PREVIEW / stock_daily / 2021-10-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-11.parquet
  size:    255 KB
  rows:    7,785
  symbols: 2,601

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-11	AAPL	Stock	142.27	144.81	141.81	142.81	64452200.0
2021-10-11	MSFT	Stock	292.92	297.97	292.75	294.23	19298600.0
2021-10-11	NVDA	Stock	20.575	21.063	20.511	20.695	163388000.0
2021-10-11	AMZN	Stock	163.75	164.6295	161.905	162.315	40684000.0
2021-10-11	GOOGL	Stock	139.292	140.712	138.859	138.914	17953620.0
2021-10-11	META	Stock	327.63	330.46	325.31	325.45	14708200.0
2021-10-11	TSLA	Stock	262.55	267.08	261.8333	263.98	42600900.0
2021-10-11	TLT	Stock	141.6	141.9	141.45	141.52	7213403.0
2021-10-11	ES	Stock	85.28	85.41	84.16	84.33	1163200.0
2021-10-11	CL	Stock	75.9	76.16	75.57	75.8	3742400.0
2021-10-11	A	Stock	151.49	152.36	149.88	150.02	1106300.0
2021-10-11	AA	Stock	47.91	49.38	47.15	47.29	6078800.0
2021-10-11	AAC-DELISTED	Stock	9.77	9.78	9.74	9.78	6111.0
2021-10-11	AACG	Stock	2.31	2.35	2.22	2.34	17700.0
2021-10-11	AACIU	Stock	9.9434	9.9434	9.9434	9.9434	1047.0
2021-10-11	AAIC-DELISTED	Stock	3.75	3.9	3.75	3.86	246983.0
2021-10-11	AAIC.C-DELISTED	Stock	25.2928	25.2944	25.099	25.099	1635.0
2021-10-11	AAL	Stock	19.98	20.51	19.85	20.13	23646800.0
2021-10-11	AAM.A-DELISTED	Stock	25.645	25.68	25.62	25.6323	9396.0
2021-10-11	AAM.B-DELISTED	Stock	26.75	26.758	26.7108	26.7408	8773.0
2021-10-11	AAMC-DELISTED	Stock	7.0311	7.3	6.9735	6.9735	15123.0
2021-10-11	AAME	Stock	4.5	4.58	4.23	4.5	23300.0
2021-10-11	AAMI	Stock	26.61	26.81	26.27	26.31	196600.0
2021-10-11	AAN-DELISTED	Stock	27.99	28.21	27.62	27.62	69800.0
2021-10-11	AAOI	Stock	6.75	6.97	6.75	6.81	195200.0
2021-10-11	AAON	Stock	45.94	46.38	45.2733	45.28	124050.0
2021-10-11	AAP	Stock	214.0	215.67	211.96	212.12	418500.0
2021-10-11	AAQC-DELISTED	Stock	9.79	9.79	9.75	9.75	829.0
2021-10-11	AAT	Stock	38.17	39.03	37.84	39.0	177700.0
2021-10-11	AATC	Stock	6.9	7.0799	6.9	7.06	16909.0
2021-10-11	AAU-DELISTED	Stock	0.3915	0.3915	0.38	0.3855	192778.0
2021-10-11	AAUAF-DELISTED	Stock	0.3915	0.3915	0.38	0.3855	198014.0
2021-10-11	AAWW-DELISTED	Stock	81.81	82.0309	79.67	80.23	199257.0
2021-10-11	AAXJ	Stock	85.92	86.23	85.34	85.34	825975.0
2021-10-11	AB	Stock	51.19	51.19	49.93	49.93	230600.0
2021-10-11	ABB-DELISTED	Stock	32.9	33.075	32.59	32.6	870860.0
2021-10-11	ABBNY-DELISTED	Stock	32.9	33.075	32.59	32.6	983220.0
2021-10-11	ABBV	Stock	111.14	111.4	110.28	110.34	4613800.0
2021-10-11	ABC-DELISTED	Stock	119.72	123.75	119.525	122.4	967280.0
2021-10-11	ABCB	Stock	53.31	53.58	52.48	52.49	158000.0
2021-10-11	ABCL	Stock	15.39	15.41	14.8	14.85	2016400.0
2021-10-11	ABCM-DELISTED	Stock	20.43	20.57	20.28	20.28	16929.0
2021-10-11	ABEO	Stock	24.0	24.0	22.0	23.0	49040.0
2021-10-11	ABEV	Stock	2.74	2.76	2.7	2.7	10605900.0
2021-10-11	ABG	Stock	210.63	212.66	208.8	211.17	183400.0
2021-10-11	ABM	Stock	46.25	46.75	45.56	45.58	205500.0
2021-10-11	ABMD-DELISTED	Stock	335.36	338.67	331.87	331.9	57434.0
2021-10-11	ABNB	Stock	170.0	171.54	166.63	166.67	2046300.0
2021-10-11	ABOS	Stock	13.5	13.88	12.7	13.09	62400.0
2021-10-11	ABR	Stock	19.24	19.37	18.97	19.0	1417300.0

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

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