PREVIEW / futures_1hour / 2017-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-17.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-17 00:00:00	ES	Futures	2473.47	2473.47	2472.1	2472.1	2567.0
2017-01-17 01:00:00	ES	Futures	2472.38	2472.38	2470.47	2471.01	5667.0
2017-01-17 02:00:00	ES	Futures	2471.01	2471.83	2470.74	2471.56	4561.0
2017-01-17 03:00:00	ES	Futures	2471.56	2471.83	2467.47	2469.1	26644.0
2017-01-17 04:00:00	ES	Futures	2469.1	2470.2	2468.29	2468.56	15713.0
2017-01-17 05:00:00	ES	Futures	2468.56	2469.65	2465.29	2466.1	20289.0
2017-01-17 06:00:00	ES	Futures	2466.1	2468.01	2463.1	2466.92	28373.0
2017-01-17 07:00:00	ES	Futures	2467.2	2472.92	2466.65	2472.38	36526.0
2017-01-17 08:00:00	ES	Futures	2472.38	2472.38	2468.83	2471.01	37273.0
2017-01-17 09:00:00	ES	Futures	2470.74	2471.01	2465.56	2466.65	212926.0
2017-01-17 10:00:00	ES	Futures	2466.92	2473.74	2465.56	2472.65	208132.0
2017-01-17 11:00:00	ES	Futures	2472.92	2472.92	2468.01	2471.56	123142.0
2017-01-17 12:00:00	ES	Futures	2471.56	2472.65	2469.1	2470.47	91002.0
2017-01-17 13:00:00	ES	Futures	2470.47	2472.92	2470.2	2471.56	58168.0
2017-01-17 14:00:00	ES	Futures	2471.56	2472.38	2463.38	2465.29	174883.0
2017-01-17 15:00:00	ES	Futures	2465.29	2468.83	2462.83	2468.29	273394.0
2017-01-17 16:00:00	ES	Futures	2468.29	2469.38	2467.2	2468.29	97760.0
2017-01-17 18:00:00	ES	Futures	2468.01	2469.38	2467.2	2468.83	3914.0
2017-01-17 19:00:00	ES	Futures	2468.83	2469.65	2468.01	2468.01	2595.0
2017-01-17 20:00:00	ES	Futures	2468.01	2470.2	2467.74	2469.92	4187.0
2017-01-17 21:00:00	ES	Futures	2469.92	2471.29	2469.65	2471.01	4056.0
2017-01-17 22:00:00	ES	Futures	2471.29	2471.83	2470.47	2471.29	3953.0
2017-01-17 23:00:00	ES	Futures	2471.29	2471.56	2471.01	2471.29	1752.0
2017-01-17 00:00:00	NQ	Futures	6029.34	6029.34	6024.87	6025.76	454.0
2017-01-17 01:00:00	NQ	Futures	6025.76	6025.76	6021.88	6023.08	709.0
2017-01-17 02:00:00	NQ	Futures	6023.38	6025.17	6022.48	6024.57	796.0
2017-01-17 03:00:00	NQ	Futures	6024.57	6024.87	6015.62	6019.8	3218.0
2017-01-17 04:00:00	NQ	Futures	6019.5	6021.88	6017.41	6018.01	1565.0
2017-01-17 05:00:00	NQ	Futures	6018.01	6018.01	6006.07	6008.16	3295.0
2017-01-17 06:00:00	NQ	Futures	6007.86	6013.53	6002.19	6010.25	5017.0
2017-01-17 07:00:00	NQ	Futures	6010.55	6024.57	6009.65	6022.48	4728.0
2017-01-17 08:00:00	NQ	Futures	6022.48	6024.27	6013.53	6020.69	5341.0
2017-01-17 09:00:00	NQ	Futures	6020.69	6021.59	5996.23	6004.28	35762.0
2017-01-17 10:00:00	NQ	Futures	6004.58	6024.87	6001.6	6023.97	32330.0
2017-01-17 11:00:00	NQ	Futures	6024.27	6026.06	6011.44	6021.59	17433.0
2017-01-17 12:00:00	NQ	Futures	6021.59	6021.88	6011.44	6013.53	10507.0
2017-01-17 13:00:00	NQ	Futures	6013.83	6020.69	6011.74	6017.11	8300.0
2017-01-17 14:00:00	NQ	Futures	6017.11	6022.18	6000.7	6006.97	18622.0
2017-01-17 15:00:00	NQ	Futures	6006.67	6014.72	5999.51	6014.72	22728.0
2017-01-17 16:00:00	NQ	Futures	6014.43	6015.62	6012.04	6014.13	4901.0
2017-01-17 18:00:00	NQ	Futures	6014.72	6016.51	6010.85	6016.22	982.0
2017-01-17 19:00:00	NQ	Futures	6015.92	6018.3	6010.85	6011.44	833.0
2017-01-17 20:00:00	NQ	Futures	6011.44	6020.39	6011.44	6019.5	965.0
2017-01-17 21:00:00	NQ	Futures	6019.8	6023.67	6018.9	6022.18	844.0
2017-01-17 22:00:00	NQ	Futures	6022.18	6024.27	6019.8	6022.78	601.0
2017-01-17 23:00:00	NQ	Futures	6022.48	6024.57	6022.18	6023.97	302.0
2017-01-17 00:00:00	YM	Futures	21468.6	21468.6	21456.7	21456.7	512.0
2017-01-17 01:00:00	YM	Futures	21456.7	21457.8	21446.9	21451.2	879.0
2017-01-17 02:00:00	YM	Futures	21451.2	21454.5	21446.9	21454.5	825.0
2017-01-17 03:00:00	YM	Futures	21454.5	21455.6	21425.2	21436.1	2904.0

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

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