PREVIEW / stock_1hour / 2013-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-16.parquet
  size:    993 KB
  rows:    45,946
  symbols: 3,517

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2013-05-16 04:00:00	AAPL	Stock	15.2464	15.2464	15.2343	15.2343	16800.0
2013-05-16 05:00:00	AAPL	Stock	15.25	15.25	15.2143	15.2143	33740.0
2013-05-16 06:00:00	AAPL	Stock	15.2246	15.2246	15.1832	15.1925	50400.0
2013-05-16 07:00:00	AAPL	Stock	15.1904	15.2807	15.1904	15.2321	316428.0
2013-05-16 08:00:00	AAPL	Stock	15.2329	15.2668	15.125	15.1893	2460304.0
2013-05-16 09:00:00	AAPL	Stock	15.1896	15.2679	14.9607	15.2607	123238164.0
2013-05-16 10:00:00	AAPL	Stock	15.2621	15.5079	15.2057	15.4679	143490396.0
2013-05-16 11:00:00	AAPL	Stock	15.4679	15.625	15.4582	15.6014	85079736.0
2013-05-16 12:00:00	AAPL	Stock	15.6014	15.6061	15.4807	15.5743	66145240.0
2013-05-16 13:00:00	AAPL	Stock	15.575	15.5982	15.5361	15.5782	34484184.0
2013-05-16 14:00:00	AAPL	Stock	15.5782	15.6375	15.4529	15.4564	53803848.0
2013-05-16 15:00:00	AAPL	Stock	15.4569	15.5493	15.4557	15.5221	70057148.0
2013-05-16 16:00:00	AAPL	Stock	15.52	15.6117	15.4125	15.5304	20632500.0
2013-05-16 17:00:00	AAPL	Stock	15.5268	15.6117	15.5189	15.5336	342020.0
2013-05-16 18:00:00	AAPL	Stock	15.5304	15.5336	15.5179	15.5179	141988.0
2013-05-16 19:00:00	AAPL	Stock	15.5214	15.5329	15.5186	15.5318	145740.0
2013-05-16 04:00:00	MSFT	Stock	33.65	33.65	33.65	33.65	700.0
2013-05-16 05:00:00	MSFT	Stock	33.65	33.65	33.65	33.65	200.0
2013-05-16 07:00:00	MSFT	Stock	33.73	33.74	33.73	33.74	800.0
2013-05-16 08:00:00	MSFT	Stock	33.845	33.88	33.74	33.8	46892.0
2013-05-16 09:00:00	MSFT	Stock	33.79	34.1	33.52	34.097	8687969.0
2013-05-16 10:00:00	MSFT	Stock	34.09	34.14	33.95	34.03	7278309.0
2013-05-16 11:00:00	MSFT	Stock	34.035	34.13	34.02	34.075	5776573.0
2013-05-16 12:00:00	MSFT	Stock	34.075	34.14	34.05	34.08	4095036.0
2013-05-16 13:00:00	MSFT	Stock	34.085	34.09	34.015	34.05	4910945.0
2013-05-16 14:00:00	MSFT	Stock	34.045	34.15	34.04	34.07	5517934.0
2013-05-16 15:00:00	MSFT	Stock	34.07	34.11	34.02	34.09	13765920.0
2013-05-16 16:00:00	MSFT	Stock	34.08	34.133	34.03	34.04	3703970.0
2013-05-16 17:00:00	MSFT	Stock	34.04	34.113	34.03	34.07	199298.0
2013-05-16 18:00:00	MSFT	Stock	34.03	34.03	33.98	34.02	2587.0
2013-05-16 19:00:00	MSFT	Stock	34.02	34.02	33.98	33.98	200.0
2013-05-16 09:00:00	NVDA	Stock	0.369	0.3698	0.3645	0.3685	38765120.0
2013-05-16 10:00:00	NVDA	Stock	0.3682	0.3698	0.3675	0.3695	69307280.0
2013-05-16 11:00:00	NVDA	Stock	0.3698	0.3708	0.3692	0.3698	35869320.0
2013-05-16 12:00:00	NVDA	Stock	0.3698	0.37	0.3682	0.3685	18087400.0
2013-05-16 13:00:00	NVDA	Stock	0.3685	0.369	0.3682	0.369	21725680.0
2013-05-16 14:00:00	NVDA	Stock	0.3688	0.3708	0.3685	0.3685	35094640.0
2013-05-16 15:00:00	NVDA	Stock	0.3685	0.3688	0.3658	0.366	74431680.0
2013-05-16 16:00:00	NVDA	Stock	0.3658	0.3682	0.3658	0.3665	14382960.0
2013-05-16 19:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	5920.0
2013-05-16 06:00:00	AMZN	Stock	13.3345	13.3705	13.3305	13.3705	20000.0
2013-05-16 07:00:00	AMZN	Stock	13.3695	13.3915	13.3695	13.39	36000.0
2013-05-16 08:00:00	AMZN	Stock	13.3725	13.4	13.317	13.32	103400.0
2013-05-16 09:00:00	AMZN	Stock	13.305	13.4215	13.27	13.323	6556760.0
2013-05-16 10:00:00	AMZN	Stock	13.318	13.343	13.2545	13.305	4456400.0
2013-05-16 11:00:00	AMZN	Stock	13.3032	13.3494	13.2875	13.2888	3025620.0
2013-05-16 12:00:00	AMZN	Stock	13.2935	13.3015	13.249	13.292	3798880.0
2013-05-16 13:00:00	AMZN	Stock	13.288	13.288	13.2515	13.2558	2624320.0
2013-05-16 14:00:00	AMZN	Stock	13.254	13.325	13.253	13.2648	3005420.0
2013-05-16 15:00:00	AMZN	Stock	13.262	13.2795	13.1925	13.2055	7021460.0

> showing 50 of 45,946 rows — these rows as CSV

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