PREVIEW / stock_daily / 2020-10-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-09.parquet
  size:    228 KB
  rows:    6,926
  symbols: 2,474

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
2020-10-09	AAPL	Stock	115.28	117.0	114.92	116.97	100506900.0
2020-10-09	MSFT	Stock	211.23	215.86	211.23	215.81	26458000.0
2020-10-09	NVDA	Stock	13.767	13.8242	13.6608	13.7628	346892000.0
2020-10-09	AMZN	Stock	160.5	164.4495	159.8915	164.3325	98158000.0
2020-10-09	GOOGL	Stock	74.643	75.5925	74.35	75.5225	32966800.0
2020-10-09	META	Stock	264.52	264.75	262.17	264.45	14107800.0
2020-10-09	TSLA	Stock	143.3767	144.8633	142.1533	144.6667	86777100.0
2020-10-09	TLT	Stock	159.52	160.27	158.81	160.09	8441506.0
2020-10-09	ES	Stock	92.75	92.99	91.48	92.19	1271100.0
2020-10-09	CL	Stock	79.09	80.13	78.89	79.77	2870600.0
2020-10-09	A	Stock	104.83	106.1	104.55	105.76	709000.0
2020-10-09	AA	Stock	12.94	12.97	12.25	12.52	8440000.0
2020-10-09	AACG	Stock	1.09	1.09	1.07	1.08	26800.0
2020-10-09	AACQ-DELISTED	Stock	9.81	9.81	9.76	9.76	350154.0
2020-10-09	AACQU-DELISTED	Stock	10.18	10.23	10.17	10.19	103643.0
2020-10-09	AACQW-DELISTED	Stock	1.4	1.45	1.39	1.4	80737.0
2020-10-09	AAIC-DELISTED	Stock	2.95	2.98	2.82	2.83	182284.0
2020-10-09	AAL	Stock	13.25	13.49	12.95	13.2	65281000.0
2020-10-09	AAM.A-DELISTED	Stock	26.29	26.4	26.11	26.4	5177.0
2020-10-09	AAM.B-DELISTED	Stock	27.23	27.382	27.1201	27.3	5803.0
2020-10-09	AAMI	Stock	14.75	15.14	14.46	14.9	603100.0
2020-10-09	AAOI	Stock	11.79	11.94	11.46	11.83	333900.0
2020-10-09	AAON	Stock	42.1267	42.88	41.9133	42.3733	201300.0
2020-10-09	AAP	Stock	158.58	158.58	155.07	155.32	840400.0
2020-10-09	AAT	Stock	25.86	26.41	25.5	26.17	312500.0
2020-10-09	AAU-DELISTED	Stock	0.78	0.909	0.78	0.8464	1168042.0
2020-10-09	AAUAF-DELISTED	Stock	0.78	0.909	0.78	0.845	1194661.0
2020-10-09	AAWW-DELISTED	Stock	68.12	68.63	66.665	67.72	273945.0
2020-10-09	AAXJ	Stock	79.73	80.3	79.615	80.12	755852.0
2020-10-09	AAXN-DELISTED	Stock	97.57	99.67	97.56	99.07	353103.0
2020-10-09	AB	Stock	29.8	30.37	29.43	30.26	513500.0
2020-10-09	ABB-DELISTED	Stock	26.68	26.945	26.61	26.85	1066882.0
2020-10-09	ABBNY-DELISTED	Stock	26.68	26.945	26.61	26.85	1128410.0
2020-10-09	ABBV	Stock	87.41	88.7	87.35	87.7	6005800.0
2020-10-09	ABC-DELISTED	Stock	98.9	98.99	96.57	96.87	554128.0
2020-10-09	ABCB	Stock	26.59	27.11	25.7	25.88	307100.0
2020-10-09	ABEO	Stock	36.5	39.5	34.0	34.5	165996.0
2020-10-09	ABEV	Stock	2.48	2.54	2.45	2.47	21808900.0
2020-10-09	ABG	Stock	116.11	117.33	113.71	114.7	99900.0
2020-10-09	ABM	Stock	37.6	37.69	36.73	37.01	277300.0
2020-10-09	ABMD-DELISTED	Stock	272.99	276.24	271.56	273.13	90280.0
2020-10-09	ABR	Stock	11.9	12.01	11.59	11.74	938000.0
2020-10-09	ABR.A-DELISTED	Stock	25.3559	25.44	25.3	25.3001	1675.0
2020-10-09	ABR.B-DELISTED	Stock	25.27	25.2728	25.27	25.2728	337.0
2020-10-09	ABR.C-DELISTED	Stock	25.63	25.76	25.4633	25.723	5940.0
2020-10-09	ABT	Stock	109.34	109.97	108.8	109.65	3060700.0
2020-10-09	ABTC	Stock	124800.0	137700.0	123000.0	132000.0	27.4
2020-10-09	ABTS	Stock	18.6	19.05	18.0	18.3	6407.0
2020-10-09	ABTX-DELISTED	Stock	26.22	26.35	25.9873	26.25	22347.0
2020-10-09	ABUS	Stock	3.16	3.23	3.12	3.2	833400.0

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

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