PREVIEW / futures_1hour / 2011-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-25.parquet
  size:    39 KB
  rows:    1,161

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
2011-04-25 00:00:00	ES	Futures	1324.38	1324.63	1323.64	1324.38	1405.0
2011-04-25 01:00:00	ES	Futures	1324.38	1325.13	1324.13	1324.63	2383.0
2011-04-25 02:00:00	ES	Futures	1324.38	1325.63	1324.13	1325.63	1287.0
2011-04-25 03:00:00	ES	Futures	1325.38	1325.87	1324.88	1325.87	1560.0
2011-04-25 04:00:00	ES	Futures	1325.87	1326.87	1325.87	1326.87	3257.0
2011-04-25 05:00:00	ES	Futures	1326.62	1326.87	1326.12	1326.62	823.0
2011-04-25 06:00:00	ES	Futures	1326.62	1326.62	1325.87	1326.37	997.0
2011-04-25 07:00:00	ES	Futures	1326.62	1326.62	1325.87	1325.87	2980.0
2011-04-25 08:00:00	ES	Futures	1326.37	1326.37	1323.14	1323.89	15673.0
2011-04-25 09:00:00	ES	Futures	1323.89	1325.63	1321.9	1324.63	120591.0
2011-04-25 10:00:00	ES	Futures	1324.63	1325.38	1319.41	1320.41	150164.0
2011-04-25 11:00:00	ES	Futures	1320.41	1322.4	1318.92	1321.9	66879.0
2011-04-25 12:00:00	ES	Futures	1322.15	1323.14	1321.9	1322.4	36713.0
2011-04-25 13:00:00	ES	Futures	1322.4	1323.39	1322.15	1323.39	14538.0
2011-04-25 14:00:00	ES	Futures	1323.14	1324.38	1322.89	1323.39	30463.0
2011-04-25 15:00:00	ES	Futures	1323.39	1323.89	1321.9	1323.14	73168.0
2011-04-25 16:00:00	ES	Futures	1323.14	1323.89	1322.15	1323.64	51184.0
2011-04-25 17:00:00	ES	Futures	1323.89	1324.63	1323.39	1324.38	1632.0
2011-04-25 18:00:00	ES	Futures	1324.63	1325.13	1324.38	1324.63	2644.0
2011-04-25 19:00:00	ES	Futures	1324.63	1324.88	1324.38	1324.38	2727.0
2011-04-25 20:00:00	ES	Futures	1324.63	1325.38	1323.64	1323.89	7977.0
2011-04-25 21:00:00	ES	Futures	1323.89	1324.38	1322.64	1323.39	10532.0
2011-04-25 22:00:00	ES	Futures	1323.39	1323.89	1321.4	1321.9	4416.0
2011-04-25 23:00:00	ES	Futures	1321.9	1321.9	1320.16	1320.41	4237.0
2011-04-25 00:00:00	NQ	Futures	2731.79	2732.65	2730.93	2732.36	65.0
2011-04-25 01:00:00	NQ	Futures	2731.5	2732.94	2731.5	2732.36	141.0
2011-04-25 02:00:00	NQ	Futures	2732.36	2734.66	2732.08	2734.66	339.0
2011-04-25 03:00:00	NQ	Futures	2734.37	2734.95	2733.51	2734.95	195.0
2011-04-25 04:00:00	NQ	Futures	2735.24	2737.25	2735.24	2737.25	255.0
2011-04-25 05:00:00	NQ	Futures	2737.25	2737.54	2736.39	2736.67	129.0
2011-04-25 06:00:00	NQ	Futures	2737.25	2737.25	2736.1	2736.96	105.0
2011-04-25 07:00:00	NQ	Futures	2736.96	2737.82	2736.1	2736.39	433.0
2011-04-25 08:00:00	NQ	Futures	2736.1	2736.1	2730.64	2731.5	1835.0
2011-04-25 09:00:00	NQ	Futures	2731.79	2736.39	2727.77	2735.24	27327.0
2011-04-25 10:00:00	NQ	Futures	2735.52	2736.39	2726.04	2728.05	29871.0
2011-04-25 11:00:00	NQ	Futures	2727.77	2731.5	2725.76	2731.21	11572.0
2011-04-25 12:00:00	NQ	Futures	2731.21	2732.94	2729.2	2731.5	7633.0
2011-04-25 13:00:00	NQ	Futures	2731.21	2733.23	2729.78	2732.65	4694.0
2011-04-25 14:00:00	NQ	Futures	2732.36	2736.67	2732.36	2736.1	8579.0
2011-04-25 15:00:00	NQ	Futures	2736.1	2736.67	2732.94	2735.24	13157.0
2011-04-25 16:00:00	NQ	Futures	2734.95	2735.24	2731.21	2734.09	7200.0
2011-04-25 17:00:00	NQ	Futures	2733.8	2736.1	2733.51	2736.1	115.0
2011-04-25 18:00:00	NQ	Futures	2736.1	2736.67	2734.66	2736.1	453.0
2011-04-25 19:00:00	NQ	Futures	2736.1	2736.39	2734.66	2734.95	120.0
2011-04-25 20:00:00	NQ	Futures	2734.95	2736.96	2733.51	2734.66	739.0
2011-04-25 21:00:00	NQ	Futures	2735.24	2735.24	2731.79	2734.09	374.0
2011-04-25 22:00:00	NQ	Futures	2733.8	2734.09	2729.49	2730.07	358.0
2011-04-25 23:00:00	NQ	Futures	2730.35	2730.35	2727.77	2728.05	363.0
2011-04-25 00:00:00	YM	Futures	11982.1	11985.9	11980.1	11984.9	115.0
2011-04-25 01:00:00	YM	Futures	11984.9	11990.7	11984.9	11986.9	179.0

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

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