PREVIEW / stock_daily / 2021-07-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-19.parquet
  size:    258 KB
  rows:    7,940
  symbols: 2,873

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-19	AAPL	Stock	143.75	144.07	141.67	142.45	121434600.0
2021-07-19	MSFT	Stock	278.93	280.37	274.45	277.01	32935600.0
2021-07-19	NVDA	Stock	17.9152	19.042	17.8655	18.7798	749060000.0
2021-07-19	AMZN	Stock	176.629	177.5105	174.958	177.4795	75692000.0
2021-07-19	GOOGL	Stock	126.0895	126.205	123.505	124.578	27967580.0
2021-07-19	META	Stock	337.57	339.79	334.54	336.95	14372300.0
2021-07-19	TSLA	Stock	209.9633	215.7333	207.0967	215.4067	63891300.0
2021-07-19	TLT	Stock	150.95	151.95	150.62	151.46	40203891.0
2021-07-19	ES	Stock	87.26	88.2	85.34	86.23	2312600.0
2021-07-19	CL	Stock	84.38	84.96	83.18	83.97	4960200.0
2021-07-19	A	Stock	147.66	147.97	146.95	147.58	1835100.0
2021-07-19	AA	Stock	31.99	32.45	30.995	31.62	12140800.0
2021-07-19	AAC-DELISTED	Stock	9.76	9.76	9.73	9.74	288153.0
2021-07-19	AACG	Stock	2.91	2.99	2.65	2.98	650200.0
2021-07-19	AAIC-DELISTED	Stock	3.7	3.75	3.64	3.71	263159.0
2021-07-19	AAIC.C-DELISTED	Stock	25.15	25.4	25.15	25.29	2449.0
2021-07-19	AAL	Stock	18.83	19.21	18.28	18.97	63985800.0
2021-07-19	AAM.A-DELISTED	Stock	26.46	26.54	26.3616	26.3801	13502.0
2021-07-19	AAM.B-DELISTED	Stock	27.03	27.05	26.91	26.995	16169.0
2021-07-19	AAMC-DELISTED	Stock	4.8865	5.0059	4.8529	4.9382	31345.0
2021-07-19	AAME	Stock	4.03	4.09	3.62	3.89	108300.0
2021-07-19	AAMI	Stock	23.29	23.41	22.85	23.09	677900.0
2021-07-19	AAN-DELISTED	Stock	27.29	28.15	27.05	27.37	280700.0
2021-07-19	AAOI	Stock	7.22	7.31	6.95	7.27	685200.0
2021-07-19	AAON	Stock	40.26	41.02	40.0133	40.7133	186600.0
2021-07-19	AAP	Stock	203.05	206.38	202.64	205.67	602400.0
2021-07-19	AAQC-DELISTED	Stock	9.69	9.75	9.69	9.75	75361.0
2021-07-19	AAT	Stock	36.24	36.65	34.78	34.99	412500.0
2021-07-19	AAU-DELISTED	Stock	0.45	0.4535	0.4124	0.4126	1117115.0
2021-07-19	AAUAF-DELISTED	Stock	0.45	0.4535	0.4124	0.415	1146961.0
2021-07-19	AAWW-DELISTED	Stock	62.96	63.53	62.13	63.5	339140.0
2021-07-19	AAXJ	Stock	90.33	90.46	89.83	90.25	2803780.0
2021-07-19	AB	Stock	44.65	44.73	43.62	44.35	384100.0
2021-07-19	ABB-DELISTED	Stock	34.51	34.56	34.25	34.43	2128679.0
2021-07-19	ABBNY-DELISTED	Stock	34.51	34.56	34.25	34.42	2250801.0
2021-07-19	ABBV	Stock	116.67	117.0	113.74	115.42	6762000.0
2021-07-19	ABC-DELISTED	Stock	112.09	113.31	111.34	112.7	570073.0
2021-07-19	ABCB	Stock	45.63	46.15	44.92	45.58	472200.0
2021-07-19	ABCL	Stock	16.58	16.95	16.08	16.42	1195500.0
2021-07-19	ABCM-DELISTED	Stock	17.75	18.0	17.62	17.7	152462.0
2021-07-19	ABEO	Stock	32.0	32.25	29.0	30.75	84916.0
2021-07-19	ABEV	Stock	3.28	3.31	3.17	3.21	35854300.0
2021-07-19	ABG	Stock	180.95	187.85	178.5	184.82	176000.0
2021-07-19	ABGI-DELISTED	Stock	9.79	9.84	9.79	9.84	2089.0
2021-07-19	ABM	Stock	45.57	45.62	44.17	44.61	951900.0
2021-07-19	ABMD-DELISTED	Stock	316.81	317.08	311.0	314.94	67886.0
2021-07-19	ABNB	Stock	131.36	133.77	130.31	131.88	7215700.0
2021-07-19	ABOS	Stock	17.76	20.29	17.274	19.11	82800.0
2021-07-19	ABR	Stock	17.34	17.48	16.82	17.29	2566600.0
2021-07-19	ABR.D	Stock	25.39	25.5187	25.3766	25.48	18739.0

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

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