PREVIEW / futures_1hour / 2012-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-09.parquet
  size:    40 KB
  rows:    1,184

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
2012-03-09 00:00:00	ES	Futures	1378.12	1379.38	1377.62	1378.12	4375.0
2012-03-09 01:00:00	ES	Futures	1377.87	1378.37	1374.09	1376.11	8394.0
2012-03-09 02:00:00	ES	Futures	1375.85	1377.37	1375.6	1376.11	7300.0
2012-03-09 03:00:00	ES	Futures	1376.36	1378.63	1374.59	1375.85	17183.0
2012-03-09 04:00:00	ES	Futures	1375.85	1377.11	1375.35	1376.11	10290.0
2012-03-09 05:00:00	ES	Futures	1375.85	1376.36	1374.85	1375.35	6717.0
2012-03-09 06:00:00	ES	Futures	1375.35	1377.11	1374.85	1376.61	5997.0
2012-03-09 07:00:00	ES	Futures	1376.61	1377.37	1375.6	1376.61	12550.0
2012-03-09 08:00:00	ES	Futures	1376.61	1383.92	1376.11	1380.64	79257.0
2012-03-09 09:00:00	ES	Futures	1380.64	1381.4	1377.37	1378.37	81235.0
2012-03-09 10:00:00	ES	Futures	1378.37	1385.43	1378.12	1384.67	100697.0
2012-03-09 11:00:00	ES	Futures	1384.67	1385.18	1382.91	1384.42	45001.0
2012-03-09 12:00:00	ES	Futures	1384.42	1384.93	1383.16	1384.17	23695.0
2012-03-09 13:00:00	ES	Futures	1383.92	1385.18	1383.41	1384.67	19238.0
2012-03-09 14:00:00	ES	Futures	1384.93	1385.18	1379.63	1380.89	46459.0
2012-03-09 15:00:00	ES	Futures	1380.89	1382.41	1379.63	1381.9	64353.0
2012-03-09 16:00:00	ES	Futures	1381.9	1384.17	1381.15	1382.91	29836.0
2012-03-09 00:00:00	NQ	Futures	3047.69	3050.29	3047.11	3047.69	295.0
2012-03-09 01:00:00	NQ	Futures	3047.69	3048.27	3041.34	3044.22	484.0
2012-03-09 02:00:00	NQ	Futures	3044.22	3047.11	3043.93	3044.22	451.0
2012-03-09 03:00:00	NQ	Futures	3044.51	3049.13	3040.76	3044.51	1119.0
2012-03-09 04:00:00	NQ	Futures	3044.51	3046.25	3042.78	3044.22	702.0
2012-03-09 05:00:00	NQ	Futures	3044.22	3045.38	3042.2	3043.36	333.0
2012-03-09 06:00:00	NQ	Futures	3043.36	3046.82	3042.78	3045.96	332.0
2012-03-09 07:00:00	NQ	Futures	3045.38	3048.56	3044.22	3046.53	729.0
2012-03-09 08:00:00	NQ	Futures	3046.82	3059.24	3039.89	3053.18	5236.0
2012-03-09 09:00:00	NQ	Futures	3052.6	3058.37	3048.27	3049.71	13572.0
2012-03-09 10:00:00	NQ	Futures	3050.0	3061.26	3048.84	3060.11	13492.0
2012-03-09 11:00:00	NQ	Futures	3060.11	3060.97	3056.64	3059.24	4573.0
2012-03-09 12:00:00	NQ	Futures	3059.82	3060.68	3057.22	3059.82	2108.0
2012-03-09 13:00:00	NQ	Futures	3059.53	3063.28	3058.66	3061.84	4049.0
2012-03-09 14:00:00	NQ	Futures	3062.13	3064.15	3054.04	3056.06	6354.0
2012-03-09 15:00:00	NQ	Futures	3056.35	3059.53	3053.46	3058.09	9912.0
2012-03-09 16:00:00	NQ	Futures	3058.09	3060.4	3056.64	3058.95	3390.0
2012-03-09 00:00:00	YM	Futures	12802.5	12810.4	12798.5	12800.5	544.0
2012-03-09 01:00:00	YM	Futures	12801.5	12802.5	12769.8	12787.6	649.0
2012-03-09 02:00:00	YM	Futures	12786.6	12799.5	12782.7	12792.6	574.0
2012-03-09 03:00:00	YM	Futures	12793.6	12810.4	12778.7	12791.6	1857.0
2012-03-09 04:00:00	YM	Futures	12791.6	12800.5	12787.6	12791.6	978.0
2012-03-09 05:00:00	YM	Futures	12791.6	12796.5	12784.7	12787.6	641.0
2012-03-09 06:00:00	YM	Futures	12788.6	12800.5	12782.7	12797.5	420.0
2012-03-09 07:00:00	YM	Futures	12796.5	12803.5	12791.6	12794.6	561.0
2012-03-09 08:00:00	YM	Futures	12795.6	12840.2	12788.6	12824.3	5470.0
2012-03-09 09:00:00	YM	Futures	12823.3	12824.3	12794.6	12799.5	4814.0
2012-03-09 10:00:00	YM	Futures	12799.5	12850.1	12794.6	12842.1	6471.0
2012-03-09 11:00:00	YM	Futures	12841.1	12843.1	12821.3	12831.2	2726.0
2012-03-09 12:00:00	YM	Futures	12831.2	12836.2	12822.3	12827.3	1028.0
2012-03-09 13:00:00	YM	Futures	12827.3	12837.2	12822.3	12828.3	1416.0
2012-03-09 14:00:00	YM	Futures	12829.3	12832.2	12790.6	12799.5	2350.0
2012-03-09 15:00:00	YM	Futures	12799.5	12814.4	12782.7	12809.4	4378.0

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

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