PREVIEW / futures_1hour / 2011-02-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-15.parquet
  size:    48 KB
  rows:    1,465

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-15 00:00:00	ES	Futures	1312.85	1313.84	1312.85	1313.1	2080.0
2011-02-15 01:00:00	ES	Futures	1313.1	1313.34	1312.35	1313.34	3167.0
2011-02-15 02:00:00	ES	Futures	1313.34	1314.33	1311.36	1311.61	10112.0
2011-02-15 03:00:00	ES	Futures	1311.61	1315.57	1311.61	1314.33	23279.0
2011-02-15 04:00:00	ES	Futures	1314.33	1315.07	1313.1	1313.34	13987.0
2011-02-15 05:00:00	ES	Futures	1313.1	1315.57	1312.6	1314.83	14235.0
2011-02-15 06:00:00	ES	Futures	1314.83	1315.32	1313.84	1314.33	6072.0
2011-02-15 07:00:00	ES	Futures	1314.33	1314.58	1312.35	1312.6	14584.0
2011-02-15 08:00:00	ES	Futures	1312.6	1313.84	1310.62	1311.61	65259.0
2011-02-15 09:00:00	ES	Futures	1311.61	1314.09	1310.62	1313.59	223617.0
2011-02-15 10:00:00	ES	Futures	1313.59	1314.33	1308.64	1311.12	306896.0
2011-02-15 11:00:00	ES	Futures	1311.12	1313.34	1310.87	1311.36	171078.0
2011-02-15 12:00:00	ES	Futures	1311.36	1314.09	1310.37	1312.85	103785.0
2011-02-15 13:00:00	ES	Futures	1312.85	1313.84	1311.86	1312.35	58468.0
2011-02-15 14:00:00	ES	Futures	1312.35	1312.35	1308.64	1311.12	122130.0
2011-02-15 15:00:00	ES	Futures	1311.36	1312.6	1309.88	1312.35	183415.0
2011-02-15 16:00:00	ES	Futures	1312.35	1313.34	1311.86	1312.6	92062.0
2011-02-15 17:00:00	ES	Futures	1312.6	1313.34	1312.35	1312.85	2208.0
2011-02-15 18:00:00	ES	Futures	1312.6	1313.59	1312.35	1313.34	3300.0
2011-02-15 19:00:00	ES	Futures	1313.59	1314.09	1313.1	1313.84	2570.0
2011-02-15 20:00:00	ES	Futures	1313.84	1315.32	1312.85	1315.07	6198.0
2011-02-15 21:00:00	ES	Futures	1314.83	1317.3	1314.58	1316.81	13493.0
2011-02-15 22:00:00	ES	Futures	1316.81	1319.03	1316.56	1318.29	13404.0
2011-02-15 23:00:00	ES	Futures	1318.29	1318.54	1317.55	1317.8	2277.0
2011-02-15 00:00:00	NQ	Futures	2733.12	2734.27	2732.55	2733.41	89.0
2011-02-15 01:00:00	NQ	Futures	2733.12	2733.41	2731.4	2733.12	167.0
2011-02-15 02:00:00	NQ	Futures	2733.7	2734.85	2729.97	2730.25	522.0
2011-02-15 03:00:00	NQ	Futures	2730.54	2738.86	2730.54	2736.28	1457.0
2011-02-15 04:00:00	NQ	Futures	2736.57	2738.0	2733.98	2734.27	956.0
2011-02-15 05:00:00	NQ	Futures	2733.98	2738.29	2733.12	2737.43	1083.0
2011-02-15 06:00:00	NQ	Futures	2737.14	2738.0	2735.71	2737.43	517.0
2011-02-15 07:00:00	NQ	Futures	2737.14	2737.14	2732.26	2732.84	2168.0
2011-02-15 08:00:00	NQ	Futures	2732.84	2733.7	2727.38	2729.68	9454.0
2011-02-15 09:00:00	NQ	Futures	2729.97	2737.14	2725.95	2736.28	25160.0
2011-02-15 10:00:00	NQ	Futures	2736.28	2737.14	2721.93	2727.67	36977.0
2011-02-15 11:00:00	NQ	Futures	2727.38	2733.12	2726.81	2728.53	16013.0
2011-02-15 12:00:00	NQ	Futures	2728.53	2736.28	2726.81	2735.13	13018.0
2011-02-15 13:00:00	NQ	Futures	2735.13	2735.99	2731.97	2733.41	7836.0
2011-02-15 14:00:00	NQ	Futures	2733.12	2733.7	2725.37	2730.83	15198.0
2011-02-15 15:00:00	NQ	Futures	2730.83	2734.85	2728.53	2734.56	23398.0
2011-02-15 16:00:00	NQ	Futures	2734.56	2736.28	2732.26	2733.12	7946.0
2011-02-15 17:00:00	NQ	Futures	2733.12	2734.27	2732.84	2734.27	99.0
2011-02-15 18:00:00	NQ	Futures	2733.41	2735.99	2733.41	2735.42	139.0
2011-02-15 19:00:00	NQ	Futures	2735.42	2735.99	2734.85	2735.42	115.0
2011-02-15 20:00:00	NQ	Futures	2735.42	2738.86	2735.13	2738.86	606.0
2011-02-15 21:00:00	NQ	Futures	2738.86	2741.45	2738.58	2741.16	944.0
2011-02-15 22:00:00	NQ	Futures	2741.16	2744.89	2740.87	2743.46	1501.0
2011-02-15 23:00:00	NQ	Futures	2743.74	2744.32	2742.31	2742.6	198.0
2011-02-15 00:00:00	YM	Futures	11702.2	11708.9	11700.3	11705.1	58.0
2011-02-15 01:00:00	YM	Futures	11704.1	11705.1	11696.4	11700.3	126.0

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

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