PREVIEW / futures_1hour / 2011-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-15.parquet
  size:    49 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-15 00:00:00	ES	Futures	1252.03	1254.79	1252.03	1253.54	5428.0
2011-11-15 01:00:00	ES	Futures	1253.79	1254.54	1251.78	1253.29	3331.0
2011-11-15 02:00:00	ES	Futures	1253.29	1254.79	1251.03	1253.54	11736.0
2011-11-15 03:00:00	ES	Futures	1253.29	1258.55	1250.28	1250.78	61409.0
2011-11-15 04:00:00	ES	Futures	1250.78	1251.03	1245.77	1248.52	57192.0
2011-11-15 05:00:00	ES	Futures	1248.78	1251.03	1244.26	1244.51	39937.0
2011-11-15 06:00:00	ES	Futures	1244.51	1245.77	1237.74	1240.0	70400.0
2011-11-15 07:00:00	ES	Futures	1240.0	1245.01	1239.75	1242.0	43118.0
2011-11-15 08:00:00	ES	Futures	1242.0	1249.78	1242.0	1246.77	134647.0
2011-11-15 09:00:00	ES	Futures	1246.77	1257.05	1246.52	1254.54	273630.0
2011-11-15 10:00:00	ES	Futures	1254.79	1255.55	1249.28	1250.03	291897.0
2011-11-15 11:00:00	ES	Futures	1250.03	1252.54	1245.52	1249.53	271661.0
2011-11-15 12:00:00	ES	Futures	1249.53	1259.56	1249.28	1259.31	211700.0
2011-11-15 13:00:00	ES	Futures	1259.06	1263.32	1258.05	1261.81	179216.0
2011-11-15 14:00:00	ES	Futures	1261.81	1264.07	1259.81	1262.57	143528.0
2011-11-15 15:00:00	ES	Futures	1262.32	1266.08	1258.81	1259.56	322184.0
2011-11-15 16:00:00	ES	Futures	1259.56	1260.56	1257.05	1258.55	91001.0
2011-11-15 17:00:00	ES	Futures	1258.55	1259.06	1257.8	1257.8	1536.0
2011-11-15 18:00:00	ES	Futures	1258.3	1259.31	1256.3	1256.55	7887.0
2011-11-15 19:00:00	ES	Futures	1256.55	1257.55	1255.29	1256.05	7716.0
2011-11-15 20:00:00	ES	Futures	1256.05	1258.05	1253.29	1253.54	7830.0
2011-11-15 21:00:00	ES	Futures	1253.79	1253.79	1246.02	1247.27	20340.0
2011-11-15 22:00:00	ES	Futures	1247.27	1248.52	1245.52	1247.77	10499.0
2011-11-15 23:00:00	ES	Futures	1247.52	1248.52	1246.52	1247.52	3671.0
2011-11-15 00:00:00	NQ	Futures	2693.8	2697.26	2693.51	2695.53	228.0
2011-11-15 01:00:00	NQ	Futures	2696.39	2696.97	2692.36	2695.24	189.0
2011-11-15 02:00:00	NQ	Futures	2694.66	2697.55	2690.91	2694.09	804.0
2011-11-15 03:00:00	NQ	Futures	2694.09	2704.18	2688.32	2689.76	3513.0
2011-11-15 04:00:00	NQ	Futures	2689.76	2690.05	2680.53	2686.59	2983.0
2011-11-15 05:00:00	NQ	Futures	2686.59	2692.36	2676.5	2676.5	3764.0
2011-11-15 06:00:00	NQ	Futures	2676.5	2678.23	2664.1	2669.0	3175.0
2011-11-15 07:00:00	NQ	Futures	2669.29	2679.96	2669.0	2674.77	2794.0
2011-11-15 08:00:00	NQ	Futures	2675.06	2691.78	2675.06	2687.45	6941.0
2011-11-15 09:00:00	NQ	Futures	2686.88	2709.37	2686.01	2705.62	32587.0
2011-11-15 10:00:00	NQ	Futures	2705.33	2706.77	2689.47	2694.66	36877.0
2011-11-15 11:00:00	NQ	Futures	2694.37	2703.02	2687.74	2698.12	31144.0
2011-11-15 12:00:00	NQ	Futures	2698.12	2724.94	2698.12	2722.92	42045.0
2011-11-15 13:00:00	NQ	Futures	2722.63	2731.86	2718.59	2726.95	25228.0
2011-11-15 14:00:00	NQ	Futures	2726.95	2734.45	2725.22	2731.86	18801.0
2011-11-15 15:00:00	NQ	Futures	2731.86	2738.2	2725.8	2726.67	35475.0
2011-11-15 16:00:00	NQ	Futures	2726.38	2727.24	2720.9	2725.22	8266.0
2011-11-15 17:00:00	NQ	Futures	2724.36	2725.8	2724.36	2724.94	84.0
2011-11-15 18:00:00	NQ	Futures	2725.8	2726.95	2721.76	2722.05	292.0
2011-11-15 19:00:00	NQ	Futures	2722.34	2724.07	2719.75	2722.92	512.0
2011-11-15 20:00:00	NQ	Futures	2723.21	2726.09	2717.44	2717.73	678.0
2011-11-15 21:00:00	NQ	Futures	2717.44	2717.44	2705.33	2708.21	1939.0
2011-11-15 22:00:00	NQ	Futures	2708.21	2709.94	2702.73	2707.64	1085.0
2011-11-15 23:00:00	NQ	Futures	2707.06	2709.08	2704.46	2706.77	261.0
2011-11-15 00:00:00	YM	Futures	11848.2	11866.9	11847.2	11860.0	292.0
2011-11-15 01:00:00	YM	Futures	11864.0	11864.9	11841.3	11852.1	418.0

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

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