TIMESTAMP | TX_HASH | EVENT | NFT_ID | SENDER | RECEIVER | |
|---|---|---|---|---|---|---|
1 | 2025-02-15 07:47:47.000 | 0xccf9069cc7d5de25a4a6b89cc36236ce18d883b57ffa8eec3189619a42b1a6f0 | transfer | 1138 | 0x54ecc92c9407b74138fcf45e284425139687ca56 | 0x199565d1e9f50f49ffbe46b6ccb1a30c6f45f1ef |
2 | 2025-02-15 07:46:59.000 | 0x98239eefd0c48ceaf50da790ac39987b419102686afdbe0e24448bad23cecf59 | transfer | 638 | 0xeb79f3b9836e14678abdb862aabfc171341b3199 | 0x79b94c17d8178689df8d10754d7e4a1bb3d49bc1 |
3 | 2025-02-15 07:46:47.000 | 0x454ef7fb04df39b1325fdd56ad29a9e6e2cc370c40058db88f1a1a4769eb2614 | transfer | 638 | 0x820474a280e355e087e892f32702e29226bb066e | 0xeb79f3b9836e14678abdb862aabfc171341b3199 |
4 | 2025-02-15 07:46:47.000 | 0x454ef7fb04df39b1325fdd56ad29a9e6e2cc370c40058db88f1a1a4769eb2614 | transfer | 1138 | 0x820474a280e355e087e892f32702e29226bb066e | 0x54ecc92c9407b74138fcf45e284425139687ca56 |
5 | 2025-02-15 07:45:35.000 | 0x5c2c4514d0136ef32485b88a05670b3cdafa4844632543159fba7139c4440284 | transfer | 1389 | 0xeb79f3b9836e14678abdb862aabfc171341b3199 | 0x1fabfd128d498fef7da0190ef416a502375bf59a |
6 | 2025-02-15 07:45:23.000 | 0x294157a6b86ad564e6a1207620082104143420d8c11bd8bacfb835afeb8583e1 | transfer | 1389 | 0x820474a280e355e087e892f32702e29226bb066e | 0xeb79f3b9836e14678abdb862aabfc171341b3199 |
7 | 2025-02-15 07:44:59.000 | 0x9f7ee69051d10dbeadcfc7d103885f2e8319faa66b812a60bdde0c77afb5696b | transfer | 1389 | 0x477efc7b456963288c710268dfb7576663ddec19 | 0x820474a280e355e087e892f32702e29226bb066e |
8 | 2025-02-15 07:43:23.000 | 0x973feed9087338c212b68625ab8c7ee3a7ab488e99c574819d4ecd2775f2446a | transfer | 1389 | 0x54ecc92c9407b74138fcf45e284425139687ca56 | 0x477efc7b456963288c710268dfb7576663ddec19 |
9 | 2025-02-15 07:39:59.000 | 0xdf21b6c197d2b0ccaa457e7b483f064bf72bd4a6233b238daae0d9d8605e5129 | transfer | 851 | 0x820474a280e355e087e892f32702e29226bb066e | 0x859a3e98661e8350e1efa99d7ae357501126a42a |
10 | 2025-02-15 07:39:35.000 | 0xc51d3b2e16b0bc76b83ad78ae8dff04db1e8cb0312465af18da14fb316aa48c3 | transfer | 851 | 0x67f72412a592d066a2e688e62664116deabeab29 | 0x820474a280e355e087e892f32702e29226bb066e |
11 | 2025-02-15 07:39:35.000 | 0xc51d3b2e16b0bc76b83ad78ae8dff04db1e8cb0312465af18da14fb316aa48c3 | transfer | 1496 | 0x67f72412a592d066a2e688e62664116deabeab29 | 0x41ff81f91fde40cd4bb10fac36a650ce2871c885 |
12 | 2025-02-15 07:36:35.000 | 0xe80ca44a02752f47f512dbddcd1ae8e8357f86a418270c831c088111e1d68c48 | transfer | 1389 | 0x820474a280e355e087e892f32702e29226bb066e | 0x54ecc92c9407b74138fcf45e284425139687ca56 |
13 | 2025-02-15 07:35:47.000 | 0xf0fa03bee1487bf9c798180bc922917dc4f74bc5e9a76e03388c186dcb8d25bf | transfer | 1389 | 0xa0580a130ca644dbef1bf397fe373f66c3ad83e9 | 0x820474a280e355e087e892f32702e29226bb066e |
14 | 2025-02-15 07:33:47.000 | 0x051732e0373447ee7c029edda6520562f0bfe3a7873312d6c8a364f23a30d74a | transfer | 1238 | 0x859a3e98661e8350e1efa99d7ae357501126a42a | 0x78e11523949f4e53e7caa92ce1be787b53738260 |
15 | 2025-02-15 07:13:47.000 | 0x5f5bf9f4ecaf33cd46f46b374ad96337edf5012fb7979dbf95e0b4f39b2ebbac | transfer | 1044 | 0x26da8b7c03698371aecb4307b7de31068dbcab1d | 0x92e9b91aa2171694d740e7066f787739ca1af9de |
16 | 2025-02-15 07:13:23.000 | 0xcafff6656ea29a7006091d75ee4eeaced8f971bc0a26bc1018c3a4edafd6f902 | transfer | 1044 | 0x6fe4aced57ae0b50d14229f3d40617c8b7d2f2e1 | 0x26da8b7c03698371aecb4307b7de31068dbcab1d |
17 | 2025-02-15 07:07:59.000 | 0x986c8108fe5b032fda31c031538f6794d8753174b050fbed9e77031cead1e57a | transfer | 1340 | 0x820474a280e355e087e892f32702e29226bb066e | 0x397642ac095040260f77c7c570e6f86f0e9aa720 |
18 | 2025-02-15 07:01:35.000 | 0x0eaad37b4fdd07f62a577d168d1125ad0f0cc0a05c3b44a246818371eb088ba6 | transfer | 1352 | 0x5a7cedb5683fa6b5f38c6a56942b733a425fe39b | 0xee3c2d93ab21321a8fec55593d5a367d374fcd3f |
19 | 2025-02-15 07:00:47.000 | 0x90dd1e7b577f325bf127d276a7e53dc2a20269ebe6b8e912f7b50fb636684a6b | transfer | 1352 | 0x5c270528353b44b9e11fbef10aaa91765d040969 | 0x5a7cedb5683fa6b5f38c6a56942b733a425fe39b |
20 | 2025-02-15 06:43:11.000 | 0x3e872a7a59fdaa24bdd28792c72a98833bfc0e972dc379c5c23ac49fc2be86c4 | transfer | 1437 | 0x54ecc92c9407b74138fcf45e284425139687ca56 | 0x7e7022f8879d88bcc5d288b229737adb4b1f39cb |
freemartianTransfers
Updated 29 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with sapes_api as (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/transfer.json'
) AS response
)
SELECT
to_timestamp(value:event_timestamp) AS timestamp,
value:transaction AS tx_hash,
value:event_type AS event,
value:nft:identifier AS nft_id,
value:from_address AS sender,
value:to_address AS receiver,
FROM sapes_api, LATERAL FLATTEN (input => response:data)
WHERE event = 'transfer'
GROUP BY ALL
ORDER BY 1 DESC
Last run: 29 minutes agoAuto-refreshes every 1 hour
...
1650
329KB
3s