PREVIEW / stock_daily / 2021-11-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-24.parquet
  size:    258 KB
  rows:    7,918
  symbols: 2,598

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-24	AAPL	Stock	160.75	162.14	159.64	161.94	69463600.0
2021-11-24	MSFT	Stock	336.28	338.16	333.91	337.91	21661300.0
2021-11-24	NVDA	Stock	31.461	32.855	30.928	32.674	435162000.0
2021-11-24	AMZN	Stock	178.1335	180.682	176.8425	179.0205	46560000.0
2021-11-24	GOOGL	Stock	145.4735	146.2493	144.373	146.12	18040140.0
2021-11-24	META	Stock	336.0	341.78	332.81	341.06	13566200.0
2021-11-24	TSLA	Stock	360.13	377.59	354.0	372.0	67680600.0
2021-11-24	TLT	Stock	144.94	146.82	144.79	146.82	13769705.0
2021-11-24	ES	Stock	85.37	85.37	84.59	84.93	783900.0
2021-11-24	CL	Stock	78.07	78.16	77.37	77.76	2350400.0
2021-11-24	A	Stock	153.76	154.67	151.09	152.97	2291400.0
2021-11-24	AA	Stock	48.81	51.335	48.41	50.46	7137600.0
2021-11-24	AAC-DELISTED	Stock	9.84	9.84	9.81	9.8175	187563.0
2021-11-24	AACG	Stock	1.73	1.78	1.7	1.75	10100.0
2021-11-24	AACIU	Stock	9.92	10.0001	9.92	10.0001	467.0
2021-11-24	AACIW-DELISTED	Stock	0.5195	0.52	0.5	0.52	1399.0
2021-11-24	AAIC-DELISTED	Stock	3.68	3.77	3.68	3.74	204459.0
2021-11-24	AAIC.C-DELISTED	Stock	25.795	25.9	25.795	25.9	903.0
2021-11-24	AAL	Stock	19.33	19.55	19.07	19.46	21323300.0
2021-11-24	AAM.A-DELISTED	Stock	25.61	25.68	25.6	25.6	32906.0
2021-11-24	AAM.B-DELISTED	Stock	26.59	26.6925	26.56	26.56	10773.0
2021-11-24	AAMC-DELISTED	Stock	6.5235	6.5529	5.5529	5.5706	165390.0
2021-11-24	AAME	Stock	4.06	4.1	3.94	4.01	4700.0
2021-11-24	AAMI	Stock	30.32	30.5	30.32	30.46	526900.0
2021-11-24	AAN-DELISTED	Stock	24.75	25.38	24.14	24.92	191200.0
2021-11-24	AAOI	Stock	5.87	6.05	5.77	6.03	334100.0
2021-11-24	AAON	Stock	52.1733	52.7	51.98	52.4867	276900.0
2021-11-24	AAP	Stock	233.6	234.56	232.16	233.37	361000.0
2021-11-24	AAQC-DELISTED	Stock	9.7201	9.74	9.72	9.74	86248.0
2021-11-24	AAT	Stock	37.92	38.22	37.72	38.1	85100.0
2021-11-24	AATC	Stock	6.89	6.9541	6.8155	6.9541	8077.0
2021-11-24	AAU-DELISTED	Stock	0.3343	0.34	0.3343	0.3365	662128.0
2021-11-24	AAUAF-DELISTED	Stock	0.3343	0.34	0.3343	0.3365	668143.0
2021-11-24	AAWW-DELISTED	Stock	94.52	94.52	92.39	94.1	149214.0
2021-11-24	AAXJ	Stock	85.53	85.98	85.36	85.94	1571901.0
2021-11-24	AB	Stock	55.37	55.66	55.15	55.54	190100.0
2021-11-24	ABB-DELISTED	Stock	34.88	35.22	34.86	35.185	1219401.0
2021-11-24	ABBNY-DELISTED	Stock	34.88	35.22	34.86	35.17	1349438.0
2021-11-24	ABBV	Stock	118.68	119.24	118.08	118.66	5792800.0
2021-11-24	ABC-DELISTED	Stock	123.23	124.96	122.79	123.44	369550.0
2021-11-24	ABCB	Stock	53.24	53.63	52.93	53.2	350400.0
2021-11-24	ABCL	Stock	13.91	14.45	13.6	14.44	774700.0
2021-11-24	ABCM-DELISTED	Stock	22.1	22.62	22.1	22.62	43868.0
2021-11-24	ABEO	Stock	18.5	19.25	18.25	19.0	9328.0
2021-11-24	ABEV	Stock	3.0	3.06	2.99	3.03	18645300.0
2021-11-24	ABG	Stock	164.64	166.7	162.21	163.97	367700.0
2021-11-24	ABGI-DELISTED	Stock	9.77	9.77	9.77	9.77	150.0
2021-11-24	ABM	Stock	48.63	49.15	48.23	48.29	164800.0
2021-11-24	ABMD-DELISTED	Stock	328.67	338.17	324.65	337.91	70466.0
2021-11-24	ABNB	Stock	175.63	182.78	175.0	179.89	4763300.0

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

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