PREVIEW / stock_1hour / 2017-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-13.parquet
  size:    1.0 MB
  rows:    48,394
  symbols: 3,066

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
2017-03-13 05:00:00	AAPL	Stock	34.73	34.73	34.73	34.73	576.0
2017-03-13 06:00:00	AAPL	Stock	34.7	34.7	34.7	34.7	3200.0
2017-03-13 07:00:00	AAPL	Stock	34.69	34.7	34.675	34.68	27368.0
2017-03-13 08:00:00	AAPL	Stock	34.655	34.7375	34.655	34.715	137188.0
2017-03-13 09:00:00	AAPL	Stock	34.71	34.85	34.6925	34.7775	9059756.0
2017-03-13 10:00:00	AAPL	Stock	34.7775	34.79	34.71	34.7675	9743128.0
2017-03-13 11:00:00	AAPL	Stock	34.7685	34.7725	34.715	34.745	5833048.0
2017-03-13 12:00:00	AAPL	Stock	34.7475	34.8575	34.735	34.7788	8091556.0
2017-03-13 13:00:00	AAPL	Stock	34.778	34.8325	34.7738	34.815	5837564.0
2017-03-13 14:00:00	AAPL	Stock	34.8175	34.8425	34.8025	34.805	4443532.0
2017-03-13 15:00:00	AAPL	Stock	34.8075	34.82	34.78	34.7975	7692484.0
2017-03-13 16:00:00	AAPL	Stock	34.8	34.83	34.8	34.805	8604816.0
2017-03-13 17:00:00	AAPL	Stock	34.8125	34.825	34.8	34.8225	27092.0
2017-03-13 18:00:00	AAPL	Stock	34.8	34.825	34.8	34.8175	30540.0
2017-03-13 19:00:00	AAPL	Stock	34.8175	34.8175	34.8	34.8125	20416.0
2017-03-13 04:00:00	MSFT	Stock	65.2	65.2	65.2	65.2	100.0
2017-03-13 08:00:00	MSFT	Stock	65.0	65.0	64.9	64.9	1165.0
2017-03-13 09:00:00	MSFT	Stock	65.0	65.195	64.915	64.925	1838214.0
2017-03-13 10:00:00	MSFT	Stock	64.925	64.95	64.7	64.78	1832754.0
2017-03-13 11:00:00	MSFT	Stock	64.78	64.83	64.72	64.76	1329896.0
2017-03-13 12:00:00	MSFT	Stock	64.76	64.77	64.57	64.67	1325733.0
2017-03-13 13:00:00	MSFT	Stock	64.665	64.75	64.63	64.685	1434193.0
2017-03-13 14:00:00	MSFT	Stock	64.69	64.79	64.68	64.77	1519239.0
2017-03-13 15:00:00	MSFT	Stock	64.775	64.81	64.67	64.71	3491770.0
2017-03-13 16:00:00	MSFT	Stock	64.715	64.82	64.71	64.76	5140691.0
2017-03-13 17:00:00	MSFT	Stock	64.77	64.77	64.71	64.71	1950.0
2017-03-13 18:00:00	MSFT	Stock	64.71	64.77	64.71	64.77	1530.0
2017-03-13 19:00:00	MSFT	Stock	64.72	64.72	64.71	64.71	2623.0
2017-03-13 04:00:00	NVDA	Stock	2.4875	2.4875	2.4828	2.4828	19840.0
2017-03-13 06:00:00	NVDA	Stock	2.4938	2.5188	2.4835	2.5188	214600.0
2017-03-13 07:00:00	NVDA	Stock	2.5188	2.5188	2.4343	2.4448	1631320.0
2017-03-13 08:00:00	NVDA	Stock	2.4448	2.4935	2.4343	2.4832	5626040.0
2017-03-13 09:00:00	NVDA	Stock	2.48	2.547	2.48	2.5185	189435320.0
2017-03-13 10:00:00	NVDA	Stock	2.5184	2.5425	2.5145	2.5302	134223920.0
2017-03-13 11:00:00	NVDA	Stock	2.5293	2.5438	2.5192	2.5208	86301520.0
2017-03-13 12:00:00	NVDA	Stock	2.5207	2.54	2.5206	2.5378	42128040.0
2017-03-13 13:00:00	NVDA	Stock	2.538	2.548	2.5363	2.5471	67752120.0
2017-03-13 14:00:00	NVDA	Stock	2.547	2.5563	2.5403	2.5498	86509000.0
2017-03-13 15:00:00	NVDA	Stock	2.5498	2.5563	2.5328	2.5462	124278400.0
2017-03-13 16:00:00	NVDA	Stock	2.5462	2.5475	2.5321	2.545	9658160.0
2017-03-13 17:00:00	NVDA	Stock	2.545	2.5475	2.5438	2.5475	262880.0
2017-03-13 18:00:00	NVDA	Stock	2.547	2.5488	2.5462	2.5475	356920.0
2017-03-13 19:00:00	NVDA	Stock	2.5485	2.549	2.548	2.5483	260240.0
2017-03-13 07:00:00	AMZN	Stock	42.623	42.623	42.623	42.623	2000.0
2017-03-13 08:00:00	AMZN	Stock	42.6215	42.6295	42.6015	42.625	35240.0
2017-03-13 09:00:00	AMZN	Stock	42.608	42.7529	42.5855	42.6844	5593500.0
2017-03-13 10:00:00	AMZN	Stock	42.694	42.758	42.669	42.721	6168060.0
2017-03-13 11:00:00	AMZN	Stock	42.7455	42.7835	42.72	42.773	5370640.0
2017-03-13 12:00:00	AMZN	Stock	42.764	42.7845	42.707	42.7455	3601040.0
2017-03-13 13:00:00	AMZN	Stock	42.751	42.7712	42.725	42.7555	1991240.0

> showing 50 of 48,394 rows — these rows as CSV

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