scottincryptoUntitled Query
Updated 2022-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- select
-- 'Swaps' as name
-- , count(*)
-- from polygon.core.fact_event_logs
-- where contract_address = '0xba12222222228d8ba445958a75a0704d566bf2c8' -- Balancer V2 Vault
-- and date_trunc('day', block_timestamp) = '2022-12-09'
-- and event_name = 'Swap'
-- union all
-- select
-- 'Topics' as name
-- , count(*)
-- from polygon.core.fact_event_logs
-- where contract_address = '0xba12222222228d8ba445958a75a0704d566bf2c8' -- Balancer V2 Vault
-- and date_trunc('day', block_timestamp) = '2022-12-09'
-- and topics[0] = '0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b'
select
*
from polygon.core.fact_event_logs
where tx_hash = '0xe872fee63f2eec576afa8a638afb19d52749ac3882235143a9a0516d3a781109'
and block_timestamp >= '2022-12-09'
and event_name = 'Swap'
Run a query to Download Data