PREVIEW / stock_daily / 2014-05-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-01.parquet
  size:    218 KB
  rows:    6,520
  symbols: 3,540

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-01	AAPL	Stock	21.1429	21.2429	20.9414	21.1243	244048000.0
2014-05-01	MSFT	Stock	40.24	40.36	39.95	40.0	28787400.0
2014-05-01	NVDA	Stock	0.4688	0.4698	0.4605	0.4643	198104000.0
2014-05-01	AMZN	Stock	15.2065	15.524	15.2	15.3945	86572000.0
2014-05-01	GOOGL	Stock	26.7125	26.9955	26.643	26.9265	40087500.0
2014-05-01	META	Stock	60.43	62.28	60.21	61.15	82429000.0
2014-05-01	TSLA	Stock	13.8053	14.268	13.7127	13.8487	81598500.0
2014-05-01	TLT	Stock	110.88	112.08	110.84	112.02	11558661.0
2014-05-01	ES	Stock	47.51	47.51	46.79	47.16	1278900.0
2014-05-01	CL	Stock	67.18	67.42	66.54	67.01	2652400.0
2014-05-01	A	Stock	38.5837	39.2489	38.3834	38.9628	2058415.0
2014-05-01	AABA-DELISTED	Stock	36.29	36.69	36.0	36.51	18603758.0
2014-05-01	AACG	Stock	4.13	4.38	4.11	4.34	17700.0
2014-05-01	AAIC-DELISTED	Stock	26.49	26.5	26.13	26.31	237338.0
2014-05-01	AAL	Stock	35.86	36.7	35.47	36.39	11497700.0
2014-05-01	AAMC-DELISTED	Stock	292.1176	292.9294	283.8235	290.5941	74147.0
2014-05-01	AAME	Stock	3.51	3.53	3.45	3.45	5000.0
2014-05-01	AAOI	Stock	22.56	22.57	21.55	21.97	234400.0
2014-05-01	AAON	Stock	12.5378	12.8356	12.1911	12.5956	297000.0
2014-05-01	AAP	Stock	124.07	124.16	120.76	120.98	377700.0
2014-05-01	AAT	Stock	33.99	34.04	33.25	33.97	171500.0
2014-05-01	AAU-DELISTED	Stock	1.39	1.4099	1.37	1.37	30432.0
2014-05-01	AAUAF-DELISTED	Stock	1.39	1.4099	1.37	1.37	30724.0
2014-05-01	AAV-DELISTED	Stock	6.33	6.35	6.18	6.295	474101.0
2014-05-01	AAWW-DELISTED	Stock	37.0	40.56	36.66	39.55	1721388.0
2014-05-01	AAXJ	Stock	59.52	59.91	59.51	59.8	186185.0
2014-05-01	AAXN-DELISTED	Stock	15.99	16.122	15.09	15.25	2259575.0
2014-05-01	AB	Stock	25.36	25.46	24.97	25.0	355300.0
2014-05-01	ABAC-DELISTED	Stock	2.0	2.05	1.9801	2.05	7016.0
2014-05-01	ABAX-DELISTED	Stock	40.45	41.47	40.13	41.0	204587.0
2014-05-01	ABB-DELISTED	Stock	23.96	23.995	23.59	23.94	3650047.0
2014-05-01	ABBNY-DELISTED	Stock	23.96	23.995	23.59	23.94	3735084.0
2014-05-01	ABBV	Stock	51.89	52.1	51.41	51.61	4279800.0
2014-05-01	ABC-DELISTED	Stock	64.76	65.17	63.85	64.88	1869679.0
2014-05-01	ABCB	Stock	21.17	21.28	20.62	20.97	102600.0
2014-05-01	ABCD-DELISTED	Stock	2.24	2.24	2.2	2.23	9840.0
2014-05-01	ABCO-DELISTED	Stock	56.99	57.82	55.54	56.47	282227.0
2014-05-01	ABE-DELISTED	Stock	13.49	13.5396	13.31	13.49	21284.0
2014-05-01	ABEO	Stock	587.5	625.0	562.5	625.0	16.0
2014-05-01	ABEV	Stock	7.31	7.31	7.09	7.15	10807100.0
2014-05-01	ABG	Stock	61.66	62.45	61.09	62.44	377900.0
2014-05-01	ABGB-DELISTED	Stock	22.31	22.48	22.2301	22.42	603.0
2014-05-01	ABIL-DELISTED	Stock	9.74	9.85	9.72	9.76	89499.0
2014-05-01	ABM	Stock	27.1	27.1	26.53	26.86	268900.0
2014-05-01	ABMD-DELISTED	Stock	22.98	23.135	21.61	22.67	1508794.0
2014-05-01	ABR	Stock	7.01	7.03	6.94	7.0	82900.0
2014-05-01	ABR.A-DELISTED	Stock	25.07	25.19	25.07	25.17	39315.0
2014-05-01	ABR.B-DELISTED	Stock	23.92	23.95	23.85	23.95	804.0
2014-05-01	ABR.C-DELISTED	Stock	25.27	25.43	25.27	25.43	13294.0
2014-05-01	ABT	Stock	38.65	38.89	38.39	38.67	3652400.0

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

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