JimMyersTechUntitled Query
Updated 2022-05-31
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- SELECT count(*) FROM osmosis.core.fact_blocks;
-- SELECT * FROM flipside_prod_db.ethereum_core.ez_token_transfers where origin_from_address = lower('0x4a9318f375937b56045e5a548e7e66aea61dd610');
SELECT
to_date(event_inputs['expires']) as expiration,
event_inputs['cost'] / pow(10,18) as cost
FROM flipside_prod_db.ethereum_core.fact_event_logs
WHERE
event_name = 'NameRegistered' AND
contract_address = lower('0x283af0b28c62c092c9727f1ee09c02ca627eb7f5') AND
event_inputs['name'] = 'jfm'
Run a query to Download Data