PREVIEW / futures_1hour / 2011-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-30.parquet
  size:    48 KB
  rows:    1,450

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-03-30 00:00:00	ES	Futures	1310.97	1314.2	1310.47	1312.71	15742.0
2011-03-30 01:00:00	ES	Futures	1312.96	1313.95	1311.71	1312.96	5558.0
2011-03-30 02:00:00	ES	Futures	1312.96	1313.7	1312.46	1312.71	8746.0
2011-03-30 03:00:00	ES	Futures	1312.96	1314.45	1311.96	1313.2	27378.0
2011-03-30 04:00:00	ES	Futures	1313.2	1314.2	1310.97	1312.96	20376.0
2011-03-30 05:00:00	ES	Futures	1313.2	1314.2	1312.46	1312.96	15358.0
2011-03-30 06:00:00	ES	Futures	1312.96	1316.18	1312.71	1314.45	23500.0
2011-03-30 07:00:00	ES	Futures	1314.45	1316.18	1314.2	1315.19	32268.0
2011-03-30 08:00:00	ES	Futures	1314.94	1315.94	1313.7	1313.95	37807.0
2011-03-30 09:00:00	ES	Futures	1313.95	1315.19	1312.21	1314.45	178449.0
2011-03-30 10:00:00	ES	Futures	1314.69	1315.19	1311.22	1314.94	220504.0
2011-03-30 11:00:00	ES	Futures	1314.94	1315.69	1313.2	1314.69	160471.0
2011-03-30 12:00:00	ES	Futures	1314.69	1318.17	1314.69	1317.43	170978.0
2011-03-30 13:00:00	ES	Futures	1317.43	1319.41	1316.68	1317.43	89449.0
2011-03-30 14:00:00	ES	Futures	1317.18	1318.67	1316.68	1317.18	59149.0
2011-03-30 15:00:00	ES	Futures	1316.93	1317.92	1314.69	1315.19	199938.0
2011-03-30 16:00:00	ES	Futures	1315.19	1316.43	1314.94	1315.69	82539.0
2011-03-30 17:00:00	ES	Futures	1315.69	1315.94	1315.44	1315.69	511.0
2011-03-30 18:00:00	ES	Futures	1315.69	1316.18	1314.69	1314.94	3951.0
2011-03-30 19:00:00	ES	Futures	1314.94	1315.94	1314.45	1314.94	3934.0
2011-03-30 20:00:00	ES	Futures	1314.94	1316.18	1314.45	1315.94	4191.0
2011-03-30 21:00:00	ES	Futures	1315.69	1315.94	1314.2	1314.69	6227.0
2011-03-30 22:00:00	ES	Futures	1314.69	1315.19	1313.7	1313.95	6222.0
2011-03-30 23:00:00	ES	Futures	1313.95	1314.2	1313.45	1313.7	3379.0
2011-03-30 00:00:00	NQ	Futures	2676.34	2682.37	2675.48	2680.07	875.0
2011-03-30 01:00:00	NQ	Futures	2680.36	2682.95	2677.77	2682.08	891.0
2011-03-30 02:00:00	NQ	Futures	2682.08	2684.96	2680.93	2682.95	1381.0
2011-03-30 03:00:00	NQ	Futures	2682.95	2686.11	2680.65	2684.96	2553.0
2011-03-30 04:00:00	NQ	Futures	2684.96	2686.68	2680.93	2684.67	1381.0
2011-03-30 05:00:00	NQ	Futures	2685.24	2686.68	2682.66	2683.81	834.0
2011-03-30 06:00:00	NQ	Futures	2683.52	2688.98	2682.66	2685.82	1601.0
2011-03-30 07:00:00	NQ	Futures	2685.82	2693.0	2685.82	2689.84	5030.0
2011-03-30 08:00:00	NQ	Futures	2689.84	2690.99	2685.82	2685.82	4312.0
2011-03-30 09:00:00	NQ	Futures	2685.82	2686.68	2674.9	2681.22	34890.0
2011-03-30 10:00:00	NQ	Futures	2681.22	2682.08	2670.88	2680.36	30703.0
2011-03-30 11:00:00	NQ	Futures	2680.65	2680.93	2676.34	2678.06	13607.0
2011-03-30 12:00:00	NQ	Futures	2678.35	2686.97	2678.35	2684.38	20926.0
2011-03-30 13:00:00	NQ	Futures	2684.38	2687.54	2682.37	2683.23	10933.0
2011-03-30 14:00:00	NQ	Futures	2683.23	2686.68	2682.66	2683.52	10463.0
2011-03-30 15:00:00	NQ	Futures	2683.52	2687.54	2679.79	2683.23	30695.0
2011-03-30 16:00:00	NQ	Futures	2683.23	2685.53	2681.51	2682.95	6163.0
2011-03-30 17:00:00	NQ	Futures	2683.23	2684.38	2682.95	2684.38	33.0
2011-03-30 18:00:00	NQ	Futures	2682.95	2684.96	2678.06	2679.79	835.0
2011-03-30 19:00:00	NQ	Futures	2679.79	2681.51	2679.21	2680.07	192.0
2011-03-30 20:00:00	NQ	Futures	2680.36	2681.51	2678.92	2680.93	260.0
2011-03-30 21:00:00	NQ	Futures	2680.93	2681.22	2678.06	2678.64	229.0
2011-03-30 22:00:00	NQ	Futures	2678.92	2679.21	2676.62	2676.62	303.0
2011-03-30 23:00:00	NQ	Futures	2676.34	2678.06	2676.34	2676.91	224.0
2011-03-30 00:00:00	YM	Futures	11796.2	11822.2	11792.3	11810.6	976.0
2011-03-30 01:00:00	YM	Futures	11808.7	11817.4	11802.9	11812.5	291.0

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

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