PREVIEW / stock_daily / 2016-05-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-03.parquet
  size:    219 KB
  rows:    6,544
  symbols: 3,291

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-03	AAPL	Stock	23.55	23.935	23.42	23.795	227325200.0
2016-05-03	MSFT	Stock	50.34	50.41	49.6	49.78	26460200.0
2016-05-03	NVDA	Stock	0.8898	0.8935	0.8815	0.8893	224024000.0
2016-05-03	AMZN	Stock	33.868	34.015	33.5215	33.566	98468000.0
2016-05-03	GOOGL	Stock	35.625	35.6685	35.3665	35.422	38620800.0
2016-05-03	META	Stock	117.52	118.16	117.02	117.43	24117500.0
2016-05-03	TSLA	Stock	15.824	15.9273	15.4413	15.488	64533000.0
2016-05-03	TLT	Stock	129.55	130.02	129.35	129.43	10736651.0
2016-05-03	ES	Stock	57.08	57.25	56.63	56.97	1128800.0
2016-05-03	CL	Stock	72.0	72.45	71.61	71.85	3671900.0
2016-05-03	A	Stock	41.32	41.49	40.91	41.24	1334000.0
2016-05-03	AA.B-DELISTED	Stock	36.7	37.21	35.54	35.58	77857.0
2016-05-03	AAAP-DELISTED	Stock	33.93	34.91	33.93	34.33	20956.0
2016-05-03	AABA-DELISTED	Stock	36.25	36.41	35.91	36.01	8150237.0
2016-05-03	AAC-DELISTED	Stock	19.84	20.56	19.6	20.38	73890.0
2016-05-03	AACG	Stock	5.5	5.73	5.46	5.48	8900.0
2016-05-03	AAIC-DELISTED	Stock	12.75	12.79	12.37	12.53	251857.0
2016-05-03	AAL	Stock	34.76	34.77	33.85	34.58	10674200.0
2016-05-03	AAMC-DELISTED	Stock	4.5559	4.7029	3.8853	4.4941	101082.0
2016-05-03	AAME	Stock	3.84	4.12	3.78	4.12	900.0
2016-05-03	AAMI	Stock	13.61	13.73	13.19	13.67	193400.0
2016-05-03	AAOI	Stock	11.04	11.215	10.56	10.65	445600.0
2016-05-03	AAON	Stock	17.7533	17.86	17.4133	17.4667	161850.0
2016-05-03	AAP	Stock	155.23	156.97	153.91	156.01	529400.0
2016-05-03	AAT	Stock	40.6	41.17	40.48	41.03	198800.0
2016-05-03	AAU-DELISTED	Stock	1.1	1.12	1.03	1.05	434596.0
2016-05-03	AAUAF-DELISTED	Stock	1.1	1.12	1.03	1.05	436056.0
2016-05-03	AAV-DELISTED	Stock	5.55	5.55	5.27	5.28	88274.0
2016-05-03	AAVL-DELISTED	Stock	5.62	5.675	5.36	5.37	182606.0
2016-05-03	AAWW-DELISTED	Stock	40.52	41.06	38.82	39.0597	249251.0
2016-05-03	AAXJ	Stock	53.25	53.37	52.795	52.83	768534.0
2016-05-03	AAXN-DELISTED	Stock	18.28	18.37	17.57	17.805	737890.0
2016-05-03	AB	Stock	23.03	23.66	22.75	22.9	349000.0
2016-05-03	ABAC-DELISTED	Stock	0.648	0.7138	0.62	0.6801	17057.0
2016-05-03	ABAX-DELISTED	Stock	44.15	45.11	44.1	44.24	123882.0
2016-05-03	ABB-DELISTED	Stock	21.15	21.16	20.97	21.01	2317658.0
2016-05-03	ABBNY-DELISTED	Stock	21.15	21.16	20.97	21.02	2401592.0
2016-05-03	ABBV	Stock	60.99	62.09	60.72	61.77	9316600.0
2016-05-03	ABC-DELISTED	Stock	84.93	86.07	84.43	85.48	1741116.0
2016-05-03	ABCB	Stock	31.16	31.3	30.63	30.84	226000.0
2016-05-03	ABCD-DELISTED	Stock	4.6899	4.6899	4.51	4.54	9720.0
2016-05-03	ABCO-DELISTED	Stock	31.62	31.98	30.33	30.48	440146.0
2016-05-03	ABDC-DELISTED	Stock	11.47	11.47	11.362	11.37	14110.0
2016-05-03	ABE-DELISTED	Stock	11.97	11.98	11.92	11.93	2631.0
2016-05-03	ABEO	Stock	66.5	66.5	63.25	65.5	1364.0
2016-05-03	ABEV	Stock	5.4	5.5	5.37	5.45	16549800.0
2016-05-03	ABG	Stock	58.84	59.21	57.21	58.12	443200.0
2016-05-03	ABIL-DELISTED	Stock	5.0	5.0	4.37	4.57	151137.0
2016-05-03	ABM	Stock	32.33	32.52	32.17	32.42	222500.0
2016-05-03	ABMD-DELISTED	Stock	101.06	101.4	96.39	98.96	1495553.0

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

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