Updated 4 days ago
    -- forked from UFI_BSC_OrganicVolumes @ https://flipsidecrypto.xyz/edit/queries/7ebcf4cb-7b6d-4018-b224-9d26b0e40179

    with labels as(
    select *
    from values
    -- ('0xE382Fef30e57618811Ed6810b4732d3dc4B2ed79', 'MM'),
    -- ('0x14E94A27568D9fc75e2d303CECeDa8Be7b4546b4', 'MM'),
    -- ('0xeA71CE4fd4D9115023a744Ae566c94d5599123b2', 'MM'),
    -- ('0xe023457a11096269e03b5daf297cD12DCe8004cF', 'MM'),
    -- ('0x871F0E13d7D8da0820395eD30cC5b6De8FE1982c', 'MM'),
    -- ('0x2aa95Fde7C102E1869Be86eAFefBCb3bd04FEBee', 'MM'),
    -- ('0x344b00F1881a513420429eC1C354684FbC08B38F', 'MM'),
    -- ('0xC111De4c7F1Be179dc060Ea6A8D48aec33BdBefe', 'MM'),
    -- ('0xFD3d322E8D9E7edb24EeEbf2cC1Ee20Fc5Eb38D1', 'MM'),
    -- ('0xcB4e7aE324170B75A955A6A9b066FFa2F6658944', 'MM'),
    -- ('0x4238F3272729b09A0C14B6E9bBDEB79Cf351A6AD', 'MM'),
    -- ('0x8d3E17D59c90803962700B22179EE101660595C9', 'MM'),
    -- ('0x7B56BFEEAC727666F6DB78F14c18Ddd8fa380E30', 'MM'),
    -- ('0xE91e35a6db030448f57682cE80Ec06CC0937b470', 'MM'),
    -- ('0xF0A18Ea98558de206C8Ed0e0E92E84cE9AF7f969', 'MM'),
    -- ('0x1FD7d305A1cf18f2cE422614b29bb816e59981BC', 'MM'),
    -- ('0x1fff6a828dD7d0BB882064772304024812673ea7', 'MM'),
    -- ('0xaA908791999f90C1aC4b3522aca4e552B241aaA5', 'MM'),
    ----MM new
    -- ('0xaeecf5984e2d8efe27141af76c68b05ebca149ac', 'MM'),
    -- ('0x430bb77c73d80355b6d5a253e7fbcd21534b024f', 'MM'),
    -- ('0x9a2479872dc47612a4888d1888590064f9b3ebca', 'MM'),
    -- ('0x96c17876473e6b875df3c229513f60ab0f17f64d', 'MM'),
    -- ('0x0134f4394e56dcd32b5b31e1c29eec9e6df92f2b', 'MM'),
    -- ('0xe6f22bd3e45179a39c627a9c3e1ea1a345487879', 'MM'),
    -- ('0xb5a3040849a4168f7751c23e38af9a627e2eb6c3', 'MM'),
    -- ('0x679358d9fa3326fb7f6e948c0dbb71bfc42720ad', 'MM'),
    -- ('0x6efccd5014c747a9804918ed2ca6a0f15c66f96c', 'MM'),
    -- ('0x5721e543ad8eb89542ed4ffeb0951b2d02a00bec', 'MM'),
    -- ('0x7a8c931afc9415a6c820deb38550c8f3d37dec62', 'MM'),
    -- ('0x67aa933484a0c5a8c294e3628522fc5bd4cf3136', 'MM'),
    Last run: 4 days ago
    DATE
    SELLERS
    BUYERS
    ASSET_BALANCE
    BASE_BALANCE
    BASE_USD_BALANCE
    BASE_USD_VOLUME
    MIN_PRICE
    MAX_PRICE
    TOTAL_NEW_HOLDERS
    DAILY_NEW_HOLDERS
    BASE_IN
    BASE_OUT
    USD_IN
    USD_OUT
    1
    2025-04-25 00:00:00.000393755183.585987806-1.300017552-7813565.2400.015201762052099572.3151769683.615194521392.122173.12
    2
    2025-04-24 00:00:00.000102108235161.208263057-6.402917362-3780.3831540.2200.0259886113120988623.08199571329.48491307513879.9217660.3
    3
    2025-04-23 00:00:00.000106-15323.2424292830.5187297241318.2762.240.020139518840.020638848232098240.88130680010.362577076540.22222.02
    4
    2025-04-22 00:00:00.0002729-54400.2767072791.7763658061085.894079.630.017806395560.020360130142097824.2424518382.4660860322582.761496.87
    5
    2025-04-21 00:00:00.0002424102094.309836761-3.260801203-1952.895580.910.017510710490.021151322172097623.0257463256.2865475281814.013766.9
    6
    2025-04-20 00:00:00.000841403.977509569-0.04839472987-28.5596.190.020283975430.020761920672097410.057077143610.105471873533.8262.37
    7
    2025-04-19 00:00:00.0006116132.267807772-0.210774553-124.82518.90.019867230560.020767645982097310.33256397920.5433385322197.04321.86
    8
    2025-04-18 00:00:00.00073634.311463961-0.02215719761-13.1435.940.020673969290.020844139192097210.019338154540.0414953521611.424.54
    9
    2025-04-17 00:00:00.0002053328.660147882-0.1158109446-68.39223.810.020525026570.021012088812097110.13320317360.249014118177.71146.1
    10
    2025-04-16 00:00:00.00012-410.87408620.014582494758.4910.570.020637411360.020507186680.016375572760.0017930780079.531.04
    11
    2025-04-15 00:00:00.0001447708.517023482-0.268064942-156.02567.440.020272650510.020930216672097010.3520196480.62008459205.71361.73
    12
    2025-04-14 00:00:00.0001012-8609.7329670560.3190817494190.15921.5900.02119754152096920.94131033340.6222285839555.87365.72
    13
    2025-04-13 00:00:00.0008105364.024907087-0.1850783505-108.97761.790.020279937250.021309697260.55327011030.7383484608326.41435.38
    14
    2025-04-12 00:00:00.000811-5887.81811810.2120044255126.86232.60.020734907440.021215681812096770.30158781430.08958338873179.7352.87
    15
    2025-04-11 00:00:00.0001598102.278871757-0.2842805836-166.47301.310.020594657460.021044314352096020.11547523290.399755816467.42233.89
    16
    2025-04-10 00:00:00.0003829-112295.7232453973.8729042222241.2910851.410.017675432790.0240739736920958411.322135717.4492314886546.354305.06
    17
    2025-04-09 00:00:00.0002321-18748.6932104170.6035635243345.743076.580.016358225680.018523478522095422.9811322182.3775686931711.161365.42
    18
    2025-04-08 00:00:00.0002714117192.426177839-3.711438235-2073.334529.250.015705276280.019295145792095222.1988788285.9103170631227.963301.29
    19
    2025-04-07 00:00:00.000242633422.672030758-1.083197746-573.166836.280.018456132090.020745350872095035.7408703356.8240680813131.563704.72
    20
    2025-04-06 00:00:00.0002119-63118.5330641672.2699418721281.064328.440.019110352310.020669854382094754.9801503592.7102084872804.751523.69
    ...
    237
    36KB
    45s