PREVIEW / stock_daily / 2016-04-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-07.parquet
  size:    217 KB
  rows:    6,537
  symbols: 3,310

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-04-07	AAPL	Stock	27.4875	27.605	27.03	27.135	127207600.0
2016-04-07	MSFT	Stock	54.87	54.91	54.23	54.46	19225100.0
2016-04-07	NVDA	Stock	0.8893	0.8973	0.882	0.8858	378104000.0
2016-04-07	AMZN	Stock	29.938	29.98	29.454	29.5715	63780000.0
2016-04-07	GOOGL	Stock	38.266	38.468	37.875	38.006	25497040.0
2016-04-07	META	Stock	113.79	114.89	113.07	113.64	20714500.0
2016-04-07	TSLA	Stock	17.7633	17.956	16.9673	17.1467	132843000.0
2016-04-07	TLT	Stock	132.19	132.99	132.015	132.85	5963282.0
2016-04-07	ES	Stock	56.76	57.33	56.54	56.8	1801500.0
2016-04-07	CL	Stock	70.9	70.95	70.28	70.64	2995100.0
2016-04-07	A	Stock	39.89	40.1	39.25	39.47	1373800.0
2016-04-07	AA.B-DELISTED	Stock	32.69	33.2564	32.43	32.65	17027.0
2016-04-07	AAAP-DELISTED	Stock	36.41	37.77	33.93	35.0001	107218.0
2016-04-07	AABA-DELISTED	Stock	35.86	37.25	35.72	36.18	37044743.0
2016-04-07	AAC-DELISTED	Stock	18.41	19.52	18.41	19.01	233279.0
2016-04-07	AACG	Stock	5.31	5.66	5.22	5.37	10700.0
2016-04-07	AAIC-DELISTED	Stock	12.08	12.29	12.06	12.15	175371.0
2016-04-07	AAL	Stock	38.66	39.05	37.91	38.36	8206700.0
2016-04-07	AAMC-DELISTED	Stock	4.8529	5.0441	4.7147	4.7471	53149.0
2016-04-07	AAME	Stock	4.86	4.86	4.78	4.83	900.0
2016-04-07	AAMI	Stock	12.88	12.95	12.69	12.77	120400.0
2016-04-07	AAOI	Stock	14.74	15.03	14.53	14.7	175600.0
2016-04-07	AAON	Stock	17.7333	18.1267	17.5067	17.5667	655800.0
2016-04-07	AAP	Stock	158.86	159.53	155.13	155.83	580900.0
2016-04-07	AAT	Stock	38.44	38.72	38.14	38.39	161100.0
2016-04-07	AAU-DELISTED	Stock	0.81	0.95	0.79	0.94	3036244.0
2016-04-07	AAUAF-DELISTED	Stock	0.81	0.95	0.79	0.94	3047315.0
2016-04-07	AAV-DELISTED	Stock	5.2	5.24	5.1	5.13	31207.0
2016-04-07	AAVL-DELISTED	Stock	5.46	5.5475	5.25	5.29	264903.0
2016-04-07	AAWW-DELISTED	Stock	38.73	39.18	38.03	38.38	154691.0
2016-04-07	AAXJ	Stock	53.08	53.15	52.595	52.69	949291.0
2016-04-07	AAXN-DELISTED	Stock	18.47	18.95	18.44	18.61	646872.0
2016-04-07	AB	Stock	23.87	23.93	23.12	23.36	312300.0
2016-04-07	ABAC-DELISTED	Stock	0.699	0.699	0.65	0.65	1130.0
2016-04-07	ABAX-DELISTED	Stock	44.37	44.81	43.785	44.1	157321.0
2016-04-07	ABB-DELISTED	Stock	19.04	19.13	18.93	18.975	1529305.0
2016-04-07	ABBNY-DELISTED	Stock	19.04	19.13	18.93	18.98	1570318.0
2016-04-07	ABBV	Stock	59.42	59.9	58.76	59.3	7827600.0
2016-04-07	ABC-DELISTED	Stock	87.3	88.0	86.6	86.66	2016836.0
2016-04-07	ABCB	Stock	28.38	28.59	27.73	27.89	230500.0
2016-04-07	ABCD-DELISTED	Stock	4.1	4.17	4.05	4.05	10348.0
2016-04-07	ABCO-DELISTED	Stock	32.55	32.775	31.76	32.01	531549.0
2016-04-07	ABCW-DELISTED	Stock	44.48	44.53	43.95	44.01	27191.0
2016-04-07	ABDC-DELISTED	Stock	11.97	12.0	11.36	11.49	34429.0
2016-04-07	ABE-DELISTED	Stock	11.544	11.6	11.1	11.51	17715.0
2016-04-07	ABEO	Stock	74.0	74.0	68.5	68.75	5156.0
2016-04-07	ABEOW-DELISTED	Stock	0.9453	0.9453	0.92	0.92	4804.0
2016-04-07	ABEV	Stock	5.05	5.08	4.96	5.01	10104600.0
2016-04-07	ABG	Stock	56.55	56.72	53.96	54.19	491000.0
2016-04-07	ABGB-DELISTED	Stock	1.48	1.48	1.4201	1.44	25575.0

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

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