PREVIEW / stock_daily / 2021-10-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-15.parquet
  size:    258 KB
  rows:    7,889
  symbols: 2,667

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-10-15	AAPL	Stock	143.77	144.9	143.51	144.84	67940300.0
2021-10-15	MSFT	Stock	302.34	304.45	300.52	304.21	25384800.0
2021-10-15	NVDA	Stock	21.81	21.931	21.662	21.862	226994000.0
2021-10-15	AMZN	Stock	165.571	170.521	165.2	170.451	103598000.0
2021-10-15	GOOGL	Stock	141.6145	141.718	140.755	141.368	30274440.0
2021-10-15	META	Stock	328.68	329.07	322.51	324.76	21596400.0
2021-10-15	TSLA	Stock	274.58	281.07	274.1167	281.01	56773800.0
2021-10-15	TLT	Stock	145.0	145.14	144.47	145.03	11811540.0
2021-10-15	ES	Stock	87.73	87.93	86.16	86.41	1164500.0
2021-10-15	CL	Stock	76.66	76.99	76.0	76.25	4076000.0
2021-10-15	A	Stock	153.14	153.89	152.55	153.27	1397800.0
2021-10-15	AA	Stock	51.92	56.93	51.0	56.0	33374900.0
2021-10-15	AAC-DELISTED	Stock	9.76	9.78	9.74	9.74	97330.0
2021-10-15	AACG	Stock	2.27	2.58	2.26	2.46	214500.0
2021-10-15	AAIC-DELISTED	Stock	3.97	4.04	3.92	3.95	176697.0
2021-10-15	AAIC.C-DELISTED	Stock	25.3	25.3	25.175	25.23	2830.0
2021-10-15	AAL	Stock	20.02	20.33	19.92	19.98	27259900.0
2021-10-15	AAM.A-DELISTED	Stock	25.67	26.06	25.67	26.03	246482.0
2021-10-15	AAM.B-DELISTED	Stock	26.74	27.09	26.69	27.04	218044.0
2021-10-15	AAMC-DELISTED	Stock	7.1509	7.2059	7.0294	7.0294	10452.0
2021-10-15	AAME	Stock	4.44	4.49	4.28	4.33	9700.0
2021-10-15	AAMI	Stock	27.0	27.05	26.71	26.76	331000.0
2021-10-15	AAN-DELISTED	Stock	28.25	28.25	27.45	27.48	105700.0
2021-10-15	AAOI	Stock	7.39	7.45	7.18	7.22	211000.0
2021-10-15	AAON	Stock	46.8067	47.4867	46.4	46.6667	190050.0
2021-10-15	AAP	Stock	216.67	218.82	215.42	215.43	357200.0
2021-10-15	AAQC-DELISTED	Stock	9.71	9.72	9.71	9.715	8282.0
2021-10-15	AAT	Stock	40.27	40.39	39.46	39.5	165800.0
2021-10-15	AATC	Stock	6.96	7.1072	6.8	6.99	28885.0
2021-10-15	AAU-DELISTED	Stock	0.38	0.3995	0.38	0.3896	469203.0
2021-10-15	AAUAF-DELISTED	Stock	0.38	0.3995	0.38	0.3898	480505.0
2021-10-15	AAWW-DELISTED	Stock	80.45	80.45	78.64	78.78	293079.0
2021-10-15	AAXJ	Stock	87.09	87.545	86.79	87.35	682023.0
2021-10-15	AB	Stock	52.09	52.65	51.97	52.16	186500.0
2021-10-15	ABB-DELISTED	Stock	34.37	34.655	34.35	34.5	1653901.0
2021-10-15	ABBNY-DELISTED	Stock	34.37	34.655	34.35	34.49	1785821.0
2021-10-15	ABBV	Stock	109.15	109.96	109.08	109.33	4634500.0
2021-10-15	ABC-DELISTED	Stock	120.63	121.67	119.81	119.86	782589.0
2021-10-15	ABCB	Stock	53.9	53.9	51.78	51.88	532100.0
2021-10-15	ABCL	Stock	15.96	16.02	15.4	15.53	1076300.0
2021-10-15	ABCM-DELISTED	Stock	21.38	21.83	21.36	21.59	30904.0
2021-10-15	ABEO	Stock	22.0	23.5	22.0	22.75	26756.0
2021-10-15	ABEV	Stock	2.76	2.82	2.75	2.79	17769000.0
2021-10-15	ABG	Stock	215.92	215.92	210.1	210.63	91100.0
2021-10-15	ABGI-DELISTED	Stock	9.735	9.735	9.735	9.735	200.0
2021-10-15	ABM	Stock	46.76	46.92	44.99	45.14	289100.0
2021-10-15	ABMD-DELISTED	Stock	347.47	352.2432	346.46	351.4	181517.0
2021-10-15	ABNB	Stock	171.9	172.95	168.58	169.18	3592700.0
2021-10-15	ABOS	Stock	14.17	14.29	13.05	13.55	45600.0
2021-10-15	ABR	Stock	19.49	19.5	19.19	19.19	1072000.0

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

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