PREVIEW / stock_daily / 2019-09-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-12.parquet
  size:    221 KB
  rows:    6,589
  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-09-12	AAPL	Stock	56.2	56.605	55.715	55.7725	128906800.0
2019-09-12	MSFT	Stock	137.85	138.42	136.87	137.52	27010000.0
2019-09-12	NVDA	Stock	4.655	4.71	4.5988	4.6068	327840000.0
2019-09-12	AMZN	Stock	91.8815	92.683	91.714	92.1775	56470000.0
2019-09-12	GOOGL	Stock	61.1735	62.1208	61.128	61.7485	31644600.0
2019-09-12	META	Stock	189.86	190.93	187.23	187.47	11419800.0
2019-09-12	TSLA	Stock	16.5133	16.9	16.2933	16.3913	128718000.0
2019-09-12	TLT	Stock	141.5	141.8	139.0647	139.52	19163308.0
2019-09-12	ES	Stock	82.65	83.22	82.41	82.86	1621600.0
2019-09-12	CL	Stock	73.37	73.86	72.24	72.29	2644200.0
2019-09-12	A	Stock	77.01	78.09	76.71	77.57	4009800.0
2019-09-12	AA	Stock	22.03	22.82	21.38	22.56	5143800.0
2019-09-12	AABA-DELISTED	Stock	69.92	70.03	69.92	69.98	22544088.0
2019-09-12	AAC-DELISTED	Stock	0.8079	0.83	0.75	0.772	74568.0
2019-09-12	AACG	Stock	1.86	1.87	1.83	1.86	19700.0
2019-09-12	AAIC-DELISTED	Stock	5.63	5.65	5.5132	5.55	290667.0
2019-09-12	AAIC.C-DELISTED	Stock	21.88	22.0168	21.837	21.9476	36390.0
2019-09-12	AAL	Stock	29.67	30.22	29.64	29.94	5808800.0
2019-09-12	AAM.A-DELISTED	Stock	26.44	26.59	26.34	26.55	32068.0
2019-09-12	AAM.B-DELISTED	Stock	26.4163	26.63	26.4088	26.59	31580.0
2019-09-12	AAMC-DELISTED	Stock	2.9471	3.0706	2.9471	3.0706	932.0
2019-09-12	AAME	Stock	2.82	2.82	2.74	2.74	1000.0
2019-09-12	AAMI	Stock	10.05	10.43	9.99	10.37	690400.0
2019-09-12	AAOI	Stock	11.5	11.6	10.97	11.06	552500.0
2019-09-12	AAON	Stock	33.3533	34.0867	32.7	33.7533	362100.0
2019-09-12	AAP	Stock	160.0	160.15	155.08	155.2	1163200.0
2019-09-12	AAT	Stock	46.8	47.2	46.54	47.14	825600.0
2019-09-12	AAU-DELISTED	Stock	0.72	0.75	0.71	0.71	179441.0
2019-09-12	AAUAF-DELISTED	Stock	0.72	0.75	0.71	0.71	209167.0
2019-09-12	AAWW-DELISTED	Stock	29.46	29.68	28.23	29.35	253473.0
2019-09-12	AAXJ	Stock	68.31	68.78	68.065	68.45	1073322.0
2019-09-12	AAXN-DELISTED	Stock	63.0	64.72	62.01	64.36	346700.0
2019-09-12	AB	Stock	29.75	30.1	29.52	29.98	391200.0
2019-09-12	ABB-DELISTED	Stock	20.21	20.33	20.15	20.24	2270186.0
2019-09-12	ABBNY-DELISTED	Stock	20.21	20.33	20.15	20.23	2353933.0
2019-09-12	ABBV	Stock	70.76	71.17	70.19	70.83	9560100.0
2019-09-12	ABC-DELISTED	Stock	87.88	88.2322	84.52	84.64	851660.0
2019-09-12	ABCB	Stock	37.48	38.81	37.21	38.67	584900.0
2019-09-12	ABDC-DELISTED	Stock	8.95	8.9758	8.91	8.91	6727.0
2019-09-12	ABEO	Stock	78.0	82.0	76.75	78.5	22256.0
2019-09-12	ABEV	Stock	4.74	4.8	4.7	4.79	32800400.0
2019-09-12	ABG	Stock	102.82	103.17	100.89	101.8	368700.0
2019-09-12	ABIL-DELISTED	Stock	0.6407	0.6407	0.6101	0.64	16418.0
2019-09-12	ABM	Stock	36.36	37.11	36.27	36.85	388000.0
2019-09-12	ABMD-DELISTED	Stock	191.58	193.53	183.9	188.16	359447.0
2019-09-12	ABR	Stock	12.8	12.84	12.74	12.77	836100.0
2019-09-12	ABR.A-DELISTED	Stock	26.1358	26.1358	26.1208	26.1208	800.0
2019-09-12	ABR.B-DELISTED	Stock	25.68	25.757	25.67	25.747	400.0
2019-09-12	ABR.C-DELISTED	Stock	26.35	26.35	26.3392	26.3392	200.0
2019-09-12	ABT	Stock	85.03	85.99	84.91	85.21	3517500.0

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

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