PREVIEW / futures_1hour / 2018-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-12.parquet
  size:    53 KB
  rows:    1,668

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-07-12 00:00:00	ES	Futures	3033.64	3035.27	3033.09	3033.64	4000.0
2018-07-12 01:00:00	ES	Futures	3033.37	3035.27	3033.09	3033.64	6324.0
2018-07-12 02:00:00	ES	Futures	3033.64	3035.27	3033.09	3035.0	7593.0
2018-07-12 03:00:00	ES	Futures	3034.73	3035.0	3031.46	3034.18	12848.0
2018-07-12 04:00:00	ES	Futures	3034.18	3035.27	3028.19	3032.0	16376.0
2018-07-12 05:00:00	ES	Futures	3032.0	3038.27	3031.73	3036.91	22094.0
2018-07-12 06:00:00	ES	Futures	3037.18	3041.81	3034.73	3041.54	17881.0
2018-07-12 07:00:00	ES	Futures	3041.54	3041.81	3038.54	3039.63	14853.0
2018-07-12 08:00:00	ES	Futures	3039.63	3042.36	3038.27	3041.27	27602.0
2018-07-12 09:00:00	ES	Futures	3041.0	3041.81	3032.82	3039.09	144577.0
2018-07-12 10:00:00	ES	Futures	3039.09	3045.63	3038.82	3040.72	146996.0
2018-07-12 11:00:00	ES	Futures	3041.0	3047.54	3039.91	3046.99	107585.0
2018-07-12 12:00:00	ES	Futures	3046.99	3051.35	3043.18	3049.99	103323.0
2018-07-12 13:00:00	ES	Futures	3050.26	3052.17	3046.45	3047.26	86491.0
2018-07-12 14:00:00	ES	Futures	3047.26	3048.9	3045.63	3047.54	56365.0
2018-07-12 15:00:00	ES	Futures	3047.81	3052.71	3044.27	3051.62	203586.0
2018-07-12 16:00:00	ES	Futures	3051.35	3051.62	3046.72	3049.72	74323.0
2018-07-12 18:00:00	ES	Futures	3049.99	3051.35	3048.63	3049.99	2936.0
2018-07-12 19:00:00	ES	Futures	3049.99	3055.16	3049.99	3054.07	6483.0
2018-07-12 20:00:00	ES	Futures	3054.07	3056.8	3053.26	3055.98	7630.0
2018-07-12 21:00:00	ES	Futures	3055.71	3056.53	3053.8	3055.44	5716.0
2018-07-12 22:00:00	ES	Futures	3055.71	3056.53	3054.89	3056.25	3980.0
2018-07-12 23:00:00	ES	Futures	3056.25	3058.43	3055.71	3057.89	6084.0
2018-07-12 00:00:00	NQ	Futures	8581.7	8589.36	8579.93	8580.82	1834.0
2018-07-12 01:00:00	NQ	Futures	8580.52	8591.71	8579.93	8585.23	2308.0
2018-07-12 02:00:00	NQ	Futures	8585.23	8587.0	8579.93	8582.29	2658.0
2018-07-12 03:00:00	NQ	Futures	8582.29	8582.29	8565.8	8575.81	5432.0
2018-07-12 04:00:00	NQ	Futures	8575.81	8577.87	8556.09	8569.04	4870.0
2018-07-12 05:00:00	NQ	Futures	8569.33	8584.64	8567.57	8579.93	4848.0
2018-07-12 06:00:00	NQ	Futures	8580.23	8589.06	8570.81	8588.18	4691.0
2018-07-12 07:00:00	NQ	Futures	8588.18	8589.94	8582.58	8587.29	3847.0
2018-07-12 08:00:00	NQ	Futures	8587.0	8597.89	8585.53	8594.95	7540.0
2018-07-12 09:00:00	NQ	Futures	8594.95	8619.68	8583.17	8617.62	44953.0
2018-07-12 10:00:00	NQ	Futures	8617.32	8651.18	8617.03	8635.28	46057.0
2018-07-12 11:00:00	NQ	Futures	8635.28	8672.09	8635.28	8670.03	39967.0
2018-07-12 12:00:00	NQ	Futures	8670.32	8678.27	8658.84	8674.15	26031.0
2018-07-12 13:00:00	NQ	Futures	8674.44	8685.92	8668.26	8670.91	23391.0
2018-07-12 14:00:00	NQ	Futures	8670.32	8685.63	8664.43	8684.16	18438.0
2018-07-12 15:00:00	NQ	Futures	8683.86	8699.47	8670.61	8697.11	37554.0
2018-07-12 16:00:00	NQ	Futures	8696.82	8698.88	8685.92	8695.35	9592.0
2018-07-12 18:00:00	NQ	Futures	8693.58	8700.65	8691.52	8695.35	1412.0
2018-07-12 19:00:00	NQ	Futures	8695.35	8713.89	8695.35	8710.36	3387.0
2018-07-12 20:00:00	NQ	Futures	8710.95	8717.43	8707.71	8717.13	3713.0
2018-07-12 21:00:00	NQ	Futures	8717.13	8719.19	8708.89	8714.78	3239.0
2018-07-12 22:00:00	NQ	Futures	8714.78	8720.37	8713.6	8719.49	2192.0
2018-07-12 23:00:00	NQ	Futures	8719.78	8726.85	8717.72	8725.08	2596.0
2018-07-12 00:00:00	YM	Futures	26944.7	26958.9	26938.2	26940.4	903.0
2018-07-12 01:00:00	YM	Futures	26940.4	26956.7	26938.2	26942.6	1534.0
2018-07-12 02:00:00	YM	Futures	26941.5	26971.9	26939.3	26965.4	2035.0
2018-07-12 03:00:00	YM	Futures	26965.4	26965.4	26930.6	26951.3	3461.0

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

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