TXN_DATE | Asset and Contributor | ADDRESS | SYMBOL | AMOUNT | USD Value | |
|---|---|---|---|---|---|---|
1 | 2024-10-26 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.480849504 |
2 | 2024-10-26 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.191907064 |
3 | 2024-10-27 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.561699488 |
4 | 2024-10-27 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.199073875 |
5 | 2024-10-28 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.666699467 |
6 | 2024-10-28 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.199274053 |
7 | 2024-10-29 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.679149464 |
8 | 2024-10-29 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.198933091 |
9 | 2024-10-30 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.702699459 |
10 | 2024-10-30 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.199758 |
11 | 2024-10-31 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.629949474 |
12 | 2024-10-31 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.199441235 |
13 | 2024-11-01 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.536949493 |
14 | 2024-11-01 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.201957758 |
15 | 2024-11-01 00:00:00.000 | ETH - GSR | DEQAtFnQYmmVgguovNNpk6NCwiumdxxnJ1dmwWT8FgMN | ETH | 0.01 | 25.1511 |
16 | 2024-11-01 00:00:00.000 | tETH - GSR | DEQAtFnQYmmVgguovNNpk6NCwiumdxxnJ1dmwWT8FgMN | tETH | 0 | 0 |
17 | 2024-11-02 00:00:00.000 | SOL - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | SOL | 0.014999997 | 2.484299503 |
18 | 2024-11-02 00:00:00.000 | USDC - Amber | BnYzZkwqb2f5kzXVdv2MnNTLeAC4NMzVMbKKbqvMFtuJ | USDC | 2.199758 | 2.1997558 |
19 | 2024-11-02 00:00:00.000 | ETH - GSR | DEQAtFnQYmmVgguovNNpk6NCwiumdxxnJ1dmwWT8FgMN | ETH | 0.01 | 25.0996 |
20 | 2024-11-02 00:00:00.000 | tETH - GSR | DEQAtFnQYmmVgguovNNpk6NCwiumdxxnJ1dmwWT8FgMN | tETH | 0 | 0 |
Flipside ConceptsContributor Locked Tokens Over Time
Updated 2025-04-11
999
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 prices as (
(select
HOUR,
case
when TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'Eth1111111111111111111111111111111111111111'
when TOKEN_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'
when TOKEN_ADDRESS = 'gu7ns9xcwgnpiadj69iusfrrfawjddpjembovhv1d4kn' then 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'
when TOKEN_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'
when TOKEN_ADDRESS = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' then '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji'
when TOKEN_ADDRESS = '0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88' then 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'
when TOKEN_ADDRESS = 'So11111111111111111111111111111111111111112' then 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'
when TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' then '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'
when TOKEN_ADDRESS = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' then '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'
when TOKEN_ADDRESS = 'ezSoL6fY1PVdJcJsUpe5CM3xkfmy3zoVCABybm5WtiC' then 'Fu5P5ikrnQ8BKZECJ1XeeDAaTgWJUrcjw8JmFrNA8TJk'
when TOKEN_ADDRESS = 'kySo1nETpsZE2NWe5vj2C64mPSciH1SppmHb4XieQ7B' then '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP'
when TOKEN_ADDRESS = '0x04c154b66cb340f3ae24111cc767e0184ed00cc6' then '6AjQBsySS1FtQmA7a4oYc6GYpHBTDqtSswptsVSTz3Tv'
when TOKEN_ADDRESS = 'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9' then 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'
when TOKEN_ADDRESS = 'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877' then '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'
when TOKEN_ADDRESS = 'hgd4dc6qycj3uanmdiuc4qanheetsavk6dy91b3f8gnl' then 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
when TOKEN_ADDRESS = 'laihkxa47apns599tyeyasy2refezbne4heunanhsmx' then 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx'
end as token_address_on_eclipse,
case
when SYMBOL = 'WETH' then 'ETH'
when SYMBOL = 'TETH' then 'tETH'
when SYMBOL = 'WEETHS' then 'weETHs'
when SYMBOL = 'STTIA' then 'stTIA'
when SYMBOL = 'KYSOL' then 'kySOL'
when SYMBOL = 'EZSOL' then 'ezSOL'
when SYMBOL = 'PXETH' then 'apxETH'
else symbol end as token_symbol,
PRICE
from crosschain.price.ez_prices_hourly
where TOKEN_ADDRESS in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm','So11111111111111111111111111111111111111112',
'0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88','0x2260fac5e5542a773aa44fbcfedf7c193bc2c599','0xdac17f958d2ee523a2206206994597c13d831ec7','orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE',
'ezSoL6fY1PVdJcJsUpe5CM3xkfmy3zoVCABybm5WtiC','kySo1nETpsZE2NWe5vj2C64mPSciH1SppmHb4XieQ7B','0x04c154b66cb340f3ae24111cc767e0184ed00cc6', 'gu7ns9xcwgnpiadj69iusfrrfawjddpjembovhv1d4kn',
'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9', 'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877','hgd4dc6qycj3uanmdiuc4qanheetsavk6dy91b3f8gnl',
Last run: 16 days agoAuto-refreshes every 1 hour
...
1454
177KB
24s