PREVIEW / futures_1hour / 2017-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-13.parquet
  size:    51 KB
  rows:    1,617

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-13 00:00:00	ES	Futures	2586.12	2586.4	2585.85	2585.85	517.0
2017-03-13 01:00:00	ES	Futures	2585.85	2586.67	2585.85	2586.4	762.0
2017-03-13 02:00:00	ES	Futures	2586.4	2588.03	2586.12	2587.49	844.0
2017-03-13 03:00:00	ES	Futures	2587.49	2588.03	2586.4	2586.94	2399.0
2017-03-13 04:00:00	ES	Futures	2586.94	2588.03	2585.3	2586.94	3631.0
2017-03-13 05:00:00	ES	Futures	2586.94	2587.49	2584.76	2585.58	2434.0
2017-03-13 06:00:00	ES	Futures	2585.58	2586.12	2584.49	2585.3	2304.0
2017-03-13 07:00:00	ES	Futures	2585.58	2587.49	2584.21	2586.67	4969.0
2017-03-13 08:00:00	ES	Futures	2586.67	2590.21	2586.4	2588.58	8511.0
2017-03-13 09:00:00	ES	Futures	2588.58	2591.3	2586.67	2586.67	24312.0
2017-03-13 10:00:00	ES	Futures	2586.94	2589.4	2586.12	2587.21	34483.0
2017-03-13 11:00:00	ES	Futures	2587.49	2588.85	2584.76	2588.85	24450.0
2017-03-13 12:00:00	ES	Futures	2588.85	2589.4	2585.85	2587.49	19809.0
2017-03-13 13:00:00	ES	Futures	2587.76	2588.3	2585.58	2586.94	13415.0
2017-03-13 14:00:00	ES	Futures	2587.21	2589.12	2586.12	2589.12	12166.0
2017-03-13 15:00:00	ES	Futures	2589.12	2591.3	2588.03	2590.21	38365.0
2017-03-13 16:00:00	ES	Futures	2590.21	2591.58	2589.67	2590.76	14645.0
2017-03-13 18:00:00	ES	Futures	2590.21	2591.03	2589.67	2590.21	784.0
2017-03-13 19:00:00	ES	Futures	2590.21	2590.49	2589.67	2589.94	377.0
2017-03-13 20:00:00	ES	Futures	2589.94	2589.94	2588.58	2589.12	829.0
2017-03-13 21:00:00	ES	Futures	2589.12	2589.4	2587.76	2588.85	1306.0
2017-03-13 22:00:00	ES	Futures	2588.58	2589.12	2588.3	2588.85	240.0
2017-03-13 23:00:00	ES	Futures	2588.85	2589.67	2588.85	2589.4	668.0
2017-03-13 00:00:00	NQ	Futures	6419.54	6420.44	6418.35	6418.95	139.0
2017-03-13 01:00:00	NQ	Futures	6419.25	6420.74	6419.25	6420.14	70.0
2017-03-13 02:00:00	NQ	Futures	6420.14	6424.62	6419.54	6424.02	175.0
2017-03-13 03:00:00	NQ	Futures	6424.32	6425.21	6421.04	6423.12	288.0
2017-03-13 04:00:00	NQ	Futures	6422.53	6424.32	6418.05	6422.23	610.0
2017-03-13 05:00:00	NQ	Futures	6421.63	6421.93	6416.26	6418.95	232.0
2017-03-13 06:00:00	NQ	Futures	6418.35	6420.44	6416.26	6419.84	228.0
2017-03-13 07:00:00	NQ	Futures	6420.14	6420.74	6416.86	6418.65	269.0
2017-03-13 08:00:00	NQ	Futures	6419.54	6424.32	6418.65	6422.53	955.0
2017-03-13 09:00:00	NQ	Futures	6422.53	6434.16	6420.44	6427.0	5422.0
2017-03-13 10:00:00	NQ	Futures	6427.0	6430.28	6421.63	6427.0	5798.0
2017-03-13 11:00:00	NQ	Futures	6426.7	6431.78	6424.32	6429.99	3468.0
2017-03-13 12:00:00	NQ	Futures	6430.28	6433.57	6424.32	6430.28	3338.0
2017-03-13 13:00:00	NQ	Futures	6429.99	6432.97	6427.6	6430.58	2991.0
2017-03-13 14:00:00	NQ	Futures	6431.18	6437.15	6429.39	6435.95	2803.0
2017-03-13 15:00:00	NQ	Futures	6436.25	6439.53	6433.27	6437.15	4377.0
2017-03-13 16:00:00	NQ	Futures	6436.85	6439.53	6435.06	6438.94	1646.0
2017-03-13 18:00:00	NQ	Futures	6437.15	6439.83	6436.25	6436.85	83.0
2017-03-13 19:00:00	NQ	Futures	6437.44	6438.34	6436.55	6437.44	53.0
2017-03-13 20:00:00	NQ	Futures	6436.55	6437.44	6435.36	6435.95	157.0
2017-03-13 21:00:00	NQ	Futures	6435.95	6437.44	6434.76	6436.55	156.0
2017-03-13 22:00:00	NQ	Futures	6435.95	6437.15	6435.65	6437.15	68.0
2017-03-13 23:00:00	NQ	Futures	6436.85	6438.34	6436.55	6436.55	73.0
2017-03-13 00:00:00	YM	Futures	22661.8	22662.9	22650.9	22653.1	562.0
2017-03-13 01:00:00	YM	Futures	22653.1	22660.7	22653.1	22659.6	291.0
2017-03-13 02:00:00	YM	Futures	22659.6	22674.8	22657.4	22670.5	409.0
2017-03-13 03:00:00	YM	Futures	22671.6	22675.9	22657.4	22665.0	794.0

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

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