PREVIEW / stock_daily / 2021-02-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-08.parquet
  size:    247 KB
  rows:    7,462
  symbols: 2,748

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-08	AAPL	Stock	136.03	136.96	134.92	136.91	71297200.0
2021-02-08	MSFT	Stock	243.15	243.68	240.81	242.47	22211900.0
2021-02-08	NVDA	Stock	13.7273	14.4738	13.7273	14.4388	434624000.0
2021-02-08	AMZN	Stock	167.925	168.25	165.2	166.147	65148000.0
2021-02-08	GOOGL	Stock	105.0	105.75	103.1675	104.226	28828860.0
2021-02-08	META	Stock	268.75	269.86	265.0	266.58	13755200.0
2021-02-08	TSLA	Stock	289.89	292.59	284.9167	287.8067	60485100.0
2021-02-08	TLT	Stock	148.3	149.265	148.035	148.68	11574766.0
2021-02-08	ES	Stock	87.82	87.82	85.22	85.51	2119200.0
2021-02-08	CL	Stock	80.0	80.13	79.27	79.7	3828700.0
2021-02-08	A	Stock	123.92	125.74	122.57	123.41	2065300.0
2021-02-08	AA	Stock	21.33	21.97	21.29	21.8	8282900.0
2021-02-08	AACG	Stock	6.17	7.5	5.46	5.85	5239300.0
2021-02-08	AACQ-DELISTED	Stock	11.3	11.55	11.27	11.41	1213086.0
2021-02-08	AACQU-DELISTED	Stock	12.54	12.54	12.19	12.29	43599.0
2021-02-08	AACQW-DELISTED	Stock	2.65	2.65	2.48	2.5	574891.0
2021-02-08	AAIC-DELISTED	Stock	3.68	3.75	3.67	3.74	120945.0
2021-02-08	AAIC.C-DELISTED	Stock	22.2	22.2999	22.15	22.15	5140.0
2021-02-08	AAL	Stock	17.32	18.09	17.24	17.77	44177500.0
2021-02-08	AAM.A-DELISTED	Stock	26.3	26.398	26.2	26.29	17661.0
2021-02-08	AAM.B-DELISTED	Stock	27.07	27.0921	26.93	27.09	7276.0
2021-02-08	AAMC-DELISTED	Stock	6.3529	6.7588	6.3529	6.7588	19033.0
2021-02-08	AAME	Stock	4.9	7.85	4.5	6.5	9688800.0
2021-02-08	AAMI	Stock	20.47	20.47	19.58	19.7	574300.0
2021-02-08	AAN-DELISTED	Stock	19.86	20.4	19.39	19.58	342100.0
2021-02-08	AAOI	Stock	11.85	12.5	11.85	12.34	571400.0
2021-02-08	AAON	Stock	51.7333	53.76	51.6133	53.6467	314400.0
2021-02-08	AAP	Stock	158.38	160.02	157.56	158.44	957800.0
2021-02-08	AAT	Stock	28.9	29.28	28.42	29.24	170900.0
2021-02-08	AAU-DELISTED	Stock	0.77	0.7993	0.755	0.7899	5221567.0
2021-02-08	AAUAF-DELISTED	Stock	0.77	0.7993	0.755	0.7903	5344106.0
2021-02-08	AAWW-DELISTED	Stock	54.17	54.67	53.11	53.53	323192.0
2021-02-08	AAXJ	Stock	98.5	99.02	98.39	99.02	1502568.0
2021-02-08	AB	Stock	39.04	39.52	38.81	39.5	456500.0
2021-02-08	ABB-DELISTED	Stock	29.32	29.385	28.9	29.07	1759992.0
2021-02-08	ABBNY-DELISTED	Stock	29.32	29.385	28.9	29.08	2411333.0
2021-02-08	ABBV	Stock	108.89	108.98	105.81	106.84	9199100.0
2021-02-08	ABC-DELISTED	Stock	109.7	110.42	107.7	108.48	863825.0
2021-02-08	ABCB	Stock	44.38	45.14	43.7	45.08	293600.0
2021-02-08	ABCL	Stock	49.0	49.37	44.57	45.03	579700.0
2021-02-08	ABCM-DELISTED	Stock	22.9	23.22	22.8	22.9	41538.0
2021-02-08	ABEO	Stock	66.75	87.5	65.5	84.75	665760.0
2021-02-08	ABEV	Stock	2.82	2.87	2.79	2.83	35210200.0
2021-02-08	ABG	Stock	157.14	165.34	156.17	165.0	301700.0
2021-02-08	ABM	Stock	39.63	41.03	39.45	41.03	272300.0
2021-02-08	ABMD-DELISTED	Stock	330.4	331.56	323.59	325.86	126980.0
2021-02-08	ABNB	Stock	199.93	201.96	191.5	200.43	3488100.0
2021-02-08	ABR	Stock	15.14	15.28	14.97	15.21	1572800.0
2021-02-08	ABR.A-DELISTED	Stock	26.15	26.25	26.15	26.25	3300.0
2021-02-08	ABR.B-DELISTED	Stock	25.75	25.75	25.735	25.735	1150.0

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

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