PREVIEW / stock_daily / 2021-07-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-21.parquet
  size:    258 KB
  rows:    7,897
  symbols: 2,836

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-07-21	AAPL	Stock	145.53	146.13	144.63	145.4	74993500.0
2021-07-21	MSFT	Stock	278.9	281.52	277.29	281.4	24364300.0
2021-07-21	NVDA	Stock	18.882	19.527	18.742	19.41	371017000.0
2021-07-21	AMZN	Stock	178.819	179.3225	177.182	179.26	46380000.0
2021-07-21	GOOGL	Stock	126.1335	127.596	126.0235	127.549	20746180.0
2021-07-21	META	Stock	341.5	346.52	341.25	346.23	9279700.0
2021-07-21	TSLA	Stock	219.87	221.62	216.7633	218.43	41859900.0
2021-07-21	TLT	Stock	148.18	148.5	146.67	148.1	19988911.0
2021-07-21	ES	Stock	85.62	85.77	83.35	83.78	2331000.0
2021-07-21	CL	Stock	82.78	82.98	82.06	82.18	3579600.0
2021-07-21	A	Stock	149.49	149.91	147.6	148.95	2255700.0
2021-07-21	AA	Stock	35.25	37.41	35.25	37.09	11877700.0
2021-07-21	AAC-DELISTED	Stock	9.7521	9.77	9.74	9.77	14671.0
2021-07-21	AACG	Stock	3.25	3.41	3.14	3.19	278800.0
2021-07-21	AAIC-DELISTED	Stock	3.79	3.98	3.79	3.95	539476.0
2021-07-21	AAIC.C-DELISTED	Stock	25.2835	25.2985	25.15	25.15	1200.0
2021-07-21	AAL	Stock	20.79	21.55	20.75	21.4	52282600.0
2021-07-21	AAM.A-DELISTED	Stock	26.641	26.6526	26.47	26.48	6462.0
2021-07-21	AAM.B-DELISTED	Stock	27.02	27.07	26.9658	27.05	18471.0
2021-07-21	AAMC-DELISTED	Stock	4.8529	5.1324	4.8529	5.0353	44122.0
2021-07-21	AAME	Stock	3.88	4.07	3.88	3.99	24000.0
2021-07-21	AAMI	Stock	23.48	23.98	23.375	23.88	384500.0
2021-07-21	AAN-DELISTED	Stock	28.8	29.65	28.545	28.98	224600.0
2021-07-21	AAOI	Stock	7.44	7.81	7.44	7.71	319400.0
2021-07-21	AAON	Stock	41.2267	41.7067	40.9333	41.1867	143700.0
2021-07-21	AAP	Stock	211.06	212.21	209.08	209.4	620400.0
2021-07-21	AAQC-DELISTED	Stock	9.68	9.68	9.68	9.68	150542.0
2021-07-21	AAT	Stock	36.98	37.69	36.98	37.42	430300.0
2021-07-21	AATC	Stock	6.0501	8.4399	6.0501	6.52	118256.0
2021-07-21	AAU-DELISTED	Stock	0.42	0.4378	0.4171	0.4371	580947.0
2021-07-21	AAUAF-DELISTED	Stock	0.42	0.4378	0.4171	0.4375	595674.0
2021-07-21	AAWW-DELISTED	Stock	65.0	66.29	65.0	65.54	152752.0
2021-07-21	AAXJ	Stock	90.36	91.13	89.98	91.11	403877.0
2021-07-21	AB	Stock	45.5	46.25	45.15	46.03	240800.0
2021-07-21	ABB-DELISTED	Stock	35.36	35.865	35.36	35.84	1598531.0
2021-07-21	ABBNY-DELISTED	Stock	35.36	35.865	35.36	35.84	1800847.0
2021-07-21	ABBV	Stock	116.64	117.07	115.79	116.99	4133800.0
2021-07-21	ABC-DELISTED	Stock	116.81	118.42	116.69	118.22	1338986.0
2021-07-21	ABCB	Stock	47.09	47.97	47.08	47.48	327200.0
2021-07-21	ABCL	Stock	16.37	16.97	16.36	16.62	893100.0
2021-07-21	ABCM-DELISTED	Stock	17.66	17.66	17.35	17.49	232974.0
2021-07-21	ABEO	Stock	32.25	35.0	31.75	33.75	31568.0
2021-07-21	ABEV	Stock	3.23	3.28	3.19	3.26	25459600.0
2021-07-21	ABG	Stock	195.95	200.91	195.27	197.11	162200.0
2021-07-21	ABGI-DELISTED	Stock	9.8572	9.8572	9.81	9.81	300.0
2021-07-21	ABM	Stock	46.3	46.8	45.45	45.71	393200.0
2021-07-21	ABMD-DELISTED	Stock	325.17	325.17	318.5	322.85	69752.0
2021-07-21	ABNB	Stock	136.71	140.15	135.725	139.25	5269600.0
2021-07-21	ABOS	Stock	18.31	19.095	17.15	17.17	109900.0
2021-07-21	ABR	Stock	17.93	18.08	17.81	17.85	1032700.0

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

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