PREVIEW / stock_daily / 2019-09-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-23.parquet
  size:    221 KB
  rows:    6,616
  symbols: 2,523

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-23	AAPL	Stock	54.7375	54.96	54.4125	54.68	76662000.0
2019-09-23	MSFT	Stock	139.23	139.63	138.44	139.14	17139300.0
2019-09-23	NVDA	Stock	4.3175	4.4167	4.3138	4.371	249712000.0
2019-09-23	AMZN	Stock	88.85	89.635	88.366	89.265	58446000.0
2019-09-23	GOOGL	Stock	61.3285	61.984	61.1891	61.7345	23941380.0
2019-09-23	META	Stock	189.34	190.1	185.21	186.82	13327600.0
2019-09-23	TSLA	Stock	16.0	16.3453	15.948	16.082	65103000.0
2019-09-23	TLT	Stock	142.24	143.155	141.7	141.86	15402596.0
2019-09-23	ES	Stock	83.35	83.83	83.04	83.49	1273000.0
2019-09-23	CL	Stock	70.85	71.72	70.84	71.5	3952000.0
2019-09-23	A	Stock	77.48	78.39	77.27	78.06	2217000.0
2019-09-23	AA	Stock	20.66	21.707	20.44	21.3	3529200.0
2019-09-23	AABA-DELISTED	Stock	70.41	70.845	70.4	70.79	18509098.0
2019-09-23	AAC-DELISTED	Stock	0.7537	0.7941	0.68	0.7369	52519.0
2019-09-23	AACG	Stock	1.91	1.91	1.83	1.86	8500.0
2019-09-23	AAIC-DELISTED	Stock	5.58	5.7	5.56	5.67	489408.0
2019-09-23	AAIC.C-DELISTED	Stock	21.1	21.23	21.1	21.14	5376.0
2019-09-23	AAL	Stock	27.71	27.88	27.36	27.5	5324400.0
2019-09-23	AAM.A-DELISTED	Stock	26.4749	26.62	26.24	26.315	68252.0
2019-09-23	AAM.B-DELISTED	Stock	26.65	26.74	26.58	26.65	21184.0
2019-09-23	AAMC-DELISTED	Stock	3.1765	3.1765	2.9265	3.1324	6511.0
2019-09-23	AAME	Stock	2.69	2.75	2.68	2.74	2600.0
2019-09-23	AAMI	Stock	10.14	10.4	10.01	10.36	1060900.0
2019-09-23	AAOI	Stock	11.07	11.3	10.67	11.22	323800.0
2019-09-23	AAON	Stock	32.5267	32.9667	31.82	32.1867	173250.0
2019-09-23	AAP	Stock	156.55	161.57	155.78	161.22	1234200.0
2019-09-23	AAT	Stock	46.71	47.05	46.64	46.8	259000.0
2019-09-23	AAU-DELISTED	Stock	0.72	0.747	0.7143	0.7418	114630.0
2019-09-23	AAUAF-DELISTED	Stock	0.72	0.747	0.7143	0.7262	126803.0
2019-09-23	AAWW-DELISTED	Stock	24.65	24.99	24.12	24.8	386092.0
2019-09-23	AAXJ	Stock	67.41	67.65	67.32	67.6	888612.0
2019-09-23	AAXN-DELISTED	Stock	63.21	64.375	62.34	62.54	488808.0
2019-09-23	AB	Stock	29.25	29.7	29.2	29.29	143900.0
2019-09-23	ABB-DELISTED	Stock	19.76	19.93	19.7	19.9	984543.0
2019-09-23	ABBNY-DELISTED	Stock	19.76	19.93	19.7	19.9	1044556.0
2019-09-23	ABBV	Stock	72.33	73.78	72.05	72.93	8092300.0
2019-09-23	ABC-DELISTED	Stock	84.87	85.26	83.29	83.87	645836.0
2019-09-23	ABCB	Stock	39.3	39.76	38.95	39.6	331700.0
2019-09-23	ABDC-DELISTED	Stock	9.05	9.05	8.95	9.01	43254.0
2019-09-23	ABEO	Stock	67.5	78.0	62.75	71.75	90048.0
2019-09-23	ABEOW-DELISTED	Stock	0.29	0.314	0.29	0.29	3500.0
2019-09-23	ABEV	Stock	4.63	4.7	4.63	4.65	21375900.0
2019-09-23	ABG	Stock	100.6	102.84	100.6	101.97	120700.0
2019-09-23	ABIL-DELISTED	Stock	0.6011	0.6226	0.593	0.6157	11719.0
2019-09-23	ABM	Stock	35.71	36.56	35.71	36.23	224400.0
2019-09-23	ABMD-DELISTED	Stock	192.47	192.47	184.75	186.27	514535.0
2019-09-23	ABR	Stock	13.21	13.21	13.0	13.04	887300.0
2019-09-23	ABR.A-DELISTED	Stock	26.0	26.2475	26.0	26.1482	1691.0
2019-09-23	ABR.B-DELISTED	Stock	25.72	25.83	25.72	25.74	2011.0
2019-09-23	ABR.C-DELISTED	Stock	26.51	26.6496	26.21	26.21	2700.0

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

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