PREVIEW / stock_daily / 2019-08-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-21.parquet
  size:    219 KB
  rows:    6,579
  symbols: 2,520

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
2019-08-21	AAPL	Stock	53.2475	53.4125	52.9	53.16	86141600.0
2019-08-21	MSFT	Stock	138.55	139.49	138.0	138.79	14970300.0
2019-08-21	NVDA	Stock	4.2632	4.3362	4.2415	4.2808	427244000.0
2019-08-21	AMZN	Stock	90.9695	91.479	90.75	91.177	40636000.0
2019-08-21	GOOGL	Stock	59.791	60.0278	59.396	59.579	14165440.0
2019-08-21	META	Stock	185.0	185.9	183.14	183.55	8398200.0
2019-08-21	TSLA	Stock	14.8007	14.8813	14.5067	14.722	116914500.0
2019-08-21	TLT	Stock	144.72	145.79	144.285	144.56	9372115.0
2019-08-21	ES	Stock	78.82	79.59	78.68	79.56	930000.0
2019-08-21	CL	Stock	73.0	73.17	72.46	72.61	2527100.0
2019-08-21	A	Stock	71.96	72.33	71.19	72.2	1897400.0
2019-08-21	AA	Stock	18.67	19.01	18.46	18.47	3383100.0
2019-08-21	AABA-DELISTED	Stock	69.59	69.715	69.55	69.6	6314285.0
2019-08-21	AAC-DELISTED	Stock	0.65	0.67	0.6034	0.6347	150235.0
2019-08-21	AACG	Stock	1.84	1.85	1.8	1.83	81800.0
2019-08-21	AAIC-DELISTED	Stock	5.45	5.49	5.2	5.3	766897.0
2019-08-21	AAIC.C-DELISTED	Stock	22.129	22.2446	21.92	22.1804	8155.0
2019-08-21	AAL	Stock	26.06	26.6	26.01	26.42	6227500.0
2019-08-21	AAM.A-DELISTED	Stock	26.6994	26.7	26.565	26.7	12027.0
2019-08-21	AAM.B-DELISTED	Stock	26.59	26.7704	26.59	26.755	12775.0
2019-08-21	AAMC-DELISTED	Stock	2.9412	2.9412	2.9412	2.9412	4192.0
2019-08-21	AAME	Stock	2.38	2.59	2.38	2.59	16300.0
2019-08-21	AAMI	Stock	8.78	9.37	8.77	9.29	417000.0
2019-08-21	AAOI	Stock	9.73	9.775	9.543	9.66	231700.0
2019-08-21	AAON	Stock	31.6333	31.9667	31.4067	31.8467	158700.0
2019-08-21	AAP	Stock	136.56	136.75	134.7	136.23	1344700.0
2019-08-21	AAT	Stock	47.11	47.25	46.8	46.92	338900.0
2019-08-21	AAU-DELISTED	Stock	0.75	0.7899	0.7489	0.7703	189112.0
2019-08-21	AAUAF-DELISTED	Stock	0.75	0.7899	0.7489	0.7703	194975.0
2019-08-21	AAWW-DELISTED	Stock	26.83	27.27	26.645	26.7	185927.0
2019-08-21	AAXJ	Stock	65.7	65.74	65.32	65.55	480685.0
2019-08-21	AAXN-DELISTED	Stock	61.35	61.35	60.23	60.35	662998.0
2019-08-21	AB	Stock	27.75	28.31	27.75	28.02	227100.0
2019-08-21	ABB-DELISTED	Stock	18.76	18.79	18.63	18.635	1149267.0
2019-08-21	ABBNY-DELISTED	Stock	18.76	18.79	18.63	18.63	1221381.0
2019-08-21	ABBV	Stock	67.34	67.92	66.6	67.54	7615700.0
2019-08-21	ABC-DELISTED	Stock	86.44	87.58	86.23	86.31	709386.0
2019-08-21	ABCB	Stock	36.94	36.97	36.6	36.62	313100.0
2019-08-21	ABDC-DELISTED	Stock	8.875	8.93	8.82	8.88	73069.0
2019-08-21	ABEO	Stock	55.0	55.75	53.25	55.0	7696.0
2019-08-21	ABEOW-DELISTED	Stock	0.15	0.15	0.12	0.12	800.0
2019-08-21	ABEV	Stock	4.7	4.71	4.64	4.65	22464200.0
2019-08-21	ABG	Stock	91.39	91.57	90.2	90.57	120400.0
2019-08-21	ABIL-DELISTED	Stock	0.6329	0.68	0.5751	0.6548	95409.0
2019-08-21	ABM	Stock	38.5	38.87	38.38	38.68	161500.0
2019-08-21	ABMD-DELISTED	Stock	192.86	197.675	192.86	195.93	300445.0
2019-08-21	ABR	Stock	12.57	12.6	12.45	12.54	1732700.0
2019-08-21	ABR.A-DELISTED	Stock	25.97	25.97	25.954	25.954	1588.0
2019-08-21	ABR.B-DELISTED	Stock	25.6263	25.76	25.6263	25.76	790.0
2019-08-21	ABR.C-DELISTED	Stock	26.35	26.35	26.35	26.35	100.0

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

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