PREVIEW / futures_1hour / 2011-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-08.parquet
  size:    41 KB
  rows:    1,176

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-08 00:00:00	ES	Futures	1347.54	1347.79	1347.04	1347.79	2141.0
2011-07-08 01:00:00	ES	Futures	1347.79	1348.54	1347.29	1348.04	4100.0
2011-07-08 02:00:00	ES	Futures	1348.04	1350.28	1347.79	1349.03	12362.0
2011-07-08 03:00:00	ES	Futures	1349.28	1349.53	1346.54	1347.79	22863.0
2011-07-08 04:00:00	ES	Futures	1347.79	1349.03	1347.29	1348.79	12898.0
2011-07-08 05:00:00	ES	Futures	1348.79	1348.79	1343.8	1345.54	34317.0
2011-07-08 06:00:00	ES	Futures	1345.29	1347.79	1344.55	1347.54	22078.0
2011-07-08 07:00:00	ES	Futures	1347.29	1348.54	1346.79	1347.54	20378.0
2011-07-08 08:00:00	ES	Futures	1347.29	1351.28	1329.08	1330.33	348669.0
2011-07-08 09:00:00	ES	Futures	1330.33	1334.82	1327.34	1333.07	371302.0
2011-07-08 10:00:00	ES	Futures	1333.32	1333.57	1327.59	1329.83	354448.0
2011-07-08 11:00:00	ES	Futures	1329.83	1331.58	1326.09	1330.58	284999.0
2011-07-08 12:00:00	ES	Futures	1330.83	1331.83	1328.58	1330.83	90788.0
2011-07-08 13:00:00	ES	Futures	1331.08	1334.57	1329.58	1331.58	160009.0
2011-07-08 14:00:00	ES	Futures	1331.58	1333.32	1330.08	1332.07	105040.0
2011-07-08 15:00:00	ES	Futures	1332.07	1336.56	1331.08	1336.56	256449.0
2011-07-08 16:00:00	ES	Futures	1336.56	1339.31	1336.07	1338.56	124343.0
2011-07-08 00:00:00	NQ	Futures	2780.96	2781.25	2780.1	2780.39	230.0
2011-07-08 01:00:00	NQ	Futures	2780.96	2782.98	2780.39	2781.54	379.0
2011-07-08 02:00:00	NQ	Futures	2781.83	2784.99	2780.39	2784.13	1600.0
2011-07-08 03:00:00	NQ	Futures	2783.84	2784.13	2779.24	2781.54	2465.0
2011-07-08 04:00:00	NQ	Futures	2781.83	2784.7	2780.96	2783.84	1527.0
2011-07-08 05:00:00	NQ	Futures	2783.55	2784.13	2774.35	2776.94	4295.0
2011-07-08 06:00:00	NQ	Futures	2776.65	2782.11	2775.78	2781.83	3079.0
2011-07-08 07:00:00	NQ	Futures	2781.83	2783.55	2781.25	2782.11	3119.0
2011-07-08 08:00:00	NQ	Futures	2782.11	2787.58	2748.45	2749.89	34867.0
2011-07-08 09:00:00	NQ	Futures	2749.89	2761.4	2742.4	2757.94	57348.0
2011-07-08 10:00:00	NQ	Futures	2758.23	2758.52	2743.27	2746.14	48688.0
2011-07-08 11:00:00	NQ	Futures	2745.86	2747.58	2734.63	2745.28	32889.0
2011-07-08 12:00:00	NQ	Futures	2745.28	2752.47	2740.96	2750.46	13990.0
2011-07-08 13:00:00	NQ	Futures	2750.17	2756.5	2745.86	2750.17	18637.0
2011-07-08 14:00:00	NQ	Futures	2749.89	2754.78	2747.3	2752.76	12969.0
2011-07-08 15:00:00	NQ	Futures	2752.76	2766.29	2751.04	2766.0	33461.0
2011-07-08 16:00:00	NQ	Futures	2766.0	2773.48	2765.42	2772.33	11064.0
2011-07-08 00:00:00	YM	Futures	12276.4	12276.4	12272.5	12274.5	135.0
2011-07-08 01:00:00	YM	Futures	12277.4	12282.2	12272.5	12279.3	226.0
2011-07-08 02:00:00	YM	Futures	12280.3	12301.6	12278.3	12294.8	812.0
2011-07-08 03:00:00	YM	Futures	12293.8	12294.8	12275.4	12281.2	1756.0
2011-07-08 04:00:00	YM	Futures	12282.2	12293.8	12279.3	12290.9	687.0
2011-07-08 05:00:00	YM	Futures	12290.0	12290.0	12248.3	12263.8	1741.0
2011-07-08 06:00:00	YM	Futures	12264.8	12287.1	12257.0	12284.1	1462.0
2011-07-08 07:00:00	YM	Futures	12284.1	12293.8	12281.2	12284.1	1508.0
2011-07-08 08:00:00	YM	Futures	12283.2	12320.0	12144.7	12153.4	17499.0
2011-07-08 09:00:00	YM	Futures	12154.4	12188.3	12130.2	12175.7	22966.0
2011-07-08 10:00:00	YM	Futures	12174.7	12175.7	12123.4	12145.7	19707.0
2011-07-08 11:00:00	YM	Futures	12145.7	12164.1	12114.7	12157.3	15673.0
2011-07-08 12:00:00	YM	Futures	12157.3	12163.1	12137.9	12152.4	4757.0
2011-07-08 13:00:00	YM	Futures	12151.5	12181.5	12142.8	12162.1	9107.0
2011-07-08 14:00:00	YM	Futures	12162.1	12175.7	12150.5	12166.0	6519.0
2011-07-08 15:00:00	YM	Futures	12165.0	12205.7	12158.3	12203.8	13286.0

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

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