mrwildcatrabby subsidies on uniswap v1
Updated 2024-07-28
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 subsidy_transactions AS (
SELECT
'optimism' AS chain,
AMOUNT_USD AS subsidy_amount,
BLOCK_TIMESTAMP AS subsidy_timestamp,
TO_ADDRESS AS subsidized_address,
TX_HASH AS subsidy_tx_hash
FROM optimism.core.ez_native_transfers
WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
AND BLOCK_TIMESTAMP::date >= '2024-03-01'
UNION ALL
SELECT
'arbitrum' AS chain,
AMOUNT_USD AS subsidy_amount,
BLOCK_TIMESTAMP AS subsidy_timestamp,
TO_ADDRESS AS subsidized_address,
TX_HASH AS subsidy_tx_hash
FROM arbitrum.core.ez_native_transfers
WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
AND BLOCK_TIMESTAMP::date >= '2024-03-01'
UNION ALL
SELECT
'polygon' AS chain,
AMOUNT_USD AS subsidy_amount,
BLOCK_TIMESTAMP AS subsidy_timestamp,
TO_ADDRESS AS subsidized_address,
TX_HASH AS subsidy_tx_hash
FROM polygon.core.ez_native_transfers
WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
AND BLOCK_TIMESTAMP::date >= '2024-03-01'
UNION ALL