/* EXTRACT AUG-2021 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 2 rows | 545B in 1s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfersUpdateUpdateUpdateUpdateUpdate WHERE (BLOCK_TIMESTAMP >= '2021-08-01' AND BLOCK_TIMESTAMP <= '2021-09-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT SEP-2021 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 0 rows | 2B in 1s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2021-09-01' AND BLOCK_TIMESTAMP <= '2021-10-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT OCT-2021 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 0 rows | 2B in 3s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2021-10-01' AND BLOCK_TIMESTAMP <= '2021-11-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT NOV-2021 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 0 rows | 2B in 4s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2021-11-01' AND BLOCK_TIMESTAMP <= '2021-12-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT DEC-2021 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 14935 rows | 4MB in 12s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2021-12-01' AND BLOCK_TIMESTAMP <= '2022-01-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT JAN-2022 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 23053 rows | 6MB in 55s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2022-01-01' AND BLOCK_TIMESTAMP <= '2022-02-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT FEB-2022 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 24265 rows | 6MB in 13s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2022-02-01' AND BLOCK_TIMESTAMP <= '2022-03-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT MAR-2022 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 19652 rows | 5MB in 23s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2022-03-01' AND BLOCK_TIMESTAMP <= '2022-04-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ /* EXTRACT APR-2022 - 9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5 */ -- 22887 rows | 6MB in 31s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (BLOCK_TIMESTAMP >= '2022-04-01' AND BLOCK_TIMESTAMP <= '2022-05-01') AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC */ -- EARLIEST TX - 91441593 / 2021-08-13 04:17:08.000 / 4Z4RiSFwXXQGwkTUaBpcNCt1uauLAZFwdq8fD9pUMTG7DmFpDMkbLRtTWTnbNXBwd5Xxpf6J /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP ASC LIMIT 1; */ -- LATEST TX WITHIN SPECIFIED DATE RANGE - 91442609, 2021-08-13 04:26:54.000, 2uni2qDG89HJEVMqXcBAajpEx13xULN8WLacyX72Jw6dprVJStayLmaR9Q2d3hRAWy9D3DBSChifYz1M6AghDWwy -- 273B in 5s /* SELECT BLOCK_ID, BLOCK_TIMESTAMP, TX_ID, TX_FROM, TX_TO, MINT, AMOUNT FROM solana.core.fact_transfers WHERE BLOCK_TIMESTAMP <= '2021-09-01 00:00:00.000' AND BLOCK_TIMESTAMP >= '2021-08-01 00:00:00.000' AND (TX_FROM = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5' OR TX_TO = '9RuqAN42PTUi9ya59k9suGATrkqzvb9gk2QABJtQzGP5') ORDER BY BLOCK_TIMESTAMP DESC LIMIT 1; */ -- LATEST TX WITHIN SPECIFIED DATE RANGE - -- B in s /* SELECT * FROM gnosis.core.fact_transactions WHERE BLOCK_TIMESTAMP <= '2021-12-01 00:00:00.000' AND BLOCK_TIMESTAMP >= '2022-02-31 00:00:00.000' AND (FROM_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be' OR TO_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be') ORDER BY BLOCK_TIMESTAMP DESC LIMIT 1; */ -- ALL TX FOR GNOSIS ADDRESS /* SELECT * FROM gnosis.core.fact_transactions WHERE (FROM_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be' OR TO_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be') ORDER BY BLOCK_TIMESTAMP DESC */ /* -- ALL TOKEN TRANSFER TX FOR GNOSIS ADDRESS SELECT ftt.block_number, ftt.block_timestamp, ftt.contract_address, ftt.from_address, ftt.to_address, ftt.raw_amount, dc.* FROM gnosis.core.fact_token_transfers ftt, gnosis.core.dim_contracts dc WHERE (ftt.FROM_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be' OR ftt.TO_ADDRESS = '0x9fc062032d4f2fe7daa601bd8b06c45f9c8f17be') AND ftt.contract_address = dc.address ORDER BY BLOCK_TIMESTAMP DESC */ -- ALL TOKEN TRANSFER TX FOR GNOSIS ADDRESS WITHIN TIME PERIOD /* SELECT ftt.tx_hash, ftt.from_address, ftt.to_address, ft.value, ftt.contract_address, dc.symbol, ft.tx_fee, ft.block_timestamp, ftt.raw_amount, dc.decimals FROM gnosis.core.fact_token_transfers ftt, gnosis.core.fact_transactions ft, gnosis.core.dim_contracts dc WHERE ( ftt.FROM_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR ftt.TO_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' ) AND ftt.tx_hash = ft.tx_hash AND ftt.block_timestamp >= '2023-09-01 00:00:00.000' AND ftt.block_timestamp <= '2024-03-31 00:00:00.000' AND ftt.contract_address = dc.address ORDER BY BLOCK_TIMESTAMP DESC */ -- 586 tx /* SELECT ftt.tx_hash, ftt.from_address, ftt.to_address, ft.value, ftt.contract_address, ft.tx_fee, ft.block_timestamp, ftt.raw_amount, dc.decimals FROM gnosis.core.fact_token_transfers ftt, gnosis.core.fact_transactions ft, gnosis.core.dim_contracts dc WHERE ( ftt.FROM_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR ftt.TO_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' ) AND ftt.tx_hash = ft.tx_hash AND ftt.block_timestamp >= '2021-01-01 00:00:00.000' AND ftt.block_timestamp <= '2022-12-31 23:59:59.000' AND ftt.contract_address = dc.address */ /* SELECT ft.* FROM gnosis.core.fact_transactions ft, WHERE ( ft.FROM_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR ft.TO_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' ) AND ft.block_timestamp >= '2021-01-01 00:00:00.000' AND ft.block_timestamp <= '2022-12-31 23:59:59.000' */ -- Found , FACT_TRANSACTIONS_ID = 3dc9c4010780a86b88723f6cf77ef44c /* SELECT ft.* FROM gnosis.core.fact_transactions ft WHERE ft.tx_hash = '0x189a55981bfa643cce37ff66f95a47cbe113b21eb5751d57b28a04f93e1d6b94' */ /* SELECT ft.* FROM gnosis.core.fact_transactions ft WHERE ft.fact_transactions_id = '3dc9c4010780a86b88723f6cf77ef44c' */ SELECT ent.* FROM gnosis.core.ez_native_transfers ent WHERE ent.tx_hash = '0x189a55981bfa643cce37ff66f95a47cbe113b21eb5751d57b28a04f93e1d6b94' /* SELECT * from gnosis.core.dim_contracts WHERE ADDRESS = '0xc9b6218affe8aba68a13899cbf7cf7f14ddd304c' */ -- GET SPECIFIC TX DETAILS INCLUDING FEE /* SELECT * FROM gnosis.core.fact_transactions WHERE TX_HASH in ('0x6052fa29d6f1e46fe391632c7e0f78f534c806a1f186fa449aa271d55925d1b0', '0x521c2021f792af356e1f1efa06325899ca6394299b9a24ec01d78c5a01022f5f') */ /* SELECT * FROM gnosis.core.dim_contracts WHERE SYMBOL != '' */ /* SELECT * FROM gnosis.core.ez_native_transfers WHERE ( ORIGIN_FROM_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR ORIGIN_TO_ADDRESS = '00xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR FROM_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' OR TO_ADDRESS = '0xcfd3aa1ebc6119d80ed47955a87a9d9c281a97b3' ) */

nexus7