dr1888Inflow amount Polygon
Updated 2023-04-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
36
›
⌄
-- forked from Inflow amount @ https://flipsidecrypto.xyz/edit/queries/89b88d15-2706-4abc-a55b-2be0326b18df
with
A AS (
SELECT
TRUNC(block_timestamp, '{{Trunc}}') AS BTD,
tx_hash,
from_address,
origin_from_address,
origin_to_address,
amount_usd
FROM polygon.core.ez_token_transfers
WHERE block_timestamp BETWEEN '{{Start_day}}' AND '{{End_day}}'
AND
from_address
in (
lower('0x29e38769f23701A2e4A8Ef0492e19dA4604Be62c'), lower('0x1205f31718499dBf1fCa446663B532Ef87481fe1')
)
)
select
BTD,
tx_hash,
origin_from_address,
amount_usd
FROM (
SELECT
BTD,
tx_hash,
origin_from_address,
amount_usd
FROM A
)
Run a query to Download Data