shreexARB sat main
    Updated 2023-04-07
    WITH
    list AS (
    SELECT distinct
    event_inputs:to AS recipient
    from
    arbitrum.core.fact_event_logs
    where
    event_name = 'Transfer'
    and event_inputs:
    from
    = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
    and contract_address = '0x912ce59144191c1204e64559fe8253a0e49e6548'
    and tx_status = 'SUCCESS'
    ),
    prices as (
    select
    hour,
    price
    from
    crosschain.core.fact_hourly_prices
    where
    blockchain = 'ethereum'
    and provider = 'coingecko'
    and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    AND hour >= '2023-02-24'
    ),

    sat as (
    select
    date_trunc('week', block_timestamp) as date,
    'Satellite #From Arb' as bridge,
    --token_symbol as t,
    count(distinct tx_hash) as bridges,
    count(
    distinct event_inputs:
    from
    Run a query to Download Data