PREVIEW / stock_daily / 2018-02-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-12.parquet
  size:    217 KB
  rows:    6,500
  symbols: 2,869

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-02-12	AAPL	Stock	39.625	40.9725	39.3775	40.6775	243278000.0
2018-02-12	MSFT	Stock	88.74	89.78	87.93	89.13	35720300.0
2018-02-12	NVDA	Stock	5.884	5.887	5.6258	5.7008	1093172000.0
2018-02-12	AMZN	Stock	68.2335	69.6905	67.2005	69.3115	134778000.0
2018-02-12	GOOGL	Stock	52.8335	53.2785	52.2745	52.728	56240220.0
2018-02-12	META	Stock	177.06	177.55	171.84	176.41	32092100.0
2018-02-12	TSLA	Stock	21.0753	21.2053	20.4167	21.0487	93417000.0
2018-02-12	TLT	Stock	118.56	119.3	118.19	118.46	10944598.0
2018-02-12	ES	Stock	57.08	57.86	56.51	57.53	2176600.0
2018-02-12	CL	Stock	70.01	70.87	69.74	70.19	3457600.0
2018-02-12	A	Stock	67.46	69.05	67.37	68.43	4227600.0
2018-02-12	AA	Stock	46.05	47.13	45.77	46.65	3495900.0
2018-02-12	AABA-DELISTED	Stock	71.19	71.78	70.27	71.1	2174900.0
2018-02-12	AAC-DELISTED	Stock	8.12	8.22	7.91	8.08	65940.0
2018-02-12	AACG	Stock	5.87	5.94	5.5	5.67	5200.0
2018-02-12	AAIC-DELISTED	Stock	10.54	10.73	10.43	10.68	742241.0
2018-02-12	AAL	Stock	48.79	50.51	48.65	50.09	5437800.0
2018-02-12	AAM.A-DELISTED	Stock	25.56	25.56	25.11	25.24	111513.0
2018-02-12	AAMC-DELISTED	Stock	19.7647	19.7647	19.7647	19.7647	1102.0
2018-02-12	AAME	Stock	3.25	3.25	3.25	3.25	200.0
2018-02-12	AAMI	Stock	15.45	15.703	15.4	15.51	1459700.0
2018-02-12	AAOI	Stock	30.77	31.048	28.97	30.25	1524200.0
2018-02-12	AAON	Stock	22.2	22.5667	22.0	22.4333	258600.0
2018-02-12	AAP	Stock	109.8	110.8	108.05	109.48	1181400.0
2018-02-12	AAT	Stock	32.96	32.96	31.46	32.62	180600.0
2018-02-12	AAU-DELISTED	Stock	0.86	0.9149	0.85	0.9073	245806.0
2018-02-12	AAUAF-DELISTED	Stock	0.86	0.9149	0.85	0.9073	256970.0
2018-02-12	AAV-DELISTED	Stock	2.95	3.15	2.95	3.05	349361.0
2018-02-12	AAWW-DELISTED	Stock	52.0	53.75	51.4	53.5	254203.0
2018-02-12	AAXJ	Stock	75.13	75.72	74.58	75.32	1420110.0
2018-02-12	AAXN-DELISTED	Stock	25.4	25.8899	25.22	25.6	845348.0
2018-02-12	AB	Stock	25.0	25.55	24.9	25.4	289700.0
2018-02-12	ABAC-DELISTED	Stock	2.48	2.7179	2.48	2.7068	1226.0
2018-02-12	ABAX-DELISTED	Stock	65.42	67.97	64.57	65.52	214662.0
2018-02-12	ABB-DELISTED	Stock	24.5	24.71	24.38	24.6	2396349.0
2018-02-12	ABBNY-DELISTED	Stock	24.5	24.71	24.38	24.6	2530678.0
2018-02-12	ABBV	Stock	112.57	113.33	110.65	111.93	4823300.0
2018-02-12	ABC-DELISTED	Stock	89.85	91.54	88.755	89.44	1866223.0
2018-02-12	ABCB	Stock	52.75	53.1	51.9	52.6	116900.0
2018-02-12	ABCD-DELISTED	Stock	7.06	7.14	6.88	7.03	77927.0
2018-02-12	ABDC-DELISTED	Stock	7.52	7.53	7.41	7.52	27906.0
2018-02-12	ABE-DELISTED	Stock	14.56	14.85	14.5401	14.85	47935.0
2018-02-12	ABEO	Stock	361.25	363.75	313.75	315.0	105560.0
2018-02-12	ABEOW-DELISTED	Stock	9.0503	9.0503	8.0	8.63	53502.0
2018-02-12	ABEV	Stock	6.58	6.72	6.56	6.68	17760800.0
2018-02-12	ABG	Stock	69.3	70.6	68.0	69.15	197200.0
2018-02-12	ABIL-DELISTED	Stock	0.3916	0.41	0.355	0.41	108481.0
2018-02-12	ABLX-DELISTED	Stock	53.58	53.776	53.5	53.67	210015.0
2018-02-12	ABM	Stock	34.98	35.7	34.59	35.45	486800.0
2018-02-12	ABMD-DELISTED	Stock	232.15	235.4943	228.9892	233.88	289340.0

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

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