PREVIEW / stock_daily / 2016-07-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-12.parquet
  size:    220 KB
  rows:    6,562
  symbols: 3,256

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-07-12	AAPL	Stock	24.2925	24.425	24.28	24.355	96670000.0
2016-07-12	MSFT	Stock	52.94	53.4	52.79	53.21	27317600.0
2016-07-12	NVDA	Stock	1.315	1.332	1.2985	1.32	436760000.0
2016-07-12	AMZN	Stock	37.843	37.867	37.0165	37.4105	112474000.0
2016-07-12	GOOGL	Stock	36.596	36.78	36.375	36.6255	26573600.0
2016-07-12	META	Stock	118.63	118.72	117.57	117.93	15217700.0
2016-07-12	TSLA	Stock	14.94	15.1667	14.8813	14.9767	68569500.0
2016-07-12	TLT	Stock	140.42	140.86	139.64	140.0	15810639.0
2016-07-12	ES	Stock	58.98	59.05	57.85	57.88	2097300.0
2016-07-12	CL	Stock	74.26	74.4	73.72	73.95	3909900.0
2016-07-12	A	Stock	45.77	46.66	45.64	46.53	2237700.0
2016-07-12	AA.B-DELISTED	Stock	36.51	36.87	35.85	36.55	91888.0
2016-07-12	AAAP-DELISTED	Stock	30.72	31.17	30.69	31.15	21345.0
2016-07-12	AABA-DELISTED	Stock	38.0	38.33	37.87	37.88	14549936.0
2016-07-12	AAC-DELISTED	Stock	22.77	22.77	22.25	22.39	97075.0
2016-07-12	AACG	Stock	4.67	4.67	4.01	4.2	9300.0
2016-07-12	AAIC-DELISTED	Stock	13.25	13.34	13.18	13.25	298315.0
2016-07-12	AAL	Stock	32.78	34.89	32.75	34.66	25515700.0
2016-07-12	AAMC-DELISTED	Stock	4.2559	4.4029	4.0147	4.0706	100779.0
2016-07-12	AAMI	Stock	13.69	13.94	13.685	13.87	168500.0
2016-07-12	AAOI	Stock	11.24	11.6	10.78	11.56	343300.0
2016-07-12	AAON	Stock	18.6733	18.9333	18.0067	18.7867	162150.0
2016-07-12	AAP	Stock	164.5	164.92	162.55	163.55	860200.0
2016-07-12	AAT	Stock	43.62	43.73	43.04	43.67	163600.0
2016-07-12	AAU-DELISTED	Stock	1.5	1.5042	1.43	1.4499	509653.0
2016-07-12	AAUAF-DELISTED	Stock	1.5	1.5042	1.43	1.4499	512083.0
2016-07-12	AAV-DELISTED	Stock	5.78	5.93	5.75	5.86	80249.0
2016-07-12	AAWW-DELISTED	Stock	42.04	43.01	41.54	42.8	101030.0
2016-07-12	AAXJ	Stock	56.05	56.385	56.01	56.25	947001.0
2016-07-12	AAXN-DELISTED	Stock	28.02	28.18	26.39	27.0	2048514.0
2016-07-12	AB	Stock	23.9	23.98	23.44	23.53	189200.0
2016-07-12	ABAC-DELISTED	Stock	0.785	0.821	0.75	0.7736	12941.0
2016-07-12	ABAX-DELISTED	Stock	52.11	52.59	51.87	52.52	141275.0
2016-07-12	ABB-DELISTED	Stock	19.51	19.59	19.49	19.52	2199299.0
2016-07-12	ABBNY-DELISTED	Stock	19.51	19.59	19.49	19.53	2246350.0
2016-07-12	ABBV	Stock	64.67	65.81	64.32	65.5	11870500.0
2016-07-12	ABC-DELISTED	Stock	82.25	84.41	82.24	84.15	2521603.0
2016-07-12	ABCB	Stock	30.05	30.76	30.05	30.52	149800.0
2016-07-12	ABCD-DELISTED	Stock	4.81	4.99	4.81	4.94	11483.0
2016-07-12	ABCO-DELISTED	Stock	38.66	39.73	38.66	39.16	234323.0
2016-07-12	ABDC-DELISTED	Stock	12.35	12.41	12.29	12.39	29884.0
2016-07-12	ABE-DELISTED	Stock	12.45	12.5499	12.45	12.54	9362.0
2016-07-12	ABEO	Stock	59.25	62.25	59.25	61.0	3124.0
2016-07-12	ABEOW-DELISTED	Stock	1.05	1.11	1.05	1.11	3854.0
2016-07-12	ABEV	Stock	5.85	5.91	5.82	5.83	7199500.0
2016-07-12	ABG	Stock	56.62	57.32	56.34	56.69	225000.0
2016-07-12	ABIL-DELISTED	Stock	4.44	4.48	4.33	4.44	81895.0
2016-07-12	ABM	Stock	37.25	37.54	36.86	37.25	209600.0
2016-07-12	ABMD-DELISTED	Stock	116.17	118.207	116.0	117.76	694338.0
2016-07-12	ABR	Stock	7.18	7.25	7.15	7.25	124600.0

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

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