PREVIEW / futures_1hour / 2018-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-05.parquet
  size:    55 KB
  rows:    1,680

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-05 00:00:00	ES	Futures	2995.44	2996.26	2994.62	2995.71	1628.0
2018-06-05 01:00:00	ES	Futures	2995.71	2996.53	2994.62	2995.17	2426.0
2018-06-05 02:00:00	ES	Futures	2995.44	2996.53	2994.89	2994.89	2898.0
2018-06-05 03:00:00	ES	Futures	2995.17	3000.35	2993.26	2999.53	14340.0
2018-06-05 04:00:00	ES	Futures	2999.81	3001.17	2998.44	3000.35	8201.0
2018-06-05 05:00:00	ES	Futures	3000.62	3003.9	2999.26	3003.63	12361.0
2018-06-05 06:00:00	ES	Futures	3003.63	3003.9	2999.53	3000.62	10607.0
2018-06-05 07:00:00	ES	Futures	3000.62	3002.26	2999.81	3000.35	8424.0
2018-06-05 08:00:00	ES	Futures	3000.35	3001.99	2995.71	2996.53	30956.0
2018-06-05 09:00:00	ES	Futures	2996.26	3001.44	2995.71	3001.44	99019.0
2018-06-05 10:00:00	ES	Futures	3001.17	3004.72	2997.62	3000.35	176630.0
2018-06-05 11:00:00	ES	Futures	3000.62	3000.9	2989.98	2993.26	157385.0
2018-06-05 12:00:00	ES	Futures	2993.53	2996.8	2989.98	2995.98	81551.0
2018-06-05 13:00:00	ES	Futures	2995.71	2999.53	2995.44	2998.44	56756.0
2018-06-05 14:00:00	ES	Futures	2998.17	3002.81	2996.53	3002.81	60342.0
2018-06-05 15:00:00	ES	Futures	3002.81	3002.81	2997.89	3001.44	139102.0
2018-06-05 16:00:00	ES	Futures	3001.44	3005.54	3001.17	3003.35	49166.0
2018-06-05 18:00:00	ES	Futures	3003.08	3004.72	3002.26	3003.08	4154.0
2018-06-05 19:00:00	ES	Futures	3003.08	3004.44	3001.99	3003.35	2050.0
2018-06-05 20:00:00	ES	Futures	3003.35	3005.26	3002.81	3004.44	3627.0
2018-06-05 21:00:00	ES	Futures	3004.44	3006.63	3004.17	3005.54	4782.0
2018-06-05 22:00:00	ES	Futures	3005.54	3006.63	3004.99	3005.81	1648.0
2018-06-05 23:00:00	ES	Futures	3005.81	3007.99	3005.26	3007.17	2573.0
2018-06-05 00:00:00	NQ	Futures	8446.31	8447.2	8442.17	8446.6	336.0
2018-06-05 01:00:00	NQ	Futures	8446.01	8449.56	8441.28	8444.24	884.0
2018-06-05 02:00:00	NQ	Futures	8443.94	8449.26	8441.28	8442.17	1144.0
2018-06-05 03:00:00	NQ	Futures	8442.47	8457.54	8438.62	8456.36	3923.0
2018-06-05 04:00:00	NQ	Futures	8456.65	8467.0	8456.06	8466.4	4762.0
2018-06-05 05:00:00	NQ	Futures	8466.7	8481.18	8462.27	8479.7	4371.0
2018-06-05 06:00:00	NQ	Futures	8479.7	8480.59	8468.18	8471.13	3492.0
2018-06-05 07:00:00	NQ	Futures	8470.84	8473.79	8465.52	8467.0	3264.0
2018-06-05 08:00:00	NQ	Futures	8467.0	8472.91	8455.47	8459.31	7987.0
2018-06-05 09:00:00	NQ	Futures	8459.31	8480.29	8456.65	8480.29	33638.0
2018-06-05 10:00:00	NQ	Futures	8479.7	8493.0	8468.77	8480.89	46415.0
2018-06-05 11:00:00	NQ	Futures	8481.18	8482.66	8440.1	8456.95	43070.0
2018-06-05 12:00:00	NQ	Futures	8457.24	8461.09	8440.99	8459.02	23910.0
2018-06-05 13:00:00	NQ	Futures	8459.31	8471.72	8456.95	8467.29	16657.0
2018-06-05 14:00:00	NQ	Futures	8467.29	8480.59	8459.9	8478.52	15032.0
2018-06-05 15:00:00	NQ	Futures	8478.82	8480.0	8464.34	8478.23	27065.0
2018-06-05 16:00:00	NQ	Futures	8478.23	8496.55	8477.64	8491.53	8053.0
2018-06-05 18:00:00	NQ	Futures	8489.75	8491.82	8484.14	8486.5	1139.0
2018-06-05 19:00:00	NQ	Futures	8486.21	8492.71	8484.14	8489.46	1182.0
2018-06-05 20:00:00	NQ	Futures	8489.16	8498.62	8486.5	8494.78	1903.0
2018-06-05 21:00:00	NQ	Futures	8495.07	8501.28	8494.48	8496.55	1622.0
2018-06-05 22:00:00	NQ	Futures	8496.25	8499.8	8495.07	8496.84	845.0
2018-06-05 23:00:00	NQ	Futures	8496.84	8505.12	8496.25	8504.53	1177.0
2018-06-05 00:00:00	YM	Futures	26925.8	26927.9	26914.9	26923.6	353.0
2018-06-05 01:00:00	YM	Futures	26922.5	26936.6	26914.9	26923.6	739.0
2018-06-05 02:00:00	YM	Futures	26924.7	26935.5	26906.2	26911.7	1005.0
2018-06-05 03:00:00	YM	Futures	26910.6	26958.4	26892.1	26950.8	2980.0

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

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