PREVIEW / stock_daily / 2021-02-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-09.parquet
  size:    248 KB
  rows:    7,479
  symbols: 2,767

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-09	AAPL	Stock	136.62	137.88	135.85	136.01	76774200.0
2021-02-09	MSFT	Stock	241.87	244.76	241.38	243.77	23565000.0
2021-02-09	NVDA	Stock	14.3408	14.5832	14.2225	14.2632	287560000.0
2021-02-09	AMZN	Stock	165.6245	166.9	164.892	165.25	44070000.0
2021-02-09	GOOGL	Stock	103.74	104.9255	103.5	103.7695	21891660.0
2021-02-09	META	Stock	266.44	273.39	265.75	269.45	14613400.0
2021-02-09	TSLA	Stock	285.04	286.6	280.5833	283.1533	45473100.0
2021-02-09	TLT	Stock	149.22	149.67	148.655	148.79	5218341.0
2021-02-09	ES	Stock	85.84	86.16	84.25	85.74	1084800.0
2021-02-09	CL	Stock	79.64	79.66	78.36	78.7	3682200.0
2021-02-09	A	Stock	123.41	123.49	122.36	123.24	1988300.0
2021-02-09	AA	Stock	21.77	22.345	21.66	21.76	5591000.0
2021-02-09	AACG	Stock	6.05	6.39	5.91	6.21	2443400.0
2021-02-09	AACQ-DELISTED	Stock	11.39	11.45	11.22	11.33	881049.0
2021-02-09	AACQU-DELISTED	Stock	12.39	12.39	12.04	12.2	16295.0
2021-02-09	AACQW-DELISTED	Stock	2.49	2.65	2.41	2.56	207567.0
2021-02-09	AAIC-DELISTED	Stock	3.7	3.71	3.64	3.71	193796.0
2021-02-09	AAIC.C-DELISTED	Stock	22.25	22.29	22.22	22.22	3000.0
2021-02-09	AAL	Stock	17.74	17.76	17.34	17.44	29972900.0
2021-02-09	AAM.A-DELISTED	Stock	26.37	26.37	26.19	26.25	20638.0
2021-02-09	AAM.B-DELISTED	Stock	27.16	27.16	27.02	27.04	5174.0
2021-02-09	AAMC-DELISTED	Stock	6.7206	7.7882	6.7206	7.5926	80522.0
2021-02-09	AAME	Stock	6.15	7.5	5.7	6.53	2569700.0
2021-02-09	AAMI	Stock	19.59	19.69	19.18	19.56	262700.0
2021-02-09	AAN-DELISTED	Stock	19.5	20.78	19.23	20.65	373600.0
2021-02-09	AAOI	Stock	12.48	12.5	12.08	12.37	405200.0
2021-02-09	AAON	Stock	52.7067	54.1267	52.4067	53.8667	454950.0
2021-02-09	AAP	Stock	158.0	162.14	157.4	160.67	709300.0
2021-02-09	AAT	Stock	29.48	29.74	29.0	29.26	195500.0
2021-02-09	AAU-DELISTED	Stock	0.8202	0.89	0.78	0.8282	8536667.0
2021-02-09	AAUAF-DELISTED	Stock	0.8202	0.89	0.78	0.8375	8691187.0
2021-02-09	AAWW-DELISTED	Stock	53.52	56.11	53.15	55.76	517421.0
2021-02-09	AAXJ	Stock	99.28	100.18	99.08	100.08	802159.0
2021-02-09	AB	Stock	39.28	39.65	38.67	38.72	429000.0
2021-02-09	ABB-DELISTED	Stock	29.22	29.42	29.18	29.34	1065821.0
2021-02-09	ABBNY-DELISTED	Stock	29.22	29.42	29.18	29.34	1151364.0
2021-02-09	ABBV	Stock	106.0	106.5	105.11	105.4	5506900.0
2021-02-09	ABC-DELISTED	Stock	108.13	108.84	106.25	107.41	677798.0
2021-02-09	ABCB	Stock	45.0	45.73	44.38	45.51	551400.0
2021-02-09	ABCL	Stock	47.75	49.7	46.175	47.0	973600.0
2021-02-09	ABCM-DELISTED	Stock	23.21	23.41	23.04	23.05	16331.0
2021-02-09	ABEO	Stock	94.75	94.75	80.0	83.5	468296.0
2021-02-09	ABEV	Stock	2.77	2.84	2.76	2.81	18218600.0
2021-02-09	ABG	Stock	164.63	165.01	157.73	164.5	211000.0
2021-02-09	ABM	Stock	41.25	42.15	41.13	41.76	242100.0
2021-02-09	ABMD-DELISTED	Stock	326.6	327.91	321.84	324.09	123422.0
2021-02-09	ABNB	Stock	199.203	209.22	196.16	199.88	4725800.0
2021-02-09	ABR	Stock	15.11	15.26	15.0	15.08	1141000.0
2021-02-09	ABR.A-DELISTED	Stock	26.215	26.2499	26.16	26.16	1237.0
2021-02-09	ABR.B-DELISTED	Stock	25.69	25.69	25.65	25.65	1781.0

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

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