PREVIEW / futures_1hour / 2016-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-02.parquet
  size:    46 KB
  rows:    1,325

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
2016-12-02 00:00:00	ES	Futures	2381.78	2382.87	2380.42	2382.87	3984.0
2016-12-02 01:00:00	ES	Futures	2382.87	2382.87	2381.51	2382.6	3116.0
2016-12-02 02:00:00	ES	Futures	2382.6	2383.41	2381.51	2383.41	6106.0
2016-12-02 03:00:00	ES	Futures	2383.41	2383.41	2379.6	2379.6	24586.0
2016-12-02 04:00:00	ES	Futures	2379.87	2380.15	2377.15	2378.79	23319.0
2016-12-02 05:00:00	ES	Futures	2378.51	2379.06	2377.15	2378.24	10437.0
2016-12-02 06:00:00	ES	Futures	2377.97	2379.6	2377.97	2378.51	9388.0
2016-12-02 07:00:00	ES	Futures	2378.51	2382.05	2378.24	2381.51	18053.0
2016-12-02 08:00:00	ES	Futures	2381.51	2385.04	2379.87	2383.41	67485.0
2016-12-02 09:00:00	ES	Futures	2383.41	2388.58	2382.6	2387.49	251760.0
2016-12-02 10:00:00	ES	Futures	2387.77	2390.21	2383.96	2388.04	255644.0
2016-12-02 11:00:00	ES	Futures	2388.04	2391.3	2386.95	2387.22	169017.0
2016-12-02 12:00:00	ES	Futures	2387.49	2388.04	2382.87	2386.68	163107.0
2016-12-02 13:00:00	ES	Futures	2386.68	2387.22	2380.69	2382.05	142160.0
2016-12-02 14:00:00	ES	Futures	2381.78	2383.41	2380.15	2382.05	105788.0
2016-12-02 15:00:00	ES	Futures	2381.78	2386.95	2381.51	2384.5	283740.0
2016-12-02 16:00:00	ES	Futures	2384.77	2386.95	2383.68	2384.5	85330.0
2016-12-02 00:00:00	NQ	Futures	5638.53	5642.71	5636.44	5642.41	793.0
2016-12-02 01:00:00	NQ	Futures	5642.11	5642.11	5638.23	5640.32	907.0
2016-12-02 02:00:00	NQ	Futures	5640.32	5641.51	5636.44	5641.51	1170.0
2016-12-02 03:00:00	NQ	Futures	5641.22	5641.22	5624.51	5624.81	5305.0
2016-12-02 04:00:00	NQ	Futures	5624.81	5626.0	5617.35	5621.52	4244.0
2016-12-02 05:00:00	NQ	Futures	5621.52	5623.31	5617.94	5619.44	2296.0
2016-12-02 06:00:00	NQ	Futures	5619.73	5625.4	5619.44	5622.42	1853.0
2016-12-02 07:00:00	NQ	Futures	5623.02	5634.05	5623.02	5633.46	2718.0
2016-12-02 08:00:00	NQ	Futures	5633.76	5649.27	5632.86	5643.6	12562.0
2016-12-02 09:00:00	NQ	Futures	5643.9	5679.1	5638.83	5657.92	55602.0
2016-12-02 10:00:00	NQ	Futures	5658.22	5667.77	5632.56	5660.61	48181.0
2016-12-02 11:00:00	NQ	Futures	5660.91	5677.91	5656.43	5659.41	22883.0
2016-12-02 12:00:00	NQ	Futures	5659.12	5668.07	5653.15	5665.68	13701.0
2016-12-02 13:00:00	NQ	Futures	5665.38	5665.98	5646.88	5652.25	13811.0
2016-12-02 14:00:00	NQ	Futures	5652.25	5654.94	5643.9	5650.46	11951.0
2016-12-02 15:00:00	NQ	Futures	5650.46	5659.41	5644.8	5655.24	16936.0
2016-12-02 16:00:00	NQ	Futures	5655.24	5657.92	5646.88	5649.57	5367.0
2016-12-02 00:00:00	YM	Futures	20715.0	20729.0	20704.2	20726.9	1126.0
2016-12-02 01:00:00	YM	Futures	20725.8	20731.2	20715.0	20726.9	956.0
2016-12-02 02:00:00	YM	Futures	20725.8	20730.1	20719.3	20730.1	1594.0
2016-12-02 03:00:00	YM	Futures	20729.0	20730.1	20710.7	20713.9	3232.0
2016-12-02 04:00:00	YM	Futures	20715.0	20723.6	20702.0	20715.0	3698.0
2016-12-02 05:00:00	YM	Futures	20715.0	20717.1	20704.2	20709.6	1348.0
2016-12-02 06:00:00	YM	Futures	20709.6	20718.2	20706.3	20708.5	1145.0
2016-12-02 07:00:00	YM	Futures	20708.5	20730.1	20707.4	20726.9	2406.0
2016-12-02 08:00:00	YM	Futures	20726.9	20743.1	20709.6	20734.4	8033.0
2016-12-02 09:00:00	YM	Futures	20734.4	20738.8	20678.2	20713.9	25376.0
2016-12-02 10:00:00	YM	Futures	20715.0	20731.2	20690.1	20717.1	20305.0
2016-12-02 11:00:00	YM	Futures	20718.2	20737.7	20715.0	20724.7	12465.0
2016-12-02 12:00:00	YM	Futures	20724.7	20735.5	20691.2	20729.0	11642.0
2016-12-02 13:00:00	YM	Futures	20730.1	20731.2	20686.9	20694.4	11910.0
2016-12-02 14:00:00	YM	Futures	20694.4	20709.6	20685.8	20696.6	8531.0
2016-12-02 15:00:00	YM	Futures	20696.6	20732.3	20695.5	20711.7	14071.0

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

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