PREVIEW / futures_1hour / 2018-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-06.parquet
  size:    54 KB
  rows:    1,660

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
2018-06-06 00:00:00	ES	Futures	3007.17	3009.9	3007.17	3009.36	4285.0
2018-06-06 01:00:00	ES	Futures	3009.08	3009.63	3008.27	3008.81	2714.0
2018-06-06 02:00:00	ES	Futures	3008.81	3010.72	3007.17	3008.27	7977.0
2018-06-06 03:00:00	ES	Futures	3008.27	3009.63	3006.08	3007.72	16153.0
2018-06-06 04:00:00	ES	Futures	3007.99	3008.54	3006.08	3006.9	7406.0
2018-06-06 05:00:00	ES	Futures	3006.9	3010.45	3006.63	3009.9	10405.0
2018-06-06 06:00:00	ES	Futures	3009.9	3010.45	3007.99	3009.63	9008.0
2018-06-06 07:00:00	ES	Futures	3009.36	3010.18	3007.17	3009.9	10728.0
2018-06-06 08:00:00	ES	Futures	3009.63	3010.18	3007.45	3007.45	14694.0
2018-06-06 09:00:00	ES	Futures	3007.17	3009.63	3002.53	3003.35	130286.0
2018-06-06 10:00:00	ES	Futures	3003.35	3005.81	2999.81	3005.54	160017.0
2018-06-06 11:00:00	ES	Futures	3005.54	3014.82	3005.26	3014.54	161644.0
2018-06-06 12:00:00	ES	Futures	3014.54	3014.82	3011.81	3013.45	74501.0
2018-06-06 13:00:00	ES	Futures	3013.45	3015.09	3010.99	3013.45	65977.0
2018-06-06 14:00:00	ES	Futures	3013.18	3022.46	3013.18	3020.82	120154.0
2018-06-06 15:00:00	ES	Futures	3020.82	3026.55	3019.18	3026.28	224089.0
2018-06-06 16:00:00	ES	Futures	3026.55	3029.01	3024.91	3027.64	83400.0
2018-06-06 18:00:00	ES	Futures	3027.37	3028.46	3025.46	3025.46	4276.0
2018-06-06 19:00:00	ES	Futures	3025.46	3026.0	3024.09	3025.19	2773.0
2018-06-06 20:00:00	ES	Futures	3025.19	3026.55	3024.37	3025.73	4452.0
2018-06-06 21:00:00	ES	Futures	3026.0	3027.37	3025.46	3026.82	5504.0
2018-06-06 22:00:00	ES	Futures	3027.1	3029.01	3026.28	3027.91	4558.0
2018-06-06 23:00:00	ES	Futures	3027.64	3029.01	3027.64	3028.73	2013.0
2018-06-06 00:00:00	NQ	Futures	8504.53	8515.17	8504.23	8513.39	1957.0
2018-06-06 01:00:00	NQ	Futures	8513.1	8514.28	8506.89	8507.78	1356.0
2018-06-06 02:00:00	NQ	Futures	8507.78	8511.03	8498.03	8500.69	2712.0
2018-06-06 03:00:00	NQ	Futures	8500.39	8506.01	8490.93	8496.84	4813.0
2018-06-06 04:00:00	NQ	Futures	8497.14	8500.1	8491.53	8495.37	3093.0
2018-06-06 05:00:00	NQ	Futures	8495.37	8505.71	8495.37	8503.94	2633.0
2018-06-06 06:00:00	NQ	Futures	8503.64	8503.94	8495.66	8497.73	2413.0
2018-06-06 07:00:00	NQ	Futures	8498.03	8500.39	8492.71	8497.14	2847.0
2018-06-06 08:00:00	NQ	Futures	8497.14	8498.91	8486.21	8486.8	4887.0
2018-06-06 09:00:00	NQ	Futures	8486.5	8496.25	8462.86	8464.93	43215.0
2018-06-06 10:00:00	NQ	Futures	8464.93	8469.36	8443.06	8467.0	59236.0
2018-06-06 11:00:00	NQ	Futures	8467.0	8498.91	8466.11	8498.32	43601.0
2018-06-06 12:00:00	NQ	Futures	8498.03	8501.87	8480.89	8489.46	23649.0
2018-06-06 13:00:00	NQ	Futures	8489.16	8494.18	8468.18	8479.41	21965.0
2018-06-06 14:00:00	NQ	Futures	8479.41	8513.39	8479.41	8508.37	24189.0
2018-06-06 15:00:00	NQ	Futures	8508.96	8528.17	8503.94	8528.17	34525.0
2018-06-06 16:00:00	NQ	Futures	8528.17	8537.63	8525.22	8531.72	9992.0
2018-06-06 18:00:00	NQ	Futures	8532.01	8532.9	8526.4	8527.88	1561.0
2018-06-06 19:00:00	NQ	Futures	8527.58	8528.76	8523.15	8527.28	1211.0
2018-06-06 20:00:00	NQ	Futures	8526.99	8534.08	8524.62	8530.83	1831.0
2018-06-06 21:00:00	NQ	Futures	8530.83	8540.88	8530.24	8536.45	2682.0
2018-06-06 22:00:00	NQ	Futures	8537.04	8544.72	8534.67	8539.7	1455.0
2018-06-06 23:00:00	NQ	Futures	8539.7	8543.24	8539.4	8542.06	755.0
2018-06-06 00:00:00	YM	Futures	27014.8	27045.2	27014.8	27032.2	1449.0
2018-06-06 01:00:00	YM	Futures	27032.2	27036.5	27024.6	27028.9	847.0
2018-06-06 02:00:00	YM	Futures	27027.9	27061.5	27026.8	27039.8	2830.0
2018-06-06 03:00:00	YM	Futures	27040.9	27059.4	27019.2	27038.7	3942.0

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

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