binhachon$THOR Staking Reward + APY - APY
    Updated 2022-05-21
    with vTHOR_transactions as (
    select
    block_timestamp,
    tx_hash,
    raw_amount/1e18 as vTHOR_amount
    from flipside_prod_db.ethereum_core.fact_token_transfers
    where contract_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'
    ),
    THOR_transactions as (
    select
    block_timestamp,
    tx_hash,
    raw_amount/1e18 as THOR_amount
    from flipside_prod_db.ethereum_core.fact_token_transfers
    where contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044'
    ),
    THOR_vTHOR_transactions as (
    select
    vTHOR_transactions.*,
    THOR_amount,
    THOR_amount/vTHOR_amount as "vTHOR to THOR ratio"
    from vTHOR_transactions
    inner join THOR_transactions on (vTHOR_transactions.tx_hash = THOR_transactions.tx_hash)
    ),
    daily_ratio as (
    select
    date_trunc('day', block_timestamp) as time,
    block_timestamp,
    "vTHOR to THOR ratio"
    from THOR_vTHOR_transactions
    where time >= '2022-05-05'
    qualify row_number() over (partition by time order by block_timestamp) = 1
    )
    select
    time,
    block_timestamp,
    Run a query to Download Data