PREVIEW / futures_1hour / 2017-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-13.parquet
  size:    52 KB
  rows:    1,610

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-13 00:00:00	ES	Futures	2668.88	2670.25	2668.88	2670.25	2511.0
2017-07-13 01:00:00	ES	Futures	2670.25	2670.52	2669.7	2670.25	3669.0
2017-07-13 02:00:00	ES	Futures	2669.98	2671.07	2669.43	2669.7	5861.0
2017-07-13 03:00:00	ES	Futures	2669.98	2673.26	2669.7	2672.16	23506.0
2017-07-13 04:00:00	ES	Futures	2672.16	2673.53	2671.07	2673.26	13518.0
2017-07-13 05:00:00	ES	Futures	2673.53	2674.9	2672.44	2672.71	13158.0
2017-07-13 06:00:00	ES	Futures	2672.98	2672.98	2671.34	2671.62	9512.0
2017-07-13 07:00:00	ES	Futures	2671.34	2671.62	2668.88	2669.7	17748.0
2017-07-13 08:00:00	ES	Futures	2669.43	2671.34	2669.43	2670.52	17259.0
2017-07-13 09:00:00	ES	Futures	2670.52	2672.98	2668.34	2672.44	114088.0
2017-07-13 10:00:00	ES	Futures	2672.16	2673.26	2666.7	2669.7	149141.0
2017-07-13 11:00:00	ES	Futures	2669.7	2674.35	2669.43	2673.26	103208.0
2017-07-13 12:00:00	ES	Futures	2673.26	2674.9	2672.71	2674.08	57738.0
2017-07-13 13:00:00	ES	Futures	2674.35	2674.9	2672.16	2673.53	62521.0
2017-07-13 14:00:00	ES	Futures	2673.26	2674.35	2671.07	2673.8	79659.0
2017-07-13 15:00:00	ES	Futures	2673.8	2675.44	2672.44	2673.53	164952.0
2017-07-13 16:00:00	ES	Futures	2673.8	2674.9	2672.44	2674.9	75489.0
2017-07-13 18:00:00	ES	Futures	2674.9	2674.9	2672.98	2673.8	3603.0
2017-07-13 19:00:00	ES	Futures	2673.53	2674.35	2673.53	2674.08	1261.0
2017-07-13 20:00:00	ES	Futures	2674.08	2674.62	2673.53	2674.62	2931.0
2017-07-13 21:00:00	ES	Futures	2674.35	2675.72	2673.8	2673.8	6911.0
2017-07-13 22:00:00	ES	Futures	2674.08	2674.35	2673.53	2673.8	2618.0
2017-07-13 23:00:00	ES	Futures	2673.53	2674.08	2673.26	2673.26	1298.0
2017-07-13 00:00:00	NQ	Futures	6903.96	6907.23	6903.96	6906.64	297.0
2017-07-13 01:00:00	NQ	Futures	6906.34	6907.83	6903.36	6904.85	689.0
2017-07-13 02:00:00	NQ	Futures	6904.55	6907.83	6903.06	6904.55	1293.0
2017-07-13 03:00:00	NQ	Futures	6904.55	6915.27	6903.06	6909.91	3731.0
2017-07-13 04:00:00	NQ	Futures	6910.21	6916.76	6906.34	6915.57	1908.0
2017-07-13 05:00:00	NQ	Futures	6915.57	6922.12	6913.78	6917.65	2820.0
2017-07-13 06:00:00	NQ	Futures	6917.65	6917.65	6907.83	6908.72	3547.0
2017-07-13 07:00:00	NQ	Futures	6908.42	6910.21	6900.39	6902.47	4693.0
2017-07-13 08:00:00	NQ	Futures	6901.87	6907.53	6897.11	6900.09	5423.0
2017-07-13 09:00:00	NQ	Futures	6899.49	6917.95	6884.31	6914.97	41042.0
2017-07-13 10:00:00	NQ	Futures	6914.68	6917.95	6880.73	6896.51	53971.0
2017-07-13 11:00:00	NQ	Futures	6896.22	6907.23	6890.26	6905.74	26962.0
2017-07-13 12:00:00	NQ	Futures	6905.45	6915.27	6902.17	6914.38	14052.0
2017-07-13 13:00:00	NQ	Futures	6914.38	6916.17	6888.77	6897.11	20187.0
2017-07-13 14:00:00	NQ	Futures	6897.41	6905.74	6883.71	6903.06	21051.0
2017-07-13 15:00:00	NQ	Futures	6902.77	6908.72	6896.51	6901.28	25001.0
2017-07-13 16:00:00	NQ	Futures	6901.28	6907.83	6899.49	6907.23	6249.0
2017-07-13 18:00:00	NQ	Futures	6907.23	6907.23	6902.17	6904.55	573.0
2017-07-13 19:00:00	NQ	Futures	6904.85	6908.42	6904.26	6906.64	322.0
2017-07-13 20:00:00	NQ	Futures	6906.64	6911.1	6905.15	6910.51	805.0
2017-07-13 21:00:00	NQ	Futures	6910.81	6914.08	6908.42	6909.91	1494.0
2017-07-13 22:00:00	NQ	Futures	6909.62	6911.1	6897.11	6903.06	1254.0
2017-07-13 23:00:00	NQ	Futures	6903.06	6905.45	6899.79	6903.96	734.0
2017-07-13 00:00:00	YM	Futures	23391.5	23400.2	23390.4	23400.2	366.0
2017-07-13 01:00:00	YM	Futures	23399.1	23400.2	23393.7	23395.8	443.0
2017-07-13 02:00:00	YM	Futures	23395.8	23402.4	23392.6	23393.7	819.0
2017-07-13 03:00:00	YM	Futures	23394.7	23415.4	23391.5	23405.6	2946.0

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

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