PREVIEW / stock_daily / 2020-06-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-05.parquet
  size:    221 KB
  rows:    6,666
  symbols: 2,374

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-05	AAPL	Stock	80.8375	82.9375	80.8075	82.875	137250400.0
2020-06-05	MSFT	Stock	182.62	187.73	182.01	187.2	39893600.0
2020-06-05	NVDA	Stock	8.7945	8.997	8.708	8.92	481748000.0
2020-06-05	AMZN	Stock	122.2255	124.4325	121.8565	124.15	66128000.0
2020-06-05	GOOGL	Stock	70.782	72.315	70.3811	72.001	42647000.0
2020-06-05	META	Stock	226.71	231.35	225.31	230.77	16750400.0
2020-06-05	TSLA	Stock	58.5227	59.1013	57.7467	59.044	117178500.0
2020-06-05	TLT	Stock	154.61	156.16	153.16	156.11	17778549.0
2020-06-05	ES	Stock	86.13	87.73	85.34	86.52	1669500.0
2020-06-05	CL	Stock	71.17	72.58	70.29	72.4	5976200.0
2020-06-05	A	Stock	92.13	93.04	90.09	90.38	2844700.0
2020-06-05	AA	Stock	12.69	13.86	11.57	12.07	18677600.0
2020-06-05	AACG	Stock	0.87	0.91	0.8	0.86	30000.0
2020-06-05	AAIC-DELISTED	Stock	3.11	3.3927	2.989	3.22	1691003.0
2020-06-05	AAIC.C-DELISTED	Stock	19.0	21.11	18.69	20.65	27580.0
2020-06-05	AAL	Stock	21.25	22.8	17.8	18.59	428617100.0
2020-06-05	AAM.A-DELISTED	Stock	26.29	26.29	25.95	26.06	14305.0
2020-06-05	AAM.B-DELISTED	Stock	26.25	26.3	26.15	26.25	20852.0
2020-06-05	AAMC-DELISTED	Stock	5.15	5.2941	4.9118	5.2941	70118.0
2020-06-05	AAME	Stock	1.9	1.9	1.76	1.8	3900.0
2020-06-05	AAMI	Stock	9.76	9.9	9.51	9.74	435000.0
2020-06-05	AAOI	Stock	10.0	10.145	9.73	9.98	1014300.0
2020-06-05	AAON	Stock	38.0467	39.14	37.58	38.9133	432000.0
2020-06-05	AAP	Stock	145.07	149.16	144.56	146.1	929300.0
2020-06-05	AAT	Stock	32.85	34.09	32.54	32.83	461400.0
2020-06-05	AAU-DELISTED	Stock	0.46	0.49	0.46	0.4801	255977.0
2020-06-05	AAUAF-DELISTED	Stock	0.46	0.49	0.46	0.48	278105.0
2020-06-05	AAWW-DELISTED	Stock	46.76	47.7	43.42	44.0	708877.0
2020-06-05	AAXJ	Stock	69.76	70.27	69.7	69.85	4575193.0
2020-06-05	AAXN-DELISTED	Stock	96.18	97.219	92.03	92.74	629923.0
2020-06-05	AB	Stock	27.4	27.66	26.18	26.3	590800.0
2020-06-05	ABB-DELISTED	Stock	21.8	21.91	21.55	21.63	1931819.0
2020-06-05	ABBNY-DELISTED	Stock	21.82	21.91	21.55	21.62	2078998.0
2020-06-05	ABBV	Stock	93.5	95.54	92.81	93.85	9630100.0
2020-06-05	ABC-DELISTED	Stock	99.57	102.21	98.51	98.96	1190198.0
2020-06-05	ABCB	Stock	28.63	29.55	28.05	28.53	501900.0
2020-06-05	ABEO	Stock	75.0	75.75	71.75	73.0	30888.0
2020-06-05	ABEV	Stock	2.8	2.9	2.77	2.82	50237900.0
2020-06-05	ABG	Stock	85.95	87.87	80.97	81.5	331200.0
2020-06-05	ABM	Stock	35.79	36.74	35.66	36.54	547700.0
2020-06-05	ABMD-DELISTED	Stock	237.23	251.865	236.1	249.88	398128.0
2020-06-05	ABR	Stock	10.05	10.39	9.61	9.73	3231600.0
2020-06-05	ABR.A-DELISTED	Stock	24.75	24.82	24.75	24.76	3276.0
2020-06-05	ABR.B-DELISTED	Stock	24.2889	24.49	23.8	24.1381	2469.0
2020-06-05	ABR.C-DELISTED	Stock	24.85	26.49	24.81	25.61	19486.0
2020-06-05	ABT	Stock	88.47	89.96	87.32	89.86	11874500.0
2020-06-05	ABTC	Stock	282000.0	282300.0	266400.0	274800.0	1.84
2020-06-05	ABTS	Stock	11.28	12.3	11.25	11.55	1853.0
2020-06-05	ABTX-DELISTED	Stock	28.81	29.83	27.15	29.16	76006.0
2020-06-05	ABUS	Stock	2.03	2.15	2.02	2.05	1225000.0

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

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