PREVIEW / stock_daily / 2021-02-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-05.parquet
  size:    245 KB
  rows:    7,430
  symbols: 2,745

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-02-05	AAPL	Stock	137.35	137.42	135.86	136.76	75693800.0
2021-02-05	MSFT	Stock	242.23	243.28	240.42	242.2	18054800.0
2021-02-05	NVDA	Stock	13.725	13.7372	13.5458	13.591	169152000.0
2021-02-05	AMZN	Stock	165.95	168.85	165.1355	167.6075	72416000.0
2021-02-05	GOOGL	Stock	102.978	104.797	102.5	104.4415	29865120.0
2021-02-05	META	Stock	266.8	269.17	265.67	268.1	12454400.0
2021-02-05	TSLA	Stock	281.6667	288.2567	279.6567	284.0767	55699800.0
2021-02-05	TLT	Stock	149.1	149.57	148.02	148.03	10258935.0
2021-02-05	ES	Stock	88.41	89.04	87.73	87.8	1131500.0
2021-02-05	CL	Stock	79.16	80.07	79.11	79.87	3579200.0
2021-02-05	A	Stock	124.51	125.96	123.11	123.18	1919700.0
2021-02-05	AA	Stock	20.58	20.98	20.22	20.95	5242700.0
2021-02-05	AACG	Stock	10.02	10.12	5.6	6.33	18333600.0
2021-02-05	AACQ-DELISTED	Stock	11.2322	11.74	11.18	11.27	969365.0
2021-02-05	AACQU-DELISTED	Stock	12.01	12.57	12.01	12.12	21677.0
2021-02-05	AACQW-DELISTED	Stock	2.52	2.68	2.41	2.59	238285.0
2021-02-05	AAIC-DELISTED	Stock	3.7	3.7349	3.64	3.7	89755.0
2021-02-05	AAIC.C-DELISTED	Stock	22.0099	22.149	21.895	21.9899	2550.0
2021-02-05	AAL	Stock	17.6	17.67	17.07	17.19	30910200.0
2021-02-05	AAM.A-DELISTED	Stock	26.31	26.41	26.21	26.33	7944.0
2021-02-05	AAM.B-DELISTED	Stock	27.01	27.17	26.94	26.94	12020.0
2021-02-05	AAMC-DELISTED	Stock	6.4441	6.6176	6.3171	6.5118	25830.0
2021-02-05	AAME	Stock	3.75	15.97	3.6	5.2	111912800.0
2021-02-05	AAMI	Stock	20.15	20.44	19.92	20.36	294800.0
2021-02-05	AAN-DELISTED	Stock	19.31	19.64	18.63	19.63	362600.0
2021-02-05	AAOI	Stock	11.51	11.82	11.37	11.73	509700.0
2021-02-05	AAON	Stock	51.8	52.4733	51.1467	51.76	146400.0
2021-02-05	AAP	Stock	159.98	160.25	156.5	157.28	877900.0
2021-02-05	AAT	Stock	28.85	28.99	28.41	28.81	110000.0
2021-02-05	AAU-DELISTED	Stock	0.73	0.76	0.7152	0.745	3940706.0
2021-02-05	AAUAF-DELISTED	Stock	0.73	0.76	0.7152	0.7451	4035597.0
2021-02-05	AAWW-DELISTED	Stock	53.33	54.8	53.0	53.69	380220.0
2021-02-05	AAXJ	Stock	98.31	98.73	97.95	98.73	1203633.0
2021-02-05	AB	Stock	38.42	38.78	38.1	38.47	499700.0
2021-02-05	ABB-DELISTED	Stock	28.9	28.99	28.7	28.82	1509930.0
2021-02-05	ABBNY-DELISTED	Stock	28.9	28.99	28.7	28.82	1711383.0
2021-02-05	ABBV	Stock	109.63	110.27	108.44	108.73	7251000.0
2021-02-05	ABC-DELISTED	Stock	112.2	112.33	108.08	109.7	1503652.0
2021-02-05	ABCB	Stock	44.28	44.73	43.03	44.0	324500.0
2021-02-05	ABCL	Stock	46.9	47.45	45.68	46.55	458700.0
2021-02-05	ABCM-DELISTED	Stock	22.2568	23.23	22.2568	22.57	35367.0
2021-02-05	ABEO	Stock	65.5	65.5	57.75	64.5	137680.0
2021-02-05	ABEV	Stock	2.94	2.97	2.9	2.92	15308300.0
2021-02-05	ABG	Stock	155.28	156.32	151.54	155.12	194200.0
2021-02-05	ABM	Stock	39.61	39.75	39.01	39.43	208300.0
2021-02-05	ABMD-DELISTED	Stock	326.8518	331.3	323.85	327.38	171786.0
2021-02-05	ABNB	Stock	197.0	197.25	190.25	195.31	2869700.0
2021-02-05	ABR	Stock	15.5	15.8	15.43	15.45	998200.0
2021-02-05	ABR.A-DELISTED	Stock	26.17	26.325	26.17	26.2516	4554.0
2021-02-05	ABR.B-DELISTED	Stock	25.71	25.71	25.7	25.7	600.0

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

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