PREVIEW / futures_1hour / 2011-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-22.parquet
  size:    40 KB
  rows:    1,160

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-07-22 00:00:00	ES	Futures	1342.55	1342.8	1341.8	1342.55	2026.0
2011-07-22 01:00:00	ES	Futures	1342.8	1343.05	1342.05	1342.3	2458.0
2011-07-22 02:00:00	ES	Futures	1342.3	1343.05	1340.8	1342.05	10956.0
2011-07-22 03:00:00	ES	Futures	1342.05	1342.8	1340.31	1341.3	30610.0
2011-07-22 04:00:00	ES	Futures	1341.3	1344.55	1340.8	1343.05	23883.0
2011-07-22 05:00:00	ES	Futures	1343.3	1344.05	1342.05	1343.3	12376.0
2011-07-22 06:00:00	ES	Futures	1343.05	1344.55	1340.8	1341.55	23199.0
2011-07-22 07:00:00	ES	Futures	1341.3	1343.55	1338.56	1339.06	41542.0
2011-07-22 08:00:00	ES	Futures	1339.06	1340.8	1336.81	1337.06	63040.0
2011-07-22 09:00:00	ES	Futures	1337.06	1338.56	1332.07	1332.82	258847.0
2011-07-22 10:00:00	ES	Futures	1332.82	1335.07	1329.58	1334.82	284796.0
2011-07-22 11:00:00	ES	Futures	1334.82	1337.31	1333.82	1336.31	180641.0
2011-07-22 12:00:00	ES	Futures	1336.56	1339.56	1335.57	1339.06	107098.0
2011-07-22 13:00:00	ES	Futures	1339.06	1339.31	1337.31	1338.56	54743.0
2011-07-22 14:00:00	ES	Futures	1338.56	1338.81	1337.06	1338.56	67467.0
2011-07-22 15:00:00	ES	Futures	1338.81	1339.31	1335.32	1337.81	188411.0
2011-07-22 16:00:00	ES	Futures	1337.81	1339.31	1337.31	1337.56	76036.0
2011-07-22 00:00:00	NQ	Futures	2777.8	2778.66	2777.51	2778.37	86.0
2011-07-22 01:00:00	NQ	Futures	2778.37	2778.37	2776.94	2777.51	157.0
2011-07-22 02:00:00	NQ	Futures	2777.51	2779.52	2775.21	2778.66	1296.0
2011-07-22 03:00:00	NQ	Futures	2778.09	2779.24	2775.21	2776.94	4764.0
2011-07-22 04:00:00	NQ	Futures	2776.65	2781.83	2775.21	2779.24	2582.0
2011-07-22 05:00:00	NQ	Futures	2779.52	2779.81	2775.5	2778.09	1393.0
2011-07-22 06:00:00	NQ	Futures	2777.8	2780.68	2774.35	2775.78	2405.0
2011-07-22 07:00:00	NQ	Futures	2775.5	2777.51	2766.29	2767.73	3984.0
2011-07-22 08:00:00	NQ	Futures	2767.73	2770.89	2760.24	2760.53	6339.0
2011-07-22 09:00:00	NQ	Futures	2760.53	2776.36	2758.23	2764.85	31209.0
2011-07-22 10:00:00	NQ	Futures	2764.56	2771.76	2760.53	2771.76	25303.0
2011-07-22 11:00:00	NQ	Futures	2771.76	2776.65	2768.88	2775.5	15260.0
2011-07-22 12:00:00	NQ	Futures	2775.5	2789.88	2774.35	2789.02	19904.0
2011-07-22 13:00:00	NQ	Futures	2789.31	2793.91	2785.57	2793.05	14157.0
2011-07-22 14:00:00	NQ	Futures	2793.34	2796.79	2789.02	2794.78	15159.0
2011-07-22 15:00:00	NQ	Futures	2794.78	2796.79	2786.43	2793.05	25617.0
2011-07-22 16:00:00	NQ	Futures	2793.05	2796.79	2792.19	2794.78	7047.0
2011-07-22 00:00:00	YM	Futures	12314.2	12317.1	12311.3	12315.1	111.0
2011-07-22 01:00:00	YM	Futures	12315.1	12318.0	12312.2	12314.2	134.0
2011-07-22 02:00:00	YM	Futures	12312.2	12318.0	12303.5	12313.2	1046.0
2011-07-22 03:00:00	YM	Futures	12311.3	12329.7	12299.6	12320.9	3374.0
2011-07-22 04:00:00	YM	Futures	12320.0	12345.2	12314.2	12335.5	2166.0
2011-07-22 05:00:00	YM	Futures	12335.5	12339.3	12327.7	12336.4	1288.0
2011-07-22 06:00:00	YM	Futures	12335.5	12346.1	12321.9	12327.7	1587.0
2011-07-22 07:00:00	YM	Futures	12326.8	12340.3	12257.0	12264.8	4457.0
2011-07-22 08:00:00	YM	Futures	12265.7	12290.0	12252.2	12252.2	4152.0
2011-07-22 09:00:00	YM	Futures	12252.2	12272.5	12217.3	12224.1	18737.0
2011-07-22 10:00:00	YM	Futures	12224.1	12237.7	12194.1	12223.1	20713.0
2011-07-22 11:00:00	YM	Futures	12223.1	12248.3	12218.3	12238.6	8955.0
2011-07-22 12:00:00	YM	Futures	12237.7	12254.1	12228.0	12249.3	6547.0
2011-07-22 13:00:00	YM	Futures	12250.3	12252.2	12236.7	12243.5	4090.0
2011-07-22 14:00:00	YM	Futures	12243.5	12243.5	12227.0	12231.9	4103.0
2011-07-22 15:00:00	YM	Futures	12232.8	12237.7	12203.8	12228.9	9713.0

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

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