PREVIEW / stock_1hour / 2017-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-08.parquet
  size:    1.0 MB
  rows:    48,065
  symbols: 3,043

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-05-08 04:00:00	AAPL	Stock	37.295	37.295	37.2475	37.25	4532.0
2017-05-08 06:00:00	AAPL	Stock	37.24	37.335	37.24	37.335	13960.0
2017-05-08 07:00:00	AAPL	Stock	37.33	37.375	37.2875	37.2875	199016.0
2017-05-08 08:00:00	AAPL	Stock	37.2475	37.345	37.2	37.275	787608.0
2017-05-08 09:00:00	AAPL	Stock	37.275	37.7125	37.2575	37.6175	29428040.0
2017-05-08 10:00:00	AAPL	Stock	37.615	37.815	37.5625	37.7975	24881912.0
2017-05-08 11:00:00	AAPL	Stock	37.7925	38.02	37.78	38.015	22805048.0
2017-05-08 12:00:00	AAPL	Stock	38.015	38.3125	37.9925	38.1775	32646104.0
2017-05-08 13:00:00	AAPL	Stock	38.1825	38.425	38.1125	38.375	21937600.0
2017-05-08 14:00:00	AAPL	Stock	38.375	38.387	38.2525	38.3525	14936384.0
2017-05-08 15:00:00	AAPL	Stock	38.35	38.395	38.21	38.2525	21652768.0
2017-05-08 16:00:00	AAPL	Stock	38.2525	38.2675	38.225	38.245	10600276.0
2017-05-08 17:00:00	AAPL	Stock	38.25	38.2725	38.2475	38.2725	957680.0
2017-05-08 18:00:00	AAPL	Stock	38.2675	38.2875	38.2675	38.2875	106812.0
2017-05-08 19:00:00	AAPL	Stock	38.2875	38.3	38.2775	38.3	83628.0
2017-05-08 07:00:00	MSFT	Stock	69.24	69.24	69.24	69.24	100.0
2017-05-08 08:00:00	MSFT	Stock	69.1	69.1	68.92	69.0	3050.0
2017-05-08 09:00:00	MSFT	Stock	69.0	69.18	68.47	68.5	1975072.0
2017-05-08 10:00:00	MSFT	Stock	68.505	68.756	68.42	68.6	2497116.0
2017-05-08 11:00:00	MSFT	Stock	68.59	68.69	68.57	68.658	1299379.0
2017-05-08 12:00:00	MSFT	Stock	68.66	68.68	68.58	68.635	890724.0
2017-05-08 13:00:00	MSFT	Stock	68.635	68.71	68.58	68.705	1290366.0
2017-05-08 14:00:00	MSFT	Stock	68.7	68.795	68.66	68.75	1844834.0
2017-05-08 15:00:00	MSFT	Stock	68.755	68.95	68.67	68.94	4096793.0
2017-05-08 16:00:00	MSFT	Stock	68.94	68.94	68.623	68.85	3420139.0
2017-05-08 17:00:00	MSFT	Stock	68.85	68.85	68.84	68.85	2679.0
2017-05-08 18:00:00	MSFT	Stock	68.84	68.85	68.84	68.85	650.0
2017-05-08 06:00:00	NVDA	Stock	2.6	2.6	2.6	2.6	33560.0
2017-05-08 07:00:00	NVDA	Stock	2.6035	2.6112	2.6	2.606	99880.0
2017-05-08 08:00:00	NVDA	Stock	2.5975	2.605	2.5975	2.605	622640.0
2017-05-08 09:00:00	NVDA	Stock	2.605	2.61	2.5628	2.57	59015960.0
2017-05-08 10:00:00	NVDA	Stock	2.5698	2.5958	2.569	2.5919	58143880.0
2017-05-08 11:00:00	NVDA	Stock	2.592	2.5967	2.5848	2.586	29831680.0
2017-05-08 12:00:00	NVDA	Stock	2.5862	2.5918	2.5778	2.579	20864320.0
2017-05-08 13:00:00	NVDA	Stock	2.579	2.5845	2.5748	2.5825	24353400.0
2017-05-08 14:00:00	NVDA	Stock	2.5828	2.5849	2.573	2.5733	29949960.0
2017-05-08 15:00:00	NVDA	Stock	2.5733	2.574	2.5578	2.5693	72711080.0
2017-05-08 16:00:00	NVDA	Stock	2.5693	2.5698	2.5668	2.568	44472400.0
2017-05-08 17:00:00	NVDA	Stock	2.5688	2.5718	2.5675	2.5698	274920.0
2017-05-08 18:00:00	NVDA	Stock	2.574	2.5798	2.5712	2.5745	212600.0
2017-05-08 19:00:00	NVDA	Stock	2.5788	2.5788	2.5698	2.57	183640.0
2017-05-08 04:00:00	AMZN	Stock	46.894	46.894	46.894	46.894	2400.0
2017-05-08 05:00:00	AMZN	Stock	46.843	46.888	46.843	46.888	6000.0
2017-05-08 07:00:00	AMZN	Stock	46.8625	46.925	46.815	46.9	64040.0
2017-05-08 08:00:00	AMZN	Stock	46.9195	47.0	46.7075	46.95	712280.0
2017-05-08 09:00:00	AMZN	Stock	46.972	47.314	46.9315	47.1601	15724860.0
2017-05-08 10:00:00	AMZN	Stock	47.1688	47.215	47.055	47.078	7255980.0
2017-05-08 11:00:00	AMZN	Stock	47.071	47.112	46.9605	47.061	6802480.0
2017-05-08 12:00:00	AMZN	Stock	47.061	47.188	47.061	47.1855	4507240.0
2017-05-08 13:00:00	AMZN	Stock	47.1765	47.1798	47.114	47.1729	3106460.0

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

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