PREVIEW / stock_daily / 2021-09-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-09.parquet
  size:    259 KB
  rows:    7,880
  symbols: 2,716

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-09-09	AAPL	Stock	155.49	156.11	153.95	154.07	57305700.0
2021-09-09	MSFT	Stock	300.82	302.14	297.0	297.25	19927000.0
2021-09-09	NVDA	Stock	22.312	22.538	22.131	22.177	196856000.0
2021-09-09	AMZN	Stock	176.301	177.4995	174.0185	174.208	54384000.0
2021-09-09	GOOGL	Stock	143.8405	144.3105	143.1775	143.541	15317100.0
2021-09-09	META	Stock	377.64	379.83	376.57	378.0	9098900.0
2021-09-09	TSLA	Stock	251.1367	254.0333	250.5433	251.62	42233100.0
2021-09-09	TLT	Stock	148.17	149.89	147.85	149.72	20324739.0
2021-09-09	ES	Stock	90.05	90.65	88.89	89.81	2580700.0
2021-09-09	CL	Stock	78.07	78.22	77.23	77.3	3956900.0
2021-09-09	A	Stock	179.07	179.36	177.02	177.23	1010000.0
2021-09-09	AA	Stock	46.185	47.89	46.04	47.51	7477600.0
2021-09-09	AAC-DELISTED	Stock	9.71	9.74	9.71	9.74	186431.0
2021-09-09	AACG	Stock	2.73	2.88	2.72	2.78	120600.0
2021-09-09	AACIU	Stock	9.88	9.93	9.85	9.88	553073.0
2021-09-09	AAIC-DELISTED	Stock	3.75	3.81	3.75	3.77	95674.0
2021-09-09	AAIC.C-DELISTED	Stock	25.3	25.3	25.3	25.3	197.0
2021-09-09	AAL	Stock	19.1	20.61	19.01	20.2	60077200.0
2021-09-09	AAM.A-DELISTED	Stock	25.92	26.0	25.91	25.93	17509.0
2021-09-09	AAM.B-DELISTED	Stock	26.8	26.98	26.8	26.9	16992.0
2021-09-09	AAMC-DELISTED	Stock	8.3824	9.1235	8.2353	8.5235	241033.0
2021-09-09	AAME	Stock	3.88	4.14	3.88	4.06	160800.0
2021-09-09	AAMI	Stock	26.82	27.27	26.8	26.84	326500.0
2021-09-09	AAN-DELISTED	Stock	26.14	27.09	26.14	26.69	165400.0
2021-09-09	AAOI	Stock	7.8	7.97	7.58	7.72	425600.0
2021-09-09	AAON	Stock	43.2533	43.52	42.7	43.1133	198150.0
2021-09-09	AAP	Stock	200.71	202.74	199.9	201.22	631200.0
2021-09-09	AAQC-DELISTED	Stock	9.69	9.75	9.63	9.67	50566.0
2021-09-09	AAT	Stock	39.64	39.92	39.27	39.29	244900.0
2021-09-09	AATC	Stock	8.16	8.2759	8.0379	8.25	26947.0
2021-09-09	AAU-DELISTED	Stock	0.4	0.4005	0.39	0.3949	516740.0
2021-09-09	AAUAF-DELISTED	Stock	0.4	0.4005	0.39	0.3949	524434.0
2021-09-09	AAWW-DELISTED	Stock	72.43	73.38	72.03	73.05	255180.0
2021-09-09	AAXJ	Stock	89.21	89.44	88.9066	89.19	640842.0
2021-09-09	AB	Stock	50.51	51.97	50.28	51.3	325800.0
2021-09-09	ABB-DELISTED	Stock	36.65	36.83	36.46	36.5	560914.0
2021-09-09	ABBNY-DELISTED	Stock	36.65	36.83	36.46	36.5	644900.0
2021-09-09	ABBV	Stock	109.44	109.74	107.2	107.27	10337100.0
2021-09-09	ABC-DELISTED	Stock	123.91	124.99	123.56	123.6	279234.0
2021-09-09	ABCB	Stock	46.31	47.2	46.31	46.75	368400.0
2021-09-09	ABCL	Stock	18.24	18.59	17.96	18.43	1135300.0
2021-09-09	ABCM-DELISTED	Stock	21.04	21.19	20.96	20.98	40286.0
2021-09-09	ABEO	Stock	31.25	33.25	31.0	32.5	17696.0
2021-09-09	ABEV	Stock	3.02	3.09	2.97	3.05	48027900.0
2021-09-09	ABG	Stock	173.62	177.84	173.62	174.63	139100.0
2021-09-09	ABM	Stock	45.52	47.99	45.29	45.9	867400.0
2021-09-09	ABMD-DELISTED	Stock	374.48	374.56	365.55	365.64	107366.0
2021-09-09	ABNB	Stock	163.0	166.97	160.83	166.0	5935800.0
2021-09-09	ABOS	Stock	18.35	18.68	17.26	17.7	164000.0
2021-09-09	ABR	Stock	18.01	18.41	17.97	18.23	1055200.0

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

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