PREVIEW / stock_daily / 2021-06-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-15.parquet
  size:    258 KB
  rows:    7,866
  symbols: 2,924

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-15	AAPL	Stock	129.94	130.6	129.39	129.64	62746300.0
2021-06-15	MSFT	Stock	259.77	259.99	257.68	258.36	18038900.0
2021-06-15	NVDA	Stock	17.915	18.0162	17.728	17.7885	243032000.0
2021-06-15	AMZN	Stock	169.2	169.8495	168.1555	169.1565	48524000.0
2021-06-15	GOOGL	Stock	122.45	122.7755	121.056	121.4195	21562140.0
2021-06-15	META	Stock	336.99	339.92	335.03	336.75	15795200.0
2021-06-15	TSLA	Stock	205.5633	205.5967	199.41	199.7867	53292300.0
2021-06-15	TLT	Stock	140.8	141.09	140.48	141.05	18207559.0
2021-06-15	ES	Stock	82.6	84.45	82.49	83.77	2171100.0
2021-06-15	CL	Stock	83.69	83.87	83.15	83.27	3220700.0
2021-06-15	A	Stock	144.85	145.16	144.04	144.62	1035800.0
2021-06-15	AA	Stock	36.22	36.36	34.75	36.29	8600600.0
2021-06-15	AAC-DELISTED	Stock	9.79	9.82	9.78	9.8	48641.0
2021-06-15	AACG	Stock	3.23	3.29	3.1	3.12	48600.0
2021-06-15	AACQ-DELISTED	Stock	10.05	10.07	10.0001	10.01	4878760.0
2021-06-15	AACQU-DELISTED	Stock	10.9999	10.9999	10.8001	10.86	17677.0
2021-06-15	AACQW-DELISTED	Stock	2.51	2.6	2.4201	2.5	523532.0
2021-06-15	AAIC-DELISTED	Stock	4.11	4.17	4.07	4.08	162289.0
2021-06-15	AAIC.C-DELISTED	Stock	24.84	24.9801	24.84	24.88	1807.0
2021-06-15	AAL	Stock	22.97	23.13	22.55	22.79	19062200.0
2021-06-15	AAM.A-DELISTED	Stock	26.42	26.42	26.31	26.34	34196.0
2021-06-15	AAM.B-DELISTED	Stock	27.2	27.25	27.165	27.25	6792.0
2021-06-15	AAMC-DELISTED	Stock	5.7353	5.8706	5.6912	5.6912	8653.0
2021-06-15	AAME	Stock	4.41	4.41	4.2	4.21	85700.0
2021-06-15	AAMI	Stock	22.38	22.835	22.31	22.72	356200.0
2021-06-15	AAN-DELISTED	Stock	36.22	36.28	35.65	36.13	187600.0
2021-06-15	AAOI	Stock	8.755	8.88	8.64	8.69	358200.0
2021-06-15	AAON	Stock	42.68	42.9733	42.2	42.6	211350.0
2021-06-15	AAP	Stock	199.24	200.69	198.07	200.66	1136300.0
2021-06-15	AAQC-DELISTED	Stock	9.6801	9.69	9.68	9.69	18114.0
2021-06-15	AAT	Stock	38.8	38.8	38.39	38.5	298000.0
2021-06-15	AAU-DELISTED	Stock	0.5335	0.54	0.522	0.526	536211.0
2021-06-15	AAUAF-DELISTED	Stock	0.5335	0.54	0.522	0.5264	565681.0
2021-06-15	AAWW-DELISTED	Stock	73.13	73.73	72.53	73.19	293770.0
2021-06-15	AAXJ	Stock	94.51	94.51	93.88	93.99	440968.0
2021-06-15	AB	Stock	45.69	45.75	45.13	45.35	155000.0
2021-06-15	ABB-DELISTED	Stock	34.78	34.915	34.735	34.83	1043716.0
2021-06-15	ABBNY-DELISTED	Stock	34.78	34.915	34.735	34.82	1159560.0
2021-06-15	ABBV	Stock	115.36	115.94	114.52	115.83	3590500.0
2021-06-15	ABC-DELISTED	Stock	119.11	119.2838	118.3	119.03	301396.0
2021-06-15	ABCB	Stock	53.89	55.2	53.57	54.85	289700.0
2021-06-15	ABCL	Stock	24.88	24.88	23.47	23.53	2296000.0
2021-06-15	ABCM-DELISTED	Stock	18.72	18.72	18.5	18.55	182774.0
2021-06-15	ABEO	Stock	45.0	45.25	42.0	42.0	45704.0
2021-06-15	ABEV	Stock	3.83	3.84	3.77	3.82	15347600.0
2021-06-15	ABG	Stock	171.32	174.55	168.46	173.52	282600.0
2021-06-15	ABGI-DELISTED	Stock	9.97	9.97	9.95	9.95	4070.0
2021-06-15	ABM	Stock	47.88	48.0	47.48	48.0	402900.0
2021-06-15	ABMD-DELISTED	Stock	303.6	304.35	300.46	301.92	131879.0
2021-06-15	ABNB	Stock	149.2	153.74	148.84	151.78	12007700.0

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

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