PREVIEW / stock_daily / 2019-07-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-09.parquet
  size:    222 KB
  rows:    6,586
  symbols: 2,553

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-07-09	AAPL	Stock	49.8	50.3775	49.7025	50.31	82312000.0
2019-07-09	MSFT	Stock	136.0	136.97	135.8	136.46	19953100.0
2019-07-09	NVDA	Stock	3.8878	3.961	3.875	3.9328	342860000.0
2019-07-09	AMZN	Stock	97.39	99.5005	97.174	99.415	86914000.0
2019-07-09	GOOGL	Stock	55.516	56.393	55.3575	56.2145	29472440.0
2019-07-09	META	Stock	194.97	199.46	194.89	199.21	14698600.0
2019-07-09	TSLA	Stock	15.2647	15.4	15.152	15.3373	92862000.0
2019-07-09	TLT	Stock	132.68	132.71	132.16	132.56	6216115.0
2019-07-09	ES	Stock	76.9	77.08	76.42	76.96	1496700.0
2019-07-09	CL	Stock	72.69	73.29	72.69	73.11	3885600.0
2019-07-09	A	Stock	73.49	74.08	73.11	73.45	2092200.0
2019-07-09	AA	Stock	21.7	22.25	21.16	22.22	4720900.0
2019-07-09	AABA-DELISTED	Stock	68.9	69.6	68.76	69.59	1252442.0
2019-07-09	AAC-DELISTED	Stock	1.21	1.67	1.17	1.25	1186309.0
2019-07-09	AACG	Stock	2.43	2.53	2.43	2.45	92100.0
2019-07-09	AAIC-DELISTED	Stock	6.28	6.32	6.2	6.3	740118.0
2019-07-09	AAIC.C-DELISTED	Stock	21.7344	21.93	21.7344	21.775	8766.0
2019-07-09	AAL	Stock	32.4	32.75	31.93	32.36	5450600.0
2019-07-09	AAM.A-DELISTED	Stock	25.71	25.87	25.71	25.86	21665.0
2019-07-09	AAM.B-DELISTED	Stock	25.96	25.99	25.89	25.99	18680.0
2019-07-09	AAMC-DELISTED	Stock	4.0647	4.0647	3.7676	3.7676	8354.0
2019-07-09	AAMI	Stock	11.86	11.97	11.66	11.95	500600.0
2019-07-09	AAOI	Stock	10.11	11.18	9.89	10.85	2767700.0
2019-07-09	AAON	Stock	33.1533	33.4667	32.9867	33.4267	116400.0
2019-07-09	AAP	Stock	157.77	158.88	154.03	155.5	1040700.0
2019-07-09	AAT	Stock	47.71	48.06	47.5	47.88	369600.0
2019-07-09	AAU-DELISTED	Stock	0.6	0.6325	0.5902	0.6325	76675.0
2019-07-09	AAUAF-DELISTED	Stock	0.6	0.6325	0.5902	0.6325	79135.0
2019-07-09	AAWW-DELISTED	Stock	42.08	42.43	41.145	41.69	184585.0
2019-07-09	AAXJ	Stock	68.55	68.97	68.54	68.89	1780346.0
2019-07-09	AAXN-DELISTED	Stock	62.1	63.11	61.7	62.96	670397.0
2019-07-09	AB	Stock	30.17	30.36	29.97	30.08	237200.0
2019-07-09	ABB-DELISTED	Stock	18.79	18.87	18.68	18.695	3195739.0
2019-07-09	ABBNY-DELISTED	Stock	18.79	18.87	18.68	18.69	3315953.0
2019-07-09	ABBV	Stock	71.18	72.45	70.89	71.24	11832500.0
2019-07-09	ABC-DELISTED	Stock	87.42	88.75	87.17	88.25	860566.0
2019-07-09	ABCB	Stock	38.54	38.88	38.34	38.84	404000.0
2019-07-09	ABDC-DELISTED	Stock	8.35	8.39	8.29	8.36	13816.0
2019-07-09	ABEO	Stock	110.75	111.0	107.5	109.0	17164.0
2019-07-09	ABEV	Stock	4.91	4.99	4.9	4.96	14064600.0
2019-07-09	ABG	Stock	83.47	84.77	82.68	84.49	116300.0
2019-07-09	ABIL-DELISTED	Stock	0.91	0.9304	0.871	0.91	63128.0
2019-07-09	ABM	Stock	40.46	40.63	40.21	40.41	156100.0
2019-07-09	ABMD-DELISTED	Stock	256.11	258.97	253.45	257.26	262534.0
2019-07-09	ABR	Stock	12.4	12.43	12.29	12.31	1478000.0
2019-07-09	ABR.A-DELISTED	Stock	26.1795	26.1829	26.1795	26.1829	750.0
2019-07-09	ABR.B-DELISTED	Stock	25.9793	25.9793	25.935	25.95	1713.0
2019-07-09	ABR.C-DELISTED	Stock	26.1538	26.25	26.0914	26.15	2611.0
2019-07-09	ABT	Stock	84.96	85.37	84.82	85.27	3126000.0
2019-07-09	ABTC	Stock	452400.0	469200.0	436500.0	446400.0	12.066666666666666

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

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