HosseinUntitled Query
Updated 2022-10-29Copy Reference Fork
999
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
list as (
select tx_hash,
block_timestamp::date as day,
event_inputs:_to as receiver,
event_inputs:_from as sender,
event_inputs:_id as token_id,
event_inputs:_value as tokens_count,
contract_address
from polygon.core.fact_event_logs
where 1 = 1
and origin_function_signature in ('0x5a86c41a','0x669f5a51')
and tx_status = 'SUCCESS'
and event_inputs:_from = '0x0000000000000000000000000000000000000000'
and event_name ='TransferSingle'
and contract_address in (
('0x4670e4890bc1b76f3ae5c7660aa98e0b6668c6f3'),
('0x2d58a44d6c0a355de25761fb33a1f6269a97e2c5'),
('0x04f087e3191d7a050800a2e04cb20046d2633e35'),
('0x8264e2bad3d2f7afd72a00233b9f841fe4b388cd'),
('0xddbdb65138131dbf2d01b4a5140e1979680c90bb'),
('0xc70a7496716b3e25546901fe88215531abbd5a10'),
('0x2e90e8af4c319095942c84cfa446e1f206795517'),
('0xd8cf23bf309de778609d234bd2410b0156118c26'),
('0x3e4627665bf2e52c69be03788e664ab545f2be71'),
('0x04f7a676af597f847053b6c02ed42d02fa4046aa'),
('0x79ef499463dae3cd413d78477fa848ecbbda774b'),
('0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3'),
('0x83feea011baeb1c6d1df7d23903efad83d3c781f'),
('0x21d426e2b88fbf8b93adf0591a2d5b08d58f089f'),
('0xe4989961ebfdac3e65fcf0059c916452c77d8503'),
('0x6acb8fb82880d39c2b8446f8778a14d34ee6cfb7'),
('0xbfd670667053e517a97afe56c91e4f83f1160bd3'),
('0xb9c042c3275bc49799688eea1a29b1405d02946b'),
('0x91e51b92a2efea89bf1b6f66ad719737264724be'),
('0xd6261320f49d38c137f6e229a2ea4ab0f4fae6de'),
Run a query to Download Data