PREVIEW / stock_1hour / 2017-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-13.parquet
  size:    1.0 MB
  rows:    47,675
  symbols: 3,137

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-01-13 06:00:00	AAPL	Stock	29.795	29.795	29.7775	29.7775	4400.0
2017-01-13 07:00:00	AAPL	Stock	29.795	29.8125	29.795	29.8	12540.0
2017-01-13 08:00:00	AAPL	Stock	29.8	29.835	29.7775	29.78	141352.0
2017-01-13 09:00:00	AAPL	Stock	29.7875	29.905	29.745	29.806	17059928.0
2017-01-13 10:00:00	AAPL	Stock	29.805	29.8425	29.715	29.7442	13204728.0
2017-01-13 11:00:00	AAPL	Stock	29.745	29.79	29.72	29.781	9195940.0
2017-01-13 12:00:00	AAPL	Stock	29.7825	29.79	29.7075	29.7775	8636136.0
2017-01-13 13:00:00	AAPL	Stock	29.7775	29.7948	29.75	29.7525	6291148.0
2017-01-13 14:00:00	AAPL	Stock	29.7525	29.795	29.705	29.7605	9193080.0
2017-01-13 15:00:00	AAPL	Stock	29.761	29.7625	29.7025	29.7575	18916676.0
2017-01-13 16:00:00	AAPL	Stock	29.755	29.7625	29.725	29.76	8970280.0
2017-01-13 17:00:00	AAPL	Stock	29.76	29.7625	29.7525	29.755	261736.0
2017-01-13 18:00:00	AAPL	Stock	29.755	29.7625	29.75	29.75	52164.0
2017-01-13 19:00:00	AAPL	Stock	29.75	29.755	29.75	29.755	38416.0
2017-01-13 07:00:00	MSFT	Stock	62.6	62.72	62.6	62.72	4235.0
2017-01-13 08:00:00	MSFT	Stock	62.61	62.76	62.61	62.75	6658.0
2017-01-13 09:00:00	MSFT	Stock	62.66	62.865	62.35	62.59	2547167.0
2017-01-13 10:00:00	MSFT	Stock	62.59	62.63	62.445	62.595	1840447.0
2017-01-13 11:00:00	MSFT	Stock	62.6	62.66	62.43	62.635	1534089.0
2017-01-13 12:00:00	MSFT	Stock	62.63	62.72	62.48	62.63	1975087.0
2017-01-13 13:00:00	MSFT	Stock	62.64	62.675	62.58	62.645	1115078.0
2017-01-13 14:00:00	MSFT	Stock	62.645	62.65	62.51	62.605	1735634.0
2017-01-13 15:00:00	MSFT	Stock	62.605	62.71	62.48	62.685	3868277.0
2017-01-13 16:00:00	MSFT	Stock	62.7	62.7	62.58	62.64	3264960.0
2017-01-13 17:00:00	MSFT	Stock	62.68	62.75	62.67	62.7	55436.0
2017-01-13 18:00:00	MSFT	Stock	62.65	62.75	62.65	62.75	700.0
2017-01-13 19:00:00	MSFT	Stock	62.75	62.75	62.75	62.75	100.0
2017-01-13 07:00:00	NVDA	Stock	2.6013	2.6013	2.6	2.6	134600.0
2017-01-13 08:00:00	NVDA	Stock	2.6	2.6	2.5905	2.5935	585680.0
2017-01-13 09:00:00	NVDA	Stock	2.5925	2.625	2.5813	2.6155	83531120.0
2017-01-13 10:00:00	NVDA	Stock	2.6155	2.6198	2.598	2.5998	71233480.0
2017-01-13 11:00:00	NVDA	Stock	2.6007	2.6025	2.5878	2.5928	63701360.0
2017-01-13 12:00:00	NVDA	Stock	2.593	2.595	2.5775	2.5798	49409680.0
2017-01-13 13:00:00	NVDA	Stock	2.58	2.5933	2.58	2.5825	40235880.0
2017-01-13 14:00:00	NVDA	Stock	2.5825	2.5893	2.5765	2.5849	41194040.0
2017-01-13 15:00:00	NVDA	Stock	2.5848	2.5935	2.5782	2.5858	75900040.0
2017-01-13 16:00:00	NVDA	Stock	2.5832	2.5979	2.5828	2.5858	4444280.0
2017-01-13 17:00:00	NVDA	Stock	2.5853	2.5875	2.5845	2.5868	153000.0
2017-01-13 18:00:00	NVDA	Stock	2.587	2.5875	2.586	2.586	54400.0
2017-01-13 19:00:00	NVDA	Stock	2.586	2.5888	2.585	2.5888	90400.0
2017-01-13 06:00:00	AMZN	Stock	40.782	40.782	40.782	40.782	4000.0
2017-01-13 07:00:00	AMZN	Stock	40.7715	40.7875	40.753	40.775	31220.0
2017-01-13 08:00:00	AMZN	Stock	40.7965	40.7965	40.59	40.7	295640.0
2017-01-13 09:00:00	AMZN	Stock	40.73	40.8995	40.57	40.8507	16885200.0
2017-01-13 10:00:00	AMZN	Stock	40.8515	41.0312	40.75	40.9402	11950980.0
2017-01-13 11:00:00	AMZN	Stock	40.938	41.06	40.8835	41.0533	7636140.0
2017-01-13 12:00:00	AMZN	Stock	41.052	41.0825	40.8582	40.9955	8215600.0
2017-01-13 13:00:00	AMZN	Stock	40.998	41.0335	40.9355	40.9675	4834280.0
2017-01-13 14:00:00	AMZN	Stock	40.9725	41.0125	40.9108	40.9935	4937100.0
2017-01-13 15:00:00	AMZN	Stock	40.995	40.995	40.8125	40.862	9780540.0

> showing 50 of 47,675 rows — these rows as CSV

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