PREVIEW / futures_1hour / 2015-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-31.parquet
  size:    36 KB
  rows:    1,015

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
2015-12-31 00:00:00	ES	Futures	2208.79	2210.67	2208.52	2209.59	1509.0
2015-12-31 01:00:00	ES	Futures	2209.59	2211.48	2209.59	2210.94	660.0
2015-12-31 02:00:00	ES	Futures	2210.94	2211.21	2208.79	2208.79	1109.0
2015-12-31 03:00:00	ES	Futures	2208.79	2210.67	2208.52	2210.13	2493.0
2015-12-31 04:00:00	ES	Futures	2209.86	2210.67	2208.79	2209.06	2745.0
2015-12-31 05:00:00	ES	Futures	2209.33	2210.67	2208.79	2209.59	2298.0
2015-12-31 06:00:00	ES	Futures	2209.86	2210.4	2208.52	2208.79	2331.0
2015-12-31 07:00:00	ES	Futures	2209.06	2209.33	2203.68	2204.49	10134.0
2015-12-31 08:00:00	ES	Futures	2204.49	2204.76	2198.58	2201.53	22268.0
2015-12-31 09:00:00	ES	Futures	2201.53	2202.88	2194.55	2198.04	109968.0
2015-12-31 10:00:00	ES	Futures	2197.77	2198.85	2189.44	2193.47	137290.0
2015-12-31 11:00:00	ES	Futures	2193.47	2202.88	2192.93	2202.61	112959.0
2015-12-31 12:00:00	ES	Futures	2202.34	2208.52	2201.26	2203.95	89940.0
2015-12-31 13:00:00	ES	Futures	2203.68	2204.76	2198.85	2203.95	61372.0
2015-12-31 14:00:00	ES	Futures	2203.68	2204.49	2192.93	2195.62	79271.0
2015-12-31 15:00:00	ES	Futures	2195.62	2197.77	2185.95	2186.75	243799.0
2015-12-31 16:00:00	ES	Futures	2186.75	2189.44	2182.19	2188.1	134548.0
2015-12-31 00:00:00	NQ	Futures	5520.25	5527.08	5519.66	5522.33	676.0
2015-12-31 01:00:00	NQ	Futures	5522.63	5527.08	5522.63	5525.3	189.0
2015-12-31 02:00:00	NQ	Futures	5525.89	5528.27	5518.77	5519.06	385.0
2015-12-31 03:00:00	NQ	Futures	5518.77	5525.6	5517.28	5522.63	706.0
2015-12-31 04:00:00	NQ	Futures	5522.03	5525.0	5519.95	5521.74	555.0
2015-12-31 05:00:00	NQ	Futures	5521.74	5525.6	5521.44	5522.92	596.0
2015-12-31 06:00:00	NQ	Futures	5523.52	5526.19	5519.06	5519.66	582.0
2015-12-31 07:00:00	NQ	Futures	5519.95	5521.44	5506.59	5509.86	2314.0
2015-12-31 08:00:00	NQ	Futures	5509.86	5510.45	5493.82	5499.47	3895.0
2015-12-31 09:00:00	NQ	Futures	5499.47	5503.03	5476.6	5484.62	21331.0
2015-12-31 10:00:00	NQ	Futures	5484.32	5489.07	5462.35	5474.82	24510.0
2015-12-31 11:00:00	NQ	Futures	5474.23	5493.53	5473.04	5492.34	18978.0
2015-12-31 12:00:00	NQ	Futures	5492.34	5506.59	5489.67	5493.82	15483.0
2015-12-31 13:00:00	NQ	Futures	5494.12	5496.79	5477.49	5488.18	11597.0
2015-12-31 14:00:00	NQ	Futures	5488.48	5490.26	5460.86	5468.88	13198.0
2015-12-31 15:00:00	NQ	Futures	5468.88	5468.88	5445.13	5446.61	28671.0
2015-12-31 16:00:00	NQ	Futures	5446.61	5455.22	5439.19	5454.63	14072.0
2015-12-31 00:00:00	YM	Futures	18644.3	18658.2	18643.3	18649.7	365.0
2015-12-31 01:00:00	YM	Futures	18650.7	18666.7	18650.7	18660.3	386.0
2015-12-31 02:00:00	YM	Futures	18662.4	18665.6	18644.3	18644.3	389.0
2015-12-31 03:00:00	YM	Futures	18644.3	18659.2	18642.2	18653.9	511.0
2015-12-31 04:00:00	YM	Futures	18652.9	18659.2	18646.5	18649.7	437.0
2015-12-31 05:00:00	YM	Futures	18650.7	18658.2	18646.5	18648.6	340.0
2015-12-31 06:00:00	YM	Futures	18649.7	18653.9	18638.0	18642.2	397.0
2015-12-31 07:00:00	YM	Futures	18640.1	18644.3	18602.8	18610.3	2160.0
2015-12-31 08:00:00	YM	Futures	18610.3	18611.3	18551.7	18574.1	3190.0
2015-12-31 09:00:00	YM	Futures	18575.1	18590.0	18512.3	18544.3	10652.0
2015-12-31 10:00:00	YM	Futures	18545.3	18552.8	18474.0	18497.4	10692.0
2015-12-31 11:00:00	YM	Futures	18496.4	18575.1	18490.0	18573.0	10133.0
2015-12-31 12:00:00	YM	Futures	18574.1	18626.2	18569.8	18587.9	9315.0
2015-12-31 13:00:00	YM	Futures	18587.9	18594.3	18545.3	18586.9	5539.0
2015-12-31 14:00:00	YM	Futures	18586.9	18590.0	18495.3	18516.6	5792.0
2015-12-31 15:00:00	YM	Futures	18514.5	18525.1	18447.4	18449.5	13114.0

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

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