PREVIEW / stock_daily / 2021-03-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-05.parquet
  size:    250 KB
  rows:    7,601
  symbols: 2,851

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-03-05	AAPL	Stock	120.98	121.94	117.57	121.42	153766600.0
2021-03-05	MSFT	Stock	229.52	233.27	226.46	231.6	41872800.0
2021-03-05	NVDA	Stock	12.55	12.55	11.6793	12.4615	542840000.0
2021-03-05	AMZN	Stock	150.25	150.45	144.05	150.023	107772000.0
2021-03-05	GOOGL	Stock	103.0575	105.31	101.3889	104.8535	53099540.0
2021-03-05	META	Stock	260.67	265.45	255.61	264.28	26820100.0
2021-03-05	TSLA	Stock	208.6867	209.28	179.83	199.3167	268189500.0
2021-03-05	TLT	Stock	138.1687	139.34	137.99	138.91	20598039.0
2021-03-05	ES	Stock	77.49	81.08	77.09	80.66	2149500.0
2021-03-05	CL	Stock	74.61	76.24	74.57	76.06	10241200.0
2021-03-05	A	Stock	115.88	116.19	112.47	116.14	2441500.0
2021-03-05	AA	Stock	29.23	30.505	27.41	28.99	7777600.0
2021-03-05	AACG	Stock	4.21	4.34	3.94	4.08	177200.0
2021-03-05	AACQ-DELISTED	Stock	10.4	10.77	10.14	10.65	3294156.0
2021-03-05	AACQU-DELISTED	Stock	10.94	11.33	10.61	11.3	18575.0
2021-03-05	AACQW-DELISTED	Stock	1.99	1.99	1.6	1.9	965853.0
2021-03-05	AAIC-DELISTED	Stock	4.09	4.15	3.8878	4.14	215225.0
2021-03-05	AAIC.C-DELISTED	Stock	22.25	22.2538	21.97	21.97	4020.0
2021-03-05	AAL	Stock	21.4	21.5	18.94	20.45	63183900.0
2021-03-05	AAM.A-DELISTED	Stock	25.78	25.84	25.7583	25.84	18658.0
2021-03-05	AAM.B-DELISTED	Stock	26.3	26.37	26.23	26.35	11732.0
2021-03-05	AAMC-DELISTED	Stock	6.9618	6.9618	6.2294	6.4029	139815.0
2021-03-05	AAME	Stock	3.59	3.74	3.25	3.67	104400.0
2021-03-05	AAMI	Stock	19.11	19.33	18.24	19.29	390600.0
2021-03-05	AAN-DELISTED	Stock	23.44	24.04	23.21	23.96	306800.0
2021-03-05	AAOI	Stock	7.96	8.1	7.33	8.045	1237400.0
2021-03-05	AAON	Stock	48.02	48.8533	47.1467	48.5333	493950.0
2021-03-05	AAP	Stock	167.04	172.11	165.23	171.51	817200.0
2021-03-05	AAT	Stock	34.28	34.7	33.49	34.6	427300.0
2021-03-05	AAU-DELISTED	Stock	0.64	0.695	0.5801	0.6421	1572633.0
2021-03-05	AAUAF-DELISTED	Stock	0.64	0.695	0.5801	0.6421	1615061.0
2021-03-05	AAWW-DELISTED	Stock	56.01	57.87	54.1	57.6	392298.0
2021-03-05	AAXJ	Stock	94.65	94.65	92.54	94.46	597123.0
2021-03-05	AB	Stock	36.99	37.54	36.1	37.39	502100.0
2021-03-05	ABB-DELISTED	Stock	29.43	29.775	28.93	29.69	3046566.0
2021-03-05	ABBNY-DELISTED	Stock	29.43	29.775	28.93	29.7	3284830.0
2021-03-05	ABBV	Stock	106.01	106.99	104.07	106.7	7277800.0
2021-03-05	ABC-DELISTED	Stock	103.73	105.45	101.84	104.79	833471.0
2021-03-05	ABCB	Stock	50.75	51.21	49.17	50.35	538800.0
2021-03-05	ABCL	Stock	30.51	31.736	26.16	28.61	1794000.0
2021-03-05	ABCM-DELISTED	Stock	21.15	21.28	20.79	21.21	84143.0
2021-03-05	ABEO	Stock	52.5	53.5	42.5	50.25	156716.0
2021-03-05	ABEV	Stock	2.68	2.73	2.67	2.71	39866600.0
2021-03-05	ABG	Stock	171.4	173.1	167.18	171.65	238800.0
2021-03-05	ABGI-DELISTED	Stock	10.0	10.0	9.91	9.97	450204.0
2021-03-05	ABM	Stock	45.26	46.5	44.74	46.22	306900.0
2021-03-05	ABMD-DELISTED	Stock	297.24	302.57	280.9962	300.67	263090.0
2021-03-05	ABNB	Stock	182.52	183.5	161.9	179.81	8788500.0
2021-03-05	ABR	Stock	16.13	16.17	14.82	15.68	2203600.0
2021-03-05	ABR.A-DELISTED	Stock	25.68	25.97	25.65	25.65	3776.0

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

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