PREVIEW / stock_daily / 2020-09-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-29.parquet
  size:    226 KB
  rows:    6,889
  symbols: 2,452

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-29	AAPL	Stock	114.55	115.31	113.57	114.09	99382200.0
2020-09-29	MSFT	Stock	209.35	210.07	206.81	207.26	24221900.0
2020-09-29	NVDA	Stock	12.9375	13.4428	12.9333	13.2258	621460000.0
2020-09-29	AMZN	Stock	158.7695	159.413	156.627	157.244	69916000.0
2020-09-29	GOOGL	Stock	73.1955	73.6	72.7	73.301	31822240.0
2020-09-29	META	Stock	257.81	263.33	256.9	261.79	20200200.0
2020-09-29	TSLA	Stock	138.6667	142.8333	137.2	139.69	150657900.0
2020-09-29	TLT	Stock	164.8	165.24	164.56	164.84	10297950.0
2020-09-29	ES	Stock	82.94	83.67	82.61	83.01	778700.0
2020-09-29	CL	Stock	76.67	76.78	75.85	76.22	2076000.0
2020-09-29	A	Stock	99.79	101.33	99.59	100.22	722400.0
2020-09-29	AA	Stock	12.18	12.18	11.55	11.67	5169800.0
2020-09-29	AACG	Stock	1.13	1.17	1.09	1.13	78800.0
2020-09-29	AACQ-DELISTED	Stock	10.03	10.03	9.9101	9.94	88069.0
2020-09-29	AACQU-DELISTED	Stock	10.45	10.5	10.4	10.4112	13927.0
2020-09-29	AACQW-DELISTED	Stock	1.67	1.67	1.5	1.5299	121059.0
2020-09-29	AAIC-DELISTED	Stock	2.84	2.86	2.7745	2.85	233496.0
2020-09-29	AAIC.C-DELISTED	Stock	18.83	19.0	18.83	19.0	1100.0
2020-09-29	AAL	Stock	12.59	12.66	12.11	12.25	46994300.0
2020-09-29	AAM.A-DELISTED	Stock	26.275	26.35	26.275	26.32	9907.0
2020-09-29	AAM.B-DELISTED	Stock	27.2699	27.2699	27.17	27.2215	7263.0
2020-09-29	AAMC-DELISTED	Stock	6.1176	6.1176	5.5588	5.75	20563.0
2020-09-29	AAME	Stock	1.98	2.03	1.98	1.98	2100.0
2020-09-29	AAMI	Stock	13.0	13.17	12.71	12.89	375500.0
2020-09-29	AAOI	Stock	10.95	11.36	10.856	11.24	386300.0
2020-09-29	AAON	Stock	38.8933	39.84	38.8933	39.7267	259950.0
2020-09-29	AAP	Stock	153.89	153.89	151.66	151.71	610400.0
2020-09-29	AAT	Stock	24.43	24.43	23.53	23.98	228700.0
2020-09-29	AAU-DELISTED	Stock	0.86	0.8899	0.82	0.8205	358599.0
2020-09-29	AAUAF-DELISTED	Stock	0.86	0.8899	0.82	0.8258	369350.0
2020-09-29	AAWW-DELISTED	Stock	62.02	63.31	61.01	61.24	356249.0
2020-09-29	AAXJ	Stock	75.83	76.22	75.75	75.96	396364.0
2020-09-29	AAXN-DELISTED	Stock	87.92	89.15	87.1	88.61	291249.0
2020-09-29	AB	Stock	27.45	27.45	26.75	27.03	305900.0
2020-09-29	ABB-DELISTED	Stock	25.64	25.76	25.52	25.61	872456.0
2020-09-29	ABBNY-DELISTED	Stock	25.64	25.76	25.52	25.61	2143693.0
2020-09-29	ABBV	Stock	87.11	87.28	86.31	86.89	5508900.0
2020-09-29	ABC-DELISTED	Stock	97.47	97.58	95.92	96.17	509951.0
2020-09-29	ABCB	Stock	22.47	22.79	22.07	22.76	392100.0
2020-09-29	ABEO	Stock	28.75	29.0	27.25	27.75	264456.0
2020-09-29	ABEV	Stock	2.22	2.28	2.19	2.19	33354400.0
2020-09-29	ABG	Stock	99.17	99.17	93.79	95.5	138200.0
2020-09-29	ABM	Stock	37.47	37.58	36.41	36.92	359500.0
2020-09-29	ABMD-DELISTED	Stock	271.31	279.44	271.31	272.47	78656.0
2020-09-29	ABR	Stock	11.94	11.94	11.43	11.51	775800.0
2020-09-29	ABR.A-DELISTED	Stock	25.315	25.315	25.315	25.315	400.0
2020-09-29	ABR.B-DELISTED	Stock	25.08	25.2	25.035	25.1999	2066.0
2020-09-29	ABR.C-DELISTED	Stock	25.46	25.8	25.4192	25.8	4507.0
2020-09-29	ABT	Stock	106.01	106.41	104.92	105.19	4464300.0
2020-09-29	ABTC	Stock	107100.0	112650.0	102300.0	111600.0	3.32

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

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