PREVIEW / futures_1hour / 2011-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-17.parquet
  size:    52 KB
  rows:    1,515

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-03-17 00:00:00	ES	Futures	1251.1	1252.34	1249.36	1251.59	8921.0
2011-03-17 01:00:00	ES	Futures	1251.59	1255.07	1250.6	1253.83	12741.0
2011-03-17 02:00:00	ES	Futures	1253.83	1254.57	1250.6	1252.09	11786.0
2011-03-17 03:00:00	ES	Futures	1252.09	1257.56	1252.09	1257.06	44723.0
2011-03-17 04:00:00	ES	Futures	1257.06	1260.29	1254.33	1259.29	57976.0
2011-03-17 05:00:00	ES	Futures	1259.29	1262.03	1256.56	1257.31	49046.0
2011-03-17 06:00:00	ES	Futures	1257.31	1258.05	1249.85	1255.32	60049.0
2011-03-17 07:00:00	ES	Futures	1255.32	1258.8	1252.59	1257.56	66719.0
2011-03-17 08:00:00	ES	Futures	1257.56	1265.51	1255.82	1263.52	150299.0
2011-03-17 09:00:00	ES	Futures	1263.52	1265.51	1257.31	1258.3	347104.0
2011-03-17 10:00:00	ES	Futures	1258.3	1266.5	1257.56	1263.77	392322.0
2011-03-17 11:00:00	ES	Futures	1263.77	1266.25	1259.05	1259.54	264337.0
2011-03-17 12:00:00	ES	Futures	1259.54	1264.26	1259.05	1261.28	175680.0
2011-03-17 13:00:00	ES	Futures	1261.28	1264.01	1253.58	1255.82	257611.0
2011-03-17 14:00:00	ES	Futures	1255.82	1261.03	1253.83	1259.79	177908.0
2011-03-17 15:00:00	ES	Futures	1259.54	1264.51	1257.56	1260.54	308309.0
2011-03-17 16:00:00	ES	Futures	1260.29	1262.28	1258.3	1259.79	117017.0
2011-03-17 17:00:00	ES	Futures	1259.79	1261.03	1259.54	1260.78	3362.0
2011-03-17 18:00:00	ES	Futures	1261.03	1262.52	1255.57	1256.56	16500.0
2011-03-17 19:00:00	ES	Futures	1256.56	1259.54	1253.58	1259.29	17543.0
2011-03-17 20:00:00	ES	Futures	1259.05	1270.47	1258.8	1267.0	36092.0
2011-03-17 21:00:00	ES	Futures	1267.24	1270.72	1266.5	1268.49	17462.0
2011-03-17 22:00:00	ES	Futures	1268.73	1271.47	1268.24	1269.98	10299.0
2011-03-17 23:00:00	ES	Futures	1270.23	1272.71	1269.98	1272.21	8392.0
2011-03-17 00:00:00	NQ	Futures	2543.89	2550.21	2541.87	2548.19	1001.0
2011-03-17 01:00:00	NQ	Futures	2548.48	2553.94	2547.05	2550.49	1091.0
2011-03-17 02:00:00	NQ	Futures	2550.78	2553.37	2543.31	2545.9	1543.0
2011-03-17 03:00:00	NQ	Futures	2547.05	2554.52	2545.9	2552.22	4875.0
2011-03-17 04:00:00	NQ	Futures	2552.22	2561.7	2547.05	2559.97	6083.0
2011-03-17 05:00:00	NQ	Futures	2559.69	2565.72	2551.93	2553.65	3704.0
2011-03-17 06:00:00	NQ	Futures	2553.37	2554.52	2543.89	2552.79	4203.0
2011-03-17 07:00:00	NQ	Futures	2552.79	2559.11	2547.33	2557.39	4989.0
2011-03-17 08:00:00	NQ	Futures	2557.68	2572.9	2554.23	2570.32	13820.0
2011-03-17 09:00:00	NQ	Futures	2570.61	2574.92	2558.83	2562.27	53974.0
2011-03-17 10:00:00	NQ	Futures	2562.56	2578.08	2560.55	2575.78	52115.0
2011-03-17 11:00:00	NQ	Futures	2575.49	2580.95	2570.61	2570.89	39113.0
2011-03-17 12:00:00	NQ	Futures	2570.61	2576.35	2569.46	2570.32	21571.0
2011-03-17 13:00:00	NQ	Futures	2570.32	2575.2	2553.94	2558.25	32232.0
2011-03-17 14:00:00	NQ	Futures	2557.96	2565.43	2552.79	2562.56	25371.0
2011-03-17 15:00:00	NQ	Futures	2562.56	2565.43	2551.64	2553.37	45129.0
2011-03-17 16:00:00	NQ	Futures	2553.37	2559.97	2550.78	2555.09	16859.0
2011-03-17 17:00:00	NQ	Futures	2555.09	2557.1	2553.08	2554.52	288.0
2011-03-17 18:00:00	NQ	Futures	2555.67	2559.11	2549.63	2550.21	965.0
2011-03-17 19:00:00	NQ	Futures	2551.36	2555.95	2545.61	2555.95	1603.0
2011-03-17 20:00:00	NQ	Futures	2555.95	2576.93	2555.38	2569.46	4238.0
2011-03-17 21:00:00	NQ	Futures	2569.74	2575.49	2568.59	2570.89	699.0
2011-03-17 22:00:00	NQ	Futures	2570.89	2574.92	2570.32	2572.04	669.0
2011-03-17 23:00:00	NQ	Futures	2572.9	2581.81	2572.62	2580.09	1014.0
2011-03-17 00:00:00	YM	Futures	11180.7	11188.4	11167.2	11176.8	919.0
2011-03-17 01:00:00	YM	Futures	11178.8	11208.6	11173.0	11196.1	571.0

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

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