Sandeshpoly
Updated 2022-10-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select block_timestamp::date as "date",count(tx_hash) as t,
case when nonce <3 then 'first'
else 'later'
end as a
from polygon.core.fact_transactions
where to_address in
('0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6',
'0xc35DADB65012eC5796536bD9864eD8773aBc74C4',
'0x93395129bd3fcf49d95730D3C2737c17990fF328',
'0x2f686751b19a9d91cc3d57d90150Bc767f050066',
'0xCaAbdD9Cf4b61813D4a52f980d6BC1B713FE66F5',
'0xaB235da7f52d35fb4551AfBa11BFB56e18774A65',
lower('0x1b02da8cb0d097eb8d57a175b88c7d8b47997506'),
'0x4ab2fc6e258a0ca7175d05ff10c5cf798a672cae',
'0x0689640d190b10765f09310fcfe9c670ede4e25b'
)
group by 1,3
-- and nonce < 3
Run a query to Download Data