PREVIEW / futures_1hour / 2017-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-27.parquet
  size:    54 KB
  rows:    1,630

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-06-27 00:00:00	ES	Futures	2664.24	2664.24	2663.42	2663.69	1862.0
2017-06-27 01:00:00	ES	Futures	2663.96	2663.96	2662.32	2663.14	3011.0
2017-06-27 02:00:00	ES	Futures	2663.14	2663.14	2660.68	2661.23	9084.0
2017-06-27 03:00:00	ES	Futures	2660.96	2662.32	2659.59	2660.14	20665.0
2017-06-27 04:00:00	ES	Futures	2660.41	2661.23	2656.86	2660.68	34983.0
2017-06-27 05:00:00	ES	Futures	2660.68	2663.42	2660.41	2660.68	20701.0
2017-06-27 06:00:00	ES	Futures	2660.96	2661.78	2659.86	2660.96	8553.0
2017-06-27 07:00:00	ES	Futures	2660.96	2661.5	2659.04	2661.5	16203.0
2017-06-27 08:00:00	ES	Futures	2661.5	2662.05	2660.41	2661.5	16431.0
2017-06-27 09:00:00	ES	Futures	2661.23	2661.78	2656.04	2658.77	185188.0
2017-06-27 10:00:00	ES	Futures	2658.5	2664.24	2657.95	2662.87	212276.0
2017-06-27 11:00:00	ES	Futures	2663.14	2664.51	2662.05	2662.87	118753.0
2017-06-27 12:00:00	ES	Futures	2662.87	2663.69	2656.86	2657.95	109772.0
2017-06-27 13:00:00	ES	Futures	2657.68	2658.5	2647.02	2651.12	232949.0
2017-06-27 14:00:00	ES	Futures	2650.84	2654.12	2646.47	2651.66	184948.0
2017-06-27 15:00:00	ES	Futures	2651.66	2652.48	2642.1	2642.92	308946.0
2017-06-27 16:00:00	ES	Futures	2643.19	2647.02	2642.37	2643.46	122788.0
2017-06-27 18:00:00	ES	Futures	2642.64	2645.92	2642.37	2644.56	6818.0
2017-06-27 19:00:00	ES	Futures	2644.83	2645.38	2643.19	2643.46	3989.0
2017-06-27 20:00:00	ES	Futures	2643.46	2645.38	2642.92	2645.1	6530.0
2017-06-27 21:00:00	ES	Futures	2645.38	2646.74	2644.83	2645.38	7214.0
2017-06-27 22:00:00	ES	Futures	2645.1	2646.2	2640.73	2641.55	11655.0
2017-06-27 23:00:00	ES	Futures	2641.55	2644.28	2641.28	2643.74	5650.0
2017-06-27 00:00:00	NQ	Futures	6888.18	6888.48	6883.41	6885.2	315.0
2017-06-27 01:00:00	NQ	Futures	6885.5	6885.5	6872.99	6879.24	1051.0
2017-06-27 02:00:00	NQ	Futures	6879.54	6879.54	6867.93	6870.31	1677.0
2017-06-27 03:00:00	NQ	Futures	6870.01	6872.4	6859.59	6862.57	3543.0
2017-06-27 04:00:00	NQ	Futures	6861.98	6862.87	6840.83	6851.55	7482.0
2017-06-27 05:00:00	NQ	Futures	6851.55	6861.68	6850.07	6852.74	3904.0
2017-06-27 06:00:00	NQ	Futures	6852.74	6858.4	6848.58	6853.64	2541.0
2017-06-27 07:00:00	NQ	Futures	6853.64	6858.7	6846.19	6858.7	5220.0
2017-06-27 08:00:00	NQ	Futures	6858.4	6860.19	6848.87	6850.66	5750.0
2017-06-27 09:00:00	NQ	Futures	6850.36	6859.59	6830.12	6842.62	54801.0
2017-06-27 10:00:00	NQ	Futures	6842.62	6866.14	6841.43	6857.81	53748.0
2017-06-27 11:00:00	NQ	Futures	6857.81	6864.95	6843.51	6845.9	27518.0
2017-06-27 12:00:00	NQ	Futures	6846.19	6850.96	6814.04	6820.59	33733.0
2017-06-27 13:00:00	NQ	Futures	6820.29	6822.67	6775.33	6788.13	66901.0
2017-06-27 14:00:00	NQ	Futures	6788.43	6804.51	6770.86	6794.68	50291.0
2017-06-27 15:00:00	NQ	Futures	6794.39	6800.94	6758.06	6759.25	62527.0
2017-06-27 16:00:00	NQ	Futures	6759.25	6765.5	6751.81	6757.76	17870.0
2017-06-27 18:00:00	NQ	Futures	6757.46	6763.12	6748.23	6755.08	2179.0
2017-06-27 19:00:00	NQ	Futures	6755.38	6758.66	6750.91	6753.59	1158.0
2017-06-27 20:00:00	NQ	Futures	6753.59	6757.17	6749.43	6754.49	1496.0
2017-06-27 21:00:00	NQ	Futures	6754.49	6755.68	6747.04	6747.34	1683.0
2017-06-27 22:00:00	NQ	Futures	6747.64	6752.1	6730.96	6731.56	4596.0
2017-06-27 23:00:00	NQ	Futures	6731.86	6743.17	6729.18	6741.39	2777.0
2017-06-27 00:00:00	YM	Futures	23265.2	23266.3	23257.6	23260.9	268.0
2017-06-27 01:00:00	YM	Futures	23261.9	23261.9	23245.6	23251.1	1036.0
2017-06-27 02:00:00	YM	Futures	23250.0	23250.0	23230.4	23233.6	1977.0
2017-06-27 03:00:00	YM	Futures	23232.6	23242.4	23222.8	23226.0	2700.0

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

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