PREVIEW / futures_1hour / 2017-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-14.parquet
  size:    44 KB
  rows:    1,298

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
2017-07-14 00:00:00	ES	Futures	2673.26	2674.08	2673.26	2673.53	1379.0
2017-07-14 01:00:00	ES	Futures	2673.53	2674.08	2673.26	2673.26	1828.0
2017-07-14 02:00:00	ES	Futures	2673.26	2673.8	2672.16	2672.71	6470.0
2017-07-14 03:00:00	ES	Futures	2672.98	2672.98	2670.52	2671.62	17549.0
2017-07-14 04:00:00	ES	Futures	2671.34	2672.16	2670.52	2671.07	7529.0
2017-07-14 05:00:00	ES	Futures	2671.07	2671.89	2669.98	2671.34	9075.0
2017-07-14 06:00:00	ES	Futures	2671.34	2673.26	2671.07	2672.98	9623.0
2017-07-14 07:00:00	ES	Futures	2673.26	2673.53	2672.16	2673.26	8308.0
2017-07-14 08:00:00	ES	Futures	2672.98	2677.63	2671.89	2677.36	44867.0
2017-07-14 09:00:00	ES	Futures	2677.36	2678.72	2672.44	2677.08	142434.0
2017-07-14 10:00:00	ES	Futures	2677.08	2679.0	2675.44	2678.18	105512.0
2017-07-14 11:00:00	ES	Futures	2678.18	2679.0	2676.26	2678.72	93109.0
2017-07-14 12:00:00	ES	Futures	2678.72	2683.37	2677.9	2682.28	90049.0
2017-07-14 13:00:00	ES	Futures	2682.0	2685.83	2681.73	2685.83	83620.0
2017-07-14 14:00:00	ES	Futures	2685.83	2687.2	2685.28	2685.56	82956.0
2017-07-14 15:00:00	ES	Futures	2685.56	2691.02	2684.19	2685.56	271667.0
2017-07-14 16:00:00	ES	Futures	2685.56	2687.2	2684.46	2686.92	81088.0
2017-07-14 00:00:00	NQ	Futures	6904.26	6906.64	6904.26	6906.04	227.0
2017-07-14 01:00:00	NQ	Futures	6906.34	6907.23	6902.47	6903.36	529.0
2017-07-14 02:00:00	NQ	Futures	6903.36	6904.55	6897.11	6899.79	945.0
2017-07-14 03:00:00	NQ	Futures	6900.09	6904.55	6893.24	6901.87	1933.0
2017-07-14 04:00:00	NQ	Futures	6901.58	6904.85	6898.9	6901.28	1072.0
2017-07-14 05:00:00	NQ	Futures	6901.58	6904.55	6895.62	6901.87	1175.0
2017-07-14 06:00:00	NQ	Futures	6901.58	6906.34	6900.68	6902.17	3337.0
2017-07-14 07:00:00	NQ	Futures	6902.17	6910.51	6901.28	6908.72	2077.0
2017-07-14 08:00:00	NQ	Futures	6908.42	6938.2	6903.96	6937.6	17219.0
2017-07-14 09:00:00	NQ	Futures	6937.9	6944.45	6919.14	6920.33	46568.0
2017-07-14 10:00:00	NQ	Futures	6920.63	6926.59	6910.21	6924.21	33588.0
2017-07-14 11:00:00	NQ	Futures	6924.5	6930.76	6919.14	6929.56	19645.0
2017-07-14 12:00:00	NQ	Futures	6929.56	6943.26	6926.88	6939.39	17696.0
2017-07-14 13:00:00	NQ	Futures	6939.39	6953.68	6937.9	6951.9	17328.0
2017-07-14 14:00:00	NQ	Futures	6952.19	6958.45	6950.71	6950.71	16207.0
2017-07-14 15:00:00	NQ	Futures	6951.0	6964.7	6951.0	6955.77	33100.0
2017-07-14 16:00:00	NQ	Futures	6955.47	6964.1	6953.98	6963.81	8394.0
2017-07-14 00:00:00	YM	Futures	23416.5	23419.8	23414.3	23416.5	264.0
2017-07-14 01:00:00	YM	Futures	23416.5	23419.8	23413.2	23415.4	266.0
2017-07-14 02:00:00	YM	Futures	23415.4	23416.5	23405.6	23407.8	924.0
2017-07-14 03:00:00	YM	Futures	23408.9	23410.0	23390.4	23401.3	2103.0
2017-07-14 04:00:00	YM	Futures	23400.2	23408.9	23393.7	23401.3	1890.0
2017-07-14 05:00:00	YM	Futures	23401.3	23404.5	23391.5	23402.4	1079.0
2017-07-14 06:00:00	YM	Futures	23401.3	23415.4	23399.1	23414.3	1323.0
2017-07-14 07:00:00	YM	Futures	23414.3	23416.5	23406.7	23410.0	828.0
2017-07-14 08:00:00	YM	Futures	23408.9	23429.6	23400.2	23428.5	4773.0
2017-07-14 09:00:00	YM	Futures	23427.4	23428.5	23369.7	23418.7	15830.0
2017-07-14 10:00:00	YM	Futures	23418.7	23427.4	23400.2	23420.9	11302.0
2017-07-14 11:00:00	YM	Futures	23420.9	23420.9	23388.2	23416.5	9254.0
2017-07-14 12:00:00	YM	Futures	23417.6	23488.4	23407.8	23465.5	11789.0
2017-07-14 13:00:00	YM	Futures	23466.6	23498.1	23463.3	23480.7	8030.0
2017-07-14 14:00:00	YM	Futures	23481.8	23503.6	23475.3	23482.9	5986.0
2017-07-14 15:00:00	YM	Futures	23482.9	23541.7	23482.9	23498.1	15716.0

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

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