PREVIEW / stock_1hour / 2014-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-09.parquet
  size:    1.1 MB
  rows:    49,753
  symbols: 3,546

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-09 04:00:00	AAPL	Stock	28.0875	28.0875	27.675	27.72	236828.0
2014-12-09 05:00:00	AAPL	Stock	27.72	27.8	27.6875	27.795	108736.0
2014-12-09 06:00:00	AAPL	Stock	27.7875	27.9	27.785	27.8225	116640.0
2014-12-09 07:00:00	AAPL	Stock	27.835	27.86	27.74	27.7875	438432.0
2014-12-09 08:00:00	AAPL	Stock	27.7888	27.8925	27.64	27.7	2150516.0
2014-12-09 09:00:00	AAPL	Stock	27.7025	28.1	27.3375	27.825	52238064.0
2014-12-09 10:00:00	AAPL	Stock	27.8375	27.905	27.5675	27.7825	36301420.0
2014-12-09 11:00:00	AAPL	Stock	27.7825	28.0025	27.7825	27.925	22726436.0
2014-12-09 12:00:00	AAPL	Stock	27.925	28.21	27.9025	28.2	21939428.0
2014-12-09 13:00:00	AAPL	Stock	28.2	28.415	28.17	28.36	26335596.0
2014-12-09 14:00:00	AAPL	Stock	28.36	28.375	28.2075	28.2828	14632448.0
2014-12-09 15:00:00	AAPL	Stock	28.285	28.575	28.2762	28.5325	31228532.0
2014-12-09 16:00:00	AAPL	Stock	28.535	28.545	27.807	28.53	15417528.0
2014-12-09 17:00:00	AAPL	Stock	28.5275	28.5325	28.505	28.5225	198224.0
2014-12-09 18:00:00	AAPL	Stock	28.525	28.54	28.525	28.53	92360.0
2014-12-09 19:00:00	AAPL	Stock	28.535	28.5625	28.0905	28.55	103436.0
2014-12-09 06:00:00	MSFT	Stock	47.4	47.4	47.4	47.4	100.0
2014-12-09 07:00:00	MSFT	Stock	47.45	47.45	47.31	47.31	1200.0
2014-12-09 08:00:00	MSFT	Stock	47.4	47.45	47.01	47.09	23395.0
2014-12-09 09:00:00	MSFT	Stock	47.1	47.62	47.05	47.5	3264137.0
2014-12-09 10:00:00	MSFT	Stock	47.495	47.54	47.21	47.35	3242417.0
2014-12-09 11:00:00	MSFT	Stock	47.35	47.67	47.31	47.65	1877338.0
2014-12-09 12:00:00	MSFT	Stock	47.635	47.74	47.5	47.71	1452143.0
2014-12-09 13:00:00	MSFT	Stock	47.71	47.92	47.69	47.79	1727151.0
2014-12-09 14:00:00	MSFT	Stock	47.79	47.85	47.465	47.6	2533992.0
2014-12-09 15:00:00	MSFT	Stock	47.6	47.71	47.51	47.6	4866216.0
2014-12-09 16:00:00	MSFT	Stock	47.59	47.68	47.419	47.59	3998154.0
2014-12-09 19:00:00	MSFT	Stock	47.601	47.601	47.6	47.6	4381.0
2014-12-09 08:00:00	NVDA	Stock	0.5175	0.5175	0.511	0.5115	40000.0
2014-12-09 09:00:00	NVDA	Stock	0.5168	0.5195	0.5112	0.5133	35466720.0
2014-12-09 10:00:00	NVDA	Stock	0.5133	0.5133	0.509	0.5115	36968240.0
2014-12-09 11:00:00	NVDA	Stock	0.5118	0.5142	0.5116	0.5135	13100800.0
2014-12-09 12:00:00	NVDA	Stock	0.5133	0.514	0.5109	0.5133	19036840.0
2014-12-09 13:00:00	NVDA	Stock	0.5133	0.517	0.5131	0.5162	17320920.0
2014-12-09 14:00:00	NVDA	Stock	0.516	0.5178	0.5158	0.5175	20624400.0
2014-12-09 15:00:00	NVDA	Stock	0.5175	0.5192	0.5174	0.5184	65164800.0
2014-12-09 16:00:00	NVDA	Stock	0.5185	0.519	0.5182	0.5182	14203240.0
2014-12-09 04:00:00	AMZN	Stock	15.2885	15.2885	15.2885	15.2885	10000.0
2014-12-09 06:00:00	AMZN	Stock	15.2885	15.2925	15.2885	15.2925	38100.0
2014-12-09 07:00:00	AMZN	Stock	15.2875	15.295	15.05	15.1395	345580.0
2014-12-09 08:00:00	AMZN	Stock	15.15	15.195	15.1005	15.144	191020.0
2014-12-09 09:00:00	AMZN	Stock	15.125	15.4054	15.057	15.4035	12129300.0
2014-12-09 10:00:00	AMZN	Stock	15.4023	15.4225	15.2355	15.3375	14864560.0
2014-12-09 11:00:00	AMZN	Stock	15.331	15.4325	15.268	15.3994	7670840.0
2014-12-09 12:00:00	AMZN	Stock	15.392	15.5415	15.357	15.492	9061380.0
2014-12-09 13:00:00	AMZN	Stock	15.489	15.682	15.484	15.5978	9290460.0
2014-12-09 14:00:00	AMZN	Stock	15.6	15.621	15.5315	15.579	5873960.0
2014-12-09 15:00:00	AMZN	Stock	15.585	15.639	15.554	15.6285	13033600.0
2014-12-09 16:00:00	AMZN	Stock	15.625	15.649	15.3174	15.4306	2418820.0
2014-12-09 17:00:00	AMZN	Stock	15.625	15.625	15.615	15.615	10880.0

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

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