Solana

-- Pull fundamental network activity data for Solana
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    price
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze Solana fee components
SELECT
    date,
    chain_fees,
    base_fee,
    vote_tx_fee,
    priority_fee,
    burned_fee_allocation,
    validator_fee_allocation
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Track Solana fee distribution before and after fee changes
SELECT
    date,
    IFF(date < '2025-02-13', 'Before SIMD 0096', 'After SIMD 0096') as fee_regime,
    fees,
    validator_fee_allocation,
    burned_fee_allocation,
    validator_fee_allocation / fees as validator_share,
    burned_fee_allocation / fees as burned_share
FROM
    art_share.solana.ez_metrics
WHERE
    date BETWEEN '2025-01-01' AND '2025-03-31'
ORDER BY
    date ASC

-- Track Solana staking metrics
SELECT
    date,
    total_staked,
    total_staked_native,
    total_staked / market_cap as stake_ratio,
    price
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze different volume sources on Solana
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    chain_nft_trading_volume,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_volume,
    stablecoin_transfer_volume
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

-- Track stablecoin usage on Solana
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_transfer_volume,
    stablecoin_dau,
    stablecoin_txns,
    p2p_stablecoin_transfer_volume,
    artemis_stablecoin_transfer_volume
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze different user types on Solana
SELECT
    date,
    chain_dau,
    returning_users,
    new_users,
    sybil_users,
    non_sybil_users,
    -- Note: low_sleep_users and high_sleep_users are deprecated metrics
    low_sleep_users,
    high_sleep_users
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze metrics for specific applications on Solana
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.solana.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('jupiter', 'magic-eden', 'raydium')
ORDER BY
    app, date ASC

-- Track developer activity on Solana
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC