PREVIEW / futures_1hour / 2011-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-09.parquet
  size:    51 KB
  rows:    1,477

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-11-09 00:00:00	ES	Futures	1273.6	1274.35	1272.35	1274.1	4849.0
2011-11-09 01:00:00	ES	Futures	1274.1	1275.36	1273.6	1275.1	3115.0
2011-11-09 02:00:00	ES	Futures	1275.36	1276.11	1269.84	1271.09	17286.0
2011-11-09 03:00:00	ES	Futures	1271.09	1272.1	1267.33	1269.09	41102.0
2011-11-09 04:00:00	ES	Futures	1269.09	1269.09	1253.79	1255.55	120394.0
2011-11-09 05:00:00	ES	Futures	1255.55	1257.8	1248.78	1251.78	98182.0
2011-11-09 06:00:00	ES	Futures	1251.78	1251.78	1244.01	1247.27	89426.0
2011-11-09 07:00:00	ES	Futures	1247.27	1251.53	1246.02	1250.28	70422.0
2011-11-09 08:00:00	ES	Futures	1250.28	1252.29	1240.75	1250.28	126903.0
2011-11-09 09:00:00	ES	Futures	1250.28	1250.53	1241.25	1243.51	356860.0
2011-11-09 10:00:00	ES	Futures	1243.26	1249.78	1239.75	1247.52	445767.0
2011-11-09 11:00:00	ES	Futures	1247.27	1253.04	1245.77	1250.28	276730.0
2011-11-09 12:00:00	ES	Futures	1250.53	1251.28	1245.52	1249.03	190825.0
2011-11-09 13:00:00	ES	Futures	1249.03	1250.28	1234.98	1236.74	258281.0
2011-11-09 14:00:00	ES	Futures	1236.99	1237.24	1226.46	1231.22	436021.0
2011-11-09 15:00:00	ES	Futures	1231.22	1237.24	1227.21	1229.72	532695.0
2011-11-09 16:00:00	ES	Futures	1229.47	1234.73	1227.96	1230.47	143735.0
2011-11-09 17:00:00	ES	Futures	1230.72	1231.22	1229.47	1230.22	2808.0
2011-11-09 18:00:00	ES	Futures	1230.22	1230.72	1226.21	1226.71	9737.0
2011-11-09 19:00:00	ES	Futures	1226.71	1227.71	1223.45	1227.46	12313.0
2011-11-09 20:00:00	ES	Futures	1227.71	1229.97	1226.46	1229.22	8736.0
2011-11-09 21:00:00	ES	Futures	1228.97	1229.47	1227.46	1228.21	5385.0
2011-11-09 22:00:00	ES	Futures	1228.21	1229.97	1228.21	1228.46	4284.0
2011-11-09 23:00:00	ES	Futures	1228.71	1229.72	1227.71	1229.72	3591.0
2011-11-09 00:00:00	NQ	Futures	2757.52	2760.4	2755.79	2759.53	265.0
2011-11-09 01:00:00	NQ	Futures	2759.53	2763.57	2759.53	2762.42	342.0
2011-11-09 02:00:00	NQ	Futures	2762.99	2764.15	2750.31	2752.04	1599.0
2011-11-09 03:00:00	NQ	Futures	2752.33	2754.34	2744.25	2748.0	1829.0
2011-11-09 04:00:00	NQ	Futures	2747.71	2747.71	2716.0	2718.3	6296.0
2011-11-09 05:00:00	NQ	Futures	2718.3	2723.21	2703.02	2709.94	4995.0
2011-11-09 06:00:00	NQ	Futures	2709.65	2715.71	2698.41	2708.5	7204.0
2011-11-09 07:00:00	NQ	Futures	2708.5	2716.86	2705.91	2714.56	4452.0
2011-11-09 08:00:00	NQ	Futures	2714.84	2717.44	2701.29	2716.86	8220.0
2011-11-09 09:00:00	NQ	Futures	2717.15	2717.15	2688.9	2692.93	46851.0
2011-11-09 10:00:00	NQ	Futures	2692.36	2701.58	2682.84	2696.97	48587.0
2011-11-09 11:00:00	NQ	Futures	2696.68	2712.54	2694.95	2707.35	29696.0
2011-11-09 12:00:00	NQ	Futures	2707.64	2709.65	2698.41	2708.5	19894.0
2011-11-09 13:00:00	NQ	Futures	2708.79	2711.96	2677.65	2682.26	26955.0
2011-11-09 14:00:00	NQ	Futures	2682.26	2682.26	2655.45	2664.1	63660.0
2011-11-09 15:00:00	NQ	Futures	2664.39	2675.92	2658.04	2666.69	54434.0
2011-11-09 16:00:00	NQ	Futures	2666.12	2674.48	2660.35	2671.31	10153.0
2011-11-09 17:00:00	NQ	Futures	2671.31	2672.17	2668.42	2669.58	253.0
2011-11-09 18:00:00	NQ	Futures	2668.71	2671.88	2663.23	2663.23	637.0
2011-11-09 19:00:00	NQ	Futures	2663.23	2665.54	2657.18	2665.25	693.0
2011-11-09 20:00:00	NQ	Futures	2665.83	2669.29	2662.66	2667.56	401.0
2011-11-09 21:00:00	NQ	Futures	2667.56	2667.85	2664.1	2666.41	227.0
2011-11-09 22:00:00	NQ	Futures	2666.41	2669.58	2665.54	2668.14	292.0
2011-11-09 23:00:00	NQ	Futures	2668.14	2669.0	2665.25	2668.42	229.0
2011-11-09 00:00:00	YM	Futures	11904.3	11915.1	11897.4	11910.2	276.0
2011-11-09 01:00:00	YM	Futures	11911.2	11922.0	11908.3	11920.1	271.0

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

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