PREVIEW / futures_1hour / 2018-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-12.parquet
  size:    50 KB
  rows:    1,608

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-12 00:00:00	ES	Futures	3038.01	3040.74	3037.74	3040.47	800.0
2018-06-12 01:00:00	ES	Futures	3040.47	3040.74	3036.65	3039.1	3059.0
2018-06-12 02:00:00	ES	Futures	3039.1	3043.74	3038.83	3042.65	3650.0
2018-06-12 03:00:00	ES	Futures	3042.65	3043.47	3039.1	3040.2	5346.0
2018-06-12 04:00:00	ES	Futures	3039.92	3041.29	3034.46	3036.92	5955.0
2018-06-12 05:00:00	ES	Futures	3036.92	3038.01	3034.19	3035.28	5574.0
2018-06-12 06:00:00	ES	Futures	3035.28	3035.28	3033.37	3035.28	2827.0
2018-06-12 07:00:00	ES	Futures	3035.28	3038.56	3033.1	3038.29	3670.0
2018-06-12 08:00:00	ES	Futures	3038.56	3041.01	3035.56	3041.01	7325.0
2018-06-12 09:00:00	ES	Futures	3041.01	3042.65	3037.19	3038.56	33029.0
2018-06-12 10:00:00	ES	Futures	3038.56	3042.11	3037.74	3040.74	36445.0
2018-06-12 11:00:00	ES	Futures	3040.74	3044.56	3037.19	3044.02	25358.0
2018-06-12 12:00:00	ES	Futures	3044.29	3045.38	3041.56	3042.38	12178.0
2018-06-12 13:00:00	ES	Futures	3042.38	3043.47	3039.65	3042.92	15725.0
2018-06-12 14:00:00	ES	Futures	3042.65	3042.92	3033.37	3033.37	19989.0
2018-06-12 15:00:00	ES	Futures	3033.37	3042.65	3033.1	3041.83	37432.0
2018-06-12 16:00:00	ES	Futures	3041.83	3044.56	3038.56	3043.74	10671.0
2018-06-12 18:00:00	ES	Futures	3043.47	3044.56	3041.29	3043.47	1552.0
2018-06-12 19:00:00	ES	Futures	3043.74	3045.65	3043.47	3044.02	881.0
2018-06-12 20:00:00	ES	Futures	3043.74	3046.47	3043.74	3045.11	2364.0
2018-06-12 21:00:00	ES	Futures	3044.84	3047.56	3044.56	3044.84	2118.0
2018-06-12 22:00:00	ES	Futures	3044.56	3045.38	3043.47	3045.38	892.0
2018-06-12 23:00:00	ES	Futures	3045.11	3045.65	3044.84	3044.84	529.0
2018-06-12 00:00:00	NQ	Futures	8475.27	8480.59	8474.09	8478.82	227.0
2018-06-12 01:00:00	NQ	Futures	8479.11	8490.93	8471.43	8482.36	1087.0
2018-06-12 02:00:00	NQ	Futures	8482.07	8494.78	8482.07	8493.0	941.0
2018-06-12 03:00:00	NQ	Futures	8492.71	8496.25	8479.41	8482.66	828.0
2018-06-12 04:00:00	NQ	Futures	8481.77	8486.21	8463.15	8469.95	1157.0
2018-06-12 05:00:00	NQ	Futures	8469.66	8474.68	8463.15	8465.81	898.0
2018-06-12 06:00:00	NQ	Futures	8465.81	8468.18	8460.49	8467.29	589.0
2018-06-12 07:00:00	NQ	Futures	8468.18	8474.98	8462.86	8474.68	879.0
2018-06-12 08:00:00	NQ	Futures	8475.27	8487.68	8469.36	8487.68	1623.0
2018-06-12 09:00:00	NQ	Futures	8487.68	8504.23	8479.7	8482.07	8812.0
2018-06-12 10:00:00	NQ	Futures	8482.07	8500.98	8480.0	8500.1	8548.0
2018-06-12 11:00:00	NQ	Futures	8500.69	8520.78	8490.64	8518.12	7157.0
2018-06-12 12:00:00	NQ	Futures	8518.71	8522.26	8513.1	8517.83	3986.0
2018-06-12 13:00:00	NQ	Futures	8517.24	8530.83	8516.65	8529.06	4441.0
2018-06-12 14:00:00	NQ	Futures	8529.35	8529.35	8487.09	8487.98	5885.0
2018-06-12 15:00:00	NQ	Futures	8487.68	8525.22	8485.61	8523.15	8698.0
2018-06-12 16:00:00	NQ	Futures	8522.85	8534.08	8509.85	8530.54	3985.0
2018-06-12 18:00:00	NQ	Futures	8527.58	8537.92	8524.33	8533.79	341.0
2018-06-12 19:00:00	NQ	Futures	8534.08	8538.81	8532.01	8535.26	256.0
2018-06-12 20:00:00	NQ	Futures	8536.15	8545.31	8536.15	8541.17	470.0
2018-06-12 21:00:00	NQ	Futures	8541.17	8548.27	8537.92	8537.92	493.0
2018-06-12 22:00:00	NQ	Futures	8539.11	8539.99	8531.42	8539.4	269.0
2018-06-12 23:00:00	NQ	Futures	8539.4	8540.88	8536.15	8536.74	262.0
2018-06-12 00:00:00	YM	Futures	27564.4	27585.1	27563.3	27584.0	460.0
2018-06-12 01:00:00	YM	Futures	27584.0	27588.3	27538.3	27561.2	1230.0
2018-06-12 02:00:00	YM	Futures	27560.1	27616.6	27560.1	27604.6	2174.0
2018-06-12 03:00:00	YM	Futures	27604.6	27617.7	27569.9	27578.5	2335.0

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

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