SELECT * FROM solana.core.fact_token_balances WHERE SUCCEEDED = TRUE AND ACCOUNT_ADDRESS = '33XYEz2akV9zQizGC4MwteyRYqj5Vqf6F8UA3gEqeiJ6' AND BLOCK_TIMESTAMP <= '2023-01-01 00:00:14' ORDER BY BLOCK_TIMESTAMP DESC LIMIT 10; SELECT sum(amount) FROM sei.core.fact_transfers WHERE sender = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw'; 8812396995100 8812396974100 165318 SELECT sum(amount) FROM sei.core.fact_transfers WHERE RECEIVER = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw'; SELECT * FROM sei.core.fact_transactions WHERE tx_from = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw'; select * from flow.core.ez_token_transfers limit 10; SELECT token_contract, SUM(amount) FROM flow.core.ez_token_transfers WHERE sender = '0x6a7457b796dee457' and TX_SUCCEEDED = TRUE GROUP BY token_contract LIMIT 10; 246496078.231398 SELECT token_contract, SUM(amount) FROM flow.core.ez_token_transfers WHERE RECIPIENT = '0x6a7457b796dee457' and TX_SUCCEEDED = TRUE GROUP BY token_contract LIMIT 10; 264179271.554956 select * from flow.core.fact_transactions limit 10; select sum(GAS_LIMIT) from flow.core.fact_transactions where payer = '0x6a7457b796dee457' and TX_SUCCEEDED = TRUE limit 10; select * from sei.core.fact_transfers limit 10; SELECT sum(amount) FROM sei.core.fact_transfers WHERE receiver = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84';636437706268215 SELECT sum(amount) FROM sei.core.fact_transfers WHERE sender = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84'; 597936761463600 SELECT amount from sei.core.fact_transfers where receiver = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw'; --- SELECT sum(amount) from sei.core.fact_transfers where receiver = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and currency = 'usei' and block_id <= 48970915;8812396995100 SELECT sum(amount) from sei.core.fact_transfers where sender = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and currency = 'usei' and block_id <= 48970915; 999000 SELECT * from sei.core.fact_transactions where tx_from = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' limit 10; 1000 SELECT 8812396995100 - 999000 - 1000; end of 2023 - 8812395.995100 8812397.9941 8,812,395,995,100 SELECT SUM(TO_NUMBER(REGEXP_REPLACE(fee, '[^0-9]', ''))) AS total_amount from sei.core.fact_transactions where tx_from = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and block_id <= 48970915 limit 10; SELECT 8812396995100-8812396974100-21000 --- --- SELECT sum(amount) from sei.core.fact_transfers where receiver = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and currency = 'usei';636502295337267 SELECT sum(amount) from sei.core.fact_transfers where sender = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and currency = 'usei' ; 600461700131800 SELECT * from sei.core.fact_transactions where tx_from = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' limit 10; 294657000 SELECT SUM(TO_NUMBER(REGEXP_REPLACE(fee, '[^0-9]', ''))) AS total_amount from sei.core.fact_transactions where tx_from = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' limit 10; select 636502295337267 - 600461700131800 - 294657000; ----35,718,665.608467 17558 SELECT * from sei.core.fact_transfers WHERE sender is 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84'; select * from sei.core.fact_msgs limit 10; select * from sei.core.fact_msg_attributes WHERE ATTRIBUTE_VALUE = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' limit 10; select DISTINCT(ATTRIBUTE_KEY) from sei.core.fact_msg_attributes WHERE ATTRIBUTE_VALUE = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' limit 10; SELECT sum(amount) from sei.core.fact_transfers where receiver = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and block_id<=48970915 SELECT sum(amount) from sei.core.fact_transfers where sender = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and block_id<=48970915 SELECT count(fee) from sei.core.fact_transactions where tx_from = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and block_id<=48970915 and fee='1000usei' -- Result = 252727840987168 - 213853983591900 - [20000*1705+10000*1836+2000] //3543 - 1000, 10000, 20000 SELECT sum(currency) from sei.core.fact_transfers where receiver = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' and tx_succeeded = 'true' SELECT DISTINCT(currency) from sei.core.fact_transfers where sender = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' SELECT count(fee) from sei.core.fact_transactions where tx_from = 'sei1nm0rrq86ucezaf8uj35pq9fpwr5r82cl2ufg84' -- Result = 636437706268215 - 598052735567200 [17539 - count: 10,000*1836+20,000*13176+5000*2524+1000*2] SELECT sum(amount) from sei.core.fact_transfers where receiver = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' SELECT sum(amount) from sei.core.fact_transfers where sender = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' SELECT fee from sei.core.fact_transactions where tx_from = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' -- Result = 8812396995100 - 8812396974100 - 21000 -- sdfghjk SELECT sum(amount) from sei.core.fact_transfers where receiver = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and block_id<=48970915 SELECT sum(amount) from sei.core.fact_transfers where sender = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and block_id<=48970915 SELECT fee from sei.core.fact_transactions where tx_from = 'sei1ksyeuyxcd9nk7sku7de75sy98zgxgsc8jtzqzw' and block_id<=48970915 -- Result = 8812396995100 - 999000 - 1000

Query	Creator	Created
2023-09-07 04:09 PM copy solana	coincodecap	Sep 2, 2024
2023-12-29 03:42 PM bitcoin	coincodecap	Dec 29, 2023
2023-09-07 04:09 PM	coincodecap	Sep 7, 2023
Getting Started	coincodecap	May 26, 2023

coincodecap