PREVIEW / futures_1hour / 2011-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-14.parquet
  size:    50 KB
  rows:    1,482

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-04-14 00:00:00	ES	Futures	1300.53	1301.28	1299.54	1301.28	2153.0
2011-04-14 01:00:00	ES	Futures	1301.03	1302.52	1300.78	1302.02	6265.0
2011-04-14 02:00:00	ES	Futures	1302.02	1302.02	1298.79	1299.54	8253.0
2011-04-14 03:00:00	ES	Futures	1299.29	1300.04	1297.3	1298.3	29709.0
2011-04-14 04:00:00	ES	Futures	1298.3	1299.79	1297.3	1297.8	17934.0
2011-04-14 05:00:00	ES	Futures	1297.8	1298.55	1293.58	1293.58	37038.0
2011-04-14 06:00:00	ES	Futures	1293.83	1295.32	1293.33	1293.83	28230.0
2011-04-14 07:00:00	ES	Futures	1293.83	1295.81	1292.83	1295.57	31053.0
2011-04-14 08:00:00	ES	Futures	1295.32	1296.31	1291.59	1293.58	87683.0
2011-04-14 09:00:00	ES	Futures	1293.58	1296.06	1290.1	1293.83	331508.0
2011-04-14 10:00:00	ES	Futures	1293.83	1300.04	1293.33	1297.55	372246.0
2011-04-14 11:00:00	ES	Futures	1297.55	1299.04	1295.07	1297.8	247428.0
2011-04-14 12:00:00	ES	Futures	1297.55	1301.28	1297.06	1300.53	134606.0
2011-04-14 13:00:00	ES	Futures	1300.78	1301.53	1297.8	1298.05	109819.0
2011-04-14 14:00:00	ES	Futures	1298.05	1302.02	1297.8	1301.28	117336.0
2011-04-14 15:00:00	ES	Futures	1301.28	1305.01	1300.78	1303.02	308365.0
2011-04-14 16:00:00	ES	Futures	1303.02	1303.52	1301.03	1302.27	111110.0
2011-04-14 17:00:00	ES	Futures	1302.27	1303.52	1302.02	1303.27	2401.0
2011-04-14 18:00:00	ES	Futures	1303.02	1304.51	1302.77	1303.52	4506.0
2011-04-14 19:00:00	ES	Futures	1303.27	1305.01	1302.77	1304.76	3079.0
2011-04-14 20:00:00	ES	Futures	1304.51	1304.76	1301.78	1302.77	5729.0
2011-04-14 21:00:00	ES	Futures	1302.52	1303.52	1301.03	1302.27	6105.0
2011-04-14 22:00:00	ES	Futures	1302.27	1303.76	1301.78	1302.27	6744.0
2011-04-14 23:00:00	ES	Futures	1302.52	1302.52	1300.29	1300.78	5199.0
2011-04-14 00:00:00	NQ	Futures	2652.49	2653.35	2650.19	2653.35	306.0
2011-04-14 01:00:00	NQ	Futures	2653.06	2655.36	2651.92	2653.93	785.0
2011-04-14 02:00:00	NQ	Futures	2653.93	2654.21	2648.76	2650.19	1106.0
2011-04-14 03:00:00	NQ	Futures	2650.48	2651.92	2646.74	2648.76	2668.0
2011-04-14 04:00:00	NQ	Futures	2648.76	2651.34	2647.03	2647.32	844.0
2011-04-14 05:00:00	NQ	Futures	2647.61	2649.04	2636.69	2636.98	3077.0
2011-04-14 06:00:00	NQ	Futures	2637.26	2637.55	2632.95	2634.1	5203.0
2011-04-14 07:00:00	NQ	Futures	2633.81	2639.27	2632.38	2638.7	4024.0
2011-04-14 08:00:00	NQ	Futures	2638.7	2640.42	2632.38	2637.84	10531.0
2011-04-14 09:00:00	NQ	Futures	2637.84	2643.01	2628.93	2637.55	56777.0
2011-04-14 10:00:00	NQ	Futures	2637.55	2649.9	2635.83	2643.58	59688.0
2011-04-14 11:00:00	NQ	Futures	2643.58	2645.88	2636.11	2642.43	32259.0
2011-04-14 12:00:00	NQ	Futures	2642.72	2647.61	2641.57	2646.46	15544.0
2011-04-14 13:00:00	NQ	Futures	2646.74	2648.47	2637.55	2638.12	14251.0
2011-04-14 14:00:00	NQ	Futures	2637.84	2650.19	2637.84	2647.89	15988.0
2011-04-14 15:00:00	NQ	Futures	2648.18	2657.09	2647.03	2652.78	45616.0
2011-04-14 16:00:00	NQ	Futures	2652.78	2653.35	2641.0	2644.73	20122.0
2011-04-14 17:00:00	NQ	Futures	2645.31	2645.31	2642.43	2643.3	859.0
2011-04-14 18:00:00	NQ	Futures	2644.16	2649.9	2643.58	2646.74	626.0
2011-04-14 19:00:00	NQ	Futures	2646.74	2650.19	2646.17	2649.33	179.0
2011-04-14 20:00:00	NQ	Futures	2649.33	2649.33	2644.45	2645.59	189.0
2011-04-14 21:00:00	NQ	Futures	2646.17	2646.74	2644.45	2646.17	361.0
2011-04-14 22:00:00	NQ	Futures	2646.46	2648.47	2645.02	2646.46	277.0
2011-04-14 23:00:00	NQ	Futures	2645.88	2645.88	2640.42	2640.71	533.0
2011-04-14 00:00:00	YM	Futures	11753.8	11759.6	11746.1	11757.6	201.0
2011-04-14 01:00:00	YM	Futures	11755.7	11771.1	11755.7	11765.3	612.0

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

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