PREVIEW / futures_1hour / 2017-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-26.parquet
  size:    54 KB
  rows:    1,665

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-26 00:00:00	ES	Futures	2506.75	2507.02	2505.38	2505.93	4859.0
2017-01-26 01:00:00	ES	Futures	2505.93	2508.93	2505.66	2507.84	8030.0
2017-01-26 02:00:00	ES	Futures	2507.84	2508.11	2506.2	2507.02	8722.0
2017-01-26 03:00:00	ES	Futures	2507.29	2507.84	2505.38	2505.93	18992.0
2017-01-26 04:00:00	ES	Futures	2505.93	2506.47	2505.11	2505.93	8681.0
2017-01-26 05:00:00	ES	Futures	2506.2	2506.47	2504.29	2505.38	8280.0
2017-01-26 06:00:00	ES	Futures	2505.66	2505.66	2502.93	2504.29	9672.0
2017-01-26 07:00:00	ES	Futures	2504.56	2504.56	2502.66	2502.66	11746.0
2017-01-26 08:00:00	ES	Futures	2502.66	2504.02	2501.29	2503.2	22459.0
2017-01-26 09:00:00	ES	Futures	2503.2	2505.11	2500.47	2504.02	170317.0
2017-01-26 10:00:00	ES	Futures	2504.02	2505.66	2501.02	2502.11	210347.0
2017-01-26 11:00:00	ES	Futures	2502.11	2503.75	2500.47	2501.29	139126.0
2017-01-26 12:00:00	ES	Futures	2501.29	2502.38	2499.65	2501.02	78822.0
2017-01-26 13:00:00	ES	Futures	2501.29	2501.84	2498.02	2501.56	90992.0
2017-01-26 14:00:00	ES	Futures	2501.56	2503.75	2500.47	2502.11	81079.0
2017-01-26 15:00:00	ES	Futures	2502.38	2502.66	2498.84	2501.29	181229.0
2017-01-26 16:00:00	ES	Futures	2501.56	2504.02	2501.02	2503.2	68802.0
2017-01-26 18:00:00	ES	Futures	2502.93	2503.47	2501.29	2501.84	4908.0
2017-01-26 19:00:00	ES	Futures	2501.56	2501.84	2500.2	2500.47	2838.0
2017-01-26 20:00:00	ES	Futures	2500.47	2502.38	2499.65	2502.11	4047.0
2017-01-26 21:00:00	ES	Futures	2502.38	2502.66	2501.56	2501.84	1720.0
2017-01-26 22:00:00	ES	Futures	2501.56	2502.11	2501.56	2501.84	727.0
2017-01-26 23:00:00	ES	Futures	2501.84	2502.11	2501.29	2501.56	799.0
2017-01-26 00:00:00	NQ	Futures	6160.6	6162.09	6157.92	6159.41	1206.0
2017-01-26 01:00:00	NQ	Futures	6159.11	6167.46	6159.11	6165.08	1322.0
2017-01-26 02:00:00	NQ	Futures	6165.08	6165.97	6159.71	6162.99	1900.0
2017-01-26 03:00:00	NQ	Futures	6162.99	6165.38	6160.01	6160.9	2271.0
2017-01-26 04:00:00	NQ	Futures	6160.6	6161.2	6157.02	6159.71	1671.0
2017-01-26 05:00:00	NQ	Futures	6159.71	6160.01	6155.23	6157.62	1242.0
2017-01-26 06:00:00	NQ	Futures	6157.62	6157.62	6149.86	6153.74	2185.0
2017-01-26 07:00:00	NQ	Futures	6154.04	6155.83	6150.76	6151.06	2947.0
2017-01-26 08:00:00	NQ	Futures	6151.35	6152.55	6147.18	6150.46	3720.0
2017-01-26 09:00:00	NQ	Futures	6150.46	6161.2	6144.49	6152.85	28378.0
2017-01-26 10:00:00	NQ	Futures	6152.85	6155.83	6141.21	6143.3	28706.0
2017-01-26 11:00:00	NQ	Futures	6143.3	6151.95	6138.53	6146.28	21192.0
2017-01-26 12:00:00	NQ	Futures	6146.28	6152.55	6143.6	6149.56	9770.0
2017-01-26 13:00:00	NQ	Futures	6149.86	6153.44	6143.0	6148.97	10007.0
2017-01-26 14:00:00	NQ	Futures	6148.97	6158.51	6147.18	6151.95	11300.0
2017-01-26 15:00:00	NQ	Futures	6151.95	6153.14	6143.6	6148.07	18947.0
2017-01-26 16:00:00	NQ	Futures	6148.07	6157.02	6135.54	6141.21	17120.0
2017-01-26 18:00:00	NQ	Futures	6138.53	6140.91	6132.56	6138.23	2583.0
2017-01-26 19:00:00	NQ	Futures	6138.23	6138.53	6134.65	6138.53	870.0
2017-01-26 20:00:00	NQ	Futures	6138.53	6142.41	6135.54	6141.81	757.0
2017-01-26 21:00:00	NQ	Futures	6142.11	6142.41	6139.12	6141.21	553.0
2017-01-26 22:00:00	NQ	Futures	6141.21	6143.6	6140.91	6143.0	557.0
2017-01-26 23:00:00	NQ	Futures	6143.3	6145.99	6142.7	6143.9	360.0
2017-01-26 00:00:00	YM	Futures	21752.8	21753.9	21742.0	21745.2	1392.0
2017-01-26 01:00:00	YM	Futures	21745.2	21770.2	21744.1	21762.6	1591.0
2017-01-26 02:00:00	YM	Futures	21761.5	21762.6	21745.2	21759.3	2051.0
2017-01-26 03:00:00	YM	Futures	21758.2	21762.6	21745.2	21749.6	2721.0

> showing 50 of 1,665 rows — these rows as CSV

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