PREVIEW / futures_1hour / 2012-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-15.parquet
  size:    48 KB
  rows:    1,513

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
2012-11-15 00:00:00	ES	Futures	1384.61	1385.64	1384.36	1384.87	4689.0
2012-11-15 01:00:00	ES	Futures	1384.61	1384.87	1382.83	1384.61	5463.0
2012-11-15 02:00:00	ES	Futures	1384.61	1386.91	1384.1	1384.36	14335.0
2012-11-15 03:00:00	ES	Futures	1384.61	1387.93	1384.1	1386.66	31726.0
2012-11-15 04:00:00	ES	Futures	1386.91	1387.17	1385.12	1386.66	22751.0
2012-11-15 05:00:00	ES	Futures	1386.66	1388.7	1385.38	1388.19	23406.0
2012-11-15 06:00:00	ES	Futures	1387.93	1388.19	1385.89	1386.15	17051.0
2012-11-15 07:00:00	ES	Futures	1385.89	1386.15	1381.8	1384.1	49281.0
2012-11-15 08:00:00	ES	Futures	1383.85	1385.64	1378.99	1381.29	100886.0
2012-11-15 09:00:00	ES	Futures	1381.29	1388.19	1380.01	1381.04	321175.0
2012-11-15 10:00:00	ES	Futures	1381.04	1387.42	1377.97	1380.01	384865.0
2012-11-15 11:00:00	ES	Futures	1380.01	1381.55	1374.65	1376.18	393403.0
2012-11-15 12:00:00	ES	Futures	1376.18	1379.25	1374.65	1376.95	164219.0
2012-11-15 13:00:00	ES	Futures	1376.95	1386.15	1375.67	1383.59	199522.0
2012-11-15 14:00:00	ES	Futures	1383.34	1383.59	1378.74	1380.01	147556.0
2012-11-15 15:00:00	ES	Futures	1380.01	1382.83	1374.91	1379.76	365982.0
2012-11-15 16:00:00	ES	Futures	1380.01	1381.8	1378.99	1381.55	106215.0
2012-11-15 17:00:00	ES	Futures	1381.55	1381.8	1380.01	1380.27	2664.0
2012-11-15 18:00:00	ES	Futures	1380.01	1381.29	1379.25	1379.76	3781.0
2012-11-15 19:00:00	ES	Futures	1379.76	1379.76	1376.95	1377.72	11617.0
2012-11-15 20:00:00	ES	Futures	1377.72	1378.99	1377.2	1378.48	5247.0
2012-11-15 21:00:00	ES	Futures	1378.23	1379.25	1377.2	1378.48	3463.0
2012-11-15 22:00:00	ES	Futures	1378.48	1379.25	1377.46	1378.99	4686.0
2012-11-15 23:00:00	ES	Futures	1379.25	1379.76	1378.74	1378.99	3655.0
2012-11-15 00:00:00	NQ	Futures	2944.41	2945.57	2943.54	2944.12	365.0
2012-11-15 01:00:00	NQ	Futures	2943.54	2944.12	2938.89	2942.96	515.0
2012-11-15 02:00:00	NQ	Futures	2942.67	2947.9	2941.8	2942.38	1201.0
2012-11-15 03:00:00	NQ	Futures	2942.96	2949.93	2942.67	2947.9	1828.0
2012-11-15 04:00:00	NQ	Futures	2947.9	2948.77	2943.83	2948.19	1569.0
2012-11-15 05:00:00	NQ	Futures	2948.19	2951.67	2944.7	2951.38	2156.0
2012-11-15 06:00:00	NQ	Futures	2951.38	2951.38	2945.57	2946.15	1464.0
2012-11-15 07:00:00	NQ	Futures	2946.15	2946.44	2938.6	2944.99	3944.0
2012-11-15 08:00:00	NQ	Futures	2944.7	2947.9	2938.31	2944.12	8266.0
2012-11-15 09:00:00	NQ	Futures	2943.83	2953.42	2935.11	2936.86	52510.0
2012-11-15 10:00:00	NQ	Futures	2936.56	2952.55	2930.75	2931.92	61702.0
2012-11-15 11:00:00	NQ	Futures	2932.21	2935.4	2923.2	2926.39	48552.0
2012-11-15 12:00:00	NQ	Futures	2926.39	2935.98	2924.07	2929.88	26234.0
2012-11-15 13:00:00	NQ	Futures	2929.59	2945.28	2926.39	2940.05	33819.0
2012-11-15 14:00:00	NQ	Futures	2940.05	2940.92	2931.92	2933.95	26733.0
2012-11-15 15:00:00	NQ	Futures	2933.95	2938.31	2920.58	2930.17	53457.0
2012-11-15 16:00:00	NQ	Futures	2930.46	2934.82	2928.43	2934.24	7999.0
2012-11-15 17:00:00	NQ	Futures	2934.53	2934.53	2931.04	2931.04	206.0
2012-11-15 18:00:00	NQ	Futures	2931.04	2934.24	2930.46	2931.63	551.0
2012-11-15 19:00:00	NQ	Futures	2931.63	2931.92	2925.52	2928.14	1334.0
2012-11-15 20:00:00	NQ	Futures	2928.72	2931.33	2927.56	2929.59	681.0
2012-11-15 21:00:00	NQ	Futures	2929.88	2932.5	2928.14	2930.46	775.0
2012-11-15 22:00:00	NQ	Futures	2930.75	2931.92	2928.72	2931.33	452.0
2012-11-15 23:00:00	NQ	Futures	2931.33	2932.21	2929.88	2930.46	180.0
2012-11-15 00:00:00	YM	Futures	12558.5	12565.5	12557.5	12560.5	376.0
2012-11-15 01:00:00	YM	Futures	12558.5	12562.5	12543.5	12559.5	688.0

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

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