PREVIEW / futures_1hour / 2017-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-02.parquet
  size:    45 KB
  rows:    1,348

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-02 00:00:00	ES	Futures	2659.87	2660.96	2659.32	2660.14	4588.0
2017-06-02 01:00:00	ES	Futures	2660.14	2661.23	2659.32	2660.41	6948.0
2017-06-02 02:00:00	ES	Futures	2660.14	2661.23	2659.05	2660.14	13523.0
2017-06-02 03:00:00	ES	Futures	2660.14	2661.51	2658.23	2658.23	24527.0
2017-06-02 04:00:00	ES	Futures	2658.5	2659.32	2657.68	2659.05	13993.0
2017-06-02 05:00:00	ES	Futures	2658.77	2660.41	2658.23	2660.14	13656.0
2017-06-02 06:00:00	ES	Futures	2660.14	2662.87	2659.59	2662.6	17044.0
2017-06-02 07:00:00	ES	Futures	2662.6	2662.87	2659.87	2660.14	17182.0
2017-06-02 08:00:00	ES	Futures	2660.14	2660.69	2653.31	2656.86	102609.0
2017-06-02 09:00:00	ES	Futures	2656.86	2658.5	2651.67	2653.58	243906.0
2017-06-02 10:00:00	ES	Futures	2653.86	2659.32	2653.04	2658.23	204950.0
2017-06-02 11:00:00	ES	Futures	2658.23	2662.32	2657.13	2661.78	151064.0
2017-06-02 12:00:00	ES	Futures	2661.78	2662.6	2660.14	2661.78	127029.0
2017-06-02 13:00:00	ES	Futures	2661.78	2664.78	2660.69	2663.69	134650.0
2017-06-02 14:00:00	ES	Futures	2663.96	2664.51	2660.96	2663.14	119310.0
2017-06-02 15:00:00	ES	Futures	2663.14	2665.6	2660.41	2662.87	321670.0
2017-06-02 16:00:00	ES	Futures	2662.87	2663.96	2662.05	2662.87	119024.0
2017-06-02 00:00:00	NQ	Futures	6963.96	6966.94	6962.47	6964.26	904.0
2017-06-02 01:00:00	NQ	Futures	6964.56	6967.54	6962.77	6965.15	1084.0
2017-06-02 02:00:00	NQ	Futures	6965.15	6966.94	6961.87	6965.15	1538.0
2017-06-02 03:00:00	NQ	Futures	6965.45	6969.92	6961.28	6961.57	4051.0
2017-06-02 04:00:00	NQ	Futures	6961.87	6962.17	6957.4	6960.98	2722.0
2017-06-02 05:00:00	NQ	Futures	6960.98	6965.45	6960.08	6964.85	1476.0
2017-06-02 06:00:00	NQ	Futures	6965.15	6969.92	6963.66	6969.33	2363.0
2017-06-02 07:00:00	NQ	Futures	6969.33	6969.62	6963.66	6965.45	2273.0
2017-06-02 08:00:00	NQ	Futures	6965.15	6966.64	6950.54	6959.49	18101.0
2017-06-02 09:00:00	NQ	Futures	6959.49	6966.94	6948.16	6955.91	48148.0
2017-06-02 10:00:00	NQ	Futures	6956.21	6977.97	6953.82	6974.69	46404.0
2017-06-02 11:00:00	NQ	Futures	6974.69	6993.77	6974.1	6991.98	30320.0
2017-06-02 12:00:00	NQ	Futures	6991.69	6995.86	6989.0	6994.97	21241.0
2017-06-02 13:00:00	NQ	Futures	6994.97	7008.08	6993.47	7005.4	24825.0
2017-06-02 14:00:00	NQ	Futures	7005.4	7009.57	7001.82	7006.0	21091.0
2017-06-02 15:00:00	NQ	Futures	7006.29	7017.03	7004.8	7014.64	45423.0
2017-06-02 16:00:00	NQ	Futures	7014.64	7020.31	7012.85	7018.52	10396.0
2017-06-02 00:00:00	YM	Futures	23029.1	23036.7	23026.9	23030.2	613.0
2017-06-02 01:00:00	YM	Futures	23030.2	23047.6	23025.8	23036.7	1605.0
2017-06-02 02:00:00	YM	Futures	23036.7	23046.5	23026.9	23031.3	1838.0
2017-06-02 03:00:00	YM	Futures	23032.4	23049.8	23017.1	23018.2	4401.0
2017-06-02 04:00:00	YM	Futures	23019.3	23033.5	23011.7	23029.1	2406.0
2017-06-02 05:00:00	YM	Futures	23029.1	23041.1	23023.7	23040.0	1295.0
2017-06-02 06:00:00	YM	Futures	23040.0	23068.2	23035.6	23068.2	2367.0
2017-06-02 07:00:00	YM	Futures	23068.2	23069.3	23040.0	23042.1	2313.0
2017-06-02 08:00:00	YM	Futures	23043.2	23046.5	22971.5	23000.8	14030.0
2017-06-02 09:00:00	YM	Futures	23000.8	23016.1	22958.5	22976.9	22447.0
2017-06-02 10:00:00	YM	Futures	22975.9	23029.1	22970.4	23018.2	15625.0
2017-06-02 11:00:00	YM	Futures	23018.2	23060.6	23009.5	23059.5	10310.0
2017-06-02 12:00:00	YM	Futures	23058.4	23059.5	23041.1	23045.4	7493.0
2017-06-02 13:00:00	YM	Futures	23046.5	23061.7	23033.5	23054.1	6905.0
2017-06-02 14:00:00	YM	Futures	23053.0	23060.6	23029.1	23045.4	6216.0
2017-06-02 15:00:00	YM	Futures	23046.5	23057.4	23015.0	23031.3	13007.0

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

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