PREVIEW / stock_1hour / 2014-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-17.parquet
  size:    1.0 MB
  rows:    49,209
  symbols: 3,557

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-10-17 04:00:00	AAPL	Stock	24.185	24.325	24.1375	24.325	38832.0
2014-10-17 05:00:00	AAPL	Stock	24.33	24.3975	24.3225	24.3975	17312.0
2014-10-17 06:00:00	AAPL	Stock	24.3975	24.4225	24.35	24.38	135648.0
2014-10-17 07:00:00	AAPL	Stock	24.38	24.38	24.3	24.3325	299376.0
2014-10-17 08:00:00	AAPL	Stock	24.33	24.415	24.3125	24.3625	1241084.0
2014-10-17 09:00:00	AAPL	Stock	24.375	24.4375	24.2025	24.3475	45604208.0
2014-10-17 10:00:00	AAPL	Stock	24.345	24.51	24.335	24.4975	36369556.0
2014-10-17 11:00:00	AAPL	Stock	24.4975	24.75	24.4775	24.685	35869108.0
2014-10-17 12:00:00	AAPL	Stock	24.6825	24.7075	24.4875	24.5338	29189424.0
2014-10-17 13:00:00	AAPL	Stock	24.5325	24.585	24.475	24.5375	21232112.0
2014-10-17 14:00:00	AAPL	Stock	24.535	24.5362	24.415	24.4575	22661100.0
2014-10-17 15:00:00	AAPL	Stock	24.4575	24.51	24.375	24.415	44133572.0
2014-10-17 16:00:00	AAPL	Stock	24.4175	24.515	24.39	24.4425	17649392.0
2014-10-17 17:00:00	AAPL	Stock	24.45	24.5	24.4175	24.4975	1017868.0
2014-10-17 18:00:00	AAPL	Stock	24.4975	24.5375	24.4175	24.5125	592376.0
2014-10-17 19:00:00	AAPL	Stock	24.505	24.535	24.495	24.5325	254852.0
2014-10-17 04:00:00	MSFT	Stock	42.98	42.98	42.98	42.98	100.0
2014-10-17 07:00:00	MSFT	Stock	43.1	43.14	43.1	43.14	4410.0
2014-10-17 08:00:00	MSFT	Stock	43.19	43.3	43.13	43.2	22715.0
2014-10-17 09:00:00	MSFT	Stock	43.19	43.33	42.79	43.005	9851914.0
2014-10-17 10:00:00	MSFT	Stock	43.005	43.48	42.9	43.445	5572726.0
2014-10-17 11:00:00	MSFT	Stock	43.44	43.91	43.35	43.755	3973522.0
2014-10-17 12:00:00	MSFT	Stock	43.75	43.8	43.635	43.74	2897006.0
2014-10-17 13:00:00	MSFT	Stock	43.74	43.77	43.45	43.58	3353711.0
2014-10-17 14:00:00	MSFT	Stock	43.57	43.685	43.43	43.63	3369904.0
2014-10-17 15:00:00	MSFT	Stock	43.625	43.935	43.44	43.63	7248029.0
2014-10-17 16:00:00	MSFT	Stock	43.63	43.737	43.546	43.7	3076703.0
2014-10-17 17:00:00	MSFT	Stock	43.7	43.7	43.65	43.7	728.0
2014-10-17 18:00:00	MSFT	Stock	43.64	43.65	43.63	43.63	26087.0
2014-10-17 19:00:00	MSFT	Stock	43.63	43.7	43.63	43.7	1400.0
2014-10-17 09:00:00	NVDA	Stock	0.441	0.4466	0.441	0.4458	44220040.0
2014-10-17 10:00:00	NVDA	Stock	0.4456	0.4466	0.4405	0.4415	42809360.0
2014-10-17 11:00:00	NVDA	Stock	0.4415	0.4445	0.4406	0.442	38033480.0
2014-10-17 12:00:00	NVDA	Stock	0.4421	0.4422	0.4378	0.4388	27301040.0
2014-10-17 13:00:00	NVDA	Stock	0.4388	0.4392	0.4355	0.4367	11789360.0
2014-10-17 14:00:00	NVDA	Stock	0.4365	0.4375	0.4338	0.4366	22189320.0
2014-10-17 15:00:00	NVDA	Stock	0.4368	0.4369	0.4338	0.4355	81668880.0
2014-10-17 16:00:00	NVDA	Stock	0.4355	0.4372	0.4348	0.4355	13175320.0
2014-10-17 18:00:00	NVDA	Stock	0.435	0.435	0.435	0.435	24000.0
2014-10-17 08:00:00	AMZN	Stock	15.2945	15.382	15.2945	15.374	117200.0
2014-10-17 09:00:00	AMZN	Stock	15.3555	15.46	15.227	15.2918	14184640.0
2014-10-17 10:00:00	AMZN	Stock	15.2885	15.418	15.2385	15.3155	14035120.0
2014-10-17 11:00:00	AMZN	Stock	15.316	15.4185	15.2995	15.347	7516620.0
2014-10-17 12:00:00	AMZN	Stock	15.345	15.371	15.2805	15.311	7300960.0
2014-10-17 13:00:00	AMZN	Stock	15.32	15.3352	15.1715	15.1975	8900860.0
2014-10-17 14:00:00	AMZN	Stock	15.194	15.2295	15.143	15.2045	8282840.0
2014-10-17 15:00:00	AMZN	Stock	15.206	15.2605	15.136	15.1815	17222920.0
2014-10-17 16:00:00	AMZN	Stock	15.188	15.3756	15.125	15.1815	583100.0
2014-10-17 17:00:00	AMZN	Stock	15.181	15.181	15.15	15.1505	165940.0
2014-10-17 18:00:00	AMZN	Stock	15.1625	15.182	15.15	15.1725	100200.0

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

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