PREVIEW / futures_1hour / 2017-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-21.parquet
  size:    54 KB
  rows:    1,624

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-21 00:00:00	ES	Futures	2594.04	2594.31	2593.77	2594.04	1435.0
2017-03-21 01:00:00	ES	Futures	2593.77	2594.31	2593.49	2593.77	2137.0
2017-03-21 02:00:00	ES	Futures	2593.49	2594.31	2592.95	2593.77	2632.0
2017-03-21 03:00:00	ES	Futures	2594.04	2596.77	2593.77	2595.68	12126.0
2017-03-21 04:00:00	ES	Futures	2595.95	2596.22	2593.77	2594.04	10486.0
2017-03-21 05:00:00	ES	Futures	2594.04	2594.59	2593.22	2594.04	7546.0
2017-03-21 06:00:00	ES	Futures	2594.31	2594.86	2593.49	2593.77	5095.0
2017-03-21 07:00:00	ES	Futures	2593.77	2595.95	2593.22	2594.59	10755.0
2017-03-21 08:00:00	ES	Futures	2594.86	2594.86	2593.22	2594.31	12530.0
2017-03-21 09:00:00	ES	Futures	2594.59	2598.96	2593.49	2593.49	150798.0
2017-03-21 10:00:00	ES	Futures	2593.77	2593.77	2571.91	2574.65	455018.0
2017-03-21 11:00:00	ES	Futures	2574.65	2575.47	2561.53	2571.37	499698.0
2017-03-21 12:00:00	ES	Futures	2571.37	2574.37	2563.17	2566.18	249656.0
2017-03-21 13:00:00	ES	Futures	2566.18	2567.82	2557.71	2558.26	234770.0
2017-03-21 14:00:00	ES	Futures	2558.26	2567.0	2556.89	2563.72	280725.0
2017-03-21 15:00:00	ES	Futures	2563.72	2566.18	2554.43	2556.62	454195.0
2017-03-21 16:00:00	ES	Futures	2556.62	2560.17	2555.53	2557.71	131355.0
2017-03-21 18:00:00	ES	Futures	2557.16	2558.26	2552.79	2555.25	13570.0
2017-03-21 19:00:00	ES	Futures	2555.53	2556.89	2553.89	2554.98	10257.0
2017-03-21 20:00:00	ES	Futures	2554.71	2556.62	2554.16	2554.71	7083.0
2017-03-21 21:00:00	ES	Futures	2554.98	2554.98	2550.34	2551.97	19984.0
2017-03-21 22:00:00	ES	Futures	2551.97	2552.79	2548.97	2550.06	15352.0
2017-03-21 23:00:00	ES	Futures	2549.79	2554.16	2549.24	2552.79	11980.0
2017-03-21 00:00:00	NQ	Futures	6474.11	6475.01	6473.52	6473.82	391.0
2017-03-21 01:00:00	NQ	Futures	6473.82	6474.71	6472.62	6473.52	415.0
2017-03-21 02:00:00	NQ	Futures	6473.22	6474.41	6472.03	6473.82	465.0
2017-03-21 03:00:00	NQ	Futures	6473.82	6480.67	6473.52	6478.29	2700.0
2017-03-21 04:00:00	NQ	Futures	6478.29	6480.08	6474.41	6474.71	2716.0
2017-03-21 05:00:00	NQ	Futures	6474.71	6475.61	6472.92	6475.01	1619.0
2017-03-21 06:00:00	NQ	Futures	6474.71	6475.61	6473.52	6474.71	1017.0
2017-03-21 07:00:00	NQ	Futures	6474.41	6478.88	6473.22	6475.9	1656.0
2017-03-21 08:00:00	NQ	Futures	6475.9	6476.5	6473.22	6476.2	2203.0
2017-03-21 09:00:00	NQ	Futures	6475.9	6488.72	6475.9	6483.36	26252.0
2017-03-21 10:00:00	NQ	Futures	6483.36	6483.36	6425.22	6430.88	72819.0
2017-03-21 11:00:00	NQ	Futures	6430.88	6432.08	6386.46	6411.8	89971.0
2017-03-21 12:00:00	NQ	Futures	6411.5	6415.68	6385.27	6394.81	45833.0
2017-03-21 13:00:00	NQ	Futures	6395.11	6399.28	6365.29	6367.08	38608.0
2017-03-21 14:00:00	NQ	Futures	6366.78	6391.83	6363.5	6385.86	49340.0
2017-03-21 15:00:00	NQ	Futures	6385.27	6388.25	6356.35	6361.12	60062.0
2017-03-21 16:00:00	NQ	Futures	6360.82	6367.68	6358.73	6362.31	8851.0
2017-03-21 18:00:00	NQ	Futures	6361.42	6364.7	6353.07	6359.33	2464.0
2017-03-21 19:00:00	NQ	Futures	6359.33	6361.42	6354.86	6357.54	1465.0
2017-03-21 20:00:00	NQ	Futures	6357.24	6363.21	6356.65	6358.44	1836.0
2017-03-21 21:00:00	NQ	Futures	6358.44	6358.44	6346.51	6349.79	4062.0
2017-03-21 22:00:00	NQ	Futures	6349.49	6351.28	6338.46	6342.04	3828.0
2017-03-21 23:00:00	NQ	Futures	6341.74	6352.77	6339.95	6350.09	2768.0
2017-03-21 00:00:00	YM	Futures	22705.2	22707.4	22702.0	22704.2	293.0
2017-03-21 01:00:00	YM	Futures	22705.2	22705.2	22699.8	22699.8	318.0
2017-03-21 02:00:00	YM	Futures	22699.8	22700.9	22693.3	22696.5	825.0
2017-03-21 03:00:00	YM	Futures	22697.6	22717.2	22696.5	22709.6	2574.0

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

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