PREVIEW / futures_1hour / 2017-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-23.parquet
  size:    52 KB
  rows:    1,609

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-10-23 00:00:00	ES	Futures	2817.11	2817.65	2815.19	2815.74	5846.0
2017-10-23 01:00:00	ES	Futures	2816.01	2816.56	2815.47	2816.29	2424.0
2017-10-23 02:00:00	ES	Futures	2816.01	2817.38	2816.01	2816.56	6178.0
2017-10-23 03:00:00	ES	Futures	2816.83	2817.11	2814.37	2815.74	20757.0
2017-10-23 04:00:00	ES	Futures	2815.74	2817.93	2814.37	2816.01	14475.0
2017-10-23 05:00:00	ES	Futures	2816.29	2819.84	2815.74	2819.29	23528.0
2017-10-23 06:00:00	ES	Futures	2819.02	2819.84	2818.47	2819.29	10755.0
2017-10-23 07:00:00	ES	Futures	2819.29	2819.84	2817.11	2817.93	15135.0
2017-10-23 08:00:00	ES	Futures	2817.65	2819.29	2816.83	2819.29	12307.0
2017-10-23 09:00:00	ES	Futures	2819.02	2819.84	2815.47	2817.38	119387.0
2017-10-23 10:00:00	ES	Futures	2817.65	2817.65	2814.1	2814.64	131375.0
2017-10-23 11:00:00	ES	Futures	2814.37	2816.29	2812.46	2814.1	88468.0
2017-10-23 12:00:00	ES	Futures	2814.1	2814.64	2812.73	2814.64	60772.0
2017-10-23 13:00:00	ES	Futures	2814.64	2814.92	2810.81	2812.18	78678.0
2017-10-23 14:00:00	ES	Futures	2812.18	2812.46	2808.35	2810.27	110872.0
2017-10-23 15:00:00	ES	Futures	2810.54	2810.54	2803.43	2805.07	357056.0
2017-10-23 16:00:00	ES	Futures	2805.07	2806.44	2802.88	2804.8	111563.0
2017-10-23 18:00:00	ES	Futures	2803.98	2806.16	2803.7	2805.89	5518.0
2017-10-23 19:00:00	ES	Futures	2805.62	2806.71	2805.34	2805.89	2953.0
2017-10-23 20:00:00	ES	Futures	2805.89	2807.26	2805.62	2806.44	6878.0
2017-10-23 21:00:00	ES	Futures	2806.44	2807.53	2805.62	2807.26	5435.0
2017-10-23 22:00:00	ES	Futures	2807.26	2808.35	2806.98	2807.53	4063.0
2017-10-23 23:00:00	ES	Futures	2807.81	2808.08	2806.98	2806.98	2979.0
2017-10-23 00:00:00	NQ	Futures	7271.24	7272.72	7265.29	7267.67	1154.0
2017-10-23 01:00:00	NQ	Futures	7267.67	7270.64	7265.29	7269.45	841.0
2017-10-23 02:00:00	NQ	Futures	7269.45	7273.02	7268.56	7271.24	1070.0
2017-10-23 03:00:00	NQ	Futures	7271.53	7272.43	7262.91	7268.86	2324.0
2017-10-23 04:00:00	NQ	Futures	7269.16	7278.67	7266.18	7273.02	2273.0
2017-10-23 05:00:00	NQ	Futures	7273.02	7284.32	7271.83	7282.84	2337.0
2017-10-23 06:00:00	NQ	Futures	7283.13	7284.62	7281.05	7283.13	1933.0
2017-10-23 07:00:00	NQ	Futures	7282.84	7284.32	7274.21	7276.59	2437.0
2017-10-23 08:00:00	NQ	Futures	7276.59	7285.22	7275.4	7284.32	2666.0
2017-10-23 09:00:00	NQ	Futures	7284.32	7285.81	7262.91	7265.59	26334.0
2017-10-23 10:00:00	NQ	Futures	7265.59	7267.67	7240.6	7247.15	51420.0
2017-10-23 11:00:00	NQ	Futures	7246.85	7253.69	7241.5	7249.53	20176.0
2017-10-23 12:00:00	NQ	Futures	7249.82	7262.02	7248.04	7261.72	17034.0
2017-10-23 13:00:00	NQ	Futures	7261.72	7262.61	7245.36	7249.53	15168.0
2017-10-23 14:00:00	NQ	Futures	7249.82	7253.99	7237.33	7243.58	22583.0
2017-10-23 15:00:00	NQ	Futures	7243.58	7243.87	7209.97	7220.38	54111.0
2017-10-23 16:00:00	NQ	Futures	7220.38	7223.06	7211.16	7216.22	9737.0
2017-10-23 18:00:00	NQ	Futures	7215.03	7220.38	7214.13	7218.0	1568.0
2017-10-23 19:00:00	NQ	Futures	7218.0	7222.16	7217.4	7220.97	861.0
2017-10-23 20:00:00	NQ	Futures	7220.97	7225.73	7218.89	7222.16	1526.0
2017-10-23 21:00:00	NQ	Futures	7222.46	7226.92	7219.78	7226.03	1446.0
2017-10-23 22:00:00	NQ	Futures	7226.03	7230.19	7225.44	7227.52	1415.0
2017-10-23 23:00:00	NQ	Futures	7228.11	7229.0	7223.06	7223.06	1056.0
2017-10-23 00:00:00	YM	Futures	25332.2	25335.4	25318.0	25323.5	657.0
2017-10-23 01:00:00	YM	Futures	25323.5	25328.9	25318.0	25325.6	645.0
2017-10-23 02:00:00	YM	Futures	25325.6	25339.8	25324.6	25337.6	1688.0
2017-10-23 03:00:00	YM	Futures	25337.6	25342.0	25310.4	25322.4	2890.0

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

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