PREVIEW / futures_1hour / 2017-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-06.parquet
  size:    46 KB
  rows:    1,331

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-06 00:00:00	ES	Futures	2469.65	2469.92	2468.83	2469.38	2495.0
2017-01-06 01:00:00	ES	Futures	2469.65	2469.92	2469.38	2469.65	1433.0
2017-01-06 02:00:00	ES	Futures	2469.38	2469.38	2467.74	2468.56	5347.0
2017-01-06 03:00:00	ES	Futures	2468.56	2469.65	2467.47	2468.56	9985.0
2017-01-06 04:00:00	ES	Futures	2468.56	2469.38	2468.01	2468.01	6389.0
2017-01-06 05:00:00	ES	Futures	2468.01	2469.92	2468.01	2469.65	5042.0
2017-01-06 06:00:00	ES	Futures	2469.65	2470.2	2469.1	2469.65	4394.0
2017-01-06 07:00:00	ES	Futures	2469.65	2470.74	2468.01	2468.29	7745.0
2017-01-06 08:00:00	ES	Futures	2468.01	2473.2	2467.47	2472.92	47921.0
2017-01-06 09:00:00	ES	Futures	2472.92	2473.2	2463.92	2469.65	230389.0
2017-01-06 10:00:00	ES	Futures	2469.65	2473.2	2466.92	2471.29	191056.0
2017-01-06 11:00:00	ES	Futures	2471.56	2480.83	2470.74	2479.47	233684.0
2017-01-06 12:00:00	ES	Futures	2479.2	2484.38	2478.11	2483.29	173794.0
2017-01-06 13:00:00	ES	Futures	2483.29	2483.56	2480.02	2481.92	103095.0
2017-01-06 14:00:00	ES	Futures	2481.92	2484.38	2480.29	2480.56	132615.0
2017-01-06 15:00:00	ES	Futures	2480.83	2482.47	2478.11	2478.65	280642.0
2017-01-06 16:00:00	ES	Futures	2478.65	2480.29	2477.56	2477.56	90057.0
2017-01-06 00:00:00	NQ	Futures	5921.05	5921.35	5919.56	5921.05	458.0
2017-01-06 01:00:00	NQ	Futures	5921.05	5922.25	5920.75	5921.95	408.0
2017-01-06 02:00:00	NQ	Futures	5921.35	5921.35	5918.37	5919.26	765.0
2017-01-06 03:00:00	NQ	Futures	5918.96	5921.35	5916.58	5919.86	1460.0
2017-01-06 04:00:00	NQ	Futures	5919.86	5922.25	5918.96	5919.86	637.0
2017-01-06 05:00:00	NQ	Futures	5919.56	5923.14	5919.26	5921.35	499.0
2017-01-06 06:00:00	NQ	Futures	5921.65	5924.33	5920.46	5923.74	718.0
2017-01-06 07:00:00	NQ	Futures	5923.74	5926.12	5919.86	5920.16	1202.0
2017-01-06 08:00:00	NQ	Futures	5920.46	5930.6	5918.67	5928.51	5414.0
2017-01-06 09:00:00	NQ	Futures	5928.81	5940.14	5909.72	5938.95	38656.0
2017-01-06 10:00:00	NQ	Futures	5939.25	5953.87	5931.19	5949.39	31991.0
2017-01-06 11:00:00	NQ	Futures	5949.39	5969.38	5947.9	5967.59	27803.0
2017-01-06 12:00:00	NQ	Futures	5967.89	5982.8	5966.1	5980.72	16903.0
2017-01-06 13:00:00	NQ	Futures	5981.01	5982.8	5972.06	5978.63	12535.0
2017-01-06 14:00:00	NQ	Futures	5978.93	5987.28	5976.54	5978.03	14854.0
2017-01-06 15:00:00	NQ	Futures	5978.03	5981.01	5968.78	5970.57	20144.0
2017-01-06 16:00:00	NQ	Futures	5970.57	5975.64	5969.38	5972.06	5191.0
2017-01-06 00:00:00	YM	Futures	21494.6	21495.7	21490.3	21494.6	449.0
2017-01-06 01:00:00	YM	Futures	21495.7	21499.0	21492.5	21496.8	260.0
2017-01-06 02:00:00	YM	Futures	21496.8	21496.8	21486.0	21490.3	955.0
2017-01-06 03:00:00	YM	Futures	21490.3	21496.8	21481.6	21491.4	1345.0
2017-01-06 04:00:00	YM	Futures	21490.3	21492.5	21478.4	21480.5	1275.0
2017-01-06 05:00:00	YM	Futures	21479.4	21492.5	21478.4	21490.3	859.0
2017-01-06 06:00:00	YM	Futures	21491.4	21493.6	21486.0	21490.3	528.0
2017-01-06 07:00:00	YM	Futures	21489.2	21495.7	21475.1	21475.1	1014.0
2017-01-06 08:00:00	YM	Futures	21475.1	21518.5	21472.9	21517.4	6828.0
2017-01-06 09:00:00	YM	Futures	21517.4	21518.5	21435.0	21483.8	21764.0
2017-01-06 10:00:00	YM	Futures	21482.7	21525.0	21474.0	21514.2	18839.0
2017-01-06 11:00:00	YM	Futures	21513.1	21590.1	21510.9	21572.7	18471.0
2017-01-06 12:00:00	YM	Futures	21571.7	21614.0	21566.2	21604.2	12316.0
2017-01-06 13:00:00	YM	Futures	21604.2	21610.7	21580.3	21596.6	8396.0
2017-01-06 14:00:00	YM	Futures	21595.5	21609.6	21582.5	21590.1	8104.0
2017-01-06 15:00:00	YM	Futures	21590.1	21606.4	21572.7	21576.0	12396.0

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

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