PREVIEW / stock_1hour / 2016-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-11.parquet
  size:    1.0 MB
  rows:    49,002
  symbols: 3,277

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
2016-07-11 04:00:00	AAPL	Stock	24.23	24.2375	24.23	24.2375	800.0
2016-07-11 05:00:00	AAPL	Stock	24.2375	24.285	24.2275	24.2825	12400.0
2016-07-11 06:00:00	AAPL	Stock	24.2525	24.2525	24.2275	24.25	6720.0
2016-07-11 07:00:00	AAPL	Stock	24.2475	24.33	24.2475	24.285	46228.0
2016-07-11 08:00:00	AAPL	Stock	24.36	24.36	24.2725	24.3	328828.0
2016-07-11 09:00:00	AAPL	Stock	24.3	24.4125	24.1825	24.3608	21637424.0
2016-07-11 10:00:00	AAPL	Stock	24.36	24.375	24.295	24.3462	13657876.0
2016-07-11 11:00:00	AAPL	Stock	24.3475	24.365	24.308	24.33	8705392.0
2016-07-11 12:00:00	AAPL	Stock	24.3325	24.35	24.3175	24.3425	6626668.0
2016-07-11 13:00:00	AAPL	Stock	24.3425	24.3575	24.2913	24.2975	7713528.0
2016-07-11 14:00:00	AAPL	Stock	24.3	24.315	24.2775	24.29	6626328.0
2016-07-11 15:00:00	AAPL	Stock	24.29	24.305	24.2325	24.245	14334180.0
2016-07-11 16:00:00	AAPL	Stock	24.245	24.3082	24.225	24.2425	6751828.0
2016-07-11 17:00:00	AAPL	Stock	24.2325	24.245	24.2325	24.245	1711084.0
2016-07-11 18:00:00	AAPL	Stock	24.2325	24.2425	24.23	24.235	26592.0
2016-07-11 19:00:00	AAPL	Stock	24.235	24.2425	24.2275	24.2275	28436.0
2016-07-11 05:00:00	MSFT	Stock	52.48	52.57	52.48	52.57	1100.0
2016-07-11 06:00:00	MSFT	Stock	52.57	52.57	52.47	52.47	800.0
2016-07-11 07:00:00	MSFT	Stock	52.34	52.34	52.34	52.34	102.0
2016-07-11 08:00:00	MSFT	Stock	52.35	52.5	52.34	52.5	9245.0
2016-07-11 09:00:00	MSFT	Stock	52.5	52.83	52.46	52.71	3122189.0
2016-07-11 10:00:00	MSFT	Stock	52.704	52.705	52.5	52.6	2874107.0
2016-07-11 11:00:00	MSFT	Stock	52.6	52.75	52.57	52.69	2628696.0
2016-07-11 12:00:00	MSFT	Stock	52.69	52.83	52.66	52.795	1592451.0
2016-07-11 13:00:00	MSFT	Stock	52.8	52.82	52.66	52.68	1814057.0
2016-07-11 14:00:00	MSFT	Stock	52.69	52.765	52.65	52.675	1758190.0
2016-07-11 15:00:00	MSFT	Stock	52.67	52.79	52.57	52.59	3798660.0
2016-07-11 16:00:00	MSFT	Stock	52.59	52.6	52.51	52.59	2926362.0
2016-07-11 17:00:00	MSFT	Stock	52.67	52.67	52.56	52.59	372943.0
2016-07-11 18:00:00	MSFT	Stock	52.59	52.59	52.59	52.59	209.0
2016-07-11 19:00:00	MSFT	Stock	52.65	52.65	52.6	52.6	1400.0
2016-07-11 07:00:00	NVDA	Stock	1.282	1.282	1.2755	1.2755	36000.0
2016-07-11 08:00:00	NVDA	Stock	1.2832	1.29	1.2812	1.2888	1752560.0
2016-07-11 09:00:00	NVDA	Stock	1.2888	1.303	1.2828	1.3015	99560640.0
2016-07-11 10:00:00	NVDA	Stock	1.3015	1.303	1.2988	1.3024	66238120.0
2016-07-11 11:00:00	NVDA	Stock	1.3024	1.31	1.3024	1.3039	52932760.0
2016-07-11 12:00:00	NVDA	Stock	1.304	1.3064	1.3025	1.3054	31157480.0
2016-07-11 13:00:00	NVDA	Stock	1.3052	1.307	1.304	1.304	47327440.0
2016-07-11 14:00:00	NVDA	Stock	1.3043	1.3046	1.301	1.3024	28293480.0
2016-07-11 15:00:00	NVDA	Stock	1.3025	1.305	1.3005	1.3005	70325480.0
2016-07-11 16:00:00	NVDA	Stock	1.3008	1.3074	1.3005	1.303	43187120.0
2016-07-11 17:00:00	NVDA	Stock	1.3015	1.303	1.3015	1.303	28000.0
2016-07-11 18:00:00	NVDA	Stock	1.3012	1.3012	1.3012	1.3012	18360.0
2016-07-11 19:00:00	NVDA	Stock	1.303	1.303	1.301	1.303	57600.0
2016-07-11 04:00:00	AMZN	Stock	37.3675	37.3675	37.3675	37.3675	2000.0
2016-07-11 07:00:00	AMZN	Stock	37.4165	37.5125	37.4165	37.495	169340.0
2016-07-11 08:00:00	AMZN	Stock	37.5195	37.523	37.45	37.4875	574460.0
2016-07-11 09:00:00	AMZN	Stock	37.4875	37.7695	37.35	37.706	14175400.0
2016-07-11 10:00:00	AMZN	Stock	37.7163	37.7775	37.614	37.773	7846300.0
2016-07-11 11:00:00	AMZN	Stock	37.7716	37.7716	37.7022	37.7395	5589760.0

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

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