PREVIEW / futures_1hour / 2011-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-02.parquet
  size:    48 KB
  rows:    1,463

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-03-02 00:00:00	ES	Futures	1283.9	1285.38	1283.65	1284.64	4996.0
2011-03-02 01:00:00	ES	Futures	1284.89	1286.13	1283.65	1286.13	4660.0
2011-03-02 02:00:00	ES	Futures	1286.13	1289.1	1286.13	1288.35	18934.0
2011-03-02 03:00:00	ES	Futures	1288.35	1289.34	1284.15	1287.61	49713.0
2011-03-02 04:00:00	ES	Futures	1287.61	1288.35	1285.14	1287.12	25819.0
2011-03-02 05:00:00	ES	Futures	1287.36	1290.58	1286.87	1288.6	30398.0
2011-03-02 06:00:00	ES	Futures	1288.35	1291.57	1287.61	1290.83	30762.0
2011-03-02 07:00:00	ES	Futures	1290.58	1292.31	1289.1	1290.33	38877.0
2011-03-02 08:00:00	ES	Futures	1290.33	1290.83	1284.15	1287.12	112544.0
2011-03-02 09:00:00	ES	Futures	1287.36	1294.54	1287.12	1294.04	344641.0
2011-03-02 10:00:00	ES	Futures	1294.04	1299.24	1292.81	1297.76	449066.0
2011-03-02 11:00:00	ES	Futures	1298.0	1300.23	1289.1	1289.1	471424.0
2011-03-02 12:00:00	ES	Futures	1289.34	1296.27	1288.11	1294.79	248776.0
2011-03-02 13:00:00	ES	Futures	1294.79	1296.52	1291.07	1292.31	173249.0
2011-03-02 14:00:00	ES	Futures	1292.56	1298.25	1290.58	1296.52	245787.0
2011-03-02 15:00:00	ES	Futures	1296.77	1298.74	1292.56	1294.29	238368.0
2011-03-02 16:00:00	ES	Futures	1294.04	1294.29	1291.57	1292.31	92672.0
2011-03-02 17:00:00	ES	Futures	1292.31	1292.56	1291.57	1291.82	1501.0
2011-03-02 18:00:00	ES	Futures	1292.06	1293.3	1291.57	1292.56	4098.0
2011-03-02 19:00:00	ES	Futures	1292.56	1294.54	1292.31	1294.04	5702.0
2011-03-02 20:00:00	ES	Futures	1294.04	1296.02	1293.55	1295.28	6068.0
2011-03-02 21:00:00	ES	Futures	1295.53	1295.53	1294.79	1295.03	2213.0
2011-03-02 22:00:00	ES	Futures	1295.28	1296.77	1294.79	1296.52	4279.0
2011-03-02 23:00:00	ES	Futures	1296.52	1297.26	1296.27	1297.01	5255.0
2011-03-02 00:00:00	NQ	Futures	2645.58	2649.31	2645.29	2648.45	277.0
2011-03-02 01:00:00	NQ	Futures	2647.87	2651.32	2645.58	2650.74	723.0
2011-03-02 02:00:00	NQ	Futures	2651.61	2656.77	2649.88	2655.34	1422.0
2011-03-02 03:00:00	NQ	Futures	2655.34	2656.77	2648.45	2653.61	4244.0
2011-03-02 04:00:00	NQ	Futures	2653.33	2654.76	2647.87	2651.89	2367.0
2011-03-02 05:00:00	NQ	Futures	2651.61	2659.07	2651.61	2656.2	1961.0
2011-03-02 06:00:00	NQ	Futures	2656.2	2661.08	2654.19	2659.36	1420.0
2011-03-02 07:00:00	NQ	Futures	2659.64	2662.51	2656.49	2657.92	6178.0
2011-03-02 08:00:00	NQ	Futures	2657.92	2657.92	2645.58	2653.61	14568.0
2011-03-02 09:00:00	NQ	Futures	2653.61	2668.25	2653.33	2667.68	45708.0
2011-03-02 10:00:00	NQ	Futures	2667.68	2684.04	2664.81	2681.46	72184.0
2011-03-02 11:00:00	NQ	Futures	2681.46	2687.77	2663.66	2663.95	53460.0
2011-03-02 12:00:00	NQ	Futures	2663.95	2677.44	2661.65	2673.13	32609.0
2011-03-02 13:00:00	NQ	Futures	2673.42	2682.61	2665.96	2668.25	25740.0
2011-03-02 14:00:00	NQ	Futures	2668.54	2678.59	2663.09	2676.86	27323.0
2011-03-02 15:00:00	NQ	Futures	2676.86	2683.75	2667.97	2670.55	30665.0
2011-03-02 16:00:00	NQ	Futures	2670.55	2670.84	2663.95	2666.53	8526.0
2011-03-02 17:00:00	NQ	Futures	2666.82	2666.82	2665.38	2665.38	221.0
2011-03-02 18:00:00	NQ	Futures	2665.67	2668.25	2665.1	2666.53	205.0
2011-03-02 19:00:00	NQ	Futures	2666.82	2670.26	2666.53	2669.11	324.0
2011-03-02 20:00:00	NQ	Futures	2669.11	2672.85	2668.25	2672.56	458.0
2011-03-02 21:00:00	NQ	Futures	2672.27	2672.27	2670.55	2671.41	129.0
2011-03-02 22:00:00	NQ	Futures	2671.41	2674.28	2671.12	2673.71	169.0
2011-03-02 23:00:00	NQ	Futures	2673.99	2675.43	2673.71	2674.28	316.0
2011-03-02 00:00:00	YM	Futures	11484.8	11494.3	11482.9	11491.5	319.0
2011-03-02 01:00:00	YM	Futures	11490.5	11503.9	11482.9	11503.0	407.0

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

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