PREVIEW / stock_daily / 2018-07-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-05.parquet
  size:    218 KB
  rows:    6,512
  symbols: 2,788

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-05	AAPL	Stock	46.315	46.6025	46.07	46.35	66416800.0
2018-07-05	MSFT	Stock	99.5	99.92	99.03	99.76	18977400.0
2018-07-05	NVDA	Stock	5.9768	6.0733	5.9375	6.0682	306216000.0
2018-07-05	AMZN	Stock	85.269	85.5345	84.1075	84.9865	59662000.0
2018-07-05	GOOGL	Stock	56.23	57.207	56.156	57.0645	28594200.0
2018-07-05	META	Stock	194.74	198.65	194.03	198.45	19684200.0
2018-07-05	TSLA	Stock	20.9173	20.9593	19.748	20.6107	262146000.0
2018-07-05	TLT	Stock	122.06	122.53	122.01	122.35	3860359.0
2018-07-05	ES	Stock	59.61	59.76	59.15	59.72	2330800.0
2018-07-05	CL	Stock	64.94	65.97	64.94	65.96	3670200.0
2018-07-05	A	Stock	61.48	61.89	60.91	61.8	2247500.0
2018-07-05	AA	Stock	46.26	47.5	46.17	46.88	2251000.0
2018-07-05	AABA-DELISTED	Stock	73.48	73.49	71.81	73.35	10365974.0
2018-07-05	AAC-DELISTED	Stock	9.83	9.9	9.63	9.82	58353.0
2018-07-05	AACG	Stock	4.48	4.57	4.1	4.26	19800.0
2018-07-05	AAIC-DELISTED	Stock	10.4	10.45	10.32	10.37	476341.0
2018-07-05	AAL	Stock	37.85	38.18	37.52	37.99	6181500.0
2018-07-05	AAM.A-DELISTED	Stock	25.6669	25.74	25.62	25.72	17575.0
2018-07-05	AAM.B-DELISTED	Stock	25.09	25.09	24.96	25.0	46698.0
2018-07-05	AAMC-DELISTED	Stock	19.4118	20.9324	18.5603	19.9706	15368.0
2018-07-05	AAME	Stock	2.58	2.58	2.58	2.58	1200.0
2018-07-05	AAMI	Stock	14.55	14.64	14.41	14.64	496500.0
2018-07-05	AAOI	Stock	46.12	46.9	44.38	46.0	824400.0
2018-07-05	AAON	Stock	23.0667	23.5	22.9	23.5	329250.0
2018-07-05	AAP	Stock	135.44	135.9	134.0	135.86	957000.0
2018-07-05	AAT	Stock	38.61	38.87	38.37	38.86	254400.0
2018-07-05	AAU-DELISTED	Stock	0.73	0.73	0.7	0.71	118875.0
2018-07-05	AAUAF-DELISTED	Stock	0.73	0.73	0.7	0.71	175013.0
2018-07-05	AAV-DELISTED	Stock	3.15	3.2	3.075	3.125	95619.0
2018-07-05	AAWW-DELISTED	Stock	72.1	72.3	70.65	71.5	228404.0
2018-07-05	AAXJ	Stock	70.68	70.73	69.98	70.25	3044848.0
2018-07-05	AAXN-DELISTED	Stock	64.69	65.0	63.7	64.97	528949.0
2018-07-05	AB	Stock	28.65	29.05	28.5	28.75	210900.0
2018-07-05	ABAC-DELISTED	Stock	2.57	2.7989	2.5101	2.5537	9856.0
2018-07-05	ABAX-DELISTED	Stock	82.97	83.27	82.91	83.21	306402.0
2018-07-05	ABB-DELISTED	Stock	21.43	21.5264	21.32	21.48	1458719.0
2018-07-05	ABBNY-DELISTED	Stock	21.43	21.5264	21.32	21.48	1527939.0
2018-07-05	ABBV	Stock	94.46	95.06	93.95	94.48	4744000.0
2018-07-05	ABC-DELISTED	Stock	86.36	87.27	85.9	87.21	745542.0
2018-07-05	ABCB	Stock	53.2	53.45	52.6	53.1	660400.0
2018-07-05	ABCD-DELISTED	Stock	11.9	12.18	11.7	12.04	139291.0
2018-07-05	ABDC-DELISTED	Stock	6.72	6.72	6.47	6.53	34125.0
2018-07-05	ABEO	Stock	402.5	408.75	400.0	405.0	17156.0
2018-07-05	ABEV	Stock	4.65	4.72	4.61	4.72	38317700.0
2018-07-05	ABG	Stock	70.2	70.75	69.0	70.4	197700.0
2018-07-05	ABIL-DELISTED	Stock	6.5	10.0	6.473	7.98	2167580.0
2018-07-05	ABM	Stock	29.76	30.07	29.46	30.02	804800.0
2018-07-05	ABMD-DELISTED	Stock	410.2	411.4025	392.2	400.65	680181.0
2018-07-05	ABR	Stock	10.61	10.66	10.57	10.66	650900.0
2018-07-05	ABR.A-DELISTED	Stock	26.05	26.059	25.83	25.87	2856.0

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

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