PREVIEW / futures_1hour / 2017-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-23.parquet
  size:    37 KB
  rows:    1,143

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-11-23 00:00:00	ES	Futures	2839.26	2839.54	2838.99	2839.26	943.0
2017-11-23 01:00:00	ES	Futures	2839.26	2839.26	2837.35	2837.62	1286.0
2017-11-23 02:00:00	ES	Futures	2837.62	2838.72	2833.52	2834.34	15890.0
2017-11-23 03:00:00	ES	Futures	2834.61	2838.72	2833.52	2837.9	24614.0
2017-11-23 04:00:00	ES	Futures	2837.9	2840.09	2837.08	2840.09	11235.0
2017-11-23 05:00:00	ES	Futures	2839.81	2842.82	2839.26	2842.55	10385.0
2017-11-23 06:00:00	ES	Futures	2842.55	2842.82	2840.63	2841.73	10121.0
2017-11-23 07:00:00	ES	Futures	2841.73	2842.55	2841.18	2841.18	6338.0
2017-11-23 08:00:00	ES	Futures	2841.18	2842.27	2840.09	2842.0	8379.0
2017-11-23 09:00:00	ES	Futures	2842.0	2842.27	2840.63	2841.45	9217.0
2017-11-23 10:00:00	ES	Futures	2841.45	2842.0	2840.36	2841.45	4024.0
2017-11-23 11:00:00	ES	Futures	2841.45	2841.73	2840.36	2840.91	5101.0
2017-11-23 12:00:00	ES	Futures	2840.91	2841.73	2840.09	2841.73	4108.0
2017-11-23 18:00:00	ES	Futures	2840.63	2840.91	2838.72	2839.81	2546.0
2017-11-23 19:00:00	ES	Futures	2839.81	2841.18	2839.54	2840.36	3453.0
2017-11-23 20:00:00	ES	Futures	2840.36	2840.91	2839.54	2840.63	3303.0
2017-11-23 21:00:00	ES	Futures	2840.63	2840.91	2839.81	2840.91	1973.0
2017-11-23 22:00:00	ES	Futures	2840.63	2843.37	2840.63	2842.55	4711.0
2017-11-23 23:00:00	ES	Futures	2842.27	2842.82	2841.73	2842.82	2347.0
2017-11-23 00:00:00	NQ	Futures	7604.34	7604.64	7601.96	7603.15	290.0
2017-11-23 01:00:00	NQ	Futures	7603.15	7603.15	7597.5	7597.8	615.0
2017-11-23 02:00:00	NQ	Futures	7597.8	7600.18	7585.01	7590.07	3626.0
2017-11-23 03:00:00	NQ	Futures	7589.77	7599.29	7587.09	7596.91	2614.0
2017-11-23 04:00:00	NQ	Futures	7596.61	7604.34	7595.42	7603.45	1956.0
2017-11-23 05:00:00	NQ	Futures	7603.15	7611.48	7601.96	7610.89	1873.0
2017-11-23 06:00:00	NQ	Futures	7610.59	7611.18	7604.05	7606.72	1297.0
2017-11-23 07:00:00	NQ	Futures	7606.72	7608.51	7604.05	7605.24	1137.0
2017-11-23 08:00:00	NQ	Futures	7604.94	7606.72	7601.07	7605.83	1752.0
2017-11-23 09:00:00	NQ	Futures	7605.53	7605.53	7598.99	7600.48	3213.0
2017-11-23 10:00:00	NQ	Futures	7600.77	7600.77	7596.31	7597.5	2187.0
2017-11-23 11:00:00	NQ	Futures	7597.5	7597.8	7592.15	7593.93	2531.0
2017-11-23 12:00:00	NQ	Futures	7593.64	7596.31	7590.37	7596.31	2090.0
2017-11-23 18:00:00	NQ	Futures	7596.31	7597.21	7589.77	7593.34	877.0
2017-11-23 19:00:00	NQ	Futures	7593.04	7596.31	7592.15	7594.53	1048.0
2017-11-23 20:00:00	NQ	Futures	7594.83	7598.99	7593.64	7597.8	1487.0
2017-11-23 21:00:00	NQ	Futures	7597.8	7598.1	7593.93	7597.8	602.0
2017-11-23 22:00:00	NQ	Futures	7597.8	7607.32	7597.5	7604.94	1403.0
2017-11-23 23:00:00	NQ	Futures	7604.64	7606.13	7603.75	7605.24	649.0
2017-11-23 00:00:00	YM	Futures	25559.5	25563.8	25556.2	25562.8	344.0
2017-11-23 01:00:00	YM	Futures	25562.8	25562.8	25543.2	25544.3	455.0
2017-11-23 02:00:00	YM	Futures	25545.4	25550.8	25491.0	25500.8	3642.0
2017-11-23 03:00:00	YM	Futures	25499.7	25530.1	25486.6	25526.9	4095.0
2017-11-23 04:00:00	YM	Futures	25526.9	25544.3	25518.2	25544.3	1795.0
2017-11-23 05:00:00	YM	Futures	25543.2	25568.2	25537.7	25567.1	1506.0
2017-11-23 06:00:00	YM	Futures	25566.0	25569.3	25546.4	25558.4	1249.0
2017-11-23 07:00:00	YM	Futures	25558.4	25564.9	25550.8	25550.8	762.0
2017-11-23 08:00:00	YM	Futures	25550.8	25560.6	25534.5	25556.2	2070.0
2017-11-23 09:00:00	YM	Futures	25556.2	25569.3	25548.6	25561.7	2042.0
2017-11-23 10:00:00	YM	Futures	25562.8	25562.8	25550.8	25559.5	894.0
2017-11-23 11:00:00	YM	Futures	25559.5	25560.6	25529.0	25544.3	2041.0

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

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