PREVIEW / stock_daily / 2020-01-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-24.parquet
  size:    222 KB
  rows:    6,580
  symbols: 2,400

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-01-24	AAPL	Stock	80.0625	80.8325	79.38	79.5775	146537600.0
2020-01-24	MSFT	Stock	167.51	167.53	164.45	165.04	24918100.0
2020-01-24	NVDA	Stock	6.4375	6.4875	6.2075	6.262	373512000.0
2020-01-24	AMZN	Stock	94.5685	94.7495	92.372	93.082	75324000.0
2020-01-24	GOOGL	Stock	74.641	74.71	73.159	73.3085	29785600.0
2020-01-24	META	Stock	220.8	221.78	216.11	217.94	11905800.0
2020-01-24	TSLA	Stock	38.042	38.2573	36.9507	37.6547	215304000.0
2020-01-24	TLT	Stock	141.42	142.55	141.3	142.08	8584952.0
2020-01-24	ES	Stock	91.01	92.13	90.95	91.81	2008400.0
2020-01-24	CL	Stock	70.83	71.08	70.08	70.3	2938300.0
2020-01-24	A	Stock	89.45	89.46	87.58	88.26	1164500.0
2020-01-24	AA	Stock	16.3	16.32	15.355	15.51	7815100.0
2020-01-24	AACG	Stock	1.47	1.47	1.35	1.36	34600.0
2020-01-24	AAIC-DELISTED	Stock	5.79	5.84	5.765	5.79	302373.0
2020-01-24	AAIC.C-DELISTED	Stock	22.2603	22.4	22.17	22.17	8654.0
2020-01-24	AAL	Stock	28.85	28.86	27.01	27.64	18067800.0
2020-01-24	AAM.A-DELISTED	Stock	26.913	26.981	26.913	26.96	5998.0
2020-01-24	AAM.B-DELISTED	Stock	27.42	27.42	27.24	27.3028	11510.0
2020-01-24	AAMC-DELISTED	Stock	3.8971	3.9088	3.7882	3.8824	34071.0
2020-01-24	AAME	Stock	1.97	1.97	1.9	1.9	2600.0
2020-01-24	AAMI	Stock	9.71	9.735	9.39	9.5	291400.0
2020-01-24	AAOI	Stock	14.33	14.8	13.8	13.96	649600.0
2020-01-24	AAON	Stock	35.9	35.9	35.32	35.6333	155100.0
2020-01-24	AAP	Stock	150.0	150.0	141.21	141.68	1277100.0
2020-01-24	AAT	Stock	47.97	48.15	47.48	47.74	149800.0
2020-01-24	AAU-DELISTED	Stock	0.543	0.543	0.5136	0.5398	231976.0
2020-01-24	AAUAF-DELISTED	Stock	0.543	0.543	0.5136	0.5398	234341.0
2020-01-24	AAWW-DELISTED	Stock	25.72	25.74	24.27	24.75	307745.0
2020-01-24	AAXJ	Stock	73.8	73.88	72.79	73.17	985092.0
2020-01-24	AAXN-DELISTED	Stock	79.19	80.84	77.285	80.52	906500.0
2020-01-24	AB	Stock	33.75	33.95	33.34	33.62	168800.0
2020-01-24	ABB-DELISTED	Stock	24.12	24.14	23.79	23.905	2374251.0
2020-01-24	ABBNY-DELISTED	Stock	24.12	24.14	23.79	23.91	2522009.0
2020-01-24	ABBV	Stock	85.43	85.48	82.76	83.54	13215400.0
2020-01-24	ABC-DELISTED	Stock	91.54	91.54	86.08	88.89	1962299.0
2020-01-24	ABCB	Stock	43.21	43.31	40.92	41.59	669900.0
2020-01-24	ABDC-DELISTED	Stock	9.46	9.48	9.45	9.48	26350.0
2020-01-24	ABEO	Stock	70.5	71.0	65.25	65.75	44152.0
2020-01-24	ABEV	Stock	4.51	4.53	4.46	4.51	7980800.0
2020-01-24	ABG	Stock	102.52	102.52	99.44	99.74	126300.0
2020-01-24	ABM	Stock	39.37	39.45	38.66	39.04	218700.0
2020-01-24	ABMD-DELISTED	Stock	185.14	187.5	181.56	182.97	400262.0
2020-01-24	ABR	Stock	14.87	14.91	14.61	14.75	748300.0
2020-01-24	ABR.A-DELISTED	Stock	26.45	26.4625	26.45	26.4625	200.0
2020-01-24	ABR.B-DELISTED	Stock	26.24	26.24	26.24	26.24	100.0
2020-01-24	ABR.C-DELISTED	Stock	26.389	26.5535	26.389	26.5535	2900.0
2020-01-24	ABT	Stock	90.85	91.53	90.21	90.4	4218700.0
2020-01-24	ABTC	Stock	282900.0	282900.0	257700.0	263400.0	4.933333333333334
2020-01-24	ABTX-DELISTED	Stock	37.08	37.08	36.5	36.78	53561.0
2020-01-24	ABUS	Stock	3.08	3.09	2.72	2.89	397200.0

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

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