steven-sabol-dir-of-economyweth-token-price
Updated 2023-01-10
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
›
⌄
SELECT * FROM ethereum.core.fact_hourly_token_prices
-- ethereum.core.fact_transactions
-- ethereum.core.fact_token_transfers
-- ethereum.core.ez_eth_transfers
-- where TO_ADDRESS='0xa24d0092e32dcd6438fcf26aec7019e41307eb10'
-- where TO_ADDRESS = '0x7a47f7707c4b2f2b1def04a47cd8681d48eadeb8'
-- IlluviumCorePool_evt_Unstaked"
where TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
-- WHERE symbol LIKE '%sILV2%'
-- address which recieved nft land
-- to_address ='0xd24754a7d9f20726abedcd36ea26c5ef6b5bf7bc'
-- 2022-06-05 04:52:55.000
-- 0xf9ec6a57e8152a45c3a811105b6f7715ddf0518320ec78626d6f9ef709428f41
-- DISTINCT contract_address
-- and block_timestamp::DATE >= CURRENT_DATE - 15
-- Select * From ethereum.core.ez_nft_transfers
-- WHERE project_name = 'Illuvium Promo NFTs'
-- Where
-- --
--
Run a query to Download Data