PREVIEW / futures_1hour / 2017-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-08.parquet
  size:    52 KB
  rows:    1,616

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-08-08 00:00:00	ES	Futures	2705.51	2706.33	2705.51	2706.06	1454.0
2017-08-08 01:00:00	ES	Futures	2706.06	2706.61	2705.79	2706.33	1883.0
2017-08-08 02:00:00	ES	Futures	2706.33	2706.88	2705.79	2706.61	3323.0
2017-08-08 03:00:00	ES	Futures	2706.88	2707.7	2706.06	2707.43	14577.0
2017-08-08 04:00:00	ES	Futures	2707.43	2707.97	2706.33	2706.61	8753.0
2017-08-08 05:00:00	ES	Futures	2706.88	2707.7	2706.61	2707.43	5426.0
2017-08-08 06:00:00	ES	Futures	2707.43	2707.97	2706.61	2707.43	6228.0
2017-08-08 07:00:00	ES	Futures	2707.43	2707.7	2704.42	2704.97	22147.0
2017-08-08 08:00:00	ES	Futures	2704.97	2706.06	2704.42	2705.51	18886.0
2017-08-08 09:00:00	ES	Futures	2705.51	2706.88	2703.33	2706.33	114051.0
2017-08-08 10:00:00	ES	Futures	2706.61	2714.26	2706.06	2713.99	160186.0
2017-08-08 11:00:00	ES	Futures	2713.99	2719.73	2713.44	2719.45	157902.0
2017-08-08 12:00:00	ES	Futures	2719.45	2720.82	2713.71	2713.71	155594.0
2017-08-08 13:00:00	ES	Futures	2713.99	2714.81	2709.07	2712.07	127325.0
2017-08-08 14:00:00	ES	Futures	2712.07	2712.35	2707.7	2708.25	87575.0
2017-08-08 15:00:00	ES	Futures	2708.25	2708.79	2697.86	2702.78	374661.0
2017-08-08 16:00:00	ES	Futures	2703.05	2704.15	2701.96	2701.96	74375.0
2017-08-08 18:00:00	ES	Futures	2700.59	2701.14	2698.13	2699.22	14348.0
2017-08-08 19:00:00	ES	Futures	2699.5	2699.5	2696.49	2697.58	8986.0
2017-08-08 20:00:00	ES	Futures	2697.58	2698.13	2691.3	2693.21	21064.0
2017-08-08 21:00:00	ES	Futures	2693.48	2695.12	2691.84	2694.3	10976.0
2017-08-08 22:00:00	ES	Futures	2694.3	2696.22	2693.21	2694.85	7515.0
2017-08-08 23:00:00	ES	Futures	2694.85	2695.94	2694.03	2694.3	5330.0
2017-08-08 00:00:00	NQ	Futures	7060.28	7062.96	7060.28	7062.36	351.0
2017-08-08 01:00:00	NQ	Futures	7062.36	7065.93	7062.06	7065.04	573.0
2017-08-08 02:00:00	NQ	Futures	7065.04	7065.93	7062.96	7065.64	559.0
2017-08-08 03:00:00	NQ	Futures	7065.64	7069.51	7063.85	7067.13	1823.0
2017-08-08 04:00:00	NQ	Futures	7066.83	7069.81	7063.26	7066.23	921.0
2017-08-08 05:00:00	NQ	Futures	7066.23	7067.13	7063.55	7066.53	595.0
2017-08-08 06:00:00	NQ	Futures	7066.53	7069.51	7064.74	7065.64	886.0
2017-08-08 07:00:00	NQ	Futures	7066.23	7067.42	7056.11	7059.38	2927.0
2017-08-08 08:00:00	NQ	Futures	7059.38	7060.87	7049.86	7053.43	5125.0
2017-08-08 09:00:00	NQ	Futures	7053.13	7058.79	7041.22	7056.7	43349.0
2017-08-08 10:00:00	NQ	Futures	7056.41	7075.46	7053.13	7074.87	39346.0
2017-08-08 11:00:00	NQ	Futures	7074.87	7107.02	7070.4	7105.24	43056.0
2017-08-08 12:00:00	NQ	Futures	7105.24	7113.57	7098.69	7098.99	31226.0
2017-08-08 13:00:00	NQ	Futures	7099.28	7103.45	7083.5	7092.73	27528.0
2017-08-08 14:00:00	NQ	Futures	7092.73	7093.33	7081.12	7083.2	19460.0
2017-08-08 15:00:00	NQ	Futures	7083.5	7084.1	7035.86	7056.41	70706.0
2017-08-08 16:00:00	NQ	Futures	7056.41	7061.47	7043.9	7043.9	8753.0
2017-08-08 18:00:00	NQ	Futures	7042.71	7042.71	7032.88	7037.05	2102.0
2017-08-08 19:00:00	NQ	Futures	7036.76	7038.84	7021.27	7028.42	2343.0
2017-08-08 20:00:00	NQ	Futures	7028.42	7029.61	7008.17	7017.4	4342.0
2017-08-08 21:00:00	NQ	Futures	7017.4	7022.17	7010.85	7018.0	2493.0
2017-08-08 22:00:00	NQ	Futures	7018.29	7021.87	7011.45	7016.81	1973.0
2017-08-08 23:00:00	NQ	Futures	7017.1	7020.97	7015.61	7018.0	939.0
2017-08-08 00:00:00	YM	Futures	23998.8	24005.4	23998.8	24004.3	325.0
2017-08-08 01:00:00	YM	Futures	24004.3	24009.7	24003.2	24009.7	387.0
2017-08-08 02:00:00	YM	Futures	24009.7	24010.8	23999.9	24004.3	596.0
2017-08-08 03:00:00	YM	Futures	24005.4	24017.4	24002.1	24013.0	1207.0

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

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