PREVIEW / stock_daily / 2021-08-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-03.parquet
  size:    256 KB
  rows:    7,856
  symbols: 2,772

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-03	AAPL	Stock	145.81	148.04	145.18	147.36	64786600.0
2021-08-03	MSFT	Stock	285.42	287.23	284.0	287.12	17879000.0
2021-08-03	NVDA	Stock	19.74	20.222	19.22	19.815	301811000.0
2021-08-03	AMZN	Stock	167.036	169.55	164.9885	168.312	83146000.0
2021-08-03	GOOGL	Stock	135.135	135.732	133.3195	135.63	20761880.0
2021-08-03	META	Stock	352.73	353.77	347.7	351.24	12406100.0
2021-08-03	TSLA	Stock	239.6667	240.8833	233.67	236.58	64860900.0
2021-08-03	TLT	Stock	150.75	151.23	150.39	150.75	13361939.0
2021-08-03	ES	Stock	87.23	88.96	86.94	87.8	1671400.0
2021-08-03	CL	Stock	79.34	79.88	79.09	79.42	3635700.0
2021-08-03	A	Stock	153.71	153.97	152.76	153.86	1859700.0
2021-08-03	AA	Stock	39.52	40.45	38.0	40.38	6269200.0
2021-08-03	AAC-DELISTED	Stock	9.75	9.76	9.725	9.74	54678.0
2021-08-03	AACG	Stock	3.08	3.11	2.83	2.88	123900.0
2021-08-03	AAIC-DELISTED	Stock	3.83	3.83	3.7264	3.82	101894.0
2021-08-03	AAL	Stock	20.08	20.08	19.31	19.95	36572600.0
2021-08-03	AAM.A-DELISTED	Stock	26.35	26.45	26.3	26.4	16925.0
2021-08-03	AAM.B-DELISTED	Stock	27.04	27.1065	27.04	27.1065	4306.0
2021-08-03	AAMC-DELISTED	Stock	4.7	4.7265	4.4382	4.5147	27023.0
2021-08-03	AAME	Stock	4.25	4.38	4.1	4.25	30400.0
2021-08-03	AAMI	Stock	25.22	25.3	24.93	25.3	661900.0
2021-08-03	AAN-DELISTED	Stock	28.95	29.55	28.62	29.2	278900.0
2021-08-03	AAOI	Stock	7.64	7.67	7.38	7.62	672300.0
2021-08-03	AAON	Stock	41.36	42.32	41.06	41.9867	290550.0
2021-08-03	AAP	Stock	213.1	217.66	211.81	215.4	441700.0
2021-08-03	AAQC-DELISTED	Stock	9.66	9.67	9.66	9.67	1662.0
2021-08-03	AAT	Stock	37.04	37.04	36.16	36.92	370800.0
2021-08-03	AATC	Stock	7.0	7.22	6.6815	6.81	56567.0
2021-08-03	AAU-DELISTED	Stock	0.4332	0.4351	0.412	0.4325	301117.0
2021-08-03	AAUAF-DELISTED	Stock	0.4332	0.4351	0.412	0.4325	308667.0
2021-08-03	AAWW-DELISTED	Stock	66.19	67.88	65.925	67.51	379960.0
2021-08-03	AAXJ	Stock	88.28	88.65	87.9	88.65	1027072.0
2021-08-03	AB	Stock	49.4	50.34	48.85	50.23	258700.0
2021-08-03	ABB-DELISTED	Stock	36.65	37.15	36.64	37.08	2842925.0
2021-08-03	ABBNY-DELISTED	Stock	36.65	37.15	36.64	37.1	3050902.0
2021-08-03	ABBV	Stock	115.67	116.31	114.89	116.25	5902700.0
2021-08-03	ABC-DELISTED	Stock	122.84	124.33	122.42	123.71	624963.0
2021-08-03	ABCB	Stock	48.58	49.0	47.2	48.76	375300.0
2021-08-03	ABCL	Stock	16.0	16.0	15.35	15.75	1029200.0
2021-08-03	ABCM-DELISTED	Stock	19.54	19.8	19.39	19.72	81446.0
2021-08-03	ABEO	Stock	31.75	32.0	30.75	30.75	25044.0
2021-08-03	ABEV	Stock	3.16	3.28	3.11	3.25	28308700.0
2021-08-03	ABG	Stock	205.02	205.02	197.75	198.22	305600.0
2021-08-03	ABGI-DELISTED	Stock	9.68	9.7	9.68	9.69	2330.0
2021-08-03	ABM	Stock	45.55	47.27	45.03	47.19	662600.0
2021-08-03	ABMD-DELISTED	Stock	330.96	333.6	323.98	326.39	119228.0
2021-08-03	ABNB	Stock	147.728	147.79	143.28	145.65	5491000.0
2021-08-03	ABOS	Stock	15.35	15.85	14.7	14.95	274800.0
2021-08-03	ABR	Stock	18.23	18.23	17.69	17.87	1493300.0
2021-08-03	ABR.D	Stock	25.63	25.65	25.6	25.64	15715.0

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

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