PREVIEW / futures_1hour / 2017-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-18.parquet
  size:    55 KB
  rows:    1,666

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-18 00:00:00	ES	Futures	2471.56	2475.11	2471.29	2475.11	10473.0
2017-01-18 01:00:00	ES	Futures	2474.83	2475.11	2473.47	2473.47	3163.0
2017-01-18 02:00:00	ES	Futures	2473.47	2474.29	2472.38	2472.65	5370.0
2017-01-18 03:00:00	ES	Futures	2472.92	2473.47	2470.2	2471.29	16825.0
2017-01-18 04:00:00	ES	Futures	2471.29	2471.83	2470.74	2471.56	6157.0
2017-01-18 05:00:00	ES	Futures	2471.56	2472.38	2470.47	2472.38	7564.0
2017-01-18 06:00:00	ES	Futures	2472.38	2472.38	2469.1	2469.38	9411.0
2017-01-18 07:00:00	ES	Futures	2469.38	2472.38	2468.83	2472.1	15288.0
2017-01-18 08:00:00	ES	Futures	2472.1	2474.83	2471.83	2472.92	30122.0
2017-01-18 09:00:00	ES	Futures	2473.2	2473.2	2463.92	2469.65	238486.0
2017-01-18 10:00:00	ES	Futures	2469.92	2472.1	2467.47	2469.92	156181.0
2017-01-18 11:00:00	ES	Futures	2470.2	2471.83	2466.92	2467.74	132006.0
2017-01-18 12:00:00	ES	Futures	2467.47	2470.74	2467.2	2467.74	85644.0
2017-01-18 13:00:00	ES	Futures	2467.47	2470.2	2467.2	2468.56	66114.0
2017-01-18 14:00:00	ES	Futures	2468.56	2471.29	2468.29	2470.74	65867.0
2017-01-18 15:00:00	ES	Futures	2470.47	2473.74	2469.65	2472.92	159918.0
2017-01-18 16:00:00	ES	Futures	2472.92	2474.01	2471.29	2471.56	75358.0
2017-01-18 18:00:00	ES	Futures	2471.83	2473.74	2471.56	2473.2	3950.0
2017-01-18 19:00:00	ES	Futures	2473.2	2474.83	2472.92	2473.74	4844.0
2017-01-18 20:00:00	ES	Futures	2473.47	2473.74	2472.38	2473.2	4001.0
2017-01-18 21:00:00	ES	Futures	2473.2	2473.47	2472.65	2472.92	1719.0
2017-01-18 22:00:00	ES	Futures	2472.92	2473.47	2471.83	2472.65	3497.0
2017-01-18 23:00:00	ES	Futures	2472.38	2472.38	2471.56	2472.1	1639.0
2017-01-18 00:00:00	NQ	Futures	6023.97	6034.71	6023.97	6033.22	1566.0
2017-01-18 01:00:00	NQ	Futures	6032.92	6032.92	6028.45	6029.04	875.0
2017-01-18 02:00:00	NQ	Futures	6029.34	6030.83	6024.57	6025.17	1135.0
2017-01-18 03:00:00	NQ	Futures	6025.46	6027.85	6020.09	6022.78	1713.0
2017-01-18 04:00:00	NQ	Futures	6022.78	6023.97	6020.99	6022.78	822.0
2017-01-18 05:00:00	NQ	Futures	6022.48	6026.66	6019.5	6026.06	1547.0
2017-01-18 06:00:00	NQ	Futures	6026.06	6026.36	6018.01	6018.3	1338.0
2017-01-18 07:00:00	NQ	Futures	6018.3	6027.55	6018.01	6026.96	2052.0
2017-01-18 08:00:00	NQ	Futures	6026.66	6030.83	6023.97	6026.66	4026.0
2017-01-18 09:00:00	NQ	Futures	6026.36	6028.75	6010.85	6027.25	33821.0
2017-01-18 10:00:00	NQ	Futures	6027.55	6031.43	6013.23	6021.29	26868.0
2017-01-18 11:00:00	NQ	Futures	6020.99	6023.38	6006.97	6008.76	18216.0
2017-01-18 12:00:00	NQ	Futures	6008.76	6019.8	6008.16	6010.25	13302.0
2017-01-18 13:00:00	NQ	Futures	6010.25	6018.01	6009.65	6013.83	9227.0
2017-01-18 14:00:00	NQ	Futures	6013.83	6020.09	6012.04	6017.71	9223.0
2017-01-18 15:00:00	NQ	Futures	6017.71	6029.04	6015.02	6026.66	18922.0
2017-01-18 16:00:00	NQ	Futures	6026.96	6032.33	6023.97	6030.54	9510.0
2017-01-18 18:00:00	NQ	Futures	6029.94	6033.82	6028.15	6032.03	1175.0
2017-01-18 19:00:00	NQ	Futures	6032.03	6036.8	6032.03	6033.82	1418.0
2017-01-18 20:00:00	NQ	Futures	6033.82	6034.12	6030.24	6031.43	1048.0
2017-01-18 21:00:00	NQ	Futures	6031.43	6032.33	6028.75	6029.94	532.0
2017-01-18 22:00:00	NQ	Futures	6029.94	6031.13	6026.66	6028.15	620.0
2017-01-18 23:00:00	NQ	Futures	6028.15	6028.45	6026.36	6028.15	304.0
2017-01-18 00:00:00	YM	Futures	21440.4	21468.6	21440.4	21465.3	2233.0
2017-01-18 01:00:00	YM	Futures	21466.4	21466.4	21454.5	21457.8	1011.0
2017-01-18 02:00:00	YM	Futures	21456.7	21462.1	21448.0	21452.3	1378.0
2017-01-18 03:00:00	YM	Futures	21452.3	21457.8	21429.6	21442.6	2641.0

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

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