PREVIEW / stock_daily / 2020-03-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-23.parquet
  size:    210 KB
  rows:    6,678
  symbols: 2,414

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-03-23	AAPL	Stock	57.02	57.125	53.1525	56.0925	336752800.0
2020-03-23	MSFT	Stock	137.01	140.57	132.52	135.98	78975200.0
2020-03-23	NVDA	Stock	5.1428	5.412	4.963	5.3173	643876000.0
2020-03-23	AMZN	Stock	91.3875	95.97	90.6	95.1415	156170000.0
2020-03-23	GOOGL	Stock	52.8185	53.3455	50.4435	52.7065	83672580.0
2020-03-23	META	Stock	149.66	152.31	142.25	148.1	29830800.0
2020-03-23	TSLA	Stock	28.9067	29.4667	27.3667	28.9527	246817500.0
2020-03-23	TLT	Stock	157.5	166.69	156.57	166.0	19971809.0
2020-03-23	ES	Stock	67.69	67.89	60.69	62.23	3432000.0
2020-03-23	CL	Stock	62.09	63.47	58.49	60.47	8306800.0
2020-03-23	A	Stock	66.8	67.56	62.09	63.37	2989600.0
2020-03-23	AA	Stock	5.5	5.945	5.16	5.67	7018500.0
2020-03-23	AACG	Stock	0.9	0.9	0.8	0.84	9000.0
2020-03-23	AAIC-DELISTED	Stock	2.13	2.18	1.88	2.02	1032675.0
2020-03-23	AAIC.C-DELISTED	Stock	9.7185	9.99	7.5	8.95	68357.0
2020-03-23	AAL	Stock	10.9	11.36	10.01	10.25	56427300.0
2020-03-23	AAM.A-DELISTED	Stock	19.21	19.26	16.5317	16.83	59115.0
2020-03-23	AAM.B-DELISTED	Stock	18.7	18.7	16.6001	16.91	84439.0
2020-03-23	AAMC-DELISTED	Stock	3.2353	3.3941	3.0147	3.1069	19791.0
2020-03-23	AAME	Stock	2.24	2.24	2.24	2.24	200.0
2020-03-23	AAMI	Stock	4.54	4.92	4.3	4.68	814700.0
2020-03-23	AAOI	Stock	7.05	7.5	6.775	6.9	959600.0
2020-03-23	AAON	Stock	30.8133	32.58	29.8133	31.8333	467100.0
2020-03-23	AAP	Stock	74.97	79.94	71.33	78.5	1476000.0
2020-03-23	AAT	Stock	22.22	22.96	21.06	22.05	543700.0
2020-03-23	AAU-DELISTED	Stock	0.25	0.25	0.2121	0.242	395166.0
2020-03-23	AAUAF-DELISTED	Stock	0.25	0.25	0.2121	0.242	425780.0
2020-03-23	AAWW-DELISTED	Stock	23.5	24.52	22.37	24.2301	869207.0
2020-03-23	AAXJ	Stock	54.57	54.59	52.95	53.81	1296094.0
2020-03-23	AAXN-DELISTED	Stock	60.53	65.01	58.06	63.44	623614.0
2020-03-23	AB	Stock	15.35	15.77	14.02	15.31	1319200.0
2020-03-23	ABB-DELISTED	Stock	15.47	15.62	14.71	14.86	5651275.0
2020-03-23	ABBNY-DELISTED	Stock	15.47	15.62	14.71	14.85	5972531.0
2020-03-23	ABBV	Stock	67.38	67.75	62.55	64.5	19219000.0
2020-03-23	ABC-DELISTED	Stock	80.29	80.29	72.0583	73.92	1806200.0
2020-03-23	ABCB	Stock	21.05	21.42	17.89	18.94	571000.0
2020-03-23	ABEO	Stock	53.25	53.75	45.75	48.75	48156.0
2020-03-23	ABEV	Stock	2.34	2.41	2.2	2.25	38765900.0
2020-03-23	ABG	Stock	52.61	52.89	45.19	45.82	321300.0
2020-03-23	ABM	Stock	21.25	22.6	20.13	20.45	581800.0
2020-03-23	ABMD-DELISTED	Stock	132.39	134.74	119.0101	132.48	926378.0
2020-03-23	ABR	Stock	5.02	5.05	3.86	4.27	3945300.0
2020-03-23	ABR.A-DELISTED	Stock	15.0	15.09	12.8118	14.375	10106.0
2020-03-23	ABR.B-DELISTED	Stock	16.25	16.25	12.0	15.45	9708.0
2020-03-23	ABR.C-DELISTED	Stock	16.94	16.97	13.927	16.12	5174.0
2020-03-23	ABT	Stock	67.07	67.49	61.61	62.82	13037100.0
2020-03-23	ABTC	Stock	119100.0	122400.0	112200.0	122100.0	2.893333333333333
2020-03-23	ABTS	Stock	12.0	15.45	12.0	13.05	187.0
2020-03-23	ABTX-DELISTED	Stock	25.02	27.88	22.135	22.7	95653.0
2020-03-23	ABUS	Stock	1.46	1.67	1.4	1.65	173000.0

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

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