PREVIEW / stock_daily / 2016-02-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-02.parquet
  size:    218 KB
  rows:    6,609
  symbols: 3,354

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
2016-02-02	AAPL	Stock	23.855	24.01	23.57	23.62	149428800.0
2016-02-02	MSFT	Stock	54.17	54.26	52.65	53.0	56313800.0
2016-02-02	NVDA	Stock	0.725	0.7288	0.6965	0.7015	341908000.0
2016-02-02	AMZN	Stock	28.5	28.578	27.5045	27.605	126240000.0
2016-02-02	GOOGL	Stock	40.025	40.5175	39.03	39.0455	135846620.0
2016-02-02	META	Stock	114.8	117.59	113.2	114.61	59778600.0
2016-02-02	TSLA	Stock	12.828	12.8747	12.0153	12.1853	86604000.0
2016-02-02	TLT	Stock	128.1	129.04	128.0	129.02	10399965.0
2016-02-02	ES	Stock	54.27	55.23	54.03	55.08	1859500.0
2016-02-02	CL	Stock	65.62	66.08	65.17	65.36	3717000.0
2016-02-02	A	Stock	37.18	37.55	36.95	37.07	1742300.0
2016-02-02	AA.B-DELISTED	Stock	26.18	26.18	25.6	25.85	59456.0
2016-02-02	AAAP-DELISTED	Stock	25.35	26.03	23.86	24.85	52201.0
2016-02-02	AABA-DELISTED	Stock	29.36	30.23	28.13	29.06	35156357.0
2016-02-02	AAC-DELISTED	Stock	18.54	18.85	17.98	18.0	126716.0
2016-02-02	AACG	Stock	5.44	5.45	5.25	5.42	10300.0
2016-02-02	AAIC-DELISTED	Stock	11.06	11.09	10.67	10.81	228011.0
2016-02-02	AAL	Stock	38.83	38.97	37.0	37.03	12401400.0
2016-02-02	AAMC-DELISTED	Stock	4.5529	4.5529	4.3118	4.4029	63893.0
2016-02-02	AAME	Stock	4.49	4.5	4.49	4.49	1600.0
2016-02-02	AAMI	Stock	10.88	10.92	10.33	10.4	182700.0
2016-02-02	AAOI	Stock	15.65	15.8	15.26	15.41	278200.0
2016-02-02	AAON	Stock	13.9867	14.1933	13.8733	13.92	124800.0
2016-02-02	AAP	Stock	154.38	154.94	150.67	151.86	713100.0
2016-02-02	AAT	Stock	37.17	37.66	36.75	37.09	215800.0
2016-02-02	AAU-DELISTED	Stock	0.6575	0.6575	0.58	0.6	61204.0
2016-02-02	AAUAF-DELISTED	Stock	0.6575	0.6575	0.58	0.6	63424.0
2016-02-02	AAV-DELISTED	Stock	5.24	5.3	5.1	5.29	306597.0
2016-02-02	AAVL-DELISTED	Stock	5.05	5.21	4.75	4.82	432622.0
2016-02-02	AAWW-DELISTED	Stock	35.77	36.12	34.83	35.66	187018.0
2016-02-02	AAXJ	Stock	48.69	48.75	47.94	48.09	1034119.0
2016-02-02	AAXN-DELISTED	Stock	15.22	15.33	14.46	14.76	1440532.0
2016-02-02	AB	Stock	18.55	18.6	17.9	17.97	234200.0
2016-02-02	ABAC-DELISTED	Stock	0.6596	0.6596	0.6596	0.6596	553.0
2016-02-02	ABAX-DELISTED	Stock	43.14	44.11	42.73	43.16	288003.0
2016-02-02	ABB-DELISTED	Stock	16.85	16.99	16.72	16.77	3278776.0
2016-02-02	ABBNY-DELISTED	Stock	16.85	16.99	16.72	16.76	5517136.0
2016-02-02	ABBV	Stock	53.64	54.78	53.32	53.95	7918300.0
2016-02-02	ABC-DELISTED	Stock	88.6	89.89	87.95	88.15	2602154.0
2016-02-02	ABCB	Stock	28.25	28.5	28.14	28.3	206100.0
2016-02-02	ABCD-DELISTED	Stock	4.47	4.57	4.3901	4.4	35382.0
2016-02-02	ABCO-DELISTED	Stock	45.08	45.87	44.25	45.31	291412.0
2016-02-02	ABCW-DELISTED	Stock	42.17	42.2	41.59	41.93	74626.0
2016-02-02	ABDC-DELISTED	Stock	10.5	11.0	10.5	10.7	35954.0
2016-02-02	ABE-DELISTED	Stock	10.3	10.3	10.1986	10.2	4020.0
2016-02-02	ABEO	Stock	60.5	66.25	57.5	58.0	1436.0
2016-02-02	ABEOW-DELISTED	Stock	0.7	0.7	0.7	0.7	1100.0
2016-02-02	ABEV	Stock	4.56	4.57	4.43	4.43	19050700.0
2016-02-02	ABG	Stock	45.9	46.34	44.13	45.07	550400.0
2016-02-02	ABGB-DELISTED	Stock	0.97	0.9733	0.8554	0.918	20436.0

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

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