PREVIEW / stock_daily / 2019-09-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-24.parquet
  size:    222 KB
  rows:    6,618
  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-24	AAPL	Stock	55.2575	55.6225	54.2975	54.42	124763200.0
2019-09-24	MSFT	Stock	140.36	140.69	136.88	137.38	29773200.0
2019-09-24	NVDA	Stock	4.4025	4.4322	4.2775	4.3132	317268000.0
2019-09-24	AMZN	Stock	89.5305	89.7855	86.7775	87.0805	92320000.0
2019-09-24	GOOGL	Stock	62.0	62.3555	60.5322	60.9165	36714240.0
2019-09-24	META	Stock	187.98	188.04	180.39	181.28	18546600.0
2019-09-24	TSLA	Stock	16.1013	16.1327	14.8407	14.8807	193372500.0
2019-09-24	TLT	Stock	142.42	143.845	142.41	143.57	12947855.0
2019-09-24	ES	Stock	83.82	84.83	83.59	84.66	1934000.0
2019-09-24	CL	Stock	71.96	72.93	71.79	72.49	4395800.0
2019-09-24	A	Stock	78.29	78.39	75.64	75.97	4296700.0
2019-09-24	AA	Stock	21.07	21.44	20.42	20.62	3718000.0
2019-09-24	AABA-DELISTED	Stock	19.32	19.66	19.25	19.505	50763980.0
2019-09-24	AAC-DELISTED	Stock	0.7372	0.7747	0.7153	0.7489	56787.0
2019-09-24	AACG	Stock	1.83	1.83	1.78	1.79	17100.0
2019-09-24	AAIC-DELISTED	Stock	5.69	5.72	5.64	5.69	534580.0
2019-09-24	AAIC.C-DELISTED	Stock	21.1	21.2962	21.0	21.18	12548.0
2019-09-24	AAL	Stock	27.62	27.7	26.77	27.0	5558300.0
2019-09-24	AAM.A-DELISTED	Stock	26.464	26.464	26.2362	26.36	13260.0
2019-09-24	AAM.B-DELISTED	Stock	26.67	26.7	26.6	26.65	18609.0
2019-09-24	AAMC-DELISTED	Stock	3.2324	3.3086	3.1706	3.1971	16918.0
2019-09-24	AAME	Stock	2.7	2.74	2.63	2.66	1900.0
2019-09-24	AAMI	Stock	10.4	10.475	10.245	10.28	1134500.0
2019-09-24	AAOI	Stock	11.34	11.4	10.9	11.125	352600.0
2019-09-24	AAON	Stock	32.3733	32.46	30.8067	30.86	270450.0
2019-09-24	AAP	Stock	162.48	163.61	158.72	159.22	1263100.0
2019-09-24	AAT	Stock	46.86	47.15	46.21	46.3	589100.0
2019-09-24	AAU-DELISTED	Stock	0.72	0.775	0.7169	0.7293	124864.0
2019-09-24	AAUAF-DELISTED	Stock	0.72	0.775	0.7169	0.7293	135453.0
2019-09-24	AAWW-DELISTED	Stock	24.6	25.15	23.73	23.895	382334.0
2019-09-24	AAXJ	Stock	67.65	67.65	66.885	66.98	3048574.0
2019-09-24	AAXN-DELISTED	Stock	62.61	63.565	59.8	60.99	715611.0
2019-09-24	AB	Stock	29.42	29.51	28.58	28.81	220400.0
2019-09-24	ABB-DELISTED	Stock	19.76	19.79	19.52	19.58	1477488.0
2019-09-24	ABBNY-DELISTED	Stock	19.76	19.79	19.52	19.58	1549952.0
2019-09-24	ABBV	Stock	73.83	73.83	72.17	72.95	8223800.0
2019-09-24	ABC-DELISTED	Stock	84.23	85.13	82.515	82.71	684040.0
2019-09-24	ABCB	Stock	39.79	39.95	39.34	39.64	739400.0
2019-09-24	ABDC-DELISTED	Stock	9.04	9.05	8.945	8.97	87755.0
2019-09-24	ABEO	Stock	71.25	72.0	66.25	69.0	31320.0
2019-09-24	ABEOW-DELISTED	Stock	0.29	0.4187	0.25	0.4187	4250.0
2019-09-24	ABEV	Stock	4.66	4.67	4.57	4.64	29672200.0
2019-09-24	ABG	Stock	102.84	103.33	100.51	101.25	122800.0
2019-09-24	ABIL-DELISTED	Stock	0.62	0.6201	0.5151	0.567	26823.0
2019-09-24	ABM	Stock	36.26	36.49	35.74	35.88	245900.0
2019-09-24	ABMD-DELISTED	Stock	186.02	189.28	181.29	184.28	564410.0
2019-09-24	ABR	Stock	13.07	13.2	13.0	13.0	1033500.0
2019-09-24	ABR.A-DELISTED	Stock	26.1401	26.25	26.14	26.2075	1754.0
2019-09-24	ABR.B-DELISTED	Stock	25.73	25.8797	25.73	25.73	2120.0
2019-09-24	ABR.C-DELISTED	Stock	26.57	26.758	26.2401	26.62	5000.0

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

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