{ "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" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "unknown_traders = pd.read_parquet(\"../data/unknown_traders.parquet\")" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
trader_addressmarket_creatortrade_idcreation_timestamptitlemarket_statuscollateral_amountoutcome_indextrade_fee_amountoutcomes_tokens_traded...is_invalidwinning_tradeearningsredeemedredeemed_amountnum_mech_callsmech_fee_amountnet_earningsroistaking
00x23522318aebb55b55879b60fb3ad4682abc6cc2fquickstart0xeeaadfc4d0ef3f3bb1c430bc96657ed01a52e3e20x23...2024-12-23 12:36:05+00:00Will any additional Amazon facilities join the...CLOSED0.40154000.0040150.939802...FalseTrue0.939802True0.93980200.00.5342471.317323non_Olas
10x8c4abc95e0091bf3bffe723d2b3c958edf642549quickstart0x6df8ac2c78c8a801d6b6f30e19d3c193daf54f1e0x8c...2024-12-24 07:22:50+00:00Will the World Health Organization issue an of...CLOSED0.29850300.0029850.624681...FalseTrue0.624681True0.62468100.00.3231931.071994non_Olas
20xb3ead49f4797662511816d2798f774dee3603185quickstart0x4cb63dbf490e1f8f7c10d1e62be7ae6bbbb6d0790xb3...2024-12-23 12:50:40+00:00Will Dominion Energy announce any additional p...CLOSED0.42305010.0042300.687175...FalseFalse0.000000False0.00000000.0-0.427280-1.000000non_Olas
30x2dd9f5678484c1f59f97ed334725858b938b4102quickstart0x005e5be235ba39c5f17622d25e77557ee79a2cba0x2d...2024-12-22 02:40:35+00:00Will the Federal Reserve signal a plan to slow...CLOSED1.56856110.0156862.474096...FalseFalse0.000000True0.00000000.0-1.584247-1.000000non_Olas
40x2dd9f5678484c1f59f97ed334725858b938b4102quickstart0x0080b3768232e8a2f187eaaf342923034275e0b90x2d...2024-12-13 04:32:35+00:00Will Russia officially confirm Bashar al-Assad...CLOSED2.67763200.0267765.135035...FalseTrue5.135035True5.13503500.02.4306270.898765non_Olas
\n", "

5 rows × 21 columns

\n", "
" ], "text/plain": [ " trader_address market_creator \\\n", "0 0x23522318aebb55b55879b60fb3ad4682abc6cc2f quickstart \n", "1 0x8c4abc95e0091bf3bffe723d2b3c958edf642549 quickstart \n", "2 0xb3ead49f4797662511816d2798f774dee3603185 quickstart \n", "3 0x2dd9f5678484c1f59f97ed334725858b938b4102 quickstart \n", "4 0x2dd9f5678484c1f59f97ed334725858b938b4102 quickstart \n", "\n", " trade_id \\\n", "0 0xeeaadfc4d0ef3f3bb1c430bc96657ed01a52e3e20x23... \n", "1 0x6df8ac2c78c8a801d6b6f30e19d3c193daf54f1e0x8c... \n", "2 0x4cb63dbf490e1f8f7c10d1e62be7ae6bbbb6d0790xb3... \n", "3 0x005e5be235ba39c5f17622d25e77557ee79a2cba0x2d... \n", "4 0x0080b3768232e8a2f187eaaf342923034275e0b90x2d... \n", "\n", " creation_timestamp \\\n", "0 2024-12-23 12:36:05+00:00 \n", "1 2024-12-24 07:22:50+00:00 \n", "2 2024-12-23 12:50:40+00:00 \n", "3 2024-12-22 02:40:35+00:00 \n", "4 2024-12-13 04:32:35+00:00 \n", "\n", " title market_status \\\n", "0 Will any additional Amazon facilities join the... CLOSED \n", "1 Will the World Health Organization issue an of... CLOSED \n", "2 Will Dominion Energy announce any additional p... CLOSED \n", "3 Will the Federal Reserve signal a plan to slow... CLOSED \n", "4 Will Russia officially confirm Bashar al-Assad... CLOSED \n", "\n", " collateral_amount outcome_index trade_fee_amount outcomes_tokens_traded \\\n", "0 0.401540 0 0.004015 0.939802 \n", "1 0.298503 0 0.002985 0.624681 \n", "2 0.423050 1 0.004230 0.687175 \n", "3 1.568561 1 0.015686 2.474096 \n", "4 2.677632 0 0.026776 5.135035 \n", "\n", " ... is_invalid winning_trade earnings redeemed redeemed_amount \\\n", "0 ... False True 0.939802 True 0.939802 \n", "1 ... False True 0.624681 True 0.624681 \n", "2 ... False False 0.000000 False 0.000000 \n", "3 ... False False 0.000000 True 0.000000 \n", "4 ... False True 5.135035 True 5.135035 \n", "\n", " num_mech_calls mech_fee_amount net_earnings roi staking \n", "0 0 0.0 0.534247 1.317323 non_Olas \n", "1 0 0.0 0.323193 1.071994 non_Olas \n", "2 0 0.0 -0.427280 -1.000000 non_Olas \n", "3 0 0.0 -1.584247 -1.000000 non_Olas \n", "4 0 0.0 2.430627 0.898765 non_Olas \n", "\n", "[5 rows x 21 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "unknown_traders.head()" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1568" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(unknown_traders)" ] } ], "metadata": { "kernelspec": { "display_name": "hf_dashboards", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.12.2" } }, "nbformat": 4, "nbformat_minor": 2 }