nasdfajsklj2024-04-22 REVENUE DATA copy
Updated 2024-06-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 2024-04-22 REVENUE DATA @ https://flipsidecrypto.xyz/edit/queries/4efc9b1b-e643-4182-bd57-1a9240448d93
with data as (
select
block_timestamp::date as date
,date_trunc('week', block_timestamp)::date as week
,date_trunc('month', block_timestamp)::date as month
,'ETH' as chain
, amount_usd
, origin_to_address
from ethereum.core.ez_token_transfers
where 1=1
and to_address in ('0xc8c0e780960f954c3426a32b6ab453248d632b59', '0x77777d91c0b8ec9984a05302e4ef041dccf77fee')
and block_timestamp::date > '2024-04-05'
and origin_from_address not in ('0xc8c0e780960f954c3426a32b6ab453248d632b59', '0x77777d91c0b8ec9984a05302e4ef041dccf77fee')
UNION ALL
select
block_timestamp::date as date
,date_trunc('week', block_timestamp)::date as week
,date_trunc('month', block_timestamp)::date as month
,'BASE' as chain
, amount_usd
, origin_to_address
from base.core.ez_token_transfers
where 1=1
and to_address in ('0xc8c0e780960f954c3426a32b6ab453248d632b59', '0x77777d91c0b8ec9984a05302e4ef041dccf77fee')
and block_timestamp::date > '2024-04-05'
and origin_from_address not in ('0xc8c0e780960f954c3426a32b6ab453248d632b59', '0x77777d91c0b8ec9984a05302e4ef041dccf77fee')
UNION ALL
select
block_timestamp::date as date
,date_trunc('week', block_timestamp)::date as week
QueryRunArchived: QueryRun has been archived