LTirrell2022-04-08_algo_flipside-behavior_payments
Updated 2022-04-08
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
›
⌄
with block_info as(
select
block_timestamp,
block_id
from
algorand.block
),
flipside_payments as (
select
block_timestamp,
block_id,
tx_group_id,
tx_id,
inner_tx,
sender,
receiver,
amount,
fee
from
algorand.payment_transaction
where
sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'
and amount < 10000
and asset_id = 0
),
account_info as (
select
block_info.block_timestamp,
created_at,
address,
balance
from
algorand.account
inner join block_info on created_at = block_info.block_id
)
select
Run a query to Download Data