PREVIEW / stock_daily / 2018-08-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-16.parquet
  size:    219 KB
  rows:    6,500
  symbols: 2,751

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-08-16	AAPL	Stock	52.9375	53.4525	52.8675	53.33	114001600.0
2018-08-16	MSFT	Stock	108.3	108.86	107.3	107.64	21384300.0
2018-08-16	NVDA	Stock	6.5475	6.55	6.3752	6.436	801260000.0
2018-08-16	AMZN	Stock	95.197	95.25	94.1775	94.326	79142000.0
2018-08-16	GOOGL	Stock	62.0995	62.1849	60.9815	61.203	32175980.0
2018-08-16	META	Stock	180.42	180.5	174.01	174.7	31351800.0
2018-08-16	TSLA	Stock	22.6607	22.8187	22.2547	22.3633	90960000.0
2018-08-16	TLT	Stock	120.81	120.93	120.28	120.83	5400385.0
2018-08-16	ES	Stock	62.29	63.0	62.1	62.99	1773600.0
2018-08-16	CL	Stock	66.06	66.86	66.06	66.72	3163000.0
2018-08-16	A	Stock	65.04	65.67	64.81	65.5	3149500.0
2018-08-16	AA	Stock	41.25	42.24	41.25	41.45	3398900.0
2018-08-16	AABA-DELISTED	Stock	67.94	69.45	67.93	68.19	8448072.0
2018-08-16	AAC-DELISTED	Stock	9.93	10.475	9.905	10.16	402753.0
2018-08-16	AACG	Stock	6.75	6.87	6.75	6.87	131600.0
2018-08-16	AAIC-DELISTED	Stock	10.14	10.16	10.07	10.15	368149.0
2018-08-16	AAL	Stock	37.75	38.46	37.44	38.16	5876500.0
2018-08-16	AAM.A-DELISTED	Stock	25.5	25.57	25.48	25.569	10544.0
2018-08-16	AAM.B-DELISTED	Stock	25.1381	25.26	25.115	25.2501	36847.0
2018-08-16	AAMC-DELISTED	Stock	18.9265	19.0882	18.9265	19.0882	1027.0
2018-08-16	AAME	Stock	2.83	2.83	2.57	2.65	1400.0
2018-08-16	AAMI	Stock	12.56	12.88	12.56	12.58	690000.0
2018-08-16	AAOI	Stock	41.51	41.85	39.37	39.58	1275100.0
2018-08-16	AAON	Stock	26.6667	27.1667	26.6333	26.8333	184800.0
2018-08-16	AAP	Stock	158.5	160.63	158.5	159.49	1415900.0
2018-08-16	AAT	Stock	38.91	39.15	38.9	39.05	110500.0
2018-08-16	AAU-DELISTED	Stock	0.6	0.62	0.56	0.6046	192482.0
2018-08-16	AAUAF-DELISTED	Stock	0.6	0.62	0.56	0.6046	200560.0
2018-08-16	AAV-DELISTED	Stock	2.9	2.95	2.85	2.95	46162.0
2018-08-16	AAWW-DELISTED	Stock	58.55	60.2	58.4	59.875	126379.0
2018-08-16	AAXJ	Stock	68.97	69.49	68.97	69.1	426465.0
2018-08-16	AAXN-DELISTED	Stock	61.49	62.77	61.14	62.68	467715.0
2018-08-16	AB	Stock	29.75	30.1	29.75	29.9	298100.0
2018-08-16	ABAC-DELISTED	Stock	2.01	2.01	1.6701	1.89	14847.0
2018-08-16	ABB-DELISTED	Stock	22.28	22.42	22.2634	22.29	1548888.0
2018-08-16	ABBNY-DELISTED	Stock	22.28	22.42	22.2634	22.3	1722751.0
2018-08-16	ABBV	Stock	97.84	98.65	97.06	98.22	6332900.0
2018-08-16	ABC-DELISTED	Stock	85.98	87.29	84.77	86.82	1569392.0
2018-08-16	ABCB	Stock	48.9	49.65	48.9	49.35	244700.0
2018-08-16	ABCD-DELISTED	Stock	12.92	13.6	12.92	13.19	316136.0
2018-08-16	ABDC-DELISTED	Stock	6.24	6.32	6.2256	6.31	28105.0
2018-08-16	ABEO	Stock	327.5	347.5	321.25	342.5	25708.0
2018-08-16	ABEV	Stock	5.0	5.01	4.85	4.86	30397700.0
2018-08-16	ABG	Stock	75.4	75.65	74.25	74.4	181400.0
2018-08-16	ABIL-DELISTED	Stock	5.0	5.0	4.5	4.67	254967.0
2018-08-16	ABM	Stock	31.32	31.58	31.29	31.47	380000.0
2018-08-16	ABMD-DELISTED	Stock	364.92	369.51	357.4417	368.98	317909.0
2018-08-16	ABR	Stock	11.39	11.56	11.37	11.53	1714200.0
2018-08-16	ABR.A-DELISTED	Stock	25.6	25.6	25.5701	25.5701	1700.0
2018-08-16	ABR.B-DELISTED	Stock	25.4001	25.4387	25.4001	25.41	753.0

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

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