PREVIEW / futures_1hour / 2017-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-13.parquet
  size:    45 KB
  rows:    1,323

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-13 00:00:00	ES	Futures	2472.1	2472.1	2471.56	2471.83	1217.0
2017-01-13 01:00:00	ES	Futures	2471.83	2472.1	2471.56	2472.1	1863.0
2017-01-13 02:00:00	ES	Futures	2472.1	2472.38	2471.29	2471.56	4012.0
2017-01-13 03:00:00	ES	Futures	2471.56	2472.92	2470.74	2471.01	13680.0
2017-01-13 04:00:00	ES	Futures	2471.29	2472.65	2470.74	2472.38	9071.0
2017-01-13 05:00:00	ES	Futures	2472.65	2474.29	2471.83	2474.29	10308.0
2017-01-13 06:00:00	ES	Futures	2474.01	2474.29	2471.83	2472.1	9931.0
2017-01-13 07:00:00	ES	Futures	2472.38	2473.47	2471.83	2473.47	10686.0
2017-01-13 08:00:00	ES	Futures	2473.47	2474.01	2468.83	2472.92	32749.0
2017-01-13 09:00:00	ES	Futures	2472.92	2480.56	2472.1	2478.11	204345.0
2017-01-13 10:00:00	ES	Futures	2478.38	2479.47	2476.2	2478.11	155349.0
2017-01-13 11:00:00	ES	Futures	2478.11	2479.74	2476.47	2478.92	108672.0
2017-01-13 12:00:00	ES	Futures	2479.2	2479.47	2474.01	2477.01	113586.0
2017-01-13 13:00:00	ES	Futures	2477.29	2477.83	2475.65	2476.2	63089.0
2017-01-13 14:00:00	ES	Futures	2475.92	2476.74	2472.65	2476.2	128569.0
2017-01-13 15:00:00	ES	Futures	2475.92	2478.38	2474.29	2476.47	194196.0
2017-01-13 16:00:00	ES	Futures	2476.47	2480.02	2475.38	2477.56	104284.0
2017-01-13 00:00:00	NQ	Futures	6014.72	6015.02	6013.23	6014.13	286.0
2017-01-13 01:00:00	NQ	Futures	6014.72	6015.32	6013.53	6015.32	391.0
2017-01-13 02:00:00	NQ	Futures	6015.32	6015.62	6012.04	6013.23	728.0
2017-01-13 03:00:00	NQ	Futures	6012.93	6018.01	6010.25	6012.34	2112.0
2017-01-13 04:00:00	NQ	Futures	6012.34	6015.32	6009.65	6015.32	1024.0
2017-01-13 05:00:00	NQ	Futures	6015.32	6019.8	6014.43	6019.2	1675.0
2017-01-13 06:00:00	NQ	Futures	6018.9	6019.2	6015.62	6017.41	1310.0
2017-01-13 07:00:00	NQ	Futures	6017.41	6020.39	6015.92	6019.2	1629.0
2017-01-13 08:00:00	NQ	Futures	6019.5	6020.69	6011.44	6017.71	4179.0
2017-01-13 09:00:00	NQ	Futures	6017.71	6037.69	6014.13	6030.83	29834.0
2017-01-13 10:00:00	NQ	Futures	6031.13	6039.19	6023.08	6034.71	20119.0
2017-01-13 11:00:00	NQ	Futures	6035.01	6041.87	6028.75	6040.68	14742.0
2017-01-13 12:00:00	NQ	Futures	6040.68	6041.57	6028.45	6036.5	12098.0
2017-01-13 13:00:00	NQ	Futures	6036.5	6039.78	6034.71	6035.31	6898.0
2017-01-13 14:00:00	NQ	Futures	6035.31	6037.69	6027.25	6034.12	12073.0
2017-01-13 15:00:00	NQ	Futures	6034.12	6035.01	6027.55	6031.73	16261.0
2017-01-13 16:00:00	NQ	Futures	6031.73	6040.98	6029.94	6038.59	6936.0
2017-01-13 00:00:00	YM	Futures	21499.0	21501.1	21497.9	21501.1	277.0
2017-01-13 01:00:00	YM	Futures	21501.1	21503.3	21497.9	21501.1	417.0
2017-01-13 02:00:00	YM	Futures	21501.1	21504.4	21493.6	21494.6	875.0
2017-01-13 03:00:00	YM	Futures	21494.6	21505.5	21488.1	21492.5	2556.0
2017-01-13 04:00:00	YM	Futures	21492.5	21500.1	21486.0	21500.1	964.0
2017-01-13 05:00:00	YM	Futures	21499.0	21513.1	21492.5	21510.9	1629.0
2017-01-13 06:00:00	YM	Futures	21512.0	21513.1	21500.1	21507.7	1473.0
2017-01-13 07:00:00	YM	Futures	21507.7	21513.1	21502.2	21510.9	1670.0
2017-01-13 08:00:00	YM	Futures	21509.8	21519.6	21479.4	21504.4	5181.0
2017-01-13 09:00:00	YM	Futures	21504.4	21563.0	21499.0	21523.9	19739.0
2017-01-13 10:00:00	YM	Futures	21522.8	21542.4	21500.1	21513.1	13301.0
2017-01-13 11:00:00	YM	Futures	21514.2	21526.1	21496.8	21517.4	9150.0
2017-01-13 12:00:00	YM	Futures	21518.5	21521.8	21463.2	21484.9	10399.0
2017-01-13 13:00:00	YM	Futures	21486.0	21495.7	21472.9	21476.2	5581.0
2017-01-13 14:00:00	YM	Futures	21476.2	21487.0	21448.0	21483.8	9603.0
2017-01-13 15:00:00	YM	Futures	21483.8	21506.6	21469.7	21489.2	9796.0

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

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