PREVIEW / futures_1hour / 2014-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-22.parquet
  size:    48 KB
  rows:    1,498

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-22 00:00:00	ES	Futures	2176.79	2179.42	2176.53	2177.06	3373.0
2014-12-22 01:00:00	ES	Futures	2177.06	2177.32	2176.53	2177.32	1069.0
2014-12-22 02:00:00	ES	Futures	2177.06	2178.63	2176.0	2176.79	5006.0
2014-12-22 03:00:00	ES	Futures	2176.53	2184.16	2176.0	2182.84	21297.0
2014-12-22 04:00:00	ES	Futures	2182.58	2183.37	2181.0	2182.58	7932.0
2014-12-22 05:00:00	ES	Futures	2182.32	2182.32	2178.9	2181.27	11515.0
2014-12-22 06:00:00	ES	Futures	2181.27	2182.84	2180.48	2181.27	6236.0
2014-12-22 07:00:00	ES	Futures	2181.0	2181.27	2178.11	2179.95	13178.0
2014-12-22 08:00:00	ES	Futures	2179.95	2181.79	2179.16	2181.0	16283.0
2014-12-22 09:00:00	ES	Futures	2181.0	2182.58	2177.32	2179.42	118551.0
2014-12-22 10:00:00	ES	Futures	2179.69	2182.84	2177.06	2180.21	151980.0
2014-12-22 11:00:00	ES	Futures	2180.21	2181.27	2176.79	2178.9	111723.0
2014-12-22 12:00:00	ES	Futures	2178.63	2181.27	2177.58	2180.21	53598.0
2014-12-22 13:00:00	ES	Futures	2180.48	2182.06	2179.95	2181.79	56610.0
2014-12-22 14:00:00	ES	Futures	2182.06	2183.37	2179.69	2180.48	65809.0
2014-12-22 15:00:00	ES	Futures	2180.48	2184.16	2180.48	2183.9	135763.0
2014-12-22 16:00:00	ES	Futures	2183.9	2185.21	2181.0	2181.27	55855.0
2014-12-22 17:00:00	ES	Futures	2181.27	2182.06	2181.0	2181.53	995.0
2014-12-22 18:00:00	ES	Futures	2182.06	2183.11	2180.48	2182.06	3591.0
2014-12-22 19:00:00	ES	Futures	2182.32	2182.32	2181.53	2182.32	792.0
2014-12-22 20:00:00	ES	Futures	2182.32	2182.58	2181.79	2182.32	1173.0
2014-12-22 21:00:00	ES	Futures	2182.32	2182.58	2181.79	2182.32	1494.0
2014-12-22 22:00:00	ES	Futures	2182.58	2183.37	2182.06	2182.32	2102.0
2014-12-22 23:00:00	ES	Futures	2182.58	2183.37	2182.32	2183.37	619.0
2014-12-22 00:00:00	NQ	Futures	5035.58	5038.81	5033.23	5033.23	964.0
2014-12-22 01:00:00	NQ	Futures	5034.41	5035.29	5031.76	5031.76	295.0
2014-12-22 02:00:00	NQ	Futures	5032.35	5038.22	5032.35	5034.99	818.0
2014-12-22 03:00:00	NQ	Futures	5034.99	5050.85	5034.11	5047.62	3797.0
2014-12-22 04:00:00	NQ	Futures	5047.33	5049.09	5044.98	5047.62	1287.0
2014-12-22 05:00:00	NQ	Futures	5047.62	5047.92	5040.87	5046.15	1664.0
2014-12-22 06:00:00	NQ	Futures	5046.15	5048.5	5044.39	5044.69	1586.0
2014-12-22 07:00:00	NQ	Futures	5044.39	5044.39	5032.35	5035.58	3278.0
2014-12-22 08:00:00	NQ	Futures	5035.58	5037.64	5029.41	5033.53	2924.0
2014-12-22 09:00:00	NQ	Futures	5033.23	5049.09	5023.25	5042.04	29272.0
2014-12-22 10:00:00	NQ	Futures	5042.34	5051.44	5038.22	5042.92	28900.0
2014-12-22 11:00:00	NQ	Futures	5042.63	5047.33	5033.53	5039.11	19094.0
2014-12-22 12:00:00	NQ	Futures	5038.52	5050.27	5036.46	5049.68	12308.0
2014-12-22 13:00:00	NQ	Futures	5049.68	5052.91	5043.22	5050.56	11026.0
2014-12-22 14:00:00	NQ	Futures	5050.56	5050.56	5038.52	5038.81	12276.0
2014-12-22 15:00:00	NQ	Futures	5038.81	5049.09	5038.81	5046.74	23315.0
2014-12-22 16:00:00	NQ	Futures	5047.04	5048.8	5042.04	5042.63	5957.0
2014-12-22 17:00:00	NQ	Futures	5042.63	5044.69	5042.63	5044.69	42.0
2014-12-22 18:00:00	NQ	Futures	5042.92	5044.1	5041.16	5043.22	276.0
2014-12-22 19:00:00	NQ	Futures	5043.8	5044.69	5042.63	5044.39	154.0
2014-12-22 20:00:00	NQ	Futures	5044.98	5047.04	5044.1	5046.15	262.0
2014-12-22 21:00:00	NQ	Futures	5046.15	5047.62	5045.27	5047.04	153.0
2014-12-22 22:00:00	NQ	Futures	5047.04	5049.97	5046.74	5047.33	260.0
2014-12-22 23:00:00	NQ	Futures	5047.33	5048.21	5046.45	5047.92	121.0
2014-12-22 00:00:00	YM	Futures	18550.7	18577.9	18549.7	18556.0	740.0
2014-12-22 01:00:00	YM	Futures	18556.0	18560.1	18552.8	18554.9	144.0

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

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