PREVIEW / futures_1hour / 2017-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-05.parquet
  size:    48 KB
  rows:    1,561

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-05 00:00:00	ES	Futures	2660.69	2661.51	2660.69	2660.96	1967.0
2017-06-05 01:00:00	ES	Futures	2660.96	2662.05	2660.69	2661.78	4944.0
2017-06-05 02:00:00	ES	Futures	2661.78	2661.78	2659.87	2661.23	7133.0
2017-06-05 03:00:00	ES	Futures	2661.23	2661.78	2660.14	2661.23	7950.0
2017-06-05 04:00:00	ES	Futures	2661.23	2662.32	2660.69	2661.51	8148.0
2017-06-05 05:00:00	ES	Futures	2661.51	2663.14	2661.23	2661.78	5225.0
2017-06-05 06:00:00	ES	Futures	2662.05	2662.05	2660.69	2660.69	2267.0
2017-06-05 07:00:00	ES	Futures	2660.69	2661.51	2659.87	2659.87	12050.0
2017-06-05 08:00:00	ES	Futures	2660.14	2661.23	2659.87	2660.69	11375.0
2017-06-05 09:00:00	ES	Futures	2660.41	2663.14	2658.77	2662.32	136134.0
2017-06-05 10:00:00	ES	Futures	2662.32	2664.78	2662.05	2662.6	116990.0
2017-06-05 11:00:00	ES	Futures	2662.6	2663.14	2659.87	2662.6	133392.0
2017-06-05 12:00:00	ES	Futures	2662.6	2664.24	2661.51	2662.6	71860.0
2017-06-05 13:00:00	ES	Futures	2662.87	2664.51	2662.05	2662.32	56932.0
2017-06-05 14:00:00	ES	Futures	2662.6	2663.42	2661.78	2662.32	48445.0
2017-06-05 15:00:00	ES	Futures	2662.6	2663.69	2660.41	2661.23	146145.0
2017-06-05 16:00:00	ES	Futures	2660.96	2661.23	2659.32	2660.69	47969.0
2017-06-05 18:00:00	ES	Futures	2659.59	2660.41	2659.32	2660.41	2207.0
2017-06-05 19:00:00	ES	Futures	2660.41	2660.69	2659.87	2660.41	1606.0
2017-06-05 20:00:00	ES	Futures	2660.41	2660.41	2657.68	2657.95	7007.0
2017-06-05 21:00:00	ES	Futures	2658.23	2658.5	2656.86	2658.5	6818.0
2017-06-05 22:00:00	ES	Futures	2658.5	2658.5	2657.41	2657.95	3002.0
2017-06-05 23:00:00	ES	Futures	2657.95	2658.23	2657.13	2657.95	2559.0
2017-06-05 00:00:00	NQ	Futures	7012.85	7014.34	7011.96	7012.56	476.0
2017-06-05 01:00:00	NQ	Futures	7012.26	7017.03	7012.26	7015.84	988.0
2017-06-05 02:00:00	NQ	Futures	7015.84	7016.43	7011.96	7014.34	771.0
2017-06-05 03:00:00	NQ	Futures	7014.34	7016.13	7012.56	7015.24	1176.0
2017-06-05 04:00:00	NQ	Futures	7014.94	7015.24	7011.36	7012.26	1594.0
2017-06-05 05:00:00	NQ	Futures	7012.26	7018.82	7011.06	7013.75	1638.0
2017-06-05 06:00:00	NQ	Futures	7013.75	7013.75	7010.77	7011.06	616.0
2017-06-05 07:00:00	NQ	Futures	7011.36	7013.15	7009.28	7010.47	1720.0
2017-06-05 08:00:00	NQ	Futures	7010.47	7013.45	7009.57	7011.06	2312.0
2017-06-05 09:00:00	NQ	Futures	7011.06	7022.69	7003.61	7018.52	33906.0
2017-06-05 10:00:00	NQ	Futures	7018.52	7025.67	7011.06	7011.66	31237.0
2017-06-05 11:00:00	NQ	Futures	7011.96	7018.52	7006.59	7013.45	26168.0
2017-06-05 12:00:00	NQ	Futures	7013.75	7016.43	7007.49	7010.47	11951.0
2017-06-05 13:00:00	NQ	Futures	7010.17	7015.54	7008.98	7009.87	11830.0
2017-06-05 14:00:00	NQ	Futures	7010.17	7016.13	7009.28	7012.85	11889.0
2017-06-05 15:00:00	NQ	Futures	7012.56	7016.13	7008.98	7012.56	22707.0
2017-06-05 16:00:00	NQ	Futures	7012.85	7015.54	7011.36	7013.45	4356.0
2017-06-05 18:00:00	NQ	Futures	7012.56	7015.24	7011.06	7015.24	495.0
2017-06-05 19:00:00	NQ	Futures	7015.54	7015.84	7013.15	7015.54	425.0
2017-06-05 20:00:00	NQ	Futures	7015.54	7015.84	7008.08	7009.28	1592.0
2017-06-05 21:00:00	NQ	Futures	7009.28	7011.06	7004.51	7009.57	2198.0
2017-06-05 22:00:00	NQ	Futures	7009.87	7010.47	7007.79	7009.28	616.0
2017-06-05 23:00:00	NQ	Futures	7009.28	7011.96	7007.49	7010.47	701.0
2017-06-05 00:00:00	YM	Futures	23032.4	23036.7	23031.3	23035.6	284.0
2017-06-05 01:00:00	YM	Futures	23035.6	23041.1	23034.5	23036.7	707.0
2017-06-05 02:00:00	YM	Futures	23036.7	23036.7	23025.8	23035.6	845.0
2017-06-05 03:00:00	YM	Futures	23036.7	23041.1	23024.8	23031.3	1190.0

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

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