PREVIEW / futures_1hour / 2017-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-02.parquet
  size:    53 KB
  rows:    1,644

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-02 00:00:00	ES	Futures	2756.1	2757.2	2756.1	2756.1	1575.0
2017-10-02 01:00:00	ES	Futures	2755.83	2757.2	2755.83	2756.65	7225.0
2017-10-02 02:00:00	ES	Futures	2756.65	2757.2	2755.28	2755.28	7595.0
2017-10-02 03:00:00	ES	Futures	2755.56	2756.65	2755.01	2755.28	15405.0
2017-10-02 04:00:00	ES	Futures	2755.28	2756.1	2754.74	2755.01	12139.0
2017-10-02 05:00:00	ES	Futures	2755.01	2756.92	2755.01	2756.1	7730.0
2017-10-02 06:00:00	ES	Futures	2756.1	2758.02	2755.83	2757.74	10226.0
2017-10-02 07:00:00	ES	Futures	2758.02	2758.84	2756.65	2758.02	12283.0
2017-10-02 08:00:00	ES	Futures	2758.02	2758.29	2755.56	2755.83	17473.0
2017-10-02 09:00:00	ES	Futures	2755.83	2759.93	2754.74	2759.66	154421.0
2017-10-02 10:00:00	ES	Futures	2759.66	2763.76	2758.56	2759.93	187073.0
2017-10-02 11:00:00	ES	Futures	2760.21	2761.03	2757.2	2757.2	126856.0
2017-10-02 12:00:00	ES	Futures	2757.47	2761.85	2756.38	2761.57	88496.0
2017-10-02 13:00:00	ES	Futures	2761.57	2762.67	2760.75	2762.39	66407.0
2017-10-02 14:00:00	ES	Futures	2762.12	2762.94	2761.03	2762.67	55400.0
2017-10-02 15:00:00	ES	Futures	2762.94	2764.86	2761.3	2764.58	205221.0
2017-10-02 16:00:00	ES	Futures	2764.31	2766.22	2763.76	2765.95	91163.0
2017-10-02 18:00:00	ES	Futures	2765.4	2765.95	2764.31	2764.58	3843.0
2017-10-02 19:00:00	ES	Futures	2764.31	2764.58	2763.76	2764.04	2196.0
2017-10-02 20:00:00	ES	Futures	2764.04	2764.31	2763.49	2764.04	5678.0
2017-10-02 21:00:00	ES	Futures	2763.76	2766.77	2763.76	2766.5	9661.0
2017-10-02 22:00:00	ES	Futures	2766.5	2767.32	2765.95	2766.5	7248.0
2017-10-02 23:00:00	ES	Futures	2766.77	2767.87	2766.5	2767.59	7473.0
2017-10-02 00:00:00	NQ	Futures	7126.4	7129.37	7125.8	7126.4	577.0
2017-10-02 01:00:00	NQ	Futures	7126.4	7129.37	7125.8	7128.48	835.0
2017-10-02 02:00:00	NQ	Futures	7128.77	7129.07	7123.72	7124.61	866.0
2017-10-02 03:00:00	NQ	Futures	7124.91	7127.29	7122.23	7122.53	1656.0
2017-10-02 04:00:00	NQ	Futures	7122.23	7125.21	7118.96	7119.26	1554.0
2017-10-02 05:00:00	NQ	Futures	7119.55	7128.48	7119.26	7126.99	1673.0
2017-10-02 06:00:00	NQ	Futures	7126.99	7134.13	7126.1	7132.94	2117.0
2017-10-02 07:00:00	NQ	Futures	7132.94	7136.8	7129.37	7134.43	2075.0
2017-10-02 08:00:00	NQ	Futures	7134.43	7135.32	7124.02	7127.88	3432.0
2017-10-02 09:00:00	NQ	Futures	7127.88	7143.94	7124.02	7142.46	39721.0
2017-10-02 10:00:00	NQ	Futures	7142.46	7149.59	7134.13	7138.29	43037.0
2017-10-02 11:00:00	NQ	Futures	7138.29	7143.05	7098.14	7098.14	42613.0
2017-10-02 12:00:00	NQ	Futures	7098.14	7115.09	7088.62	7114.5	39513.0
2017-10-02 13:00:00	NQ	Futures	7114.2	7118.07	7108.25	7114.5	21138.0
2017-10-02 14:00:00	NQ	Futures	7114.2	7124.91	7109.44	7116.28	18136.0
2017-10-02 15:00:00	NQ	Futures	7116.28	7121.93	7110.04	7119.55	31201.0
2017-10-02 16:00:00	NQ	Futures	7119.85	7121.04	7113.61	7121.04	7860.0
2017-10-02 18:00:00	NQ	Futures	7120.74	7121.34	7116.58	7117.47	771.0
2017-10-02 19:00:00	NQ	Futures	7117.18	7118.37	7115.99	7115.99	436.0
2017-10-02 20:00:00	NQ	Futures	7115.99	7117.18	7112.71	7115.69	1221.0
2017-10-02 21:00:00	NQ	Futures	7115.39	7127.29	7114.8	7126.1	2284.0
2017-10-02 22:00:00	NQ	Futures	7126.1	7130.56	7126.1	7127.88	1741.0
2017-10-02 23:00:00	NQ	Futures	7127.88	7132.64	7127.88	7130.56	1219.0
2017-10-02 00:00:00	YM	Futures	24327.1	24344.5	24326.1	24329.3	460.0
2017-10-02 01:00:00	YM	Futures	24328.2	24348.9	24327.1	24342.4	1412.0
2017-10-02 02:00:00	YM	Futures	24343.5	24346.7	24332.6	24336.9	1278.0
2017-10-02 03:00:00	YM	Futures	24336.9	24343.5	24332.6	24332.6	2035.0

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

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