PREVIEW / futures_1hour / 2014-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-17.parquet
  size:    45 KB
  rows:    1,306

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-10-17 00:00:00	ES	Futures	1943.27	1945.89	1942.49	1944.06	4760.0
2014-10-17 01:00:00	ES	Futures	1944.06	1944.58	1939.61	1944.32	7113.0
2014-10-17 02:00:00	ES	Futures	1944.32	1947.73	1942.49	1946.94	17818.0
2014-10-17 03:00:00	ES	Futures	1947.2	1956.11	1942.75	1955.59	56775.0
2014-10-17 04:00:00	ES	Futures	1955.59	1964.23	1955.32	1963.71	56613.0
2014-10-17 05:00:00	ES	Futures	1963.71	1966.33	1962.14	1963.18	42781.0
2014-10-17 06:00:00	ES	Futures	1963.18	1968.68	1961.61	1961.61	40140.0
2014-10-17 07:00:00	ES	Futures	1961.61	1967.64	1961.09	1964.76	49040.0
2014-10-17 08:00:00	ES	Futures	1964.76	1968.42	1960.3	1962.92	93622.0
2014-10-17 09:00:00	ES	Futures	1962.92	1969.47	1959.52	1965.54	357190.0
2014-10-17 10:00:00	ES	Futures	1965.8	1976.81	1963.97	1973.92	383429.0
2014-10-17 11:00:00	ES	Futures	1973.92	1982.31	1972.35	1978.38	291680.0
2014-10-17 12:00:00	ES	Futures	1978.38	1980.74	1972.09	1974.45	223094.0
2014-10-17 13:00:00	ES	Futures	1974.45	1976.81	1966.33	1968.68	194375.0
2014-10-17 14:00:00	ES	Futures	1968.42	1969.73	1959.78	1967.9	249304.0
2014-10-17 15:00:00	ES	Futures	1967.9	1976.02	1961.09	1969.47	335801.0
2014-10-17 16:00:00	ES	Futures	1969.47	1973.66	1966.85	1971.83	114173.0
2014-10-17 17:00:00	ES	Futures	1971.57	1971.83	1969.99	1970.26	3968.0
2014-10-17 00:00:00	NQ	Futures	4391.28	4395.96	4387.47	4390.98	670.0
2014-10-17 01:00:00	NQ	Futures	4391.28	4396.26	4385.71	4395.96	1291.0
2014-10-17 02:00:00	NQ	Futures	4395.96	4401.53	4389.52	4399.48	1784.0
2014-10-17 03:00:00	NQ	Futures	4399.48	4419.11	4390.1	4418.82	10750.0
2014-10-17 04:00:00	NQ	Futures	4418.53	4443.14	4418.53	4443.14	10200.0
2014-10-17 05:00:00	NQ	Futures	4442.55	4450.76	4439.62	4440.21	7783.0
2014-10-17 06:00:00	NQ	Futures	4440.5	4458.96	4440.5	4443.43	5982.0
2014-10-17 07:00:00	NQ	Futures	4443.43	4453.98	4439.92	4447.83	5671.0
2014-10-17 08:00:00	NQ	Futures	4447.53	4457.5	4439.92	4447.53	11202.0
2014-10-17 09:00:00	NQ	Futures	4447.24	4468.04	4431.13	4456.32	78536.0
2014-10-17 10:00:00	NQ	Futures	4456.62	4481.23	4453.39	4474.49	67696.0
2014-10-17 11:00:00	NQ	Futures	4474.2	4501.15	4470.1	4489.14	50114.0
2014-10-17 12:00:00	NQ	Futures	4489.43	4494.41	4478.01	4483.28	44476.0
2014-10-17 13:00:00	NQ	Futures	4482.99	4487.09	4457.79	4462.48	41307.0
2014-10-17 14:00:00	NQ	Futures	4462.77	4464.82	4443.14	4460.13	46681.0
2014-10-17 15:00:00	NQ	Futures	4460.72	4478.3	4443.72	4460.13	66953.0
2014-10-17 16:00:00	NQ	Futures	4459.84	4465.41	4450.46	4460.43	19185.0
2014-10-17 17:00:00	NQ	Futures	4459.84	4461.31	4457.2	4457.5	297.0
2014-10-17 00:00:00	YM	Futures	16684.0	16705.9	16677.8	16690.3	618.0
2014-10-17 01:00:00	YM	Futures	16690.3	16694.4	16657.0	16693.4	1149.0
2014-10-17 02:00:00	YM	Futures	16694.4	16716.3	16675.7	16709.0	2036.0
2014-10-17 03:00:00	YM	Futures	16712.1	16779.7	16677.8	16773.5	10149.0
2014-10-17 04:00:00	YM	Futures	16772.4	16839.0	16772.4	16834.8	7473.0
2014-10-17 05:00:00	YM	Futures	16832.7	16851.4	16815.1	16821.3	5424.0
2014-10-17 06:00:00	YM	Futures	16822.3	16865.0	16806.7	16808.8	6076.0
2014-10-17 07:00:00	YM	Futures	16807.8	16848.3	16804.7	16830.6	5787.0
2014-10-17 08:00:00	YM	Futures	16830.6	16852.5	16806.7	16822.3	10208.0
2014-10-17 09:00:00	YM	Futures	16823.4	16880.6	16815.1	16853.5	33126.0
2014-10-17 10:00:00	YM	Futures	16852.5	16939.8	16841.0	16921.1	35867.0
2014-10-17 11:00:00	YM	Futures	16921.1	16994.9	16908.6	16975.2	29888.0
2014-10-17 12:00:00	YM	Futures	16975.2	16997.0	16955.4	16972.1	23200.0
2014-10-17 13:00:00	YM	Futures	16972.1	16993.9	16905.5	16923.2	20266.0

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

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