PREVIEW / futures_1hour / 2017-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-28.parquet
  size:    53 KB
  rows:    1,636

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-03-28 00:00:00	ES	Futures	2559.62	2560.17	2558.8	2559.62	3319.0
2017-03-28 01:00:00	ES	Futures	2559.62	2560.72	2559.35	2560.44	4495.0
2017-03-28 02:00:00	ES	Futures	2560.44	2560.99	2557.98	2559.08	7026.0
2017-03-28 03:00:00	ES	Futures	2558.8	2559.62	2556.07	2557.98	17071.0
2017-03-28 04:00:00	ES	Futures	2557.98	2558.53	2556.07	2557.98	10303.0
2017-03-28 05:00:00	ES	Futures	2557.71	2557.98	2556.89	2557.44	6632.0
2017-03-28 06:00:00	ES	Futures	2557.44	2557.98	2556.07	2556.35	5975.0
2017-03-28 07:00:00	ES	Futures	2556.35	2556.62	2550.88	2552.52	27837.0
2017-03-28 08:00:00	ES	Futures	2552.25	2552.79	2550.61	2551.7	25889.0
2017-03-28 09:00:00	ES	Futures	2551.43	2556.35	2549.52	2551.16	170875.0
2017-03-28 10:00:00	ES	Futures	2551.16	2559.35	2550.88	2559.08	271058.0
2017-03-28 11:00:00	ES	Futures	2559.08	2569.18	2558.53	2567.54	227749.0
2017-03-28 12:00:00	ES	Futures	2567.54	2569.73	2565.91	2568.09	111798.0
2017-03-28 13:00:00	ES	Futures	2568.09	2575.74	2567.82	2575.19	118608.0
2017-03-28 14:00:00	ES	Futures	2575.47	2579.02	2573.83	2575.19	166721.0
2017-03-28 15:00:00	ES	Futures	2574.92	2577.38	2572.46	2572.46	277556.0
2017-03-28 16:00:00	ES	Futures	2572.46	2573.28	2568.64	2570.0	123194.0
2017-03-28 18:00:00	ES	Futures	2570.82	2571.09	2569.18	2570.82	6722.0
2017-03-28 19:00:00	ES	Futures	2570.82	2571.91	2570.28	2571.64	3078.0
2017-03-28 20:00:00	ES	Futures	2571.64	2572.19	2569.73	2571.09	5700.0
2017-03-28 21:00:00	ES	Futures	2571.09	2571.37	2569.46	2570.28	3303.0
2017-03-28 22:00:00	ES	Futures	2570.28	2570.82	2569.46	2570.28	4201.0
2017-03-28 23:00:00	ES	Futures	2570.28	2571.91	2570.0	2571.37	4352.0
2017-03-28 00:00:00	NQ	Futures	6428.2	6428.8	6425.22	6427.01	723.0
2017-03-28 01:00:00	NQ	Futures	6427.01	6430.59	6426.71	6429.39	689.0
2017-03-28 02:00:00	NQ	Futures	6429.1	6431.48	6423.73	6426.71	1364.0
2017-03-28 03:00:00	NQ	Futures	6426.41	6431.18	6419.85	6424.62	3306.0
2017-03-28 04:00:00	NQ	Futures	6424.32	6426.41	6421.05	6425.22	1776.0
2017-03-28 05:00:00	NQ	Futures	6424.92	6425.52	6421.94	6424.03	911.0
2017-03-28 06:00:00	NQ	Futures	6423.73	6425.52	6421.34	6422.54	897.0
2017-03-28 07:00:00	NQ	Futures	6422.54	6422.83	6410.31	6412.4	3837.0
2017-03-28 08:00:00	NQ	Futures	6412.1	6412.7	6405.54	6407.63	4741.0
2017-03-28 09:00:00	NQ	Futures	6407.93	6422.24	6396.3	6402.56	33838.0
2017-03-28 10:00:00	NQ	Futures	6402.86	6420.75	6398.09	6412.4	46093.0
2017-03-28 11:00:00	NQ	Futures	6412.4	6437.14	6411.21	6432.97	33266.0
2017-03-28 12:00:00	NQ	Futures	6432.97	6440.72	6432.67	6438.93	16451.0
2017-03-28 13:00:00	NQ	Futures	6438.93	6458.61	6438.04	6457.72	21478.0
2017-03-28 14:00:00	NQ	Futures	6458.01	6469.34	6455.63	6460.7	27983.0
2017-03-28 15:00:00	NQ	Futures	6460.7	6464.87	6449.07	6449.67	31484.0
2017-03-28 16:00:00	NQ	Futures	6449.67	6451.16	6444.9	6448.47	8005.0
2017-03-28 18:00:00	NQ	Futures	6450.56	6452.65	6446.98	6451.46	1253.0
2017-03-28 19:00:00	NQ	Futures	6451.46	6453.84	6450.86	6453.24	769.0
2017-03-28 20:00:00	NQ	Futures	6453.54	6456.52	6448.77	6452.65	1430.0
2017-03-28 21:00:00	NQ	Futures	6452.65	6453.54	6447.58	6451.46	862.0
2017-03-28 22:00:00	NQ	Futures	6451.75	6453.24	6449.67	6451.75	787.0
2017-03-28 23:00:00	NQ	Futures	6452.05	6456.52	6452.05	6454.74	812.0
2017-03-28 00:00:00	YM	Futures	22306.4	22311.8	22302.0	22307.5	564.0
2017-03-28 01:00:00	YM	Futures	22306.4	22318.3	22305.3	22314.0	957.0
2017-03-28 02:00:00	YM	Futures	22314.0	22321.6	22301.0	22307.5	1586.0
2017-03-28 03:00:00	YM	Futures	22306.4	22310.7	22285.7	22296.6	2658.0

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

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