PREVIEW / futures_1hour / 2014-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-26.parquet
  size:    29 KB
  rows:    831

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
2014-12-26 00:00:00	ES	Futures	2191.27	2191.27	2190.74	2190.74	506.0
2014-12-26 01:00:00	ES	Futures	2191.0	2191.27	2190.74	2191.27	313.0
2014-12-26 02:00:00	ES	Futures	2191.27	2191.53	2190.74	2191.27	355.0
2014-12-26 03:00:00	ES	Futures	2191.27	2191.53	2191.0	2191.53	307.0
2014-12-26 04:00:00	ES	Futures	2191.53	2192.32	2191.27	2192.05	380.0
2014-12-26 05:00:00	ES	Futures	2192.05	2192.05	2191.0	2191.0	483.0
2014-12-26 06:00:00	ES	Futures	2191.27	2191.27	2191.0	2191.27	317.0
2014-12-26 07:00:00	ES	Futures	2191.27	2191.79	2191.0	2191.79	1063.0
2014-12-26 08:00:00	ES	Futures	2191.53	2192.58	2191.27	2192.32	2764.0
2014-12-26 09:00:00	ES	Futures	2192.05	2197.32	2191.79	2196.79	41393.0
2014-12-26 10:00:00	ES	Futures	2196.53	2197.58	2194.42	2196.0	47026.0
2014-12-26 11:00:00	ES	Futures	2196.27	2196.79	2195.21	2196.0	22968.0
2014-12-26 12:00:00	ES	Futures	2196.0	2196.27	2193.9	2196.0	24391.0
2014-12-26 13:00:00	ES	Futures	2195.74	2197.58	2195.74	2197.05	21126.0
2014-12-26 14:00:00	ES	Futures	2197.05	2198.63	2196.79	2197.84	31189.0
2014-12-26 15:00:00	ES	Futures	2198.11	2198.37	2192.84	2193.11	63464.0
2014-12-26 16:00:00	ES	Futures	2193.11	2195.74	2192.58	2194.95	41638.0
2014-12-26 17:00:00	ES	Futures	2194.69	2195.48	2194.69	2195.21	608.0
2014-12-26 00:00:00	NQ	Futures	5043.51	5043.8	5041.46	5041.46	156.0
2014-12-26 01:00:00	NQ	Futures	5042.04	5042.63	5040.87	5042.63	100.0
2014-12-26 02:00:00	NQ	Futures	5042.63	5042.63	5041.16	5042.04	90.0
2014-12-26 03:00:00	NQ	Futures	5042.34	5043.8	5041.46	5043.8	153.0
2014-12-26 04:00:00	NQ	Futures	5044.1	5046.45	5043.8	5045.27	121.0
2014-12-26 05:00:00	NQ	Futures	5044.69	5045.86	5044.39	5045.57	258.0
2014-12-26 06:00:00	NQ	Futures	5045.57	5045.86	5044.98	5045.57	173.0
2014-12-26 07:00:00	NQ	Futures	5045.27	5045.57	5043.51	5044.1	264.0
2014-12-26 08:00:00	NQ	Futures	5043.8	5046.15	5042.92	5045.86	631.0
2014-12-26 09:00:00	NQ	Futures	5045.86	5056.14	5042.92	5052.03	10368.0
2014-12-26 10:00:00	NQ	Futures	5052.03	5057.61	5051.44	5056.73	8699.0
2014-12-26 11:00:00	NQ	Futures	5057.02	5060.84	5054.96	5058.2	4017.0
2014-12-26 12:00:00	NQ	Futures	5058.49	5064.36	5054.38	5064.36	3810.0
2014-12-26 13:00:00	NQ	Futures	5064.07	5074.35	5064.07	5072.0	6812.0
2014-12-26 14:00:00	NQ	Futures	5072.0	5076.7	5071.7	5075.23	4560.0
2014-12-26 15:00:00	NQ	Futures	5074.94	5077.29	5063.19	5064.66	13790.0
2014-12-26 16:00:00	NQ	Futures	5064.07	5069.65	5062.89	5066.12	6058.0
2014-12-26 17:00:00	NQ	Futures	5066.12	5067.3	5065.83	5066.12	52.0
2014-12-26 00:00:00	YM	Futures	18809.6	18811.7	18807.5	18808.6	69.0
2014-12-26 01:00:00	YM	Futures	18809.6	18811.7	18808.6	18808.6	96.0
2014-12-26 02:00:00	YM	Futures	18810.7	18812.8	18807.5	18808.6	137.0
2014-12-26 03:00:00	YM	Futures	18810.7	18813.8	18808.6	18812.8	63.0
2014-12-26 04:00:00	YM	Futures	18813.8	18818.0	18812.8	18816.9	87.0
2014-12-26 05:00:00	YM	Futures	18814.8	18814.8	18804.4	18804.4	148.0
2014-12-26 06:00:00	YM	Futures	18805.4	18807.5	18804.4	18807.5	49.0
2014-12-26 07:00:00	YM	Futures	18806.5	18810.7	18803.4	18807.5	206.0
2014-12-26 08:00:00	YM	Futures	18808.6	18818.0	18806.5	18814.8	480.0
2014-12-26 09:00:00	YM	Futures	18814.8	18839.9	18802.3	18830.5	4361.0
2014-12-26 10:00:00	YM	Futures	18832.6	18843.0	18814.8	18828.4	3038.0
2014-12-26 11:00:00	YM	Futures	18827.4	18829.5	18803.4	18812.8	2030.0
2014-12-26 12:00:00	YM	Futures	18811.7	18819.0	18807.5	18818.0	1116.0
2014-12-26 13:00:00	YM	Futures	18818.0	18829.5	18814.8	18824.2	1826.0

> showing 50 of 831 rows — these rows as CSV

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