glxyresearchmultiple-azure
Updated 2024-08-23
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
›
⌄
(SELECT
LOWER(FROM_ADDRESS) as FROM_ADDRESS,
LOWER(TO_ADDRESS) as TO_ADDRESS,
AMOUNT,
AMOUNT_USD,
BLOCK_NUMBER,
BLOCK_TIMESTAMP,
NULL as CONTRACT_ADDRESS,
LOWER(TX_HASH) as TX_HASH,
NULL as DECIMALS,
'AVAX' as SYMBOL,
(AMOUNT_USD/ AMOUNT) as TOKEN_PRICE,
'AVAX' as EXECUTION_LAYER,
'2024-09-20 19:17:04.149744' as QUERY_TIME,
'6097d425-3ab6-4040-9984-4415ec842194' as QUERY_ID,
('0x7902909f35663618f3631a0b79af6e372b042817', '0xa35056d562874c8c24e2a7d4b1690c30b19b3e7e', '0x4165ccb2ab09ac00bb40c66fb296baca183f899f', '0x077d339994b712e1b1a4035fe3524d6d6602a5fd', '0x37f3d708ea6eeae8fd7c7f4d7e371a6e82a45a05', '0x543b8699b6590ac16a394de1eb1bb87e3ac84124', '0xc70b5e90bea219f16c4047fc15c81ee1c162fc54', '0xf3717340a1797e8a84356c349bc3f69526979150', '0x03b943acc131713253199f6b5f99504f7dd6cfcb', '0xc349417c08873b072f88527ecd90d3aba0ca15fb') as ADDRESSES
FROM
avalanche.core.ez_native_transfers
WHERE
(
FROM_ADDRESS IN ('0x7902909f35663618f3631a0b79af6e372b042817', '0xa35056d562874c8c24e2a7d4b1690c30b19b3e7e', '0x4165ccb2ab09ac00bb40c66fb296baca183f899f', '0x077d339994b712e1b1a4035fe3524d6d6602a5fd', '0x37f3d708ea6eeae8fd7c7f4d7e371a6e82a45a05', '0x543b8699b6590ac16a394de1eb1bb87e3ac84124', '0xc70b5e90bea219f16c4047fc15c81ee1c162fc54', '0xf3717340a1797e8a84356c349bc3f69526979150', '0x03b943acc131713253199f6b5f99504f7dd6cfcb', '0xc349417c08873b072f88527ecd90d3aba0ca15fb')
OR
TO_ADDRESS IN ('0x7902909f35663618f3631a0b79af6e372b042817', '0xa35056d562874c8c24e2a7d4b1690c30b19b3e7e', '0x4165ccb2ab09ac00bb40c66fb296baca183f899f', '0x077d339994b712e1b1a4035fe3524d6d6602a5fd', '0x37f3d708ea6eeae8fd7c7f4d7e371a6e82a45a05', '0x543b8699b6590ac16a394de1eb1bb87e3ac84124', '0xc70b5e90bea219f16c4047fc15c81ee1c162fc54', '0xf3717340a1797e8a84356c349bc3f69526979150', '0x03b943acc131713253199f6b5f99504f7dd6cfcb', '0xc349417c08873b072f88527ecd90d3aba0ca15fb')
)
AND
BLOCK_TIMESTAMP > CAST('2000-01-01 01:00:00.000' AS datetime)
AND
BLOCK_TIMESTAMP <= CAST('2022-09-21 19:15:52.804085' AS datetime)
)
UNION ALL
(SELECT
LOWER(FROM_ADDRESS) as FROM_ADDRESS,
LOWER(TO_ADDRESS) as TO_ADDRESS,
AMOUNT,
AMOUNT_USD,
BLOCK_NUMBER,
QueryRunArchived: QueryRun has been archived