PREVIEW / stock_daily / 2020-06-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-19.parquet
  size:    223 KB
  rows:    6,716
  symbols: 2,403

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-06-19	AAPL	Stock	88.66	89.14	86.2875	87.43	264476000.0
2020-06-19	MSFT	Stock	198.59	199.29	194.37	195.15	44441100.0
2020-06-19	NVDA	Stock	9.2425	9.445	9.2272	9.2612	524160000.0
2020-06-19	AMZN	Stock	133.904	134.8715	132.95	133.7505	115540000.0
2020-06-19	GOOGL	Stock	72.0	72.225	70.95	71.232	52783340.0
2020-06-19	META	Stock	237.79	240.83	235.55	238.79	30081300.0
2020-06-19	TSLA	Stock	67.5187	67.7313	66.0893	66.7267	130195500.0
2020-06-19	TLT	Stock	161.0	162.5	160.91	162.39	8565778.0
2020-06-19	ES	Stock	85.85	85.85	82.7	82.89	5681600.0
2020-06-19	CL	Stock	74.7	75.4	73.34	73.36	5842700.0
2020-06-19	A	Stock	89.41	89.79	87.76	88.73	1784700.0
2020-06-19	AA	Stock	11.98	12.0	11.34	11.48	8894300.0
2020-06-19	AACG	Stock	0.96	1.03	0.95	0.95	52500.0
2020-06-19	AAIC-DELISTED	Stock	2.95	2.97	2.82	2.82	1639171.0
2020-06-19	AAIC.C-DELISTED	Stock	19.55	20.09	19.55	20.09	400.0
2020-06-19	AAL	Stock	16.89	16.94	15.42	16.0	92320200.0
2020-06-19	AAM.A-DELISTED	Stock	26.23	26.23	26.11	26.18	4937.0
2020-06-19	AAM.B-DELISTED	Stock	26.0	26.0649	25.92	25.92	12321.0
2020-06-19	AAMC-DELISTED	Stock	5.2132	5.5118	4.9265	5.1353	34571.0
2020-06-19	AAME	Stock	2.15	2.15	1.95	1.96	24100.0
2020-06-19	AAMI	Stock	10.24	10.52	10.0	10.07	12096900.0
2020-06-19	AAOI	Stock	9.98	10.18	9.62	9.8	943700.0
2020-06-19	AAON	Stock	35.9133	36.02	35.2	35.5867	484800.0
2020-06-19	AAP	Stock	150.47	150.57	144.78	144.9	1042900.0
2020-06-19	AAT	Stock	30.24	30.3	28.28	28.28	1078000.0
2020-06-19	AAU-DELISTED	Stock	0.49	0.4942	0.4501	0.4704	349892.0
2020-06-19	AAUAF-DELISTED	Stock	0.49	0.4942	0.4501	0.4704	354484.0
2020-06-19	AAWW-DELISTED	Stock	40.62	41.25	40.235	40.84	482122.0
2020-06-19	AAXJ	Stock	69.69	69.69	68.59	68.7	1041741.0
2020-06-19	AAXN-DELISTED	Stock	92.78	93.49	88.6901	90.08	1689843.0
2020-06-19	AB	Stock	28.0	28.01	26.53	26.66	414800.0
2020-06-19	ABB-DELISTED	Stock	21.74	21.765	21.255	21.33	1900339.0
2020-06-19	ABBNY-DELISTED	Stock	21.74	21.765	21.255	21.32	1992609.0
2020-06-19	ABBV	Stock	97.72	98.2	95.75	96.71	9210900.0
2020-06-19	ABC-DELISTED	Stock	101.75	103.37	101.045	102.15	1411877.0
2020-06-19	ABCB	Stock	25.24	25.98	23.35	23.83	855600.0
2020-06-19	ABEO	Stock	78.5	80.5	76.5	78.5	31748.0
2020-06-19	ABEV	Stock	2.6	2.65	2.58	2.6	44839800.0
2020-06-19	ABG	Stock	78.95	78.95	74.5	74.98	315600.0
2020-06-19	ABM	Stock	39.43	40.78	37.82	38.29	1330600.0
2020-06-19	ABMD-DELISTED	Stock	254.22	260.45	250.895	256.72	530975.0
2020-06-19	ABR	Stock	9.79	10.03	9.54	9.67	2524900.0
2020-06-19	ABR.A-DELISTED	Stock	24.6456	25.1656	24.6274	24.95	919.0
2020-06-19	ABR.B-DELISTED	Stock	24.2016	24.402	23.27	23.55	7900.0
2020-06-19	ABR.C-DELISTED	Stock	25.06	25.06	25.06	25.06	100.0
2020-06-19	ABT	Stock	91.67	92.4	90.61	90.68	9473300.0
2020-06-19	ABTC	Stock	275400.0	283500.0	269700.0	271200.0	5.053333333333333
2020-06-19	ABTS	Stock	14.97	18.0	14.97	16.425	11633.0
2020-06-19	ABTX-DELISTED	Stock	24.92	25.0	24.01	24.42	219993.0
2020-06-19	ABUS	Stock	2.01	2.07	1.9	1.91	2579300.0

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

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