PREVIEW / stock_daily / 2014-05-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-20.parquet
  size:    218 KB
  rows:    6,535
  symbols: 3,543

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
2014-05-20	AAPL	Stock	21.5896	21.6571	21.4546	21.5968	234836000.0
2014-05-20	MSFT	Stock	39.68	39.94	39.46	39.68	21320900.0
2014-05-20	NVDA	Stock	0.4615	0.4628	0.4538	0.456	256200000.0
2014-05-20	AMZN	Stock	14.855	15.223	14.8375	15.0595	81914000.0
2014-05-20	GOOGL	Stock	27.0	27.3175	26.8285	27.0195	48505840.0
2014-05-20	META	Stock	59.5	60.19	58.18	58.56	53931000.0
2014-05-20	TSLA	Stock	13.1293	13.2887	12.8713	13.02	83191500.0
2014-05-20	TLT	Stock	112.6	113.48	112.59	112.95	6549776.0
2014-05-20	ES	Stock	45.25	45.66	44.83	45.19	1600000.0
2014-05-20	CL	Stock	66.7	66.92	66.38	66.56	1778900.0
2014-05-20	A	Stock	39.2489	39.3133	38.7768	38.8484	2572460.0
2014-05-20	AABA-DELISTED	Stock	33.99	34.47	33.67	33.875	17659608.0
2014-05-20	AAIC-DELISTED	Stock	26.75	26.84	26.5	26.76	175204.0
2014-05-20	AAL	Stock	38.54	38.88	38.02	38.24	6285400.0
2014-05-20	AAMC-DELISTED	Stock	255.8824	269.9382	255.8824	260.2853	40854.0
2014-05-20	AAME	Stock	3.43	3.69	3.43	3.5	7200.0
2014-05-20	AAOI	Stock	19.24	19.24	18.02	18.15	141500.0
2014-05-20	AAON	Stock	13.4667	13.4667	12.8444	13.0444	350775.0
2014-05-20	AAP	Stock	122.79	122.79	121.12	122.11	891100.0
2014-05-20	AAT	Stock	34.18	34.18	33.71	33.92	185600.0
2014-05-20	AAU-DELISTED	Stock	1.33	1.34	1.3	1.34	71300.0
2014-05-20	AAUAF-DELISTED	Stock	1.33	1.34	1.3	1.34	71826.0
2014-05-20	AAV-DELISTED	Stock	5.72	5.78	5.641	5.71	214597.0
2014-05-20	AAWW-DELISTED	Stock	36.76	36.8	35.46	36.54	300362.0
2014-05-20	AAXJ	Stock	61.36	61.54	61.16	61.28	111552.0
2014-05-20	AAXN-DELISTED	Stock	13.48	13.48	12.76	12.88	1053773.0
2014-05-20	AB	Stock	23.83	24.18	23.18	23.47	371500.0
2014-05-20	ABAC-DELISTED	Stock	2.06	2.14	2.02	2.12	46624.0
2014-05-20	ABAX-DELISTED	Stock	43.65	43.65	42.25	42.27	179545.0
2014-05-20	ABB-DELISTED	Stock	23.84	23.85	23.4999	23.58	1656114.0
2014-05-20	ABBNY-DELISTED	Stock	23.84	23.85	23.4999	23.58	2556982.0
2014-05-20	ABBV	Stock	53.86	53.93	53.31	53.54	5021200.0
2014-05-20	ABC-DELISTED	Stock	69.41	69.88	68.79	69.785	1682705.0
2014-05-20	ABCB	Stock	19.8	19.98	19.5	19.88	124700.0
2014-05-20	ABCD-DELISTED	Stock	2.255	2.3	2.255	2.3	2250.0
2014-05-20	ABCO-DELISTED	Stock	49.35	49.63	46.88	47.28	660101.0
2014-05-20	ABDC-DELISTED	Stock	14.9	14.97	14.85	14.94	18811.0
2014-05-20	ABE-DELISTED	Stock	14.06	14.06	13.97	13.97	9719.0
2014-05-20	ABEO	Stock	550.0	562.5	512.5	562.5	40.0
2014-05-20	ABEV	Stock	7.37	7.51	7.3	7.31	7142100.0
2014-05-20	ABG	Stock	63.09	63.3	62.44	63.04	348500.0
2014-05-20	ABGB-DELISTED	Stock	20.75	20.78	20.3	20.45	4592.0
2014-05-20	ABIL-DELISTED	Stock	9.71	9.71	9.7	9.7	400.0
2014-05-20	ABM	Stock	26.64	26.64	26.04	26.19	209500.0
2014-05-20	ABMD-DELISTED	Stock	21.95	21.95	20.83	21.07	391949.0
2014-05-20	ABR	Stock	7.13	7.13	7.02	7.03	53100.0
2014-05-20	ABR.A-DELISTED	Stock	24.51	24.6199	24.5	24.5	1787.0
2014-05-20	ABR.B-DELISTED	Stock	23.72	23.79	23.7	23.75	4525.0
2014-05-20	ABR.C-DELISTED	Stock	24.85	24.85	24.76	24.8	5748.0
2014-05-20	ABRN-DELISTED	Stock	24.68	24.89	24.65	24.82	35920.0

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

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