PREVIEW / futures_1hour / 2018-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-08.parquet
  size:    55 KB
  rows:    1,653

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-03-08 00:00:00	ES	Futures	2979.0	2979.55	2975.72	2976.54	3378.0
2018-03-08 01:00:00	ES	Futures	2976.54	2980.64	2975.72	2979.55	2715.0
2018-03-08 02:00:00	ES	Futures	2979.28	2983.65	2978.73	2979.55	9820.0
2018-03-08 03:00:00	ES	Futures	2979.55	2980.1	2974.63	2976.0	12710.0
2018-03-08 04:00:00	ES	Futures	2976.27	2980.1	2974.9	2976.82	7585.0
2018-03-08 05:00:00	ES	Futures	2976.82	2980.1	2976.54	2979.28	7410.0
2018-03-08 06:00:00	ES	Futures	2979.28	2983.38	2977.91	2983.1	8130.0
2018-03-08 07:00:00	ES	Futures	2983.38	2988.57	2982.83	2986.11	18742.0
2018-03-08 08:00:00	ES	Futures	2985.84	2987.75	2982.28	2984.2	24820.0
2018-03-08 09:00:00	ES	Futures	2984.47	2992.67	2984.2	2985.84	147206.0
2018-03-08 10:00:00	ES	Futures	2985.84	2989.39	2979.28	2983.92	158344.0
2018-03-08 11:00:00	ES	Futures	2983.92	2991.03	2980.37	2985.02	113137.0
2018-03-08 12:00:00	ES	Futures	2985.02	2986.38	2976.54	2982.01	119066.0
2018-03-08 13:00:00	ES	Futures	2982.28	2985.84	2976.0	2981.74	80359.0
2018-03-08 14:00:00	ES	Futures	2982.01	2990.21	2977.36	2989.66	67865.0
2018-03-08 15:00:00	ES	Futures	2989.66	2996.22	2982.01	2994.58	216123.0
2018-03-08 16:00:00	ES	Futures	2994.58	2995.68	2992.67	2993.76	57775.0
2018-03-08 18:00:00	ES	Futures	2991.85	2998.68	2991.85	2994.04	8651.0
2018-03-08 19:00:00	ES	Futures	2994.04	2997.86	2991.85	2995.95	9057.0
2018-03-08 20:00:00	ES	Futures	2995.68	3000.6	2995.68	2997.32	7955.0
2018-03-08 21:00:00	ES	Futures	2997.32	2997.32	2990.76	2993.22	7814.0
2018-03-08 22:00:00	ES	Futures	2993.22	2995.13	2991.58	2994.31	3713.0
2018-03-08 23:00:00	ES	Futures	2994.58	2994.86	2989.12	2993.22	5848.0
2018-03-08 00:00:00	NQ	Futures	8220.41	8223.08	8217.14	8219.52	2035.0
2018-03-08 01:00:00	NQ	Futures	8219.81	8228.12	8215.07	8224.86	1502.0
2018-03-08 02:00:00	NQ	Futures	8224.86	8243.54	8223.97	8237.61	5650.0
2018-03-08 03:00:00	NQ	Futures	8237.61	8239.98	8226.63	8229.3	4744.0
2018-03-08 04:00:00	NQ	Futures	8229.3	8238.2	8226.93	8229.3	2662.0
2018-03-08 05:00:00	NQ	Futures	8228.71	8242.35	8228.12	8242.35	2536.0
2018-03-08 06:00:00	NQ	Futures	8242.06	8250.36	8236.13	8249.18	4898.0
2018-03-08 07:00:00	NQ	Futures	8249.18	8263.71	8248.58	8258.96	9103.0
2018-03-08 08:00:00	NQ	Futures	8258.96	8264.01	8249.47	8253.62	9367.0
2018-03-08 09:00:00	NQ	Futures	8253.92	8270.23	8246.21	8251.85	46340.0
2018-03-08 10:00:00	NQ	Futures	8251.85	8263.41	8234.94	8246.21	56841.0
2018-03-08 11:00:00	NQ	Futures	8245.91	8273.5	8240.87	8261.63	42951.0
2018-03-08 12:00:00	NQ	Futures	8261.63	8264.9	8237.61	8255.11	37705.0
2018-03-08 13:00:00	NQ	Futures	8256.0	8261.93	8222.78	8240.57	30553.0
2018-03-08 14:00:00	NQ	Futures	8240.57	8264.3	8226.04	8260.74	28307.0
2018-03-08 15:00:00	NQ	Futures	8260.74	8272.31	8231.97	8265.79	47578.0
2018-03-08 16:00:00	NQ	Futures	8266.38	8277.65	8263.71	8271.72	9291.0
2018-03-08 18:00:00	NQ	Futures	8271.42	8285.06	8266.08	8276.17	1994.0
2018-03-08 19:00:00	NQ	Futures	8276.17	8282.99	8265.49	8278.24	3871.0
2018-03-08 20:00:00	NQ	Futures	8277.35	8296.93	8277.06	8286.84	3589.0
2018-03-08 21:00:00	NQ	Futures	8287.14	8287.14	8267.27	8275.28	2204.0
2018-03-08 22:00:00	NQ	Futures	8274.68	8282.69	8271.12	8278.54	1007.0
2018-03-08 23:00:00	NQ	Futures	8277.95	8279.73	8262.82	8274.39	1835.0
2018-03-08 00:00:00	YM	Futures	26967.7	26970.9	26932.9	26939.4	1558.0
2018-03-08 01:00:00	YM	Futures	26939.4	26972.0	26923.1	26960.1	1257.0
2018-03-08 02:00:00	YM	Futures	26961.2	26998.1	26950.3	26959.0	3300.0
2018-03-08 03:00:00	YM	Futures	26960.1	26961.2	26885.1	26898.1	6122.0

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

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