PREVIEW / stock_daily / 2018-07-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-16.parquet
  size:    218 KB
  rows:    6,493
  symbols: 2,765

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
2018-07-16	AAPL	Stock	47.88	48.1625	47.605	47.7275	60172400.0
2018-07-16	MSFT	Stock	105.4	105.82	104.52	104.91	21786900.0
2018-07-16	NVDA	Stock	6.205	6.2585	6.1925	6.205	197036000.0
2018-07-16	AMZN	Stock	91.0975	92.0975	90.7225	91.1245	109324000.0
2018-07-16	GOOGL	Stock	60.1905	60.4355	59.6701	59.8255	26784740.0
2018-07-16	META	Stock	207.5	208.72	206.84	207.23	11078200.0
2018-07-16	TSLA	Stock	20.7807	21.0107	20.4167	20.6733	117280500.0
2018-07-16	TLT	Stock	122.21	122.285	121.639	122.21	5517099.0
2018-07-16	ES	Stock	59.18	59.3	58.67	59.04	2393900.0
2018-07-16	CL	Stock	65.58	65.66	65.1	65.62	2409100.0
2018-07-16	A	Stock	63.23	63.23	62.63	62.72	929300.0
2018-07-16	AA	Stock	47.54	48.08	46.76	47.41	2714100.0
2018-07-16	AABA-DELISTED	Stock	74.31	74.89	74.08	74.64	5612166.0
2018-07-16	AAC-DELISTED	Stock	10.08	10.15	9.655	9.74	50775.0
2018-07-16	AACG	Stock	4.6	4.6	4.25	4.6	6400.0
2018-07-16	AAIC-DELISTED	Stock	10.21	10.27	10.15	10.16	406614.0
2018-07-16	AAL	Stock	37.26	37.58	36.93	37.28	5358400.0
2018-07-16	AAM.A-DELISTED	Stock	25.7	25.73	25.6	25.61	15157.0
2018-07-16	AAM.B-DELISTED	Stock	25.042	25.06	24.81	24.925	89723.0
2018-07-16	AAMC-DELISTED	Stock	18.8824	18.8824	18.8824	18.8824	1408.0
2018-07-16	AAME	Stock	2.44	2.44	2.43	2.43	700.0
2018-07-16	AAMI	Stock	13.59	13.78	13.46	13.75	762500.0
2018-07-16	AAOI	Stock	47.43	49.069	47.01	48.67	1103300.0
2018-07-16	AAON	Stock	23.8333	23.8667	23.6	23.8	197100.0
2018-07-16	AAP	Stock	139.67	140.54	139.02	139.67	505100.0
2018-07-16	AAT	Stock	38.11	38.11	37.72	37.91	209500.0
2018-07-16	AAU-DELISTED	Stock	0.7099	0.71	0.6935	0.7003	80094.0
2018-07-16	AAUAF-DELISTED	Stock	0.7099	0.71	0.6935	0.7003	85944.0
2018-07-16	AAV-DELISTED	Stock	3.2	3.24	3.1	3.15	101505.0
2018-07-16	AAWW-DELISTED	Stock	70.25	71.2	68.15	68.35	225084.0
2018-07-16	AAXJ	Stock	71.61	71.68	71.43	71.59	422593.0
2018-07-16	AAXN-DELISTED	Stock	67.79	69.18	67.79	69.02	455996.0
2018-07-16	AB	Stock	28.95	29.4	28.9	29.3	149800.0
2018-07-16	ABAC-DELISTED	Stock	2.37	2.3799	2.26	2.31	8322.0
2018-07-16	ABAX-DELISTED	Stock	83.25	83.34	83.25	83.29	45541.0
2018-07-16	ABB-DELISTED	Stock	21.88	21.92	21.72	21.83	2090618.0
2018-07-16	ABBNY-DELISTED	Stock	21.88	21.92	21.72	21.83	2155780.0
2018-07-16	ABBV	Stock	96.76	96.82	95.26	96.25	3783500.0
2018-07-16	ABC-DELISTED	Stock	88.24	88.24	86.78	86.89	832955.0
2018-07-16	ABCB	Stock	51.25	51.95	51.05	51.35	273300.0
2018-07-16	ABCD-DELISTED	Stock	11.67	11.67	11.4	11.46	68490.0
2018-07-16	ABDC-DELISTED	Stock	6.13	6.2	6.05	6.18	34644.0
2018-07-16	ABEO	Stock	366.25	368.75	355.0	355.0	19084.0
2018-07-16	ABEV	Stock	4.8	4.93	4.79	4.92	34188500.0
2018-07-16	ABG	Stock	67.65	68.1	66.4	67.8	339300.0
2018-07-16	ABIL-DELISTED	Stock	5.73	5.73	4.67	5.0473	346042.0
2018-07-16	ABM	Stock	31.39	31.4	29.99	30.15	1154900.0
2018-07-16	ABMD-DELISTED	Stock	419.33	421.76	417.06	419.33	430594.0
2018-07-16	ABR	Stock	10.9	10.94	10.85	10.9	1088800.0
2018-07-16	ABR.A-DELISTED	Stock	26.1	26.1	26.0	26.0	1500.0

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

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