dweinstein33Pipeflare DAAs
Updated 2023-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select block_timestamp::date, count(distinct from_address)
from aurora.core.fact_transactions
where to_address in (lower('0x80F6CA0ccC1407Ba5E8A73B9424153527bD245B1'),
lower('0xCA879b236474Cff92eE4cfE3b872d5bBd56dBB53'),
lower('0xFb40072FA4daC2A624AEB94152BE7263CE601f22'),
lower('0x1FaD1C94E622f892a3F29796f9981D89571974c5'),
lower('0x96A97B123f15A513e49B3E908169EC6eD3Ba1Da9'),
lower('0x9b0efbB375fca4fD40D480Cc7c4D88E34592cf9f'),
lower('0x39623069A8bc1120C92B6Ab042E14C266AC79022'),
lower('0x94FE0D9Dc2c613eF40845eBf42a9859582927074'))
and block_timestamp > '2023-07-01'::date
group by 1
Run a query to Download Data