PREVIEW / futures_1hour / 2011-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-24.parquet
  size:    49 KB
  rows:    1,494

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-02-24 00:00:00	ES	Futures	1295.78	1296.27	1294.04	1294.79	6470.0
2011-02-24 01:00:00	ES	Futures	1294.54	1294.79	1292.81	1293.8	7023.0
2011-02-24 02:00:00	ES	Futures	1294.04	1294.04	1281.18	1281.67	53110.0
2011-02-24 03:00:00	ES	Futures	1281.42	1285.88	1280.19	1283.65	71731.0
2011-02-24 04:00:00	ES	Futures	1283.4	1285.38	1281.18	1283.9	40128.0
2011-02-24 05:00:00	ES	Futures	1283.9	1287.12	1283.9	1285.38	35167.0
2011-02-24 06:00:00	ES	Futures	1285.38	1286.62	1283.4	1283.9	33602.0
2011-02-24 07:00:00	ES	Futures	1283.9	1286.13	1283.4	1284.39	39169.0
2011-02-24 08:00:00	ES	Futures	1284.39	1289.84	1284.39	1289.1	95317.0
2011-02-24 09:00:00	ES	Futures	1289.34	1295.03	1288.85	1294.04	385177.0
2011-02-24 10:00:00	ES	Futures	1294.04	1296.52	1290.08	1291.82	409180.0
2011-02-24 11:00:00	ES	Futures	1291.82	1293.55	1286.62	1288.35	325797.0
2011-02-24 12:00:00	ES	Futures	1288.35	1289.34	1284.15	1287.86	266707.0
2011-02-24 13:00:00	ES	Futures	1287.86	1288.85	1279.2	1281.42	283808.0
2011-02-24 14:00:00	ES	Futures	1281.42	1291.57	1280.93	1289.84	353506.0
2011-02-24 15:00:00	ES	Futures	1289.84	1295.03	1287.86	1291.57	324407.0
2011-02-24 16:00:00	ES	Futures	1291.82	1292.06	1288.11	1288.85	86572.0
2011-02-24 17:00:00	ES	Futures	1288.85	1289.84	1288.85	1289.34	3160.0
2011-02-24 18:00:00	ES	Futures	1289.84	1293.05	1289.84	1292.81	10038.0
2011-02-24 19:00:00	ES	Futures	1292.56	1293.55	1292.06	1292.81	5857.0
2011-02-24 20:00:00	ES	Futures	1292.81	1293.3	1292.31	1293.3	4018.0
2011-02-24 21:00:00	ES	Futures	1293.3	1293.3	1290.83	1291.07	7380.0
2011-02-24 22:00:00	ES	Futures	1291.07	1293.55	1291.07	1293.55	5323.0
2011-02-24 23:00:00	ES	Futures	1293.3	1295.03	1293.3	1294.54	5296.0
2011-02-24 00:00:00	NQ	Futures	2649.6	2651.03	2645.58	2646.73	174.0
2011-02-24 01:00:00	NQ	Futures	2646.44	2647.59	2643.28	2645.0	279.0
2011-02-24 02:00:00	NQ	Futures	2645.0	2645.0	2618.02	2621.75	3823.0
2011-02-24 03:00:00	NQ	Futures	2621.75	2633.24	2619.46	2627.5	5939.0
2011-02-24 04:00:00	NQ	Futures	2627.5	2629.79	2622.62	2627.21	2701.0
2011-02-24 05:00:00	NQ	Futures	2627.21	2632.66	2626.63	2629.5	1122.0
2011-02-24 06:00:00	NQ	Futures	2629.5	2631.51	2626.63	2628.07	1380.0
2011-02-24 07:00:00	NQ	Futures	2627.78	2630.94	2626.35	2628.36	2753.0
2011-02-24 08:00:00	NQ	Futures	2628.36	2645.29	2628.36	2643.86	11042.0
2011-02-24 09:00:00	NQ	Futures	2643.57	2654.48	2642.42	2652.75	48658.0
2011-02-24 10:00:00	NQ	Futures	2652.75	2662.51	2644.43	2645.87	65332.0
2011-02-24 11:00:00	NQ	Futures	2645.87	2651.32	2635.53	2642.99	44671.0
2011-02-24 12:00:00	NQ	Futures	2643.28	2645.29	2634.38	2643.86	32778.0
2011-02-24 13:00:00	NQ	Futures	2643.86	2646.73	2623.48	2627.78	38993.0
2011-02-24 14:00:00	NQ	Futures	2627.78	2653.33	2627.5	2650.74	44632.0
2011-02-24 15:00:00	NQ	Futures	2651.03	2664.81	2647.01	2655.91	49205.0
2011-02-24 16:00:00	NQ	Futures	2655.91	2655.91	2647.01	2648.74	7142.0
2011-02-24 17:00:00	NQ	Futures	2648.45	2655.34	2648.16	2654.48	926.0
2011-02-24 18:00:00	NQ	Futures	2654.48	2658.78	2654.19	2658.78	719.0
2011-02-24 19:00:00	NQ	Futures	2657.92	2659.93	2656.77	2658.21	292.0
2011-02-24 20:00:00	NQ	Futures	2658.21	2659.64	2657.35	2659.07	187.0
2011-02-24 21:00:00	NQ	Futures	2658.78	2659.07	2653.61	2654.48	223.0
2011-02-24 22:00:00	NQ	Futures	2655.62	2659.07	2655.34	2658.21	181.0
2011-02-24 23:00:00	NQ	Futures	2659.07	2661.36	2658.78	2659.36	249.0
2011-02-24 00:00:00	YM	Futures	11610.2	11611.2	11595.9	11605.4	588.0
2011-02-24 01:00:00	YM	Futures	11604.5	11604.5	11586.3	11596.8	546.0

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

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