PREVIEW / futures_1hour / 2018-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-04.parquet
  size:    58 KB
  rows:    1,721

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-04-04 00:00:00	ES	Futures	2843.97	2846.43	2843.43	2846.16	2349.0
2018-04-04 01:00:00	ES	Futures	2846.16	2846.43	2839.88	2843.43	7091.0
2018-04-04 02:00:00	ES	Futures	2843.43	2844.79	2838.52	2839.88	11367.0
2018-04-04 03:00:00	ES	Futures	2839.88	2841.52	2820.23	2822.42	41080.0
2018-04-04 04:00:00	ES	Futures	2822.69	2823.78	2804.68	2814.5	73938.0
2018-04-04 05:00:00	ES	Futures	2814.23	2814.77	2808.22	2812.86	24436.0
2018-04-04 06:00:00	ES	Futures	2812.86	2813.14	2794.03	2804.13	50357.0
2018-04-04 07:00:00	ES	Futures	2803.86	2813.68	2803.86	2811.5	49456.0
2018-04-04 08:00:00	ES	Futures	2811.23	2818.05	2803.86	2813.95	64522.0
2018-04-04 09:00:00	ES	Futures	2813.95	2826.24	2806.86	2825.42	239065.0
2018-04-04 10:00:00	ES	Futures	2825.69	2839.88	2817.5	2838.52	328318.0
2018-04-04 11:00:00	ES	Futures	2838.52	2849.43	2830.88	2844.79	239574.0
2018-04-04 12:00:00	ES	Futures	2844.79	2859.53	2841.52	2854.07	202696.0
2018-04-04 13:00:00	ES	Futures	2854.35	2855.44	2839.88	2848.61	163604.0
2018-04-04 14:00:00	ES	Futures	2848.61	2875.09	2847.8	2873.45	219972.0
2018-04-04 15:00:00	ES	Futures	2873.45	2892.55	2871.54	2885.46	326001.0
2018-04-04 16:00:00	ES	Futures	2885.46	2890.64	2884.64	2887.37	81532.0
2018-04-04 18:00:00	ES	Futures	2888.19	2893.92	2886.28	2893.1	7898.0
2018-04-04 19:00:00	ES	Futures	2893.1	2896.1	2890.37	2895.01	9007.0
2018-04-04 20:00:00	ES	Futures	2895.01	2896.1	2887.37	2890.1	15531.0
2018-04-04 21:00:00	ES	Futures	2889.82	2898.28	2887.37	2897.74	14142.0
2018-04-04 22:00:00	ES	Futures	2897.74	2902.65	2896.65	2901.56	9100.0
2018-04-04 23:00:00	ES	Futures	2901.56	2902.38	2899.92	2902.1	3566.0
2018-04-04 00:00:00	NQ	Futures	7614.09	7618.52	7608.77	7617.05	1158.0
2018-04-04 01:00:00	NQ	Futures	7616.45	7618.23	7596.65	7602.56	2590.0
2018-04-04 02:00:00	NQ	Futures	7602.56	7607.0	7586.31	7591.63	4354.0
2018-04-04 03:00:00	NQ	Futures	7591.33	7596.65	7534.0	7542.87	10021.0
2018-04-04 04:00:00	NQ	Futures	7542.87	7547.0	7472.83	7505.63	20222.0
2018-04-04 05:00:00	NQ	Futures	7505.63	7511.84	7486.12	7507.7	8523.0
2018-04-04 06:00:00	NQ	Futures	7507.7	7510.06	7455.39	7489.38	16465.0
2018-04-04 07:00:00	NQ	Futures	7489.67	7522.77	7489.08	7514.5	18827.0
2018-04-04 08:00:00	NQ	Futures	7514.79	7531.93	7488.19	7528.09	19063.0
2018-04-04 09:00:00	NQ	Futures	7528.09	7564.44	7491.44	7558.23	77622.0
2018-04-04 10:00:00	NQ	Futures	7558.23	7600.5	7521.59	7596.36	98183.0
2018-04-04 11:00:00	NQ	Futures	7596.36	7656.94	7568.58	7642.46	79656.0
2018-04-04 12:00:00	NQ	Futures	7642.76	7691.52	7630.94	7658.42	60976.0
2018-04-04 13:00:00	NQ	Futures	7658.72	7664.04	7607.59	7640.39	51813.0
2018-04-04 14:00:00	NQ	Futures	7640.98	7724.91	7635.37	7720.19	67439.0
2018-04-04 15:00:00	NQ	Futures	7719.89	7792.3	7711.91	7765.11	67797.0
2018-04-04 16:00:00	NQ	Futures	7765.7	7787.27	7761.56	7779.88	12014.0
2018-04-04 18:00:00	NQ	Futures	7780.77	7796.14	7771.31	7794.07	2494.0
2018-04-04 19:00:00	NQ	Futures	7794.36	7805.3	7782.84	7801.16	3261.0
2018-04-04 20:00:00	NQ	Futures	7801.75	7806.78	7779.59	7790.23	6127.0
2018-04-04 21:00:00	NQ	Futures	7789.64	7820.37	7780.77	7817.12	6980.0
2018-04-04 22:00:00	NQ	Futures	7817.12	7829.53	7813.28	7825.4	3469.0
2018-04-04 23:00:00	NQ	Futures	7825.4	7827.17	7819.78	7825.4	1335.0
2018-04-04 00:00:00	YM	Futures	25957.0	25985.3	25952.7	25980.9	1181.0
2018-04-04 01:00:00	YM	Futures	25980.9	25984.2	25938.6	25959.2	2356.0
2018-04-04 02:00:00	YM	Futures	25960.3	25970.1	25914.7	25929.9	3480.0
2018-04-04 03:00:00	YM	Futures	25927.7	25941.8	25720.3	25748.5	9928.0

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

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