higeUntitled Query
Updated 2022-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- -- select min(block_timestamp),max(block_timestamp)
-- -- from polygon.core.fact_token_transfers
-- select * from polygon.core.fact_token_transfers
-- where block_number between 35101597 and 35101608
-- order by block_number
-- select min(block_timestamp),max(block_timestamp) from
-- avalanche.core.fact_transactions
-- select * from
-- polygon.core.fact_transactions
-- where tx_hash='0xf9abf812fd59841d46d7e85b59f58a43f4a04a53b50116fee53c70abe35def4c'
-- and block_timestamp between timestamp'2022-11-01' and timestamp'2022-11-26'
-- select DISTINCT date(block_timestamp) from avalanche.core.fact_transactions
-- where date(block_timestamp) between '2020-01-01' and '2021-01-01'
-- order by date(block_timestamp)
select * from bsc.core.fact_token_transfers
where contract_address='0x3d24c45565834377b59fceaa6864d6c25144ad6c'
and block_timestamp BETWEEN '2022-12-19' and '2022-12-23'
order by block_timestamp desc
Run a query to Download Data