PREVIEW / futures_1hour / 2017-01-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2469.38	2471.29	2469.38	2470.47	2959.0
2017-01-05 01:00:00	ES	Futures	2470.74	2471.29	2467.47	2467.74	5683.0
2017-01-05 02:00:00	ES	Futures	2467.74	2468.29	2466.1	2466.92	8825.0
2017-01-05 03:00:00	ES	Futures	2466.65	2469.65	2466.38	2467.74	13888.0
2017-01-05 04:00:00	ES	Futures	2467.74	2470.74	2467.74	2470.47	10087.0
2017-01-05 05:00:00	ES	Futures	2470.47	2470.74	2466.65	2469.92	13194.0
2017-01-05 06:00:00	ES	Futures	2469.92	2470.2	2468.29	2469.1	7127.0
2017-01-05 07:00:00	ES	Futures	2468.83	2469.38	2464.47	2465.29	22430.0
2017-01-05 08:00:00	ES	Futures	2465.29	2468.83	2465.01	2467.74	30986.0
2017-01-05 09:00:00	ES	Futures	2467.74	2471.29	2466.38	2469.38	135132.0
2017-01-05 10:00:00	ES	Futures	2469.1	2471.56	2466.92	2468.83	174090.0
2017-01-05 11:00:00	ES	Futures	2468.56	2469.38	2459.28	2461.47	259055.0
2017-01-05 12:00:00	ES	Futures	2461.74	2465.01	2460.38	2464.19	117653.0
2017-01-05 13:00:00	ES	Futures	2463.92	2466.65	2463.65	2465.01	83933.0
2017-01-05 14:00:00	ES	Futures	2465.01	2468.29	2465.01	2465.29	100403.0
2017-01-05 15:00:00	ES	Futures	2465.29	2471.01	2464.74	2469.65	218174.0
2017-01-05 16:00:00	ES	Futures	2469.38	2471.29	2468.83	2471.29	80412.0
2017-01-05 18:00:00	ES	Futures	2470.47	2471.56	2469.65	2469.65	4606.0
2017-01-05 19:00:00	ES	Futures	2469.65	2469.92	2468.83	2469.92	3432.0
2017-01-05 20:00:00	ES	Futures	2469.65	2471.29	2469.65	2470.74	2770.0
2017-01-05 21:00:00	ES	Futures	2470.74	2471.29	2470.47	2470.74	1114.0
2017-01-05 22:00:00	ES	Futures	2470.74	2471.01	2470.2	2470.47	1851.0
2017-01-05 23:00:00	ES	Futures	2470.47	2470.74	2469.65	2469.65	1247.0
2017-01-05 00:00:00	NQ	Futures	5882.57	5885.85	5881.97	5884.66	471.0
2017-01-05 01:00:00	NQ	Futures	5885.25	5886.15	5878.09	5878.39	882.0
2017-01-05 02:00:00	NQ	Futures	5878.39	5880.48	5873.92	5875.41	1525.0
2017-01-05 03:00:00	NQ	Futures	5874.81	5883.46	5872.72	5877.2	1644.0
2017-01-05 04:00:00	NQ	Futures	5877.8	5886.75	5877.5	5885.85	948.0
2017-01-05 05:00:00	NQ	Futures	5886.15	5886.15	5876.3	5884.06	1391.0
2017-01-05 06:00:00	NQ	Futures	5884.06	5884.66	5879.29	5881.08	1015.0
2017-01-05 07:00:00	NQ	Futures	5880.78	5881.67	5871.53	5872.72	2135.0
2017-01-05 08:00:00	NQ	Futures	5872.72	5882.57	5872.43	5880.78	2694.0
2017-01-05 09:00:00	NQ	Futures	5881.08	5915.38	5876.6	5908.52	31933.0
2017-01-05 10:00:00	NQ	Futures	5909.42	5916.88	5902.26	5910.61	27212.0
2017-01-05 11:00:00	NQ	Futures	5910.91	5913.59	5893.9	5904.05	27150.0
2017-01-05 12:00:00	NQ	Futures	5904.35	5912.4	5900.77	5910.01	13119.0
2017-01-05 13:00:00	NQ	Futures	5909.72	5913.59	5907.93	5908.82	9655.0
2017-01-05 14:00:00	NQ	Futures	5908.52	5915.38	5908.22	5910.61	11222.0
2017-01-05 15:00:00	NQ	Futures	5910.91	5923.74	5909.42	5918.96	22140.0
2017-01-05 16:00:00	NQ	Futures	5919.26	5922.54	5917.17	5922.25	6111.0
2017-01-05 18:00:00	NQ	Futures	5921.65	5922.54	5918.96	5919.26	901.0
2017-01-05 19:00:00	NQ	Futures	5918.96	5921.05	5917.47	5921.05	782.0
2017-01-05 20:00:00	NQ	Futures	5920.75	5923.74	5919.86	5922.84	607.0
2017-01-05 21:00:00	NQ	Futures	5922.54	5923.44	5921.65	5922.84	183.0
2017-01-05 22:00:00	NQ	Futures	5922.84	5922.84	5920.75	5922.54	327.0
2017-01-05 23:00:00	NQ	Futures	5922.84	5922.84	5920.46	5920.46	264.0
2017-01-05 00:00:00	YM	Futures	21532.6	21542.4	21529.3	21541.3	870.0
2017-01-05 01:00:00	YM	Futures	21542.4	21544.5	21515.2	21516.3	1004.0
2017-01-05 02:00:00	YM	Futures	21516.3	21527.2	21509.8	21519.6	1778.0
2017-01-05 03:00:00	YM	Futures	21517.4	21539.1	21514.2	21528.3	2195.0

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

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