PREVIEW / futures_1hour / 2018-04-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	2873.72	2874.81	2871.54	2871.81	4010.0
2018-04-25 01:00:00	ES	Futures	2871.81	2873.45	2866.9	2869.08	4886.0
2018-04-25 02:00:00	ES	Futures	2869.36	2873.18	2868.81	2870.45	11282.0
2018-04-25 03:00:00	ES	Futures	2870.72	2878.63	2867.72	2874.81	19205.0
2018-04-25 04:00:00	ES	Futures	2874.54	2874.81	2862.81	2864.44	23187.0
2018-04-25 05:00:00	ES	Futures	2864.17	2868.81	2861.17	2868.26	18469.0
2018-04-25 06:00:00	ES	Futures	2868.26	2871.27	2860.9	2860.9	15388.0
2018-04-25 07:00:00	ES	Futures	2860.9	2868.54	2858.17	2868.26	37048.0
2018-04-25 08:00:00	ES	Futures	2868.26	2871.81	2864.99	2867.17	39941.0
2018-04-25 09:00:00	ES	Futures	2867.44	2875.09	2850.52	2852.98	312469.0
2018-04-25 10:00:00	ES	Futures	2852.98	2873.18	2851.62	2870.17	317025.0
2018-04-25 11:00:00	ES	Futures	2870.17	2876.18	2861.44	2861.71	187067.0
2018-04-25 12:00:00	ES	Futures	2861.44	2873.18	2859.8	2869.08	184785.0
2018-04-25 13:00:00	ES	Futures	2869.36	2878.91	2865.81	2875.9	146693.0
2018-04-25 14:00:00	ES	Futures	2875.9	2885.46	2867.72	2885.18	169451.0
2018-04-25 15:00:00	ES	Futures	2885.46	2886.55	2870.45	2880.54	222147.0
2018-04-25 16:00:00	ES	Futures	2880.82	2890.91	2880.27	2888.73	87015.0
2018-04-25 18:00:00	ES	Futures	2890.91	2898.01	2890.1	2893.92	13647.0
2018-04-25 19:00:00	ES	Futures	2894.19	2896.37	2892.28	2893.37	5111.0
2018-04-25 20:00:00	ES	Futures	2893.37	2897.74	2891.19	2896.37	8288.0
2018-04-25 21:00:00	ES	Futures	2896.37	2898.01	2892.83	2893.92	5967.0
2018-04-25 22:00:00	ES	Futures	2894.19	2895.55	2891.19	2891.46	4607.0
2018-04-25 23:00:00	ES	Futures	2891.46	2893.1	2890.64	2890.91	2574.0
2018-04-25 00:00:00	NQ	Futures	7702.75	7709.55	7698.91	7700.98	1143.0
2018-04-25 01:00:00	NQ	Futures	7701.27	7707.48	7684.72	7691.52	2240.0
2018-04-25 02:00:00	NQ	Futures	7692.11	7703.64	7690.04	7697.73	2944.0
2018-04-25 03:00:00	NQ	Futures	7698.02	7721.07	7687.38	7706.59	5604.0
2018-04-25 04:00:00	NQ	Futures	7706.89	7708.36	7663.74	7669.06	8816.0
2018-04-25 05:00:00	NQ	Futures	7669.06	7683.24	7654.87	7682.06	8706.0
2018-04-25 06:00:00	NQ	Futures	7681.77	7693.29	7666.1	7666.69	5839.0
2018-04-25 07:00:00	NQ	Futures	7666.99	7691.22	7654.87	7689.16	11675.0
2018-04-25 08:00:00	NQ	Futures	7689.45	7709.55	7678.52	7700.39	16659.0
2018-04-25 09:00:00	NQ	Futures	7700.09	7714.28	7615.27	7616.75	79825.0
2018-04-25 10:00:00	NQ	Futures	7616.75	7706.89	7600.2	7695.95	108350.0
2018-04-25 11:00:00	NQ	Futures	7695.36	7737.03	7674.67	7675.86	66535.0
2018-04-25 12:00:00	NQ	Futures	7675.86	7721.37	7664.63	7693.0	46023.0
2018-04-25 13:00:00	NQ	Futures	7693.59	7724.03	7682.65	7710.43	43225.0
2018-04-25 14:00:00	NQ	Futures	7710.43	7732.3	7672.01	7732.3	49992.0
2018-04-25 15:00:00	NQ	Futures	7732.3	7738.51	7678.52	7710.14	51240.0
2018-04-25 16:00:00	NQ	Futures	7710.14	7773.97	7708.07	7770.13	19997.0
2018-04-25 18:00:00	NQ	Futures	7782.25	7806.78	7782.25	7794.36	4807.0
2018-04-25 19:00:00	NQ	Futures	7794.07	7805.3	7790.52	7799.39	2177.0
2018-04-25 20:00:00	NQ	Futures	7799.68	7816.83	7792.89	7812.98	3234.0
2018-04-25 21:00:00	NQ	Futures	7813.28	7815.94	7795.84	7802.34	2803.0
2018-04-25 22:00:00	NQ	Futures	7802.64	7808.85	7797.62	7798.8	1734.0
2018-04-25 23:00:00	NQ	Futures	7799.39	7800.57	7792.3	7792.89	1263.0
2018-04-25 00:00:00	YM	Futures	26035.2	26053.7	26023.3	26026.5	1144.0
2018-04-25 01:00:00	YM	Futures	26026.5	26038.5	25982.0	26002.7	1758.0
2018-04-25 02:00:00	YM	Futures	26002.7	26030.9	25995.1	26009.2	2671.0
2018-04-25 03:00:00	YM	Futures	26010.3	26062.4	25978.8	26017.9	4284.0

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

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