PREVIEW / stock_daily / 2021-09-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-17.parquet
  size:    259 KB
  rows:    7,864
  symbols: 2,692

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-17	AAPL	Stock	148.82	148.82	145.76	146.06	129868800.0
2021-09-17	MSFT	Stock	304.17	304.5	299.53	299.87	41372500.0
2021-09-17	NVDA	Stock	22.3	22.321	21.83	21.9	294503000.0
2021-09-17	AMZN	Stock	174.4205	174.8705	172.6065	173.126	92332000.0
2021-09-17	GOOGL	Stock	143.0305	143.45	140.4698	140.8	53384460.0
2021-09-17	META	Stock	371.41	371.41	361.59	364.72	26299000.0
2021-09-17	TSLA	Stock	252.3833	253.68	250.0	253.1633	84612600.0
2021-09-17	TLT	Stock	149.182	149.36	148.7	149.17	13783034.0
2021-09-17	ES	Stock	84.39	85.02	83.12	83.3	3092300.0
2021-09-17	CL	Stock	76.26	76.95	76.17	76.23	7334200.0
2021-09-17	A	Stock	173.92	177.36	172.8	173.94	2405700.0
2021-09-17	AA	Stock	49.19	49.77	47.47	48.83	10500000.0
2021-09-17	AAC-DELISTED	Stock	9.74	9.76	9.72	9.73	219865.0
2021-09-17	AACG	Stock	2.76	2.79	2.62	2.68	17600.0
2021-09-17	AAIC-DELISTED	Stock	3.75	3.78	3.74	3.77	133212.0
2021-09-17	AAIC.C-DELISTED	Stock	25.0492	25.0979	25.0492	25.0979	382.0
2021-09-17	AAL	Stock	19.94	20.32	19.54	19.73	32602600.0
2021-09-17	AAM.A-DELISTED	Stock	25.92	25.95	25.78	25.78	22488.0
2021-09-17	AAM.B-DELISTED	Stock	26.94	27.09	26.94	26.99	6161.0
2021-09-17	AAMC-DELISTED	Stock	7.3588	7.9559	7.0765	7.5588	170843.0
2021-09-17	AAME	Stock	3.9	4.0	3.84	4.0	37300.0
2021-09-17	AAMI	Stock	26.74	26.78	26.27	26.53	977000.0
2021-09-17	AAN-DELISTED	Stock	26.49	27.21	26.18	26.93	990200.0
2021-09-17	AAOI	Stock	7.45	7.55	7.38	7.46	515800.0
2021-09-17	AAON	Stock	43.52	44.0467	43.22	44.0	711750.0
2021-09-17	AAP	Stock	207.21	208.34	205.07	205.8	667200.0
2021-09-17	AAQC-DELISTED	Stock	9.71	9.73	9.69	9.69	6517.0
2021-09-17	AAT	Stock	39.25	39.38	37.99	38.01	673500.0
2021-09-17	AATC	Stock	8.19	8.2229	8.0099	8.17	17126.0
2021-09-17	AAU-DELISTED	Stock	0.3902	0.4055	0.3902	0.3986	613422.0
2021-09-17	AAUAF-DELISTED	Stock	0.3902	0.4055	0.3902	0.3985	643642.0
2021-09-17	AAWW-DELISTED	Stock	77.95	78.4199	75.3	75.63	762448.0
2021-09-17	AAXJ	Stock	87.27	87.33	86.73	86.94	576680.0
2021-09-17	AB	Stock	51.68	52.19	51.51	52.06	139000.0
2021-09-17	ABB-DELISTED	Stock	36.47	36.56	35.55	35.63	2038847.0
2021-09-17	ABBNY-DELISTED	Stock	36.47	36.56	35.55	35.64	2262873.0
2021-09-17	ABBV	Stock	107.5	108.25	107.1	107.73	14157200.0
2021-09-17	ABC-DELISTED	Stock	123.78	124.93	122.98	123.45	1457950.0
2021-09-17	ABCB	Stock	47.53	48.11	46.87	47.83	1918300.0
2021-09-17	ABCL	Stock	22.63	22.634	19.81	20.36	14682900.0
2021-09-17	ABCM-DELISTED	Stock	20.65	20.98	20.37	20.56	75843.0
2021-09-17	ABEO	Stock	31.0	31.75	29.25	30.0	34620.0
2021-09-17	ABEV	Stock	2.95	2.96	2.85	2.96	41092400.0
2021-09-17	ABG	Stock	181.81	186.0	180.76	181.93	400100.0
2021-09-17	ABGI-DELISTED	Stock	9.69	9.71	9.69	9.7	15713.0
2021-09-17	ABM	Stock	45.79	45.91	44.71	45.08	1195100.0
2021-09-17	ABMD-DELISTED	Stock	355.64	357.06	350.42	354.78	295687.0
2021-09-17	ABNB	Stock	169.3	170.0	163.61	166.59	20024700.0
2021-09-17	ABOS	Stock	16.18	17.71	15.855	16.23	1542900.0
2021-09-17	ABR	Stock	18.23	18.32	18.07	18.08	2788500.0

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

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