sriniFlow contract specific exploration
Updated 2022-12-13
99
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
›
⌄
-- select date_trunc('month', block_timestamp), count(distinct tx_id)/100000
-- -- select *
-- from flow.core.fact_events evt
-- -- left join flow.core.fact_transactions tx
-- -- on evt.tx_id = tx.tx_id
-- where block_timestamp >= '2022-10-01'
-- and block_timestamp < '2022-12-01'
-- and tx_succeeded = True
-- and event_contract = 'A.87ca73a41bb50ad5.Golazos'
-- group by 1
-- with events AS (
-- SELECT block_timestamp, tx_id, event_contract
-- FROM flow.CORE.FACT_EVENTS
-- WHERE block_timestamp >= '2022-11-01'
-- AND block_timestamp < '2022-12-01'
-- AND tx_succeeded = True
-- and event_contract = 'A.c1e4f4f4c4257510.TopShotMarketV3'
-- ),
-- transactions AS (
-- SELECT tx_id, instr.value as authorizer
-- FROM flow.CORE.FACT_TRANSACTIONS,
-- LATERAL flatten(input => authorizers) instr
-- WHERE block_timestamp >= '2022-11-01'
-- AND block_timestamp < '2022-12-01')
-- select date_trunc('month', block_timestamp), count(distinct authorizer)
-- from events ev
-- left join transactions tx
-- on ev.tx_id = tx.tx_id
-- group by 1
select count(distinct tx_id)
from flow.core.fact_transactions
WHERE block_timestamp >= '2022-11-01'
Run a query to Download Data