PREVIEW / stock_daily / 2021-03-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-22.parquet
  size:    252 KB
  rows:    7,654
  symbols: 2,878

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
2021-03-22	AAPL	Stock	120.33	123.87	120.26	123.39	111912300.0
2021-03-22	MSFT	Stock	230.27	236.9	230.14	235.99	30127000.0
2021-03-22	NVDA	Stock	12.9128	13.3945	12.9068	13.1862	297804000.0
2021-03-22	AMZN	Stock	153.3925	156.329	153.0025	155.5435	58044000.0
2021-03-22	GOOGL	Stock	101.3815	102.417	100.7	101.5345	33535420.0
2021-03-22	META	Stock	290.45	299.71	286.75	293.54	28273100.0
2021-03-22	TSLA	Stock	228.1967	233.2067	222.9167	223.3333	118536600.0
2021-03-22	TLT	Stock	135.69	136.41	135.37	136.26	17047525.0
2021-03-22	ES	Stock	82.07	82.68	81.04	82.25	1644400.0
2021-03-22	CL	Stock	74.98	75.93	74.84	75.77	8160500.0
2021-03-22	A	Stock	122.17	123.83	121.72	123.61	1772900.0
2021-03-22	AA	Stock	31.23	31.42	30.08	30.43	3552300.0
2021-03-22	AACG	Stock	5.32	6.06	4.87	5.01	2423600.0
2021-03-22	AACQ-DELISTED	Stock	10.36	10.36	10.26	10.32	833374.0
2021-03-22	AACQU-DELISTED	Stock	11.23	11.23	10.96	11.07	5072.0
2021-03-22	AACQW-DELISTED	Stock	2.35	2.415	2.06	2.06	259143.0
2021-03-22	AAIC-DELISTED	Stock	3.98	4.09	3.93	4.04	168739.0
2021-03-22	AAIC.C-DELISTED	Stock	22.41	22.4124	22.25	22.3985	11030.0
2021-03-22	AAL	Stock	24.62	24.7	23.76	23.83	42676000.0
2021-03-22	AAM.A-DELISTED	Stock	25.93	26.01	25.91	25.95	19729.0
2021-03-22	AAM.B-DELISTED	Stock	26.63	26.78	26.63	26.76	14492.0
2021-03-22	AAMC-DELISTED	Stock	4.9206	5.5294	4.9206	5.1618	33711.0
2021-03-22	AAME	Stock	5.44	5.48	5.06	5.33	630600.0
2021-03-22	AAMI	Stock	20.08	20.08	19.35	19.8	469900.0
2021-03-22	AAN-DELISTED	Stock	25.8	26.49	25.33	25.46	257800.0
2021-03-22	AAOI	Stock	8.51	8.662	8.37	8.48	529000.0
2021-03-22	AAON	Stock	48.4467	48.4467	46.7867	47.32	192300.0
2021-03-22	AAP	Stock	185.02	187.33	180.02	182.99	900800.0
2021-03-22	AAT	Stock	33.76	33.76	32.6	32.97	248000.0
2021-03-22	AAU-DELISTED	Stock	0.6179	0.6179	0.5857	0.5955	3318447.0
2021-03-22	AAUAF-DELISTED	Stock	0.6179	0.6179	0.5857	0.5955	3380187.0
2021-03-22	AAWW-DELISTED	Stock	59.05	59.9583	58.31	59.44	259103.0
2021-03-22	AAXJ	Stock	94.05	94.525	93.63	94.22	548080.0
2021-03-22	AB	Stock	42.36	42.72	41.72	41.87	479800.0
2021-03-22	ABB-DELISTED	Stock	31.41	31.75	31.38	31.57	1665323.0
2021-03-22	ABBNY-DELISTED	Stock	31.41	31.75	31.38	31.56	1907783.0
2021-03-22	ABBV	Stock	103.5	106.4	102.88	105.9	7627200.0
2021-03-22	ABC-DELISTED	Stock	115.87	116.42	114.19	116.35	486672.0
2021-03-22	ABCB	Stock	55.87	55.87	53.63	54.15	520200.0
2021-03-22	ABCL	Stock	31.99	32.34	30.22	30.58	543200.0
2021-03-22	ABCM-DELISTED	Stock	20.68	21.18	20.22	20.75	999572.0
2021-03-22	ABEO	Stock	54.25	55.0	50.75	51.0	61616.0
2021-03-22	ABEV	Stock	2.84	2.88	2.81	2.88	25434900.0
2021-03-22	ABG	Stock	188.81	190.43	182.58	186.41	149500.0
2021-03-22	ABGI-DELISTED	Stock	10.0	10.02	9.92	10.005	15103.0
2021-03-22	ABM	Stock	50.54	50.99	49.12	49.7	260600.0
2021-03-22	ABMD-DELISTED	Stock	302.87	307.31	302.235	306.36	226751.0
2021-03-22	ABNB	Stock	196.85	203.3	194.71	195.0	3740400.0
2021-03-22	ABR	Stock	16.61	16.61	16.24	16.41	967800.0
2021-03-22	ABR.A-DELISTED	Stock	25.66	25.75	25.66	25.7499	1468.0

> showing 50 of 7,654 rows — these rows as CSV

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