PREVIEW / stock_1hour / 2017-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-01.parquet
  size:    1.1 MB
  rows:    49,477
  symbols: 3,101

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-01 04:00:00	AAPL	Stock	34.3125	34.4	34.3125	34.4	25412.0
2017-03-01 05:00:00	AAPL	Stock	34.3975	34.425	34.3975	34.4	11928.0
2017-03-01 06:00:00	AAPL	Stock	34.4	34.43	34.4	34.425	51296.0
2017-03-01 07:00:00	AAPL	Stock	34.425	34.4625	34.38	34.4475	171032.0
2017-03-01 08:00:00	AAPL	Stock	34.44	34.4975	34.4	34.4875	532244.0
2017-03-01 09:00:00	AAPL	Stock	34.4775	34.575	34.3988	34.5352	16272024.0
2017-03-01 10:00:00	AAPL	Stock	34.5375	34.755	34.5325	34.73	20064592.0
2017-03-01 11:00:00	AAPL	Stock	34.73	34.935	34.7175	34.9175	17538348.0
2017-03-01 12:00:00	AAPL	Stock	34.9175	34.9975	34.9135	34.9525	13369764.0
2017-03-01 13:00:00	AAPL	Stock	34.95	35.02	34.905	34.9425	18966748.0
2017-03-01 14:00:00	AAPL	Stock	34.9425	35.0375	34.88	35.0225	15277684.0
2017-03-01 15:00:00	AAPL	Stock	35.0242	35.025	34.935	34.9475	18614640.0
2017-03-01 16:00:00	AAPL	Stock	34.9475	34.96	34.93	34.9425	9888228.0
2017-03-01 17:00:00	AAPL	Stock	34.9425	34.9425	34.915	34.9325	72600.0
2017-03-01 18:00:00	AAPL	Stock	34.9375	34.9625	34.9325	34.9525	70392.0
2017-03-01 19:00:00	AAPL	Stock	34.9475	34.9975	34.9475	34.9975	68164.0
2017-03-01 04:00:00	MSFT	Stock	64.19	64.35	64.19	64.25	2058.0
2017-03-01 05:00:00	MSFT	Stock	64.25	64.25	64.25	64.25	148.0
2017-03-01 06:00:00	MSFT	Stock	64.15	64.15	64.15	64.15	2000.0
2017-03-01 07:00:00	MSFT	Stock	64.24	64.24	64.17	64.18	9370.0
2017-03-01 08:00:00	MSFT	Stock	64.24	64.25	63.98	64.22	50185.0
2017-03-01 09:00:00	MSFT	Stock	64.19	64.35	64.022	64.23	2619270.0
2017-03-01 10:00:00	MSFT	Stock	64.24	64.58	64.24	64.505	2848172.0
2017-03-01 11:00:00	MSFT	Stock	64.504	64.849	64.445	64.785	2530923.0
2017-03-01 12:00:00	MSFT	Stock	64.785	64.99	64.76	64.78	2779895.0
2017-03-01 13:00:00	MSFT	Stock	64.78	64.87	64.758	64.83	1816494.0
2017-03-01 14:00:00	MSFT	Stock	64.83	64.97	64.76	64.944	2795832.0
2017-03-01 15:00:00	MSFT	Stock	64.94	64.98	64.86	64.93	5453373.0
2017-03-01 16:00:00	MSFT	Stock	64.93	64.94	64.83	64.85	4013684.0
2017-03-01 17:00:00	MSFT	Stock	64.94	64.94	64.84	64.85	57004.0
2017-03-01 18:00:00	MSFT	Stock	64.85	64.89	64.85	64.85	16325.0
2017-03-01 19:00:00	MSFT	Stock	64.85	64.86	64.85	64.86	712.0
2017-03-01 05:00:00	NVDA	Stock	2.5625	2.5625	2.5625	2.5625	12840.0
2017-03-01 06:00:00	NVDA	Stock	2.5795	2.5795	2.575	2.575	8600.0
2017-03-01 07:00:00	NVDA	Stock	2.575	2.58	2.5675	2.5785	540400.0
2017-03-01 08:00:00	NVDA	Stock	2.5788	2.597	2.5662	2.5935	3978680.0
2017-03-01 09:00:00	NVDA	Stock	2.593	2.6093	2.5403	2.555	109347520.0
2017-03-01 10:00:00	NVDA	Stock	2.5552	2.5693	2.5278	2.5493	102544040.0
2017-03-01 11:00:00	NVDA	Stock	2.5485	2.5738	2.5462	2.5729	50667640.0
2017-03-01 12:00:00	NVDA	Stock	2.573	2.5813	2.56	2.5662	56984640.0
2017-03-01 13:00:00	NVDA	Stock	2.5672	2.571	2.5585	2.561	34139920.0
2017-03-01 14:00:00	NVDA	Stock	2.561	2.5705	2.556	2.5688	33831360.0
2017-03-01 15:00:00	NVDA	Stock	2.5689	2.575	2.5638	2.5695	67611320.0
2017-03-01 16:00:00	NVDA	Stock	2.5698	2.5748	2.5662	2.5662	23173840.0
2017-03-01 17:00:00	NVDA	Stock	2.5675	2.5712	2.5665	2.5712	363080.0
2017-03-01 18:00:00	NVDA	Stock	2.569	2.569	2.569	2.569	8000.0
2017-03-01 19:00:00	NVDA	Stock	2.5712	2.5712	2.5653	2.5712	130800.0
2017-03-01 06:00:00	AMZN	Stock	42.5355	42.536	42.425	42.425	14680.0
2017-03-01 07:00:00	AMZN	Stock	42.4325	42.481	42.4325	42.481	8340.0
2017-03-01 08:00:00	AMZN	Stock	42.4795	42.65	42.425	42.5855	491000.0

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

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