PREVIEW / futures_1hour / 2018-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-15.parquet
  size:    40 KB
  rows:    1,234

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
2018-01-15 00:00:00	ES	Futures	3055.81	3056.9	3055.81	3056.08	3545.0
2018-01-15 01:00:00	ES	Futures	3056.35	3056.63	3053.07	3053.35	5005.0
2018-01-15 02:00:00	ES	Futures	3053.35	3054.17	3051.98	3053.62	6986.0
2018-01-15 03:00:00	ES	Futures	3053.62	3054.99	3051.16	3052.8	12501.0
2018-01-15 04:00:00	ES	Futures	3053.07	3055.81	3051.98	3055.53	10409.0
2018-01-15 05:00:00	ES	Futures	3055.81	3056.9	3053.62	3054.17	12288.0
2018-01-15 06:00:00	ES	Futures	3053.89	3054.17	3051.43	3053.07	9889.0
2018-01-15 07:00:00	ES	Futures	3052.8	3054.17	3051.71	3053.62	5400.0
2018-01-15 08:00:00	ES	Futures	3053.89	3054.44	3052.53	3053.62	6591.0
2018-01-15 09:00:00	ES	Futures	3053.62	3054.99	3053.07	3054.99	12185.0
2018-01-15 10:00:00	ES	Futures	3054.99	3056.9	3054.71	3056.9	8705.0
2018-01-15 11:00:00	ES	Futures	3056.9	3056.9	3054.17	3054.71	14323.0
2018-01-15 12:00:00	ES	Futures	3054.71	3055.81	3053.35	3055.26	6536.0
2018-01-15 18:00:00	ES	Futures	3054.99	3056.63	3054.17	3054.44	6197.0
2018-01-15 19:00:00	ES	Futures	3054.44	3054.99	3052.53	3053.89	4865.0
2018-01-15 20:00:00	ES	Futures	3053.62	3055.26	3053.35	3054.99	5322.0
2018-01-15 21:00:00	ES	Futures	3054.99	3056.35	3054.71	3056.35	4096.0
2018-01-15 22:00:00	ES	Futures	3056.08	3056.9	3055.53	3056.63	4040.0
2018-01-15 23:00:00	ES	Futures	3056.35	3057.72	3056.35	3057.45	3232.0
2018-01-15 00:00:00	NQ	Futures	8060.54	8065.58	8060.25	8060.54	976.0
2018-01-15 01:00:00	NQ	Futures	8060.84	8062.91	8049.86	8051.35	1123.0
2018-01-15 02:00:00	NQ	Futures	8051.64	8054.61	8046.01	8049.57	1460.0
2018-01-15 03:00:00	NQ	Futures	8049.86	8053.72	8040.97	8043.04	2788.0
2018-01-15 04:00:00	NQ	Futures	8043.04	8050.46	8042.15	8048.97	1681.0
2018-01-15 05:00:00	NQ	Futures	8049.27	8054.02	8041.26	8042.45	2354.0
2018-01-15 06:00:00	NQ	Futures	8042.45	8044.23	8035.33	8042.75	1700.0
2018-01-15 07:00:00	NQ	Futures	8042.45	8046.01	8035.33	8041.86	1680.0
2018-01-15 08:00:00	NQ	Futures	8041.86	8043.34	8036.81	8040.67	1718.0
2018-01-15 09:00:00	NQ	Futures	8041.26	8044.53	8038.0	8039.78	4011.0
2018-01-15 10:00:00	NQ	Futures	8039.78	8048.38	8039.78	8047.49	3664.0
2018-01-15 11:00:00	NQ	Futures	8047.49	8047.79	8040.67	8042.45	2542.0
2018-01-15 12:00:00	NQ	Futures	8042.45	8046.31	8035.63	8043.93	2304.0
2018-01-15 18:00:00	NQ	Futures	8043.34	8048.97	8038.89	8042.15	1521.0
2018-01-15 19:00:00	NQ	Futures	8042.45	8045.42	8039.48	8043.93	1092.0
2018-01-15 20:00:00	NQ	Futures	8043.64	8048.68	8041.26	8047.79	1700.0
2018-01-15 21:00:00	NQ	Futures	8048.09	8056.09	8047.49	8055.8	1817.0
2018-01-15 22:00:00	NQ	Futures	8055.5	8059.06	8053.13	8056.98	1278.0
2018-01-15 23:00:00	NQ	Futures	8057.28	8061.43	8056.09	8057.87	1059.0
2018-01-15 00:00:00	YM	Futures	28155.6	28166.5	28155.6	28156.7	776.0
2018-01-15 01:00:00	YM	Futures	28157.8	28157.8	28124.1	28135.0	1735.0
2018-01-15 02:00:00	YM	Futures	28135.0	28144.8	28115.4	28137.2	2311.0
2018-01-15 03:00:00	YM	Futures	28136.1	28157.8	28118.7	28133.9	2034.0
2018-01-15 04:00:00	YM	Futures	28132.8	28182.8	28129.5	28178.5	3076.0
2018-01-15 05:00:00	YM	Futures	28178.5	28201.3	28169.8	28183.9	3537.0
2018-01-15 06:00:00	YM	Futures	28183.9	28190.4	28153.5	28169.8	1834.0
2018-01-15 07:00:00	YM	Futures	28169.8	28192.6	28163.2	28182.8	1547.0
2018-01-15 08:00:00	YM	Futures	28183.9	28204.5	28182.8	28200.2	2744.0
2018-01-15 09:00:00	YM	Futures	28200.2	28232.8	28198.0	28227.4	5150.0
2018-01-15 10:00:00	YM	Futures	28227.4	28230.6	28216.5	28225.2	3121.0
2018-01-15 11:00:00	YM	Futures	28225.2	28230.6	28171.9	28194.8	3893.0

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

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