PREVIEW / futures_1hour / 2015-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-24.parquet
  size:    30 KB
  rows:    851

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-24 00:00:00	ES	Futures	2205.3	2205.3	2202.88	2203.95	3709.0
2015-12-24 01:00:00	ES	Futures	2204.22	2204.22	2202.88	2203.95	2070.0
2015-12-24 02:00:00	ES	Futures	2203.95	2205.03	2203.15	2203.15	2568.0
2015-12-24 03:00:00	ES	Futures	2203.41	2204.76	2202.88	2203.15	3546.0
2015-12-24 04:00:00	ES	Futures	2203.15	2205.3	2202.34	2204.49	4428.0
2015-12-24 05:00:00	ES	Futures	2204.22	2205.56	2202.88	2204.49	4101.0
2015-12-24 06:00:00	ES	Futures	2204.49	2206.91	2204.22	2206.91	2784.0
2015-12-24 07:00:00	ES	Futures	2206.91	2207.98	2206.37	2206.91	4546.0
2015-12-24 08:00:00	ES	Futures	2206.64	2208.25	2205.83	2206.64	6869.0
2015-12-24 09:00:00	ES	Futures	2206.64	2211.21	2205.83	2205.83	60395.0
2015-12-24 10:00:00	ES	Futures	2205.83	2208.52	2204.22	2207.98	61666.0
2015-12-24 11:00:00	ES	Futures	2207.98	2211.21	2206.64	2211.21	45952.0
2015-12-24 12:00:00	ES	Futures	2210.94	2213.89	2205.03	2205.56	71014.0
2015-12-24 13:00:00	ES	Futures	2205.56	2206.1	2202.88	2204.22	28572.0
2015-12-24 00:00:00	NQ	Futures	5471.85	5471.85	5467.1	5469.77	480.0
2015-12-24 01:00:00	NQ	Futures	5470.07	5470.66	5467.4	5469.18	240.0
2015-12-24 02:00:00	NQ	Futures	5469.77	5474.52	5468.88	5469.18	515.0
2015-12-24 03:00:00	NQ	Futures	5469.18	5471.55	5465.62	5466.51	464.0
2015-12-24 04:00:00	NQ	Futures	5466.21	5470.66	5464.43	5469.77	536.0
2015-12-24 05:00:00	NQ	Futures	5470.37	5471.26	5466.21	5468.88	480.0
2015-12-24 06:00:00	NQ	Futures	5468.88	5474.52	5467.1	5474.52	524.0
2015-12-24 07:00:00	NQ	Futures	5474.52	5480.16	5474.23	5476.9	761.0
2015-12-24 08:00:00	NQ	Futures	5476.9	5482.24	5474.82	5476.9	1168.0
2015-12-24 09:00:00	NQ	Futures	5476.9	5496.5	5475.71	5486.4	19719.0
2015-12-24 10:00:00	NQ	Futures	5486.1	5491.75	5481.35	5489.96	12314.0
2015-12-24 11:00:00	NQ	Futures	5490.56	5498.57	5484.32	5498.28	8567.0
2015-12-24 12:00:00	NQ	Futures	5497.98	5499.17	5481.95	5482.54	10522.0
2015-12-24 13:00:00	NQ	Futures	5482.84	5483.43	5472.44	5476.3	2488.0
2015-12-24 00:00:00	YM	Futures	18591.1	18591.1	18577.3	18585.8	682.0
2015-12-24 01:00:00	YM	Futures	18586.9	18589.0	18577.3	18585.8	409.0
2015-12-24 02:00:00	YM	Futures	18585.8	18598.6	18583.7	18583.7	681.0
2015-12-24 03:00:00	YM	Futures	18584.7	18594.3	18576.2	18578.3	640.0
2015-12-24 04:00:00	YM	Futures	18577.3	18593.2	18570.9	18591.1	1047.0
2015-12-24 05:00:00	YM	Futures	18590.0	18598.6	18579.4	18593.2	566.0
2015-12-24 06:00:00	YM	Futures	18593.2	18611.3	18593.2	18611.3	489.0
2015-12-24 07:00:00	YM	Futures	18612.4	18624.1	18609.2	18614.5	955.0
2015-12-24 08:00:00	YM	Futures	18615.6	18625.2	18603.9	18610.3	952.0
2015-12-24 09:00:00	YM	Futures	18610.3	18638.0	18592.2	18592.2	6755.0
2015-12-24 10:00:00	YM	Futures	18592.2	18611.3	18578.3	18605.0	5504.0
2015-12-24 11:00:00	YM	Futures	18605.0	18625.2	18586.9	18623.0	3022.0
2015-12-24 12:00:00	YM	Futures	18622.0	18644.3	18580.5	18581.5	5462.0
2015-12-24 13:00:00	YM	Futures	18581.5	18582.6	18561.3	18572.0	1706.0
2015-12-24 00:00:00	CL	Futures	49.43	49.53	49.39	49.5	1134.0
2015-12-24 01:00:00	CL	Futures	49.5	49.54	49.43	49.46	836.0
2015-12-24 02:00:00	CL	Futures	49.44	49.62	49.44	49.54	2749.0
2015-12-24 03:00:00	CL	Futures	49.54	49.61	49.44	49.54	4683.0
2015-12-24 04:00:00	CL	Futures	49.54	49.69	49.33	49.41	7213.0
2015-12-24 05:00:00	CL	Futures	49.41	49.46	49.19	49.29	5932.0
2015-12-24 06:00:00	CL	Futures	49.28	49.31	49.02	49.22	7653.0
2015-12-24 07:00:00	CL	Futures	49.2	49.54	49.12	49.35	11515.0

> showing 50 of 851 rows — these rows as CSV

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