PREVIEW / futures_1hour / 2015-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-23.parquet
  size:    49 KB
  rows:    1,549

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-23 00:00:00	ES	Futures	2185.41	2185.95	2184.6	2185.14	1361.0
2015-12-23 01:00:00	ES	Futures	2184.87	2186.22	2184.87	2185.14	2040.0
2015-12-23 02:00:00	ES	Futures	2185.14	2187.02	2184.87	2186.49	4443.0
2015-12-23 03:00:00	ES	Futures	2186.49	2192.13	2186.22	2189.44	17244.0
2015-12-23 04:00:00	ES	Futures	2189.44	2192.67	2188.9	2192.4	10206.0
2015-12-23 05:00:00	ES	Futures	2192.13	2192.67	2190.52	2191.59	7542.0
2015-12-23 06:00:00	ES	Futures	2191.59	2194.82	2189.44	2194.28	14703.0
2015-12-23 07:00:00	ES	Futures	2194.55	2198.58	2194.01	2195.89	18585.0
2015-12-23 08:00:00	ES	Futures	2195.89	2196.7	2194.28	2194.82	17842.0
2015-12-23 09:00:00	ES	Futures	2194.82	2199.11	2194.55	2197.5	134581.0
2015-12-23 10:00:00	ES	Futures	2197.23	2203.41	2195.35	2202.88	155388.0
2015-12-23 11:00:00	ES	Futures	2203.15	2203.68	2200.19	2202.61	109536.0
2015-12-23 12:00:00	ES	Futures	2202.88	2207.18	2202.61	2204.76	91011.0
2015-12-23 13:00:00	ES	Futures	2204.76	2205.83	2201.0	2205.3	78974.0
2015-12-23 14:00:00	ES	Futures	2205.3	2211.74	2204.22	2210.4	113176.0
2015-12-23 15:00:00	ES	Futures	2210.4	2211.48	2205.83	2210.94	153042.0
2015-12-23 16:00:00	ES	Futures	2210.94	2211.48	2205.03	2206.64	56930.0
2015-12-23 18:00:00	ES	Futures	2206.37	2207.98	2205.3	2206.91	2954.0
2015-12-23 19:00:00	ES	Futures	2206.91	2210.4	2206.1	2209.06	6026.0
2015-12-23 20:00:00	ES	Futures	2209.33	2209.86	2206.64	2207.44	3984.0
2015-12-23 21:00:00	ES	Futures	2207.44	2207.44	2204.76	2205.3	3172.0
2015-12-23 22:00:00	ES	Futures	2205.3	2206.1	2204.49	2205.56	3049.0
2015-12-23 23:00:00	ES	Futures	2205.56	2205.56	2205.03	2205.3	1586.0
2015-12-23 00:00:00	NQ	Futures	5447.21	5448.1	5444.83	5446.31	285.0
2015-12-23 01:00:00	NQ	Futures	5446.61	5448.1	5445.13	5446.31	281.0
2015-12-23 02:00:00	NQ	Futures	5445.72	5451.07	5445.42	5450.77	517.0
2015-12-23 03:00:00	NQ	Futures	5450.47	5464.43	5449.28	5458.19	3176.0
2015-12-23 04:00:00	NQ	Futures	5458.49	5467.4	5457.0	5466.8	1494.0
2015-12-23 05:00:00	NQ	Futures	5466.21	5468.58	5462.35	5466.21	1262.0
2015-12-23 06:00:00	NQ	Futures	5466.21	5473.34	5460.86	5471.85	2187.0
2015-12-23 07:00:00	NQ	Futures	5472.15	5478.98	5469.77	5473.04	2558.0
2015-12-23 08:00:00	NQ	Futures	5473.04	5474.23	5469.48	5470.37	2784.0
2015-12-23 09:00:00	NQ	Futures	5470.37	5478.68	5463.83	5475.71	25954.0
2015-12-23 10:00:00	NQ	Futures	5476.01	5482.24	5462.35	5473.63	26540.0
2015-12-23 11:00:00	NQ	Futures	5473.93	5474.82	5462.05	5472.15	14738.0
2015-12-23 12:00:00	NQ	Futures	5472.15	5477.49	5465.02	5467.69	12447.0
2015-12-23 13:00:00	NQ	Futures	5467.99	5473.93	5461.46	5472.44	9705.0
2015-12-23 14:00:00	NQ	Futures	5472.44	5487.59	5470.37	5483.43	13260.0
2015-12-23 15:00:00	NQ	Futures	5483.73	5486.99	5473.04	5484.62	18431.0
2015-12-23 16:00:00	NQ	Futures	5484.32	5485.51	5470.37	5471.55	4904.0
2015-12-23 18:00:00	NQ	Futures	5472.74	5477.49	5471.26	5476.6	329.0
2015-12-23 19:00:00	NQ	Futures	5476.01	5482.24	5474.82	5478.98	849.0
2015-12-23 20:00:00	NQ	Futures	5479.27	5481.35	5475.71	5476.6	604.0
2015-12-23 21:00:00	NQ	Futures	5476.9	5476.9	5472.44	5473.93	443.0
2015-12-23 22:00:00	NQ	Futures	5474.23	5476.01	5472.74	5474.82	358.0
2015-12-23 23:00:00	NQ	Futures	5474.52	5475.12	5471.85	5472.15	193.0
2015-12-23 00:00:00	YM	Futures	18467.6	18471.9	18461.2	18467.6	363.0
2015-12-23 01:00:00	YM	Futures	18467.6	18475.1	18463.4	18468.7	324.0
2015-12-23 02:00:00	YM	Futures	18467.6	18485.7	18465.5	18484.7	1112.0
2015-12-23 03:00:00	YM	Futures	18482.5	18535.8	18481.5	18508.1	3875.0

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

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