flipside

    Daily Stats By Token
    flyingfishDaily Stats By Token
    Updated 7 hours ago
    -- forked from Daily Stats @ https://flipsidecrypto.xyz/edit/queries/6f2cf700-243f-4004-a88f-29a8265ac256

    /* with cte1 AS (
    SELECT live.udf_api(
    'https://ipfs.io/ipfs/QmTnw8jdV9epXTYGWtP9nFCH1BtuXYRQp6FECcVNi3kuuE'
    ) AS response
    ) */
    with get_data AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    { 'Content-Type': 'application/json' },
    {
    'sheets_id' : '1QMy-OCO8NFtb7chUXcAvWARPkgpvmK9Y5K0tXpMEGUI',
    'tab_name' : 'byToken'
    }
    ) as response
    )
    , my_data AS (
    SELECT
    value:date_str::date AS date
    , value:positionMint::string AS pool_mint
    , value:pool_token AS pool_token
    , value:increase_calls::integer AS increase_calls
    , value:inc_users::integer AS inc_users
    , value:opens::integer AS opens
    , value:add_collateral_actions::integer AS add_collateral_actions
    , value:added_collateral::float AS added_collateral
    , value:long_collateral::float AS long_collateral
    , value:short_collateral::float AS short_collateral
    , value:increase_fees_usd::float AS increase_fees_usd
    , value:positions::integer AS positions
    , value:longs::integer AS longs
    , value:shorts::integer AS shorts
    , value:inc_position_size_usd::float AS inc_position_size_usd
    Last run: about 7 hours ago
    DATE
    POOL_MINT
    POOL_TOKEN
    INCREASE_CALLS
    INC_USERS
    OPENS
    ADD_COLLATERAL_ACTIONS
    ADDED_COLLATERAL
    LONG_COLLATERAL
    SHORT_COLLATERAL
    INCREASE_FEES_USD
    POSITIONS
    LONGS
    SHORTS
    INC_POSITION_SIZE_USD
    INC_LONG_POSITION_SIZE_USD
    INC_SHORT_POSITION_SIZE_USD
    DECREASE_CALLS
    REDUCE_COLLATERAL_ACTIONS
    FULL_CLOSE_ACTIONS
    DECREASE_LONG_ACTIONS
    DECREASE_SHORT_ACTIONS
    REMOVED_COLLATERAL
    DECREASE_FEES_USD
    USD_SENT
    DEC_POSITION_SIZE_USD
    DEC_LONG_POSITION_SIZE_USD
    DEC_SHORT_POSITION_SIZE_USD
    NET_REALIZED_PROFIT
    NET_REALIZED_LOSSES
    LIQUIDATION_CALLS
    LONG_LIQUIDATIONS
    SHORT_LIQUIDATIONS
    LIQUIDATION_FEES_USD
    LIQUIDATION_COLLECTED_COLLATERAL
    LIQUIDATED_POSITION_SIZE
    LIQUIDATED_LONG_SIZE
    LIQUIDATED_SHORT_SIZE
    LIQ_PNL_DELTA
    TRADERS_NET_PNL
    TOTAL_FEES
    JUP_PNL
    JUP_PNL_2
    DAILY_VOLUME
    DAILY_OI_DELTA
    OPEN_INTEREST
    LONG_OI_DELTA
    LONG_OI
    LONG_OI_RATIO
    SHORT_OI_DELTA
    SHORT_OI
    JUP_PERPS_VOLUME_7_DAY_AVG
    JUP_PERPS_FEES_7_DAY_AVG
    JUP_PERPS_ACTIONS_7_DAY_AVG
    CUMULATIVE_PNL
    CUM_INC_POSITION_SIZE_USD
    CUM_DEC_POSITION_SIZE_USD
    CUM_LIQ_POSITION_SIZE_USD
    DELTA_POSITION_SIZE_USD
    OPEN_POSITION_SIZE_USD
    1
    		2023-11-01 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		1110499.96020499.960245.455310145455.276045455.276000000000000000000000045455.27645455.27647707.757201670.52460.0350157856545455.27646037.232410289.8872142863.57180494.021220568.754312217.509745455.27647707.7572
    2
    		2023-11-01 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		812577427043.851612062.075314981.7763583.1356364239578736.1976294474.8641284261.333651249331823572.4272464.852623572.4272418923.3355244029.8926174893.44311229.25041255.6504167983.3832194.9178931.118728353.620150577.49863476.99061076590.651880881.7434126762.351822091.351456842.09890.448414675958790.39269920.2527233134.921057143611334758.0684976948.7523231046.964380881.7434126762.3518
    3
    		2023-11-02 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		554054116842.71614436.20142406.5147221.3057433520220627.796981292.7017139335.09522602618814593.9352103.447914593.935299741.776366919.281232822.495189.7469167.50675323.19679.60912900.652336.0509564.59932.6228323270.2232117985.3706121311.49212037.369615149.30420.1248793824105948.0011106162.18849080.79415714315.142260285.416124856.211814117.7122117985.3706121311.492
    4
    		2023-11-02 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		433743021007.266119911.96561095.3005232.3297382716232108.5839177604.016754504.56721401495994.376729.3033994.376728172.356926132.38572039.971315.2167310.096343157.5716185.136754686.02769230.751645455.276304.0188314966.9684149250.1994196957.9566142240.8794143911.4040.73067067967009.319953046.552354589.17564285711.857312602.605148741.111266903.5373149250.1994196957.9566
    5
    		2023-11-02 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		1864688181351162068.2139118656.403243411.81074769.030986212366284751002.5243322842.3691428160.15696080880592368102329.45362810.6247102329.45362763893.1091941181.084822712.024516462.69696351.99513732681051559.67063860.87011540320.4191112855.3427465.118720586.34949055216.052446788.996573551.3478268805.985325648.08390.5677749432177983.0128247903.26551525973.4523516.1426085760.59243740841.86131771367.3833446788.996573551.3478
    6
    		2023-11-03 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		13465129515084.63869947.145137.4986540.3706779242520908.8659274825.2006246083.665279475493012707.444420.702512707.444390962.8155178067.5674212895.24812238.665297.032853127.5873385.4225110705.13911898.42998806.711106.75441022576.820419240.9114140552.403484859.2042100008.50840.7115389419-65618.292940543.8951195118.41714285746.428781194.2819515819.0273124822.851219240.9114140552.4034
    7
    		2023-11-03 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		10768105237349.817234158.20663191.6106481.946717136481780.2292378074.5083103705.720965362412430585.6212479.904730585.6212358992.2816249985.1895109007.09211965.5665527.6726104657.8191126.626540714.93954172.683636542.256492.897881487.450382073.0081279030.9647123916.6352267828.03920.9598506011-41843.627211202.9251180514.91648571437.285794382.8343407733.3928107618.476882073.0081279030.9647
    8
    		2023-11-03 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		30818512934147555963.3787361110.5062194852.872511034.885811221799128210709668.595626606.0395083062.5551499881411837662433997.13728381.7044433997.13727746958.3034021586.0613725372.24243986.439818921.65344072291782125.02745636.54242018880.702890670.25881128210.44419794.711920475507.595943829.5849999991517380.9328714349.71921039997.80310.6853900564229479.869477383.13454446999.539914291224.71416795429.182411487800.16433790248.0853943829.5849999991517380.9328
    9
    		2023-11-04 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		966594219481.428117355.51142125.9167362.202696630338941.6139248422.120990519.49357156391811923.3953405.675811923.3953330674.7413243868.385986806.3554769.5727737.053990943.2581136.443538890.0822038890.0822280.036708506.4374-30623.2096109929.19384553.735104562.24340.9511781155-35176.94465366.9505295556.72831428668.8571120135.8958846493.7686163712.9334-30623.2096109929.1938
    10
    		2023-11-04 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		77547617792.17446114.00291678.1715228.3766575720220518.8356123559.107896959.7277492474099071.0755254.84099071.0755141216.9724132952.29668264.6757633.14558.929130324.25287.772723211.266023211.266135.9873384947.07456090.5972335121.5619-9393.1888258434.85040.7711674865483.78676686.7111235389.036157143551014901.6699548950.3652130829.742856090.5972335121.5619
    11
    		2023-11-04 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		26017772432169498720.0051317352.3525181367.65269727.28541013159610059478667.3785355469.7484123197.6315142341280984530487688.88669040.5945487688.88667593201.8514752656.2382840545.61470486.089823033.83453651432221839.86445453.22311704094.616635210.06171068884.55420598.863218775963.845181370.9110000011698751.8438-32396.55171007601.25140.5931421091213767.462691150.59657127799.044385721862.57126274096.560419081002.01535494342.7013181370.9110000011698751.8438
    12
    		2023-11-05 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		12868125320855.716214495.83046359.8858716.2837788246714101.5657460175.669253925.896769366541515673.1376435.819615673.1376340389.36215687.3788124701.9811378.9815556.83881798219.8886706.867195940.4585147132.708648807.74991135.59371250431.3842177771.7472287700.94197355.5816201917.8250.701832341280416.165785783.1162474127.918899.2851834237.46151186883.1286359653.3919177771.7472287700.941
    13
    		2023-11-05 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		2361222261035939.191629228.80256710.3891798.117513417165748181.2145594092.8164154088.39811353132973836705.1124921.362436705.1124626198.0921462661.3367163536.75533286.7761106.900420911111.0511286.748897907.850877350.828520557.02231192.58881472287.157424075.2716359196.833554080.6512312515.50160.8700396898-30005.379546681.3316443516.4041110.2851763082.88441175148.4573228737.593624075.2716359196.8335
    14
    		2023-11-05 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		23777252239138371748.4946230544.9647141203.52997639.432695215028757278725.7483962982.1233315743.62613532111142794559341328.74756936.1044341328.74755862182.9582913756.8872948426.07129772.569718020.28393752291461541.76593796.52481344755.211746809.201597946.010113598.353514485663.91771787.5791770539.4228302416.0351310017.28640.7398972706-230628.4551460522.14149193818.802328572446.57133552822.308424943184.97336839097.912371787.5791770539.4228
    15
    		2023-11-06 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		915291016697.986612384.45644313.5302483.6576615437447216.1679337319.2159109896.95264064323216500.7427445.522216500.7427362568.3014201741.3994160826.9021345.1403299.838990183.9149512.3439152907.0918152907.09180947.0017962691.5611-68259.2253219441.7157-17329.2753184588.54970.8411734711-50929.9534853.1662611614.518614286122.5712281453.62941549451.43512560.4837-68259.2253219441.7157
    16
    		2023-11-06 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		1026398413309.64348632.10314677.5403410.5567667824374711.4473233060.8205141650.626781675602119120.7455602.964919120.7455356855.9643248549.3548108306.60951990.4678585.625118389.1519299.773985300.11513627.127671672.9875567.1733816867.5266-67444.632291752.2015-29115.6619283399.83970.9713717266-38328.97038352.3613559531.017042857137.7142137794.33171532004.4216314037.7086-67444.632291752.2015
    17
    		2023-11-06 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		19765871858118371064.9557231191.2125139873.74327995.203977511937837720196.5384452807.3853267389.15311711551016699472335041.3157988.995335041.3156462595.9833599893.6332862702.3530619.231216038.25382581471111578.26163287.15131202718.031709410.4495493307.581516088.698415385510.55254882.5241825421.9468143503.30251453520.58890.7962655382-88620.7785371901.362911372199.81012862921.85741273018.846431405780.95638041815.943354882.5241825421.9468
    18
    		2023-11-07 00:00:00.0003NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    BTC
    		14288139329135.194416480.708812654.4855493.4718969844473555.4815238824.3221234731.159488583612714900.9634462.242514900.9634347425.3741196391.281151034.09321129.5983277.01951275206.5157490.9915157774.6315104093.877453680.7541041.9201978755.4871-31644.5241187797.1916-61660.8363122927.71340.654576952730016.312264869.4784750875.161628571156.2852755009.11091896876.8041670335.1152-31644.5241187797.1916
    19
    		2023-11-07 00:00:00.0007vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    ETH
    		10661104215350.54228938.63146411.9108590.8057648224524319.8046322954.7668201365.0379621052451712285.8273542.464212285.8273310776.512224480.287786296.22431280.3851759.430516151178.6598434.838126005.692535113.616990892.0756860.3374961102.009187537.6001379289.801663360.8622346760.70190.914236819524176.73832529.0993696730.494542857163.1422662114.13631842780.9336440043.401187537.6001379289.8016
    20
    		2023-11-07 00:00:00.000So11111111111111111111111111111111111111112
    SOL
    		28047812672132634234.6619384768.9149249465.74713125.100710641694111012453938.957104479.3385349459.609175519715581128627548865.845312327.1713548865.845310391556.786058679.234332877.55285519.099721460.68833681672011622.30074091.83341517387.452786977.9091730409.542619944.713624362883.182544994.7182370416.6648258822.19891712342.78780.7223805052286172.5144658073.877314802476.5421143360753726957.796441797337.73639559203.3953544994.7182370416.6648
    ...
    1700
    1MB
    6s