flipside

    integrated-orange
    par_rnintegrated-orange
    Updated 2 days ago
    -- select a.* from boba.core.fact_event_logs a inner join boba.core.ez_token_transfers b on a.tx_hash=b.tx_hash
    -- limit 10
    -- select a.* from boba.core.fact_event_logs a left join boba.core.ez_token_transfers b on a.tx_hash=b.tx_hash
    -- limit 10
    select b.* from boba.core.fact_event_logs a right join boba.core.ez_token_transfers b on a.tx_hash=b.tx_hash
    limit 100
    Last run: 2 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    TX_POSITION
    EVENT_INDEX
    FROM_ADDRESS
    TO_ADDRESS
    CONTRACT_ADDRESS
    TOKEN_STANDARD
    NAME
    SYMBOL
    DECIMALS
    RAW_AMOUNT_PRECISE
    RAW_AMOUNT
    AMOUNT_PRECISE
    AMOUNT
    AMOUNT_USD
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    EZ_TOKEN_TRANSFERS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301110x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea0xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18951819937110495046594459.51819937110495e+2295181.99371104950465944595181.9937110518717.160x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233eab7a8f2dc909d0c1cbc9354c373ddf7c32025-02-25 20:26:00.7152025-02-25 20:26:00.715
    2
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011140x8d611a80910bd289896e793d43d0ad0a34c233ea0x9f034dddd9c6464e827f648110dda4b6a3a428440xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18943375896159518421872539.43375896159518e+2294337.58961595184218725394337.58961595218551.110x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233eaaf8528919c10061bf51f7ebe4a01c2a52025-02-25 20:26:00.7152025-02-25 20:26:00.715
    3
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011160x8d611a80910bd289896e793d43d0ad0a34c233ea0x9f034dddd9c6464e827f648110dda4b6a3a428440xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH18580227262273266652758022726227326700005.8022726227326665275.8022726230x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea9510a4e26e737ffdd86b9e1bf2c395782025-02-25 20:26:00.7152025-02-25 20:26:00.715
    4
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011100xb1ed67e29b2497404a2ac7f2a2989c3328ec29990x8d611a80910bd289896e793d43d0ad0a34c233ea0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH1850068010178797632500680101787976000.0500680101787976320.050068010180x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea58bb4a56772eabed58fec273487342712025-02-25 20:26:00.7152025-02-25 20:26:00.715
    5
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301150x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH18575220461255386889557522046125538700005.7522046125538688955.7522046130x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea4d60b72ba731ba88b8224cc2f1c2c8e92025-02-25 20:26:00.7152025-02-25 20:26:00.715
    6
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011150x8d611a80910bd289896e793d43d0ad0a34c233ea0x9f034dddd9c6464e827f648110dda4b6a3a428440x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6501222585012225850.12225850.12225850.120x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea7df67074ce3ac9edbe61418aa8f178b32025-02-25 20:26:00.7152025-02-25 20:26:00.715
    7
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011110x8d611a80910bd289896e793d43d0ad0a34c233ea0xb1ed67e29b2497404a2ac7f2a2989c3328ec29990x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6165459112165459112165.459112165.459112165.460x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ead60fddb012ba25b21728b8c2b0168aa62025-02-25 20:26:00.7152025-02-25 20:26:00.715
    8
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301170x8d611a80910bd289896e793d43d0ad0a34c233ea0xdf37543dae7986e48e3ce83f390a828a9f3d23ba0xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18844404095097662472192844404095097662000000844.404095097662472192844.404095098166.050x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233eabc4d03a38bb5f0902e64a98a4a81bb0b2025-02-25 20:26:00.7152025-02-25 20:26:00.715
    9
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301160xdf37543dae7986e48e3ce83f390a828a9f3d23ba0x8d611a80910bd289896e793d43d0ad0a34c233ea0x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6165460766165460766165.460766165.460766165.460x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea57ae5c107b086556fc3e19a241a6dcb92025-02-25 20:26:00.7152025-02-25 20:26:00.715
    10
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301130x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea0x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6501206045012060450.12060450.12060450.120x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea4fb1aa67e870fd32fd8e721c5a8e82122025-02-25 20:26:00.7152025-02-25 20:26:00.715
    11
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284170xb1ed67e29b2497404a2ac7f2a2989c3328ec29990x000000000003b57982426680c8eeeaf1920ffe210xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH1812735062728360977127350627283610000.0127350627283609770.012735062730x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe21b8139dd60b4ed27bfebe34084bf49d802025-02-25 20:26:00.7152025-02-25 20:26:00.715
    12
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284110x247442181b8baa03b3c7dc0d8e971bd4686db27c0x000000000003b57982426680c8eeeaf1920ffe210xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18216539287235244742721216539287235245000000216.539287235244742721216.53928723542.180x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe2163ef53de6e6e0b4eef7ed7963a41602b2025-02-25 20:26:00.7152025-02-25 20:26:00.715
    13
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284150x000000000003b57982426680c8eeeaf1920ffe210xdf37543dae7986e48e3ce83f390a828a9f3d23ba0xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18216539287235244742720216539287235245000000216.53928723524474272216.53928723542.180x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe21cddeefd66ad43b7a34a1e8c04b8a49e62025-02-25 20:26:00.7152025-02-25 20:26:00.715
    14
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284100x000000000003b57982426680c8eeeaf1920ffe210x247442181b8baa03b3c7dc0d8e971bd4686db27c0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH1812721931065195362127219310651954000.0127219310651953620.012721931070x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe21ab08cfb6cef4f53bc0c2af83c439e9ed2025-02-25 20:26:00.7152025-02-25 20:26:00.715
    15
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284140xdf37543dae7986e48e3ce83f390a828a9f3d23ba0x000000000003b57982426680c8eeeaf1920ffe210x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6420108734201087342.01087342.01087341.990x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe21266d060bf9a137251d566fac4089b7eb2025-02-25 20:26:00.7152025-02-25 20:26:00.715
    16
    		134398062025-01-26 09:40:53.0000x841a27bee865d4b54ef489355d1af215df59a3d4b6685479109625ad8bab7284180x000000000003b57982426680c8eeeaf1920ffe210xb1ed67e29b2497404a2ac7f2a2989c3328ec29990x66a2a913e447d6b4bf33efbec43aaef87890fbbcerc20USD CoinUSDC6420108704201087042.0108742.0108741.990x00a614240x09639355bfa0f3a2d4074c0ee38bd8de36692a140x000000000003b57982426680c8eeeaf1920ffe212826543e8d8cf0f8dfc9a2f418df7b992025-02-25 20:26:00.7152025-02-25 20:26:00.715
    17
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e59301110x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea0xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18951819937110495046594459.51819937110495e+2295181.99371104950465944595181.9937110518717.160x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233eab7a8f2dc909d0c1cbc9354c373ddf7c32025-02-25 20:26:00.7152025-02-25 20:26:00.715
    18
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011140x8d611a80910bd289896e793d43d0ad0a34c233ea0x9f034dddd9c6464e827f648110dda4b6a3a428440xa18bf3994c0cc6e3b63ac420308e5383f53120d7erc20Boba TokenBOBA18943375896159518421872539.43375896159518e+2294337.58961595184218725394337.58961595218551.110x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233eaaf8528919c10061bf51f7ebe4a01c2a52025-02-25 20:26:00.7152025-02-25 20:26:00.715
    19
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011160x8d611a80910bd289896e793d43d0ad0a34c233ea0x9f034dddd9c6464e827f648110dda4b6a3a428440xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH18580227262273266652758022726227326700005.8022726227326665275.8022726230x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea9510a4e26e737ffdd86b9e1bf2c395782025-02-25 20:26:00.7152025-02-25 20:26:00.715
    20
    		134577122025-01-26 19:37:45.0000x4dc13c3b11a1d9e379cab80efd93acb7f90258e3eec81ece7a57df10c9e593011100xb1ed67e29b2497404a2ac7f2a2989c3328ec29990x8d611a80910bd289896e793d43d0ad0a34c233ea0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000erc20Wrapped EtherWETH1850068010178797632500680101787976000.0500680101787976320.050068010180x3bf30f850x9f034dddd9c6464e827f648110dda4b6a3a428440x8d611a80910bd289896e793d43d0ad0a34c233ea58bb4a56772eabed58fec273487342712025-02-25 20:26:00.7152025-02-25 20:26:00.715
    100
    53KB
    2s