-- -- -- select distinct action from sei.gov.fact_staking_rewards where block_timestamp >= '2024-10-01'; -- -- -- select * from sei.gov.fact_governance_proposal_deposits limit 10; -- -- -- select * from solana.core.fact_token_account_owners limit 10; -- -- select * -- -- from solana.core.fact_sol_balances -- -- where ACCOUNT_ADDRESS = '2mj1ydGPmFyJWW7wGWQmZg9ByiXcnrgF6kyyeuRHE2hH' -- -- and BLOCK_ID >= 76995157 -- -- and BLOCK_ID <= 89973851 -- -- order by BLOCK_ID -- -- ; -- -- select from solana.gov.fact_rewards_fee -- -- select * from solana.gov.fact_rewards_rent -- -- where vote_pubkey = '9dTV99jHafVXQtBWEYcWQi7Ts4wysWWMZ7BTc5r829Se' -- -- and block_id between 131544356 and 132408345 -- -- ; -- -- select max(block_number), count(*) from bsc.core.ez_native_transfers; -- -- 43905355 2867139211 -- -- select count(*) from bsc.core.ez_native_transfers where block_number > 43897867 and block_number <= 43905355; -- -- -- 352721 -- -- select 2867139211 - 352721; -- -- -- 2866786490 -- -- select -- -- floor(block_number / 1e6) as block_m, -- -- count(*) -- -- from bsc.core.ez_native_transfers -- -- where block_number <= 43897867 -- -- group by block_m -- -- order by block_m -- -- ; -- select -- floor(block_number / 1e1) as block_m, -- count(*) -- from bsc.core.ez_native_transfers -- where block_number >= 43e6 and block_number < 44e6 -- group by block_m -- order by block_m -- ; -- select -- block_number as fs_block, -- count(*) -- from bsc.core.ez_native_transfers -- where block_number >= 33293e3 and block_number < 33294e3 -- group by fs_block -- order by fs_block -- ; -- select -- floor(tx_position / 10) as block_m, -- count(*) -- from bsc.core.ez_native_transfers -- where block_number = 36666530 -- group by block_m -- order by block_m -- ; -- select * from bsc.core.ez_native_transfers -- where block_number = 33293999 -- -- and tx_hash = '0x5cc7cb8ccd4a816fee9608496f2f48034bfdf258bcf63b58738505b318073656' -- order by tx_position -- ; -- select * from bsc.core.fact_traces -- where block_number = 35530333 -- and tx_hash = '0x5cc7cb8ccd4a816fee9608496f2f48034bfdf258bcf63b58738505b318073656' -- order by trace_index -- ; -- select * from bsc.core.ez_native_transfers where identifier like 'SELFDESTRUCT%' limit 10; -- select * from arbitrum.core.ez_native_transfers where identifier like 'SELFDESTRUCT_0_%' limit 10; -- select distinct split(identifier, '_')[0] from bsc.core.ez_native_transfers -- where block_number < 10e6 -- ; -- select * from bsc.core.ez_native_transfers -- where block_number < 10e6 -- and split(identifier, '_')[0] = 'SELFDESTRUCT' -- and identifier <> 'SELFDESTRUCT_ORIGIN' -- limit 10; -- select * from bsc.core.ez_native_transfers -- where block_number < 10e6 -- and split(identifier, '_')[0] = 'CREATE' -- and identifier <> 'CREATE_ORIGIN' -- limit 10; -- select * from arbitrum.core.ez_native_transfers -- where block_number < 50e6 -- and split(identifier, '_')[0] = 'CREATE' -- and identifier <> 'CREATE_ORIGIN' -- limit 10; -- select distinct split(identifier, '_')[0] from arbitrum.core.ez_native_transfers -- where block_number < 50e6 -- ; -- -- INVALID -- select * from arbitrum.core.ez_native_transfers -- where block_number < 50e6 -- and split(identifier, '_')[0] = 'INVALID' -- -- and identifier <> 'CREATE_ORIGIN' -- limit 10; -- select split(identifier, '_')[0], count(*) -- from bsc.core.ez_native_transfers -- where block_number >= 5e6 and block_number < 6e6 -- and split(identifier, '_')[0] in ('CREATE', 'SELFDESTRUCT') -- group by split(identifier, '_')[0] -- ; -- 1564354 -- 1564354 -- select count(distinct block_number) -- from bsc.core.ez_native_transfers -- where split(identifier, '_')[0] = 'SELFDESTRUCT' -- and identifier <> 'SELFDESTRUCT_ORIGIN' -- and block_number > 37517668 -- order by block_number -- ; -- select -- case -- when deactivation_epoch = 18446744073709551615 then 'activated' -- else 'deactivated' -- end as stake_status -- , sum(active_stake) as total_stake -- , count(*) as count -- from solana.gov.fact_stake_accounts -- where activation_epoch = 696 or deactivation_epoch = 696 -- group by stake_status -- ; -- union all -- select -- epoch, -- iff(activation_epoch = epoch, 'never_fully_activated', 'deactivating') as stake_status, -- sum(active_stake) as total_stake -- , count(*) as count -- from solana.gov.fact_stake_accounts -- where deactivation_epoch = 696 -- group by stake_status -- ; -- select -- * -- from solana.gov.fact_stake_accounts where epoch = 696 -- and activation_epoch = 696 -- limit 10 -- ; -- select * from solana.gov.fact_stake_accounts -- where epoch = 692 -- and activation_epoch = 691 -- and deactivation_epoch <> 18446744073709551615 -- limit 100;

teddyastuffed