TIME | BTC Price | Stablecoin Mint | Stablecoin Mint_ | Stablecoin Burn_ | |
|---|---|---|---|---|---|
1 | 2024-02-19 00:00:00.000 | 52029.834206854 | 1047044108 | 1428144980 | -381100872 |
2 | 2024-02-12 00:00:00.000 | 50895.244047619 | 71413110 | 1236084764 | -1164671654 |
3 | 2024-02-05 00:00:00.000 | 45056.971650152 | 955226478 | 2151495492 | -1196269014 |
4 | 2024-01-08 00:00:00.000 | 44921.195989063 | 1130692042 | 3109866020 | -1979173978 |
5 | 2024-01-01 00:00:00.000 | 43861.011904762 | 1839358854 | 3388504378 | -1549145525 |
6 | 2023-12-04 00:00:00.000 | 43190.369047619 | 17425739 | 1418781725 | -1401355986 |
7 | 2023-12-18 00:00:00.000 | 43105.895807363 | 388564394 | 1680596805 | -1292032411 |
8 | 2024-01-29 00:00:00.000 | 42793.568574572 | 759254844 | 2827883048 | -2068628204 |
9 | 2023-12-25 00:00:00.000 | 42683.456451533 | 403638489 | 2510506533 | -2106868044 |
10 | 2024-01-15 00:00:00.000 | 42115.200595703 | 254236580 | 2053187646 | -1798951066 |
11 | 2023-12-11 00:00:00.000 | 42025.869047619 | 40128078 | 1675007481 | -1634879402 |
12 | 2024-01-22 00:00:00.000 | 40626.896477876 | 201886361 | 1741949994 | -1540063633 |
13 | 2023-11-27 00:00:00.000 | 38134.160714286 | 894812571 | 2158354868 | -1263542297 |
14 | 2023-11-20 00:00:00.000 | 37307.470238095 | 253332557 | 1373762799 | -1120430242 |
15 | 2023-11-13 00:00:00.000 | 36495.851190476 | 323690716 | 1663353297 | -1339662580 |
16 | 2023-11-06 00:00:00.000 | 36143.339285714 | 654289841 | 2287254657 | -1632964816 |
17 | 2023-10-30 00:00:00.000 | 34697.241506003 | -437773658 | 1118815600 | -1556589258 |
18 | 2023-10-23 00:00:00.000 | 33706.708333333 | -336089669 | 1123974696 | -1460064365 |
19 | 2023-07-10 00:00:00.000 | 30525.101190476 | -134024977 | 1157730868 | -1291755846 |
20 | 2023-07-03 00:00:00.000 | 30522.797619048 | 164402538 | 870001616 | -705599078 |
tkvresearchStablecoin Issue I BTC copy
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: over 1 year ago
60
4KB
64s