drone-mostafatest
Updated 2022-10-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
/*select TX_ID, BLOCK_TIMESTAMP,CHAIN_ID,PROPOSER,PAYER,AUTHORIZERS,TX_SUCCEEDED
-- *
from flow.core.fact_transactions
where PAYER = '0x18eb4ee6b3c026d2' and PROPOSER = '0xe8010f01868de106'
and TX_SUCCEEDED = 'TRUE'
and BLOCK_TIMESTAMP < '2022-09-01 13:30:00.000' and BLOCK_TIMESTAMP > '2022-08-29 02:29:54.000' order by 2 DESC*/
select TX_ID, BLOCK_TIMESTAMP,CHAIN_ID,PROPOSER,PAYER,AUTHORIZERS,TX_SUCCEEDED
from flow.core.fact_transactions
where PAYER = '0x18eb4ee6b3c026d2' --and AUTHORIZERS in ( '0xe4cf4bdc1751c65d') --Allday contract
and TX_SUCCEEDED = 'TRUE'
and BLOCK_TIMESTAMP >= CURRENT_DATE -4 order by 2 DESC
Run a query to Download Data