{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import gc\n", "sns.set_style(\"darkgrid\")" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "all_trades = pd.read_parquet('../data/all_trades_profitability.parquet')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | trader_address | \n", "market_creator | \n", "trade_id | \n", "creation_timestamp | \n", "title | \n", "market_status | \n", "collateral_amount | \n", "outcome_index | \n", "trade_fee_amount | \n", "outcomes_tokens_traded | \n", "... | \n", "winning_trade | \n", "earnings | \n", "redeemed | \n", "redeemed_amount | \n", "num_mech_calls | \n", "mech_fee_amount | \n", "net_earnings | \n", "roi | \n", "staking | \n", "nr_mech_calls | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0x01274796ce41aa8e8312e05a427ffb4b0d2148f6 | \n", "quickstart | \n", "0x0dfb9821725003c4d3007999968d34d7070959ef0x01... | \n", "2024-10-27 21:51:25+00:00 | \n", "Will any mainstream U.S. news outlet publish a... | \n", "CLOSED | \n", "0.461993 | \n", "1 | \n", "0.004620 | \n", "0.734537 | \n", "... | \n", "True | \n", "0.734537 | \n", "True | \n", "0.734537 | \n", "2.0 | \n", "0.02 | \n", "0.247924 | \n", "0.509488 | \n", "non_staking | \n", "NaN | \n", "
1 | \n", "0x01274796ce41aa8e8312e05a427ffb4b0d2148f6 | \n", "quickstart | \n", "0x1082be4e429e512182089162f41b3a86a52eee370x01... | \n", "2024-10-31 22:50:15+00:00 | \n", "Will Prime Minister Shigeru Ishiba announce a ... | \n", "CLOSED | \n", "0.859939 | \n", "0 | \n", "0.008599 | \n", "2.714890 | \n", "... | \n", "False | \n", "0.000000 | \n", "False | \n", "0.000000 | \n", "8.0 | \n", "0.08 | \n", "-0.948538 | \n", "-1.000000 | \n", "non_staking | \n", "NaN | \n", "
2 | \n", "0x01274796ce41aa8e8312e05a427ffb4b0d2148f6 | \n", "quickstart | \n", "0x150f4d4e5affa7fe332684d7c828c0a471c4d5de0x01... | \n", "2024-10-29 02:21:25+00:00 | \n", "Will the Constitutional Democratic Party of Ja... | \n", "CLOSED | \n", "0.203751 | \n", "1 | \n", "0.002038 | \n", "0.305174 | \n", "... | \n", "True | \n", "0.305174 | \n", "True | \n", "0.305174 | \n", "2.0 | \n", "0.02 | \n", "0.079385 | \n", "0.351592 | \n", "non_staking | \n", "NaN | \n", "
3 | \n", "0x01274796ce41aa8e8312e05a427ffb4b0d2148f6 | \n", "quickstart | \n", "0x15edf592dc3eb67e1c163ceb6d23039710cd67fb0x01... | \n", "2024-10-28 21:59:25+00:00 | \n", "Will there be a public statement from the Bide... | \n", "CLOSED | \n", "0.412054 | \n", "1 | \n", "0.004121 | \n", "0.666936 | \n", "... | \n", "False | \n", "0.000000 | \n", "False | \n", "0.000000 | \n", "2.0 | \n", "0.02 | \n", "-0.436175 | \n", "-1.000000 | \n", "non_staking | \n", "NaN | \n", "
4 | \n", "0x01274796ce41aa8e8312e05a427ffb4b0d2148f6 | \n", "quickstart | \n", "0x187c822a330c393912398884faf8150d21b4a7840x01... | \n", "2024-10-30 00:30:45+00:00 | \n", "Will the Bank of Japan issue a public statemen... | \n", "CLOSED | \n", "0.333192 | \n", "0 | \n", "0.003332 | \n", "0.447445 | \n", "... | \n", "True | \n", "0.447445 | \n", "True | \n", "0.447445 | \n", "8.0 | \n", "0.08 | \n", "0.030922 | \n", "0.074237 | \n", "non_staking | \n", "NaN | \n", "
5 rows × 22 columns
\n", "\n", " | market_creator | \n", "trader_address | \n", "creation_date | \n", "mean | \n", "max | \n", "min | \n", "nr_trades | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-16 | \n", "2.000000 | \n", "2 | \n", "2 | \n", "1 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2024-10-15 | \n", "2.000000 | \n", "2 | \n", "2 | \n", "1 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-08-23 | \n", "2.000000 | \n", "2 | \n", "2 | \n", "1 | \n", "
3 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-04 | \n", "2.000000 | \n", "2 | \n", "2 | \n", "1 | \n", "
4 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-06 | \n", "3.454545 | \n", "5 | \n", "2 | \n", "11 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "creation_date | \n", "total_mech_calls | \n", "total_trades | \n", "mech_calls_ratio | \n", "
---|---|---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-16 | \n", "2 | \n", "1 | \n", "2.000000 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2024-10-15 | \n", "2 | \n", "1 | \n", "2.000000 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-08-23 | \n", "2 | \n", "1 | \n", "2.000000 | \n", "
3 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-04 | \n", "2 | \n", "1 | \n", "2.000000 | \n", "
4 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-06 | \n", "38 | \n", "11 | \n", "3.454545 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "total_mech_calls | \n", "total_trades | \n", "mech_calls_ratio | \n", "
---|---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2 | \n", "1 | \n", "2.0 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2 | \n", "1 | \n", "2.0 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "96 | \n", "30 | \n", "3.2 | \n", "
3 | \n", "pearl | \n", "0x03429c1ab7d9d14baa42ded8a2dd7d684fc950ed | \n", "2 | \n", "2 | \n", "1.0 | \n", "
4 | \n", "pearl | \n", "0x034c4ad84f7ac6638bf19300d5bbe7d9b981e736 | \n", "0 | \n", "114 | \n", "0.0 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "154.0 | \n", "1.592610 | \n", "1.792455 | \n", "0.0 | \n", "1.00000 | \n", "1.0 | \n", "2.000000 | \n", "13.202703 | \n", "
quickstart | \n", "157.0 | \n", "3.591079 | \n", "2.965505 | \n", "0.0 | \n", "1.09375 | \n", "3.5 | \n", "5.117788 | \n", "15.344262 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "1295.0 | \n", "1.818533 | \n", "3.947135 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "27.0 | \n", "
quickstart | \n", "25502.0 | \n", "4.243510 | \n", "4.034311 | \n", "0.0 | \n", "2.0 | \n", "4.0 | \n", "6.0 | \n", "65.0 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "total_trades | \n", "
---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "1 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "47 | \n", "
3 | \n", "pearl | \n", "0x03429c1ab7d9d14baa42ded8a2dd7d684fc950ed | \n", "2 | \n", "
4 | \n", "pearl | \n", "0x034c4ad84f7ac6638bf19300d5bbe7d9b981e736 | \n", "132 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "162.0 | \n", "9.222222 | \n", "25.013537 | \n", "1.0 | \n", "1.0 | \n", "2.0 | \n", "4.0 | \n", "202.0 | \n", "
quickstart | \n", "173.0 | \n", "162.421965 | \n", "234.143345 | \n", "1.0 | \n", "18.0 | \n", "56.0 | \n", "213.0 | \n", "1095.0 | \n", "
\n", " | request_id | \n", "request_block | \n", "prompt_request | \n", "tool | \n", "nonce | \n", "trader_address | \n", "deliver_block | \n", "error | \n", "error_message | \n", "prompt_response | \n", "... | \n", "confidence | \n", "info_utility | \n", "vote | \n", "win_probability | \n", "market_creator | \n", "title | \n", "currentAnswer | \n", "request_time | \n", "request_month_year | \n", "request_month_year_week | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2225618424541398419933635980124149566532513522... | \n", "35791858 | \n", "Please take over the role of a Data Scientist ... | \n", "prediction-offline | \n", "ab641d61-9f86-4259-a6c9-29fb94dbbd5f | \n", "0x9694c0fdb79a37d048ea19deb15e051482a690c4 | \n", "35791862 | \n", "0 | \n", "None | \n", "\\nYou are an LLM inside a multi-agent system t... | \n", "... | \n", "0.1 | \n", "0.0 | \n", "None | \n", "0.50 | \n", "quickstart | \n", "Will Iceland's cucumber supply return to norma... | \n", "Yes | \n", "2024-09-02 08:19:30 | \n", "2024-09 | \n", "2024-09-02/2024-09-08 | \n", "
1 | \n", "1148749493371728409514710538112897053025639675... | \n", "36588666 | \n", "Please take over the role of a Data Scientist ... | \n", "claude-prediction-online | \n", "940bdc48-050a-41be-809c-0cc079c5a4e2 | \n", "0xbb9ee65ce6646a6b1d6a2511b72343a7e3d355af | \n", "36588672 | \n", "0 | \n", "None | \n", "\\nYou are an LLM inside a multi-agent system t... | \n", "... | \n", "0.2 | \n", "0.1 | \n", "None | \n", "0.50 | \n", "quickstart | \n", "Will Pakistan take a first-innings lead of ove... | \n", "None | \n", "2024-10-19 19:15:40 | \n", "2024-10 | \n", "2024-10-14/2024-10-20 | \n", "
2 | \n", "1011880839868261161033272472370322925264448801... | \n", "35667678 | \n", "Please take over the role of a Data Scientist ... | \n", "prediction-request-reasoning | \n", "8974731b-93bf-46eb-b7d7-7c3d6fae3a1b | \n", "0x246f6787c409dd5139b7029cd63b7d6aad08cc61 | \n", "35667695 | \n", "0 | \n", "None | \n", "\\nHere is the user's question: Will Hurricane ... | \n", "... | \n", "0.6 | \n", "0.7 | \n", "No | \n", "0.60 | \n", "quickstart | \n", "Will Hurricane Gilma hit land by 29 August 2024? | \n", "No | \n", "2024-08-25 22:00:15 | \n", "2024-08 | \n", "2024-08-19/2024-08-25 | \n", "
3 | \n", "1152862668912527760950055055523417275018202992... | \n", "36086142 | \n", "Please take over the role of a Data Scientist ... | \n", "prediction-offline-sme | \n", "da8080f9-c92d-4cf9-9387-71974bef548d | \n", "0x3badd0a1beb34fc1532f6c717fa857b3325da184 | \n", "36086168 | \n", "0 | \n", "None | \n", "\\nYou are an LLM inside a multi-agent system t... | \n", "... | \n", "0.6 | \n", "0.0 | \n", "No | \n", "0.55 | \n", "pearl | \n", "Will Manchester City be found guilty of the 11... | \n", "No | \n", "2024-09-19 20:00:45 | \n", "2024-09 | \n", "2024-09-16/2024-09-22 | \n", "
4 | \n", "3074222847102674989172916916176718419667980583... | \n", "35854248 | \n", "Please take over the role of a Data Scientist ... | \n", "prediction-offline | \n", "99749c5f-325d-4aca-b4ec-ed4227777020 | \n", "0x9d8337b10c7b820e44ae3273dab47220ea41bfc9 | \n", "35854264 | \n", "0 | \n", "None | \n", "\\nYou are an LLM inside a multi-agent system t... | \n", "... | \n", "0.1 | \n", "0.0 | \n", "None | \n", "0.50 | \n", "quickstart | \n", "Will Lenovo release the new Copilot Plus PCs o... | \n", "No | \n", "2024-09-06 01:36:35 | \n", "2024-09 | \n", "2024-09-02/2024-09-08 | \n", "
5 rows × 23 columns
\n", "\n", " | market_creator | \n", "trader_address | \n", "total_mech_calls | \n", "
---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "282 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "142 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "223 | \n", "
3 | \n", "pearl | \n", "0x03429c1ab7d9d14baa42ded8a2dd7d684fc950ed | \n", "140 | \n", "
4 | \n", "pearl | \n", "0x04430ebfb7d088960233b7353cb4cefb528dc31e | \n", "305 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "137.0 | \n", "229.386861 | \n", "167.584932 | \n", "5.0 | \n", "132.0 | \n", "189.0 | \n", "280.0 | \n", "1037.0 | \n", "
quickstart | \n", "140.0 | \n", "933.607143 | \n", "926.353062 | \n", "5.0 | \n", "122.0 | \n", "553.0 | \n", "1703.0 | \n", "4315.0 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "total_trades | \n", "total_mech_calls | \n", "
---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2 | \n", "282 | \n", "
1 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "1 | \n", "142 | \n", "
2 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "47 | \n", "223 | \n", "
3 | \n", "pearl | \n", "0x03429c1ab7d9d14baa42ded8a2dd7d684fc950ed | \n", "2 | \n", "140 | \n", "
4 | \n", "pearl | \n", "0x04430ebfb7d088960233b7353cb4cefb528dc31e | \n", "40 | \n", "305 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "137.0 | \n", "112.477637 | \n", "118.879586 | \n", "2.50000 | \n", "50.25000 | \n", "89.000000 | \n", "150.500000 | \n", "1037.0 | \n", "
quickstart | \n", "140.0 | \n", "13.269699 | \n", "52.727037 | \n", "1.83707 | \n", "3.81075 | \n", "5.598246 | \n", "9.452414 | \n", "618.0 | \n", "
\n", " | market_creator | \n", "month_year_week | \n", "mean | \n", "median | \n", "max | \n", "min | \n", "count | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "quickstart | \n", "Aug-25 | \n", "14.069767 | \n", "11.0 | \n", "34 | \n", "1 | \n", "43 | \n", "
1 | \n", "pearl | \n", "Aug-25 | \n", "3.000000 | \n", "3.0 | \n", "8 | \n", "1 | \n", "7 | \n", "
2 | \n", "quickstart | \n", "Sep-01 | \n", "50.186667 | \n", "39.0 | \n", "193 | \n", "2 | \n", "75 | \n", "
3 | \n", "pearl | \n", "Sep-01 | \n", "11.000000 | \n", "4.0 | \n", "89 | \n", "1 | \n", "25 | \n", "
4 | \n", "quickstart | \n", "Sep-08 | \n", "45.714286 | \n", "37.0 | \n", "144 | \n", "1 | \n", "77 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "creation_date | \n", "total_trades | \n", "
---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-01 | \n", "1 | \n", "
1 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-16 | \n", "1 | \n", "
2 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2024-10-15 | \n", "1 | \n", "
3 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-08-23 | \n", "1 | \n", "
4 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-04 | \n", "1 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "creation_date | \n", "total_trades | \n", "day_id | \n", "
---|---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-01 | \n", "1 | \n", "2024-09-01 | \n", "
1 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-16 | \n", "1 | \n", "2024-09-16 | \n", "
2 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2024-10-15 | \n", "1 | \n", "2024-10-15 | \n", "
3 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-08-23 | \n", "1 | \n", "2024-08-23 | \n", "
4 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-04 | \n", "1 | \n", "2024-10-04 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "623.0 | \n", "2.398074 | \n", "2.834468 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "33.0 | \n", "
quickstart | \n", "2639.0 | \n", "10.647594 | \n", "8.860392 | \n", "1.0 | \n", "4.0 | \n", "8.0 | \n", "15.0 | \n", "74.0 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "623.0 | \n", "2.398074 | \n", "2.834468 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "33.0 | \n", "
quickstart | \n", "2639.0 | \n", "10.647594 | \n", "8.860392 | \n", "1.0 | \n", "4.0 | \n", "8.0 | \n", "15.0 | \n", "74.0 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "creation_date | \n", "total_trades | \n", "day_id | \n", "request_date | \n", "total_mech_calls | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-01 | \n", "1 | \n", "2024-09-01 | \n", "2024-09-01 | \n", "6 | \n", "
1 | \n", "pearl | \n", "0x006f70b4e3c3a3648f31ec16b2e7106fc58166f2 | \n", "2024-09-16 | \n", "1 | \n", "2024-09-16 | \n", "2024-09-16 | \n", "12 | \n", "
2 | \n", "pearl | \n", "0x01c72d0743a22b70d73c76c5e16ba7524e20e0c0 | \n", "2024-10-15 | \n", "1 | \n", "2024-10-15 | \n", "2024-10-15 | \n", "5 | \n", "
3 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-08-23 | \n", "1 | \n", "2024-08-23 | \n", "2024-08-23 | \n", "20 | \n", "
4 | \n", "pearl | \n", "0x032533005f65026fa7f360ff9a211bc94315325d | \n", "2024-10-04 | \n", "1 | \n", "2024-10-04 | \n", "2024-10-04 | \n", "11 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "289.0 | \n", "9.970581 | \n", "15.065041 | \n", "1.000000 | \n", "5.000000 | \n", "6.0 | \n", "10.0 | \n", "197.0 | \n", "
quickstart | \n", "2050.0 | \n", "8.468985 | \n", "14.026061 | \n", "0.238095 | \n", "2.316388 | \n", "4.5 | \n", "8.2 | \n", "226.0 | \n", "
\n", " | market_creator | \n", "creation_date | \n", "mean | \n", "median | \n", "max | \n", "min | \n", "count | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "pearl | \n", "2024-08-23 | \n", "37.916667 | \n", "42.333333 | \n", "47.0 | \n", "20.000000 | \n", "4 | \n", "
1 | \n", "pearl | \n", "2024-08-24 | \n", "33.660714 | \n", "20.071429 | \n", "89.5 | \n", "5.000000 | \n", "4 | \n", "
2 | \n", "pearl | \n", "2024-08-25 | \n", "44.666667 | \n", "44.666667 | \n", "85.0 | \n", "4.333333 | \n", "2 | \n", "
3 | \n", "pearl | \n", "2024-08-26 | \n", "11.962963 | \n", "9.888889 | \n", "21.0 | \n", "5.000000 | \n", "3 | \n", "
4 | \n", "pearl | \n", "2024-08-27 | \n", "17.082143 | \n", "17.082143 | \n", "29.2 | \n", "4.964286 | \n", "2 | \n", "
\n", " | market_creator | \n", "trader_address | \n", "month_year_week | \n", "total_trades | \n", "total_mech_calls | \n", "
---|---|---|---|---|---|
0 | \n", "quickstart | \n", "0x74d2b585a46279b4fa9feeae001efc972726c709 | \n", "Aug-25 | \n", "30 | \n", "105 | \n", "
1 | \n", "pearl | \n", "0x5540b853357c2c04bf02896b028c1e5a8f6a114c | \n", "Aug-25 | \n", "3 | \n", "267 | \n", "
2 | \n", "quickstart | \n", "0x0822e82311bd2d7e381bd2c64cacd13b4c3fbe8a | \n", "Aug-25 | \n", "11 | \n", "351 | \n", "
3 | \n", "quickstart | \n", "0x022b36c50b85b8ae7addfb8a35d76c59d5814834 | \n", "Aug-25 | \n", "23 | \n", "123 | \n", "
4 | \n", "quickstart | \n", "0x96fc9f4eb6b7c228aa018b7fea9b43d77023aa5a | \n", "Aug-25 | \n", "8 | \n", "123 | \n", "
\n", " | market_creator | \n", "month_year_week | \n", "mean | \n", "median | \n", "max | \n", "min | \n", "count | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "quickstart | \n", "Aug-25 | \n", "16.900132 | \n", "11.928571 | \n", "97.000000 | \n", "2.645161 | \n", "42 | \n", "
1 | \n", "pearl | \n", "Aug-25 | \n", "57.220238 | \n", "50.000000 | \n", "124.000000 | \n", "7.500000 | \n", "7 | \n", "
2 | \n", "quickstart | \n", "Sep-01 | \n", "7.875711 | \n", "4.629032 | \n", "33.722222 | \n", "1.000000 | \n", "59 | \n", "
3 | \n", "pearl | \n", "Sep-01 | \n", "19.276245 | \n", "15.000000 | \n", "54.000000 | \n", "3.250000 | \n", "15 | \n", "
4 | \n", "quickstart | \n", "Sep-08 | \n", "6.803005 | \n", "3.848101 | \n", "29.576923 | \n", "1.285714 | \n", "61 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
market_creator | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
pearl | \n", "341.0 | \n", "4.381232 | \n", "7.856515 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "89.0 | \n", "
quickstart | \n", "669.0 | \n", "42.001495 | \n", "42.564622 | \n", "1.0 | \n", "10.0 | \n", "27.0 | \n", "58.0 | \n", "193.0 | \n", "