PREVIEW / futures_1hour / 2011-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-31.parquet
  size:    47 KB
  rows:    1,439

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-31 00:00:00	ES	Futures	1329.35	1330.59	1328.61	1329.85	3256.0
2011-05-31 01:00:00	ES	Futures	1329.85	1330.84	1329.1	1330.35	4394.0
2011-05-31 02:00:00	ES	Futures	1330.59	1330.84	1329.6	1330.35	7244.0
2011-05-31 03:00:00	ES	Futures	1330.59	1334.07	1330.35	1333.82	40548.0
2011-05-31 04:00:00	ES	Futures	1333.82	1335.56	1333.33	1334.82	30395.0
2011-05-31 05:00:00	ES	Futures	1335.07	1335.56	1334.07	1335.31	18548.0
2011-05-31 06:00:00	ES	Futures	1335.56	1335.56	1334.07	1334.32	12186.0
2011-05-31 07:00:00	ES	Futures	1334.32	1334.82	1332.08	1332.33	24169.0
2011-05-31 08:00:00	ES	Futures	1332.33	1333.33	1331.34	1332.83	27017.0
2011-05-31 09:00:00	ES	Futures	1332.83	1335.56	1330.84	1331.34	201257.0
2011-05-31 10:00:00	ES	Futures	1331.34	1331.84	1327.36	1327.61	339198.0
2011-05-31 11:00:00	ES	Futures	1327.61	1329.85	1326.37	1326.87	204216.0
2011-05-31 12:00:00	ES	Futures	1326.87	1328.11	1324.88	1326.37	152506.0
2011-05-31 13:00:00	ES	Futures	1326.37	1330.35	1326.37	1329.85	98488.0
2011-05-31 14:00:00	ES	Futures	1329.85	1330.59	1328.36	1329.85	73695.0
2011-05-31 15:00:00	ES	Futures	1329.6	1335.81	1328.36	1335.56	395662.0
2011-05-31 16:00:00	ES	Futures	1335.31	1337.3	1335.07	1335.56	198396.0
2011-05-31 17:00:00	ES	Futures	1335.56	1336.31	1335.56	1335.56	1945.0
2011-05-31 18:00:00	ES	Futures	1335.81	1337.8	1335.81	1337.55	5972.0
2011-05-31 19:00:00	ES	Futures	1337.8	1339.29	1337.05	1337.3	8659.0
2011-05-31 20:00:00	ES	Futures	1337.3	1337.3	1335.56	1336.06	7544.0
2011-05-31 21:00:00	ES	Futures	1336.31	1338.79	1336.06	1338.3	10731.0
2011-05-31 22:00:00	ES	Futures	1338.05	1338.54	1337.55	1338.3	4753.0
2011-05-31 23:00:00	ES	Futures	1338.05	1339.04	1337.8	1338.54	3623.0
2011-05-31 00:00:00	NQ	Futures	2697.02	2699.04	2696.45	2698.17	126.0
2011-05-31 01:00:00	NQ	Futures	2698.17	2699.32	2696.45	2699.04	284.0
2011-05-31 02:00:00	NQ	Futures	2699.04	2700.76	2698.17	2699.04	621.0
2011-05-31 03:00:00	NQ	Futures	2699.32	2706.51	2699.04	2705.64	2785.0
2011-05-31 04:00:00	NQ	Futures	2705.93	2711.96	2705.36	2710.24	3145.0
2011-05-31 05:00:00	NQ	Futures	2709.95	2710.82	2708.8	2710.53	1459.0
2011-05-31 06:00:00	NQ	Futures	2710.53	2711.39	2708.23	2708.52	1239.0
2011-05-31 07:00:00	NQ	Futures	2708.52	2709.09	2705.07	2705.36	2112.0
2011-05-31 08:00:00	NQ	Futures	2705.36	2707.65	2704.21	2706.79	3560.0
2011-05-31 09:00:00	NQ	Futures	2706.79	2715.12	2706.22	2708.52	36169.0
2011-05-31 10:00:00	NQ	Futures	2708.8	2710.24	2699.04	2699.9	42692.0
2011-05-31 11:00:00	NQ	Futures	2699.61	2704.78	2697.89	2699.9	22010.0
2011-05-31 12:00:00	NQ	Futures	2699.9	2703.63	2696.45	2701.33	15350.0
2011-05-31 13:00:00	NQ	Futures	2701.33	2713.11	2701.05	2710.82	17265.0
2011-05-31 14:00:00	NQ	Futures	2710.82	2713.98	2709.09	2713.11	16362.0
2011-05-31 15:00:00	NQ	Futures	2712.83	2726.33	2709.38	2725.76	52339.0
2011-05-31 16:00:00	NQ	Futures	2725.76	2732.65	2725.47	2729.2	25471.0
2011-05-31 17:00:00	NQ	Futures	2729.49	2730.07	2728.92	2728.92	147.0
2011-05-31 18:00:00	NQ	Futures	2728.92	2733.23	2728.92	2732.65	574.0
2011-05-31 19:00:00	NQ	Futures	2732.65	2735.52	2732.08	2732.08	846.0
2011-05-31 20:00:00	NQ	Futures	2732.08	2732.08	2728.63	2729.49	870.0
2011-05-31 21:00:00	NQ	Futures	2729.78	2735.24	2729.49	2733.51	820.0
2011-05-31 22:00:00	NQ	Futures	2733.8	2734.37	2733.23	2733.51	141.0
2011-05-31 23:00:00	NQ	Futures	2733.51	2736.1	2733.23	2734.66	538.0
2011-05-31 00:00:00	YM	Futures	12035.0	12044.7	12034.1	12042.7	118.0
2011-05-31 01:00:00	YM	Futures	12043.7	12046.6	12037.0	12045.6	233.0

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

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