PREVIEW / futures_1hour / 2011-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-09.parquet
  size:    41 KB
  rows:    1,158

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-09-09 00:00:00	ES	Futures	1188.17	1188.17	1184.93	1186.42	2305.0
2011-09-09 01:00:00	ES	Futures	1186.67	1186.92	1181.93	1182.93	5454.0
2011-09-09 02:00:00	ES	Futures	1182.93	1185.18	1180.19	1184.68	10341.0
2011-09-09 03:00:00	ES	Futures	1184.68	1188.67	1183.18	1183.93	26614.0
2011-09-09 04:00:00	ES	Futures	1183.68	1183.68	1177.69	1180.44	22579.0
2011-09-09 05:00:00	ES	Futures	1180.69	1181.93	1176.7	1176.94	16674.0
2011-09-09 06:00:00	ES	Futures	1176.94	1182.68	1175.95	1176.94	23840.0
2011-09-09 07:00:00	ES	Futures	1176.7	1179.44	1174.95	1177.44	15701.0
2011-09-09 08:00:00	ES	Futures	1177.69	1182.18	1176.7	1177.69	26438.0
2011-09-09 09:00:00	ES	Futures	1177.69	1177.94	1161.23	1165.22	183486.0
2011-09-09 10:00:00	ES	Futures	1165.22	1172.21	1162.98	1167.97	104889.0
2011-09-09 11:00:00	ES	Futures	1167.97	1172.7	1149.76	1152.25	159410.0
2011-09-09 12:00:00	ES	Futures	1152.5	1155.0	1146.52	1154.5	86762.0
2011-09-09 13:00:00	ES	Futures	1154.5	1158.24	1148.76	1150.26	66457.0
2011-09-09 14:00:00	ES	Futures	1150.51	1153.0	1144.77	1146.02	75950.0
2011-09-09 15:00:00	ES	Futures	1146.52	1154.75	1144.02	1150.26	144754.0
2011-09-09 16:00:00	ES	Futures	1150.51	1155.99	1150.01	1155.5	40391.0
2011-09-09 00:00:00	NQ	Futures	2559.38	2559.96	2552.77	2555.64	156.0
2011-09-09 01:00:00	NQ	Futures	2555.07	2555.07	2547.59	2549.31	221.0
2011-09-09 02:00:00	NQ	Futures	2548.45	2554.2	2543.85	2553.05	342.0
2011-09-09 03:00:00	NQ	Futures	2553.63	2561.11	2547.87	2550.75	906.0
2011-09-09 04:00:00	NQ	Futures	2549.02	2549.31	2538.09	2543.85	752.0
2011-09-09 05:00:00	NQ	Futures	2543.56	2547.3	2537.51	2538.09	870.0
2011-09-09 06:00:00	NQ	Futures	2537.8	2549.31	2535.79	2536.65	1078.0
2011-09-09 07:00:00	NQ	Futures	2536.08	2541.54	2532.33	2540.1	804.0
2011-09-09 08:00:00	NQ	Futures	2539.53	2550.18	2538.09	2542.69	2409.0
2011-09-09 09:00:00	NQ	Futures	2542.69	2542.69	2513.92	2519.67	18607.0
2011-09-09 10:00:00	NQ	Futures	2520.54	2539.82	2517.66	2530.9	11985.0
2011-09-09 11:00:00	NQ	Futures	2531.18	2538.09	2488.59	2493.77	17682.0
2011-09-09 12:00:00	NQ	Futures	2494.06	2500.39	2480.82	2498.67	13270.0
2011-09-09 13:00:00	NQ	Futures	2499.24	2505.0	2484.85	2486.87	6398.0
2011-09-09 14:00:00	NQ	Futures	2487.16	2493.49	2475.93	2478.81	5705.0
2011-09-09 15:00:00	NQ	Futures	2479.1	2496.94	2474.49	2489.75	11028.0
2011-09-09 16:00:00	NQ	Futures	2489.75	2498.95	2488.31	2496.94	3458.0
2011-09-09 00:00:00	YM	Futures	10987.5	10987.5	10962.3	10975.8	126.0
2011-09-09 01:00:00	YM	Futures	10973.9	10973.9	10939.0	10946.8	219.0
2011-09-09 02:00:00	YM	Futures	10944.8	10961.3	10923.5	10959.4	515.0
2011-09-09 03:00:00	YM	Futures	10960.3	10987.5	10948.7	10951.6	1034.0
2011-09-09 04:00:00	YM	Futures	10949.7	10951.6	10901.3	10922.6	730.0
2011-09-09 05:00:00	YM	Futures	10922.6	10934.2	10893.5	10894.5	640.0
2011-09-09 06:00:00	YM	Futures	10894.5	10938.1	10885.8	10895.5	868.0
2011-09-09 07:00:00	YM	Futures	10894.5	10914.8	10877.1	10897.4	590.0
2011-09-09 08:00:00	YM	Futures	10900.3	10930.3	10889.7	10893.5	1255.0
2011-09-09 09:00:00	YM	Futures	10890.6	10892.6	10721.1	10747.3	10166.0
2011-09-09 10:00:00	YM	Futures	10747.3	10808.3	10734.7	10774.4	5952.0
2011-09-09 11:00:00	YM	Futures	10773.4	10810.2	10623.3	10644.6	8678.0
2011-09-09 12:00:00	YM	Futures	10645.6	10665.0	10598.2	10652.4	5404.0
2011-09-09 13:00:00	YM	Futures	10652.4	10683.4	10611.7	10624.3	4234.0
2011-09-09 14:00:00	YM	Futures	10627.2	10647.6	10583.6	10599.1	4008.0
2011-09-09 15:00:00	YM	Futures	10595.3	10669.8	10579.8	10636.9	4918.0

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

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