PREVIEW / stock_daily / 2021-07-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-22.parquet
  size:    257 KB
  rows:    7,880
  symbols: 2,816

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-07-22	AAPL	Stock	145.94	148.2	145.81	146.8	77338200.0
2021-07-22	MSFT	Stock	283.84	286.42	283.42	286.14	23384100.0
2021-07-22	NVDA	Stock	19.642	19.887	19.276	19.594	323826000.0
2021-07-22	AMZN	Stock	179.3615	182.001	179.1135	181.9015	65308000.0
2021-07-22	GOOGL	Stock	127.844	128.483	127.4988	128.4215	14301880.0
2021-07-22	META	Stock	346.68	351.54	345.21	351.19	12385400.0
2021-07-22	TSLA	Stock	218.8133	220.7233	214.8667	216.42	45317100.0
2021-07-22	TLT	Stock	148.11	149.805	148.06	149.5	18136907.0
2021-07-22	ES	Stock	83.99	85.05	83.75	84.81	1329500.0
2021-07-22	CL	Stock	81.64	82.48	81.29	81.84	3659900.0
2021-07-22	A	Stock	149.71	150.5	148.67	150.3	1972800.0
2021-07-22	AA	Stock	36.95	37.49	36.1	37.23	7230100.0
2021-07-22	AAC-DELISTED	Stock	9.79	9.79	9.74	9.76	8478.0
2021-07-22	AACG	Stock	3.14	3.47	3.1	3.33	307700.0
2021-07-22	AAIC-DELISTED	Stock	3.96	4.0	3.87	3.91	497751.0
2021-07-22	AAIC.C-DELISTED	Stock	25.17	25.225	24.9	25.15	4039.0
2021-07-22	AAL	Stock	21.06	21.62	20.59	21.16	39028300.0
2021-07-22	AAM.A-DELISTED	Stock	26.61	26.61	26.234	26.38	16828.0
2021-07-22	AAM.B-DELISTED	Stock	27.0	27.0251	26.94	27.0216	27115.0
2021-07-22	AAMC-DELISTED	Stock	5.0588	5.2912	4.8941	4.9941	46339.0
2021-07-22	AAME	Stock	4.0	4.05	3.93	3.93	15600.0
2021-07-22	AAMI	Stock	23.95	23.95	23.5	23.69	239700.0
2021-07-22	AAN-DELISTED	Stock	28.51	28.7	27.58	27.8	188100.0
2021-07-22	AAOI	Stock	7.64	7.65	7.33	7.4	460900.0
2021-07-22	AAON	Stock	41.2067	41.3533	39.9933	40.06	127350.0
2021-07-22	AAP	Stock	209.86	210.61	207.68	210.29	450400.0
2021-07-22	AAQC-DELISTED	Stock	9.77	9.77	9.65	9.6836	6536.0
2021-07-22	AAT	Stock	37.28	37.28	36.64	36.7	415100.0
2021-07-22	AATC	Stock	6.6	6.77	6.39	6.46	20583.0
2021-07-22	AAU-DELISTED	Stock	0.436	0.447	0.421	0.4255	411128.0
2021-07-22	AAUAF-DELISTED	Stock	0.436	0.447	0.421	0.4277	426829.0
2021-07-22	AAWW-DELISTED	Stock	65.5	65.5	64.03	64.9	133935.0
2021-07-22	AAXJ	Stock	91.51	91.55	90.99	91.32	1162140.0
2021-07-22	AB	Stock	46.07	46.1	45.48	45.82	177400.0
2021-07-22	ABB-DELISTED	Stock	36.08	36.21	35.92	36.03	1364902.0
2021-07-22	ABBNY-DELISTED	Stock	36.08	36.21	35.92	36.02	1507585.0
2021-07-22	ABBV	Stock	116.64	117.91	116.39	117.54	6257000.0
2021-07-22	ABC-DELISTED	Stock	118.22	120.05	117.61	119.84	696402.0
2021-07-22	ABCB	Stock	47.43	47.43	45.45	45.7	294800.0
2021-07-22	ABCL	Stock	16.75	16.861	16.0	16.03	1029800.0
2021-07-22	ABCM-DELISTED	Stock	17.8	18.09	17.64	18.09	200272.0
2021-07-22	ABEO	Stock	34.0	34.0	31.75	33.0	19836.0
2021-07-22	ABEV	Stock	3.26	3.26	3.2	3.21	12778500.0
2021-07-22	ABG	Stock	197.17	198.23	194.45	195.22	79000.0
2021-07-22	ABGI-DELISTED	Stock	9.85	9.85	9.79	9.79	811.0
2021-07-22	ABM	Stock	45.41	45.65	45.08	45.38	422900.0
2021-07-22	ABMD-DELISTED	Stock	323.99	323.99	319.52	323.58	50513.0
2021-07-22	ABNB	Stock	141.29	141.29	137.66	139.47	4628400.0
2021-07-22	ABOS	Stock	17.51	17.585	16.77	17.13	62200.0
2021-07-22	ABR	Stock	17.82	17.9	17.53	17.58	928200.0

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

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