SELECT

'Blast' as chain,

BLOCK_TIMESTAMP :: Date as date,

'WETH' as symbol,

'0x4300000000000000000000000000000000000004' as token_contract,

sum(decoded_log:amount / pow(10, 18)) as primary_asset_deps_token

FROM

blast.core.ez_decoded_event_logs

where

contract_address = lower('0x44f33bC796f7d3df55040cd3C631628B560715C2')

and event_name = 'Deposit'

AND BLOCK_TIMESTAMP :: Date BETWEEN CURRENT_DATE -1 -29

AND CURRENT_DATE -1

group by

1,

2,

3,

4

),

Orbit_Protocol as (

SELECT

'Blast' as chain,

BLOCK_TIMESTAMP :: Date as date,

'ETH' as symbol,

'0x0000000000000000000000000000000000000000' as token_contract,

sum(decoded_log:amount / pow(10, 18)) as primary_asset_deps_token

FROM

blast.core.ez_decoded_event_logs

where

contract_address = lower('0x0872b71EFC37CB8DdE22B2118De3d800427fdba0')

and event_name = 'Mint'

AND BLOCK_TIMESTAMP :: Date BETWEEN CURRENT_DATE -1 -29

AND CURRENT_DATE -1

group by

1,