$AAPL Option Chains - Q1–2016 To Q1–2023

Historical Daily Options Price Quotes for $AAPL between 2016 and 2023

@kaggle.kylegraupe_aapl_options_data_2016_2020

Table List

2 tables(108.1 MB)

Aapl 2016–2020

Aapl 2021–2023

Aapl 2021–2023

@kaggle.kylegraupe_aapl_options_data_2016_2020.aapl_2021_2023

37.83 MB
548163 rows
33 columns

n__quote_unixtime [QUOTE UNIXTIME]	n__quote_readtime [QUOTE READTIME]	n__quote_date [QUOTE DATE]	n__quote_time_hours [QUOTE TIME HOURS]	n__underlying_last [UNDERLYING LAST]	n__expire_date [EXPIRE DATE]	n__expire_unix [EXPIRE UNIX]	n__c_delta [C DELTA]	n__c_gamma [C GAMMA]	n__c_vega [C VEGA]	n__c_theta [C THETA]	n__c_rho [C RHO]	n__c_iv [C IV]	n__c_volume [C VOLUME]	n__c_last [C LAST]	n__c_size [C SIZE]	n__c_bid [C BID]	n__c_ask [C ASK]	n__strike [STRIKE]	n__p_ask [P ASK]	n__p_size [P SIZE]	n__p_last [P LAST]	n__p_delta [P DELTA]	n__p_gamma [P GAMMA]	n__p_vega [P VEGA]	n__p_theta [P THETA]	n__p_iv [P IV]	n__strike_distance [STRIKE DISTANCE]	n__strike_distance_pct [STRIKE DISTANCE PCT]
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1							0.000000	16 x 16	68.800000	68.950000	70	0.010000	0 x 410	0.020000	-0.00093	0.00004	0.00011	-0.00547	4.889460	68.9	0.496
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1							0.000000	1 x 1	63.750000	63.950000	75	0.010000	0 x 397	0.010000	-0.00066	0.00001	0.00061	-0.00491	4.422080	63.9	0.46
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1							0.000000	1 x 1	58.750000	58.950000	80	0.010000	0 x 612	0.010000	-0.00108	0.00009	-0.00012	-0.00455	3.984220	58.9	0.424
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1					0.000010	6.000000	53.160000	1 x 4	52.100000	55.700000	85	0.010000	0 x 396	0.010000	-0.001	0.00015	-0.00018	-0.00525	3.571790	53.9	0.388
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	0.99404	0.00067	0.00113	-0.05027	0.00173	3.969420	7.000000	47.300000	86 x 19	47.500000	50.400000	90	0.010000	0 x 403	0.010000	-0.00138	0.00014	0.00025	-0.00453	3.180820	48.9	0.352
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	0.99101	0.001	0.00171	-0.07488	0.0023	3.710680	0.000000	38.740000	4 x 1	42.300000	45.650000	95	0.010000	0 x 469	0.010000	-0.00115	0.00018	-0.00012	-0.00465	2.809120	43.9	0.316
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1						0.000000	36.400000	15 x 10	37.100000	40.650000	100	0.010000	0 x 600	0.010000	-0.00145	0.00025	-0.00017	-0.00543	2.454400	38.9	0.28
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	0.97322	0.00289	0.00355	-0.22538	0.00217	3.363840	0.000000	32.050000	1 x 1	32.600000	35.650000	105	0.010000	0 x 443	0.010000	-0.00154	0.00032	0.00022	-0.00544	2.115540	33.9	0.244
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1						0.000000	30.670000	1 x 19	27.650000	29.550000	110	0.010000	0 x 468	0.010000	-0.002	0.00042	-0.00004	-0.00512	1.788660	28.9	0.208
1656705600	2022-07-01 16:00	2022-07-01	16	138.9	2022-07-01	1656705600	1						0.000000	25.150000	19 x 125	26.900000	28.650000	111	0.010000	0 x 397	0.020000	-0.00172	0.00046	0.00038	-0.00473	1.724960	27.9	0.201


CREATE TABLE aapl_2021_2023 (
  "n__quote_unixtime" BIGINT,
  "n__quote_readtime" VARCHAR,
  "n__quote_date" VARCHAR,
  "n__quote_time_hours" DOUBLE,
  "n__underlying_last" DOUBLE,
  "n__expire_date" VARCHAR,
  "n__expire_unix" BIGINT,
  "n__dte" DOUBLE,
  "n__c_delta" DOUBLE,
  "n__c_gamma" DOUBLE,
  "n__c_vega" DOUBLE,
  "n__c_theta" DOUBLE,
  "n__c_rho" DOUBLE,
  "n__c_iv" VARCHAR,
  "n__c_volume" VARCHAR,
  "n__c_last" VARCHAR,
  "n__c_size" VARCHAR,
  "n__c_bid" VARCHAR,
  "n__c_ask" VARCHAR,
  "n__strike" DOUBLE,
  "n__p_bid" VARCHAR,
  "n__p_ask" VARCHAR,
  "n__p_size" VARCHAR,
  "n__p_last" VARCHAR,
  "n__p_delta" DOUBLE,
  "n__p_gamma" DOUBLE,
  "n__p_vega" DOUBLE,
  "n__p_theta" DOUBLE,
  "n__p_rho" DOUBLE,
  "n__p_iv" VARCHAR,
  "n__p_volume" VARCHAR,
  "n__strike_distance" DOUBLE,
  "n__strike_distance_pct" DOUBLE
);