PREVIEW / futures_1hour / 2013-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-01.parquet
  size:    42 KB
  rows:    1,258

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
2013-11-01 00:00:00	ES	Futures	1807.53	1808.56	1807.01	1808.3	2601.0
2013-11-01 01:00:00	ES	Futures	1808.3	1809.08	1807.27	1808.82	2225.0
2013-11-01 02:00:00	ES	Futures	1808.56	1809.33	1808.3	1809.33	1830.0
2013-11-01 03:00:00	ES	Futures	1809.33	1811.14	1808.82	1810.88	8030.0
2013-11-01 04:00:00	ES	Futures	1810.62	1810.88	1807.79	1808.82	22771.0
2013-11-01 05:00:00	ES	Futures	1808.82	1809.85	1808.04	1808.82	10155.0
2013-11-01 06:00:00	ES	Futures	1809.08	1809.85	1807.27	1809.08	12287.0
2013-11-01 07:00:00	ES	Futures	1809.33	1810.88	1808.82	1809.85	19841.0
2013-11-01 08:00:00	ES	Futures	1809.85	1811.91	1809.85	1810.88	27049.0
2013-11-01 09:00:00	ES	Futures	1810.88	1815.01	1809.85	1813.72	143436.0
2013-11-01 10:00:00	ES	Futures	1813.98	1817.33	1808.3	1811.91	332773.0
2013-11-01 11:00:00	ES	Futures	1812.17	1812.17	1803.14	1803.66	277132.0
2013-11-01 12:00:00	ES	Futures	1803.66	1807.79	1802.63	1806.24	158169.0
2013-11-01 13:00:00	ES	Futures	1806.5	1810.37	1804.18	1809.59	108944.0
2013-11-01 14:00:00	ES	Futures	1809.59	1810.62	1808.3	1808.82	96174.0
2013-11-01 15:00:00	ES	Futures	1808.82	1815.01	1808.56	1811.91	249186.0
2013-11-01 16:00:00	ES	Futures	1812.17	1812.43	1809.59	1810.11	92601.0
2013-11-01 17:00:00	ES	Futures	1810.11	1811.14	1809.59	1810.62	2958.0
2013-11-01 00:00:00	NQ	Futures	3917.35	3919.39	3916.48	3917.93	369.0
2013-11-01 01:00:00	NQ	Futures	3918.52	3922.58	3918.22	3921.13	363.0
2013-11-01 02:00:00	NQ	Futures	3921.13	3922.58	3920.84	3922.0	271.0
2013-11-01 03:00:00	NQ	Futures	3922.29	3926.07	3921.71	3924.61	1011.0
2013-11-01 04:00:00	NQ	Futures	3924.61	3924.61	3917.93	3921.42	2281.0
2013-11-01 05:00:00	NQ	Futures	3921.42	3924.32	3920.26	3922.58	1139.0
2013-11-01 06:00:00	NQ	Futures	3922.29	3924.03	3918.81	3922.87	1544.0
2013-11-01 07:00:00	NQ	Futures	3922.87	3926.36	3922.29	3924.61	2748.0
2013-11-01 08:00:00	NQ	Futures	3924.61	3929.55	3924.32	3927.81	2514.0
2013-11-01 09:00:00	NQ	Futures	3928.1	3934.78	3926.36	3930.71	27464.0
2013-11-01 10:00:00	NQ	Futures	3930.71	3936.52	3914.16	3922.58	44597.0
2013-11-01 11:00:00	NQ	Futures	3922.58	3923.45	3902.54	3903.99	41574.0
2013-11-01 12:00:00	NQ	Futures	3903.7	3916.19	3902.83	3908.93	27087.0
2013-11-01 13:00:00	NQ	Futures	3908.93	3911.84	3900.51	3910.09	21293.0
2013-11-01 14:00:00	NQ	Futures	3910.38	3913.29	3907.19	3909.22	12997.0
2013-11-01 15:00:00	NQ	Futures	3909.51	3922.29	3908.93	3918.22	32976.0
2013-11-01 16:00:00	NQ	Futures	3918.22	3919.39	3910.67	3912.13	6433.0
2013-11-01 17:00:00	NQ	Futures	3912.13	3913.87	3912.13	3913.58	109.0
2013-11-01 00:00:00	YM	Futures	15825.2	15833.4	15821.2	15828.3	469.0
2013-11-01 01:00:00	YM	Futures	15829.3	15836.5	15822.2	15834.4	363.0
2013-11-01 02:00:00	YM	Futures	15831.4	15839.5	15829.3	15838.5	289.0
2013-11-01 03:00:00	YM	Futures	15839.5	15855.9	15838.5	15849.8	1100.0
2013-11-01 04:00:00	YM	Futures	15850.8	15851.8	15826.3	15835.5	2478.0
2013-11-01 05:00:00	YM	Futures	15835.5	15845.7	15828.3	15838.5	1022.0
2013-11-01 06:00:00	YM	Futures	15838.5	15845.7	15829.3	15845.7	988.0
2013-11-01 07:00:00	YM	Futures	15844.6	15856.9	15843.6	15848.7	1360.0
2013-11-01 08:00:00	YM	Futures	15848.7	15866.1	15848.7	15853.8	2690.0
2013-11-01 09:00:00	YM	Futures	15853.8	15900.8	15848.7	15894.7	12950.0
2013-11-01 10:00:00	YM	Futures	15894.7	15920.2	15847.7	15882.4	25477.0
2013-11-01 11:00:00	YM	Futures	15882.4	15884.5	15810.9	15813.0	22378.0
2013-11-01 12:00:00	YM	Futures	15814.0	15846.7	15809.9	15835.5	13711.0
2013-11-01 13:00:00	YM	Futures	15834.4	15872.2	15817.1	15866.1	10687.0

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

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