moshuiyungetTxFirst
Updated 2023-02-09Copy 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
›
⌄
SELECT
tx.*
from
ethereum.core.fact_transactions tx,
(
SELECT
tx2.to_address,
min(tx2.block_number) as block_number
from
ethereum.core.fact_transactions tx2
where
tx2.to_address IN (
'0xa68dd8cb83097765263adad881af6eed479c4a33',
'0x9010a15184da16e3a7c5b4aa50094dfe3bb36989',
'0xd22a32c67a2dfa3a85a1ff69176f14a61fd8783a',
'0x9ba60ba98413a60db4c651d4afe5c937bbd8044b',
'0xa32eaeca2c34ab2521ab6aa3ddd37d3e0b644ded',
'0xae7ab96520de3a18e5e111b5eaab095312d7fe84',
'0xb00fddf6d66e332694e20d1a243df8fbc5e86615',
'0xb7bb0e4bf96d9b3824456b06a13a050eaeb85d83',
'0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7',
'0xc5424b857f758e906013f3555dad202e4bdb4567',
'0xde29d461591762e8b72914a142eaa0e611777656',
'0xdef1c0ded9bec7f1a1670819833240f027b25eff',
'0xe592427a0aece92de3edee1f18e0157c05861564',
'0xeb7500d6fed95db09f5221638fe983d81c30ff5f',
'0xf6b767dc6250b89b6cb557327114266223f3c37c',
'0xfa9a30350048b2bf66865ee20363067c66f67e58',
'0x99a58482bd75cbab83b27ec03ca68ff489b5788f',
'0x0000000000cbba74c365869ae50225f5596ad59c',
'0x93bab7b697c71dc71964da77eb9ece40abd8e01b',
'0x4f073667ffb675b42305a9e4ca9d1494006c1998',
'0x325337e85cda444c6474a08c835d7e05cc3c3ba5',
'0x354c85a92721bac1aa0fa68f580eb86f2453df43',
'0x399f70b65b41c6b2efbc799add1680d5b68a0f0b',
'0x4dc8a00e578a5719d6441a2c89a0283ea9d15844',
Run a query to Download Data