$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 2016–2020

@kaggle.kylegraupe_aapl_options_data_2016_2020.aapl_2016_2020

70.27 MB
1015352 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__dte [DTE]	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_rho [P RHO]	n__p_iv [P IV]	n__p_volume [P VOLUME]	n__strike_distance [STRIKE DISTANCE]	n__strike_distance_pct [STRIKE DISTANCE PCT]
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	0.908860	0.000190	0.017090	-0.100400	0.000740	3.253140	13.000000	57.200000	139 x 91	57.700000	58.100000	100	0.020000	0 x 300	0.010000	-0.000340	0.000110	0.000790	-0.005090	-0.000410	1.625550	0.000000	57.9	0.367
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	150 x 100	52.500000	52.960000	105	0.010000	0 x 300	0.010000	-0.000690	0.000100	0.000390	-0.005180	-0.000100	1.461900	200.000000	52.9	0.335
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	146 x 94	47.450000	47.790000	110	0.010000	0 x 412	0.040000	-0.000660	0.000200	0.000000	-0.004250	-0.000090	1.305490	706.000000	47.9	0.303
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000		6.000000	36.590000	31 x 100	40.700000	44.640000	115	0.010000	0 x 397	0.010000	-0.001200	0.000210	0.000890	-0.004340	-0.000050	1.155130	0.000000	42.9	0.272
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000		2.000000	35.450000	21 x 21	35.710000	39.610000	120	0.010000	0 x 457	0.010000	-0.001090	0.000240	0.000450	-0.004290	-0.000200	1.010620	0.000000	37.9	0.24
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	52 x 104	34.690000	38.450000	121	0.020000	0 x 467	0.000000	-0.000750	0.000300	0.000370	-0.004560	0.000000	0.981970		36.9	0.234
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	100 x 105	33.650000	37.450000	122	0.000000	0 x 413	0.000000	-0.001200	0.000270	0.000260	-0.004770	-0.000450	0.953780		35.9	0.227
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	100 x 100	32.710000	36.700000	123	0.000000	0 x 455	0.000000	-0.000840	0.000350	0.000410	-0.004850	-0.000070	0.925600		34.9	0.221
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000			0.000000	26 x 101	31.800000	35.410000	124	0.010000	0 x 439	0.010000	-0.001330	0.000330	0.000950	-0.004190	-0.000230	0.897580	0.000000	33.9	0.215
1546462800	2019-01-02 16:00	2019-01-02	16	157.92	2019-01-04	1546635600	2	1.000000	0.000000	0.000000	0.000000	0.000000		1.000000	26.640000	34 x 34	30.700000	33.700000	125	0.010000	0 x 460	0.010000	-0.000980	0.000350	0.000560	-0.004500	-0.000300	0.869980	0.000000	32.9	0.208


CREATE TABLE aapl_2016_2020 (
  "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" VARCHAR,
  "n__c_gamma" VARCHAR,
  "n__c_vega" VARCHAR,
  "n__c_theta" VARCHAR,
  "n__c_rho" VARCHAR,
  "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" VARCHAR,
  "n__p_gamma" VARCHAR,
  "n__p_vega" VARCHAR,
  "n__p_theta" VARCHAR,
  "n__p_rho" VARCHAR,
  "n__p_iv" VARCHAR,
  "n__p_volume" VARCHAR,
  "n__strike_distance" DOUBLE,
  "n__strike_distance_pct" DOUBLE
);