PREVIEW / stock_daily / 2020-01-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-03.parquet
  size:    221 KB
  rows:    6,602
  symbols: 2,420

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-03	AAPL	Stock	74.2875	75.145	74.125	74.3575	146322800.0
2020-01-03	MSFT	Stock	158.32	159.95	158.06	158.62	21116200.0
2020-01-03	NVDA	Stock	5.8775	5.9458	5.8525	5.9018	205384000.0
2020-01-03	AMZN	Stock	93.225	94.31	93.225	93.7485	75288000.0
2020-01-03	GOOGL	Stock	67.4	68.6875	67.3662	68.076	23412580.0
2020-01-03	META	Stock	207.21	210.4	206.95	208.67	11188400.0
2020-01-03	TSLA	Stock	29.3667	30.2667	29.128	29.534	266677500.0
2020-01-03	TLT	Stock	138.27	139.16	137.88	139.12	12366830.0
2020-01-03	ES	Stock	83.13	83.51	82.7	82.86	2199100.0
2020-01-03	CL	Stock	67.84	68.47	67.68	68.02	3473800.0
2020-01-03	A	Stock	84.67	85.33	84.5	84.57	1118300.0
2020-01-03	AA	Stock	21.17	21.61	21.15	21.5	3011800.0
2020-01-03	AACG	Stock	1.36	1.49	1.36	1.47	42000.0
2020-01-03	AAIC-DELISTED	Stock	5.48	5.57	5.48	5.52	347169.0
2020-01-03	AAIC.C-DELISTED	Stock	21.7277	21.7277	21.7277	21.7277	158.0
2020-01-03	AAL	Stock	28.27	28.29	27.34	27.65	14008900.0
2020-01-03	AAM.A-DELISTED	Stock	26.66	26.73	26.61	26.71	20540.0
2020-01-03	AAM.B-DELISTED	Stock	27.09	27.2806	27.09	27.26	26981.0
2020-01-03	AAMC-DELISTED	Stock	4.2588	4.2588	3.8794	4.0	10135.0
2020-01-03	AAME	Stock	1.77	2.08	1.77	2.04	2600.0
2020-01-03	AAMI	Stock	9.64	9.77	9.53	9.55	444800.0
2020-01-03	AAOI	Stock	12.25	12.325	12.01	12.12	498400.0
2020-01-03	AAON	Stock	32.7667	33.6133	32.42	33.5667	274950.0
2020-01-03	AAP	Stock	158.03	159.63	157.25	159.42	567000.0
2020-01-03	AAT	Stock	45.16	45.94	45.01	45.88	318700.0
2020-01-03	AAU-DELISTED	Stock	0.6101	0.6102	0.55	0.58	244750.0
2020-01-03	AAUAF-DELISTED	Stock	0.6101	0.6101	0.55	0.58	252059.0
2020-01-03	AAWW-DELISTED	Stock	27.09	27.765	26.82	27.45	216664.0
2020-01-03	AAXJ	Stock	73.81	74.155	73.62	73.72	947057.0
2020-01-03	AAXN-DELISTED	Stock	72.3	75.5699	68.68	73.97	1897013.0
2020-01-03	AB	Stock	30.15	30.29	30.0	30.2	249700.0
2020-01-03	ABB-DELISTED	Stock	24.05	24.235	24.05	24.17	1312100.0
2020-01-03	ABBNY-DELISTED	Stock	24.05	24.235	24.05	24.18	1410854.0
2020-01-03	ABBV	Stock	88.17	89.39	87.9	88.7	5988500.0
2020-01-03	ABC-DELISTED	Stock	83.81	85.065	83.27	83.99	618109.0
2020-01-03	ABCB	Stock	42.05	42.67	41.83	42.57	389600.0
2020-01-03	ABDC-DELISTED	Stock	9.13	9.19	9.04	9.19	16606.0
2020-01-03	ABEO	Stock	80.0	80.25	72.25	72.5	143544.0
2020-01-03	ABEV	Stock	4.64	4.7	4.63	4.67	8742700.0
2020-01-03	ABG	Stock	109.66	110.03	107.89	108.39	190000.0
2020-01-03	ABM	Stock	37.89	38.39	37.89	38.32	299500.0
2020-01-03	ABMD-DELISTED	Stock	166.83	169.3174	165.24	166.75	531024.0
2020-01-03	ABR	Stock	14.01	14.29	14.01	14.19	713800.0
2020-01-03	ABR.A-DELISTED	Stock	26.1689	26.4	26.145	26.295	4221.0
2020-01-03	ABR.B-DELISTED	Stock	25.8022	26.0446	25.8022	26.0371	4568.0
2020-01-03	ABR.C-DELISTED	Stock	26.7455	26.7455	26.71	26.71	1400.0
2020-01-03	ABT	Stock	85.75	86.67	85.59	85.89	4747000.0
2020-01-03	ABTC	Stock	251100.0	254100.0	240000.0	248400.0	2.84
2020-01-03	ABTS	Stock	32.55	32.55	32.55	32.55	33.3
2020-01-03	ABTX-DELISTED	Stock	37.08	37.5	36.86	37.39	73634.0

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

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