DAY | CHAIN | AMOUNT_NET | |
|---|---|---|---|
1 | 2024-02-21 00:00:00.000 | Polygon | 250762 |
2 | 2024-02-21 00:00:00.000 | Optimism | 140114 |
3 | 2024-02-21 00:00:00.000 | Ethereum | 16423179 |
4 | 2024-02-21 00:00:00.000 | Base | 645687 |
5 | 2024-02-21 00:00:00.000 | Avalanche | -372402 |
6 | 2024-02-21 00:00:00.000 | Arbitrum | -215731 |
7 | 2024-02-20 00:00:00.000 | Polygon | 1970964 |
8 | 2024-02-20 00:00:00.000 | Optimism | 1056095 |
9 | 2024-02-20 00:00:00.000 | Ethereum | 984763193 |
10 | 2024-02-20 00:00:00.000 | Base | 1773407 |
11 | 2024-02-20 00:00:00.000 | Avalanche | 1984661 |
12 | 2024-02-20 00:00:00.000 | Arbitrum | 17208325 |
13 | 2024-02-19 00:00:00.000 | Polygon | 165581 |
14 | 2024-02-19 00:00:00.000 | Optimism | -674947 |
15 | 2024-02-19 00:00:00.000 | Ethereum | 14605398 |
16 | 2024-02-19 00:00:00.000 | Base | -284572 |
17 | 2024-02-19 00:00:00.000 | Avalanche | -3191455 |
18 | 2024-02-19 00:00:00.000 | Arbitrum | 17504767 |
19 | 2024-02-18 00:00:00.000 | Polygon | -1768086 |
20 | 2024-02-18 00:00:00.000 | Optimism | -452823 |
tkvresearchStablecoin Issue I Mint Burn
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', 'Circle','USDC', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','0x0000000000000000000000000000000000000000'),
( 'Avalanche' , 'Circle','USDC', '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0x0000000000000000000000000000000000000000'),
( 'Arbitrum' , 'Circle','USDC', '0xaf88d065e77c8cc2239327c5edb3a432268e5831','0x0000000000000000000000000000000000000000'),
( 'Optimism' , 'Circle','USDC', '0x0b2C639c533813f4Aa9D7837CAf62653d097Ff85','0x0000000000000000000000000000000000000000'),
( 'Base' , 'Circle','USDC', '0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913','0x0000000000000000000000000000000000000000'),
( 'Polygon' , 'Circle','USDC', '0x3c499c542cef5e3811e1192ce70d8cc03d5c3359','0x0000000000000000000000000000000000000000'),
( 'Avalanche' , 'Tether','USDT', '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7','0x0000000000000000000000000000000000000000'),
( 'Polygon' , 'Tether','USDT', '0x170a18b9190669cda08965562745a323c907e5ec','0x0000000000000000000000000000000000000000'),
( 'Arbitrum' , 'Tether','USDT', '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9','0x0000000000000000000000000000000000000000')
) as l1(chain, 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, contract_address, action, amount/1e6 as amount
Last run: about 1 year ago
...
1395
64KB
56s