DAY | CHAIN | WEEK | AMOUNT_NET | AMOUNTS | |
|---|---|---|---|---|---|
1 | 2024-02-21 00:00:00.000 | USDT [ether] | 2024-02-19 00:00:00.000 | 0 | 45210018006 |
2 | 2024-02-21 00:00:00.000 | USDT [avax] | 2024-02-19 00:00:00.000 | 0 | 847238621 |
3 | 2024-02-21 00:00:00.000 | USDT [arb] | 2024-02-19 00:00:00.000 | 522736 | 1659383101 |
4 | 2024-02-21 00:00:00.000 | USDC [poly] | 2024-02-19 00:00:00.000 | 250762 | 193930497 |
5 | 2024-02-21 00:00:00.000 | USDC [op] | 2024-02-19 00:00:00.000 | 140114 | 66269593 |
6 | 2024-02-21 00:00:00.000 | USDC [ether] | 2024-02-19 00:00:00.000 | 16423179 | 24392126688 |
7 | 2024-02-21 00:00:00.000 | USDC [base] | 2024-02-19 00:00:00.000 | 645687 | 219957870 |
8 | 2024-02-21 00:00:00.000 | USDC [avax] | 2024-02-19 00:00:00.000 | -372402 | 228070546 |
9 | 2024-02-21 00:00:00.000 | USDC [arb] | 2024-02-19 00:00:00.000 | -738467 | 940632920 |
10 | 2024-02-20 00:00:00.000 | USDT [ether] | 2024-02-19 00:00:00.000 | 1000000000 | 45210018006 |
11 | 2024-02-20 00:00:00.000 | USDT [avax] | 2024-02-19 00:00:00.000 | 0 | 847238621 |
12 | 2024-02-20 00:00:00.000 | USDT [arb] | 2024-02-19 00:00:00.000 | 11367656 | 1658860365 |
13 | 2024-02-20 00:00:00.000 | USDC [poly] | 2024-02-19 00:00:00.000 | 1970964 | 193679735 |
14 | 2024-02-20 00:00:00.000 | USDC [op] | 2024-02-19 00:00:00.000 | 1056095 | 66129479 |
15 | 2024-02-20 00:00:00.000 | USDC [ether] | 2024-02-19 00:00:00.000 | -15236807 | 24375703509 |
16 | 2024-02-20 00:00:00.000 | USDC [base] | 2024-02-19 00:00:00.000 | 1773407 | 219312183 |
17 | 2024-02-20 00:00:00.000 | USDC [avax] | 2024-02-19 00:00:00.000 | 1984661 | 228442948 |
18 | 2024-02-20 00:00:00.000 | USDC [arb] | 2024-02-19 00:00:00.000 | 5840670 | 941371387 |
19 | 2024-02-19 00:00:00.000 | USDT [ether] | 2024-02-19 00:00:00.000 | 0 | 44210018006 |
20 | 2024-02-19 00:00:00.000 | USDT [avax] | 2024-02-19 00:00:00.000 | 0 | 847238621 |
tkvresearchUSDC vs. USDT I Daily
Updated 2024-02-21
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
›
⌄
with
L AS ( select * from (VALUES
( 'Ethereum' , 'ether', 'Circle','USDC', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','0x0000000000000000000000000000000000000000'),
( 'Avalanche' , 'avax', 'Circle','USDC', '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0x0000000000000000000000000000000000000000'),
( 'Arbitrum' , 'arb' , 'Circle','USDC', '0xaf88d065e77c8cc2239327c5edb3a432268e5831','0x0000000000000000000000000000000000000000'),
( 'Optimism' , 'op' , 'Circle','USDC', '0x0b2C639c533813f4Aa9D7837CAf62653d097Ff85','0x0000000000000000000000000000000000000000'),
( 'Base' , 'base', 'Circle','USDC', '0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913','0x0000000000000000000000000000000000000000'),
( 'Polygon' , 'poly', 'Circle','USDC', '0x3c499c542cef5e3811e1192ce70d8cc03d5c3359','0x0000000000000000000000000000000000000000'),
( 'Avalanche' , 'avax', 'Tether','USDT', '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','0x0000000000000000000000000000000000000000'),
( 'Polygon' , 'poly', 'Tether','USDT', '0x170a18b9190669cda08965562745a323c907e5ec','0x0000000000000000000000000000000000000000'),
( 'Arbitrum' , 'arb' , 'Tether','USDT', '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9','0x0000000000000000000000000000000000000000')
) as l1(chain, chain_short, tag, symbol, contract, mint) ),
A as(
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from ethereum.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from ethereum.core.fact_token_transfers union all
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from base.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from base.core.fact_token_transfers union all
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from avalanche.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from avalanche.core.fact_token_transfers union all
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from polygon.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from polygon.core.fact_token_transfers union all
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from optimism.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from optimism.core.fact_token_transfers union all
select 'mint' as action, raw_amount as amount, contract_address, from_address as mint, to_address as entity, block_timestamp from arbitrum.core.fact_token_transfers union all
select 'burn' as action, 0 - raw_amount as amount, contract_address, to_address as mint, from_address as entity, block_timestamp from arbitrum.core.fact_token_transfers
),
AB as( select block_timestamp, symbol, chain, chain_short, contract_address, action, amount/1e6 as amount
Last run: about 1 year ago
...
2673
219KB
121s