banterlyticstest query
Updated 2024-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- select * from polygon.core.fact_transactions
-- where FROM_ADDRESS = lower('0xC5D1A1954D3c9459338Bdd52e74754dC049CBEbC')
-- and TO_ADDRESS = lower('0x7cBCCC4a1576d7A05eB6f6286206596BCBee14aC')
-- and ORIGIN_FUNCTION_SIGNATURE <> lower('0xa22cb465')
-- select * from polygon.core.fact_event_logs
-- where BLOCK_TIMESTAMP > '2024-02-22'
-- and CONTRACT_ADDRESS = lower('0x7cBCCC4a1576d7A05eB6f6286206596BCBee14aC')
-- and TX_HASH = lower('0xdb5368ee0e2ed6e6d3b058a490fb63e7fdbc31ac6a71be9d86dbca8a4032a513')
select * from polygon.nft.ez_nft_transfers
WHERE NFT_ADDRESS = lower('0xaB8Eee3493a55a7bd8126865fD662B7097928088')
and NFT_TO_ADDRESS = lower('0xFdc3E8eDd74A90fe971EF7d56a0C66c870b10F5D')
where
QueryRunArchived: QueryRun has been archived