PREVIEW / futures_1hour / 2018-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-10.parquet
  size:    54 KB
  rows:    1,671

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-10 00:00:00	ES	Futures	2886.28	2891.73	2885.18	2890.64	8361.0
2018-04-10 01:00:00	ES	Futures	2890.37	2894.19	2886.0	2891.73	9284.0
2018-04-10 02:00:00	ES	Futures	2891.73	2899.65	2889.82	2898.01	17184.0
2018-04-10 03:00:00	ES	Futures	2898.01	2898.28	2882.73	2884.64	32686.0
2018-04-10 04:00:00	ES	Futures	2884.64	2892.83	2882.45	2887.64	20790.0
2018-04-10 05:00:00	ES	Futures	2887.64	2893.1	2886.82	2890.37	10489.0
2018-04-10 06:00:00	ES	Futures	2890.37	2892.55	2887.37	2889.55	11733.0
2018-04-10 07:00:00	ES	Futures	2889.55	2895.01	2887.91	2892.55	25413.0
2018-04-10 08:00:00	ES	Futures	2892.83	2893.1	2886.82	2889.55	35932.0
2018-04-10 09:00:00	ES	Futures	2889.82	2893.92	2880.27	2882.18	203075.0
2018-04-10 10:00:00	ES	Futures	2881.91	2903.47	2880.54	2898.56	246474.0
2018-04-10 11:00:00	ES	Futures	2898.28	2907.02	2889.82	2901.29	222901.0
2018-04-10 12:00:00	ES	Futures	2901.01	2902.38	2876.45	2891.73	249575.0
2018-04-10 13:00:00	ES	Futures	2891.73	2902.1	2888.73	2900.74	169518.0
2018-04-10 14:00:00	ES	Futures	2901.01	2906.2	2890.1	2904.01	180945.0
2018-04-10 15:00:00	ES	Futures	2904.29	2910.56	2898.28	2899.92	267484.0
2018-04-10 16:00:00	ES	Futures	2899.92	2900.74	2896.1	2897.74	80049.0
2018-04-10 18:00:00	ES	Futures	2897.74	2898.28	2893.92	2895.28	7148.0
2018-04-10 19:00:00	ES	Futures	2895.28	2897.19	2887.91	2891.46	8443.0
2018-04-10 20:00:00	ES	Futures	2891.46	2891.73	2882.18	2884.09	21034.0
2018-04-10 21:00:00	ES	Futures	2884.09	2888.73	2883.27	2883.55	12572.0
2018-04-10 22:00:00	ES	Futures	2883.55	2885.73	2883.0	2884.91	8833.0
2018-04-10 23:00:00	ES	Futures	2884.91	2886.0	2883.55	2884.64	5365.0
2018-04-10 00:00:00	NQ	Futures	7788.16	7807.66	7786.39	7799.68	4146.0
2018-04-10 01:00:00	NQ	Futures	7799.39	7805.59	7783.13	7797.91	4016.0
2018-04-10 02:00:00	NQ	Futures	7797.02	7831.31	7792.89	7821.85	7406.0
2018-04-10 03:00:00	NQ	Futures	7821.85	7824.8	7776.04	7779.0	8880.0
2018-04-10 04:00:00	NQ	Futures	7779.59	7812.69	7773.09	7791.7	7137.0
2018-04-10 05:00:00	NQ	Futures	7791.7	7809.44	7789.05	7800.57	3112.0
2018-04-10 06:00:00	NQ	Futures	7799.68	7802.05	7788.45	7791.41	5154.0
2018-04-10 07:00:00	NQ	Futures	7791.11	7801.75	7784.61	7794.36	7795.0
2018-04-10 08:00:00	NQ	Futures	7794.36	7795.25	7771.02	7786.98	10451.0
2018-04-10 09:00:00	NQ	Futures	7786.39	7801.16	7735.26	7748.85	63058.0
2018-04-10 10:00:00	NQ	Futures	7749.44	7819.48	7748.85	7797.02	67758.0
2018-04-10 11:00:00	NQ	Futures	7797.02	7821.85	7769.54	7795.55	63457.0
2018-04-10 12:00:00	NQ	Futures	7795.55	7799.39	7733.49	7776.93	61729.0
2018-04-10 13:00:00	NQ	Futures	7776.93	7816.53	7765.7	7815.05	41326.0
2018-04-10 14:00:00	NQ	Futures	7815.05	7833.37	7785.2	7831.31	57114.0
2018-04-10 15:00:00	NQ	Futures	7831.01	7863.22	7818.01	7833.37	68700.0
2018-04-10 16:00:00	NQ	Futures	7833.97	7835.15	7820.67	7831.01	10886.0
2018-04-10 18:00:00	NQ	Futures	7831.9	7834.56	7820.96	7824.8	1569.0
2018-04-10 19:00:00	NQ	Futures	7824.51	7829.53	7807.96	7815.94	2717.0
2018-04-10 20:00:00	NQ	Futures	7816.23	7818.89	7785.5	7794.66	7002.0
2018-04-10 21:00:00	NQ	Futures	7794.36	7810.32	7792.89	7793.18	5173.0
2018-04-10 22:00:00	NQ	Futures	7793.18	7800.87	7791.11	7798.21	2857.0
2018-04-10 23:00:00	NQ	Futures	7798.21	7802.34	7794.36	7797.62	1525.0
2018-04-10 00:00:00	YM	Futures	26360.0	26401.2	26343.7	26376.2	3442.0
2018-04-10 01:00:00	YM	Futures	26375.2	26406.7	26339.3	26384.9	4321.0
2018-04-10 02:00:00	YM	Futures	26384.9	26440.3	26370.8	26428.4	6586.0
2018-04-10 03:00:00	YM	Futures	26428.4	26433.8	26293.7	26314.3	9605.0

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

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