PREVIEW / futures_1hour / 2017-02-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-15.parquet
  size:    54 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-02-15 00:00:00	ES	Futures	2548.75	2553.12	2548.21	2550.39	9657.0
2017-02-15 01:00:00	ES	Futures	2550.66	2550.94	2550.12	2550.39	2660.0
2017-02-15 02:00:00	ES	Futures	2550.39	2551.48	2550.12	2550.12	3899.0
2017-02-15 03:00:00	ES	Futures	2550.39	2551.75	2548.75	2551.21	15253.0
2017-02-15 04:00:00	ES	Futures	2551.21	2551.21	2548.75	2549.84	8141.0
2017-02-15 05:00:00	ES	Futures	2549.57	2550.12	2547.39	2547.93	8201.0
2017-02-15 06:00:00	ES	Futures	2547.93	2549.3	2547.39	2548.48	8013.0
2017-02-15 07:00:00	ES	Futures	2548.48	2549.57	2547.93	2547.93	13708.0
2017-02-15 08:00:00	ES	Futures	2548.21	2548.48	2543.84	2544.66	48912.0
2017-02-15 09:00:00	ES	Futures	2544.39	2548.75	2543.57	2548.21	154734.0
2017-02-15 10:00:00	ES	Futures	2548.21	2552.57	2545.48	2552.3	190517.0
2017-02-15 11:00:00	ES	Futures	2552.3	2556.39	2549.84	2552.03	226890.0
2017-02-15 12:00:00	ES	Futures	2552.3	2555.57	2550.94	2554.21	119956.0
2017-02-15 13:00:00	ES	Futures	2554.48	2559.39	2552.57	2557.48	137640.0
2017-02-15 14:00:00	ES	Futures	2557.48	2560.21	2556.66	2560.21	130841.0
2017-02-15 15:00:00	ES	Futures	2560.21	2563.76	2558.85	2560.48	289243.0
2017-02-15 16:00:00	ES	Futures	2560.48	2565.66	2560.48	2564.57	105002.0
2017-02-15 17:00:00	ES	Futures	2564.57	2564.57	2564.57	2564.57	2.0
2017-02-15 18:00:00	ES	Futures	2564.3	2564.85	2562.94	2563.48	6276.0
2017-02-15 19:00:00	ES	Futures	2563.48	2563.76	2561.57	2561.57	6898.0
2017-02-15 20:00:00	ES	Futures	2561.85	2562.12	2560.75	2561.3	5788.0
2017-02-15 21:00:00	ES	Futures	2561.03	2562.39	2561.03	2562.39	2945.0
2017-02-15 22:00:00	ES	Futures	2562.12	2562.66	2561.57	2561.85	2698.0
2017-02-15 23:00:00	ES	Futures	2562.12	2563.21	2561.85	2562.94	1420.0
2017-02-15 00:00:00	NQ	Futures	6296.34	6306.48	6296.04	6300.51	2356.0
2017-02-15 01:00:00	NQ	Futures	6300.81	6302.6	6300.22	6300.81	769.0
2017-02-15 02:00:00	NQ	Futures	6300.51	6302.9	6299.32	6300.22	1083.0
2017-02-15 03:00:00	NQ	Futures	6300.51	6302.3	6296.93	6300.81	2658.0
2017-02-15 04:00:00	NQ	Futures	6300.81	6300.81	6294.85	6296.04	1740.0
2017-02-15 05:00:00	NQ	Futures	6296.04	6297.23	6291.86	6293.06	1605.0
2017-02-15 06:00:00	NQ	Futures	6293.06	6296.34	6292.16	6295.44	1125.0
2017-02-15 07:00:00	NQ	Futures	6295.44	6297.53	6292.76	6293.36	1589.0
2017-02-15 08:00:00	NQ	Futures	6293.06	6293.36	6282.91	6285.0	6427.0
2017-02-15 09:00:00	NQ	Futures	6285.0	6297.53	6283.51	6296.64	21691.0
2017-02-15 10:00:00	NQ	Futures	6296.64	6302.3	6289.48	6300.81	21954.0
2017-02-15 11:00:00	NQ	Futures	6300.51	6312.45	6298.13	6304.39	23470.0
2017-02-15 12:00:00	NQ	Futures	6304.39	6311.55	6300.81	6308.87	12103.0
2017-02-15 13:00:00	NQ	Futures	6309.17	6318.71	6303.8	6314.83	16105.0
2017-02-15 14:00:00	NQ	Futures	6314.83	6323.19	6312.75	6322.89	15296.0
2017-02-15 15:00:00	NQ	Futures	6322.59	6331.54	6321.4	6328.56	23079.0
2017-02-15 16:00:00	NQ	Futures	6328.26	6340.49	6327.36	6340.49	6670.0
2017-02-15 18:00:00	NQ	Futures	6339.89	6339.89	6333.33	6334.22	1189.0
2017-02-15 19:00:00	NQ	Futures	6334.22	6336.31	6332.43	6334.22	1177.0
2017-02-15 20:00:00	NQ	Futures	6333.93	6336.01	6332.43	6333.33	1603.0
2017-02-15 21:00:00	NQ	Futures	6333.63	6336.91	6333.03	6336.61	952.0
2017-02-15 22:00:00	NQ	Futures	6336.61	6337.8	6335.42	6336.61	912.0
2017-02-15 23:00:00	NQ	Futures	6336.31	6339.3	6336.01	6338.7	509.0
2017-02-15 00:00:00	YM	Futures	22224.7	22270.2	22223.6	22247.5	3586.0
2017-02-15 01:00:00	YM	Futures	22247.5	22255.1	22247.5	22248.5	1098.0
2017-02-15 02:00:00	YM	Futures	22248.5	22260.5	22243.1	22252.9	1818.0

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

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