SQL and on-chain data part 3

JeffersSQL and on-chain data part 3

Updated 2025-03-03

-- native transfers

-- with raw as

-- (

-- select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- amount

-- from ethereum.core.ez_native_transfers

-- where to_address = lower('0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045')

-- and block_timestamp :: date >= '2024-01-01'

-- )

-- select date_trunc('month', block_timestamp) as monthly, sum(amount)

-- from raw

-- group by monthly

-- token transfers

-- with raw as

-- (

-- select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- contract_address,

-- symbol,

-- amount,

-- origin_function_signature

-- from ethereum.core.ez_token_transfers

-- where block_timestamp :: date >= '2024-08-01'

-- and contract_address in (lower('0xdAC17F958D2ee523a2206206994597C13D831ec7'), lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'))

Last run: about 2 months ago

	NFT_TO_ADDRESS	HOLDINGS
1	0x0fb3fda2c3f062c58448aa042bd0df60662f4cf2	1
2	0xe04591ecdcbb33faa1d9bb4c2ad16d725a13d414	1
3	0xd60a3fa4af14364ea71f5bbd35f0e82b0ea0c5c3	1
4	0xbf5db9f54583cb6cba4f1fb37dd53ae4463e47b4	2
5	0xf43cfd2427e0bccb77f26a5f409fc1d3b7e3d3e7	5
6	0x7ba5f40c894fbf45a9080a6ad2b541a51867c4be	1
7	0x88c10f82cbbb803329cf16fe9e0795223e02085d	1
8	0x52c946c93798e3a47a7888164dbc0375d081f720	1
9	0xc20683b99dab48c98fabff86f9d69d653f5a874f	1
10	0x1a2a60454c34e1376354891158a65553da09e7ed	1
11	0x2059a96525c364560a806ca035a40c9f379ebca9	2
12	0xf29ba6e59378bfcd1ff433ce2389ecce8d167d87	3
13	0x441f9fbda9cea889a6924a1b32c51d7129516fce	1
14	0x9eaec4d4296d3cd7c59847cdbf5c28c2c0ad0bc3	2
15	0x89501def1f0261804483e973a53c18e455f36aaf	1
16	0x553a96c13b67d500182bb6ab46d53a2edfb22706	3
17	0x66c1f899ee868079dde5d74794f3c40925776547	2
18	0x93ad041a58e35d534ee266a2f32d3e5ceaf45da2	1
19	0xc6e50f2443d6c1e627de9364cf1e3b97586038f4	1
20	0xed364a341b8a0cad3e8edef2dab3df7b3ca4ebbb	1

...

4946

237KB

flipside