gaonipTransaction token transfers & Events
Updated 2023-12-19
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
›
⌄
## using a fact table
select
block_number, block_timestamp, tx_hash,
origin_from_address as user,
event_index as event_index_in_tx,
origin_to_address as router_contract,
contract_address as token_address,
from_address as token_from,
to_address as token_to,
raw_amount -- needs decimal adjustment!
from
ethereum.core.fact_token_transfers
where tx_hash = '0x27dc7ecdcbd53e2e1aa107803825db6348c90746f291a2c511ad30fa019854e0'
-- adding filters like this helps speed.
and block_number = 18744061
order by event_index asc
## using a EZ table
select
block_number, block_timestamp, tx_hash,
origin_from_address as user,
event_index as event_index_in_tx,
origin_to_address as router_contract,
contract_address as token_address,
symbol as token_symbol,
decimals as token_decimals,
token_price as token_price_from_hourly_close,
amount as amount_token_decimal_adjusted,
amount_usd as amount_token_priced_usd,
from_address as token_from,
to_address as token_to
from ethereum.core.ez_token_transfers
where
tx_hash = '0x27dc7ecdcbd53e2e1aa107803825db6348c90746f291a2c511ad30fa019854e0'
-- adding filters like this helps speed.
and block_number = 18744061
QueryRunArchived: QueryRun has been archived