PREVIEW / stock_1hour / 2014-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-02.parquet
  size:    1.0 MB
  rows:    49,255
  symbols: 3,579

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-09-02 04:00:00	AAPL	Stock	25.66	25.955	25.66	25.9225	189900.0
2014-09-02 05:00:00	AAPL	Stock	25.9225	25.9225	25.8625	25.88	103624.0
2014-09-02 06:00:00	AAPL	Stock	25.88	25.905	25.8	25.8	210116.0
2014-09-02 07:00:00	AAPL	Stock	25.8	25.8425	25.785	25.785	437824.0
2014-09-02 08:00:00	AAPL	Stock	25.8	25.9	25.625	25.8	1320384.0
2014-09-02 09:00:00	AAPL	Stock	25.8	25.8225	25.68	25.75	36044712.0
2014-09-02 10:00:00	AAPL	Stock	25.7475	25.935	25.7475	25.9125	36700524.0
2014-09-02 11:00:00	AAPL	Stock	25.91	25.9225	25.825	25.8263	21752568.0
2014-09-02 12:00:00	AAPL	Stock	25.8275	25.8875	25.805	25.835	19063552.0
2014-09-02 13:00:00	AAPL	Stock	25.8337	25.8675	25.775	25.8625	17741004.0
2014-09-02 14:00:00	AAPL	Stock	25.8622	25.8625	25.7425	25.801	21953188.0
2014-09-02 15:00:00	AAPL	Stock	25.8015	25.8275	25.775	25.825	25809176.0
2014-09-02 16:00:00	AAPL	Stock	25.825	25.8712	25.7925	25.8375	5371884.0
2014-09-02 17:00:00	AAPL	Stock	25.8375	25.84	25.82	25.825	1065840.0
2014-09-02 18:00:00	AAPL	Stock	25.8175	25.825	25.775	25.8125	229876.0
2014-09-02 19:00:00	AAPL	Stock	25.8125	25.82	25.7875	25.815	112684.0
2014-09-02 07:00:00	MSFT	Stock	45.49	45.49	45.46	45.46	1025.0
2014-09-02 08:00:00	MSFT	Stock	45.45	45.45	45.43	45.43	1389.0
2014-09-02 09:00:00	MSFT	Stock	45.36	45.46	44.96	44.99	3150884.0
2014-09-02 10:00:00	MSFT	Stock	45.0	45.05	44.88	44.944	3377524.0
2014-09-02 11:00:00	MSFT	Stock	44.95	44.97	44.86	44.92	2798772.0
2014-09-02 12:00:00	MSFT	Stock	44.92	44.966	44.85	44.88	2291516.0
2014-09-02 13:00:00	MSFT	Stock	44.88	44.98	44.86	44.96	1321846.0
2014-09-02 14:00:00	MSFT	Stock	44.96	44.99	44.93	44.93	1293895.0
2014-09-02 15:00:00	MSFT	Stock	44.94	45.09	44.9	45.09	4033113.0
2014-09-02 16:00:00	MSFT	Stock	45.09	45.091	44.919	44.97	2655222.0
2014-09-02 17:00:00	MSFT	Stock	45.0	45.05	45.0	45.01	3036.0
2014-09-02 18:00:00	MSFT	Stock	45.01	45.09	45.01	45.09	14750.0
2014-09-02 19:00:00	MSFT	Stock	45.04	45.04	44.98	45.03	5300.0
2014-09-02 08:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	20080.0
2014-09-02 09:00:00	NVDA	Stock	0.485	0.4875	0.4838	0.4862	23949120.0
2014-09-02 10:00:00	NVDA	Stock	0.486	0.4862	0.4829	0.4858	27682240.0
2014-09-02 11:00:00	NVDA	Stock	0.4858	0.4862	0.4843	0.4843	31272520.0
2014-09-02 12:00:00	NVDA	Stock	0.4845	0.4848	0.4835	0.484	8782680.0
2014-09-02 13:00:00	NVDA	Stock	0.4839	0.486	0.4835	0.4856	24424640.0
2014-09-02 14:00:00	NVDA	Stock	0.4855	0.4858	0.4845	0.4851	10723480.0
2014-09-02 15:00:00	NVDA	Stock	0.485	0.4875	0.485	0.4872	43180600.0
2014-09-02 16:00:00	NVDA	Stock	0.4875	0.4878	0.4873	0.4874	1564280.0
2014-09-02 17:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	24000.0
2014-09-02 07:00:00	AMZN	Stock	17.0	17.0	17.0	17.0	2000.0
2014-09-02 08:00:00	AMZN	Stock	17.0	17.0055	16.975	16.978	35620.0
2014-09-02 09:00:00	AMZN	Stock	17.004	17.09	16.9105	16.9365	9991240.0
2014-09-02 10:00:00	AMZN	Stock	16.938	16.9805	16.858	16.9745	7962880.0
2014-09-02 11:00:00	AMZN	Stock	16.975	17.0	16.95	16.961	3443300.0
2014-09-02 12:00:00	AMZN	Stock	16.961	16.9995	16.9525	16.97	2197000.0
2014-09-02 13:00:00	AMZN	Stock	16.9725	17.012	16.968	16.989	3193440.0
2014-09-02 14:00:00	AMZN	Stock	16.9885	17.0555	16.9805	17.0513	5223840.0
2014-09-02 15:00:00	AMZN	Stock	17.0515	17.125	17.0421	17.1195	7734520.0
2014-09-02 16:00:00	AMZN	Stock	17.119	17.123	17.111	17.111	1596880.0
2014-09-02 17:00:00	AMZN	Stock	17.095	17.095	17.095	17.095	16900.0

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

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