PREVIEW / futures_1hour / 2011-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-28.parquet
  size:    47 KB
  rows:    1,428

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-28 00:00:00	ES	Futures	1300.53	1301.53	1299.29	1300.29	5831.0
2011-03-28 01:00:00	ES	Futures	1300.29	1301.28	1299.79	1300.78	2202.0
2011-03-28 02:00:00	ES	Futures	1300.53	1302.77	1300.29	1302.02	5723.0
2011-03-28 03:00:00	ES	Futures	1302.02	1305.5	1299.29	1304.76	32550.0
2011-03-28 04:00:00	ES	Futures	1304.76	1305.75	1303.52	1303.76	17100.0
2011-03-28 05:00:00	ES	Futures	1303.76	1305.25	1301.53	1302.02	14722.0
2011-03-28 06:00:00	ES	Futures	1302.02	1303.76	1301.53	1303.76	10109.0
2011-03-28 07:00:00	ES	Futures	1303.52	1304.76	1303.02	1303.76	17095.0
2011-03-28 08:00:00	ES	Futures	1304.01	1304.01	1302.02	1303.76	33709.0
2011-03-28 09:00:00	ES	Futures	1303.76	1306.25	1302.27	1305.01	152364.0
2011-03-28 10:00:00	ES	Futures	1305.01	1306.99	1303.52	1303.76	214620.0
2011-03-28 11:00:00	ES	Futures	1303.76	1304.26	1301.03	1302.52	164737.0
2011-03-28 12:00:00	ES	Futures	1302.52	1303.27	1301.78	1302.77	73635.0
2011-03-28 13:00:00	ES	Futures	1303.02	1304.26	1302.52	1302.52	37889.0
2011-03-28 14:00:00	ES	Futures	1302.77	1303.76	1301.53	1301.78	76914.0
2011-03-28 15:00:00	ES	Futures	1301.78	1303.27	1297.06	1297.3	270938.0
2011-03-28 16:00:00	ES	Futures	1297.55	1297.8	1293.83	1294.32	115983.0
2011-03-28 17:00:00	ES	Futures	1294.57	1294.82	1293.83	1294.32	3573.0
2011-03-28 18:00:00	ES	Futures	1294.07	1295.32	1293.58	1294.57	4602.0
2011-03-28 19:00:00	ES	Futures	1294.57	1294.82	1293.58	1293.83	4174.0
2011-03-28 20:00:00	ES	Futures	1293.83	1295.32	1293.58	1294.32	6499.0
2011-03-28 21:00:00	ES	Futures	1294.57	1296.31	1294.32	1295.57	6942.0
2011-03-28 22:00:00	ES	Futures	1295.81	1295.81	1293.83	1294.32	4490.0
2011-03-28 23:00:00	ES	Futures	1294.32	1295.81	1294.07	1295.57	4916.0
2011-03-28 00:00:00	NQ	Futures	2663.41	2664.84	2661.68	2663.12	801.0
2011-03-28 01:00:00	NQ	Futures	2663.41	2665.13	2662.83	2664.56	168.0
2011-03-28 02:00:00	NQ	Futures	2663.7	2668.29	2663.41	2666.28	666.0
2011-03-28 03:00:00	NQ	Futures	2666.57	2674.9	2662.83	2673.18	3895.0
2011-03-28 04:00:00	NQ	Futures	2673.18	2676.05	2671.17	2671.45	1979.0
2011-03-28 05:00:00	NQ	Futures	2671.45	2674.61	2667.14	2668.01	1754.0
2011-03-28 06:00:00	NQ	Futures	2668.01	2671.17	2667.14	2670.88	1392.0
2011-03-28 07:00:00	NQ	Futures	2670.59	2673.75	2669.15	2671.45	2462.0
2011-03-28 08:00:00	NQ	Futures	2671.45	2671.45	2665.99	2670.02	4531.0
2011-03-28 09:00:00	NQ	Futures	2670.3	2673.18	2659.39	2664.56	34998.0
2011-03-28 10:00:00	NQ	Futures	2664.84	2670.02	2660.25	2663.12	29733.0
2011-03-28 11:00:00	NQ	Futures	2663.12	2665.71	2654.21	2660.25	22993.0
2011-03-28 12:00:00	NQ	Futures	2660.25	2662.26	2658.81	2660.53	13406.0
2011-03-28 13:00:00	NQ	Futures	2660.53	2664.27	2659.1	2659.39	8612.0
2011-03-28 14:00:00	NQ	Futures	2659.1	2662.55	2654.5	2654.79	23433.0
2011-03-28 15:00:00	NQ	Futures	2654.79	2658.24	2643.58	2644.45	39247.0
2011-03-28 16:00:00	NQ	Futures	2644.73	2645.02	2637.26	2641.0	12334.0
2011-03-28 17:00:00	NQ	Futures	2641.0	2641.28	2638.99	2639.85	282.0
2011-03-28 18:00:00	NQ	Futures	2640.14	2641.28	2638.7	2639.56	708.0
2011-03-28 19:00:00	NQ	Futures	2639.56	2639.85	2638.12	2638.41	144.0
2011-03-28 20:00:00	NQ	Futures	2638.7	2641.28	2638.41	2639.85	269.0
2011-03-28 21:00:00	NQ	Futures	2639.56	2643.58	2639.56	2642.15	308.0
2011-03-28 22:00:00	NQ	Futures	2642.15	2642.72	2634.96	2636.11	1019.0
2011-03-28 23:00:00	NQ	Futures	2636.4	2639.27	2636.11	2638.99	741.0
2011-03-28 00:00:00	YM	Futures	11713.3	11720.1	11705.6	11710.4	516.0
2011-03-28 01:00:00	YM	Futures	11713.3	11721.0	11710.4	11720.1	545.0

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

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