PREVIEW / stock_daily / 2021-11-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-12.parquet
  size:    261 KB
  rows:    7,993
  symbols: 2,684

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-12	AAPL	Stock	148.43	150.4	147.48	149.99	63804000.0
2021-11-12	MSFT	Stock	333.92	337.23	333.79	336.72	23831000.0
2021-11-12	NVDA	Stock	30.01	30.68	29.63	30.39	413054000.0
2021-11-12	AMZN	Stock	174.25	177.0365	172.3525	176.2575	53788000.0
2021-11-12	GOOGL	Stock	146.6155	148.85	145.411	148.678	22360000.0
2021-11-12	META	Stock	330.18	341.86	329.78	340.89	25414300.0
2021-11-12	TSLA	Stock	349.1667	351.5	339.7333	344.4733	76719300.0
2021-11-12	TLT	Stock	148.0	148.51	146.76	147.33	12711972.0
2021-11-12	ES	Stock	82.31	82.5	81.93	81.95	836300.0
2021-11-12	CL	Stock	77.92	78.46	77.66	78.03	3057200.0
2021-11-12	A	Stock	159.73	161.06	157.71	160.88	1444800.0
2021-11-12	AA	Stock	50.73	52.86	50.35	51.92	9310600.0
2021-11-12	AAC-DELISTED	Stock	9.85	9.85	9.81	9.84	456923.0
2021-11-12	AACG	Stock	2.21	2.22	2.18	2.21	7800.0
2021-11-12	AACIU	Stock	9.99	10.03	9.99	10.015	510310.0
2021-11-12	AACIW-DELISTED	Stock	0.52	0.54	0.5	0.5	308452.0
2021-11-12	AAIC-DELISTED	Stock	3.84	3.85	3.8	3.82	195420.0
2021-11-12	AAIC.C-DELISTED	Stock	25.7298	25.7298	25.7298	25.7298	100.0
2021-11-12	AAL	Stock	21.34	21.36	20.06	20.29	48375400.0
2021-11-12	AAM.A-DELISTED	Stock	25.74	25.8719	25.7	25.71	9170.0
2021-11-12	AAM.B-DELISTED	Stock	26.87	26.94	26.84	26.9	19268.0
2021-11-12	AAMC-DELISTED	Stock	6.9794	7.4118	6.9794	7.2206	43537.0
2021-11-12	AAME	Stock	4.25	4.25	4.14	4.25	11500.0
2021-11-12	AAMI	Stock	30.7	30.88	30.41	30.77	1159400.0
2021-11-12	AAN-DELISTED	Stock	26.6	26.76	26.115	26.27	77400.0
2021-11-12	AAOI	Stock	6.05	6.12	5.95	6.08	705100.0
2021-11-12	AAON	Stock	51.2667	52.2133	50.9333	51.66	195450.0
2021-11-12	AAP	Stock	239.39	240.09	237.2	239.04	775700.0
2021-11-12	AAQC-DELISTED	Stock	9.76	9.78	9.73	9.78	30150.0
2021-11-12	AAT	Stock	39.31	39.52	38.51	38.58	141400.0
2021-11-12	AATC	Stock	6.96	6.96	6.82	6.9021	18235.0
2021-11-12	AAU-DELISTED	Stock	0.4197	0.434	0.4111	0.4208	598255.0
2021-11-12	AAUAF-DELISTED	Stock	0.4197	0.434	0.41	0.4208	618378.0
2021-11-12	AAWW-DELISTED	Stock	85.51	87.075	84.245	85.69	198800.0
2021-11-12	AAXJ	Stock	87.59	88.0	87.49	87.93	716146.0
2021-11-12	AB	Stock	56.22	56.51	55.8	56.38	147600.0
2021-11-12	ABB-DELISTED	Stock	34.84	35.18	34.785	35.06	789471.0
2021-11-12	ABBNY-DELISTED	Stock	34.84	35.18	34.785	35.06	888476.0
2021-11-12	ABBV	Stock	117.4	117.4	116.43	116.97	2740300.0
2021-11-12	ABC-DELISTED	Stock	126.23	127.14	124.81	125.38	556575.0
2021-11-12	ABCB	Stock	54.82	55.22	53.4	53.78	266200.0
2021-11-12	ABCL	Stock	15.13	15.51	14.78	15.02	2082700.0
2021-11-12	ABCM-DELISTED	Stock	22.89	23.19	22.83	23.06	13507.0
2021-11-12	ABEO	Stock	23.5	24.0	22.5	23.0	19492.0
2021-11-12	ABEV	Stock	3.22	3.23	3.12	3.14	43236200.0
2021-11-12	ABG	Stock	183.69	185.34	180.46	184.72	204600.0
2021-11-12	ABM	Stock	48.76	48.76	48.31	48.55	181200.0
2021-11-12	ABMD-DELISTED	Stock	358.4	364.46	355.5	360.65	119807.0
2021-11-12	ABNB	Stock	192.465	208.16	192.06	206.54	12057800.0
2021-11-12	ABOS	Stock	13.63	13.678	12.82	12.95	24900.0

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

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