flipside

    05 - Daily Overview
    hbd199405 - Daily Overview
    Updated 12 hours ago
    ---------------------------------------------------------- Prices -----------------------------------------------------------------

    with prices as (
    (select
    HOUR,
    case
    when TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'Eth1111111111111111111111111111111111111111'
    when TOKEN_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'
    when TOKEN_ADDRESS = 'gu7ns9xcwgnpiadj69iusfrrfawjddpjembovhv1d4kn' then 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'
    when TOKEN_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'
    when TOKEN_ADDRESS = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' then '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji'
    when TOKEN_ADDRESS = '0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88' then 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'
    when TOKEN_ADDRESS = 'So11111111111111111111111111111111111111112' then 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'
    when TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' then '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'
    when TOKEN_ADDRESS = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' then '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'
    when TOKEN_ADDRESS = 'ezSoL6fY1PVdJcJsUpe5CM3xkfmy3zoVCABybm5WtiC' then 'Fu5P5ikrnQ8BKZECJ1XeeDAaTgWJUrcjw8JmFrNA8TJk'
    when TOKEN_ADDRESS = 'kySo1nETpsZE2NWe5vj2C64mPSciH1SppmHb4XieQ7B' then '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP'
    when TOKEN_ADDRESS = '0x04c154b66cb340f3ae24111cc767e0184ed00cc6' then '6AjQBsySS1FtQmA7a4oYc6GYpHBTDqtSswptsVSTz3Tv'
    when TOKEN_ADDRESS = 'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9' then 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'
    when TOKEN_ADDRESS = 'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877' then '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'
    when TOKEN_ADDRESS = 'hgd4dc6qycj3uanmdiuc4qanheetsavk6dy91b3f8gnl' then 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
    when TOKEN_ADDRESS = 'laihkxa47apns599tyeyasy2refezbne4heunanhsmx' then 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx'
    when TOKEN_ADDRESS = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn' then 'JAh5pFYn1Kbh7kCuqZab8viVFdNgTmpS6hzFstSGNBvG'
    end as token_address_on_eclipse,
    case
    when SYMBOL = 'WETH' then 'ETH'
    when SYMBOL = 'TETH' then 'tETH'
    when SYMBOL = 'WEETHS' then 'weETHs'
    when SYMBOL = 'STTIA' then 'stTIA'
    when SYMBOL = 'KYSOL' then 'kySOL'
    when SYMBOL = 'EZSOL' then 'ezSOL'
    when SYMBOL = 'PXETH' then 'apxETH'
    when SYMBOL = 'JITOSOL' then 'JitoSOL'
    else symbol end as token_symbol,
    PRICE
    from crosschain.price.ez_prices_hourly
    Last run: about 12 hours agoAuto-refreshes every 12 hours
    Date
    Bridge Actions
    Unique Users
    Bridge Volume
    Inbound Actions
    Outbound Actions
    Inbound Volume
    Outbound Volume
    Net Flow
    Inbound Users
    Outbound Users
    Cumulative Bridge Volume
    1
    		2024-08-19 00:00:00.0006666949.986685738660949.9866857380949.986685738660949.986685738
    2
    		2024-08-26 00:00:00.0006686529990.28125790766809990.28125790709990.281257907652010940.267943645
    3
    		2024-09-02 00:00:00.00043242010330.734951189432010330.734951189010330.734951189420021271.002894835
    4
    		2024-09-09 00:00:00.00054549422660.912574657545022660.912574657022660.912574657494043931.915469492
    5
    		2024-09-16 00:00:00.000401818961938584.489441932227961047914.09327704890670.396164861157243.69711217818963831982516.40491139
    6
    		2024-09-23 00:00:00.0001148149503922912.79394453859328882062534.057116861860378.73682767202155.32028919490014345905429.19885592
    7
    		2024-09-30 00:00:00.0001491451368525274.95719041018547294321156.77845514204118.17873531117038.5997197875066219714430704.1560463
    8
    		2024-10-07 00:00:00.0001378244916435779.74119696950542773313935.770358153121843.97083881192091.7995193474356214420866483.8972433
    9
    		2024-10-14 00:00:00.00045560306706300646.506547824050250583912998.230570372387648.275977451525349.9545929230483333127167130.4037911
    10
    		2024-10-21 00:00:00.00076287585837617136.229572017025760305382809.681599982234326.547972033148483.1336279558160395034784266.6333631
    11
    		2024-10-28 00:00:00.00034325140547956567.282648652798263435232500.775529852724066.507118812508434.2684110413120411542740833.9160118
    12
    		2024-11-04 00:00:00.000447631879019712031.567476335435932812944181.40812276767850.15935366176331.2487690617888531362452865.483488
    13
    		2024-11-11 00:00:00.0003862123339113506556.647501301838438103706502.4680059800054.1794969393906448.2885076220825400175959422.130989
    14
    		2024-11-18 00:00:00.000382472291922420043.619824629298894913581086.17280398838957.447020754742128.72578314217245975198379465.750814
    15
    		2024-11-25 00:00:00.000333761874121577794.694895524543883313967621.00543067610173.689464896357447.31596572175556266219957260.44571
    16
    		2024-12-02 00:00:00.000241831226918646889.652117115735844811203517.7522847443371.89983313760145.85245092103575853238604150.097827
    17
    		2024-12-09 00:00:00.000424602374833535641.4406037316691079119669455.137470713866186.3031335803268.83433771219987334272139791.538431
    18
    		2024-12-16 00:00:00.000647323733835746176.7976595501071462522243869.459481213502307.33817848741562.12130279352939640307885968.33609
    19
    		2024-12-23 00:00:00.0001437548781957566015.72917311192362451837254296.155187520311719.573985716942576.58120188514315844365451984.065263
    20
    		2024-12-30 00:00:00.0001343478393254985404.16973631078702647732185415.247521222799988.92221519385426.325306058065516752420437388.234999
    36
    5KB
    96s