PREVIEW / stock_daily / 2016-10-31

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-31.parquet
  size:    214 KB
  rows:    6,527
  symbols: 3,186

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-10-31	AAPL	Stock	28.4125	28.5575	28.3	28.385	105677600.0
2016-10-31	MSFT	Stock	60.16	60.42	59.92	59.92	26434700.0
2016-10-31	NVDA	Stock	1.7698	1.7908	1.7688	1.779	252388000.0
2016-10-31	AMZN	Stock	39.0515	39.685	39.0055	39.491	108266000.0
2016-10-31	GOOGL	Stock	41.1215	41.1315	40.4	40.495	44853580.0
2016-10-31	META	Stock	132.01	132.12	130.88	130.99	15669000.0
2016-10-31	TSLA	Stock	13.4993	13.4993	13.054	13.182	70384500.0
2016-10-31	TLT	Stock	130.89	131.29	130.71	131.25	7047470.0
2016-10-31	ES	Stock	54.36	55.47	54.29	55.06	1490100.0
2016-10-31	CL	Stock	71.28	71.69	71.02	71.36	2785900.0
2016-10-31	A	Stock	43.33	43.7	43.18	43.57	1556800.0
2016-10-31	AA	Stock	22.7804	23.3331	22.7003	23.0047	13269413.0
2016-10-31	AA.B-DELISTED	Stock	30.81	31.4598	30.81	31.02	23603.0
2016-10-31	AAAP-DELISTED	Stock	36.11	36.5	35.48	36.32	66796.0
2016-10-31	AABA-DELISTED	Stock	42.03	42.16	41.55	41.56	3355529.0
2016-10-31	AAC-DELISTED	Stock	16.68	16.97	16.39	16.39	141338.0
2016-10-31	AACG	Stock	3.5	3.69	3.3	3.66	4400.0
2016-10-31	AAIC-DELISTED	Stock	14.44	14.47	14.27	14.28	189165.0
2016-10-31	AAL	Stock	40.31	40.81	40.08	40.6	5961100.0
2016-10-31	AAMC-DELISTED	Stock	9.5735	10.2941	9.4065	10.0441	52836.0
2016-10-31	AAME	Stock	4.15	4.25	3.7	4.05	4000.0
2016-10-31	AAMI	Stock	14.1	14.17	13.91	14.07	201600.0
2016-10-31	AAOI	Stock	19.5	20.01	19.15	19.23	332000.0
2016-10-31	AAON	Stock	19.7333	20.0	19.4333	19.9667	231600.0
2016-10-31	AAP	Stock	140.33	140.82	138.83	140.08	1277400.0
2016-10-31	AAT	Stock	38.98	39.72	38.59	39.71	270400.0
2016-10-31	AAU-DELISTED	Stock	1.3	1.34	1.3	1.33	130624.0
2016-10-31	AAUAF-DELISTED	Stock	1.3	1.34	1.3	1.33	138547.0
2016-10-31	AAV-DELISTED	Stock	6.7	6.8	6.67	6.75	95040.0
2016-10-31	AAWW-DELISTED	Stock	42.25	42.25	41.55	41.9	139930.0
2016-10-31	AAXJ	Stock	58.84	59.1	58.82	58.92	1516841.0
2016-10-31	AAXN-DELISTED	Stock	22.47	22.4765	22.18	22.38	572102.0
2016-10-31	AB	Stock	21.85	22.05	21.63	21.8	157400.0
2016-10-31	ABAC-DELISTED	Stock	2.78	2.78	2.59	2.6789	5107.0
2016-10-31	ABAX-DELISTED	Stock	47.28	47.86	46.72	47.74	152719.0
2016-10-31	ABB-DELISTED	Stock	20.6	20.67	20.55	20.66	2049178.0
2016-10-31	ABBNY-DELISTED	Stock	20.6	20.67	20.55	20.65	2119448.0
2016-10-31	ABBV	Stock	57.06	57.3	55.72	55.78	14185800.0
2016-10-31	ABC-DELISTED	Stock	69.51	70.94	69.51	70.32	3994292.0
2016-10-31	ABCB	Stock	36.0	36.33	35.85	36.3	182200.0
2016-10-31	ABCD-DELISTED	Stock	5.23	5.23	4.941	5.17	22468.0
2016-10-31	ABCO-DELISTED	Stock	40.1	40.5	39.6	39.8	170519.0
2016-10-31	ABDC-DELISTED	Stock	13.25	13.25	12.78	12.8	22671.0
2016-10-31	ABE-DELISTED	Stock	12.18	12.3301	12.18	12.33	11500.0
2016-10-31	ABEO	Stock	175.0	176.25	162.5	163.75	30600.0
2016-10-31	ABEOW-DELISTED	Stock	2.55	3.8	1.7	3.06	7974.0
2016-10-31	ABEV	Stock	5.94	5.96	5.86	5.9	18737300.0
2016-10-31	ABG	Stock	51.1	51.63	50.25	50.95	194100.0
2016-10-31	ABIL-DELISTED	Stock	3.04	3.09	2.9999	2.9999	28852.0
2016-10-31	ABM	Stock	38.55	39.15	38.45	39.08	283200.0

> showing 50 of 6,527 rows — these rows as CSV

> unlock the full archive -- $79 one-time