PREVIEW / stock_daily / 2016-05-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-04.parquet
  size:    218 KB
  rows:    6,537
  symbols: 3,281

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-05-04	AAPL	Stock	23.8	23.975	23.455	23.5475	164102000.0
2016-05-04	MSFT	Stock	49.84	50.06	49.46	49.87	24257600.0
2016-05-04	NVDA	Stock	0.8785	0.8792	0.86	0.869	525764000.0
2016-05-04	AMZN	Stock	33.1295	33.7	33.107	33.545	92710000.0
2016-05-04	GOOGL	Stock	35.3385	35.7525	35.2025	35.5685	34172180.0
2016-05-04	META	Stock	116.61	118.3	116.57	118.06	23448400.0
2016-05-04	TSLA	Stock	15.3527	15.6307	14.6933	14.8373	130507500.0
2016-05-04	TLT	Stock	129.68	130.17	129.19	130.14	7211166.0
2016-05-04	ES	Stock	57.0	58.06	56.83	57.51	1617700.0
2016-05-04	CL	Stock	71.55	72.0	71.11	71.88	3314800.0
2016-05-04	A	Stock	40.81	41.2	40.39	40.52	1603000.0
2016-05-04	AA.B-DELISTED	Stock	35.57	36.1399	35.26	35.55	29871.0
2016-05-04	AAAP-DELISTED	Stock	34.1799	34.88	33.8	34.77	9900.0
2016-05-04	AABA-DELISTED	Stock	35.81	36.09	35.74	36.0	9149904.0
2016-05-04	AAC-DELISTED	Stock	20.42	20.4799	19.44	19.59	103503.0
2016-05-04	AACG	Stock	5.52	5.61	5.47	5.49	2000.0
2016-05-04	AAIC-DELISTED	Stock	12.47	12.64	12.29	12.41	259738.0
2016-05-04	AAL	Stock	34.17	34.3	33.0	33.21	13412400.0
2016-05-04	AAMC-DELISTED	Stock	4.4118	4.4529	4.0647	4.0735	78632.0
2016-05-04	AAME	Stock	4.08	4.41	4.08	4.16	1900.0
2016-05-04	AAMI	Stock	13.5	13.63	13.09	13.19	412100.0
2016-05-04	AAOI	Stock	10.64	10.92	10.54	10.61	375300.0
2016-05-04	AAON	Stock	17.42	17.6467	16.98	17.1	430350.0
2016-05-04	AAP	Stock	154.26	156.3	153.69	155.84	356300.0
2016-05-04	AAT	Stock	40.91	41.94	40.91	41.75	213100.0
2016-05-04	AAU-DELISTED	Stock	1.03	1.11	1.0	1.09	868524.0
2016-05-04	AAUAF-DELISTED	Stock	1.03	1.11	1.0	1.09	870158.0
2016-05-04	AAV-DELISTED	Stock	5.25	5.34	5.13	5.33	94323.0
2016-05-04	AAVL-DELISTED	Stock	5.3	5.35	4.97	5.01	194856.0
2016-05-04	AAWW-DELISTED	Stock	38.89	39.96	38.23	38.39	254506.0
2016-05-04	AAXJ	Stock	52.63	52.665	52.1	52.17	742578.0
2016-05-04	AAXN-DELISTED	Stock	17.61	17.75	17.18	17.67	1376918.0
2016-05-04	AB	Stock	22.78	23.34	22.76	23.05	300300.0
2016-05-04	ABAC-DELISTED	Stock	0.7141	0.7142	0.62	0.68	2223.0
2016-05-04	ABAX-DELISTED	Stock	44.17	44.62	43.6	44.37	111617.0
2016-05-04	ABB-DELISTED	Stock	20.9	20.93	20.63	20.695	1715559.0
2016-05-04	ABBNY-DELISTED	Stock	20.89	20.93	20.63	20.69	1865931.0
2016-05-04	ABBV	Stock	61.3	61.65	61.01	61.46	8691400.0
2016-05-04	ABC-DELISTED	Stock	84.98	85.3	84.0	84.29	2033238.0
2016-05-04	ABCB	Stock	30.74	31.24	30.37	30.59	165300.0
2016-05-04	ABCD-DELISTED	Stock	4.551	4.6	4.49	4.49	13794.0
2016-05-04	ABCO-DELISTED	Stock	30.52	30.8175	29.95	30.43	481600.0
2016-05-04	ABDC-DELISTED	Stock	11.3	11.78	11.3	11.78	56852.0
2016-05-04	ABE-DELISTED	Stock	11.92	11.92	11.8401	11.85	6469.0
2016-05-04	ABEO	Stock	65.0	65.25	60.25	61.0	4000.0
2016-05-04	ABEV	Stock	5.4	5.51	5.37	5.48	13338700.0
2016-05-04	ABG	Stock	57.64	58.44	56.79	57.22	237100.0
2016-05-04	ABIL-DELISTED	Stock	4.58	4.6399	3.75	4.15	132715.0
2016-05-04	ABM	Stock	32.22	32.95	32.22	32.75	351900.0
2016-05-04	ABMD-DELISTED	Stock	98.92	99.35	94.41	94.89	693755.0

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

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