rain_syndicaCEX to Solana
    Updated 2023-12-11
    -- select
    -- a.tx_id,
    -- tx_from,
    -- block_timestamp,
    -- mint,
    -- amount,
    -- amount * close as usd_amount
    -- from solana.core.fact_transfers a
    -- inner join mayan_txs c on a.tx_id = c.tx_id
    -- left join solana.core.dim_tokens d on a.mint = d.token_address
    -- left join solana.price.fact_token_prices_hourly b
    -- on d.coin_market_cap_id = b.id
    -- and date_trunc('hour', a.block_timestamp) = b.recorded_hour
    -- where block_timestamp >= '2023-06-01'
    -- -- and tx_id in
    -- -- (
    -- -- select tx_id from mayan_txs
    -- -- )
    -- and tx_to = '5yZiE74sGLCT4uRoyeqz4iTYiUwX5uykiPRggCVih9PN'
    -- -- limit 10

    with

    inflows as (
    select
    t.tx_id::string AS tx_id,
    t.block_timestamp::datetime AS block_timestamp,
    t.tx_to::string AS user,
    t.amount::float AS amount,
    t.amount * b.close as usd_amount,
    l.project_name::string AS source
    from solana.core.fact_transfers t
    inner join crosschain.core.dim_labels l on t.tx_from = l.address
    left join solana.core.dim_tokens d on t.mint = d.token_address
    left join solana.price.fact_token_prices_hourly b
    on d.coin_market_cap_id = b.id
    Run a query to Download Data