PREVIEW / futures_1hour / 2018-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-03.parquet
  size:    54 KB
  rows:    1,685

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-01-03 00:00:00	ES	Futures	2947.84	2948.66	2947.57	2947.84	1419.0
2018-01-03 01:00:00	ES	Futures	2948.12	2948.39	2947.3	2947.57	1215.0
2018-01-03 02:00:00	ES	Futures	2947.57	2948.66	2947.3	2948.39	4240.0
2018-01-03 03:00:00	ES	Futures	2948.39	2949.76	2947.84	2949.21	13615.0
2018-01-03 04:00:00	ES	Futures	2949.48	2949.76	2948.39	2949.21	9965.0
2018-01-03 05:00:00	ES	Futures	2949.21	2950.3	2948.66	2950.03	12997.0
2018-01-03 06:00:00	ES	Futures	2949.76	2950.58	2948.66	2948.66	7391.0
2018-01-03 07:00:00	ES	Futures	2948.94	2949.21	2947.3	2948.12	10547.0
2018-01-03 08:00:00	ES	Futures	2948.12	2949.48	2947.3	2948.12	13005.0
2018-01-03 09:00:00	ES	Futures	2948.39	2956.04	2948.12	2955.5	149519.0
2018-01-03 10:00:00	ES	Futures	2955.5	2961.24	2955.22	2958.78	180446.0
2018-01-03 11:00:00	ES	Futures	2958.78	2960.42	2957.68	2958.5	85459.0
2018-01-03 12:00:00	ES	Futures	2958.5	2965.61	2958.5	2963.97	98171.0
2018-01-03 13:00:00	ES	Futures	2963.97	2964.52	2960.14	2960.69	69850.0
2018-01-03 14:00:00	ES	Futures	2960.96	2964.52	2960.14	2963.42	105280.0
2018-01-03 15:00:00	ES	Futures	2963.42	2967.52	2962.6	2965.61	200708.0
2018-01-03 16:00:00	ES	Futures	2965.34	2965.88	2960.96	2962.06	89909.0
2018-01-03 18:00:00	ES	Futures	2963.15	2963.42	2961.78	2963.42	7180.0
2018-01-03 19:00:00	ES	Futures	2963.42	2965.34	2962.33	2962.88	9181.0
2018-01-03 20:00:00	ES	Futures	2963.15	2963.42	2961.24	2962.06	6425.0
2018-01-03 21:00:00	ES	Futures	2962.33	2963.97	2961.78	2963.7	2752.0
2018-01-03 22:00:00	ES	Futures	2963.42	2965.88	2963.42	2965.06	5322.0
2018-01-03 23:00:00	ES	Futures	2965.06	2966.16	2965.06	2965.34	3390.0
2018-01-03 00:00:00	NQ	Futures	7736.36	7738.44	7735.47	7736.96	409.0
2018-01-03 01:00:00	NQ	Futures	7737.25	7738.44	7733.99	7738.44	540.0
2018-01-03 02:00:00	NQ	Futures	7737.85	7742.0	7736.96	7742.0	1234.0
2018-01-03 03:00:00	NQ	Futures	7742.0	7745.26	7738.44	7744.67	2112.0
2018-01-03 04:00:00	NQ	Futures	7744.37	7748.82	7741.7	7745.86	2375.0
2018-01-03 05:00:00	NQ	Futures	7745.86	7746.75	7742.0	7744.97	1523.0
2018-01-03 06:00:00	NQ	Futures	7744.97	7747.04	7743.19	7743.48	1303.0
2018-01-03 07:00:00	NQ	Futures	7743.48	7744.37	7738.14	7741.7	1865.0
2018-01-03 08:00:00	NQ	Futures	7741.41	7743.19	7735.47	7736.96	3098.0
2018-01-03 09:00:00	NQ	Futures	7736.66	7784.71	7736.66	7781.74	43601.0
2018-01-03 10:00:00	NQ	Futures	7782.04	7798.95	7779.07	7794.79	41879.0
2018-01-03 11:00:00	NQ	Futures	7794.79	7803.69	7789.16	7796.57	21210.0
2018-01-03 12:00:00	NQ	Futures	7796.57	7817.04	7796.28	7813.18	16764.0
2018-01-03 13:00:00	NQ	Futures	7813.18	7814.67	7796.57	7798.06	13915.0
2018-01-03 14:00:00	NQ	Futures	7797.76	7812.89	7794.79	7807.84	22605.0
2018-01-03 15:00:00	NQ	Futures	7807.55	7819.71	7802.8	7810.81	32445.0
2018-01-03 16:00:00	NQ	Futures	7810.81	7816.44	7805.17	7810.81	8427.0
2018-01-03 18:00:00	NQ	Futures	7810.81	7813.48	7806.36	7812.0	1549.0
2018-01-03 19:00:00	NQ	Futures	7811.7	7821.49	7811.7	7814.67	2243.0
2018-01-03 20:00:00	NQ	Futures	7814.07	7815.26	7807.25	7809.03	1385.0
2018-01-03 21:00:00	NQ	Futures	7809.33	7815.56	7807.25	7815.26	692.0
2018-01-03 22:00:00	NQ	Futures	7814.96	7820.89	7814.37	7819.11	1249.0
2018-01-03 23:00:00	NQ	Futures	7819.41	7823.86	7819.41	7820.89	934.0
2018-01-03 00:00:00	YM	Futures	26962.2	26965.5	26957.9	26961.2	291.0
2018-01-03 01:00:00	YM	Futures	26961.2	26965.5	26955.7	26957.9	398.0
2018-01-03 02:00:00	YM	Futures	26957.9	26973.1	26956.8	26961.2	1274.0
2018-01-03 03:00:00	YM	Futures	26961.2	26982.9	26961.2	26972.0	1244.0

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

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