MeirLiquidity Transfer (Base)
    Updated 2024-02-16
    -- forked from Liquidity Transfer (Ethereum) @ https://flipsidecrypto.xyz/edit/queries/534bb394-57a7-4641-abc7-29013f49867d

    with recieve as (
    SELECT
    *
    FROM base.core.ez_token_transfers as transfers
    WHERE transfers.TO_ADDRESS in (
    -- '0x91285c4fc766fff6f3acafeec7a0423275257fae', --crvusd/eusd
    -- '0xc37c0e88551ed383c1abedc6628a5579071bf56f', --mkusd/eusd
    -- '0x8a8434a5952ac2cf4927bbea3ace255c6dd165cd', -- hyusd/eusd
    -- '0xaeda92e6a3b1028edc139a4ae56ec881f3064d4f', --fraxbp/eusd
    -- '0x7fb53345f1b21ab5d9510adb38f7d3590be6364b', -- eth/eth+
    -- '0xf2b25362a03f6eacca8de8d5350a9f37944c1e59' --usdc/usdc+'

    '0x798d81d60966d2e909468d87e7e4b6a8dafb1c36', -- crvusd/eusd base
    '0x6be2a0d3324279e645690721fc843110c84f29f1' -- hyusd/eusd base
    )
    ),

    send as (
    SELECT
    *
    FROM base.core.ez_token_transfers as transfers
    WHERE transfers.FROM_ADDRESS in (
    -- '0x91285c4fc766fff6f3acafeec7a0423275257fae', --crvusd/eusd
    -- '0xc37c0e88551ed383c1abedc6628a5579071bf56f', --mkusd/eusd
    -- '0x8a8434a5952ac2cf4927bbea3ace255c6dd165cd', -- hyusd/eusd
    -- '0xaeda92e6a3b1028edc139a4ae56ec881f3064d4f', --fraxbp/eusd
    -- '0x7fb53345f1b21ab5d9510adb38f7d3590be6364b', -- eth/eth+
    -- '0xf2b25362a03f6eacca8de8d5350a9f37944c1e59' --usdc/usdc+'

    '0x798d81d60966d2e909468d87e7e4b6a8dafb1c36', -- crvusd/eusd base
    '0x6be2a0d3324279e645690721fc843110c84f29f1' -- hyusd/eusd base
    )
    ),

    Last run: about 1 year ago
    AMOUNT
    AMOUNT_USD
    POOL_ADDR
    ORIGIN_TO_ADDRESS
    ORIGIN_FROM_ADDRESS
    FROM_ADDRESS
    TO_ADDRESS
    SYMBOL
    PRICE
    HAS_PRICE
    BLOCK_TIMESTAMP
    TX_HASH
    CHAIN_ID
    1
    83.5302549420x798d81d60966d2e909468d87e7e4b6a8dafb1c360x4f64c4df74a21e72c0a9230a10d9a80dc0f9d89f2.19793278488665e+460xd6681e74eea20d196c15038c580f721ef2ab63200x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2023-12-05 11:10:49.0000xe8f77c1427a4f7810d8b9b7f95071275db3d08c2513b18c5bd3fc451780853088453
    2
    1.1205227760x798d81d60966d2e909468d87e7e4b6a8dafb1c360xd6681e74eea20d196c15038c580f721ef2ab63201.21588105556661e+480xd6681e74eea20d196c15038c580f721ef2ab63200x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2023-12-15 17:43:11.0000x55fe2f720614a76bb7527db558b47ca1aafbdddef4df79ac3e79434190ce02c18453
    3
    1.1181773541.0991851120x6be2a0d3324279e645690721fc843110c84f29f10x6be2a0d3324279e645690721fc843110c84f29f11.21588105556661e+480xd4f9fe0039da59e6ddb21bbb6e84e0c9e83d73ed0x6be2a0d3324279e645690721fc843110c84f29f1eUSD0.983015true2023-12-15 17:46:01.0000xe4f8270d2948aefc7f2d9fb6ac6aaaa7b9dc37203944b0e43acc7fe7face597a8453
    4
    50440.43037573549678.4267940490x798d81d60966d2e909468d87e7e4b6a8dafb1c360x798d81d60966d2e909468d87e7e4b6a8dafb1c362.17705806537195e+460x03d03a026e71979be3b08d44b01eae4c5ff9da990x798d81d60966d2e909468d87e7e4b6a8dafb1c36eUSD0.984893true2023-12-18 16:43:33.0000x28c945e207f46951b4a0a8ecc7ad71017008ae8f02c3519fd845ab65bbcb28478453
    5
    6817.6394705020x798d81d60966d2e909468d87e7e4b6a8dafb1c360x11797ca7109a9927d3a0e0d1aa395c89a5bc3d902.07784250329431e+460x11797ca7109a9927d3a0e0d1aa395c89a5bc3d900x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2023-12-18 16:48:29.0000x2beecf393d85a1b76d234b3947d3a69a2b488312862abc642fe366e2dab7b6328453
    6
    4101.9090668114039.9415265390x6be2a0d3324279e645690721fc843110c84f29f10x7161f940d3ca88e4035d7b7fbde2a2870d176f871.41571815183429e+480x7161f940d3ca88e4035d7b7fbde2a2870d176f870x6be2a0d3324279e645690721fc843110c84f29f1eUSD0.984893true2023-12-18 16:49:57.0000x24d8ac3a9ca04b2eef3bd0eee946ee087768c55d12c87bee9df80dcf42f84e4f8453
    7
    26858.2861325490x6be2a0d3324279e645690721fc843110c84f29f10x6be2a0d3324279e645690721fc843110c84f29f12.17705806537195e+460x03d03a026e71979be3b08d44b01eae4c5ff9da990x6be2a0d3324279e645690721fc843110c84f29f1hyUSDfalse2023-12-18 16:49:47.0000xbf0038924f5222a7cb7aedcde04b6176d284be10ed6da701f88dd6fd7f03428f8453
    8
    1260.3550424460x6be2a0d3324279e645690721fc843110c84f29f10x77c2c727877e14afc2d31285cff89a15b5c9fd013.08928547635551e+470x77c2c727877e14afc2d31285cff89a15b5c9fd010x6be2a0d3324279e645690721fc843110c84f29f1hyUSDfalse2023-12-18 16:26:55.0000xb16695896042fda7665c744873bef19347fd7ee2914de0df127054055a6c200f8453
    9
    1031.9686693651034.0326067040x798d81d60966d2e909468d87e7e4b6a8dafb1c360x7161f940d3ca88e4035d7b7fbde2a2870d176f871.41571815183429e+480x7161f940d3ca88e4035d7b7fbde2a2870d176f870x798d81d60966d2e909468d87e7e4b6a8dafb1c36eUSD1.002true2024-01-18 07:23:31.0000xe00cc2a9978c202e69f2f72cbc07a7196a8827bb426642e859241d7305dc5b368453
    10
    1025.6362897430x6be2a0d3324279e645690721fc843110c84f29f10x7161f940d3ca88e4035d7b7fbde2a2870d176f871.41571815183429e+480x7161f940d3ca88e4035d7b7fbde2a2870d176f870x6be2a0d3324279e645690721fc843110c84f29f1hyUSDfalse2024-01-18 07:23:31.0000xe00cc2a9978c202e69f2f72cbc07a7196a8827bb426642e859241d7305dc5b368453
    11
    251.7795760330x798d81d60966d2e909468d87e7e4b6a8dafb1c360x798d81d60966d2e909468d87e7e4b6a8dafb1c361.25612349850734e+480xdc0686971386f20b973466cc9f227d862964cf420x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2023-10-31 14:47:37.0000x6db32fcc070a4102e1b44f02cc5f87f5328469f55a72421fc12a670836b510008453
    12
    9700.570858910x798d81d60966d2e909468d87e7e4b6a8dafb1c360x11797ca7109a9927d3a0e0d1aa395c89a5bc3d902.07784250329431e+460x11797ca7109a9927d3a0e0d1aa395c89a5bc3d900x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2023-12-17 03:37:43.0000xc5b4e49b02f5a9c5573b61c7465725c84288df9ea83fc7bb101a89a17143328e8453
    13
    513.19360727504.0582478670x6be2a0d3324279e645690721fc843110c84f29f10x7161f940d3ca88e4035d7b7fbde2a2870d176f871.41571815183429e+480x7161f940d3ca88e4035d7b7fbde2a2870d176f870x6be2a0d3324279e645690721fc843110c84f29f1eUSD0.982199true2023-12-17 03:53:47.0000x39176b9119b37badfc8b1471ecb6ca32d57ca6123f0de9f014f258c884f8371e8453
    14
    59.9997970320x798d81d60966d2e909468d87e7e4b6a8dafb1c360x4f64c4df74a21e72c0a9230a10d9a80dc0f9d89f2.19793278488665e+460xd6681e74eea20d196c15038c580f721ef2ab63200x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-02-06 18:11:45.0000x9522d066fcc54bd724d16295bf2ecda7d09339bdd3c7f00110645e30a473c03d8453
    15
    2569.9833822150x798d81d60966d2e909468d87e7e4b6a8dafb1c360x77c2c727877e14afc2d31285cff89a15b5c9fd013.08928547635551e+470x77c2c727877e14afc2d31285cff89a15b5c9fd010x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:30:59.0000x94e638e5628be9620a3aa7211accc2d1203c85d0aca66e52b336064ba60a40328453
    16
    1284.7339549810x798d81d60966d2e909468d87e7e4b6a8dafb1c360x77c2c727877e14afc2d31285cff89a15b5c9fd013.08928547635551e+470x77c2c727877e14afc2d31285cff89a15b5c9fd010x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:31:21.0000x43099a9e87b05eb0d4be2236b5fba42207697f3071660fd7b9989a4795bdc7a18453
    17
    537.7662741950x798d81d60966d2e909468d87e7e4b6a8dafb1c360x11797ca7109a9927d3a0e0d1aa395c89a5bc3d902.07784250329431e+460x11797ca7109a9927d3a0e0d1aa395c89a5bc3d900x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:39:51.0000xb0fd398449850c283e986ab0869daa5fa691bcf5de787e75ecc319374df2f0558453
    18
    1285.4399616360x798d81d60966d2e909468d87e7e4b6a8dafb1c360x77c2c727877e14afc2d31285cff89a15b5c9fd013.08928547635551e+470x77c2c727877e14afc2d31285cff89a15b5c9fd010x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:24:01.0000x01728c9f0f8624d3c43e8d691035a22229a8c028da2d18016ff38aa47edf02c08453
    19
    1075.837505540x798d81d60966d2e909468d87e7e4b6a8dafb1c360x11797ca7109a9927d3a0e0d1aa395c89a5bc3d902.07784250329431e+460x11797ca7109a9927d3a0e0d1aa395c89a5bc3d900x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:24:43.0000x9182bbd8c0df7be670698de0a880cb6b61250aa12adbd29132fffa2da827151b8453
    20
    1285.2073346270x798d81d60966d2e909468d87e7e4b6a8dafb1c360x77c2c727877e14afc2d31285cff89a15b5c9fd013.08928547635551e+470x77c2c727877e14afc2d31285cff89a15b5c9fd010x798d81d60966d2e909468d87e7e4b6a8dafb1c36crvUSDfalse2024-01-22 00:24:23.0000x378a695bba574e8c10982f1d3f5ef57609b95353b14ae22a93d1f8d74356d8ea8453
    ...
    2896
    984KB
    22s