PREVIEW / futures_1hour / 2017-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-07.parquet
  size:    52 KB
  rows:    1,626

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-06-07 00:00:00	ES	Futures	2657.41	2658.5	2657.41	2657.95	1734.0
2017-06-07 01:00:00	ES	Futures	2657.95	2658.23	2656.86	2657.68	2799.0
2017-06-07 02:00:00	ES	Futures	2657.41	2657.68	2655.5	2655.77	5503.0
2017-06-07 03:00:00	ES	Futures	2656.04	2656.86	2653.04	2656.32	23563.0
2017-06-07 04:00:00	ES	Futures	2656.32	2656.59	2653.86	2654.95	10114.0
2017-06-07 05:00:00	ES	Futures	2654.68	2655.5	2654.13	2655.22	7819.0
2017-06-07 06:00:00	ES	Futures	2655.22	2657.68	2654.95	2656.04	16046.0
2017-06-07 07:00:00	ES	Futures	2655.77	2657.95	2655.5	2657.95	15524.0
2017-06-07 08:00:00	ES	Futures	2657.95	2658.23	2656.04	2657.13	11506.0
2017-06-07 09:00:00	ES	Futures	2657.13	2659.05	2655.5	2658.5	153491.0
2017-06-07 10:00:00	ES	Futures	2658.5	2659.87	2652.22	2655.5	210338.0
2017-06-07 11:00:00	ES	Futures	2655.5	2657.13	2653.31	2654.95	137034.0
2017-06-07 12:00:00	ES	Futures	2654.95	2655.22	2648.39	2651.4	120760.0
2017-06-07 13:00:00	ES	Futures	2651.4	2656.32	2650.85	2655.5	116890.0
2017-06-07 14:00:00	ES	Futures	2655.5	2659.05	2654.95	2657.41	110299.0
2017-06-07 15:00:00	ES	Futures	2657.41	2660.41	2655.77	2657.41	208113.0
2017-06-07 16:00:00	ES	Futures	2657.13	2657.68	2655.5	2656.86	71739.0
2017-06-07 18:00:00	ES	Futures	2656.59	2657.41	2656.04	2656.32	3271.0
2017-06-07 19:00:00	ES	Futures	2656.59	2657.13	2655.5	2656.86	2158.0
2017-06-07 20:00:00	ES	Futures	2657.13	2657.41	2655.77	2656.59	3893.0
2017-06-07 21:00:00	ES	Futures	2656.32	2656.86	2656.04	2656.86	2303.0
2017-06-07 22:00:00	ES	Futures	2656.86	2657.95	2656.32	2657.41	2057.0
2017-06-07 23:00:00	ES	Futures	2657.68	2659.87	2657.41	2659.32	3729.0
2017-06-07 00:00:00	NQ	Futures	6997.65	7000.03	6997.65	6998.54	390.0
2017-06-07 01:00:00	NQ	Futures	6998.54	6999.44	6996.46	6997.95	789.0
2017-06-07 02:00:00	NQ	Futures	6997.65	6997.95	6994.67	6994.67	1107.0
2017-06-07 03:00:00	NQ	Futures	6994.97	6996.75	6986.92	6995.56	4841.0
2017-06-07 04:00:00	NQ	Futures	6995.86	6996.16	6991.09	6993.77	1705.0
2017-06-07 05:00:00	NQ	Futures	6994.07	6996.46	6993.18	6995.86	1078.0
2017-06-07 06:00:00	NQ	Futures	6995.86	7000.33	6994.97	6995.86	3012.0
2017-06-07 07:00:00	NQ	Futures	6995.56	7002.12	6995.56	7002.12	3413.0
2017-06-07 08:00:00	NQ	Futures	7001.82	7003.61	7000.33	7003.31	2991.0
2017-06-07 09:00:00	NQ	Futures	7003.31	7015.24	6994.07	7005.4	45390.0
2017-06-07 10:00:00	NQ	Futures	7005.4	7011.66	6986.62	7000.33	47941.0
2017-06-07 11:00:00	NQ	Futures	7000.33	7009.57	6998.54	7003.61	27692.0
2017-06-07 12:00:00	NQ	Futures	7003.61	7003.91	6971.41	6982.44	31197.0
2017-06-07 13:00:00	NQ	Futures	6982.74	7000.63	6981.55	6998.54	24813.0
2017-06-07 14:00:00	NQ	Futures	6998.54	7010.47	6996.46	7007.19	29621.0
2017-06-07 15:00:00	NQ	Futures	7007.19	7017.92	7002.42	7011.36	30366.0
2017-06-07 16:00:00	NQ	Futures	7011.36	7013.75	7005.4	7011.06	7440.0
2017-06-07 18:00:00	NQ	Futures	7009.57	7014.05	7008.38	7010.77	762.0
2017-06-07 19:00:00	NQ	Futures	7010.77	7011.66	7007.19	7011.66	813.0
2017-06-07 20:00:00	NQ	Futures	7011.66	7013.15	7009.28	7010.77	881.0
2017-06-07 21:00:00	NQ	Futures	7010.17	7011.96	7009.28	7011.36	379.0
2017-06-07 22:00:00	NQ	Futures	7011.36	7014.34	7010.77	7014.34	418.0
2017-06-07 23:00:00	NQ	Futures	7013.75	7021.5	7013.75	7020.01	1008.0
2017-06-07 00:00:00	YM	Futures	23003.0	23009.5	23000.8	23005.2	294.0
2017-06-07 01:00:00	YM	Futures	23004.1	23007.4	22997.6	23001.9	445.0
2017-06-07 02:00:00	YM	Futures	23000.8	23000.8	22985.6	22985.6	1237.0
2017-06-07 03:00:00	YM	Futures	22986.7	22996.5	22970.4	22991.1	3827.0

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

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