HOUR | SYMBOL | TX_COUNT | TOKEN_AMOUNT | USD_AMOUNT | |
---|---|---|---|---|---|
1 | 2024-01-29 09:00:00.000 | ETH | 4 | 1.40796 | |
2 | 2024-01-29 08:00:00.000 | USDC | 2 | 159114.521752 | 159158.256214595 |
3 | 2024-01-29 08:00:00.000 | ETH | 129 | 52.03985836 | 117713.32 |
4 | 2024-01-29 08:00:00.000 | USDT | 4 | 15873.30297 | 15872.806357374 |
5 | 2024-01-29 08:00:00.000 | DAI | 4 | 15868.298446831 | 15870.220980272 |
6 | 2024-01-29 07:00:00.000 | ETH | 198 | 77.476658039 | 175452.73 |
7 | 2024-01-29 07:00:00.000 | USDT | 3 | 19501.304563 | 19500.392176774 |
8 | 2024-01-29 07:00:00.000 | USDC | 2 | 22612.29448 | 22617.838919448 |
9 | 2024-01-29 07:00:00.000 | DAI | 3 | 19495.163378454 | 19496.90421466 |
10 | 2024-01-29 06:00:00.000 | stETH | 3 | 10.581782911 | 23988.196332286 |
11 | 2024-01-29 06:00:00.000 | ETH | 224 | 287.4189177 | 651469.82 |
12 | 2024-01-29 06:00:00.000 | USDC | 1 | 200000 | 200018.757759556 |
13 | 2024-01-29 05:00:00.000 | USDT | 1 | 250.506789 | 250.4620176 |
14 | 2024-01-29 05:00:00.000 | DAI | 1 | 250.438531185 | 250.470512541 |
15 | 2024-01-29 05:00:00.000 | USDC | 1 | 247524.592204 | 247555.832786629 |
16 | 2024-01-29 05:00:00.000 | stETH | 3 | 7 | 15854.214654186 |
17 | 2024-01-29 05:00:00.000 | ETH | 139 | 28.549988619 | 64705.77 |
18 | 2024-01-29 04:00:00.000 | ETH | 117 | 35.011793772 | 79438.04 |
19 | 2024-01-29 04:00:00.000 | DAI | 2 | 1109.696063912 | 1109.775631447 |
20 | 2024-01-29 04:00:00.000 | stETH | 2 | 21 | 47679.291573923 |
freemartianHourly Tokens Deposited
Updated 2024-01-29
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
›
⌄
SELECT
date_trunc('hour',block_timestamp) AS hour,
'ETH' AS symbol,
COUNT(tx_hash) AS tx_count,
SUM(amount) AS token_amount,
SUM(amount_usd) AS usd_amount
FROM ethereum.core.ez_eth_transfers
WHERE eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature = '0xf6326fb3'
AND block_timestamp::date >= '2023-11-20'
AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
AND eth_from_address <> '0x0000000000000000000000000000000000000000'
GROUP BY 1,2
UNION
SELECT
date_trunc('hour',block_timestamp) AS hour,
symbol,
COUNT(tx_hash) AS tx_count,
SUM(amount) AS token_amount,
SUM(amount_usd) AS usd_amount
FROM ethereum.core.ez_token_transfers t
WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature IN ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
AND block_timestamp::date >= '2023-11-20'
AND block_timestamp < CURRENT_TIMESTAMP() - INTERVAL '2 HOUR'
AND from_address <> '0x0000000000000000000000000000000000000000'
GROUP BY 1,2
ORDER BY 1 DESC
Last run: over 1 year agoAuto-refreshes every 3 hours
...
5346
313KB
23s