PREVIEW / futures_1hour / 2017-01-31

all futures 1-hour files

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

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-31 00:00:00	ES	Futures	2476.47	2477.01	2474.56	2477.01	4811.0
2017-01-31 01:00:00	ES	Futures	2476.74	2477.01	2474.56	2476.74	4296.0
2017-01-31 02:00:00	ES	Futures	2477.01	2478.92	2476.47	2477.29	6848.0
2017-01-31 03:00:00	ES	Futures	2477.29	2481.65	2475.92	2480.83	21580.0
2017-01-31 04:00:00	ES	Futures	2480.83	2482.2	2479.47	2480.83	11717.0
2017-01-31 05:00:00	ES	Futures	2481.11	2481.38	2477.01	2479.2	13538.0
2017-01-31 06:00:00	ES	Futures	2479.2	2481.65	2478.65	2479.74	14613.0
2017-01-31 07:00:00	ES	Futures	2479.74	2481.11	2475.92	2476.47	25145.0
2017-01-31 08:00:00	ES	Futures	2476.47	2479.74	2476.47	2477.56	27256.0
2017-01-31 09:00:00	ES	Futures	2477.56	2479.47	2473.2	2474.83	181177.0
2017-01-31 10:00:00	ES	Futures	2474.56	2476.47	2470.2	2471.83	260265.0
2017-01-31 11:00:00	ES	Futures	2471.83	2474.56	2468.29	2470.2	187763.0
2017-01-31 12:00:00	ES	Futures	2470.2	2475.11	2469.92	2474.01	104225.0
2017-01-31 13:00:00	ES	Futures	2474.01	2474.56	2469.65	2470.74	120317.0
2017-01-31 14:00:00	ES	Futures	2470.74	2477.01	2469.38	2476.47	170440.0
2017-01-31 15:00:00	ES	Futures	2476.47	2482.47	2476.2	2482.2	287155.0
2017-01-31 16:00:00	ES	Futures	2482.2	2485.74	2481.38	2484.65	131639.0
2017-01-31 18:00:00	ES	Futures	2484.38	2485.74	2482.47	2483.56	7415.0
2017-01-31 19:00:00	ES	Futures	2483.29	2484.65	2482.74	2484.65	4210.0
2017-01-31 20:00:00	ES	Futures	2484.38	2485.2	2481.92	2482.74	6705.0
2017-01-31 21:00:00	ES	Futures	2482.74	2483.56	2482.47	2483.02	2290.0
2017-01-31 22:00:00	ES	Futures	2483.02	2483.56	2483.02	2483.56	1832.0
2017-01-31 23:00:00	ES	Futures	2483.29	2484.93	2483.29	2484.65	3664.0
2017-01-31 00:00:00	NQ	Futures	6099.45	6100.64	6093.78	6099.15	1018.0
2017-01-31 01:00:00	NQ	Futures	6098.85	6098.85	6094.38	6097.96	1218.0
2017-01-31 02:00:00	NQ	Futures	6097.96	6103.03	6097.06	6100.34	1394.0
2017-01-31 03:00:00	NQ	Futures	6100.34	6109.29	6096.76	6107.5	3086.0
2017-01-31 04:00:00	NQ	Futures	6107.8	6109.29	6102.73	6105.71	2208.0
2017-01-31 05:00:00	NQ	Futures	6106.31	6107.5	6098.25	6103.03	1786.0
2017-01-31 06:00:00	NQ	Futures	6102.43	6107.5	6101.83	6104.22	2050.0
2017-01-31 07:00:00	NQ	Futures	6104.22	6108.4	6095.87	6097.36	3826.0
2017-01-31 08:00:00	NQ	Futures	6097.36	6106.01	6096.46	6100.04	3874.0
2017-01-31 09:00:00	NQ	Futures	6100.04	6102.13	6080.95	6087.22	38534.0
2017-01-31 10:00:00	NQ	Futures	6087.22	6096.46	6074.39	6077.97	40478.0
2017-01-31 11:00:00	NQ	Futures	6078.27	6083.93	6066.33	6067.83	27085.0
2017-01-31 12:00:00	NQ	Futures	6067.83	6080.06	6065.74	6076.77	13630.0
2017-01-31 13:00:00	NQ	Futures	6076.77	6081.85	6069.62	6071.41	11189.0
2017-01-31 14:00:00	NQ	Futures	6071.11	6089.01	6069.91	6088.11	16464.0
2017-01-31 15:00:00	NQ	Futures	6088.41	6102.13	6088.11	6102.13	25118.0
2017-01-31 16:00:00	NQ	Futures	6102.13	6127.49	6101.24	6123.61	11507.0
2017-01-31 18:00:00	NQ	Futures	6123.91	6126.59	6117.05	6117.94	1617.0
2017-01-31 19:00:00	NQ	Futures	6117.94	6121.52	6117.05	6121.22	1142.0
2017-01-31 20:00:00	NQ	Futures	6120.93	6123.31	6113.17	6115.56	1853.0
2017-01-31 21:00:00	NQ	Futures	6115.56	6117.94	6114.06	6117.64	779.0
2017-01-31 22:00:00	NQ	Futures	6117.64	6119.43	6117.05	6117.64	465.0
2017-01-31 23:00:00	NQ	Futures	6117.64	6122.12	6117.64	6121.82	510.0
2017-01-31 00:00:00	YM	Futures	21525.0	21525.0	21507.7	21521.8	1071.0
2017-01-31 01:00:00	YM	Futures	21520.7	21522.8	21507.7	21520.7	981.0
2017-01-31 02:00:00	YM	Futures	21521.8	21540.2	21520.7	21529.3	1367.0
2017-01-31 03:00:00	YM	Futures	21529.3	21559.7	21519.6	21554.3	3278.0

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

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