PREVIEW / stock_daily / 2021-06-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-29.parquet
  size:    258 KB
  rows:    7,878
  symbols: 2,881

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-06-29	AAPL	Stock	134.8	136.49	134.35	136.33	64556100.0
2021-06-29	MSFT	Stock	268.87	271.65	267.98	271.4	19937800.0
2021-06-29	NVDA	Stock	19.8825	20.0988	19.657	20.0268	367632000.0
2021-06-29	AMZN	Stock	171.941	172.8015	171.1515	172.407	41968000.0
2021-06-29	GOOGL	Stock	122.6704	123.0208	121.6908	122.2725	23108720.0
2021-06-29	META	Stock	356.27	356.74	349.05	351.89	21417300.0
2021-06-29	TSLA	Stock	228.2167	229.17	225.2967	226.92	52143900.0
2021-06-29	TLT	Stock	143.1	143.72	143.04	143.71	11218106.0
2021-06-29	ES	Stock	81.05	81.74	79.88	80.13	987900.0
2021-06-29	CL	Stock	81.86	82.08	81.07	81.25	3056700.0
2021-06-29	A	Stock	147.57	148.84	147.53	148.81	816700.0
2021-06-29	AA	Stock	36.55	38.0	36.54	37.53	8493500.0
2021-06-29	AAC-DELISTED	Stock	9.74	9.81	9.72	9.77	60375.0
2021-06-29	AACG	Stock	2.93	3.15	2.93	3.08	111500.0
2021-06-29	AAIC-DELISTED	Stock	4.18	4.22	4.13	4.21	237665.0
2021-06-29	AAIC.C-DELISTED	Stock	25.03	25.14	25.02	25.14	1220.0
2021-06-29	AAL	Stock	21.32	21.4	21.02	21.08	29157400.0
2021-06-29	AAM.A-DELISTED	Stock	26.06	26.23	26.04	26.2	41906.0
2021-06-29	AAM.B-DELISTED	Stock	26.92	26.9794	26.82	26.87	70517.0
2021-06-29	AAMC-DELISTED	Stock	5.7412	5.7412	5.6618	5.6618	4427.0
2021-06-29	AAME	Stock	4.25	4.51	4.23	4.36	147900.0
2021-06-29	AAMI	Stock	23.7	23.815	23.52	23.59	305600.0
2021-06-29	AAN-DELISTED	Stock	34.12	34.287	32.66	32.8	250700.0
2021-06-29	AAOI	Stock	8.85	9.19	8.56	8.67	550700.0
2021-06-29	AAON	Stock	41.2133	42.66	41.1067	42.5067	232050.0
2021-06-29	AAP	Stock	205.0	207.16	204.29	205.3	574600.0
2021-06-29	AAQC-DELISTED	Stock	9.71	9.7108	9.69	9.7018	33938.0
2021-06-29	AAT	Stock	36.97	37.43	36.97	37.16	307500.0
2021-06-29	AAU-DELISTED	Stock	0.49	0.5022	0.49	0.4901	519561.0
2021-06-29	AAUAF-DELISTED	Stock	0.49	0.5022	0.488	0.488	555196.0
2021-06-29	AAWW-DELISTED	Stock	67.82	68.98	67.57	68.48	170121.0
2021-06-29	AAXJ	Stock	94.32	95.03	94.09	95.03	788687.0
2021-06-29	AB	Stock	46.47	46.89	45.87	46.14	209800.0
2021-06-29	ABB-DELISTED	Stock	34.65	34.71	34.435	34.51	1192766.0
2021-06-29	ABBNY-DELISTED	Stock	34.65	34.71	34.435	34.51	1303401.0
2021-06-29	ABBV	Stock	112.65	112.75	111.61	112.3	5795100.0
2021-06-29	ABC-DELISTED	Stock	115.12	115.84	114.36	114.44	634860.0
2021-06-29	ABCB	Stock	51.85	52.54	50.52	50.68	270700.0
2021-06-29	ABCL	Stock	20.36	21.4	20.12	21.28	2300300.0
2021-06-29	ABCM-DELISTED	Stock	19.73	20.03	19.35	19.5	448526.0
2021-06-29	ABEO	Stock	42.25	42.5	40.75	41.0	44356.0
2021-06-29	ABEV	Stock	3.52	3.52	3.4	3.49	41513900.0
2021-06-29	ABG	Stock	164.46	165.37	160.92	163.13	137600.0
2021-06-29	ABGI-DELISTED	Stock	9.78	9.845	9.78	9.84	3436.0
2021-06-29	ABM	Stock	44.58	45.35	43.98	44.08	517700.0
2021-06-29	ABMD-DELISTED	Stock	311.31	315.91	309.8	313.0978	117655.0
2021-06-29	ABNB	Stock	149.75	149.94	145.77	146.08	7479000.0
2021-06-29	ABR	Stock	18.15	18.26	18.01	18.07	1434100.0
2021-06-29	ABR.D	Stock	25.4	25.4499	25.4	25.42	67354.0
2021-06-29	ABST-DELISTED	Stock	14.49	14.54	14.34	14.48	88854.0

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

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