elsinaUntitled Query
Updated 2022-07-16
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 users_first_tx as (
-- select address, project_name
-- from flipside_prod_db.polygon.transactions
-- ), data_with_rank as (
-- select
-- origin_address as addr,
-- row_number() OVER (
-- PARTITION BY addr
-- ORDER BY block_timestamp asc
-- ) as "rank",
-- tx_id
-- from flipside_prod_db.polygon.udm_events, addr
-- where address = contract_address and event_name = 'transfer'
-- )
-- select * from data_with_rank
-- where "rank" = 1
-- with first_tx as (
-- select TX_ID,FROM_ADDRESS from flipside_prod_db.polygon.transactions where nonce=0
-- ),nft_collection_info as (
-- select address, project_name
-- from polygon.core.dim_labels
-- where label_type ilike '%nft%'
-- )
-- select origin_address as addr, ROW_NUMBER() OVER (PARTITION BY addr ORDER BY block_timestamp asc)
-- from flipside_prod_db.polygon.udm_events , nft_collection_info , first_tx
-- where address = contract_address and event_name = 'transfer'
-- group by 1
select * from flipside_prod_db.polygon.transactions
where tx_id = lower('0xff6e1f997397d999be641c074761a0ac46fd2d1c6e8cbe4316e8eeb3e15bbcf7')
Run a query to Download Data