PREVIEW / stock_daily / 2018-02-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-14.parquet
  size:    217 KB
  rows:    6,489
  symbols: 2,857

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
2018-02-14	AAPL	Stock	40.76	41.885	40.72	41.8425	162579600.0
2018-02-14	MSFT	Stock	88.51	90.99	88.41	90.81	34960900.0
2018-02-14	NVDA	Stock	5.775	6.0648	5.7638	6.0355	744988000.0
2018-02-14	AMZN	Stock	70.3125	72.603	70.168	72.5525	119184000.0
2018-02-14	GOOGL	Stock	52.716	53.7735	52.49	53.635	41304040.0
2018-02-14	META	Stock	173.45	179.81	173.21	179.52	28929700.0
2018-02-14	TSLA	Stock	21.3893	21.7447	21.2347	21.4873	59260500.0
2018-02-14	TLT	Stock	118.46	118.54	117.47	117.67	12043313.0
2018-02-14	ES	Stock	57.29	57.77	56.84	57.58	2544400.0
2018-02-14	CL	Stock	69.78	70.03	69.0	69.62	3579200.0
2018-02-14	A	Stock	67.8	69.89	67.62	69.7	3637800.0
2018-02-14	AA	Stock	46.71	48.65	46.52	48.54	2431700.0
2018-02-14	AABA-DELISTED	Stock	70.88	73.73	70.88	73.68	6473980.0
2018-02-14	AAC-DELISTED	Stock	8.1	8.3628	8.03	8.18	43564.0
2018-02-14	AACG	Stock	5.39	5.5	5.28	5.29	2600.0
2018-02-14	AAIC-DELISTED	Stock	10.9	10.9414	10.82	10.93	682709.0
2018-02-14	AAL	Stock	50.24	51.56	50.11	51.07	4983200.0
2018-02-14	AAM.A-DELISTED	Stock	25.13	25.21	25.09	25.09	27873.0
2018-02-14	AAMC-DELISTED	Stock	19.2059	19.2059	19.2059	19.2059	843.0
2018-02-14	AAME	Stock	3.35	3.35	3.35	3.35	200.0
2018-02-14	AAMI	Stock	15.62	16.04	15.35	16.01	832900.0
2018-02-14	AAOI	Stock	29.1	31.31	29.041	31.28	994000.0
2018-02-14	AAON	Stock	22.3667	23.0	22.3667	22.9	154650.0
2018-02-14	AAP	Stock	105.5	110.0	105.26	109.02	1106700.0
2018-02-14	AAT	Stock	32.17	32.51	30.93	32.0	464600.0
2018-02-14	AAU-DELISTED	Stock	0.94	0.9517	0.9202	0.9401	373624.0
2018-02-14	AAUAF-DELISTED	Stock	0.94	0.9517	0.9202	0.942	383852.0
2018-02-14	AAV-DELISTED	Stock	3.0	3.0	2.85	2.95	299340.0
2018-02-14	AAWW-DELISTED	Stock	53.45	54.85	53.1	54.8	143891.0
2018-02-14	AAXJ	Stock	75.6	77.74	75.6	77.63	954161.0
2018-02-14	AAXN-DELISTED	Stock	26.64	27.97	26.64	27.93	530524.0
2018-02-14	AB	Stock	26.3	26.65	26.1	26.5	543400.0
2018-02-14	ABAC-DELISTED	Stock	2.51	2.61	2.4601	2.52	3870.0
2018-02-14	ABAX-DELISTED	Stock	64.86	67.9	64.86	67.79	138035.0
2018-02-14	ABB-DELISTED	Stock	24.25	24.9199	24.25	24.88	2194159.0
2018-02-14	ABBNY-DELISTED	Stock	24.25	24.9199	24.25	24.87	2443585.0
2018-02-14	ABBV	Stock	111.04	113.67	110.28	113.08	6189100.0
2018-02-14	ABC-DELISTED	Stock	97.25	98.19	95.6	96.4	3486981.0
2018-02-14	ABCB	Stock	52.45	53.8	52.2	53.7	279900.0
2018-02-14	ABCD-DELISTED	Stock	7.19	7.84	7.1124	7.59	224025.0
2018-02-14	ABDC-DELISTED	Stock	7.52	7.5714	7.46	7.53	39162.0
2018-02-14	ABE-DELISTED	Stock	14.82	15.1	14.82	15.1	15373.0
2018-02-14	ABEO	Stock	292.5	306.25	275.0	286.25	71992.0
2018-02-14	ABEOW-DELISTED	Stock	6.51	7.11	6.41	6.44	6742.0
2018-02-14	ABEV	Stock	6.62	6.9	6.58	6.87	17655900.0
2018-02-14	ABG	Stock	67.25	68.85	67.05	68.4	149700.0
2018-02-14	ABIL-DELISTED	Stock	0.375	0.3839	0.371	0.3824	80286.0
2018-02-14	ABLX-DELISTED	Stock	53.84	54.32	53.72	54.22	134017.0
2018-02-14	ABM	Stock	35.11	36.39	35.11	36.32	385600.0
2018-02-14	ABMD-DELISTED	Stock	237.27	256.13	236.66	255.59	817188.0

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

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