PREVIEW / stock_daily / 2018-09-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-28.parquet
  size:    220 KB
  rows:    6,559
  symbols: 2,753

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-09-28	AAPL	Stock	56.1975	56.46	56.005	56.435	91717600.0
2018-09-28	MSFT	Stock	114.19	114.57	113.68	114.37	21647800.0
2018-09-28	NVDA	Stock	6.8183	7.048	6.79	7.0255	709396000.0
2018-09-28	AMZN	Stock	100.2205	101.326	99.823	100.15	81702000.0
2018-09-28	GOOGL	Stock	60.2045	60.4225	59.8915	60.354	35615180.0
2018-09-28	META	Stock	168.33	168.79	162.56	164.46	34265600.0
2018-09-28	TSLA	Stock	18.0173	18.5333	17.3707	17.6513	504745500.0
2018-09-28	TLT	Stock	117.85	117.91	117.22	117.27	12807703.0
2018-09-28	ES	Stock	60.83	61.47	60.72	61.44	1697400.0
2018-09-28	CL	Stock	66.73	66.95	66.61	66.95	2491400.0
2018-09-28	A	Stock	70.69	71.0	70.46	70.54	2248100.0
2018-09-28	AA	Stock	40.54	41.355	40.24	40.4	3755700.0
2018-09-28	AABA-DELISTED	Stock	67.93	68.46	67.46	68.1	3382525.0
2018-09-28	AAC-DELISTED	Stock	7.26	7.74	7.2	7.63	123295.0
2018-09-28	AACG	Stock	1.03	1.07	1.03	1.05	29600.0
2018-09-28	AAIC-DELISTED	Stock	9.57	9.61	9.33	9.34	689279.0
2018-09-28	AAL	Stock	41.37	41.96	40.7	41.33	5030600.0
2018-09-28	AAM.A-DELISTED	Stock	25.02	25.17	24.8801	25.17	13466.0
2018-09-28	AAM.B-DELISTED	Stock	24.63	24.87	24.63	24.84	50056.0
2018-09-28	AAMC-DELISTED	Stock	18.4559	18.4559	17.6029	17.6029	5797.0
2018-09-28	AAME	Stock	2.55	2.55	2.5	2.5	4600.0
2018-09-28	AAMI	Stock	12.38	12.45	12.27	12.4	497200.0
2018-09-28	AAOI	Stock	24.0	25.78	23.8	24.66	6187700.0
2018-09-28	AAON	Stock	24.7333	25.6	24.7	25.2	550800.0
2018-09-28	AAP	Stock	169.71	171.04	167.83	168.33	1309700.0
2018-09-28	AAT	Stock	36.86	37.3	36.86	37.29	234100.0
2018-09-28	AAU-DELISTED	Stock	0.63	0.647	0.6138	0.6339	125516.0
2018-09-28	AAUAF-DELISTED	Stock	0.63	0.647	0.6138	0.6339	128655.0
2018-09-28	AAWW-DELISTED	Stock	63.5	64.6	63.5	63.85	149310.0
2018-09-28	AAXJ	Stock	70.55	70.97	70.39	70.61	1057030.0
2018-09-28	AAXN-DELISTED	Stock	67.47	69.3477	67.47	68.45	301516.0
2018-09-28	AB	Stock	30.45	30.6	30.35	30.45	316800.0
2018-09-28	ABAC-DELISTED	Stock	2.07	2.1	2.0395	2.05	4325.0
2018-09-28	ABB-DELISTED	Stock	23.6	23.7999	23.59	23.63	1399466.0
2018-09-28	ABBNY-DELISTED	Stock	23.6	23.7999	23.59	23.63	1781411.0
2018-09-28	ABBV	Stock	94.0	95.16	93.84	94.58	4527900.0
2018-09-28	ABC-DELISTED	Stock	91.12	92.51	90.53	92.23	924504.0
2018-09-28	ABCB	Stock	45.15	46.0	45.15	45.7	319100.0
2018-09-28	ABCD-DELISTED	Stock	11.78	11.925	11.66	11.83	54555.0
2018-09-28	ABDC-DELISTED	Stock	5.99	6.0499	5.95	6.01	100549.0
2018-09-28	ABEO	Stock	325.0	326.25	318.25	320.0	14180.0
2018-09-28	ABEV	Stock	4.55	4.62	4.53	4.57	17859800.0
2018-09-28	ABG	Stock	70.0	70.15	68.65	68.75	135900.0
2018-09-28	ABIL-DELISTED	Stock	3.39	3.65	3.35	3.46	99102.0
2018-09-28	ABM	Stock	32.2	32.44	32.07	32.25	407200.0
2018-09-28	ABMD-DELISTED	Stock	441.29	455.4	441.0	449.83	508055.0
2018-09-28	ABR	Stock	11.32	11.51	11.32	11.48	844400.0
2018-09-28	ABR.A-DELISTED	Stock	25.5	25.5	25.36	25.5	2000.0
2018-09-28	ABR.B-DELISTED	Stock	25.4957	25.6	25.4957	25.6	900.0
2018-09-28	ABT	Stock	72.78	73.58	72.77	73.36	6572100.0

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

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