primo_database_schema
Updated 2023-08-28
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
›
⌄
⌄
SELECT 'Flipside' as provider, (lower(table_catalog) || '.' || lower(table_schema) || '.' || lower(table_name)) AS table_name
FROM base.information_schema.tables
WHERE lower(table_schema) in ('defi', 'core','nft')
select count(1) ct from base.core.ez_nft_transfers;
select * from base.core.ez_nft_transfers limit 10;
select count(1) ct from base.core.fact_traces;
select * from base.core.fact_traces limit 10 ;
select count(1) ct from base.defi.ez_dex_swaps
select * from base.defi.ez_dex_swaps limit 10
select count(1) ct from base.core.fact_event_logs
select * from base.core.fact_event_logs limit 10
select count(1) ct from base.core.fact_token_transfers
select * from base.core.fact_token_transfers limit 10
select count(1) ct from base.nft.ez_nft_sales
select * from base.nft.ez_nft_sales limit 10
select count(1) ct from base.core.dim_contracts
select * from base.core.dim_contracts limit 10
select count(1) ct from base.core.dim_labels
select * from base.core.dim_labels limit 10
select count(1) ct from base.core.fact_decoded_event_logs
select * from base.core.fact_decoded_event_logs limit 10
select count(1) ct from base.defi.dim_dex_liquidity_pools
select * from base.defi.dim_dex_liquidity_pools limit 10
select count(1) ct from base.core.ez_decoded_event_logs
Run a query to Download Data