BLOCK_ID | BLOCK_TIMESTAMP | TX_ID | TX_SUCCEEDED | TRANSFER_TYPE | SENDER | AMOUNT | CURRENCY | DECIMAL | RECEIVER | FOREIGN_ADDRESS | FOREIGN_CHAIN | FACT_TRANSFERS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 12898079 | 2023-12-23 03:00:09.000 | FB6030AE0D25F1589EF0DBDD10E1BE29424A8F76F73B484AF2654C76A6F3DA2C | TRUE | IBC_TRANSFER_IN | bcna1dl7w3myyfmnarh0t5uxmy7qe6szagz3ka2nq42 | 93143000000 | ibc/D805F1DA50D31B96E4282C1D4181EDDFB1A44A598BFF5666F4B43E4B8BEA95A5 | 0 | osmo1dl7w3myyfmnarh0t5uxmy7qe6szagz3k0ps3t2 | 8d34a2ce3af1e75ccebac51829136f73 | 2023-12-23 03:33:42.780 | 2023-12-24 03:33:43.944 | ||
2 | 12897992 | 2023-12-23 02:51:38.000 | DAA9E3B31E7A24CC179BD767BD71A791E8583A335F2A1A9965DA3B983470D3B6 | TRUE | IBC_TRANSFER_IN | bcna1dl7w3myyfmnarh0t5uxmy7qe6szagz3ka2nq42 | 150000000 | ibc/D805F1DA50D31B96E4282C1D4181EDDFB1A44A598BFF5666F4B43E4B8BEA95A5 | 0 | osmo1dl7w3myyfmnarh0t5uxmy7qe6szagz3k0ps3t2 | 1bdccdcfed081e1e90c5fc99d9a503f9 | 2023-12-23 03:33:42.780 | 2023-12-24 03:33:43.944 |
cptjack2024-01-26 08:23 AM
Updated 2024-01-31
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
›
⌄
select
a.sender
, a.receiver
, a.amount
, b.alias coin_alias
, b.label as coin_label
, a.block_timestamp
, b.blockchain coin_chain
, a.block_id
, a.tx_id
, a.tx_succeeded
, a.transfer_type
from osmosis.core.fact_transfers a
left join osmosis.core.dim_tokens b on b.address = a.currency
where a.sender = 'bcna1dl7w3myyfmnarh0t5uxmy7qe6szagz3ka2nq42'
select
a.sender
, a.receiver
, a.amount
, b.alias coin_alias
, b.label as coin_label
, a.block_timestamp
, b.blockchain coin_chain
, a.block_id
, a.tx_id
, a.tx_succeeded
, a.transfer_type
from osmosis.core.fact_transfers a
left join osmosis.core.dim_tokens b on b.address = a.currency
where a.sender = 'osmo1dl7w3myyfmnarh0t5uxmy7qe6szagz3k0ps3t2'
and a.block_timestamp > '2023-12-23 03:00:09.000'
Last run: about 1 year ago
2
801B
3s