PREVIEW / stock_daily / 2015-06-04

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-04.parquet
  size:    224 KB
  rows:    6,644
  symbols: 3,498

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
2015-06-04	AAPL	Stock	32.395	32.645	32.2275	32.34	153800400.0
2015-06-04	MSFT	Stock	46.79	47.16	46.2	46.36	27745500.0
2015-06-04	NVDA	Stock	0.5392	0.554	0.5392	0.5522	323712000.0
2015-06-04	AMZN	Stock	21.72	21.838	21.463	21.539	50216000.0
2015-06-04	GOOGL	Stock	27.609	27.798	27.456	27.5845	26866340.0
2015-06-04	META	Stock	82.14	82.95	81.51	82.05	20863900.0
2015-06-04	TSLA	Stock	16.5	16.62	16.3807	16.3947	36804000.0
2015-06-04	TLT	Stock	118.26	119.29	118.14	119.05	10859277.0
2015-06-04	ES	Stock	47.4	47.87	47.32	47.44	734900.0
2015-06-04	CL	Stock	66.21	66.9	65.85	65.92	3280400.0
2015-06-04	A	Stock	40.89	41.08	40.01	40.54	4091900.0
2015-06-04	AA.B-DELISTED	Stock	44.73	44.9999	44.59	44.64	24534.0
2015-06-04	AABA-DELISTED	Stock	43.09	43.44	42.76	42.9	8596954.0
2015-06-04	AAC-DELISTED	Stock	41.34	42.08	40.98	41.65	244767.0
2015-06-04	AACG	Stock	4.93	5.0	4.78	4.78	12600.0
2015-06-04	AAIC-DELISTED	Stock	20.8	20.99	20.7	20.9	357329.0
2015-06-04	AAL	Stock	43.05	43.98	41.88	42.17	14128000.0
2015-06-04	AAMC-DELISTED	Stock	46.5647	47.8412	46.5529	47.8412	27540.0
2015-06-04	AAME	Stock	3.87	3.87	3.65	3.85	1600.0
2015-06-04	AAMI	Stock	19.56	19.66	19.11	19.21	48200.0
2015-06-04	AAOI	Stock	18.47	18.55	17.42	17.67	330600.0
2015-06-04	AAON	Stock	15.9333	16.0467	15.7067	15.7867	101250.0
2015-06-04	AAP	Stock	155.73	157.1	155.54	156.6	579900.0
2015-06-04	AAT	Stock	39.63	39.96	39.41	39.55	174900.0
2015-06-04	AAU-DELISTED	Stock	0.877	0.9	0.877	0.8825	45842.0
2015-06-04	AAUAF-DELISTED	Stock	0.875	0.9	0.875	0.88	47051.0
2015-06-04	AAV-DELISTED	Stock	5.99	6.06	5.96	5.98	60466.0
2015-06-04	AAVL-DELISTED	Stock	37.37	38.86	37.21	38.86	210590.0
2015-06-04	AAWW-DELISTED	Stock	55.47	55.88	53.55	53.9	395939.0
2015-06-04	AAXJ	Stock	65.55	65.63	65.1697	65.24	576490.0
2015-06-04	AAXN-DELISTED	Stock	31.53	32.25	31.033	31.36	1563008.0
2015-06-04	AB	Stock	31.69	32.24	31.01	31.29	183100.0
2015-06-04	ABAC-DELISTED	Stock	1.5515	1.69	1.5515	1.61	2500.0
2015-06-04	ABAX-DELISTED	Stock	52.89	53.1599	52.64	52.8	139539.0
2015-06-04	ABB-DELISTED	Stock	23.59	23.66	23.07	23.15	6314622.0
2015-06-04	ABBNY-DELISTED	Stock	23.59	23.66	23.07	23.14	7951250.0
2015-06-04	ABBV	Stock	66.55	67.87	66.52	67.42	10539000.0
2015-06-04	ABC-DELISTED	Stock	111.47	112.6	111.1	111.5	1391447.0
2015-06-04	ABCB	Stock	25.47	25.64	25.03	25.32	85500.0
2015-06-04	ABCD-DELISTED	Stock	4.14	4.15	4.0501	4.11	22005.0
2015-06-04	ABCO-DELISTED	Stock	51.75	51.99	50.85	50.87	211559.0
2015-06-04	ABCW-DELISTED	Stock	37.0	37.0	36.92	36.94	27529.0
2015-06-04	ABDC-DELISTED	Stock	13.65	13.95	13.6399	13.74	44432.0
2015-06-04	ABE-DELISTED	Stock	12.9	12.9	12.81	12.82	11683.0
2015-06-04	ABEO	Stock	185.0	192.5	178.75	181.0	26432.0
2015-06-04	ABEOW-DELISTED	Stock	3.15	3.15	3.01	3.01	3620.0
2015-06-04	ABEV	Stock	5.85	5.87	5.78	5.82	7404300.0
2015-06-04	ABG	Stock	86.82	87.86	86.57	87.08	196300.0
2015-06-04	ABGB-DELISTED	Stock	17.17	17.29	16.96	16.99	14985.0
2015-06-04	ABM	Stock	33.0	33.0	32.52	32.71	157700.0

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

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