creepy-chocolate

datavortexcreepy-chocolate

Updated 2025-03-13

SELECT

SELECT input, output, origin_from_address, origin_to_address, tx_hash,

left(input, 10) AS function_signature,

regexp_substr_all(SUBSTR(input, 11), '.{64}') as segmented,

'0X' || substr(segmented[0]::string, 25) as src,

'0X' || substr(segmented[1]::string, 25) as dst,

livequery.utils.udf_hex_to_int(segmented[2]::string) as wad

FROM ethereum.core.fact_traces

where trace_succeeded = TRUE

and tx_hash = '0x06f4721faf8cb0298baf540d6268a275c574cc5a687abe764023fe0edcf0aada'

and function_signature = '0x23b872dd'

LIMIT 500

select

tx_hash,

trace_index,

input,

output,

left(input, 10) as function_sig,

regexp_substr_all(SUBSTR(input, 11), '.{64}') AS segmented,

--segmented[0] , -- domain separator

--segmented[1], -- isCollectionLevelOffer

--segmented[2] -- protocol

--,'0x' || substr(segmented[3]::string , 25) as maker

--,livequery.utils.udf_hex_to_int(segmented[13]::string) as expiration,

--to_timestamp(expiration)

-- '0x' || substr(segmented[0]::string , 25) as src,

-- '0x' || substr(segmented[1]::string , 25) as dst,

-- livequery.utils.udf_hex_to_int(segmented[2]::string) as wad

Last run: 3 months ago

	INPUT	OUTPUT	ORIGIN_FROM_ADDRESS	ORIGIN_TO_ADDRESS	TX_HASH	FUNCTION_SIGNATURE	SEGMENTED	SRC	DST	WAD
1	0x3628263a0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19	0x000000000000000000000000000000000000000000000000000000000000c350	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x3628263a	[ "0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19" ]	0X9cef7d1d390a4811bba1bc40a53b40a506c33b19
2	0x16f0115b	0x000000000000000000000000c39a5a616f0ad1ff45077fa2de3f79ab8eb8b8b9	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x16f0115b	[]
3	0x4672d6a60000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19	0x0000000000000000000000000000000000000000000000000000000000000000	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x4672d6a6	[ "0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19" ]	0X9cef7d1d390a4811bba1bc40a53b40a506c33b19
4	0x3a60339a	0x000000000000000000000000804a6f5f667170f545bf14e5ddb48c70b788390c	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x3a60339a	[]
5	0x0827b071000000000000000000000000000000000000000000000000000000b7efab5c...		0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x0827b071	[ "000000000000000000000000000000000000000000000000000000b7efab5c00", "000000000000000000000000000000000000000000000000000000025f3a2204", "0000000000000000000000000000000000000000000000000000000000000000", "0000000000000000000000000000000000000000000000000000000011dc100f", "0000000000000000000000000000000000000000000000000000000067899b0f" ]	0X000000000000000000000000000000b7efab5c00	0X000000000000000000000000000000025f3a2204	0
6	0x1a70f05e0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19	0x00000000000000000000000000000000000000000000000000000000000009c4	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x1a70f05e	[ "0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19" ]	0X9cef7d1d390a4811bba1bc40a53b40a506c33b19
7	0x5949d6e90000000000000000000000000000000000000000000000000000000000000000		0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x5949d6e9	[ "0000000000000000000000000000000000000000000000000000000000000000" ]	0X0000000000000000000000000000000000000000
8	0xa9059cbb0000000000000000000000008c6a34e2b9cecee4a1fce672ba37e611b1aece...	0x0000000000000000000000000000000000000000000000000000000000000001	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xa9059cbb	[ "0000000000000000000000008c6a34e2b9cecee4a1fce672ba37e611b1aecebb", "0000000000000000000000000000000000000000000000000000000014387d4a" ]	0X8c6a34e2b9cecee4a1fce672ba37e611b1aecebb	0X0000000000000000000000000000000014387d4a
9	0x3a60339a	0x000000000000000000000000804a6f5f667170f545bf14e5ddb48c70b788390c	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x3a60339a	[]
10	0xa9059cbb000000000000000000000000c39a5a616f0ad1ff45077fa2de3f79ab8eb8b8...	0x0000000000000000000000000000000000000000000000000000000000000001	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xa9059cbb	[ "000000000000000000000000c39a5a616f0ad1ff45077fa2de3f79ab8eb8b8b9", "000000000000000000000000000000000000000000000000000000ba1c507f07" ]	0Xc39a5a616f0ad1ff45077fa2de3f79ab8eb8b8b9	0X000000000000000000000000000000ba1c507f07
11	0x0827b071000000000000000000000000000000000000000000000000000000b7efab5c...		0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x0827b071	[ "000000000000000000000000000000000000000000000000000000b7efab5c00", "000000000000000000000000000000000000000000000000000000025f3a2204", "0000000000000000000000000000000000000000000000000000000000000000", "0000000000000000000000000000000000000000000000000000000011dc100f", "0000000000000000000000000000000000000000000000000000000067899b0f" ]	0X000000000000000000000000000000b7efab5c00	0X000000000000000000000000000000025f3a2204	0
12	0x23b872dd000000000000000000000000028ffcff8c8d9c0e75186f62ff483addbbc500...	0x0000000000000000000000000000000000000000000000000000000000000001	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x23b872dd	[ "000000000000000000000000028ffcff8c8d9c0e75186f62ff483addbbc50075", "000000000000000000000000b50d675f3c6d18ce5ccac691354f92afebd1675e", "000000000000000000000000000000000000000000000000000000ba60c18e13" ]	0X028ffcff8c8d9c0e75186f62ff483addbbc50075	0Xb50d675f3c6d18ce5ccac691354f92afebd1675e	800487214611
13	0xa009bea2000000000000000000000000000000000000000000000000000000b7efab5c00		0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xa009bea2	[ "000000000000000000000000000000000000000000000000000000b7efab5c00" ]	0X000000000000000000000000000000b7efab5c00
14	0xd9ef0459	0x0000000000000000000000000000000000000000000000000000000067899b0f	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xd9ef0459	[]
15	0x4672d6a60000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19	0x0000000000000000000000000000000000000000000000000000000000000000	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x4672d6a6	[ "0000000000000000000000009cef7d1d390a4811bba1bc40a53b40a506c33b19" ]	0X9cef7d1d390a4811bba1bc40a53b40a506c33b19
16	0xcaf901dd	0x0000000000000000000000000000000000000000000000000000000000000001	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xcaf901dd	[]
17	0x938afdd00000000000000000000000000000000000000000000000000000000067899b0f	0x0000000000000000000000000000000000000000000000000000000000000000000000...	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x938afdd0	[ "0000000000000000000000000000000000000000000000000000000067899b0f" ]	0X0000000000000000000000000000000067899b0f
18	0x70a0823100000000000000000000000098005a88a32f1a88f68598ab8ba7db914aa6d626	0x0000000000000000000000000000000000000000000000000000000000000000	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x70a08231	[ "00000000000000000000000098005a88a32f1a88f68598ab8ba7db914aa6d626" ]	0X98005a88a32f1a88f68598ab8ba7db914aa6d626
19	0x5dd28449	0x0000000000000000000000000000000000000000000000000000000000008214	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0x5dd28449	[]
20	0xa9059cbb000000000000000000000000a9466eabd096449d650d5aeb0dd3da6f52fd0b...	0x0000000000000000000000000000000000000000000000000000000000000001	0x028ffcff8c8d9c0e75186f62ff483addbbc50075	0xb4cb9affb100506600c79cc6d8834cc0d93e9c36	0xbb654a63930c5b08169992c6739f7340fa60f163089e4123a9c77ac9b5ae9421	0xa9059cbb	[ "000000000000000000000000a9466eabd096449d650d5aeb0dd3da6f52fd0b19", "00000000000000000000000000000000000000000000000000000000303891c2" ]	0Xa9466eabd096449d650d5aeb0dd3da6f52fd0b19	0X00000000000000000000000000000000303891c2

32KB

flipside

flipside