PREVIEW / futures_1hour / 2017-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-12.parquet
  size:    54 KB
  rows:    1,621

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-12 00:00:00	ES	Futures	2471.01	2471.83	2470.74	2471.56	3030.0
2017-01-12 01:00:00	ES	Futures	2471.56	2471.83	2470.47	2471.01	2851.0
2017-01-12 02:00:00	ES	Futures	2471.01	2471.56	2468.83	2468.83	7230.0
2017-01-12 03:00:00	ES	Futures	2468.83	2469.92	2466.92	2467.2	23788.0
2017-01-12 04:00:00	ES	Futures	2467.2	2470.2	2466.65	2469.38	15389.0
2017-01-12 05:00:00	ES	Futures	2469.38	2471.29	2469.1	2469.92	8435.0
2017-01-12 06:00:00	ES	Futures	2469.92	2471.29	2469.1	2470.2	9853.0
2017-01-12 07:00:00	ES	Futures	2469.92	2471.83	2469.65	2471.56	15705.0
2017-01-12 08:00:00	ES	Futures	2471.83	2472.38	2470.2	2471.29	17684.0
2017-01-12 09:00:00	ES	Futures	2471.29	2472.1	2463.38	2465.01	237115.0
2017-01-12 10:00:00	ES	Futures	2465.29	2465.56	2456.01	2456.56	374330.0
2017-01-12 11:00:00	ES	Futures	2456.83	2459.56	2453.28	2457.38	226154.0
2017-01-12 12:00:00	ES	Futures	2457.65	2466.1	2457.38	2464.47	179897.0
2017-01-12 13:00:00	ES	Futures	2464.47	2469.38	2463.65	2468.01	135410.0
2017-01-12 14:00:00	ES	Futures	2468.01	2472.38	2466.92	2471.56	135814.0
2017-01-12 15:00:00	ES	Futures	2471.83	2473.74	2468.29	2471.29	235802.0
2017-01-12 16:00:00	ES	Futures	2471.56	2471.83	2469.1	2471.01	81277.0
2017-01-12 18:00:00	ES	Futures	2470.74	2472.38	2470.47	2471.56	4889.0
2017-01-12 19:00:00	ES	Futures	2471.29	2471.83	2470.47	2471.01	3026.0
2017-01-12 20:00:00	ES	Futures	2471.01	2472.1	2470.74	2471.83	2961.0
2017-01-12 21:00:00	ES	Futures	2471.83	2472.65	2471.29	2472.38	3071.0
2017-01-12 22:00:00	ES	Futures	2472.38	2472.92	2472.1	2472.38	2072.0
2017-01-12 23:00:00	ES	Futures	2472.65	2472.65	2471.56	2471.83	1283.0
2017-01-12 00:00:00	NQ	Futures	6008.16	6011.14	6007.86	6009.35	589.0
2017-01-12 01:00:00	NQ	Futures	6009.06	6009.95	6005.77	6006.97	732.0
2017-01-12 02:00:00	NQ	Futures	6006.67	6008.76	6005.18	6005.18	1125.0
2017-01-12 03:00:00	NQ	Futures	6005.18	6007.56	6001.3	6001.6	3744.0
2017-01-12 04:00:00	NQ	Futures	6001.9	6007.86	5999.81	6005.48	2636.0
2017-01-12 05:00:00	NQ	Futures	6005.48	6009.95	6003.98	6005.18	1494.0
2017-01-12 06:00:00	NQ	Futures	6005.18	6009.95	6003.69	6005.18	1995.0
2017-01-12 07:00:00	NQ	Futures	6005.18	6006.37	6001.0	6006.07	3414.0
2017-01-12 08:00:00	NQ	Futures	6006.07	6006.97	6001.9	6004.28	2669.0
2017-01-12 09:00:00	NQ	Futures	6003.98	6004.28	5979.82	5987.58	32116.0
2017-01-12 10:00:00	NQ	Futures	5987.58	5990.56	5960.73	5963.12	50837.0
2017-01-12 11:00:00	NQ	Futures	5963.12	5978.33	5954.76	5975.05	26213.0
2017-01-12 12:00:00	NQ	Futures	5975.64	5993.54	5974.75	5989.96	19643.0
2017-01-12 13:00:00	NQ	Futures	5989.67	6003.09	5988.17	5998.91	16215.0
2017-01-12 14:00:00	NQ	Futures	5998.91	6006.97	5995.04	6005.48	16709.0
2017-01-12 15:00:00	NQ	Futures	6005.18	6015.02	5999.51	6011.14	19108.0
2017-01-12 16:00:00	NQ	Futures	6010.85	6012.04	6006.97	6011.74	4898.0
2017-01-12 18:00:00	NQ	Futures	6008.46	6014.13	6008.46	6011.44	1104.0
2017-01-12 19:00:00	NQ	Futures	6011.44	6012.64	6009.65	6011.44	668.0
2017-01-12 20:00:00	NQ	Futures	6011.44	6016.51	6010.25	6015.32	765.0
2017-01-12 21:00:00	NQ	Futures	6015.02	6016.51	6013.53	6016.22	442.0
2017-01-12 22:00:00	NQ	Futures	6016.22	6016.81	6015.02	6015.32	484.0
2017-01-12 23:00:00	NQ	Futures	6015.62	6015.92	6012.34	6015.02	389.0
2017-01-12 00:00:00	YM	Futures	21505.5	21515.2	21504.4	21513.1	743.0
2017-01-12 01:00:00	YM	Futures	21513.1	21519.6	21506.6	21512.0	998.0
2017-01-12 02:00:00	YM	Futures	21510.9	21516.3	21507.7	21507.7	1523.0
2017-01-12 03:00:00	YM	Futures	21507.7	21514.2	21491.4	21493.6	3124.0

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

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