PREVIEW / stock_daily / 2021-08-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-30.parquet
  size:    257 KB
  rows:    7,859
  symbols: 2,726

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-08-30	AAPL	Stock	149.0	153.49	148.61	153.12	90956700.0
2021-08-30	MSFT	Stock	301.12	304.22	301.06	303.59	16348100.0
2021-08-30	NVDA	Stock	22.83	23.043	22.551	22.688	262580000.0
2021-08-30	AMZN	Stock	167.8715	172.25	167.761	171.0785	63844000.0
2021-08-30	GOOGL	Stock	144.4	145.9705	144.163	144.5905	24434200.0
2021-08-30	META	Stock	372.56	381.49	370.52	380.66	13547300.0
2021-08-30	TSLA	Stock	238.24	243.6667	237.5767	243.6367	55812600.0
2021-08-30	TLT	Stock	148.99	149.9	148.93	149.85	10596306.0
2021-08-30	ES	Stock	90.05	91.15	90.04	91.05	683000.0
2021-08-30	CL	Stock	77.63	77.94	77.45	77.65	1960800.0
2021-08-30	A	Stock	173.86	177.12	173.86	176.73	1221400.0
2021-08-30	AA	Stock	44.5	44.88	43.33	44.05	5552300.0
2021-08-30	AAC-DELISTED	Stock	9.68	9.7	9.66	9.69	1078458.0
2021-08-30	AACG	Stock	2.68	2.74	2.64	2.7	45900.0
2021-08-30	AACIU	Stock	9.89	9.89	9.89	9.89	345.0
2021-08-30	AAIC-DELISTED	Stock	3.78	4.0	3.76	3.79	231549.0
2021-08-30	AAIC.C-DELISTED	Stock	25.32	25.37	25.32	25.37	910.0
2021-08-30	AAL	Stock	20.29	20.3	19.47	19.51	24094300.0
2021-08-30	AAM.A-DELISTED	Stock	26.25	26.25	26.18	26.19	9875.0
2021-08-30	AAM.B-DELISTED	Stock	27.2196	27.33	27.2196	27.2704	11277.0
2021-08-30	AAMC-DELISTED	Stock	4.1882	5.2206	4.1882	5.2206	278151.0
2021-08-30	AAME	Stock	3.86	3.92	3.76	3.87	33300.0
2021-08-30	AAMI	Stock	27.68	27.68	27.16	27.25	372800.0
2021-08-30	AAN-DELISTED	Stock	27.54	28.16	27.5	27.89	251400.0
2021-08-30	AAOI	Stock	7.3	7.36	7.14	7.28	315800.0
2021-08-30	AAON	Stock	46.06	46.2267	45.6467	46.1333	244050.0
2021-08-30	AAP	Stock	204.0	204.34	201.06	201.14	549400.0
2021-08-30	AAQC-DELISTED	Stock	9.6201	9.65	9.62	9.65	13048.0
2021-08-30	AAT	Stock	39.51	39.51	38.46	39.4	225900.0
2021-08-30	AATC	Stock	7.82	8.0	7.6371	7.78	81081.0
2021-08-30	AAU-DELISTED	Stock	0.43	0.43	0.4099	0.4138	373850.0
2021-08-30	AAUAF-DELISTED	Stock	0.43	0.43	0.4099	0.4138	381937.0
2021-08-30	AAWW-DELISTED	Stock	73.99	74.09	72.815	73.49	196835.0
2021-08-30	AAXJ	Stock	87.45	87.6	86.99	87.46	750833.0
2021-08-30	AB	Stock	52.24	52.65	52.0	52.19	158600.0
2021-08-30	ABB-DELISTED	Stock	37.34	37.61	37.29	37.46	1035939.0
2021-08-30	ABBNY-DELISTED	Stock	37.34	37.61	37.29	37.46	1161951.0
2021-08-30	ABBV	Stock	119.84	120.9	119.54	120.57	3260900.0
2021-08-30	ABC-DELISTED	Stock	119.57	120.49	119.35	119.51	234851.0
2021-08-30	ABCB	Stock	50.0	50.21	48.61	48.69	217600.0
2021-08-30	ABCL	Stock	17.86	17.99	16.9	17.35	1031800.0
2021-08-30	ABCM-DELISTED	Stock	20.6	21.09	20.6	20.97	53828.0
2021-08-30	ABEO	Stock	32.25	33.0	31.75	32.0	14520.0
2021-08-30	ABEV	Stock	3.2	3.28	3.18	3.27	13604500.0
2021-08-30	ABG	Stock	191.48	191.48	185.35	185.62	101400.0
2021-08-30	ABGI-DELISTED	Stock	9.62	9.62	9.62	9.62	100.0
2021-08-30	ABM	Stock	49.86	49.97	49.11	49.14	252800.0
2021-08-30	ABMD-DELISTED	Stock	360.68	364.485	359.81	360.6	60590.0
2021-08-30	ABNB	Stock	154.41	157.49	151.92	156.02	3968700.0
2021-08-30	ABOS	Stock	18.91	19.46	18.53	18.85	101800.0

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

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