PREVIEW / futures_1hour / 2017-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-17.parquet
  size:    44 KB
  rows:    1,328

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-17 00:00:00	ES	Futures	2599.23	2599.23	2597.86	2598.14	2763.0
2017-03-17 01:00:00	ES	Futures	2598.14	2598.96	2596.77	2597.04	4872.0
2017-03-17 02:00:00	ES	Futures	2597.04	2597.32	2595.4	2595.68	3116.0
2017-03-17 03:00:00	ES	Futures	2595.95	2596.77	2595.4	2595.95	6378.0
2017-03-17 04:00:00	ES	Futures	2595.95	2597.32	2595.13	2596.5	12208.0
2017-03-17 05:00:00	ES	Futures	2596.5	2598.41	2596.5	2597.86	10528.0
2017-03-17 06:00:00	ES	Futures	2597.59	2599.77	2597.04	2598.68	16864.0
2017-03-17 07:00:00	ES	Futures	2598.68	2600.32	2597.59	2598.41	20792.0
2017-03-17 08:00:00	ES	Futures	2598.41	2601.69	2597.32	2601.41	38634.0
2017-03-17 09:00:00	ES	Futures	2601.41	2602.51	2597.32	2598.41	197600.0
2017-03-17 10:00:00	ES	Futures	2598.68	2599.23	2595.4	2596.5	144724.0
2017-03-17 11:00:00	ES	Futures	2596.5	2597.04	2593.49	2597.04	126535.0
2017-03-17 12:00:00	ES	Futures	2597.04	2598.96	2596.77	2597.59	85971.0
2017-03-17 13:00:00	ES	Futures	2597.59	2600.32	2597.32	2599.23	63638.0
2017-03-17 14:00:00	ES	Futures	2599.5	2602.78	2599.23	2599.23	90118.0
2017-03-17 15:00:00	ES	Futures	2599.5	2600.32	2592.4	2592.67	268033.0
2017-03-17 16:00:00	ES	Futures	2592.67	2596.77	2592.4	2595.13	120205.0
2017-03-17 00:00:00	NQ	Futures	6460.4	6460.4	6458.01	6458.91	606.0
2017-03-17 01:00:00	NQ	Futures	6458.91	6461.0	6457.12	6457.72	904.0
2017-03-17 02:00:00	NQ	Futures	6457.72	6457.72	6453.84	6454.14	976.0
2017-03-17 03:00:00	NQ	Futures	6454.14	6457.42	6453.54	6454.44	1334.0
2017-03-17 04:00:00	NQ	Futures	6454.74	6458.01	6452.95	6456.23	2358.0
2017-03-17 05:00:00	NQ	Futures	6455.93	6461.29	6455.93	6460.7	1709.0
2017-03-17 06:00:00	NQ	Futures	6460.7	6465.77	6459.8	6463.38	2849.0
2017-03-17 07:00:00	NQ	Futures	6463.68	6466.06	6461.0	6462.19	2473.0
2017-03-17 08:00:00	NQ	Futures	6462.49	6469.05	6460.1	6468.15	5048.0
2017-03-17 09:00:00	NQ	Futures	6468.15	6468.15	6453.84	6458.61	29097.0
2017-03-17 10:00:00	NQ	Futures	6458.61	6460.4	6452.05	6456.23	16066.0
2017-03-17 11:00:00	NQ	Futures	6456.23	6458.61	6449.67	6458.31	14134.0
2017-03-17 12:00:00	NQ	Futures	6458.31	6463.08	6458.31	6462.19	9659.0
2017-03-17 13:00:00	NQ	Futures	6462.19	6466.96	6462.19	6464.28	8184.0
2017-03-17 14:00:00	NQ	Futures	6464.28	6469.94	6463.68	6463.98	9925.0
2017-03-17 15:00:00	NQ	Futures	6463.98	6465.77	6449.67	6449.67	24356.0
2017-03-17 16:00:00	NQ	Futures	6449.67	6458.01	6447.58	6450.86	7917.0
2017-03-17 00:00:00	YM	Futures	22699.8	22700.9	22682.4	22688.9	2207.0
2017-03-17 01:00:00	YM	Futures	22690.0	22703.1	22671.6	22678.1	3607.0
2017-03-17 02:00:00	YM	Futures	22678.1	22682.4	22667.2	22672.6	1111.0
2017-03-17 03:00:00	YM	Futures	22673.7	22683.5	22671.6	22675.9	1418.0
2017-03-17 04:00:00	YM	Futures	22677.0	22690.0	22670.5	22686.8	1708.0
2017-03-17 05:00:00	YM	Futures	22687.9	22697.6	22687.9	22693.3	1197.0
2017-03-17 06:00:00	YM	Futures	22693.3	22710.7	22687.9	22704.2	1909.0
2017-03-17 07:00:00	YM	Futures	22704.2	22719.4	22700.9	22708.5	2466.0
2017-03-17 08:00:00	YM	Futures	22709.6	22736.8	22700.9	22735.7	3914.0
2017-03-17 09:00:00	YM	Futures	22735.7	22745.5	22699.8	22708.5	14872.0
2017-03-17 10:00:00	YM	Futures	22709.6	22712.8	22681.3	22688.9	11474.0
2017-03-17 11:00:00	YM	Futures	22687.9	22692.2	22670.5	22687.9	9086.0
2017-03-17 12:00:00	YM	Futures	22687.9	22699.8	22686.8	22696.5	6075.0
2017-03-17 13:00:00	YM	Futures	22696.5	22717.2	22695.5	22713.9	6720.0
2017-03-17 14:00:00	YM	Futures	22715.0	22742.2	22711.8	22712.8	10199.0
2017-03-17 15:00:00	YM	Futures	22712.8	22719.4	22670.5	22670.5	16743.0

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

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