PREVIEW / stock_daily / 2021-10-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-07.parquet
  size:    258 KB
  rows:    7,903
  symbols: 2,701

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-10-07	AAPL	Stock	143.06	144.22	142.72	143.29	61732700.0
2021-10-07	MSFT	Stock	295.18	296.64	293.92	294.85	20430500.0
2021-10-07	NVDA	Stock	21.092	21.322	20.972	21.075	256919000.0
2021-10-07	AMZN	Stock	164.577	166.2875	164.153	165.1215	48182000.0
2021-10-07	GOOGL	Stock	138.892	140.042	138.6512	139.225	25110140.0
2021-10-07	META	Stock	337.0	338.84	328.98	329.22	28307500.0
2021-10-07	TSLA	Stock	261.82	268.3333	261.1267	264.5367	57587400.0
2021-10-07	TLT	Stock	143.185	143.335	142.59	142.88	14856041.0
2021-10-07	ES	Stock	86.3	87.05	85.27	86.09	1551400.0
2021-10-07	CL	Stock	75.53	76.41	75.52	75.59	3642200.0
2021-10-07	A	Stock	155.06	157.48	154.96	155.32	1002800.0
2021-10-07	AA	Stock	48.17	48.26	46.94	47.05	5916600.0
2021-10-07	AAC-DELISTED	Stock	9.77	9.78	9.75	9.755	6762.0
2021-10-07	AACG	Stock	2.29	2.35	2.24	2.27	14600.0
2021-10-07	AACIU	Stock	9.915	9.96	9.9	9.93	3796.0
2021-10-07	AAIC-DELISTED	Stock	3.74	3.79	3.74	3.76	104421.0
2021-10-07	AAIC.C-DELISTED	Stock	25.3	25.3	24.96	25.0	2459.0
2021-10-07	AAL	Stock	20.84	20.9	20.08	20.17	29167200.0
2021-10-07	AAM.A-DELISTED	Stock	25.75	25.7606	25.63	25.64	6058.0
2021-10-07	AAM.B-DELISTED	Stock	26.97	26.97	26.73	26.77	18422.0
2021-10-07	AAMC-DELISTED	Stock	6.8529	7.0588	6.8235	7.0588	14079.0
2021-10-07	AAME	Stock	4.53	4.55	4.3	4.33	32900.0
2021-10-07	AAMI	Stock	26.89	27.13	26.48	26.57	426400.0
2021-10-07	AAN-DELISTED	Stock	27.71	28.23	27.66	28.2	147400.0
2021-10-07	AAOI	Stock	6.91	7.07	6.88	6.9	463600.0
2021-10-07	AAON	Stock	45.38	46.6333	45.38	46.5733	204300.0
2021-10-07	AAP	Stock	212.34	214.93	212.34	214.5	321400.0
2021-10-07	AAQC-DELISTED	Stock	9.75	9.76	9.69	9.72	78155.0
2021-10-07	AAT	Stock	38.18	38.67	38.04	38.31	189700.0
2021-10-07	AATC	Stock	7.1	7.39	7.1	7.1	26752.0
2021-10-07	AAU-DELISTED	Stock	0.38	0.3995	0.38	0.392	473258.0
2021-10-07	AAUAF-DELISTED	Stock	0.38	0.3995	0.38	0.392	482992.0
2021-10-07	AAWW-DELISTED	Stock	84.82	85.33	82.95	83.19	251481.0
2021-10-07	AAXJ	Stock	84.8	85.75	84.8	85.42	594009.0
2021-10-07	AB	Stock	50.5	51.02	50.18	50.21	214600.0
2021-10-07	ABB-DELISTED	Stock	33.18	33.43	33.18	33.21	1276839.0
2021-10-07	ABBNY-DELISTED	Stock	33.18	33.43	33.18	33.21	1391600.0
2021-10-07	ABBV	Stock	109.78	111.79	109.56	110.87	7842600.0
2021-10-07	ABC-DELISTED	Stock	117.25	119.345	117.03	118.58	482180.0
2021-10-07	ABCB	Stock	52.78	53.13	52.41	53.13	215800.0
2021-10-07	ABCL	Stock	15.67	16.2	15.41	15.78	1827700.0
2021-10-07	ABCM-DELISTED	Stock	20.23	20.79	20.165	20.76	61061.0
2021-10-07	ABEO	Stock	23.75	25.0	23.75	23.75	22584.0
2021-10-07	ABEV	Stock	2.7	2.72	2.68	2.68	14926000.0
2021-10-07	ABG	Stock	197.44	204.38	197.44	204.11	100800.0
2021-10-07	ABM	Stock	46.25	46.83	46.18	46.34	255900.0
2021-10-07	ABMD-DELISTED	Stock	339.05	344.04	338.82	340.57	122681.0
2021-10-07	ABNB	Stock	170.0	171.27	168.6	169.6	2119600.0
2021-10-07	ABOS	Stock	14.97	14.97	14.31	14.8	60100.0
2021-10-07	ABR	Stock	19.1	19.23	18.99	19.02	1597600.0

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

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