PREVIEW / futures_1hour / 2017-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-26.parquet
  size:    45 KB
  rows:    1,343

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-05-26 00:00:00	ES	Futures	2635.28	2635.83	2634.74	2635.56	1309.0
2017-05-26 01:00:00	ES	Futures	2635.56	2635.83	2634.46	2634.74	3691.0
2017-05-26 02:00:00	ES	Futures	2635.01	2636.1	2634.46	2635.83	7852.0
2017-05-26 03:00:00	ES	Futures	2635.83	2639.38	2635.01	2638.29	22575.0
2017-05-26 04:00:00	ES	Futures	2638.29	2639.38	2634.19	2634.74	20756.0
2017-05-26 05:00:00	ES	Futures	2634.46	2635.83	2633.1	2633.37	14797.0
2017-05-26 06:00:00	ES	Futures	2633.37	2635.01	2633.1	2634.19	10606.0
2017-05-26 07:00:00	ES	Futures	2634.19	2634.74	2631.19	2631.19	20866.0
2017-05-26 08:00:00	ES	Futures	2631.46	2634.74	2630.91	2634.46	28841.0
2017-05-26 09:00:00	ES	Futures	2634.19	2638.01	2634.19	2637.2	128632.0
2017-05-26 10:00:00	ES	Futures	2637.2	2639.11	2635.83	2636.1	147315.0
2017-05-26 11:00:00	ES	Futures	2635.83	2638.29	2635.01	2635.01	86740.0
2017-05-26 12:00:00	ES	Futures	2635.28	2638.29	2635.01	2637.47	42662.0
2017-05-26 13:00:00	ES	Futures	2637.74	2638.56	2636.1	2636.65	58869.0
2017-05-26 14:00:00	ES	Futures	2636.65	2638.01	2636.1	2637.2	42539.0
2017-05-26 15:00:00	ES	Futures	2637.47	2638.56	2636.1	2637.2	131577.0
2017-05-26 16:00:00	ES	Futures	2637.2	2638.29	2636.38	2638.29	58733.0
2017-05-26 00:00:00	NQ	Futures	6898.37	6899.86	6896.58	6898.96	396.0
2017-05-26 01:00:00	NQ	Futures	6898.67	6899.26	6894.79	6896.58	878.0
2017-05-26 02:00:00	NQ	Futures	6896.28	6898.37	6894.79	6897.18	1100.0
2017-05-26 03:00:00	NQ	Futures	6897.18	6906.12	6895.68	6904.03	2851.0
2017-05-26 04:00:00	NQ	Futures	6904.03	6906.12	6892.7	6893.0	3839.0
2017-05-26 05:00:00	NQ	Futures	6893.0	6896.88	6889.13	6890.02	2992.0
2017-05-26 06:00:00	NQ	Futures	6890.02	6893.9	6888.83	6890.91	1846.0
2017-05-26 07:00:00	NQ	Futures	6890.91	6893.0	6884.65	6885.25	3942.0
2017-05-26 08:00:00	NQ	Futures	6885.55	6893.6	6884.36	6892.41	5532.0
2017-05-26 09:00:00	NQ	Futures	6892.7	6901.35	6885.55	6900.16	32596.0
2017-05-26 10:00:00	NQ	Futures	6900.45	6909.1	6898.96	6900.16	28079.0
2017-05-26 11:00:00	NQ	Futures	6900.45	6903.44	6893.6	6893.9	17201.0
2017-05-26 12:00:00	NQ	Futures	6893.9	6901.65	6893.6	6899.26	8456.0
2017-05-26 13:00:00	NQ	Futures	6898.67	6900.45	6893.9	6897.77	11129.0
2017-05-26 14:00:00	NQ	Futures	6897.77	6902.24	6896.88	6900.45	8523.0
2017-05-26 15:00:00	NQ	Futures	6900.75	6905.82	6899.26	6904.93	17948.0
2017-05-26 16:00:00	NQ	Futures	6904.63	6912.68	6903.44	6911.49	6771.0
2017-05-26 00:00:00	YM	Futures	22873.7	22879.1	22868.3	22878.0	325.0
2017-05-26 01:00:00	YM	Futures	22877.0	22877.0	22862.8	22872.6	1045.0
2017-05-26 02:00:00	YM	Futures	22871.5	22881.3	22867.2	22879.1	1175.0
2017-05-26 03:00:00	YM	Futures	22879.1	22903.0	22872.6	22898.7	2698.0
2017-05-26 04:00:00	YM	Futures	22898.7	22905.2	22870.4	22871.5	3051.0
2017-05-26 05:00:00	YM	Futures	22872.6	22883.5	22865.0	22868.3	1815.0
2017-05-26 06:00:00	YM	Futures	22869.3	22877.0	22865.0	22871.5	1357.0
2017-05-26 07:00:00	YM	Futures	22870.4	22875.9	22844.3	22845.4	3340.0
2017-05-26 08:00:00	YM	Futures	22846.5	22874.8	22845.4	22874.8	4771.0
2017-05-26 09:00:00	YM	Futures	22874.8	22898.7	22859.6	22880.2	12789.0
2017-05-26 10:00:00	YM	Futures	22881.3	22894.3	22868.3	22869.3	10545.0
2017-05-26 11:00:00	YM	Futures	22870.4	22888.9	22868.3	22868.3	7466.0
2017-05-26 12:00:00	YM	Futures	22869.3	22895.4	22868.3	22892.2	3863.0
2017-05-26 13:00:00	YM	Futures	22892.2	22901.9	22883.5	22886.7	4106.0
2017-05-26 14:00:00	YM	Futures	22886.7	22894.3	22882.4	22890.0	4045.0
2017-05-26 15:00:00	YM	Futures	22891.1	22897.6	22878.0	22883.5	8416.0

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

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