PREVIEW / futures_1hour / 2011-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-14.parquet
  size:    45 KB
  rows:    1,403

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-02-14 00:00:00	ES	Futures	1314.83	1315.82	1314.33	1314.33	5167.0
2011-02-14 01:00:00	ES	Futures	1314.33	1316.81	1314.09	1315.82	8345.0
2011-02-14 02:00:00	ES	Futures	1315.57	1315.82	1314.33	1314.83	8017.0
2011-02-14 03:00:00	ES	Futures	1314.58	1315.82	1313.1	1313.59	27595.0
2011-02-14 04:00:00	ES	Futures	1313.34	1314.09	1312.35	1312.6	15059.0
2011-02-14 05:00:00	ES	Futures	1312.6	1313.34	1311.86	1312.35	12688.0
2011-02-14 06:00:00	ES	Futures	1312.11	1312.6	1311.61	1312.11	9325.0
2011-02-14 07:00:00	ES	Futures	1312.11	1313.34	1311.86	1312.35	12344.0
2011-02-14 08:00:00	ES	Futures	1312.11	1312.6	1311.36	1312.6	16922.0
2011-02-14 09:00:00	ES	Futures	1312.6	1313.84	1311.61	1312.85	187324.0
2011-02-14 10:00:00	ES	Futures	1312.6	1315.07	1310.87	1312.35	215064.0
2011-02-14 11:00:00	ES	Futures	1312.35	1314.33	1311.36	1314.09	100968.0
2011-02-14 12:00:00	ES	Futures	1314.09	1315.82	1313.84	1315.07	90786.0
2011-02-14 13:00:00	ES	Futures	1315.07	1315.82	1314.09	1314.83	60578.0
2011-02-14 14:00:00	ES	Futures	1315.07	1316.31	1314.33	1316.31	82307.0
2011-02-14 15:00:00	ES	Futures	1316.06	1317.55	1314.83	1316.06	190602.0
2011-02-14 16:00:00	ES	Futures	1316.06	1316.56	1312.11	1312.35	104236.0
2011-02-14 17:00:00	ES	Futures	1312.35	1312.35	1311.86	1312.11	2218.0
2011-02-14 18:00:00	ES	Futures	1312.35	1312.6	1311.36	1312.6	4191.0
2011-02-14 19:00:00	ES	Futures	1312.6	1313.59	1311.61	1312.35	6477.0
2011-02-14 20:00:00	ES	Futures	1312.6	1313.34	1312.11	1313.34	3256.0
2011-02-14 21:00:00	ES	Futures	1313.34	1314.09	1312.6	1314.09	3977.0
2011-02-14 22:00:00	ES	Futures	1314.09	1314.58	1313.1	1314.33	4084.0
2011-02-14 23:00:00	ES	Futures	1314.58	1314.83	1312.6	1313.1	3826.0
2011-02-14 00:00:00	NQ	Futures	2731.4	2733.41	2730.83	2730.83	203.0
2011-02-14 01:00:00	NQ	Futures	2730.54	2735.13	2730.54	2733.7	382.0
2011-02-14 02:00:00	NQ	Futures	2733.41	2734.27	2730.83	2731.69	398.0
2011-02-14 03:00:00	NQ	Futures	2731.97	2734.27	2730.54	2731.4	2475.0
2011-02-14 04:00:00	NQ	Futures	2731.4	2732.26	2729.39	2729.68	953.0
2011-02-14 05:00:00	NQ	Futures	2729.39	2731.11	2728.24	2728.82	623.0
2011-02-14 06:00:00	NQ	Futures	2729.1	2729.97	2728.24	2729.39	622.0
2011-02-14 07:00:00	NQ	Futures	2729.39	2730.54	2727.96	2728.24	2170.0
2011-02-14 08:00:00	NQ	Futures	2728.53	2729.97	2727.96	2729.68	1874.0
2011-02-14 09:00:00	NQ	Futures	2729.68	2736.28	2728.24	2734.56	31973.0
2011-02-14 10:00:00	NQ	Futures	2734.56	2740.87	2731.11	2733.7	29904.0
2011-02-14 11:00:00	NQ	Futures	2733.98	2738.86	2732.26	2737.43	14494.0
2011-02-14 12:00:00	NQ	Futures	2737.43	2741.16	2735.99	2738.0	17084.0
2011-02-14 13:00:00	NQ	Futures	2738.0	2739.15	2735.99	2736.28	7821.0
2011-02-14 14:00:00	NQ	Futures	2735.99	2738.0	2734.85	2736.85	9588.0
2011-02-14 15:00:00	NQ	Futures	2736.57	2738.58	2734.85	2737.43	22817.0
2011-02-14 16:00:00	NQ	Futures	2737.43	2738.29	2730.83	2731.11	9418.0
2011-02-14 17:00:00	NQ	Futures	2731.11	2731.4	2730.54	2730.83	156.0
2011-02-14 18:00:00	NQ	Futures	2730.83	2731.97	2729.97	2731.97	440.0
2011-02-14 19:00:00	NQ	Futures	2731.69	2733.41	2730.25	2731.69	295.0
2011-02-14 20:00:00	NQ	Futures	2731.69	2733.12	2731.4	2732.84	110.0
2011-02-14 21:00:00	NQ	Futures	2733.12	2734.56	2731.97	2734.56	390.0
2011-02-14 22:00:00	NQ	Futures	2734.27	2735.99	2733.41	2735.71	291.0
2011-02-14 23:00:00	NQ	Futures	2735.42	2735.99	2732.26	2733.12	181.0
2011-02-14 00:00:00	YM	Futures	11737.6	11746.2	11736.7	11736.7	310.0
2011-02-14 01:00:00	YM	Futures	11735.7	11750.1	11733.8	11745.3	397.0

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

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