PREVIEW / stock_daily / 2020-09-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-22.parquet
  size:    226 KB
  rows:    6,888
  symbols: 2,462

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-09-22	AAPL	Stock	112.68	112.86	109.16	111.81	183055400.0
2020-09-22	MSFT	Stock	205.06	208.1	202.08	207.42	33517100.0
2020-09-22	NVDA	Stock	12.575	12.648	12.1555	12.6378	646452000.0
2020-09-22	AMZN	Stock	151.692	156.6995	150.01	156.4495	138976000.0
2020-09-22	GOOGL	Stock	72.516	73.1985	71.4748	72.991	33950840.0
2020-09-22	META	Stock	253.31	255.32	248.22	254.75	30293100.0
2020-09-22	TSLA	Stock	143.2	145.92	139.2	141.41	238742400.0
2020-09-22	TLT	Stock	164.44	164.88	163.87	164.27	10524495.0
2020-09-22	ES	Stock	77.84	79.56	77.77	78.98	1464000.0
2020-09-22	CL	Stock	75.24	76.57	75.22	76.07	2852500.0
2020-09-22	A	Stock	97.84	98.98	97.49	98.62	845800.0
2020-09-22	AA	Stock	12.36	12.42	11.89	12.21	4915000.0
2020-09-22	AACG	Stock	1.07	1.12	1.06	1.07	8600.0
2020-09-22	AACQ-DELISTED	Stock	10.04	10.04	9.91	9.92	65523.0
2020-09-22	AACQU-DELISTED	Stock	10.5	10.5	10.26	10.3	115254.0
2020-09-22	AACQW-DELISTED	Stock	1.6002	1.65	1.56	1.6	253902.0
2020-09-22	AAIC-DELISTED	Stock	2.66	2.7	2.63	2.66	246644.0
2020-09-22	AAIC.C-DELISTED	Stock	19.2	19.2	19.0	19.0	972.0
2020-09-22	AAL	Stock	12.3	12.5	12.18	12.34	33013400.0
2020-09-22	AAM.A-DELISTED	Stock	26.24	26.25	26.13	26.23	24366.0
2020-09-22	AAM.B-DELISTED	Stock	27.04	27.13	26.92	27.08	19297.0
2020-09-22	AAMC-DELISTED	Stock	5.9618	6.0912	5.8176	5.9441	34877.0
2020-09-22	AAME	Stock	2.2	2.2	2.05	2.13	2200.0
2020-09-22	AAMI	Stock	13.07	13.2	12.72	13.03	374000.0
2020-09-22	AAOI	Stock	11.19	11.68	10.84	11.11	814500.0
2020-09-22	AAON	Stock	37.4533	38.0533	37.0933	37.9933	267450.0
2020-09-22	AAP	Stock	148.99	152.46	146.42	150.11	1244900.0
2020-09-22	AAT	Stock	23.51	24.01	23.38	23.8	424900.0
2020-09-22	AAU-DELISTED	Stock	0.88	0.9201	0.875	0.9066	409476.0
2020-09-22	AAUAF-DELISTED	Stock	0.88	0.9201	0.875	0.9001	427126.0
2020-09-22	AAWW-DELISTED	Stock	59.84	60.863	59.38	60.44	265252.0
2020-09-22	AAXJ	Stock	76.68	76.7	75.845	76.48	1250491.0
2020-09-22	AAXN-DELISTED	Stock	84.01	87.12	83.07	86.95	782310.0
2020-09-22	AB	Stock	27.13	27.5	26.94	27.37	370500.0
2020-09-22	ABB-DELISTED	Stock	25.14	25.225	24.96	25.19	1036714.0
2020-09-22	ABBNY-DELISTED	Stock	25.14	25.225	24.96	25.19	1112634.0
2020-09-22	ABBV	Stock	88.9	88.95	87.93	88.6	5306100.0
2020-09-22	ABC-DELISTED	Stock	95.69	96.125	94.81	95.26	496458.0
2020-09-22	ABCB	Stock	21.36	22.24	21.25	21.52	795100.0
2020-09-22	ABEO	Stock	48.75	48.75	46.75	48.0	29860.0
2020-09-22	ABEV	Stock	2.36	2.39	2.34	2.36	8512900.0
2020-09-22	ABG	Stock	95.81	99.59	95.81	98.71	159900.0
2020-09-22	ABM	Stock	37.06	37.75	36.69	37.5	339400.0
2020-09-22	ABMD-DELISTED	Stock	266.99	269.4	261.23	268.99	124521.0
2020-09-22	ABR	Stock	11.46	11.82	11.39	11.46	866000.0
2020-09-22	ABR.A-DELISTED	Stock	25.47	25.5562	25.1	25.16	3487.0
2020-09-22	ABR.B-DELISTED	Stock	25.0	25.0	24.895	25.0	800.0
2020-09-22	ABR.C-DELISTED	Stock	25.2902	25.5896	25.2902	25.5896	1073.0
2020-09-22	ABT	Stock	105.46	105.52	103.57	104.8	4180300.0
2020-09-22	ABTC	Stock	120900.0	124200.0	119400.0	120900.0	5.493333333333334

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

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