PREVIEW / futures_1hour / 2017-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-31.parquet
  size:    51 KB
  rows:    1,613

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-07-31 00:00:00	ES	Futures	2698.13	2698.68	2697.58	2698.68	1352.0
2017-07-31 01:00:00	ES	Futures	2698.68	2699.22	2698.13	2698.13	2957.0
2017-07-31 02:00:00	ES	Futures	2698.13	2699.77	2697.86	2699.5	7359.0
2017-07-31 03:00:00	ES	Futures	2699.77	2705.79	2698.95	2703.6	38077.0
2017-07-31 04:00:00	ES	Futures	2703.33	2704.15	2702.23	2702.78	12167.0
2017-07-31 05:00:00	ES	Futures	2703.05	2704.97	2701.41	2703.6	17574.0
2017-07-31 06:00:00	ES	Futures	2703.6	2703.6	2702.23	2702.78	10699.0
2017-07-31 07:00:00	ES	Futures	2703.05	2704.42	2702.78	2704.42	12821.0
2017-07-31 08:00:00	ES	Futures	2704.42	2706.06	2703.33	2704.69	18123.0
2017-07-31 09:00:00	ES	Futures	2704.42	2706.06	2700.59	2700.87	115570.0
2017-07-31 10:00:00	ES	Futures	2701.14	2701.41	2695.4	2697.04	202656.0
2017-07-31 11:00:00	ES	Futures	2697.31	2700.87	2697.04	2700.59	103593.0
2017-07-31 12:00:00	ES	Futures	2700.59	2701.69	2698.4	2701.14	73013.0
2017-07-31 13:00:00	ES	Futures	2701.41	2702.51	2699.22	2700.87	76171.0
2017-07-31 14:00:00	ES	Futures	2700.87	2701.41	2698.4	2698.95	66475.0
2017-07-31 15:00:00	ES	Futures	2699.22	2703.05	2697.31	2697.86	273792.0
2017-07-31 16:00:00	ES	Futures	2697.86	2701.14	2697.86	2698.95	126631.0
2017-07-31 18:00:00	ES	Futures	2698.4	2698.95	2696.49	2698.13	5860.0
2017-07-31 19:00:00	ES	Futures	2698.13	2698.4	2697.86	2698.13	2230.0
2017-07-31 20:00:00	ES	Futures	2698.13	2700.59	2697.86	2699.77	6077.0
2017-07-31 21:00:00	ES	Futures	2700.04	2706.88	2699.77	2706.06	19214.0
2017-07-31 22:00:00	ES	Futures	2706.06	2706.06	2704.15	2704.69	4443.0
2017-07-31 23:00:00	ES	Futures	2704.42	2705.24	2703.6	2703.87	3105.0
2017-07-31 00:00:00	NQ	Futures	7031.69	7035.86	7030.2	7034.37	536.0
2017-07-31 01:00:00	NQ	Futures	7034.08	7039.43	7034.08	7039.43	911.0
2017-07-31 02:00:00	NQ	Futures	7039.14	7041.22	7035.27	7038.54	1303.0
2017-07-31 03:00:00	NQ	Futures	7038.84	7066.83	7037.35	7053.13	6208.0
2017-07-31 04:00:00	NQ	Futures	7052.83	7056.11	7048.67	7051.94	2157.0
2017-07-31 05:00:00	NQ	Futures	7052.24	7055.51	7041.52	7052.83	2855.0
2017-07-31 06:00:00	NQ	Futures	7052.83	7053.13	7045.99	7048.96	2004.0
2017-07-31 07:00:00	NQ	Futures	7048.67	7058.19	7048.67	7055.51	2168.0
2017-07-31 08:00:00	NQ	Futures	7055.51	7060.87	7048.96	7055.51	3639.0
2017-07-31 09:00:00	NQ	Futures	7054.92	7065.34	7031.4	7032.88	38067.0
2017-07-31 10:00:00	NQ	Futures	7032.88	7036.46	6991.5	7004.3	75759.0
2017-07-31 11:00:00	NQ	Futures	7004.3	7023.65	7002.22	7020.38	29836.0
2017-07-31 12:00:00	NQ	Futures	7020.38	7022.17	7003.11	7016.81	21948.0
2017-07-31 13:00:00	NQ	Futures	7017.1	7019.19	6994.77	7005.49	21588.0
2017-07-31 14:00:00	NQ	Futures	7005.79	7010.85	6995.07	7001.03	19519.0
2017-07-31 15:00:00	NQ	Futures	7001.03	7015.61	6999.83	7005.19	34503.0
2017-07-31 16:00:00	NQ	Futures	7004.9	7015.32	7004.6	7008.77	8776.0
2017-07-31 18:00:00	NQ	Futures	7008.47	7012.04	6997.75	7002.81	1300.0
2017-07-31 19:00:00	NQ	Futures	7003.11	7005.49	7002.22	7004.9	424.0
2017-07-31 20:00:00	NQ	Futures	7004.9	7015.61	7004.9	7013.83	1369.0
2017-07-31 21:00:00	NQ	Futures	7014.13	7040.03	7012.94	7037.05	4123.0
2017-07-31 22:00:00	NQ	Futures	7036.76	7037.35	7031.99	7035.86	1167.0
2017-07-31 23:00:00	NQ	Futures	7035.56	7037.35	7031.4	7033.18	731.0
2017-07-31 00:00:00	YM	Futures	23691.9	23697.3	23691.9	23696.3	291.0
2017-07-31 01:00:00	YM	Futures	23696.3	23699.5	23694.1	23695.2	468.0
2017-07-31 02:00:00	YM	Futures	23694.1	23711.5	23693.0	23710.4	1418.0
2017-07-31 03:00:00	YM	Futures	23710.4	23780.1	23708.2	23755.0	6854.0

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

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