PREVIEW / stock_daily / 2018-07-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-09.parquet
  size:    219 KB
  rows:    6,528
  symbols: 2,794

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-09	AAPL	Stock	47.375	47.67	47.325	47.645	79026400.0
2018-07-09	MSFT	Stock	101.65	102.25	101.25	101.85	18212000.0
2018-07-09	NVDA	Stock	6.2582	6.268	6.1518	6.2312	303880000.0
2018-07-09	AMZN	Stock	86.2025	86.978	85.8115	86.951	60240000.0
2018-07-09	GOOGL	Stock	58.0	58.3965	57.8617	58.364	21584020.0
2018-07-09	META	Stock	204.93	205.8	202.12	204.74	18149400.0
2018-07-09	TSLA	Stock	20.7993	21.2347	20.5333	21.234	113952000.0
2018-07-09	TLT	Stock	122.07	122.21	121.9	121.96	5952743.0
2018-07-09	ES	Stock	60.61	60.68	58.24	58.46	2145900.0
2018-07-09	CL	Stock	65.45	65.57	64.95	65.0	4102300.0
2018-07-09	A	Stock	62.43	63.32	62.43	63.12	1508600.0
2018-07-09	AA	Stock	47.94	48.56	47.57	48.29	2370200.0
2018-07-09	AABA-DELISTED	Stock	76.0	76.34	74.91	75.62	7246883.0
2018-07-09	AAC-DELISTED	Stock	9.5	9.78	9.46	9.57	74511.0
2018-07-09	AACG	Stock	4.11	4.41	4.07	4.4	3800.0
2018-07-09	AAIC-DELISTED	Stock	10.5	10.5	10.35	10.37	468390.0
2018-07-09	AAL	Stock	38.21	39.41	38.07	39.31	4530400.0
2018-07-09	AAM.A-DELISTED	Stock	25.8	25.84	25.71	25.71	25133.0
2018-07-09	AAM.B-DELISTED	Stock	24.98	25.059	24.87	24.95	115620.0
2018-07-09	AAMC-DELISTED	Stock	20.0	20.0147	20.0	20.0147	1139.0
2018-07-09	AAME	Stock	2.6	2.6	2.35	2.35	11400.0
2018-07-09	AAMI	Stock	14.52	14.7	14.51	14.65	298300.0
2018-07-09	AAOI	Stock	45.4	47.11	44.37	45.33	1007800.0
2018-07-09	AAON	Stock	23.6667	23.8333	23.4667	23.7667	267900.0
2018-07-09	AAP	Stock	137.59	141.58	137.47	140.95	950800.0
2018-07-09	AAT	Stock	38.77	38.9	38.27	38.49	414000.0
2018-07-09	AAU-DELISTED	Stock	0.72	0.735	0.72	0.7302	154829.0
2018-07-09	AAUAF-DELISTED	Stock	0.72	0.735	0.72	0.73	186314.0
2018-07-09	AAV-DELISTED	Stock	3.15	3.2	3.1	3.15	65733.0
2018-07-09	AAWW-DELISTED	Stock	72.15	73.05	71.6	72.55	145348.0
2018-07-09	AAXJ	Stock	72.02	72.45	71.86	72.43	1113299.0
2018-07-09	AAXN-DELISTED	Stock	66.5	67.0	65.53	66.95	558353.0
2018-07-09	AB	Stock	29.25	29.45	29.1	29.4	158600.0
2018-07-09	ABAC-DELISTED	Stock	2.7742	2.7742	2.32	2.34	77615.0
2018-07-09	ABAX-DELISTED	Stock	83.24	83.3	83.18	83.23	202002.0
2018-07-09	ABB-DELISTED	Stock	21.68	21.94	21.67	21.91	3530822.0
2018-07-09	ABBNY-DELISTED	Stock	21.68	21.94	21.67	21.9	4164392.0
2018-07-09	ABBV	Stock	97.98	98.35	96.92	97.04	5953100.0
2018-07-09	ABC-DELISTED	Stock	88.3	89.55	87.97	88.26	1271861.0
2018-07-09	ABCB	Stock	53.55	54.15	53.4	53.45	731900.0
2018-07-09	ABCD-DELISTED	Stock	12.07	12.08	11.72	11.9	113863.0
2018-07-09	ABDC-DELISTED	Stock	6.6	6.6	6.2	6.36	83241.0
2018-07-09	ABEO	Stock	400.0	403.5	380.0	396.25	24424.0
2018-07-09	ABEV	Stock	4.69	4.73	4.64	4.67	26182400.0
2018-07-09	ABG	Stock	70.65	72.5	70.6	72.4	167400.0
2018-07-09	ABIL-DELISTED	Stock	7.48	7.5	6.7001	6.86	185905.0
2018-07-09	ABM	Stock	30.22	30.74	30.13	30.72	383700.0
2018-07-09	ABMD-DELISTED	Stock	407.88	413.855	403.16	408.4	456951.0
2018-07-09	ABR	Stock	10.94	11.0	10.82	10.85	2830300.0
2018-07-09	ABR.A-DELISTED	Stock	25.9	25.94	25.9	25.9162	2345.0

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

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