PREVIEW / stock_1hour / 2014-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-08.parquet
  size:    1.1 MB
  rows:    49,434
  symbols: 3,562

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
2014-12-08 04:00:00	AAPL	Stock	28.6875	28.695	28.65	28.65	11780.0
2014-12-08 05:00:00	AAPL	Stock	28.5875	28.5925	28.575	28.5925	20640.0
2014-12-08 06:00:00	AAPL	Stock	28.575	28.7075	28.5725	28.5775	108976.0
2014-12-08 07:00:00	AAPL	Stock	28.6075	28.7075	28.5925	28.5925	220396.0
2014-12-08 08:00:00	AAPL	Stock	28.6025	28.67	28.4775	28.49	899316.0
2014-12-08 09:00:00	AAPL	Stock	28.49	28.662	28.2825	28.5628	27220336.0
2014-12-08 10:00:00	AAPL	Stock	28.5775	28.62	28.44	28.464	21395540.0
2014-12-08 11:00:00	AAPL	Stock	28.4628	28.4628	28.315	28.42	25900504.0
2014-12-08 12:00:00	AAPL	Stock	28.42	28.455	28.005	28.0522	40617656.0
2014-12-08 13:00:00	AAPL	Stock	28.0525	28.205	27.9325	27.9775	29992156.0
2014-12-08 14:00:00	AAPL	Stock	27.9775	28.16	27.905	28.1275	25306500.0
2014-12-08 15:00:00	AAPL	Stock	28.1275	28.146	28.02	28.1025	26599960.0
2014-12-08 16:00:00	AAPL	Stock	28.105	28.813	28.0638	28.105	16563452.0
2014-12-08 17:00:00	AAPL	Stock	28.105	28.2528	28.1	28.135	627980.0
2014-12-08 18:00:00	AAPL	Stock	28.135	28.1475	28.1	28.1375	341124.0
2014-12-08 19:00:00	AAPL	Stock	28.1425	28.165	28.1375	28.16	184400.0
2014-12-08 04:00:00	MSFT	Stock	48.5	48.5	48.5	48.5	220.0
2014-12-08 05:00:00	MSFT	Stock	48.4	48.4	48.2	48.2	300.0
2014-12-08 07:00:00	MSFT	Stock	48.25	48.25	48.25	48.25	600.0
2014-12-08 08:00:00	MSFT	Stock	48.25	48.25	48.21	48.24	2256.0
2014-12-08 09:00:00	MSFT	Stock	48.24	48.49	48.12	48.25	2342591.0
2014-12-08 10:00:00	MSFT	Stock	48.25	48.34	48.14	48.23	2204227.0
2014-12-08 11:00:00	MSFT	Stock	48.231	48.27	48.09	48.27	2246935.0
2014-12-08 12:00:00	MSFT	Stock	48.27	48.27	47.81	47.875	2832964.0
2014-12-08 13:00:00	MSFT	Stock	47.88	47.91	47.51	47.546	2975661.0
2014-12-08 14:00:00	MSFT	Stock	47.545	47.755	47.445	47.675	2332655.0
2014-12-08 15:00:00	MSFT	Stock	47.675	47.79	47.57	47.69	6191159.0
2014-12-08 16:00:00	MSFT	Stock	47.695	47.865	47.644	47.689	4446787.0
2014-12-08 17:00:00	MSFT	Stock	47.944	47.944	47.69	47.69	13295.0
2014-12-08 18:00:00	MSFT	Stock	47.695	47.97	47.695	47.97	9456.0
2014-12-08 19:00:00	MSFT	Stock	47.79	47.87	47.79	47.87	425.0
2014-12-08 08:00:00	NVDA	Stock	0.5268	0.5268	0.5268	0.5268	170000.0
2014-12-08 09:00:00	NVDA	Stock	0.526	0.5312	0.5247	0.5302	19406840.0
2014-12-08 10:00:00	NVDA	Stock	0.5305	0.5312	0.5274	0.5282	32382000.0
2014-12-08 11:00:00	NVDA	Stock	0.5282	0.5285	0.5218	0.5221	44433400.0
2014-12-08 12:00:00	NVDA	Stock	0.5221	0.5222	0.518	0.5205	23529720.0
2014-12-08 13:00:00	NVDA	Stock	0.5205	0.521	0.5165	0.5165	19114480.0
2014-12-08 14:00:00	NVDA	Stock	0.5165	0.5185	0.5158	0.5181	23954400.0
2014-12-08 15:00:00	NVDA	Stock	0.518	0.5205	0.5175	0.5201	51357480.0
2014-12-08 16:00:00	NVDA	Stock	0.52	0.5224	0.5188	0.52	7938720.0
2014-12-08 04:00:00	AMZN	Stock	15.8	15.8	15.8	15.8	6000.0
2014-12-08 06:00:00	AMZN	Stock	15.718	15.718	15.718	15.718	4000.0
2014-12-08 08:00:00	AMZN	Stock	15.647	15.65	15.605	15.605	41240.0
2014-12-08 09:00:00	AMZN	Stock	15.5895	15.828	15.556	15.715	9887840.0
2014-12-08 10:00:00	AMZN	Stock	15.715	15.7635	15.6005	15.675	9970540.0
2014-12-08 11:00:00	AMZN	Stock	15.6785	15.707	15.506	15.519	8355520.0
2014-12-08 12:00:00	AMZN	Stock	15.5255	15.527	15.35	15.41	8535000.0
2014-12-08 13:00:00	AMZN	Stock	15.411	15.419	15.278	15.2875	6982980.0
2014-12-08 14:00:00	AMZN	Stock	15.2915	15.356	15.241	15.309	6755340.0
2014-12-08 15:00:00	AMZN	Stock	15.3115	15.349	15.2585	15.328	13222500.0

> showing 50 of 49,434 rows — these rows as CSV

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