PREVIEW / futures_1hour / 2011-04-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1324.88	1326.87	1324.63	1325.63	6219.0
2011-04-21 01:00:00	ES	Futures	1325.63	1327.36	1325.63	1326.87	5879.0
2011-04-21 02:00:00	ES	Futures	1327.12	1327.12	1325.63	1326.62	11227.0
2011-04-21 03:00:00	ES	Futures	1326.37	1328.85	1324.63	1328.11	41349.0
2011-04-21 04:00:00	ES	Futures	1328.36	1328.36	1325.13	1326.37	17807.0
2011-04-21 05:00:00	ES	Futures	1326.37	1328.11	1326.12	1326.87	10670.0
2011-04-21 06:00:00	ES	Futures	1327.12	1329.1	1326.62	1328.61	21363.0
2011-04-21 07:00:00	ES	Futures	1328.61	1329.35	1327.36	1327.61	23811.0
2011-04-21 08:00:00	ES	Futures	1327.61	1327.86	1323.89	1324.88	66092.0
2011-04-21 09:00:00	ES	Futures	1324.88	1326.37	1322.15	1322.89	217852.0
2011-04-21 10:00:00	ES	Futures	1323.14	1324.13	1320.41	1323.14	262987.0
2011-04-21 11:00:00	ES	Futures	1323.39	1325.13	1322.4	1324.88	105421.0
2011-04-21 12:00:00	ES	Futures	1324.63	1325.63	1324.13	1324.63	62254.0
2011-04-21 13:00:00	ES	Futures	1324.63	1325.13	1323.14	1323.64	40319.0
2011-04-21 14:00:00	ES	Futures	1323.89	1324.88	1322.89	1323.39	62575.0
2011-04-21 15:00:00	ES	Futures	1323.14	1325.13	1322.64	1324.63	156525.0
2011-04-21 16:00:00	ES	Futures	1324.38	1324.63	1322.15	1322.4	79580.0
2011-04-21 00:00:00	NQ	Futures	2731.21	2733.8	2728.63	2732.36	547.0
2011-04-21 01:00:00	NQ	Futures	2732.36	2736.96	2732.36	2734.95	901.0
2011-04-21 02:00:00	NQ	Futures	2734.95	2735.24	2727.77	2730.93	2513.0
2011-04-21 03:00:00	NQ	Futures	2730.93	2734.37	2726.33	2733.23	2535.0
2011-04-21 04:00:00	NQ	Futures	2733.23	2733.51	2726.33	2730.93	2056.0
2011-04-21 05:00:00	NQ	Futures	2730.64	2734.37	2730.07	2730.64	1199.0
2011-04-21 06:00:00	NQ	Futures	2730.64	2738.11	2730.35	2737.54	2694.0
2011-04-21 07:00:00	NQ	Futures	2737.54	2738.4	2734.66	2735.52	2647.0
2011-04-21 08:00:00	NQ	Futures	2735.52	2736.1	2726.62	2729.2	8944.0
2011-04-21 09:00:00	NQ	Futures	2729.2	2735.24	2722.02	2729.2	60811.0
2011-04-21 10:00:00	NQ	Futures	2729.2	2730.07	2720.01	2727.77	53468.0
2011-04-21 11:00:00	NQ	Futures	2727.77	2732.65	2724.89	2732.08	25049.0
2011-04-21 12:00:00	NQ	Futures	2732.36	2732.65	2728.63	2730.64	10729.0
2011-04-21 13:00:00	NQ	Futures	2730.64	2731.21	2726.04	2728.63	10332.0
2011-04-21 14:00:00	NQ	Futures	2728.34	2731.79	2726.9	2727.77	10362.0
2011-04-21 15:00:00	NQ	Futures	2727.48	2730.07	2726.04	2728.34	19871.0
2011-04-21 16:00:00	NQ	Futures	2728.05	2730.64	2727.48	2727.77	8675.0
2011-04-21 00:00:00	YM	Futures	11978.2	11989.8	11977.2	11980.1	827.0
2011-04-21 01:00:00	YM	Futures	11980.1	11991.7	11979.2	11989.8	605.0
2011-04-21 02:00:00	YM	Futures	11989.8	11991.7	11984.0	11987.8	696.0
2011-04-21 03:00:00	YM	Futures	11987.8	12001.3	11967.6	11996.5	1659.0
2011-04-21 04:00:00	YM	Futures	11997.5	11997.5	11973.4	11983.0	942.0
2011-04-21 05:00:00	YM	Futures	11983.0	11998.4	11983.0	11987.8	449.0
2011-04-21 06:00:00	YM	Futures	11988.8	12007.1	11987.8	12004.2	1102.0
2011-04-21 07:00:00	YM	Futures	12004.2	12009.0	11996.5	11998.4	1126.0
2011-04-21 08:00:00	YM	Futures	11997.5	11997.5	11963.8	11974.4	2909.0
2011-04-21 09:00:00	YM	Futures	11974.4	11984.9	11950.3	11954.1	13087.0
2011-04-21 10:00:00	YM	Futures	11955.1	11970.5	11932.9	11958.9	16136.0
2011-04-21 11:00:00	YM	Futures	11958.9	11978.2	11949.3	11977.2	7215.0
2011-04-21 12:00:00	YM	Futures	11976.3	11984.9	11968.6	11980.1	3290.0
2011-04-21 13:00:00	YM	Futures	11981.1	11982.1	11962.8	11968.6	2752.0
2011-04-21 14:00:00	YM	Futures	11968.6	11975.3	11961.8	11968.6	2819.0
2011-04-21 15:00:00	YM	Futures	11968.6	11992.7	11964.7	11989.8	6188.0

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

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