SYSTEM_CREATED_AT | BLOCKCHAIN | ADDRESS | ADDRESS_NAME | PROJECT_NAME | LABEL_TYPE | LABEL_SUBTYPE | L1_LABEL | L2_LABEL | CREATOR | DIM_ADDRESS_LABELS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2023-05-04 20:31:52.000 | near | metapool.sputnik-dao.near | metapool dao | metapool | dapp | dao | dapp | dao | flipside | 36413f21cfc8a3ff1086d53f0d37eb47 | 2024-01-31 19:58:03.821 | 2024-01-31 19:58:03.821 |
2 | 2022-12-01 15:53:20.000 | near | operator.meta-pool.near | metapool operator | metapool | defi | chadmin | defi | chadmin | flipside | 858597ec7887864e5b9e635007a5ae23 | 2024-01-31 19:58:03.821 | 2024-01-31 19:58:03.821 |
3 | 2022-12-01 15:53:20.000 | near | treasury.meta-pool.near | metapool treasury address | metapool | defi | treasury | defi | treasury | flipside | e520fb4dbfda74f85f7c9b98a0ca18dd | 2024-01-31 19:58:03.821 | 2024-01-31 19:58:03.821 |
0xblid2024-02-05 07:25 PM
Updated 2024-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT *
FROM near.core.dim_address_labels
WHERE PROJECT_NAME = 'metapool'
LIMIT 100
SELECT *
FROM near.core.fact_transactions
WHERE TX_RECEIVER = 'meta-pool.near' OR
TX_SIGNER = 'meta-pool.near'
--WHERE PROJECT_NAME = 'metapool'
--AND block_timestamp > '2022-01-01'
LIMIT 100
Last run: about 1 year ago
3
672B
1s