flipside

    yearling-coral
    Mrftiyearling-coral
    Updated 4 days ago
    select *
    --ORIGIN_FROM_ADDRESS as "Borrower",
    --count (distinct tx_hash) as "Total Flashloans",
    --sum (FLASHLOAN_AMOUNT_USD) as "Total Flashloan (USD)"
    from avalanche.defi.ez_lending_flashloans
    order by 1 desc
    limit 100

    select distinct CONTRACT_ADDRESS
    --ORIGIN_FROM_ADDRESS as "Borrower",
    --count (distinct tx_hash) as "Total Flashloans",
    --sum (FLASHLOAN_AMOUNT_USD) as "Total Flashloan (USD)"
    from avalanche.defi.ez_lending_flashloans
    order by 1 desc
    limit 100

    select *
    from avalanche.core.fact_token_transfers
    where tx_hash = '0xeb508578395639b317f7f1de90d600b77c6f01763641eca3022156afa96c9f85'

    Last run: 4 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    CONTRACT_ADDRESS
    EVENT_NAME
    EVENT_INDEX
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    PLATFORM
    INITIATOR
    TARGET
    PROTOCOL_MARKET
    FLASHLOAN_TOKEN
    FLASHLOAN_TOKEN_SYMBOL
    FLASHLOAN_AMOUNT_UNADJ
    FLASHLOAN_AMOUNT
    FLASHLOAN_AMOUNT_USD
    PREMIUM_AMOUNT_UNADJ
    PREMIUM_AMOUNT
    PREMIUM_AMOUNT_USD
    EZ_LENDING_FLASHLOANS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		588192772025-03-16 20:20:46.0000xeb508578395639b317f7f1de90d600b77c6f01763641eca3022156afa96c9f850x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan360x42b0b77c0x9af8c1a59f255382dbff637300cb926458e088ec0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC92251364099225.1364099224.2000af1d85c19cf6cf102e4efbe095e21a242025-03-16 21:39:14.8852025-03-16 21:39:14.885
    2
    		588191152025-03-16 20:15:46.0000x6b6fb0932c403265456a2b18b8b7b1460375d2788bb4e3e4f28e7e9f9639d10a0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan710x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC200000000200199.980006157d3a633f1b492957649a8e56b008e2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    3
    		588188992025-03-16 20:08:36.0000x814b035ff19d62f742ba68f391afefeb545082c9e4077fa82ca2e42168e00a5b0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan360x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC10000000010099.990006636a58c46613ffebc0d92b77df7d9ab2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    4
    		588179762025-03-16 19:39:30.0000x482332d367ea25eeb7e45ff6e5c19196e9201bd18342ce3d498ad5c474b472fe0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan350x9304c9340xd716b9a8429a812de9d99a4d46ce929593a318440x510349bd5ab5c18cccd824ecddb791ae669b3b11Aave V30x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c70x352423e2fa5d5c99343d371c9e3bc56c87723cc70x6ab707aca953edaefbc4fd23ba732942414906200x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7USDt300000000300299.9900010092ce101dd6272ee587c62432226f62025-03-16 21:39:14.8852025-03-16 21:39:14.885
    5
    		588178572025-03-16 19:35:52.0000xab1d306efb517c8b0f1714a0f4c45a3f3df8257db5914c21b745bd6c07fddb570x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan340xb8bd1c6b0x9ec34414ec6626c2c1b99ad34ed2d55d105a149b0xe28e2c8d240dd5ebd0adcab86fbd79df7a052034Aave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xe28e2c8d240dd5ebd0adcab86fbd79df7a0520340x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC10063379381006.3379381006.220.0000020f37caa92cf04bf5cdd9b57c93c33f02a2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    6
    		588163162025-03-16 18:49:05.0000xe6f250956b833f5a152542c3d062a45ffd5a40040519346fe8bdcc98421cf2c10x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan390x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC500000005049.9900050ba3af25fb531fda10039056400fc8a2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    7
    		588138592025-03-16 17:30:48.0000x128949915d5d270390b3aa715acb22dbc36ba2dda40b8fa5b900d0bbc1734d380x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan760x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC250000002525000b409555f7707c666b92b7a8fc5b76b412025-03-16 21:39:14.8852025-03-16 21:39:14.885
    8
    		588137592025-03-16 17:27:52.0000x5d1f4f9c58f59c9f9a660176ba58881c0db3ca9181065fc5ee87c15b23c190220x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan360x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC25000000252500031e0640a03a12034ad1c1bb4b691d6402025-03-16 21:39:14.8852025-03-16 21:39:14.885
    9
    		588137352025-03-16 17:27:12.0000xda903874d8ca9d77a728db0f3adbb4d139a2d05b8fd0e43fbb159dd484984fb90x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan530x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC2500000025250003c4e54b1e7e9857d71d283933619e9882025-03-16 21:39:14.8852025-03-16 21:39:14.885
    10
    		588135902025-03-16 17:22:30.0000x15b61d91543415444519c5e5be085443008d8633133c0d1f58a3c80f95f393620x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan380x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC2500000025250005823e3d737098264f3bc7e9b0b0648412025-03-16 21:39:14.8852025-03-16 21:39:14.885
    11
    		588134982025-03-16 17:19:26.0000x229720e46ba5a177ad4cd489e533277222c1ae1f869c24578abed0b0389feaf30x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan720x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC2500000025250008cacefbc6c2cfbaf0d30edc33cd737fb2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    12
    		588134842025-03-16 17:18:59.0000x2a73540fc9213c36cda0c0b1015874e5e423ca802cc10cd7fe7d16482d2c4d8c0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan340x42b0b77c0x60a71287353f3ac632f3e75fd1be532850aa5f4d0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC250000002525000cd1563d74efcf6f5bfb10ad59f5e76052025-03-16 21:39:14.8852025-03-16 21:39:14.885
    13
    		588122912025-03-16 16:44:16.0000xfa22cb203c097013747f2183039aee7a811407819b05d042026203e81e2dcbf00x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan540xb8bd1c6b0x712e2115b405cfe46b472940a5d0e4ec0b42d5cb0xe28e2c8d240dd5ebd0adcab86fbd79df7a052034Aave V30xb31f66aa3c1e785363f0875a1b74e27b85fd66c70xe28e2c8d240dd5ebd0adcab86fbd79df7a0520340x06a193ab7c879853e65801c259da2b20dde5f0a10xb31f66aa3c1e785363f0875a1b74e27b85fd66c7WAVAX20432316604527840002.0432316637.6222e-1807f4007105da1b90b198994c7d53203532025-03-16 21:39:14.8852025-03-16 21:39:14.885
    14
    		588115312025-03-16 16:24:21.0000x73d28b389ac5027577784c8dc537c788eeaf1f0c63d7817cbe00a9aa08a7a3d80x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan870xace0fd1a0xda9f21d645bd2c2da7e3d1038953e2087378e7d30x14843971c9918b5f762c309ac21bc2554981ec9dAave V30xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x14843971c9918b5f762c309ac21bc2554981ec9d0x06a193ab7c879853e65801c259da2b20dde5f0a10xb31f66aa3c1e785363f0875a1b74e27b85fd66c7WAVAX1098387911.09838791e-10000064fe8ac8b317a75ebdaea924f02f778f2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    15
    		588113792025-03-16 16:20:53.0000x9c8589607dfcbf3256f2280df290a527fd18b4fd1558efba41b87dc3e91419190x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan360x42b0b77c0x23622a177964888665beb695fff7d5da169d181a0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a0x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC150000000150149.97000a6159f4b4574c9e63dc1da2bbbbb3c692025-03-16 21:39:14.8852025-03-16 21:39:14.885
    16
    		588113302025-03-16 16:19:30.0000xcb9c0ca184015f983601261e5032d54bd92b9e49dff4163e940bb04e22641f0c0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan320xb8bd1c6b0xee1d92ed36721ee4a24ada4359169f1634871d8b0xe28e2c8d240dd5ebd0adcab86fbd79df7a052034Aave V30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xe28e2c8d240dd5ebd0adcab86fbd79df7a0520340x625e7708f30ca75bfd92586e17077590c60eb4cd0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eUSDC8153407781.53407781.5220.0000020557b22519ef34d3b2fd59d02c1562c2b2025-03-16 21:39:14.8852025-03-16 21:39:14.885
    17
    		588100052025-03-16 15:40:28.0000xab5e40488d37aed085b2934fbfe92fd229786718caa748c00f8baaad000afafd0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2cFlashLoan240x000000020xf1d5681ae7ffce035247c0335241f01850241b7b0xa40f5f28975d65a6d4c9b75af5c64909a4498dd9Aave V20xa40f5f28975d65a6d4c9b75af5c64909a4498dd90xa40f5f28975d65a6d4c9b75af5c64909a4498dd90x06a193ab7c879853e65801c259da2b20dde5f0a10xb31f66aa3c1e785363f0875a1b74e27b85fd66c7WAVAX29544293515869300002.95442935254.1326589864164282370.0026589864160.05d3195942c99d520167d14be9137a23e52025-03-16 21:39:14.8852025-03-16 21:39:14.885
    18
    		588081642025-03-16 14:45:26.0000xa021d63965b613f84451fc7245f35df7445cbf442234b08dd8f048357d7472600x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan300xb8bd1c6b0xa4a6485e48d955537825c2cf268ce41bab91af580xe28e2c8d240dd5ebd0adcab86fbd79df7a052034Aave V30x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c70xe28e2c8d240dd5ebd0adcab86fbd79df7a0520340x6ab707aca953edaefbc4fd23ba732942414906200x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7USDt72010995727201.0995727200.7320.00000200cc71695f7ae9854f4c89c55fa0106d02025-03-16 20:39:17.2632025-03-16 20:39:17.263
    19
    		588079182025-03-16 14:37:54.0000xb314ca6795901f87cbab328f280903957b66eb4032b3e1eafb4d437c64235e220x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan380x42b0b77c0xd4ab116da1f689ee9d45fddf8352c77d95061eba0x794a61358d6845594f94dc1db02a252b5b4814adAave V30xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x5d4d4007a4c6336550ddaa2a7c0d5e7972eebd160xdfe521292ece2a4f44242efbcd66bc594ca9714b0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7WAVAX1646132063693426000016.461320637305.36000161ac039f70093817a9368b2b649b8782025-03-16 20:39:17.2632025-03-16 20:39:17.263
    20
    		588075082025-03-16 14:25:01.0000xdea3df1c52621e44de5efb3969353052b832104d973f44a939c739d694021f6d0x794a61358d6845594f94dc1db02a252b5b4814adFlashLoan250xb8bd1c6b0xe921a6d1cbc0369e9ec7970990c838d9931440830xe28e2c8d240dd5ebd0adcab86fbd79df7a052034Aave V30x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c70xe28e2c8d240dd5ebd0adcab86fbd79df7a0520340x6ab707aca953edaefbc4fd23ba732942414906200x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7USDt113867271483113867.271483113861.4620.00000208c96d9ae2595e1ff55b4e13b2e33b2b02025-03-16 20:39:17.2632025-03-16 20:39:17.263
    100
    58KB
    2s