PREVIEW / futures_1hour / 2016-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-04.parquet
  size:    52 KB
  rows:    1,599

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-08-04 00:00:00	ES	Futures	2339.8	2340.88	2339.25	2340.61	1647.0
2016-08-04 01:00:00	ES	Futures	2340.61	2341.69	2340.07	2341.15	3588.0
2016-08-04 02:00:00	ES	Futures	2341.15	2342.24	2339.25	2340.34	6986.0
2016-08-04 03:00:00	ES	Futures	2340.07	2341.42	2337.36	2339.25	25531.0
2016-08-04 04:00:00	ES	Futures	2339.53	2340.88	2338.71	2339.25	12676.0
2016-08-04 05:00:00	ES	Futures	2339.25	2340.88	2338.17	2340.34	9054.0
2016-08-04 06:00:00	ES	Futures	2340.61	2340.88	2338.71	2340.61	8876.0
2016-08-04 07:00:00	ES	Futures	2340.61	2347.66	2340.61	2345.22	61143.0
2016-08-04 08:00:00	ES	Futures	2345.22	2345.76	2340.61	2341.15	43024.0
2016-08-04 09:00:00	ES	Futures	2341.15	2345.22	2339.25	2339.25	182678.0
2016-08-04 10:00:00	ES	Futures	2339.53	2344.68	2336.54	2344.14	226720.0
2016-08-04 11:00:00	ES	Futures	2344.14	2345.76	2341.69	2345.22	155817.0
2016-08-04 12:00:00	ES	Futures	2345.49	2346.85	2342.78	2343.05	89501.0
2016-08-04 13:00:00	ES	Futures	2343.32	2343.59	2340.88	2342.51	85702.0
2016-08-04 14:00:00	ES	Futures	2342.51	2343.59	2339.53	2341.97	81369.0
2016-08-04 15:00:00	ES	Futures	2341.69	2343.86	2340.34	2343.05	153397.0
2016-08-04 16:00:00	ES	Futures	2343.05	2343.32	2341.97	2343.32	52434.0
2016-08-04 18:00:00	ES	Futures	2342.51	2343.32	2342.24	2343.05	2032.0
2016-08-04 19:00:00	ES	Futures	2343.05	2344.14	2342.78	2344.14	2355.0
2016-08-04 20:00:00	ES	Futures	2344.14	2345.22	2343.86	2344.14	4180.0
2016-08-04 21:00:00	ES	Futures	2344.14	2345.76	2343.32	2344.95	5156.0
2016-08-04 22:00:00	ES	Futures	2345.22	2346.85	2344.95	2346.03	3620.0
2016-08-04 23:00:00	ES	Futures	2346.03	2346.58	2345.49	2346.3	2201.0
2016-08-04 00:00:00	NQ	Futures	5632.28	5634.37	5630.49	5634.07	336.0
2016-08-04 01:00:00	NQ	Futures	5633.77	5637.65	5633.77	5636.16	572.0
2016-08-04 02:00:00	NQ	Futures	5636.16	5639.14	5631.09	5633.47	1046.0
2016-08-04 03:00:00	NQ	Futures	5633.17	5637.05	5625.13	5630.19	3264.0
2016-08-04 04:00:00	NQ	Futures	5630.19	5632.58	5627.81	5628.41	1952.0
2016-08-04 05:00:00	NQ	Futures	5628.41	5631.98	5625.43	5630.79	1114.0
2016-08-04 06:00:00	NQ	Futures	5630.49	5631.68	5626.92	5630.49	1304.0
2016-08-04 07:00:00	NQ	Futures	5630.49	5647.48	5630.49	5642.71	8913.0
2016-08-04 08:00:00	NQ	Futures	5642.71	5644.5	5634.07	5634.66	4442.0
2016-08-04 09:00:00	NQ	Futures	5634.37	5648.97	5631.39	5632.28	29226.0
2016-08-04 10:00:00	NQ	Futures	5632.28	5654.63	5621.25	5653.44	33748.0
2016-08-04 11:00:00	NQ	Futures	5653.44	5654.93	5643.01	5653.14	19829.0
2016-08-04 12:00:00	NQ	Futures	5652.85	5658.21	5646.88	5647.18	13047.0
2016-08-04 13:00:00	NQ	Futures	5647.18	5651.95	5641.52	5651.36	10885.0
2016-08-04 14:00:00	NQ	Futures	5651.65	5654.93	5643.01	5651.65	10360.0
2016-08-04 15:00:00	NQ	Futures	5651.65	5657.91	5647.48	5652.85	15984.0
2016-08-04 16:00:00	NQ	Futures	5652.55	5659.4	5651.36	5658.21	5637.0
2016-08-04 18:00:00	NQ	Futures	5657.02	5657.32	5654.04	5655.83	397.0
2016-08-04 19:00:00	NQ	Futures	5656.12	5659.11	5655.53	5659.11	374.0
2016-08-04 20:00:00	NQ	Futures	5659.11	5662.38	5658.81	5660.0	613.0
2016-08-04 21:00:00	NQ	Futures	5660.0	5664.77	5657.32	5661.49	856.0
2016-08-04 22:00:00	NQ	Futures	5662.09	5667.15	5660.89	5664.17	580.0
2016-08-04 23:00:00	NQ	Futures	5664.47	5667.15	5663.87	5666.26	354.0
2016-08-04 00:00:00	YM	Futures	19665.5	19675.2	19663.3	19674.1	422.0
2016-08-04 01:00:00	YM	Futures	19675.2	19682.7	19673.0	19678.4	554.0
2016-08-04 02:00:00	YM	Futures	19677.3	19687.0	19662.3	19670.9	1589.0
2016-08-04 03:00:00	YM	Futures	19669.8	19682.7	19650.4	19665.5	2684.0

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

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