PREVIEW / stock_daily / 2021-09-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-21.parquet
  size:    256 KB
  rows:    7,809
  symbols: 2,647

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-21	AAPL	Stock	143.93	144.6	142.78	143.43	75834000.0
2021-09-21	MSFT	Stock	295.69	297.54	294.07	294.8	22364100.0
2021-09-21	NVDA	Stock	21.417	21.425	20.95	21.246	204688000.0
2021-09-21	AMZN	Stock	168.75	168.985	166.6195	167.1815	55618000.0
2021-09-21	GOOGL	Stock	139.7495	140.0115	138.278	139.033	25331900.0
2021-09-21	META	Stock	358.5	360.04	355.19	357.48	11751900.0
2021-09-21	TSLA	Stock	244.93	248.2467	243.48	246.46	48992100.0
2021-09-21	TLT	Stock	150.71	150.96	150.2	150.89	10035770.0
2021-09-21	ES	Stock	83.37	84.45	83.29	83.54	1066000.0
2021-09-21	CL	Stock	76.28	77.11	76.26	76.39	4247500.0
2021-09-21	A	Stock	172.3	173.6	171.19	171.44	1059800.0
2021-09-21	AA	Stock	48.75	49.14	44.48	45.6	14587100.0
2021-09-21	AAC-DELISTED	Stock	9.72	9.76	9.72	9.73	122097.0
2021-09-21	AACG	Stock	2.37	2.43	2.35	2.41	20500.0
2021-09-21	AACIU	Stock	9.93	9.93	9.895	9.93	1907430.0
2021-09-21	AAIC-DELISTED	Stock	3.71	3.75	3.71	3.72	61054.0
2021-09-21	AAIC.C-DELISTED	Stock	25.2477	25.2477	25.2477	25.2477	300.0
2021-09-21	AAL	Stock	20.42	20.75	19.67	19.76	34050100.0
2021-09-21	AAM.A-DELISTED	Stock	25.71	25.7999	25.68	25.73	7323.0
2021-09-21	AAM.B-DELISTED	Stock	26.82	26.9	26.82	26.87	2498.0
2021-09-21	AAMC-DELISTED	Stock	7.4353	7.5	7.1647	7.1647	50997.0
2021-09-21	AAME	Stock	3.64	3.97	3.6	3.85	26000.0
2021-09-21	AAMI	Stock	26.38	26.41	25.9	26.25	472100.0
2021-09-21	AAN-DELISTED	Stock	26.77	26.945	26.201	26.68	222100.0
2021-09-21	AAOI	Stock	7.04	7.09	6.76	6.78	351200.0
2021-09-21	AAON	Stock	44.1467	44.1467	43.3333	43.4933	123000.0
2021-09-21	AAP	Stock	206.51	206.81	204.11	205.66	585200.0
2021-09-21	AAQC-DELISTED	Stock	9.69	9.7	9.69	9.7	2549.0
2021-09-21	AAT	Stock	38.43	38.62	37.99	38.01	254900.0
2021-09-21	AATC	Stock	7.35	7.64	7.35	7.59	54716.0
2021-09-21	AAU-DELISTED	Stock	0.3865	0.3988	0.375	0.3968	525903.0
2021-09-21	AAUAF-DELISTED	Stock	0.3865	0.3988	0.375	0.3968	532484.0
2021-09-21	AAWW-DELISTED	Stock	74.8	74.8	72.48	72.58	231153.0
2021-09-21	AAXJ	Stock	85.19	85.28	84.77	85.0	1279325.0
2021-09-21	AB	Stock	48.99	50.24	48.61	49.67	370000.0
2021-09-21	ABB-DELISTED	Stock	35.24	35.25	34.815	34.95	1180438.0
2021-09-21	ABBNY-DELISTED	Stock	35.24	35.25	34.815	34.95	1335496.0
2021-09-21	ABBV	Stock	106.25	107.41	106.2	107.15	6400400.0
2021-09-21	ABC-DELISTED	Stock	122.72	123.57	120.99	121.51	604618.0
2021-09-21	ABCB	Stock	46.78	47.45	46.15	46.53	370700.0
2021-09-21	ABCL	Stock	20.53	21.179	19.75	21.08	3426100.0
2021-09-21	ABCM-DELISTED	Stock	20.62	21.13	20.6	20.98	47247.0
2021-09-21	ABEO	Stock	30.75	30.75	29.5	30.25	12368.0
2021-09-21	ABEV	Stock	2.92	2.98	2.9	2.92	21424900.0
2021-09-21	ABG	Stock	181.74	185.18	179.63	181.14	131500.0
2021-09-21	ABM	Stock	44.6	44.89	43.85	44.06	210800.0
2021-09-21	ABMD-DELISTED	Stock	349.99	353.46	343.66	344.86	190789.0
2021-09-21	ABNB	Stock	164.0	170.01	162.96	169.29	8592500.0
2021-09-21	ABOS	Stock	14.73	15.58	14.61	15.04	404000.0
2021-09-21	ABR	Stock	18.04	18.11	17.84	17.84	1281400.0

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

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