PREVIEW / stock_1hour / 2016-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-02.parquet
  size:    1.0 MB
  rows:    47,545
  symbols: 3,221

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-09-02 04:00:00	AAPL	Stock	26.7275	26.7275	26.7275	26.7275	400.0
2016-09-02 06:00:00	AAPL	Stock	26.745	26.77	26.7125	26.7125	34852.0
2016-09-02 07:00:00	AAPL	Stock	26.725	26.7625	26.7125	26.75	120260.0
2016-09-02 08:00:00	AAPL	Stock	26.7625	26.91	26.7125	26.895	1110316.0
2016-09-02 09:00:00	AAPL	Stock	26.8975	27.0	26.825	26.91	18956428.0
2016-09-02 10:00:00	AAPL	Stock	26.91	26.955	26.8075	26.8475	13767928.0
2016-09-02 11:00:00	AAPL	Stock	26.8448	26.87	26.75	26.815	9003292.0
2016-09-02 12:00:00	AAPL	Stock	26.8175	26.8225	26.705	26.7668	8751136.0
2016-09-02 13:00:00	AAPL	Stock	26.765	26.8378	26.725	26.825	8424508.0
2016-09-02 14:00:00	AAPL	Stock	26.825	26.89	26.8075	26.8875	8827980.0
2016-09-02 15:00:00	AAPL	Stock	26.8875	26.9425	26.885	26.9325	19119652.0
2016-09-02 16:00:00	AAPL	Stock	26.9338	26.9425	26.9	26.9125	7141408.0
2016-09-02 17:00:00	AAPL	Stock	26.9125	26.9325	26.9125	26.9275	72428.0
2016-09-02 18:00:00	AAPL	Stock	26.925	26.935	26.925	26.9325	35632.0
2016-09-02 19:00:00	AAPL	Stock	26.935	26.935	26.9275	26.9275	14272.0
2016-09-02 08:00:00	MSFT	Stock	57.6	57.65	57.57	57.62	12096.0
2016-09-02 09:00:00	MSFT	Stock	57.67	58.19	57.6	58.17	3568926.0
2016-09-02 10:00:00	MSFT	Stock	58.18	58.18	57.96	57.98	2451298.0
2016-09-02 11:00:00	MSFT	Stock	57.99	58.01	57.79	57.79	1594014.0
2016-09-02 12:00:00	MSFT	Stock	57.799	57.83	57.59	57.615	1743307.0
2016-09-02 13:00:00	MSFT	Stock	57.61	57.62	57.42	57.475	1653994.0
2016-09-02 14:00:00	MSFT	Stock	57.475	57.705	57.47	57.66	1595080.0
2016-09-02 15:00:00	MSFT	Stock	57.655	57.78	57.63	57.67	3072021.0
2016-09-02 16:00:00	MSFT	Stock	57.67	57.67	57.67	57.67	2178324.0
2016-09-02 17:00:00	MSFT	Stock	57.7	57.7	57.7	57.7	2000.0
2016-09-02 18:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	100.0
2016-09-02 19:00:00	MSFT	Stock	57.6	57.61	57.6	57.61	1150.0
2016-09-02 05:00:00	NVDA	Stock	1.5775	1.5775	1.5775	1.5775	4000.0
2016-09-02 08:00:00	NVDA	Stock	1.58	1.5865	1.5788	1.5848	1070720.0
2016-09-02 09:00:00	NVDA	Stock	1.5852	1.5855	1.5563	1.5758	59336560.0
2016-09-02 10:00:00	NVDA	Stock	1.5762	1.5798	1.5678	1.5678	49827400.0
2016-09-02 11:00:00	NVDA	Stock	1.5678	1.57	1.5592	1.5632	41299400.0
2016-09-02 12:00:00	NVDA	Stock	1.5635	1.564	1.554	1.5587	35367240.0
2016-09-02 13:00:00	NVDA	Stock	1.5585	1.5585	1.546	1.547	33842000.0
2016-09-02 14:00:00	NVDA	Stock	1.5471	1.5575	1.5455	1.5567	34456440.0
2016-09-02 15:00:00	NVDA	Stock	1.5566	1.5632	1.5555	1.5632	55854480.0
2016-09-02 16:00:00	NVDA	Stock	1.5632	1.5632	1.563	1.5632	1263240.0
2016-09-02 17:00:00	NVDA	Stock	1.565	1.5675	1.565	1.566	50000.0
2016-09-02 18:00:00	NVDA	Stock	1.5632	1.5632	1.5632	1.5632	4600.0
2016-09-02 19:00:00	NVDA	Stock	1.5632	1.5632	1.5628	1.5628	40000.0
2016-09-02 05:00:00	AMZN	Stock	38.5325	38.5325	38.5325	38.5325	10000.0
2016-09-02 08:00:00	AMZN	Stock	38.531	38.66	38.43	38.656	214420.0
2016-09-02 09:00:00	AMZN	Stock	38.66	38.775	38.6196	38.7168	7894180.0
2016-09-02 10:00:00	AMZN	Stock	38.717	38.8	38.7095	38.7235	8859900.0
2016-09-02 11:00:00	AMZN	Stock	38.731	38.779	38.667	38.687	3036180.0
2016-09-02 12:00:00	AMZN	Stock	38.687	38.696	38.6335	38.6613	2474240.0
2016-09-02 13:00:00	AMZN	Stock	38.657	38.664	38.585	38.6218	2368960.0
2016-09-02 14:00:00	AMZN	Stock	38.6212	38.6915	38.6063	38.6398	2694380.0
2016-09-02 15:00:00	AMZN	Stock	38.6445	38.682	38.6125	38.6225	6216500.0
2016-09-02 16:00:00	AMZN	Stock	38.622	38.63	38.6145	38.6145	4017340.0

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

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