PREVIEW / futures_1hour / 2014-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-04.parquet
  size:    42 KB
  rows:    1,251

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-04-04 00:00:00	ES	Futures	1958.44	1959.22	1958.18	1958.44	1517.0
2014-04-04 01:00:00	ES	Futures	1958.7	1959.22	1958.44	1958.96	1489.0
2014-04-04 02:00:00	ES	Futures	1958.7	1958.96	1957.14	1957.66	5302.0
2014-04-04 03:00:00	ES	Futures	1957.66	1958.96	1957.4	1958.7	12865.0
2014-04-04 04:00:00	ES	Futures	1958.7	1959.48	1957.92	1959.22	8505.0
2014-04-04 05:00:00	ES	Futures	1958.96	1960.0	1958.96	1959.74	7375.0
2014-04-04 06:00:00	ES	Futures	1959.74	1960.0	1958.18	1958.7	8656.0
2014-04-04 07:00:00	ES	Futures	1958.44	1960.0	1958.44	1959.22	9179.0
2014-04-04 08:00:00	ES	Futures	1959.22	1965.19	1957.92	1963.63	131493.0
2014-04-04 09:00:00	ES	Futures	1963.37	1965.71	1954.29	1957.66	335078.0
2014-04-04 10:00:00	ES	Futures	1957.66	1963.63	1957.66	1958.44	351347.0
2014-04-04 11:00:00	ES	Futures	1958.7	1958.7	1944.68	1947.79	356909.0
2014-04-04 12:00:00	ES	Futures	1947.79	1948.05	1937.41	1938.96	289651.0
2014-04-04 13:00:00	ES	Futures	1938.96	1942.34	1935.59	1936.89	242951.0
2014-04-04 14:00:00	ES	Futures	1936.63	1938.45	1927.54	1932.73	312665.0
2014-04-04 15:00:00	ES	Futures	1932.73	1935.85	1928.58	1930.91	284858.0
2014-04-04 16:00:00	ES	Futures	1930.91	1935.07	1930.66	1933.77	114973.0
2014-04-04 17:00:00	ES	Futures	1933.77	1934.29	1933.25	1933.51	1860.0
2014-04-04 00:00:00	NQ	Futures	4236.7	4238.74	4236.41	4236.99	221.0
2014-04-04 01:00:00	NQ	Futures	4236.99	4239.03	4236.41	4238.74	312.0
2014-04-04 02:00:00	NQ	Futures	4237.87	4238.16	4232.62	4233.21	871.0
2014-04-04 03:00:00	NQ	Futures	4233.79	4236.99	4232.92	4236.7	1148.0
2014-04-04 04:00:00	NQ	Futures	4236.7	4238.74	4235.25	4236.7	1377.0
2014-04-04 05:00:00	NQ	Futures	4237.28	4241.36	4236.7	4240.49	2015.0
2014-04-04 06:00:00	NQ	Futures	4240.49	4241.65	4237.28	4239.03	1673.0
2014-04-04 07:00:00	NQ	Futures	4239.03	4243.11	4239.03	4241.36	1772.0
2014-04-04 08:00:00	NQ	Futures	4241.65	4255.34	4239.32	4250.68	23591.0
2014-04-04 09:00:00	NQ	Futures	4250.39	4260.87	4194.18	4209.91	94984.0
2014-04-04 10:00:00	NQ	Futures	4209.33	4233.21	4185.74	4186.9	112845.0
2014-04-04 11:00:00	NQ	Futures	4186.9	4187.49	4142.35	4151.37	86099.0
2014-04-04 12:00:00	NQ	Futures	4151.37	4152.25	4120.5	4126.91	78363.0
2014-04-04 13:00:00	NQ	Futures	4126.33	4139.14	4118.76	4126.91	55253.0
2014-04-04 14:00:00	NQ	Futures	4126.91	4133.03	4103.61	4119.05	57442.0
2014-04-04 15:00:00	NQ	Futures	4119.05	4131.86	4107.69	4113.22	74865.0
2014-04-04 16:00:00	NQ	Futures	4113.22	4127.49	4112.64	4124.58	16582.0
2014-04-04 17:00:00	NQ	Futures	4124.29	4126.62	4124.0	4126.04	264.0
2014-04-04 00:00:00	YM	Futures	17012.2	17017.4	17010.2	17014.3	201.0
2014-04-04 01:00:00	YM	Futures	17013.3	17019.5	17011.2	17017.4	221.0
2014-04-04 02:00:00	YM	Futures	17017.4	17017.4	17004.0	17008.1	509.0
2014-04-04 03:00:00	YM	Futures	17007.1	17015.3	17002.0	17013.3	1325.0
2014-04-04 04:00:00	YM	Futures	17015.3	17019.5	17009.2	17016.4	877.0
2014-04-04 05:00:00	YM	Futures	17018.4	17021.5	17015.3	17019.5	689.0
2014-04-04 06:00:00	YM	Futures	17019.5	17022.5	17012.2	17013.3	929.0
2014-04-04 07:00:00	YM	Futures	17013.3	17023.6	17013.3	17020.5	1128.0
2014-04-04 08:00:00	YM	Futures	17019.5	17067.9	17009.2	17054.5	15183.0
2014-04-04 09:00:00	YM	Futures	17054.5	17068.9	16984.4	17006.1	36234.0
2014-04-04 10:00:00	YM	Futures	17006.1	17052.4	17006.1	17022.5	38115.0
2014-04-04 11:00:00	YM	Futures	17021.5	17021.5	16940.2	16972.1	29169.0
2014-04-04 12:00:00	YM	Futures	16972.1	16974.1	16901.0	16911.3	30184.0
2014-04-04 13:00:00	YM	Futures	16910.3	16929.9	16884.5	16889.7	25065.0

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

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