PREVIEW / stock_daily / 2021-12-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-28.parquet
  size:    260 KB
  rows:    8,013
  symbols: 2,618

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-12-28	AAPL	Stock	180.16	181.33	178.53	179.29	79144300.0
2021-12-28	MSFT	Stock	343.15	343.81	340.32	341.25	15661500.0
2021-12-28	NVDA	Stock	31.312	31.33	30.012	30.322	420591000.0
2021-12-28	AMZN	Stock	170.1825	172.176	169.1355	170.661	54638000.0
2021-12-28	GOOGL	Stock	148.236	148.299	146.0543	146.687	18254300.0
2021-12-28	META	Stock	346.63	352.71	345.2	346.22	16637600.0
2021-12-28	TSLA	Stock	369.83	373.0	359.4733	362.8233	60324000.0
2021-12-28	TLT	Stock	149.6	149.78	148.01	148.29	9176428.0
2021-12-28	ES	Stock	89.25	90.14	89.08	90.06	550200.0
2021-12-28	CL	Stock	83.9	84.67	83.83	84.46	2201000.0
2021-12-28	A	Stock	159.68	159.79	158.12	159.18	764300.0
2021-12-28	AA	Stock	59.28	59.56	58.51	59.19	6000000.0
2021-12-28	AAC-DELISTED	Stock	9.74	9.75	9.74	9.75	7266.0
2021-12-28	AACG	Stock	1.12	1.18	1.12	1.17	26800.0
2021-12-28	AACIU	Stock	9.91	9.91	9.91	9.91	203.0
2021-12-28	AACIW-DELISTED	Stock	0.5015	0.51	0.5015	0.51	700.0
2021-12-28	AAIC-DELISTED	Stock	3.52	3.6	3.52	3.55	147997.0
2021-12-28	AAIC.C-DELISTED	Stock	25.3	25.3	25.3	25.3	300.0
2021-12-28	AAL	Stock	18.03	18.64	17.92	18.54	28263600.0
2021-12-28	AAM.A-DELISTED	Stock	25.453	25.48	25.453	25.465	15810.0
2021-12-28	AAM.B-DELISTED	Stock	26.39	26.67	26.39	26.49	6577.0
2021-12-28	AAME	Stock	3.05	3.2	3.05	3.13	14200.0
2021-12-28	AAMI	Stock	26.03	26.12	25.64	25.79	622400.0
2021-12-28	AAN-DELISTED	Stock	24.61	25.3	24.61	24.76	113600.0
2021-12-28	AAOI	Stock	5.59	5.62	5.46	5.48	356400.0
2021-12-28	AAON	Stock	53.3733	53.5733	52.5	52.9	166650.0
2021-12-28	AAP	Stock	236.03	238.99	234.9	238.13	601200.0
2021-12-28	AAQC-DELISTED	Stock	9.7	9.71	9.7	9.71	3886.0
2021-12-28	AAT	Stock	36.59	36.86	36.41	36.58	110300.0
2021-12-28	AATC	Stock	6.37	6.4998	6.34	6.34	15294.0
2021-12-28	AAU-DELISTED	Stock	0.31	0.3138	0.29	0.2944	661140.0
2021-12-28	AAUAF-DELISTED	Stock	0.31	0.3138	0.29	0.2973	665182.0
2021-12-28	AAWW-DELISTED	Stock	92.9	94.0	92.46	93.11	132696.0
2021-12-28	AAXJ	Stock	82.89	82.89	82.47	82.51	739106.0
2021-12-28	AB	Stock	48.84	49.07	48.62	49.03	142400.0
2021-12-28	ABB-DELISTED	Stock	38.32	38.455	38.27	38.39	707327.0
2021-12-28	ABBNY-DELISTED	Stock	38.32	38.455	38.27	38.38	802414.0
2021-12-28	ABBV	Stock	134.55	135.26	133.74	134.39	4237200.0
2021-12-28	ABC-DELISTED	Stock	131.76	132.85	131.5	132.41	406986.0
2021-12-28	ABCB	Stock	49.62	50.56	48.59	50.07	168700.0
2021-12-28	ABCL	Stock	14.6	14.74	13.705	13.71	1621200.0
2021-12-28	ABCM-DELISTED	Stock	23.42	23.82	23.0	23.06	80314.0
2021-12-28	ABEO	Stock	8.0	8.25	7.5	7.5	164488.0
2021-12-28	ABEV	Stock	2.73	2.76	2.71	2.73	9174200.0
2021-12-28	ABG	Stock	166.8	171.27	166.57	169.52	118600.0
2021-12-28	ABM	Stock	41.17	41.79	41.05	41.08	357800.0
2021-12-28	ABMD-DELISTED	Stock	360.2	360.27	355.22	357.6	139100.0
2021-12-28	ABNB	Stock	171.32	172.73	167.73	169.71	2292600.0
2021-12-28	ABOS	Stock	6.82	6.96	6.65	6.65	74700.0
2021-12-28	ABR	Stock	18.25	18.52	18.23	18.33	1007300.0

> showing 50 of 8,013 rows — these rows as CSV

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