PREVIEW / stock_daily / 2021-06-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-09.parquet
  size:    258 KB
  rows:    7,869
  symbols: 2,943

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-09	AAPL	Stock	127.21	127.75	126.52	127.13	56877900.0
2021-06-09	MSFT	Stock	253.81	255.53	253.21	253.59	17937600.0
2021-06-09	NVDA	Stock	17.5158	17.575	17.2558	17.3583	381656000.0
2021-06-09	AMZN	Stock	163.6435	164.879	163.535	164.0575	49110000.0
2021-06-09	GOOGL	Stock	120.5715	120.644	119.845	120.397	17941040.0
2021-06-09	META	Stock	335.74	336.8	330.0	330.25	13727900.0
2021-06-09	TSLA	Stock	200.7233	203.93	199.21	199.5933	49753800.0
2021-06-09	TLT	Stock	141.765	142.15	141.25	141.69	12768309.0
2021-06-09	ES	Stock	81.58	82.81	81.25	82.56	1930400.0
2021-06-09	CL	Stock	83.45	83.88	82.53	82.56	6530200.0
2021-06-09	A	Stock	139.13	140.37	138.87	140.13	961400.0
2021-06-09	AA	Stock	38.47	38.68	37.49	37.98	4926800.0
2021-06-09	AAC-DELISTED	Stock	9.81	9.83	9.7784	9.78	209075.0
2021-06-09	AACG	Stock	3.41	3.48	3.31	3.31	39000.0
2021-06-09	AACQ-DELISTED	Stock	10.05	10.07	9.98	10.0	2098481.0
2021-06-09	AACQU-DELISTED	Stock	10.64	10.82	10.64	10.71	2968.0
2021-06-09	AACQW-DELISTED	Stock	2.0	2.42	1.98	2.27	153832.0
2021-06-09	AAIC-DELISTED	Stock	4.16	4.27	4.16	4.19	213522.0
2021-06-09	AAIC.C-DELISTED	Stock	24.9944	25.2999	24.9778	25.16	8509.0
2021-06-09	AAL	Stock	24.37	24.41	23.84	23.85	20289000.0
2021-06-09	AAM.A-DELISTED	Stock	26.04	26.12	26.0	26.1	9755.0
2021-06-09	AAM.B-DELISTED	Stock	27.2	27.2	27.02	27.09	11835.0
2021-06-09	AAMC-DELISTED	Stock	5.1382	6.4411	4.9997	5.5882	234070.0
2021-06-09	AAME	Stock	4.29	4.37	4.17	4.19	49200.0
2021-06-09	AAMI	Stock	22.3	22.37	22.11	22.26	339100.0
2021-06-09	AAN-DELISTED	Stock	36.76	37.49	36.2	37.15	248400.0
2021-06-09	AAOI	Stock	8.85	8.98	8.652	8.69	368100.0
2021-06-09	AAON	Stock	43.0	43.2067	42.7933	43.0333	160800.0
2021-06-09	AAP	Stock	197.51	198.86	195.68	197.03	871300.0
2021-06-09	AAQC-DELISTED	Stock	9.74	9.75	9.705	9.73	167199.0
2021-06-09	AAT	Stock	38.47	38.58	38.18	38.57	306900.0
2021-06-09	AAU-DELISTED	Stock	0.5394	0.55	0.5357	0.5414	799444.0
2021-06-09	AAUAF-DELISTED	Stock	0.5394	0.55	0.5357	0.5417	815346.0
2021-06-09	AAWW-DELISTED	Stock	74.0	74.32	73.14	74.0	169792.0
2021-06-09	AAXJ	Stock	94.34	94.65	94.1	94.14	709161.0
2021-06-09	AB	Stock	45.84	46.5	45.5	46.21	294300.0
2021-06-09	ABB-DELISTED	Stock	34.86	34.87	34.67	34.73	847860.0
2021-06-09	ABBNY-DELISTED	Stock	34.86	34.87	34.67	34.73	917783.0
2021-06-09	ABBV	Stock	112.88	114.42	112.74	114.0	4884000.0
2021-06-09	ABC-DELISTED	Stock	118.12	118.91	117.3	117.4	493961.0
2021-06-09	ABCB	Stock	56.62	56.66	55.52	55.56	321600.0
2021-06-09	ABCL	Stock	23.5	24.84	23.25	23.84	3872600.0
2021-06-09	ABCM-DELISTED	Stock	19.16	19.31	19.03	19.03	203768.0
2021-06-09	ABEO	Stock	44.75	45.25	43.0	43.25	46360.0
2021-06-09	ABEV	Stock	3.91	3.93	3.79	3.79	39255700.0
2021-06-09	ABG	Stock	182.98	183.13	179.36	179.78	110100.0
2021-06-09	ABGI-DELISTED	Stock	9.9	9.95	9.88	9.95	3102.0
2021-06-09	ABM	Stock	48.1	49.36	48.0	48.54	497900.0
2021-06-09	ABMD-DELISTED	Stock	291.72	295.33	291.72	294.02	151267.0
2021-06-09	ABNB	Stock	148.57	149.36	144.46	144.85	5606500.0

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

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