PREVIEW / futures_1hour / 2012-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-05.parquet
  size:    47 KB
  rows:    1,416

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-06-05 00:00:00	ES	Futures	1291.99	1293.76	1289.97	1293.51	7274.0
2012-06-05 01:00:00	ES	Futures	1293.26	1295.03	1292.5	1294.27	5830.0
2012-06-05 02:00:00	ES	Futures	1294.52	1295.79	1291.99	1293.0	13047.0
2012-06-05 03:00:00	ES	Futures	1292.75	1293.26	1288.2	1289.97	29693.0
2012-06-05 04:00:00	ES	Futures	1290.22	1291.99	1284.4	1284.91	38933.0
2012-06-05 05:00:00	ES	Futures	1285.16	1287.44	1284.4	1284.91	24525.0
2012-06-05 06:00:00	ES	Futures	1284.91	1286.68	1284.65	1285.16	14693.0
2012-06-05 07:00:00	ES	Futures	1285.16	1287.18	1282.63	1286.43	41274.0
2012-06-05 08:00:00	ES	Futures	1286.43	1290.73	1285.92	1287.94	69538.0
2012-06-05 09:00:00	ES	Futures	1288.2	1294.01	1286.68	1293.51	249446.0
2012-06-05 10:00:00	ES	Futures	1293.51	1299.83	1292.5	1294.27	386859.0
2012-06-05 11:00:00	ES	Futures	1294.27	1297.56	1291.49	1291.74	228960.0
2012-06-05 12:00:00	ES	Futures	1291.74	1298.32	1291.74	1295.79	173958.0
2012-06-05 13:00:00	ES	Futures	1295.79	1299.33	1293.51	1297.81	118826.0
2012-06-05 14:00:00	ES	Futures	1297.81	1300.09	1297.05	1299.33	150300.0
2012-06-05 15:00:00	ES	Futures	1299.33	1302.11	1297.56	1299.58	269823.0
2012-06-05 16:00:00	ES	Futures	1299.33	1301.35	1297.3	1300.09	89051.0
2012-06-05 17:00:00	ES	Futures	1300.09	1300.34	1298.82	1300.34	4056.0
2012-06-05 18:00:00	ES	Futures	1300.34	1300.59	1298.32	1300.59	4978.0
2012-06-05 19:00:00	ES	Futures	1300.59	1305.91	1300.59	1303.12	18227.0
2012-06-05 20:00:00	ES	Futures	1303.12	1304.89	1301.86	1303.38	9246.0
2012-06-05 21:00:00	ES	Futures	1303.12	1305.65	1302.11	1305.15	16378.0
2012-06-05 22:00:00	ES	Futures	1305.15	1307.68	1304.89	1307.17	13772.0
2012-06-05 23:00:00	ES	Futures	1307.17	1311.47	1306.66	1309.7	14391.0
2012-06-05 00:00:00	NQ	Futures	2867.42	2870.03	2861.35	2869.74	886.0
2012-06-05 01:00:00	NQ	Futures	2869.45	2872.34	2868.29	2871.18	490.0
2012-06-05 02:00:00	NQ	Futures	2871.18	2874.07	2865.4	2868.0	1029.0
2012-06-05 03:00:00	NQ	Futures	2867.71	2869.16	2856.14	2861.64	3275.0
2012-06-05 04:00:00	NQ	Futures	2861.93	2867.42	2848.91	2851.52	4413.0
2012-06-05 05:00:00	NQ	Futures	2850.65	2856.14	2848.63	2849.78	2785.0
2012-06-05 06:00:00	NQ	Futures	2850.07	2853.25	2849.49	2849.78	2165.0
2012-06-05 07:00:00	NQ	Futures	2849.78	2854.7	2845.15	2853.25	4117.0
2012-06-05 08:00:00	NQ	Futures	2853.25	2865.4	2851.81	2858.17	5924.0
2012-06-05 09:00:00	NQ	Futures	2857.88	2871.47	2852.67	2866.84	30094.0
2012-06-05 10:00:00	NQ	Futures	2866.56	2880.15	2859.33	2862.51	42808.0
2012-06-05 11:00:00	NQ	Futures	2862.51	2872.92	2854.99	2856.14	21852.0
2012-06-05 12:00:00	NQ	Futures	2856.14	2868.87	2854.41	2863.37	18532.0
2012-06-05 13:00:00	NQ	Futures	2863.37	2873.5	2857.88	2870.6	13418.0
2012-06-05 14:00:00	NQ	Futures	2870.6	2879.28	2869.16	2876.39	16375.0
2012-06-05 15:00:00	NQ	Futures	2876.39	2882.75	2870.03	2876.68	26196.0
2012-06-05 16:00:00	NQ	Futures	2876.68	2881.88	2873.79	2879.57	8814.0
2012-06-05 17:00:00	NQ	Futures	2879.86	2880.15	2877.55	2879.86	165.0
2012-06-05 18:00:00	NQ	Futures	2880.44	2881.02	2876.97	2880.73	249.0
2012-06-05 19:00:00	NQ	Futures	2881.02	2890.85	2879.86	2886.22	1304.0
2012-06-05 20:00:00	NQ	Futures	2886.51	2889.69	2883.33	2886.51	1058.0
2012-06-05 21:00:00	NQ	Futures	2886.8	2891.14	2884.2	2889.69	1482.0
2012-06-05 22:00:00	NQ	Futures	2889.98	2895.48	2889.98	2893.16	1373.0
2012-06-05 23:00:00	NQ	Futures	2893.16	2902.71	2892.01	2898.08	1311.0
2012-06-05 00:00:00	YM	Futures	12052.2	12062.2	12033.3	12060.2	594.0
2012-06-05 01:00:00	YM	Futures	12059.2	12070.2	12053.2	12070.2	301.0

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

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