PREVIEW / futures_1hour / 2017-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-20.parquet
  size:    53 KB
  rows:    1,634

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-20 00:00:00	ES	Futures	2551.16	2551.7	2550.61	2550.61	2118.0
2017-04-20 01:00:00	ES	Futures	2550.88	2551.7	2550.06	2551.16	3697.0
2017-04-20 02:00:00	ES	Futures	2551.16	2552.79	2550.88	2551.97	8531.0
2017-04-20 03:00:00	ES	Futures	2552.25	2556.62	2550.61	2556.07	30551.0
2017-04-20 04:00:00	ES	Futures	2555.8	2557.44	2554.71	2556.62	13358.0
2017-04-20 05:00:00	ES	Futures	2556.35	2558.26	2555.53	2556.89	13204.0
2017-04-20 06:00:00	ES	Futures	2557.16	2557.71	2555.8	2556.89	9810.0
2017-04-20 07:00:00	ES	Futures	2556.89	2557.71	2555.8	2556.35	13530.0
2017-04-20 08:00:00	ES	Futures	2556.35	2557.98	2555.8	2556.62	17727.0
2017-04-20 09:00:00	ES	Futures	2556.35	2559.62	2553.61	2554.98	153097.0
2017-04-20 10:00:00	ES	Futures	2554.98	2561.53	2554.98	2559.9	196707.0
2017-04-20 11:00:00	ES	Futures	2559.9	2566.45	2557.98	2565.91	154568.0
2017-04-20 12:00:00	ES	Futures	2566.18	2572.19	2565.63	2570.28	177623.0
2017-04-20 13:00:00	ES	Futures	2570.28	2576.56	2568.64	2575.47	158971.0
2017-04-20 14:00:00	ES	Futures	2575.19	2575.74	2572.46	2572.73	124411.0
2017-04-20 15:00:00	ES	Futures	2572.73	2574.92	2570.0	2570.28	235433.0
2017-04-20 16:00:00	ES	Futures	2570.28	2571.37	2568.91	2569.73	99774.0
2017-04-20 18:00:00	ES	Futures	2570.55	2571.64	2569.46	2570.55	5887.0
2017-04-20 19:00:00	ES	Futures	2570.55	2571.09	2570.0	2570.55	2459.0
2017-04-20 20:00:00	ES	Futures	2570.55	2571.37	2569.73	2570.0	4552.0
2017-04-20 21:00:00	ES	Futures	2570.0	2571.09	2569.73	2570.55	3549.0
2017-04-20 22:00:00	ES	Futures	2570.55	2571.37	2570.0	2570.28	2451.0
2017-04-20 23:00:00	ES	Futures	2570.55	2570.55	2569.46	2569.46	1637.0
2017-04-20 00:00:00	NQ	Futures	6442.81	6443.7	6441.02	6441.02	500.0
2017-04-20 01:00:00	NQ	Futures	6441.02	6442.51	6438.93	6441.32	564.0
2017-04-20 02:00:00	NQ	Futures	6441.32	6446.98	6441.32	6446.39	1881.0
2017-04-20 03:00:00	NQ	Futures	6446.39	6456.23	6443.11	6454.74	5446.0
2017-04-20 04:00:00	NQ	Futures	6454.44	6459.51	6452.35	6456.82	2389.0
2017-04-20 05:00:00	NQ	Futures	6456.52	6461.0	6454.44	6458.91	2015.0
2017-04-20 06:00:00	NQ	Futures	6458.91	6460.1	6455.93	6458.91	1455.0
2017-04-20 07:00:00	NQ	Futures	6458.91	6461.59	6456.52	6459.8	2128.0
2017-04-20 08:00:00	NQ	Futures	6459.8	6464.87	6458.91	6461.59	4099.0
2017-04-20 09:00:00	NQ	Futures	6461.59	6472.33	6452.95	6456.23	31349.0
2017-04-20 10:00:00	NQ	Futures	6455.93	6474.71	6455.93	6466.66	34524.0
2017-04-20 11:00:00	NQ	Futures	6466.36	6482.76	6462.79	6481.27	26945.0
2017-04-20 12:00:00	NQ	Futures	6481.27	6500.95	6480.08	6495.88	31830.0
2017-04-20 13:00:00	NQ	Futures	6495.88	6505.12	6489.92	6502.14	25277.0
2017-04-20 14:00:00	NQ	Futures	6502.44	6504.52	6498.26	6500.95	16065.0
2017-04-20 15:00:00	NQ	Futures	6501.25	6503.93	6488.43	6489.02	29201.0
2017-04-20 16:00:00	NQ	Futures	6488.72	6494.69	6488.13	6492.6	8571.0
2017-04-20 18:00:00	NQ	Futures	6493.49	6498.86	6490.51	6496.47	3630.0
2017-04-20 19:00:00	NQ	Futures	6496.18	6497.37	6495.28	6496.47	636.0
2017-04-20 20:00:00	NQ	Futures	6496.47	6498.26	6494.39	6495.58	1061.0
2017-04-20 21:00:00	NQ	Futures	6495.28	6498.86	6494.69	6496.18	753.0
2017-04-20 22:00:00	NQ	Futures	6496.47	6498.56	6496.18	6496.77	694.0
2017-04-20 23:00:00	NQ	Futures	6496.77	6497.37	6494.98	6495.28	356.0
2017-04-20 00:00:00	YM	Futures	22110.8	22115.1	22107.5	22107.5	619.0
2017-04-20 01:00:00	YM	Futures	22107.5	22110.8	22098.8	22105.3	794.0
2017-04-20 02:00:00	YM	Futures	22105.3	22120.5	22104.2	22111.9	1738.0
2017-04-20 03:00:00	YM	Futures	22112.9	22157.5	22099.9	22144.5	6907.0

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

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