forgashCopy of Untitled Query
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select block_timestamp::date as date,
txn_hash::string as txn_hash,
(parse_json(trim(args))):amount as asset_amount
(parse_json(args)):recipient as eth_address
from flipside_prod_db.mdao_near.actions_events_function_call
where action_name = 'FunctionCall'
and method_name = 'withdraw' -- ERC20 tokens
-- and (parse_json(trim(args))):amount::string is not null
-- and eth_address is not null
and date = '2022-07-01'
and args like '{"%'
limit 100
Run a query to Download Data