PREVIEW / futures_1hour / 2018-04-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	2922.57	2923.39	2922.3	2923.39	1482.0
2018-04-30 01:00:00	ES	Futures	2923.66	2926.39	2923.39	2925.3	4366.0
2018-04-30 02:00:00	ES	Futures	2925.03	2925.57	2922.85	2923.12	4149.0
2018-04-30 03:00:00	ES	Futures	2923.12	2925.57	2922.3	2923.39	7682.0
2018-04-30 04:00:00	ES	Futures	2923.39	2924.48	2922.85	2923.94	3864.0
2018-04-30 05:00:00	ES	Futures	2924.21	2927.48	2923.66	2927.21	6437.0
2018-04-30 06:00:00	ES	Futures	2926.94	2928.03	2924.48	2926.39	9632.0
2018-04-30 07:00:00	ES	Futures	2926.39	2926.67	2923.12	2925.57	10155.0
2018-04-30 08:00:00	ES	Futures	2925.85	2926.12	2920.93	2922.85	13666.0
2018-04-30 09:00:00	ES	Futures	2923.12	2927.48	2919.57	2923.12	135011.0
2018-04-30 10:00:00	ES	Futures	2922.85	2927.21	2916.57	2920.39	124541.0
2018-04-30 11:00:00	ES	Futures	2920.66	2923.12	2907.02	2909.2	155981.0
2018-04-30 12:00:00	ES	Futures	2909.47	2909.47	2897.46	2903.74	143446.0
2018-04-30 13:00:00	ES	Futures	2903.47	2908.65	2898.56	2906.74	112856.0
2018-04-30 14:00:00	ES	Futures	2906.74	2907.02	2895.28	2898.01	126445.0
2018-04-30 15:00:00	ES	Futures	2897.74	2902.38	2888.19	2889.0	265462.0
2018-04-30 16:00:00	ES	Futures	2888.73	2891.46	2887.37	2887.91	120696.0
2018-04-30 18:00:00	ES	Futures	2888.73	2889.55	2883.27	2884.64	10711.0
2018-04-30 19:00:00	ES	Futures	2884.91	2891.46	2884.37	2890.91	5525.0
2018-04-30 20:00:00	ES	Futures	2891.19	2893.64	2889.28	2891.73	6358.0
2018-04-30 21:00:00	ES	Futures	2892.01	2894.46	2891.46	2893.64	5465.0
2018-04-30 22:00:00	ES	Futures	2893.64	2893.92	2892.83	2893.1	1452.0
2018-04-30 23:00:00	ES	Futures	2893.1	2893.1	2891.73	2891.73	1630.0
2018-04-30 00:00:00	NQ	Futures	7916.42	7921.44	7914.65	7919.08	967.0
2018-04-30 01:00:00	NQ	Futures	7919.37	7930.9	7919.08	7927.95	1839.0
2018-04-30 02:00:00	NQ	Futures	7927.65	7930.31	7920.26	7921.15	1713.0
2018-04-30 03:00:00	NQ	Futures	7921.44	7928.24	7917.31	7922.33	2503.0
2018-04-30 04:00:00	NQ	Futures	7922.03	7925.29	7919.97	7923.22	1547.0
2018-04-30 05:00:00	NQ	Futures	7923.51	7935.04	7920.26	7932.38	2424.0
2018-04-30 06:00:00	NQ	Futures	7932.08	7934.45	7918.49	7928.24	2534.0
2018-04-30 07:00:00	NQ	Futures	7927.95	7928.54	7911.69	7920.26	3529.0
2018-04-30 08:00:00	NQ	Futures	7920.85	7922.33	7902.82	7906.96	4984.0
2018-04-30 09:00:00	NQ	Futures	7906.67	7929.72	7886.87	7914.94	47622.0
2018-04-30 10:00:00	NQ	Futures	7914.94	7941.54	7902.53	7912.87	55945.0
2018-04-30 11:00:00	NQ	Futures	7913.17	7920.26	7831.9	7843.72	58530.0
2018-04-30 12:00:00	NQ	Futures	7843.42	7844.01	7796.73	7823.62	61399.0
2018-04-30 13:00:00	NQ	Futures	7823.03	7846.38	7807.37	7845.79	32760.0
2018-04-30 14:00:00	NQ	Futures	7845.79	7846.08	7807.96	7823.62	38412.0
2018-04-30 15:00:00	NQ	Futures	7823.33	7850.81	7813.57	7814.76	47049.0
2018-04-30 16:00:00	NQ	Futures	7814.76	7821.26	7804.41	7805.89	12125.0
2018-04-30 18:00:00	NQ	Futures	7809.14	7815.94	7798.21	7805.0	2044.0
2018-04-30 19:00:00	NQ	Futures	7805.59	7826.58	7803.82	7824.8	1296.0
2018-04-30 20:00:00	NQ	Futures	7824.8	7829.83	7818.01	7822.44	3453.0
2018-04-30 21:00:00	NQ	Futures	7822.44	7829.24	7820.67	7827.46	2146.0
2018-04-30 22:00:00	NQ	Futures	7827.76	7828.06	7823.03	7824.21	644.0
2018-04-30 23:00:00	NQ	Futures	7823.92	7825.4	7820.08	7821.26	697.0
2018-04-30 00:00:00	YM	Futures	26428.4	26440.3	26427.3	26438.1	767.0
2018-04-30 01:00:00	YM	Futures	26439.2	26480.5	26438.1	26468.6	2561.0
2018-04-30 02:00:00	YM	Futures	26466.4	26470.7	26443.6	26458.8	2099.0
2018-04-30 03:00:00	YM	Futures	26456.6	26480.5	26447.9	26463.1	1865.0

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

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