flipside

    003 - swap overview
    StangFAST003 - swap overview
    Updated 2024-02-13
    -- forked from 01 - swap overview - chart @ https://flipsidecrypto.xyz/edit/queries/c5c10e93-9ac5-474d-b3fe-ea1e4dcded04

    -- forked from 01 - total supply og HON @ https://flipsidecrypto.xyz/edit/queries/e267be9f-72a0-4d1d-b6de-27eb0efbe375

    -- forked from 01 - hon @ https://flipsidecrypto.xyz/edit/queries/73d19a4b-154a-4b69-ac6d-1c0e7d31c172

    with

    hon AS
    (
    SELECT
    a.address AS address
    , a.symbol AS symbol
    , a.name AS name
    , a.decimals AS decimals
    FROM
    avalanche.core.dim_contracts a
    WHERE
    a.address = lower( '0xEd2b42D3C9c6E97e11755BB37df29B6375ede3EB' )
    )
    ,
    hon_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price_usd
    , a.symbol AS token
    FROM
    avalanche.price.ez_hourly_token_prices a
    INNER JOIN
    hon b
    ON a.token_address = b.address
    GROUP BY 1 , 3
    ORDER BY 1 DESC
    )
    ,
    Last run: about 1 year ago
    date
    users
    transactions
    usd volume
    total users
    total transactions
    total usd volume
    1
    		2024-01-01 00:00:00.0005722831239779.866547532630911988514841519.9391524
    2
    		2023-12-01 00:00:00.00010522927475582.933032942573711705414601740.0726049
    3
    		2023-11-01 00:00:00.0002763096102174.9667070352468511412714126157.1395719
    4
    		2023-10-01 00:00:00.000135302535560.2695210362440911103114023982.1728649
    5
    		2023-09-01 00:00:00.000110286939728.2744915482427410800613988421.9033439
    6
    		2023-08-01 00:00:00.000150295643315.5312770472416410513713948693.6288523
    7
    		2023-07-01 00:00:00.000162298344028.2140319542401410218113905378.0975753
    8
    		2023-06-01 00:00:00.000172251436030.570664127238529919813861349.8835433
    9
    		2023-05-01 00:00:00.000255166980181.520035263236809668413825319.3128792
    10
    		2023-04-01 00:00:00.0004391769140527.723901887234259501513745137.7928439
    11
    		2023-03-01 00:00:00.0002312987239533.226624778229869324613604610.068942
    12
    		2023-02-01 00:00:00.0003292987236138.141973494227559025913365076.8423172
    13
    		2023-01-01 00:00:00.0002383279212788.192378402224268727213128938.7003438
    14
    		2022-12-01 00:00:00.0001592649115947.232430528221888399312916150.5079654
    15
    		2022-11-01 00:00:00.0002622600231781.544098255220298134412800203.2755348
    16
    		2022-10-01 00:00:00.0003083405304468.912834936217677874412568421.7314366
    17
    		2022-09-01 00:00:00.0002852013156676.005689598214597533912263952.8186016
    18
    		2022-08-01 00:00:00.0004313376317919.331611256211747332612107276.812912
    19
    		2022-07-01 00:00:00.0004894731228270.949798958207436995011789357.4813008
    20
    		2022-06-01 00:00:00.0006887177271625.867056197202546521911561086.5315018
    24
    2KB
    23s