PREVIEW / stock_daily / 2021-07-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-13.parquet
  size:    257 KB
  rows:    7,877
  symbols: 2,857

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-13	AAPL	Stock	144.03	147.46	143.63	145.64	100827100.0
2021-07-13	MSFT	Stock	277.52	282.85	277.39	280.98	26120100.0
2021-07-13	NVDA	Stock	20.4005	20.4613	20.114	20.25	290708000.0
2021-07-13	AMZN	Stock	185.105	188.654	183.566	183.868	76918000.0
2021-07-13	GOOGL	Stock	127.0385	128.0575	126.6745	127.3415	19246940.0
2021-07-13	META	Stock	351.5	358.49	348.8	352.09	11456000.0
2021-07-13	TSLA	Stock	228.7733	231.0933	222.1	222.8467	62898300.0
2021-07-13	TLT	Stock	146.82	147.46	144.64	145.22	23340375.0
2021-07-13	ES	Stock	82.38	83.43	82.23	82.93	2198500.0
2021-07-13	CL	Stock	82.78	83.32	82.35	82.64	2733700.0
2021-07-13	A	Stock	149.11	149.54	148.19	149.27	1456500.0
2021-07-13	AA	Stock	37.15	37.18	35.22	35.62	8073400.0
2021-07-13	AAC-DELISTED	Stock	9.84	9.84	9.79	9.81	282772.0
2021-07-13	AACG	Stock	2.78	2.92	2.75	2.8	40500.0
2021-07-13	AAIC-DELISTED	Stock	3.91	3.93	3.81	3.81	277315.0
2021-07-13	AAIC.C-DELISTED	Stock	25.39	25.39	25.39	25.39	100.0
2021-07-13	AAL	Stock	20.69	20.7	19.99	20.02	30951500.0
2021-07-13	AAM.A-DELISTED	Stock	26.6	26.62	26.34	26.56	14185.0
2021-07-13	AAM.B-DELISTED	Stock	27.04	27.0891	26.82	26.85	9142.0
2021-07-13	AAMC-DELISTED	Stock	5.3029	5.3029	5.1588	5.1588	3788.0
2021-07-13	AAME	Stock	4.25	4.43	4.25	4.38	16400.0
2021-07-13	AAMI	Stock	24.0	24.14	23.68	23.84	275600.0
2021-07-13	AAN-DELISTED	Stock	30.56	30.73	29.215	29.4	289700.0
2021-07-13	AAOI	Stock	7.94	7.99	7.82	7.83	248700.0
2021-07-13	AAON	Stock	41.5	41.9333	41.0133	41.0133	114900.0
2021-07-13	AAP	Stock	211.04	212.13	208.82	208.97	689000.0
2021-07-13	AAT	Stock	37.93	37.96	36.82	36.95	288600.0
2021-07-13	AAU-DELISTED	Stock	0.4701	0.4799	0.4701	0.4713	341617.0
2021-07-13	AAUAF-DELISTED	Stock	0.4701	0.4799	0.4701	0.4713	354685.0
2021-07-13	AAWW-DELISTED	Stock	67.3	68.44	66.27	66.29	165245.0
2021-07-13	AAXJ	Stock	92.13	92.63	92.055	92.14	460204.0
2021-07-13	AB	Stock	46.85	46.85	45.51	45.72	209300.0
2021-07-13	ABB-DELISTED	Stock	35.79	35.95	35.71	35.72	836165.0
2021-07-13	ABBNY-DELISTED	Stock	35.79	35.95	35.71	35.71	929915.0
2021-07-13	ABBV	Stock	117.59	118.09	116.69	117.91	6540300.0
2021-07-13	ABC-DELISTED	Stock	115.29	115.82	114.14	114.22	640753.0
2021-07-13	ABCB	Stock	49.61	49.76	48.31	48.54	324700.0
2021-07-13	ABCL	Stock	18.58	18.67	17.78	17.83	1625000.0
2021-07-13	ABCM-DELISTED	Stock	18.7	18.96	18.66	18.75	93902.0
2021-07-13	ABEO	Stock	36.25	36.25	33.75	34.5	43688.0
2021-07-13	ABEV	Stock	3.38	3.46	3.37	3.44	30537500.0
2021-07-13	ABG	Stock	187.22	192.34	185.6	189.22	249700.0
2021-07-13	ABM	Stock	44.0	44.36	43.8	44.1	549700.0
2021-07-13	ABMD-DELISTED	Stock	320.69	322.61	317.37	319.23	69537.0
2021-07-13	ABNB	Stock	147.695	147.695	143.0	143.41	5871500.0
2021-07-13	ABOS	Stock	18.36	19.0	18.09	18.94	81200.0
2021-07-13	ABR	Stock	18.23	18.23	17.86	17.99	1019200.0
2021-07-13	ABR.D	Stock	25.65	25.65	25.5	25.55	50403.0
2021-07-13	ABST-DELISTED	Stock	14.21	14.31	13.939	14.04	46618.0
2021-07-13	ABT	Stock	118.57	119.26	118.11	118.65	3877100.0

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

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