PREVIEW / stock_daily / 2021-11-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-09.parquet
  size:    260 KB
  rows:    7,953
  symbols: 2,661

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-11-09	AAPL	Stock	150.2	151.43	150.06	150.81	56787900.0
2021-11-09	MSFT	Stock	337.11	338.72	334.53	335.95	21307400.0
2021-11-09	NVDA	Stock	32.282	32.31	29.964	30.657	646746000.0
2021-11-09	AMZN	Stock	175.7625	179.6885	175.0715	178.8115	85898000.0
2021-11-09	GOOGL	Stock	149.233	149.8345	147.2448	148.9185	19529740.0
2021-11-09	META	Stock	340.0	341.31	334.47	335.37	17556700.0
2021-11-09	TSLA	Stock	391.2	391.5	337.1733	341.1667	177317400.0
2021-11-09	TLT	Stock	150.8	151.767	150.64	150.96	23430239.0
2021-11-09	ES	Stock	82.79	83.66	82.68	83.32	1421500.0
2021-11-09	CL	Stock	77.87	78.18	77.49	78.05	3854900.0
2021-11-09	A	Stock	160.94	162.23	159.52	159.81	1021000.0
2021-11-09	AA	Stock	48.72	49.16	46.75	47.24	7051500.0
2021-11-09	AAC-DELISTED	Stock	9.82	9.83	9.78	9.81	652200.0
2021-11-09	AACG	Stock	2.35	2.35	2.28	2.31	19700.0
2021-11-09	AACIU	Stock	9.95	9.98	9.95	9.98	4514.0
2021-11-09	AAIC-DELISTED	Stock	3.85	3.9	3.85	3.86	113474.0
2021-11-09	AAIC.C-DELISTED	Stock	25.58	25.58	25.58	25.58	100.0
2021-11-09	AAL	Stock	22.12	22.33	21.7	22.26	22013200.0
2021-11-09	AAM.A-DELISTED	Stock	25.89	25.94	25.84	25.92	24313.0
2021-11-09	AAM.B-DELISTED	Stock	27.025	27.0421	27.02	27.03	2767.0
2021-11-09	AAMC-DELISTED	Stock	7.2132	7.2335	7.1941	7.1941	5134.0
2021-11-09	AAME	Stock	4.31	4.41	4.21	4.41	7600.0
2021-11-09	AAMI	Stock	30.35	30.445	30.13	30.31	1902300.0
2021-11-09	AAN-DELISTED	Stock	26.35	27.1	26.094	26.39	234200.0
2021-11-09	AAOI	Stock	5.9	5.94	5.73	5.75	1238000.0
2021-11-09	AAON	Stock	49.76	51.32	49.74	51.1067	271650.0
2021-11-09	AAP	Stock	228.01	233.59	228.01	232.39	587800.0
2021-11-09	AAQC-DELISTED	Stock	9.85	9.92	9.79	9.79	11141.0
2021-11-09	AAT	Stock	39.07	39.64	39.07	39.61	196800.0
2021-11-09	AATC	Stock	6.9741	6.99	6.86	6.9	12539.0
2021-11-09	AAU-DELISTED	Stock	0.3866	0.4099	0.372	0.4015	1359890.0
2021-11-09	AAUAF-DELISTED	Stock	0.3866	0.4099	0.372	0.4024	1457451.0
2021-11-09	AAWW-DELISTED	Stock	86.0	86.58	83.61	84.29	263973.0
2021-11-09	AAXJ	Stock	86.652	86.96	86.11	86.26	4694597.0
2021-11-09	AB	Stock	56.22	56.77	56.11	56.59	136200.0
2021-11-09	ABB-DELISTED	Stock	35.0	35.0699	34.835	35.02	685634.0
2021-11-09	ABBNY-DELISTED	Stock	35.0	35.0699	34.835	35.01	788755.0
2021-11-09	ABBV	Stock	116.24	116.59	115.41	115.61	3146800.0
2021-11-09	ABC-DELISTED	Stock	125.63	126.38	124.53	124.68	596168.0
2021-11-09	ABCB	Stock	54.99	55.52	54.33	54.9	240700.0
2021-11-09	ABCL	Stock	15.4	15.5	14.66	14.71	2436700.0
2021-11-09	ABCM-DELISTED	Stock	23.2	23.35	22.94	23.26	17886.0
2021-11-09	ABEO	Stock	24.25	26.5	23.0	24.25	64168.0
2021-11-09	ABEV	Stock	3.2	3.26	3.18	3.2	29367700.0
2021-11-09	ABG	Stock	185.61	188.27	182.06	182.96	268600.0
2021-11-09	ABGI-DELISTED	Stock	9.8	9.82	9.75	9.75	26893.0
2021-11-09	ABM	Stock	47.78	48.17	47.55	47.66	195900.0
2021-11-09	ABMD-DELISTED	Stock	363.44	373.165	360.09	371.72	268052.0
2021-11-09	ABNB	Stock	201.44	201.5	187.5	194.68	9056100.0
2021-11-09	ABOS	Stock	14.8	14.8	14.11	14.78	32300.0

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

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