PREVIEW / futures_1hour / 2012-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-28.parquet
  size:    40 KB
  rows:    1,192

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-12-28 00:00:00	ES	Futures	1449.23	1449.48	1446.92	1447.94	4937.0
2012-12-28 01:00:00	ES	Futures	1447.94	1448.2	1446.4	1446.4	3375.0
2012-12-28 02:00:00	ES	Futures	1446.66	1448.71	1445.89	1448.2	5622.0
2012-12-28 03:00:00	ES	Futures	1447.94	1451.02	1447.69	1449.23	14716.0
2012-12-28 04:00:00	ES	Futures	1449.48	1449.48	1445.38	1445.63	12083.0
2012-12-28 05:00:00	ES	Futures	1445.89	1446.92	1444.35	1444.86	12035.0
2012-12-28 06:00:00	ES	Futures	1444.86	1445.63	1442.56	1443.07	15498.0
2012-12-28 07:00:00	ES	Futures	1443.07	1443.32	1438.96	1439.73	22421.0
2012-12-28 08:00:00	ES	Futures	1439.99	1441.02	1436.91	1439.73	30751.0
2012-12-28 09:00:00	ES	Futures	1439.48	1443.07	1437.68	1441.02	104942.0
2012-12-28 10:00:00	ES	Futures	1440.76	1448.46	1437.42	1444.61	198311.0
2012-12-28 11:00:00	ES	Futures	1444.61	1445.89	1441.27	1443.07	81618.0
2012-12-28 12:00:00	ES	Futures	1443.32	1445.63	1442.81	1443.32	52338.0
2012-12-28 13:00:00	ES	Futures	1443.07	1444.61	1441.79	1442.56	45230.0
2012-12-28 14:00:00	ES	Futures	1442.3	1442.81	1439.73	1440.25	53636.0
2012-12-28 15:00:00	ES	Futures	1440.5	1442.81	1432.55	1432.8	219646.0
2012-12-28 16:00:00	ES	Futures	1433.06	1433.32	1418.69	1421.26	149560.0
2012-12-28 17:00:00	ES	Futures	1421.26	1426.13	1421.26	1423.31	7580.0
2012-12-28 00:00:00	NQ	Futures	3053.02	3053.61	3050.4	3051.57	363.0
2012-12-28 01:00:00	NQ	Futures	3051.57	3051.86	3046.91	3047.2	750.0
2012-12-28 02:00:00	NQ	Futures	3046.91	3050.99	3046.91	3050.4	673.0
2012-12-28 03:00:00	NQ	Futures	3050.11	3056.23	3049.24	3052.73	1877.0
2012-12-28 04:00:00	NQ	Futures	3052.73	3053.31	3046.91	3047.49	1935.0
2012-12-28 05:00:00	NQ	Futures	3047.49	3048.37	3046.04	3046.91	1691.0
2012-12-28 06:00:00	NQ	Futures	3046.62	3046.62	3039.05	3042.55	2706.0
2012-12-28 07:00:00	NQ	Futures	3042.25	3044.29	3036.43	3037.01	2629.0
2012-12-28 08:00:00	NQ	Futures	3037.31	3041.96	3032.94	3036.43	3525.0
2012-12-28 09:00:00	NQ	Futures	3036.43	3048.08	3033.81	3044.0	17694.0
2012-12-28 10:00:00	NQ	Futures	3043.42	3059.14	3035.56	3053.02	28653.0
2012-12-28 11:00:00	NQ	Futures	3053.02	3056.23	3044.87	3046.91	12425.0
2012-12-28 12:00:00	NQ	Futures	3046.91	3052.15	3045.75	3047.2	9693.0
2012-12-28 13:00:00	NQ	Futures	3047.2	3050.99	3044.87	3046.33	8305.0
2012-12-28 14:00:00	NQ	Futures	3046.04	3047.2	3040.22	3042.55	7774.0
2012-12-28 15:00:00	NQ	Futures	3042.55	3050.11	3026.83	3027.99	29152.0
2012-12-28 16:00:00	NQ	Futures	3027.7	3028.57	3006.74	3007.62	15708.0
2012-12-28 17:00:00	NQ	Futures	3007.62	3012.86	3007.03	3009.65	400.0
2012-12-28 00:00:00	YM	Futures	13091.4	13091.4	13078.3	13080.3	564.0
2012-12-28 01:00:00	YM	Futures	13080.3	13086.4	13073.3	13074.3	391.0
2012-12-28 02:00:00	YM	Futures	13074.3	13086.4	13074.3	13085.4	433.0
2012-12-28 03:00:00	YM	Futures	13083.4	13099.5	13081.3	13085.4	1406.0
2012-12-28 04:00:00	YM	Futures	13085.4	13088.4	13052.2	13056.2	1464.0
2012-12-28 05:00:00	YM	Futures	13056.2	13068.3	13046.1	13049.1	1288.0
2012-12-28 06:00:00	YM	Futures	13049.1	13057.2	13031.0	13042.1	1401.0
2012-12-28 07:00:00	YM	Futures	13041.1	13042.1	13010.9	13022.0	1956.0
2012-12-28 08:00:00	YM	Futures	13024.0	13030.0	12999.9	13018.0	3225.0
2012-12-28 09:00:00	YM	Futures	13017.0	13047.1	13006.9	13029.0	8724.0
2012-12-28 10:00:00	YM	Futures	13028.0	13085.4	12994.8	13051.2	18257.0
2012-12-28 11:00:00	YM	Futures	13051.2	13061.2	13025.0	13039.1	7454.0
2012-12-28 12:00:00	YM	Futures	13040.1	13054.2	13033.1	13037.1	4037.0
2012-12-28 13:00:00	YM	Futures	13037.1	13048.1	13023.0	13027.0	3085.0

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

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