PREVIEW / futures_1hour / 2017-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-28.parquet
  size:    45 KB
  rows:    1,353

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-04-28 00:00:00	ES	Futures	2606.06	2606.06	2604.69	2605.51	2871.0
2017-04-28 01:00:00	ES	Futures	2605.78	2606.06	2604.69	2605.51	3710.0
2017-04-28 02:00:00	ES	Futures	2605.51	2606.6	2604.96	2605.24	6030.0
2017-04-28 03:00:00	ES	Futures	2604.96	2606.33	2604.15	2606.06	9287.0
2017-04-28 04:00:00	ES	Futures	2606.06	2608.24	2605.78	2606.88	10943.0
2017-04-28 05:00:00	ES	Futures	2606.88	2609.33	2606.88	2609.06	11158.0
2017-04-28 06:00:00	ES	Futures	2609.06	2609.61	2607.7	2609.06	6989.0
2017-04-28 07:00:00	ES	Futures	2609.06	2609.88	2607.42	2608.24	11977.0
2017-04-28 08:00:00	ES	Futures	2607.97	2609.61	2607.15	2607.97	23890.0
2017-04-28 09:00:00	ES	Futures	2607.97	2609.61	2603.87	2604.96	130951.0
2017-04-28 10:00:00	ES	Futures	2604.96	2605.78	2600.87	2603.05	184304.0
2017-04-28 11:00:00	ES	Futures	2603.33	2604.15	2599.5	2600.32	122119.0
2017-04-28 12:00:00	ES	Futures	2600.59	2603.05	2600.59	2601.41	70436.0
2017-04-28 13:00:00	ES	Futures	2601.69	2602.23	2599.5	2600.05	72717.0
2017-04-28 14:00:00	ES	Futures	2600.05	2601.41	2598.41	2599.5	96695.0
2017-04-28 15:00:00	ES	Futures	2599.5	2602.23	2598.96	2600.59	251490.0
2017-04-28 16:00:00	ES	Futures	2600.87	2602.78	2599.77	2601.14	105916.0
2017-04-28 00:00:00	NQ	Futures	6667.31	6667.61	6662.24	6664.03	973.0
2017-04-28 01:00:00	NQ	Futures	6664.03	6664.92	6662.84	6663.73	746.0
2017-04-28 02:00:00	NQ	Futures	6663.73	6665.82	6662.24	6663.14	1340.0
2017-04-28 03:00:00	NQ	Futures	6662.84	6664.33	6659.26	6664.03	1582.0
2017-04-28 04:00:00	NQ	Futures	6664.33	6667.61	6662.24	6663.73	1865.0
2017-04-28 05:00:00	NQ	Futures	6663.73	6671.19	6663.73	6670.59	1683.0
2017-04-28 06:00:00	NQ	Futures	6670.59	6672.68	6669.69	6671.48	1756.0
2017-04-28 07:00:00	NQ	Futures	6671.78	6675.66	6667.31	6668.2	2820.0
2017-04-28 08:00:00	NQ	Futures	6667.91	6669.1	6661.35	6663.43	5230.0
2017-04-28 09:00:00	NQ	Futures	6663.43	6672.97	6651.21	6652.1	37055.0
2017-04-28 10:00:00	NQ	Futures	6652.1	6660.15	6649.12	6659.26	32427.0
2017-04-28 11:00:00	NQ	Futures	6659.26	6659.86	6646.44	6649.42	18975.0
2017-04-28 12:00:00	NQ	Futures	6649.42	6661.35	6649.42	6657.17	12130.0
2017-04-28 13:00:00	NQ	Futures	6657.77	6659.86	6652.1	6652.4	10639.0
2017-04-28 14:00:00	NQ	Futures	6652.4	6653.89	6644.65	6649.12	15492.0
2017-04-28 15:00:00	NQ	Futures	6649.12	6658.96	6647.33	6654.49	24004.0
2017-04-28 16:00:00	NQ	Futures	6654.49	6659.26	6654.19	6655.68	7573.0
2017-04-28 00:00:00	YM	Futures	22705.2	22706.3	22697.6	22702.0	577.0
2017-04-28 01:00:00	YM	Futures	22702.0	22706.3	22698.7	22703.1	680.0
2017-04-28 02:00:00	YM	Futures	22704.2	22710.7	22700.9	22702.0	1142.0
2017-04-28 03:00:00	YM	Futures	22700.9	22707.4	22685.7	22695.5	2671.0
2017-04-28 04:00:00	YM	Futures	22695.5	22715.0	22694.4	22699.8	1929.0
2017-04-28 05:00:00	YM	Futures	22699.8	22718.3	22699.8	22716.1	1411.0
2017-04-28 06:00:00	YM	Futures	22717.2	22721.5	22704.2	22712.8	890.0
2017-04-28 07:00:00	YM	Futures	22713.9	22733.5	22711.8	22727.0	2069.0
2017-04-28 08:00:00	YM	Futures	22725.9	22745.5	22717.2	22735.7	3619.0
2017-04-28 09:00:00	YM	Futures	22735.7	22741.1	22700.9	22716.1	12168.0
2017-04-28 10:00:00	YM	Futures	22716.1	22718.3	22673.7	22708.5	15736.0
2017-04-28 11:00:00	YM	Futures	22709.6	22717.2	22679.2	22693.3	9791.0
2017-04-28 12:00:00	YM	Futures	22693.3	22712.8	22690.0	22696.5	4814.0
2017-04-28 13:00:00	YM	Futures	22697.6	22699.8	22677.0	22686.8	5644.0
2017-04-28 14:00:00	YM	Futures	22687.9	22694.4	22669.4	22680.2	6688.0
2017-04-28 15:00:00	YM	Futures	22680.2	22699.8	22671.6	22683.5	11223.0

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

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