PREVIEW / stock_daily / 2021-12-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-30.parquet
  size:    261 KB
  rows:    8,014
  symbols: 2,613

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-30	AAPL	Stock	179.47	180.57	178.09	178.2	59773000.0
2021-12-30	MSFT	Stock	341.91	343.13	338.82	339.32	15994500.0
2021-12-30	NVDA	Stock	29.827	30.457	29.54	29.586	308864000.0
2021-12-30	AMZN	Stock	169.7	170.888	168.524	168.6445	37584000.0
2021-12-30	GOOGL	Stock	146.694	147.3	145.9945	146.2005	15687720.0
2021-12-30	META	Stock	344.0	347.23	343.22	344.36	10593300.0
2021-12-30	TSLA	Stock	353.7767	365.1833	351.05	356.78	47040900.0
2021-12-30	TLT	Stock	147.25	147.9699	146.45	147.9	10355046.0
2021-12-30	ES	Stock	90.93	91.42	90.06	91.14	820300.0
2021-12-30	CL	Stock	85.1	85.18	84.49	84.59	2772000.0
2021-12-30	A	Stock	161.11	162.62	160.6	160.88	771000.0
2021-12-30	AA	Stock	59.68	61.59	59.14	59.21	4507500.0
2021-12-30	AAC-DELISTED	Stock	9.74	9.75	9.73	9.74	59618.0
2021-12-30	AACG	Stock	1.08	1.12	1.0	1.04	116400.0
2021-12-30	AACIU	Stock	10.02	10.02	9.9982	9.9982	1101.0
2021-12-30	AAIC-DELISTED	Stock	3.47	3.58	3.47	3.5	159305.0
2021-12-30	AAIC.C-DELISTED	Stock	25.2999	25.2999	25.17	25.21	1470.0
2021-12-30	AAL	Stock	17.98	18.38	17.96	18.07	28158200.0
2021-12-30	AAM.A-DELISTED	Stock	25.6	25.6	25.528	25.55	2904.0
2021-12-30	AAM.B-DELISTED	Stock	26.64	26.66	26.55	26.63	7300.0
2021-12-30	AAME	Stock	2.91	3.0	2.74	2.78	36200.0
2021-12-30	AAMI	Stock	25.76	26.39	25.735	25.92	1037600.0
2021-12-30	AAN-DELISTED	Stock	24.7	25.04	24.43	24.44	121900.0
2021-12-30	AAOI	Stock	5.29	5.45	5.16	5.35	609700.0
2021-12-30	AAON	Stock	53.1867	53.4067	52.7333	52.78	119100.0
2021-12-30	AAP	Stock	241.14	241.99	237.47	237.52	569400.0
2021-12-30	AAQC-DELISTED	Stock	9.72	9.72	9.7	9.7	2781.0
2021-12-30	AAT	Stock	37.46	37.85	37.05	37.5	427300.0
2021-12-30	AATC	Stock	6.38	6.4	6.2501	6.2792	12880.0
2021-12-30	AAU-DELISTED	Stock	0.286	0.3	0.286	0.2976	662993.0
2021-12-30	AAUAF-DELISTED	Stock	0.286	0.3	0.286	0.2976	672351.0
2021-12-30	AAWW-DELISTED	Stock	93.0	94.42	92.6	93.24	246493.0
2021-12-30	AAXJ	Stock	82.16	83.35	82.16	83.15	1232302.0
2021-12-30	AB	Stock	48.76	49.6	48.76	49.01	176300.0
2021-12-30	ABB-DELISTED	Stock	38.41	38.505	38.09	38.14	1262678.0
2021-12-30	ABBNY-DELISTED	Stock	38.41	38.505	38.09	38.14	1370634.0
2021-12-30	ABBV	Stock	135.75	136.83	135.63	135.93	6354300.0
2021-12-30	ABC-DELISTED	Stock	134.0	135.26	133.35	133.79	372079.0
2021-12-30	ABCB	Stock	50.35	50.74	49.62	49.71	201800.0
2021-12-30	ABCL	Stock	13.68	14.7	13.585	14.34	2779300.0
2021-12-30	ABCM-DELISTED	Stock	23.52	23.85	23.52	23.67	59206.0
2021-12-30	ABEO	Stock	7.5	8.25	7.5	8.0	265020.0
2021-12-30	ABEV	Stock	2.75	2.78	2.75	2.76	8389900.0
2021-12-30	ABG	Stock	169.04	173.4	168.74	170.09	338900.0
2021-12-30	ABGI-DELISTED	Stock	9.75	9.83	9.75	9.8	935.0
2021-12-30	ABM	Stock	40.62	41.16	40.49	40.54	245800.0
2021-12-30	ABMD-DELISTED	Stock	361.33	370.51	361.33	362.17	142918.0
2021-12-30	ABNB	Stock	167.06	170.85	165.71	168.78	2181100.0
2021-12-30	ABOS	Stock	6.73	7.25	6.55	6.9	245900.0
2021-12-30	ABR	Stock	18.47	18.67	18.4	18.43	1145900.0

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

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