PREVIEW / stock_daily / 2019-06-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-27.parquet
  size:    221 KB
  rows:    6,605
  symbols: 2,575

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
2019-06-27	AAPL	Stock	50.0725	50.3925	49.8925	49.935	83598800.0
2019-06-27	MSFT	Stock	134.14	134.71	133.51	134.15	16557500.0
2019-06-27	NVDA	Stock	4.0678	4.1	4.0315	4.0808	445440000.0
2019-06-27	AMZN	Stock	95.1	95.562	94.902	95.214	42834000.0
2019-06-27	GOOGL	Stock	54.3375	54.4232	53.7925	53.8315	24078280.0
2019-06-27	META	Stock	189.88	198.88	188.27	189.5	11159000.0
2019-06-27	TSLA	Stock	14.63	14.86	14.49	14.856	95095500.0
2019-06-27	TLT	Stock	132.31	133.09	131.99	132.9	9724166.0
2019-06-27	ES	Stock	76.01	76.01	75.19	75.41	1627300.0
2019-06-27	CL	Stock	72.34	72.45	71.91	72.14	2470800.0
2019-06-27	A	Stock	72.55	73.28	72.2	73.19	1480200.0
2019-06-27	AA	Stock	23.28	23.39	22.915	23.13	2625300.0
2019-06-27	AABA-DELISTED	Stock	69.88	70.34	69.71	70.0	5785970.0
2019-06-27	AAC-DELISTED	Stock	0.8651	0.88	0.8221	0.8352	355733.0
2019-06-27	AACG	Stock	2.79	2.79	2.52	2.6	135200.0
2019-06-27	AAIC-DELISTED	Stock	6.67	6.8093	6.65	6.76	517258.0
2019-06-27	AAIC.C-DELISTED	Stock	21.5743	21.5743	21.52	21.56	3286.0
2019-06-27	AAL	Stock	31.56	32.55	31.42	32.15	4274500.0
2019-06-27	AAM.A-DELISTED	Stock	25.61	25.79	25.61	25.71	18635.0
2019-06-27	AAM.B-DELISTED	Stock	25.7	25.86	25.7	25.83	18302.0
2019-06-27	AAMC-DELISTED	Stock	4.3235	4.3235	4.1206	4.1206	5885.0
2019-06-27	AAME	Stock	2.49	2.53	2.49	2.51	1800.0
2019-06-27	AAMI	Stock	11.0	11.13	11.0	11.11	520800.0
2019-06-27	AAOI	Stock	11.25	11.4	10.36	10.56	2291100.0
2019-06-27	AAON	Stock	32.3267	33.2067	32.3133	33.0133	211800.0
2019-06-27	AAP	Stock	150.09	153.03	149.17	151.71	1028900.0
2019-06-27	AAT	Stock	45.73	46.37	45.73	46.25	605100.0
2019-06-27	AAU-DELISTED	Stock	0.62	0.62	0.5758	0.5937	152482.0
2019-06-27	AAUAF-DELISTED	Stock	0.62	0.62	0.5758	0.5937	165083.0
2019-06-27	AAWW-DELISTED	Stock	42.06	43.62	42.06	43.6	170969.0
2019-06-27	AAXJ	Stock	69.79	69.99	69.68	69.96	2413039.0
2019-06-27	AAXN-DELISTED	Stock	67.0	67.42	66.22	66.89	728947.0
2019-06-27	AB	Stock	29.13	29.15	28.76	29.08	109400.0
2019-06-27	ABB-DELISTED	Stock	19.93	19.97	19.85	19.96	1018752.0
2019-06-27	ABBNY-DELISTED	Stock	19.93	19.97	19.85	19.96	1336793.0
2019-06-27	ABBV	Stock	68.16	70.6	68.1	70.0	22129200.0
2019-06-27	ABC-DELISTED	Stock	84.39	86.53	83.9	85.63	912393.0
2019-06-27	ABCB	Stock	38.27	38.95	38.27	38.94	427900.0
2019-06-27	ABDC-DELISTED	Stock	8.44	8.47	8.32	8.35	17605.0
2019-06-27	ABEO	Stock	116.75	119.5	111.75	119.0	92368.0
2019-06-27	ABEV	Stock	4.66	4.71	4.6	4.71	26697900.0
2019-06-27	ABG	Stock	82.66	84.0	82.33	83.94	138800.0
2019-06-27	ABIL-DELISTED	Stock	0.9057	0.93	0.888	0.9199	18584.0
2019-06-27	ABM	Stock	39.11	39.68	38.91	39.64	302300.0
2019-06-27	ABMD-DELISTED	Stock	253.97	257.54	253.0	254.99	214470.0
2019-06-27	ABR	Stock	11.85	11.91	11.75	11.81	1691800.0
2019-06-27	ABR.A-DELISTED	Stock	25.95	25.95	25.95	25.95	100.0
2019-06-27	ABR.B-DELISTED	Stock	25.6	25.92	25.6	25.755	5120.0
2019-06-27	ABT	Stock	83.39	83.98	83.07	83.69	4111600.0
2019-06-27	ABTC	Stock	600000.0	726600.0	600000.0	651000.0	20.0

> showing 50 of 6,605 rows — these rows as CSV

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