PREVIEW / futures_1hour / 2014-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-15.parquet
  size:    48 KB
  rows:    1,495

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-09-15 00:00:00	ES	Futures	2063.78	2064.3	2062.99	2064.04	2987.0
2014-09-15 01:00:00	ES	Futures	2064.3	2064.56	2063.78	2064.04	3414.0
2014-09-15 02:00:00	ES	Futures	2064.3	2065.35	2064.04	2065.09	4594.0
2014-09-15 03:00:00	ES	Futures	2065.09	2066.14	2064.3	2065.61	19076.0
2014-09-15 04:00:00	ES	Futures	2065.35	2068.49	2065.09	2067.71	15778.0
2014-09-15 05:00:00	ES	Futures	2067.45	2067.97	2065.61	2066.92	7885.0
2014-09-15 06:00:00	ES	Futures	2066.92	2068.49	2066.66	2067.97	8270.0
2014-09-15 07:00:00	ES	Futures	2068.23	2071.38	2067.71	2069.28	17027.0
2014-09-15 08:00:00	ES	Futures	2069.28	2071.64	2068.76	2071.11	26720.0
2014-09-15 09:00:00	ES	Futures	2070.85	2072.69	2064.56	2066.4	203450.0
2014-09-15 10:00:00	ES	Futures	2066.4	2071.38	2063.78	2069.54	210202.0
2014-09-15 11:00:00	ES	Futures	2069.28	2070.07	2065.35	2065.87	131944.0
2014-09-15 12:00:00	ES	Futures	2065.87	2069.8	2064.83	2069.8	93641.0
2014-09-15 13:00:00	ES	Futures	2069.54	2070.85	2066.14	2066.66	92465.0
2014-09-15 14:00:00	ES	Futures	2066.4	2073.73	2066.14	2070.59	132731.0
2014-09-15 15:00:00	ES	Futures	2070.85	2072.16	2069.54	2070.33	115241.0
2014-09-15 16:00:00	ES	Futures	2070.07	2071.38	2070.07	2071.11	50539.0
2014-09-15 17:00:00	ES	Futures	2071.38	2071.64	2071.11	2071.64	2066.0
2014-09-15 18:00:00	ES	Futures	2071.38	2071.64	2070.85	2070.85	2792.0
2014-09-15 19:00:00	ES	Futures	2070.85	2071.38	2070.85	2071.11	977.0
2014-09-15 20:00:00	ES	Futures	2071.38	2071.38	2070.85	2071.11	1716.0
2014-09-15 21:00:00	ES	Futures	2071.11	2071.38	2070.85	2071.11	2751.0
2014-09-15 22:00:00	ES	Futures	2071.11	2071.38	2070.33	2070.85	2388.0
2014-09-15 23:00:00	ES	Futures	2070.59	2070.85	2070.07	2070.33	2584.0
2014-09-15 00:00:00	NQ	Futures	4742.3	4743.76	4741.42	4743.76	306.0
2014-09-15 01:00:00	NQ	Futures	4743.47	4744.35	4742.88	4743.76	315.0
2014-09-15 02:00:00	NQ	Futures	4743.76	4747.28	4743.76	4746.11	884.0
2014-09-15 03:00:00	NQ	Futures	4746.4	4749.33	4744.93	4748.16	3162.0
2014-09-15 04:00:00	NQ	Futures	4748.16	4755.78	4747.57	4753.14	2646.0
2014-09-15 05:00:00	NQ	Futures	4753.43	4754.02	4749.33	4752.55	1368.0
2014-09-15 06:00:00	NQ	Futures	4752.26	4756.65	4751.97	4755.78	1970.0
2014-09-15 07:00:00	NQ	Futures	4756.07	4762.81	4755.48	4757.83	4296.0
2014-09-15 08:00:00	NQ	Futures	4758.12	4765.15	4757.24	4763.39	5092.0
2014-09-15 09:00:00	NQ	Futures	4763.1	4768.38	4719.15	4724.72	59899.0
2014-09-15 10:00:00	NQ	Futures	4724.72	4730.58	4713.88	4719.74	51492.0
2014-09-15 11:00:00	NQ	Futures	4719.74	4721.49	4708.31	4710.36	36713.0
2014-09-15 12:00:00	NQ	Futures	4710.65	4720.32	4708.31	4719.74	21650.0
2014-09-15 13:00:00	NQ	Futures	4719.44	4721.49	4701.57	4702.45	27576.0
2014-09-15 14:00:00	NQ	Futures	4702.45	4722.96	4700.4	4715.34	30359.0
2014-09-15 15:00:00	NQ	Futures	4715.63	4720.32	4710.07	4714.46	27286.0
2014-09-15 16:00:00	NQ	Futures	4714.17	4718.86	4713.88	4718.56	6368.0
2014-09-15 17:00:00	NQ	Futures	4718.86	4720.03	4718.56	4720.03	220.0
2014-09-15 18:00:00	NQ	Futures	4719.15	4721.2	4718.56	4719.15	586.0
2014-09-15 19:00:00	NQ	Futures	4719.15	4720.62	4718.86	4720.32	329.0
2014-09-15 20:00:00	NQ	Futures	4720.62	4720.62	4719.15	4719.74	302.0
2014-09-15 21:00:00	NQ	Futures	4720.03	4720.32	4718.56	4719.15	462.0
2014-09-15 22:00:00	NQ	Futures	4719.44	4719.44	4717.98	4718.27	486.0
2014-09-15 23:00:00	NQ	Futures	4718.56	4718.56	4716.51	4717.1	491.0
2014-09-15 00:00:00	YM	Futures	17520.0	17522.1	17514.8	17521.0	608.0
2014-09-15 01:00:00	YM	Futures	17522.1	17526.2	17521.0	17523.1	697.0

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

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