PREVIEW / futures_1hour / 2018-02-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-08.parquet
  size:    59 KB
  rows:    1,740

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-02-08 00:00:00	ES	Futures	2914.22	2924.34	2913.4	2921.6	10655.0
2018-02-08 01:00:00	ES	Futures	2921.6	2924.61	2919.14	2921.06	5660.0
2018-02-08 02:00:00	ES	Futures	2920.78	2926.52	2916.68	2921.33	14256.0
2018-02-08 03:00:00	ES	Futures	2921.6	2929.26	2919.42	2921.06	21244.0
2018-02-08 04:00:00	ES	Futures	2921.06	2927.89	2918.6	2921.6	20146.0
2018-02-08 05:00:00	ES	Futures	2921.6	2921.6	2910.12	2911.22	25193.0
2018-02-08 06:00:00	ES	Futures	2910.94	2915.32	2904.93	2908.76	19189.0
2018-02-08 07:00:00	ES	Futures	2908.76	2923.79	2908.21	2921.06	26681.0
2018-02-08 08:00:00	ES	Futures	2921.33	2935.0	2919.14	2933.63	62878.0
2018-02-08 09:00:00	ES	Futures	2933.63	2937.18	2911.22	2920.51	249910.0
2018-02-08 10:00:00	ES	Futures	2920.24	2927.07	2891.54	2898.37	345250.0
2018-02-08 11:00:00	ES	Futures	2898.64	2907.66	2884.7	2894.54	330734.0
2018-02-08 12:00:00	ES	Futures	2894.82	2899.19	2857.1	2868.58	373934.0
2018-02-08 13:00:00	ES	Futures	2868.58	2896.18	2860.92	2889.9	366889.0
2018-02-08 14:00:00	ES	Futures	2889.9	2893.72	2862.02	2868.3	248327.0
2018-02-08 15:00:00	ES	Futures	2868.58	2878.42	2817.47	2818.83	615404.0
2018-02-08 16:00:00	ES	Futures	2818.83	2844.52	2818.29	2839.6	207113.0
2018-02-08 18:00:00	ES	Futures	2835.78	2841.79	2824.03	2829.77	29950.0
2018-02-08 19:00:00	ES	Futures	2830.31	2848.62	2828.4	2842.06	20734.0
2018-02-08 20:00:00	ES	Futures	2842.34	2853.82	2837.42	2837.96	25928.0
2018-02-08 21:00:00	ES	Futures	2837.96	2839.33	2826.21	2832.77	22146.0
2018-02-08 22:00:00	ES	Futures	2832.5	2855.73	2832.22	2845.34	21387.0
2018-02-08 23:00:00	ES	Futures	2845.34	2851.08	2843.16	2847.53	6679.0
2018-02-08 00:00:00	NQ	Futures	7779.07	7810.22	7775.51	7793.9	2881.0
2018-02-08 01:00:00	NQ	Futures	7793.01	7803.39	7786.19	7791.83	1518.0
2018-02-08 02:00:00	NQ	Futures	7792.72	7806.36	7769.88	7796.57	4370.0
2018-02-08 03:00:00	NQ	Futures	7795.98	7826.53	7791.23	7803.99	5324.0
2018-02-08 04:00:00	NQ	Futures	7803.99	7822.08	7798.06	7804.88	2518.0
2018-02-08 05:00:00	NQ	Futures	7803.1	7803.1	7771.96	7776.4	4137.0
2018-02-08 06:00:00	NQ	Futures	7777.29	7788.27	7758.91	7768.4	5174.0
2018-02-08 07:00:00	NQ	Futures	7768.69	7815.85	7766.62	7809.03	8084.0
2018-02-08 08:00:00	NQ	Futures	7807.84	7852.04	7799.84	7830.98	19864.0
2018-02-08 09:00:00	NQ	Futures	7831.27	7847.59	7765.73	7791.83	63958.0
2018-02-08 10:00:00	NQ	Futures	7791.83	7813.48	7679.72	7708.48	84116.0
2018-02-08 11:00:00	NQ	Futures	7708.48	7738.44	7661.33	7707.89	67854.0
2018-02-08 12:00:00	NQ	Futures	7707.3	7723.61	7577.98	7614.76	77461.0
2018-02-08 13:00:00	NQ	Futures	7614.17	7703.74	7595.78	7687.13	71136.0
2018-02-08 14:00:00	NQ	Futures	7687.13	7697.21	7597.56	7617.73	52893.0
2018-02-08 15:00:00	NQ	Futures	7618.02	7647.09	7475.36	7476.84	88541.0
2018-02-08 16:00:00	NQ	Futures	7476.55	7530.53	7475.66	7517.18	31684.0
2018-02-08 18:00:00	NQ	Futures	7507.39	7523.71	7470.62	7489.89	6275.0
2018-02-08 19:00:00	NQ	Futures	7489.89	7542.69	7484.26	7531.12	7421.0
2018-02-08 20:00:00	NQ	Futures	7531.71	7551.59	7498.79	7500.87	9563.0
2018-02-08 21:00:00	NQ	Futures	7499.68	7504.72	7460.53	7484.26	8225.0
2018-02-08 22:00:00	NQ	Futures	7483.96	7554.85	7483.96	7518.37	6616.0
2018-02-08 23:00:00	NQ	Futures	7518.37	7538.83	7507.1	7508.28	3350.0
2018-02-08 00:00:00	YM	Futures	26872.0	26980.7	26864.4	26945.9	3210.0
2018-02-08 01:00:00	YM	Futures	26936.2	26972.0	26923.1	26930.7	1212.0
2018-02-08 02:00:00	YM	Futures	26928.5	26970.9	26877.5	26917.7	3219.0
2018-02-08 03:00:00	YM	Futures	26915.5	27000.3	26902.5	26918.8	3913.0

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

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