PREVIEW / stock_daily / 2021-09-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-16.parquet
  size:    258 KB
  rows:    7,873
  symbols: 2,716

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-09-16	AAPL	Stock	148.44	148.97	147.22	148.79	68034100.0
2021-09-16	MSFT	Stock	303.76	305.31	300.76	305.22	19550800.0
2021-09-16	NVDA	Stock	22.183	22.277	21.927	22.242	156033000.0
2021-09-16	AMZN	Stock	172.998	174.6275	172.307	174.412	51672000.0
2021-09-16	GOOGL	Stock	143.9505	144.3	142.4015	143.61	26195420.0
2021-09-16	META	Stock	372.79	373.56	369.71	373.06	11934200.0
2021-09-16	TSLA	Stock	250.9433	252.97	249.2033	252.33	41770200.0
2021-09-16	TLT	Stock	149.67	150.45	149.5	149.89	13328978.0
2021-09-16	ES	Stock	84.96	85.54	84.13	84.86	986200.0
2021-09-16	CL	Stock	77.13	77.25	75.86	76.47	4170600.0
2021-09-16	A	Stock	173.93	173.93	171.1	173.28	1142000.0
2021-09-16	AA	Stock	50.95	50.96	48.66	49.41	8054400.0
2021-09-16	AAC-DELISTED	Stock	9.75	9.76	9.73	9.75	47175.0
2021-09-16	AACG	Stock	2.75	2.81	2.72	2.76	22800.0
2021-09-16	AAIC-DELISTED	Stock	3.76	3.7901	3.74	3.76	151364.0
2021-09-16	AAIC.C-DELISTED	Stock	25.155	25.2	25.05	25.17	7992.0
2021-09-16	AAL	Stock	19.35	20.22	19.32	19.89	33586200.0
2021-09-16	AAM.A-DELISTED	Stock	25.93	25.9985	25.8	25.85	15151.0
2021-09-16	AAM.B-DELISTED	Stock	26.85	27.08	26.845	27.0	39756.0
2021-09-16	AAMC-DELISTED	Stock	7.8147	7.9412	7.4559	7.5324	75745.0
2021-09-16	AAME	Stock	3.84	3.96	3.83	3.86	14800.0
2021-09-16	AAMI	Stock	26.86	26.95	26.555	26.66	181300.0
2021-09-16	AAN-DELISTED	Stock	26.24	26.61	26.0	26.4	188600.0
2021-09-16	AAOI	Stock	7.29	7.49	7.13	7.46	288000.0
2021-09-16	AAON	Stock	43.7533	43.7533	42.9667	43.3467	137550.0
2021-09-16	AAP	Stock	206.08	208.78	205.3	207.69	518900.0
2021-09-16	AAQC-DELISTED	Stock	9.71	9.75	9.6996	9.74	84298.0
2021-09-16	AAT	Stock	39.51	39.93	38.88	38.89	365100.0
2021-09-16	AATC	Stock	8.09	8.29	8.04	8.25	60048.0
2021-09-16	AAU-DELISTED	Stock	0.402	0.411	0.3921	0.4055	720393.0
2021-09-16	AAUAF-DELISTED	Stock	0.402	0.411	0.3921	0.4055	726917.0
2021-09-16	AAWW-DELISTED	Stock	77.855	79.41	76.6101	78.47	326351.0
2021-09-16	AAXJ	Stock	86.77	87.18	86.55	87.02	427218.0
2021-09-16	AB	Stock	52.23	52.23	51.51	51.77	111500.0
2021-09-16	ABB-DELISTED	Stock	36.72	36.75	36.47	36.61	587626.0
2021-09-16	ABBNY-DELISTED	Stock	36.72	36.75	36.47	36.61	710834.0
2021-09-16	ABBV	Stock	108.24	108.75	106.53	108.08	5821800.0
2021-09-16	ABC-DELISTED	Stock	126.25	126.97	124.2	124.24	487012.0
2021-09-16	ABCB	Stock	47.55	47.82	46.5	47.45	403800.0
2021-09-16	ABCL	Stock	18.79	19.88	18.37	19.8	6508800.0
2021-09-16	ABCM-DELISTED	Stock	20.59	20.875	20.49	20.72	34839.0
2021-09-16	ABEO	Stock	31.0	31.75	30.25	31.0	14860.0
2021-09-16	ABEV	Stock	2.99	3.08	2.95	3.03	28453500.0
2021-09-16	ABG	Stock	178.66	182.19	174.24	180.12	188000.0
2021-09-16	ABGI-DELISTED	Stock	9.7	9.7	9.67	9.67	4100.0
2021-09-16	ABM	Stock	46.64	46.92	45.66	45.91	516600.0
2021-09-16	ABMD-DELISTED	Stock	354.64	359.24	351.41	358.06	103573.0
2021-09-16	ABNB	Stock	165.26	169.45	165.04	168.15	6094800.0
2021-09-16	ABOS	Stock	15.31	16.43	15.11	16.18	405200.0
2021-09-16	ABR	Stock	18.17	18.33	18.05	18.14	2315700.0

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

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