PREVIEW / futures_1hour / 2011-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-13.parquet
  size:    41 KB
  rows:    1,160

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-05-13 00:00:00	ES	Futures	1336.31	1337.55	1335.07	1337.3	3494.0
2011-05-13 01:00:00	ES	Futures	1337.3	1339.79	1337.3	1339.29	7627.0
2011-05-13 02:00:00	ES	Futures	1339.54	1340.28	1338.79	1339.29	10019.0
2011-05-13 03:00:00	ES	Futures	1339.04	1342.27	1338.54	1342.27	27952.0
2011-05-13 04:00:00	ES	Futures	1342.27	1344.01	1341.77	1342.77	18627.0
2011-05-13 05:00:00	ES	Futures	1342.77	1343.26	1339.29	1341.28	21598.0
2011-05-13 06:00:00	ES	Futures	1341.52	1342.02	1340.53	1341.52	13552.0
2011-05-13 07:00:00	ES	Futures	1341.77	1341.77	1340.28	1341.28	11988.0
2011-05-13 08:00:00	ES	Futures	1341.28	1344.01	1339.29	1340.53	69455.0
2011-05-13 09:00:00	ES	Futures	1340.78	1340.78	1334.82	1335.81	297461.0
2011-05-13 10:00:00	ES	Futures	1335.81	1338.54	1332.33	1335.07	308904.0
2011-05-13 11:00:00	ES	Futures	1335.07	1335.07	1327.36	1328.11	388572.0
2011-05-13 12:00:00	ES	Futures	1328.11	1329.1	1322.15	1325.63	386809.0
2011-05-13 13:00:00	ES	Futures	1325.63	1327.86	1324.13	1325.38	113433.0
2011-05-13 14:00:00	ES	Futures	1325.63	1330.1	1324.88	1327.36	130720.0
2011-05-13 15:00:00	ES	Futures	1327.61	1329.35	1325.38	1326.87	252812.0
2011-05-13 16:00:00	ES	Futures	1326.87	1327.12	1324.63	1325.63	125530.0
2011-05-13 00:00:00	NQ	Futures	2760.23	2761.67	2757.36	2760.52	382.0
2011-05-13 01:00:00	NQ	Futures	2761.1	2766.27	2761.1	2765.69	443.0
2011-05-13 02:00:00	NQ	Futures	2765.69	2767.13	2764.26	2765.69	508.0
2011-05-13 03:00:00	NQ	Futures	2765.12	2772.01	2763.97	2771.73	2035.0
2011-05-13 04:00:00	NQ	Futures	2771.73	2774.6	2770.58	2772.88	2019.0
2011-05-13 05:00:00	NQ	Futures	2772.88	2773.16	2764.54	2768.28	2107.0
2011-05-13 06:00:00	NQ	Futures	2768.85	2770.58	2767.42	2770.29	1117.0
2011-05-13 07:00:00	NQ	Futures	2770.29	2770.29	2766.84	2768.85	842.0
2011-05-13 08:00:00	NQ	Futures	2768.57	2773.16	2763.68	2766.27	8175.0
2011-05-13 09:00:00	NQ	Futures	2765.98	2766.27	2751.61	2753.91	48182.0
2011-05-13 10:00:00	NQ	Futures	2753.62	2762.24	2747.02	2755.06	30432.0
2011-05-13 11:00:00	NQ	Futures	2755.06	2755.35	2737.25	2740.12	45832.0
2011-05-13 12:00:00	NQ	Futures	2739.83	2742.42	2730.07	2734.09	72309.0
2011-05-13 13:00:00	NQ	Futures	2734.09	2738.97	2731.5	2733.8	18274.0
2011-05-13 14:00:00	NQ	Futures	2733.8	2742.13	2732.94	2736.96	16984.0
2011-05-13 15:00:00	NQ	Futures	2737.25	2739.83	2730.07	2731.21	31865.0
2011-05-13 16:00:00	NQ	Futures	2731.21	2732.08	2722.59	2724.89	16475.0
2011-05-13 00:00:00	YM	Futures	12180.5	12193.0	12173.7	12188.2	162.0
2011-05-13 01:00:00	YM	Futures	12190.1	12207.4	12189.1	12202.6	556.0
2011-05-13 02:00:00	YM	Futures	12203.6	12214.2	12200.7	12204.6	379.0
2011-05-13 03:00:00	YM	Futures	12204.6	12230.6	12200.7	12229.6	1105.0
2011-05-13 04:00:00	YM	Futures	12229.6	12242.1	12225.7	12234.4	1088.0
2011-05-13 05:00:00	YM	Futures	12235.4	12238.3	12207.4	12222.9	1088.0
2011-05-13 06:00:00	YM	Futures	12223.8	12229.6	12217.1	12225.7	810.0
2011-05-13 07:00:00	YM	Futures	12226.7	12226.7	12216.1	12222.9	463.0
2011-05-13 08:00:00	YM	Futures	12222.9	12245.0	12206.5	12217.1	3379.0
2011-05-13 09:00:00	YM	Futures	12216.1	12218.0	12166.0	12168.0	17104.0
2011-05-13 10:00:00	YM	Futures	12168.0	12200.7	12143.9	12172.8	19746.0
2011-05-13 11:00:00	YM	Futures	12171.8	12172.8	12102.5	12106.3	21715.0
2011-05-13 12:00:00	YM	Futures	12106.3	12114.0	12046.6	12075.5	27180.0
2011-05-13 13:00:00	YM	Futures	12075.5	12098.6	12067.8	12081.3	7769.0
2011-05-13 14:00:00	YM	Futures	12081.3	12120.8	12077.4	12097.6	7056.0
2011-05-13 15:00:00	YM	Futures	12097.6	12113.0	12075.5	12100.5	12837.0

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

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