PREVIEW / futures_1hour / 2017-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-16.parquet
  size:    38 KB
  rows:    1,175

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-01-16 00:00:00	ES	Futures	2474.29	2474.56	2473.47	2474.29	1855.0
2017-01-16 01:00:00	ES	Futures	2474.29	2474.29	2472.1	2473.2	4085.0
2017-01-16 02:00:00	ES	Futures	2473.2	2473.47	2472.38	2473.2	3518.0
2017-01-16 03:00:00	ES	Futures	2472.92	2474.56	2471.29	2472.65	13883.0
2017-01-16 04:00:00	ES	Futures	2472.65	2474.01	2471.83	2474.01	6703.0
2017-01-16 05:00:00	ES	Futures	2473.74	2474.56	2472.92	2474.01	4367.0
2017-01-16 06:00:00	ES	Futures	2474.29	2474.29	2472.92	2473.47	3120.0
2017-01-16 07:00:00	ES	Futures	2473.74	2475.38	2472.92	2475.38	4977.0
2017-01-16 08:00:00	ES	Futures	2475.11	2475.38	2473.47	2473.74	4778.0
2017-01-16 09:00:00	ES	Futures	2473.74	2474.01	2471.83	2471.83	9406.0
2017-01-16 10:00:00	ES	Futures	2471.83	2473.47	2471.83	2473.47	9146.0
2017-01-16 11:00:00	ES	Futures	2473.47	2474.29	2472.65	2473.47	7845.0
2017-01-16 12:00:00	ES	Futures	2473.2	2474.01	2471.56	2472.38	7968.0
2017-01-16 18:00:00	ES	Futures	2472.1	2473.47	2471.83	2472.92	2290.0
2017-01-16 19:00:00	ES	Futures	2472.92	2472.92	2471.56	2471.56	3366.0
2017-01-16 20:00:00	ES	Futures	2471.56	2473.47	2471.56	2473.2	4307.0
2017-01-16 21:00:00	ES	Futures	2472.92	2473.74	2472.65	2473.47	1826.0
2017-01-16 22:00:00	ES	Futures	2473.74	2473.74	2472.92	2473.47	1993.0
2017-01-16 23:00:00	ES	Futures	2473.47	2474.01	2472.92	2473.47	2044.0
2017-01-16 00:00:00	NQ	Futures	6028.15	6028.75	6026.96	6027.85	413.0
2017-01-16 01:00:00	NQ	Futures	6027.85	6028.15	6023.38	6025.46	822.0
2017-01-16 02:00:00	NQ	Futures	6025.17	6025.17	6022.48	6025.17	720.0
2017-01-16 03:00:00	NQ	Futures	6025.17	6026.66	6019.2	6021.59	2425.0
2017-01-16 04:00:00	NQ	Futures	6021.88	6029.04	6020.99	6028.75	1321.0
2017-01-16 05:00:00	NQ	Futures	6028.75	6031.43	6028.15	6029.94	1079.0
2017-01-16 06:00:00	NQ	Futures	6029.94	6031.43	6028.75	6029.64	702.0
2017-01-16 07:00:00	NQ	Futures	6029.64	6032.92	6028.15	6032.62	662.0
2017-01-16 08:00:00	NQ	Futures	6032.62	6032.92	6030.54	6031.43	673.0
2017-01-16 09:00:00	NQ	Futures	6031.13	6031.73	6026.36	6026.36	1637.0
2017-01-16 10:00:00	NQ	Futures	6026.36	6029.64	6026.06	6029.64	1160.0
2017-01-16 11:00:00	NQ	Futures	6029.64	6030.83	6026.96	6029.04	1153.0
2017-01-16 12:00:00	NQ	Futures	6029.34	6030.83	6025.17	6026.36	1232.0
2017-01-16 18:00:00	NQ	Futures	6027.85	6029.34	6025.46	6027.85	716.0
2017-01-16 19:00:00	NQ	Futures	6027.85	6027.85	6022.78	6024.27	895.0
2017-01-16 20:00:00	NQ	Futures	6024.27	6028.75	6024.27	6028.15	766.0
2017-01-16 21:00:00	NQ	Futures	6027.85	6029.34	6026.66	6028.75	459.0
2017-01-16 22:00:00	NQ	Futures	6029.04	6029.34	6027.55	6029.04	423.0
2017-01-16 23:00:00	NQ	Futures	6029.34	6030.24	6027.25	6029.34	494.0
2017-01-16 00:00:00	YM	Futures	21468.6	21469.7	21462.1	21464.3	511.0
2017-01-16 01:00:00	YM	Futures	21464.3	21464.3	21451.2	21461.0	763.0
2017-01-16 02:00:00	YM	Futures	21459.9	21459.9	21452.3	21458.8	675.0
2017-01-16 03:00:00	YM	Futures	21457.8	21477.3	21445.8	21461.0	2831.0
2017-01-16 04:00:00	YM	Futures	21461.0	21472.9	21453.4	21472.9	1009.0
2017-01-16 05:00:00	YM	Futures	21472.9	21480.5	21465.3	21472.9	761.0
2017-01-16 06:00:00	YM	Futures	21472.9	21472.9	21459.9	21465.3	471.0
2017-01-16 07:00:00	YM	Futures	21465.3	21486.0	21463.2	21483.8	1097.0
2017-01-16 08:00:00	YM	Futures	21483.8	21483.8	21469.7	21469.7	851.0
2017-01-16 09:00:00	YM	Futures	21469.7	21471.9	21448.0	21448.0	2090.0
2017-01-16 10:00:00	YM	Futures	21449.1	21469.7	21448.0	21467.5	1423.0
2017-01-16 11:00:00	YM	Futures	21467.5	21471.9	21459.9	21464.3	861.0

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

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