PREVIEW / futures_1hour / 2011-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-05.parquet
  size:    46 KB
  rows:    1,400

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-12-05 00:00:00	ES	Futures	1256.8	1258.3	1256.3	1258.05	4438.0
2011-12-05 01:00:00	ES	Futures	1258.05	1258.55	1255.55	1256.8	5320.0
2011-12-05 02:00:00	ES	Futures	1256.55	1261.31	1256.55	1260.81	12341.0
2011-12-05 03:00:00	ES	Futures	1261.06	1261.31	1255.29	1257.55	39411.0
2011-12-05 04:00:00	ES	Futures	1257.55	1262.57	1256.3	1261.81	20063.0
2011-12-05 05:00:00	ES	Futures	1261.81	1262.32	1259.81	1260.31	16178.0
2011-12-05 06:00:00	ES	Futures	1260.31	1260.81	1257.8	1259.31	16726.0
2011-12-05 07:00:00	ES	Futures	1259.31	1264.32	1258.81	1262.57	34416.0
2011-12-05 08:00:00	ES	Futures	1262.57	1265.83	1261.31	1265.07	57140.0
2011-12-05 09:00:00	ES	Futures	1265.07	1267.08	1262.32	1266.83	248680.0
2011-12-05 10:00:00	ES	Futures	1266.58	1269.84	1263.32	1267.08	373916.0
2011-12-05 11:00:00	ES	Futures	1267.08	1268.33	1265.33	1266.33	231661.0
2011-12-05 12:00:00	ES	Futures	1266.33	1270.09	1265.58	1268.58	130599.0
2011-12-05 13:00:00	ES	Futures	1268.84	1269.34	1259.81	1261.31	248802.0
2011-12-05 14:00:00	ES	Futures	1261.31	1261.56	1256.55	1261.06	259617.0
2011-12-05 15:00:00	ES	Futures	1260.81	1262.32	1252.54	1260.31	464276.0
2011-12-05 16:00:00	ES	Futures	1260.31	1262.32	1256.05	1256.3	102852.0
2011-12-05 17:00:00	ES	Futures	1256.55	1258.05	1256.05	1258.05	2187.0
2011-12-05 18:00:00	ES	Futures	1257.05	1257.3	1255.04	1256.3	7365.0
2011-12-05 19:00:00	ES	Futures	1256.3	1257.3	1255.55	1256.55	6143.0
2011-12-05 20:00:00	ES	Futures	1256.55	1257.05	1254.29	1254.79	6931.0
2011-12-05 21:00:00	ES	Futures	1255.04	1256.3	1255.04	1255.29	5743.0
2011-12-05 22:00:00	ES	Futures	1255.29	1255.55	1253.04	1253.79	7931.0
2011-12-05 23:00:00	ES	Futures	1253.79	1254.29	1250.28	1251.03	10711.0
2011-12-05 00:00:00	NQ	Futures	2672.17	2673.33	2671.31	2673.33	275.0
2011-12-05 01:00:00	NQ	Futures	2673.33	2673.33	2669.87	2671.31	218.0
2011-12-05 02:00:00	NQ	Futures	2671.02	2679.67	2670.15	2679.67	594.0
2011-12-05 03:00:00	NQ	Futures	2679.67	2680.25	2670.44	2676.79	2890.0
2011-12-05 04:00:00	NQ	Futures	2677.07	2685.44	2674.77	2684.28	1409.0
2011-12-05 05:00:00	NQ	Futures	2683.99	2684.86	2679.96	2680.82	1361.0
2011-12-05 06:00:00	NQ	Futures	2681.11	2681.4	2675.63	2679.09	1193.0
2011-12-05 07:00:00	NQ	Futures	2679.09	2693.22	2677.94	2688.61	4334.0
2011-12-05 08:00:00	NQ	Futures	2688.9	2694.95	2686.88	2692.93	3900.0
2011-12-05 09:00:00	NQ	Futures	2693.22	2697.55	2677.07	2686.88	35153.0
2011-12-05 10:00:00	NQ	Futures	2686.3	2703.02	2681.69	2697.26	39141.0
2011-12-05 11:00:00	NQ	Futures	2697.55	2699.56	2692.36	2696.39	24444.0
2011-12-05 12:00:00	NQ	Futures	2696.1	2702.45	2694.95	2700.43	10590.0
2011-12-05 13:00:00	NQ	Futures	2700.14	2701.58	2684.57	2687.17	23108.0
2011-12-05 14:00:00	NQ	Futures	2686.88	2687.45	2677.65	2686.01	27587.0
2011-12-05 15:00:00	NQ	Futures	2685.72	2688.61	2669.87	2683.99	41341.0
2011-12-05 16:00:00	NQ	Futures	2683.99	2690.63	2675.63	2679.09	7462.0
2011-12-05 17:00:00	NQ	Futures	2678.8	2681.98	2677.65	2681.98	194.0
2011-12-05 18:00:00	NQ	Futures	2680.53	2681.11	2677.36	2679.09	649.0
2011-12-05 19:00:00	NQ	Futures	2679.09	2681.4	2678.52	2679.67	373.0
2011-12-05 20:00:00	NQ	Futures	2679.67	2680.25	2676.21	2677.07	379.0
2011-12-05 21:00:00	NQ	Futures	2677.36	2679.67	2677.36	2678.52	251.0
2011-12-05 22:00:00	NQ	Futures	2677.94	2677.94	2673.33	2674.19	449.0
2011-12-05 23:00:00	NQ	Futures	2674.48	2675.63	2670.15	2670.73	631.0
2011-12-05 00:00:00	YM	Futures	11897.4	11908.3	11890.5	11905.3	233.0
2011-12-05 01:00:00	YM	Futures	11908.3	11910.2	11888.6	11897.4	770.0

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

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