PREVIEW / futures_1hour / 2011-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-21.parquet
  size:    49 KB
  rows:    1,454

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-21 00:00:00	ES	Futures	1319.11	1321.35	1318.86	1321.35	1981.0
2011-07-21 01:00:00	ES	Futures	1321.35	1322.35	1320.85	1321.85	4581.0
2011-07-21 02:00:00	ES	Futures	1321.6	1323.1	1321.1	1322.85	12531.0
2011-07-21 03:00:00	ES	Futures	1322.6	1324.59	1316.11	1317.11	44605.0
2011-07-21 04:00:00	ES	Futures	1316.86	1319.85	1316.11	1317.86	21464.0
2011-07-21 05:00:00	ES	Futures	1317.86	1318.11	1312.37	1314.37	44743.0
2011-07-21 06:00:00	ES	Futures	1314.37	1318.61	1311.87	1317.86	28514.0
2011-07-21 07:00:00	ES	Futures	1317.86	1322.1	1317.36	1321.6	42747.0
2011-07-21 08:00:00	ES	Futures	1321.85	1328.33	1320.35	1326.84	144408.0
2011-07-21 09:00:00	ES	Futures	1327.09	1331.58	1323.35	1330.33	278700.0
2011-07-21 10:00:00	ES	Futures	1330.58	1338.31	1328.83	1335.82	455233.0
2011-07-21 11:00:00	ES	Futures	1336.07	1336.56	1331.33	1332.82	231695.0
2011-07-21 12:00:00	ES	Futures	1332.82	1340.31	1331.33	1337.81	325106.0
2011-07-21 13:00:00	ES	Futures	1337.56	1340.06	1336.31	1338.31	136874.0
2011-07-21 14:00:00	ES	Futures	1338.31	1339.06	1335.82	1338.56	100393.0
2011-07-21 15:00:00	ES	Futures	1338.56	1339.56	1335.82	1337.06	264092.0
2011-07-21 16:00:00	ES	Futures	1337.06	1341.3	1336.81	1340.06	108039.0
2011-07-21 17:00:00	ES	Futures	1339.81	1341.05	1339.56	1341.05	1996.0
2011-07-21 18:00:00	ES	Futures	1340.8	1341.3	1340.06	1340.55	2570.0
2011-07-21 19:00:00	ES	Futures	1340.55	1341.3	1340.06	1341.05	2096.0
2011-07-21 20:00:00	ES	Futures	1341.05	1341.3	1339.56	1340.06	4416.0
2011-07-21 21:00:00	ES	Futures	1340.06	1341.05	1339.06	1339.81	3752.0
2011-07-21 22:00:00	ES	Futures	1339.56	1341.05	1339.56	1340.8	2141.0
2011-07-21 23:00:00	ES	Futures	1340.8	1343.05	1340.55	1342.55	4996.0
2011-07-21 00:00:00	NQ	Futures	2734.06	2737.22	2732.33	2737.22	322.0
2011-07-21 01:00:00	NQ	Futures	2736.94	2739.81	2736.65	2738.95	288.0
2011-07-21 02:00:00	NQ	Futures	2738.66	2743.84	2738.09	2743.27	1234.0
2011-07-21 03:00:00	NQ	Futures	2742.98	2747.87	2731.47	2732.91	4063.0
2011-07-21 04:00:00	NQ	Futures	2732.91	2738.95	2730.89	2735.21	2598.0
2011-07-21 05:00:00	NQ	Futures	2735.5	2736.07	2725.71	2730.32	4524.0
2011-07-21 06:00:00	NQ	Futures	2730.6	2731.18	2724.85	2730.6	4251.0
2011-07-21 07:00:00	NQ	Futures	2730.6	2741.83	2730.6	2741.83	3844.0
2011-07-21 08:00:00	NQ	Futures	2741.83	2757.08	2739.81	2753.05	16932.0
2011-07-21 09:00:00	NQ	Futures	2753.05	2757.65	2733.48	2750.46	43091.0
2011-07-21 10:00:00	NQ	Futures	2751.32	2779.24	2746.72	2773.77	55635.0
2011-07-21 11:00:00	NQ	Futures	2773.77	2775.21	2754.2	2758.52	29190.0
2011-07-21 12:00:00	NQ	Futures	2758.52	2775.78	2757.08	2769.45	32132.0
2011-07-21 13:00:00	NQ	Futures	2769.45	2772.04	2764.27	2769.17	14165.0
2011-07-21 14:00:00	NQ	Futures	2769.17	2770.6	2761.68	2769.17	12346.0
2011-07-21 15:00:00	NQ	Futures	2769.17	2771.18	2762.55	2763.99	31659.0
2011-07-21 16:00:00	NQ	Futures	2764.27	2774.92	2757.65	2771.76	15715.0
2011-07-21 17:00:00	NQ	Futures	2771.18	2775.21	2771.18	2774.63	283.0
2011-07-21 18:00:00	NQ	Futures	2775.5	2775.78	2772.33	2772.62	232.0
2011-07-21 19:00:00	NQ	Futures	2772.91	2774.63	2772.62	2774.35	210.0
2011-07-21 20:00:00	NQ	Futures	2774.63	2774.63	2771.76	2772.62	209.0
2011-07-21 21:00:00	NQ	Futures	2772.33	2774.06	2770.89	2772.04	143.0
2011-07-21 22:00:00	NQ	Futures	2772.33	2774.35	2771.76	2773.77	163.0
2011-07-21 23:00:00	NQ	Futures	2774.06	2778.95	2774.06	2778.09	442.0
2011-07-21 00:00:00	YM	Futures	12123.4	12140.8	12121.5	12140.8	115.0
2011-07-21 01:00:00	YM	Futures	12136.9	12145.7	12136.0	12140.8	304.0

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

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