Getting Started | 0x158e02e4A130AFD22426bc3cCA06dD346f4f54Ea

Updated 9 days ago

-- Get started with Flipside by running your first query:

-- the SQL statement below will get you a list of NFT

-- platforms on Ethereum, ranked by how many sales

-- they've had in the past month.

-- Be sure to see our documentation for more guidance,

-- including a full walkthrough of the app:

-- https://docs.flipsidecrypto.xyz/our-app/getting-started

select

from monad.testnet.fact_event_logs

where block_timestamp > current_date - interval '30 days'

and contract_address = lower('0x37676650654C9c2C36fCeCfaEA6172eE1849F9a4')

and lower(data::text) like lower('%fdfDCF1E38744eA903b0434E5b602EAdbBCA824F%')

and lower(data::text) like lower('%0044a%')

limit 200;

Last run: 9 days ago

	BLOCK_NUMBER	BLOCK_TIMESTAMP	TX_HASH	TX_POSITION	EVENT_INDEX	CONTRACT_ADDRESS	TOPICS	TOPIC_0	TOPIC_1	TOPIC_2	TOPIC_3	DATA	EVENT_REMOVED	ORIGIN_FROM_ADDRESS	ORIGIN_TO_ADDRESS	ORIGIN_FUNCTION_SIGNATURE	TX_SUCCEEDED	FACT_EVENT_LOGS_ID	INSERTED_TIMESTAMP	MODIFIED_TIMESTAMP
1	6637486	2025-03-07 16:53:21.000	0x8260df431c0998331964c841e76f3e13f342a3a3f7d0ad573d92694406ce7551	0	0	0x37676650654c9c2c36fcecfaea6172ee1849f9a4	["0xb81bbaf150467ef3096ed6220cb963abc169bffd2eb88f26c47359ef344cf94c"]	0xb81bbaf150467ef3096ed6220cb963abc169bffd2eb88f26c47359ef344cf94c				0x000000000000000000000000000000000000000000000000000000000000044a000000...	FALSE	0xfdfdcf1e38744ea903b0434e5b602eadbbca824f	0x37676650654c9c2c36fcecfaea6172ee1849f9a4	0x40e79b1b	TRUE	ef7cab20122c4a97e7a61758b3ea2b69	2025-03-07 17:53:12.419	2025-03-07 17:53:12.419

836B

10s