LTirrellsolana hack - histogram summary
    Updated 2023-01-04
    with solana_swaps AS (
    SELECT
    SWAP_PROGRAM,
    BLOCK_TIMESTAMP,
    BLOCK_ID,
    TX_ID,
    SUCCEEDED,
    SWAPPER,
    SWAP_FROM_AMOUNT,
    SWAP_FROM_MINT,
    a.address_name as from_asset,
    SWAP_TO_AMOUNT,
    SWAP_TO_MINT,
    b.address_name as to_asset,
    SWAP_TO_AMOUNT / SWAP_FROM_AMOUNT as ratio
    FROM
    solana.core.fact_swaps
    LEFT JOIN solana.core.dim_labels a ON SWAP_FROM_MINT = a.address
    LEFT JOIN solana.core.dim_labels b ON SWAP_TO_MINT = b.address
    WHERE
    SUCCEEDED = 'TRUE'
    AND block_timestamp > '2022-01-01'
    ),
    stables AS (
    SELECT
    address,
    label,
    address_name
    FROM
    solana.core.dim_labels
    WHERE
    label_subtype = 'token_contract'
    and address_name LIKE '%usd%'
    ),
    price as (
    SELECT
    Run a query to Download Data