PREVIEW / futures_1hour / 2018-12-13

all futures 1-hour files

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

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-12-13 00:00:00	ES	Futures	2898.14	2898.68	2892.7	2894.06	5132.0
2018-12-13 01:00:00	ES	Futures	2893.79	2901.13	2893.79	2899.23	5128.0
2018-12-13 02:00:00	ES	Futures	2899.23	2903.04	2896.51	2903.04	11253.0
2018-12-13 03:00:00	ES	Futures	2902.76	2905.76	2891.07	2891.89	27111.0
2018-12-13 04:00:00	ES	Futures	2891.61	2894.61	2886.99	2888.35	18841.0
2018-12-13 05:00:00	ES	Futures	2888.35	2892.97	2887.53	2888.08	14720.0
2018-12-13 06:00:00	ES	Futures	2888.08	2892.16	2880.46	2882.64	22496.0
2018-12-13 07:00:00	ES	Futures	2882.64	2890.25	2881.28	2888.08	23485.0
2018-12-13 08:00:00	ES	Futures	2888.08	2895.42	2887.81	2893.79	32669.0
2018-12-13 09:00:00	ES	Futures	2894.06	2903.85	2886.17	2886.99	179569.0
2018-12-13 10:00:00	ES	Futures	2887.26	2906.03	2878.56	2887.53	257719.0
2018-12-13 11:00:00	ES	Futures	2887.53	2895.97	2878.83	2881.82	246606.0
2018-12-13 12:00:00	ES	Futures	2881.82	2885.36	2873.93	2879.65	164443.0
2018-12-13 13:00:00	ES	Futures	2879.37	2888.89	2870.67	2878.01	164340.0
2018-12-13 14:00:00	ES	Futures	2877.74	2881.55	2869.31	2878.56	140840.0
2018-12-13 15:00:00	ES	Futures	2878.56	2889.71	2873.93	2882.64	209256.0
2018-12-13 16:00:00	ES	Futures	2882.37	2883.18	2875.84	2877.47	59547.0
2018-12-13 18:00:00	ES	Futures	2879.37	2880.73	2875.29	2879.1	5609.0
2018-12-13 19:00:00	ES	Futures	2879.1	2881.82	2870.67	2872.3	11504.0
2018-12-13 20:00:00	ES	Futures	2872.3	2872.3	2856.8	2860.06	21823.0
2018-12-13 21:00:00	ES	Futures	2860.33	2860.88	2854.35	2860.06	11420.0
2018-12-13 22:00:00	ES	Futures	2859.79	2863.05	2858.7	2862.24	6233.0
2018-12-13 23:00:00	ES	Futures	2862.24	2863.05	2857.07	2857.34	4664.0
2018-12-13 00:00:00	NQ	Futures	7990.46	7991.34	7974.63	7978.73	3163.0
2018-12-13 01:00:00	NQ	Futures	7978.14	8004.25	7977.56	8000.14	3527.0
2018-12-13 02:00:00	NQ	Futures	8000.44	8011.29	7987.82	8009.53	5182.0
2018-12-13 03:00:00	NQ	Futures	8009.24	8022.44	7968.17	7972.57	11782.0
2018-12-13 04:00:00	NQ	Futures	7972.28	7982.25	7957.32	7964.07	7689.0
2018-12-13 05:00:00	NQ	Futures	7963.77	7980.78	7960.84	7961.72	5607.0
2018-12-13 06:00:00	NQ	Futures	7962.01	7974.04	7937.67	7947.64	8092.0
2018-12-13 07:00:00	NQ	Futures	7947.93	7971.11	7939.72	7962.6	8165.0
2018-12-13 08:00:00	NQ	Futures	7963.19	7991.34	7962.6	7988.41	15783.0
2018-12-13 09:00:00	NQ	Futures	7988.41	8016.57	7953.8	7962.89	76157.0
2018-12-13 10:00:00	NQ	Futures	7963.19	8023.32	7913.62	7947.64	96747.0
2018-12-13 11:00:00	NQ	Futures	7947.93	7971.69	7916.26	7923.59	91697.0
2018-12-13 12:00:00	NQ	Futures	7923.3	7933.27	7893.67	7918.02	61121.0
2018-12-13 13:00:00	NQ	Futures	7917.14	7957.32	7894.84	7920.66	54668.0
2018-12-13 14:00:00	NQ	Futures	7920.66	7930.04	7887.8	7922.12	59151.0
2018-12-13 15:00:00	NQ	Futures	7921.83	7958.79	7902.47	7940.01	52711.0
2018-12-13 16:00:00	NQ	Futures	7940.01	7942.07	7911.56	7914.5	11134.0
2018-12-13 18:00:00	NQ	Futures	7921.83	7928.57	7904.82	7921.54	2162.0
2018-12-13 19:00:00	NQ	Futures	7921.24	7932.09	7893.67	7900.42	3858.0
2018-12-13 20:00:00	NQ	Futures	7899.83	7899.83	7844.39	7859.65	7694.0
2018-12-13 21:00:00	NQ	Futures	7858.47	7859.35	7837.35	7856.42	3652.0
2018-12-13 22:00:00	NQ	Futures	7855.83	7866.39	7849.67	7863.75	1724.0
2018-12-13 23:00:00	NQ	Futures	7863.46	7866.39	7846.74	7847.91	1397.0
2018-12-13 00:00:00	YM	Futures	26784.4	26789.8	26745.3	26754.0	114.0
2018-12-13 01:00:00	YM	Futures	26752.9	26810.4	26751.8	26799.6	119.0
2018-12-13 02:00:00	YM	Futures	26787.6	26833.2	26777.9	26824.6	231.0
2018-12-13 03:00:00	YM	Futures	26831.1	26858.2	26719.2	26727.9	355.0

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

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