PREVIEW / futures_1hour / 2016-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-12.parquet
  size:    46 KB
  rows:    1,319

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
2016-02-12 00:00:00	ES	Futures	1970.44	1972.06	1962.92	1964.53	15383.0
2016-02-12 01:00:00	ES	Futures	1964.53	1965.88	1962.11	1962.92	10384.0
2016-02-12 02:00:00	ES	Futures	1962.92	1970.98	1958.89	1969.37	24705.0
2016-02-12 03:00:00	ES	Futures	1969.64	1979.04	1969.64	1976.09	67357.0
2016-02-12 04:00:00	ES	Futures	1976.35	1980.39	1972.32	1977.16	34619.0
2016-02-12 05:00:00	ES	Futures	1977.16	1980.65	1974.47	1975.28	25987.0
2016-02-12 06:00:00	ES	Futures	1975.01	1985.76	1974.47	1983.61	33303.0
2016-02-12 07:00:00	ES	Futures	1983.88	1984.15	1977.97	1979.04	28795.0
2016-02-12 08:00:00	ES	Futures	1979.04	1986.83	1974.74	1982.27	82841.0
2016-02-12 09:00:00	ES	Futures	1982.0	1983.88	1972.59	1974.47	246807.0
2016-02-12 10:00:00	ES	Futures	1974.47	1983.34	1970.71	1979.31	276073.0
2016-02-12 11:00:00	ES	Futures	1979.31	1994.09	1979.04	1988.72	279721.0
2016-02-12 12:00:00	ES	Futures	1988.45	1992.75	1987.64	1989.25	129503.0
2016-02-12 13:00:00	ES	Futures	1989.25	1991.4	1983.61	1987.1	136565.0
2016-02-12 14:00:00	ES	Futures	1987.1	1996.78	1986.3	1994.9	153826.0
2016-02-12 15:00:00	ES	Futures	1994.9	2000.0	1993.28	2000.0	263303.0
2016-02-12 16:00:00	ES	Futures	1999.73	2000.0	1994.9	1999.2	87975.0
2016-02-12 00:00:00	NQ	Futures	4722.1	4728.04	4706.06	4709.33	2330.0
2016-02-12 01:00:00	NQ	Futures	4711.11	4713.19	4700.72	4701.61	945.0
2016-02-12 02:00:00	NQ	Futures	4701.31	4724.47	4695.08	4721.21	2540.0
2016-02-12 03:00:00	NQ	Futures	4720.91	4745.85	4720.91	4739.32	9157.0
2016-02-12 04:00:00	NQ	Futures	4739.32	4753.28	4730.12	4745.85	6204.0
2016-02-12 05:00:00	NQ	Futures	4745.85	4755.06	4737.24	4739.02	3387.0
2016-02-12 06:00:00	NQ	Futures	4738.43	4765.75	4736.35	4760.11	3490.0
2016-02-12 07:00:00	NQ	Futures	4760.4	4761.0	4742.29	4742.29	3801.0
2016-02-12 08:00:00	NQ	Futures	4742.29	4763.97	4734.87	4748.82	11341.0
2016-02-12 09:00:00	NQ	Futures	4748.53	4756.25	4706.66	4710.22	45482.0
2016-02-12 10:00:00	NQ	Futures	4709.63	4736.65	4704.28	4719.72	43182.0
2016-02-12 11:00:00	NQ	Futures	4720.02	4769.31	4719.72	4748.53	37867.0
2016-02-12 12:00:00	NQ	Futures	4748.53	4759.81	4746.15	4747.04	16642.0
2016-02-12 13:00:00	NQ	Futures	4747.04	4748.82	4723.58	4734.57	24317.0
2016-02-12 14:00:00	NQ	Futures	4734.87	4766.64	4732.79	4759.81	25482.0
2016-02-12 15:00:00	NQ	Futures	4759.81	4771.69	4752.68	4766.64	41779.0
2016-02-12 16:00:00	NQ	Futures	4766.34	4769.01	4751.79	4769.01	11350.0
2016-02-12 00:00:00	YM	Futures	16680.4	16694.2	16621.8	16634.6	2442.0
2016-02-12 01:00:00	YM	Futures	16634.6	16644.2	16612.2	16616.5	1111.0
2016-02-12 02:00:00	YM	Futures	16618.6	16681.4	16597.3	16670.8	2999.0
2016-02-12 03:00:00	YM	Futures	16668.7	16743.2	16668.7	16721.9	9066.0
2016-02-12 04:00:00	YM	Futures	16723.0	16758.1	16695.3	16734.7	5533.0
2016-02-12 05:00:00	YM	Futures	16734.7	16760.2	16712.3	16718.7	3352.0
2016-02-12 06:00:00	YM	Futures	16718.7	16797.5	16711.2	16783.6	4265.0
2016-02-12 07:00:00	YM	Futures	16784.7	16787.9	16744.2	16750.6	3988.0
2016-02-12 08:00:00	YM	Futures	16750.6	16809.2	16715.5	16770.9	8876.0
2016-02-12 09:00:00	YM	Futures	16770.9	16782.6	16712.3	16729.3	33519.0
2016-02-12 10:00:00	YM	Futures	16729.3	16813.4	16702.7	16787.9	32751.0
2016-02-12 11:00:00	YM	Futures	16789.0	16887.9	16786.8	16858.1	26050.0
2016-02-12 12:00:00	YM	Futures	16860.3	16884.8	16848.6	16867.7	10916.0
2016-02-12 13:00:00	YM	Futures	16867.7	16881.6	16823.0	16851.8	11274.0
2016-02-12 14:00:00	YM	Futures	16851.8	16933.7	16847.5	16920.9	15350.0
2016-02-12 15:00:00	YM	Futures	16920.9	16950.8	16894.3	16947.6	18395.0

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

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