DATE | FLOOR_TOKEN | µ-Tokens Volume | Collection Volume | |
|---|---|---|---|---|
1 | 2023-11-02 00:00:00.000 | μELEM | 239273.661075709 | 278027.06921401 |
2 | 2023-12-19 00:00:00.000 | μMOONBIRD | 23534.91 | 298749.290719819 |
3 | 2023-11-19 00:00:00.000 | μBAYC | 350615.99 | 662713.69087305 |
4 | 2023-12-07 00:00:00.000 | μMIL | 39598.29 | 353849.942368407 |
5 | 2024-01-20 00:00:00.000 | μBEANZ | 42192.495560817 | 162535.320794685 |
6 | 2023-11-02 00:00:00.000 | μCloneX | 20666.596027568 | 109767.33797371 |
7 | 2024-01-13 00:00:00.000 | μBAKC | 74645.14 | 302978.405844215 |
8 | 2023-12-18 00:00:00.000 | μSAPS | 1352.57 | 37104.78161756 |
9 | 2023-11-11 00:00:00.000 | μMIL | 15602.99 | 300164.255591876 |
10 | 2023-12-09 00:00:00.000 | μCloneX | 34311.49 | 270407.375046429 |
11 | 2023-12-01 00:00:00.000 | μBAYC | 505381.49 | 3601641.89851958 |
12 | 2023-11-23 00:00:00.000 | μPotatoz | 13383.06 | 55134.8751 |
13 | 2023-11-15 00:00:00.000 | μ0N1 | 3817.07 | 13866.822137 |
14 | 2023-11-26 00:00:00.000 | μGHOST | 8831.540194943 | 1920.888606 |
15 | 2023-11-24 00:00:00.000 | μMFER | 22202.33 | 88248.46463879 |
16 | 2023-12-06 00:00:00.000 | μMOONBIRD | 41277.1 | 385396.18787554 |
17 | 2024-01-18 00:00:00.000 | μ⚇ | 7753.46 | 124108.753324036 |
18 | 2023-11-02 00:00:00.000 | μMOONBIRD | 72300.883272734 | 217763.145878653 |
19 | 2024-01-19 00:00:00.000 | μCloneX | 65997.1 | 213421.958713615 |
20 | 2023-11-18 00:00:00.000 | μ⚇ | 57768.25 | 63957.524954399 |
rezarwz2024-01-30 02:49 PM
Updated 2024-01-30
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 ft as (
SELECT
DECODED_LOG:floorToken as floorToken,
DECODED_LOG:collection as collection
from
ethereum.core.ez_decoded_event_logs
where
contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'
and event_name = 'NewCollectionSupported'
),
FP as (
with trades as (
SELECT
TX_HASH,
date_trunc('day', BLOCK_TIMESTAMP) as date,
ORIGIN_FROM_ADDRESS as ua,
CASE
when TOKEN_IN in (
SELECT
DECODED_LOG:floorToken
from
ethereum.core.ez_decoded_event_logs
where
contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'
and event_name = 'NewCollectionSupported'
) then SYMBOL_IN
else SYMBOL_OUT
end as Floor_token,
CASE
when TOKEN_IN in (
SELECT
DECODED_LOG:floorToken
from
ethereum.core.ez_decoded_event_logs
where
contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'
Last run: about 1 year ago
...
2341
146KB
32s