PREVIEW / futures_1hour / 2011-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-03.parquet
  size:    50 KB
  rows:    1,464

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-03 00:00:00	ES	Futures	1226.71	1226.71	1221.69	1223.2	4434.0
2011-11-03 01:00:00	ES	Futures	1223.2	1225.71	1222.45	1223.45	4367.0
2011-11-03 02:00:00	ES	Futures	1223.45	1223.7	1220.69	1220.69	5667.0
2011-11-03 03:00:00	ES	Futures	1220.69	1221.94	1217.18	1219.69	23428.0
2011-11-03 04:00:00	ES	Futures	1219.44	1229.72	1219.19	1229.47	51658.0
2011-11-03 05:00:00	ES	Futures	1229.47	1241.0	1228.97	1237.74	80229.0
2011-11-03 06:00:00	ES	Futures	1237.49	1247.27	1237.49	1242.0	88872.0
2011-11-03 07:00:00	ES	Futures	1242.0	1245.77	1237.74	1242.51	89597.0
2011-11-03 08:00:00	ES	Futures	1242.51	1258.55	1242.26	1255.55	163503.0
2011-11-03 09:00:00	ES	Futures	1255.55	1256.05	1240.0	1242.0	321851.0
2011-11-03 10:00:00	ES	Futures	1242.26	1249.78	1234.23	1245.26	543599.0
2011-11-03 11:00:00	ES	Futures	1245.26	1251.78	1243.51	1247.77	248456.0
2011-11-03 12:00:00	ES	Futures	1247.52	1254.29	1246.77	1253.54	234925.0
2011-11-03 13:00:00	ES	Futures	1253.54	1260.56	1252.03	1257.05	258328.0
2011-11-03 14:00:00	ES	Futures	1257.05	1260.31	1254.79	1256.8	154770.0
2011-11-03 15:00:00	ES	Futures	1256.8	1263.57	1256.55	1261.06	371486.0
2011-11-03 16:00:00	ES	Futures	1260.81	1261.56	1258.55	1259.06	92926.0
2011-11-03 17:00:00	ES	Futures	1259.06	1261.06	1258.81	1260.31	1990.0
2011-11-03 18:00:00	ES	Futures	1259.81	1260.81	1257.8	1259.31	2726.0
2011-11-03 19:00:00	ES	Futures	1259.31	1260.56	1258.3	1259.81	2655.0
2011-11-03 20:00:00	ES	Futures	1259.56	1260.31	1257.05	1257.05	6097.0
2011-11-03 21:00:00	ES	Futures	1257.3	1257.8	1255.8	1257.55	7587.0
2011-11-03 22:00:00	ES	Futures	1257.55	1257.8	1255.29	1255.8	4069.0
2011-11-03 23:00:00	ES	Futures	1256.05	1256.3	1254.54	1255.8	3023.0
2011-11-03 00:00:00	NQ	Futures	2654.58	2654.87	2646.22	2649.11	354.0
2011-11-03 01:00:00	NQ	Futures	2649.11	2652.57	2647.09	2648.82	447.0
2011-11-03 02:00:00	NQ	Futures	2648.82	2648.82	2638.44	2639.3	840.0
2011-11-03 03:00:00	NQ	Futures	2638.73	2640.46	2628.35	2629.79	2480.0
2011-11-03 04:00:00	NQ	Futures	2629.5	2646.8	2628.92	2646.22	5623.0
2011-11-03 05:00:00	NQ	Futures	2646.22	2672.46	2645.36	2666.12	6208.0
2011-11-03 06:00:00	NQ	Futures	2666.12	2684.28	2666.12	2674.48	7534.0
2011-11-03 07:00:00	NQ	Futures	2674.48	2680.53	2664.68	2673.61	8147.0
2011-11-03 08:00:00	NQ	Futures	2674.19	2694.66	2673.33	2691.49	16813.0
2011-11-03 09:00:00	NQ	Futures	2691.49	2694.37	2671.31	2674.48	41702.0
2011-11-03 10:00:00	NQ	Futures	2675.06	2695.82	2660.06	2686.01	68989.0
2011-11-03 11:00:00	NQ	Futures	2685.72	2705.62	2685.15	2693.51	32252.0
2011-11-03 12:00:00	NQ	Futures	2693.51	2706.48	2689.76	2704.46	22401.0
2011-11-03 13:00:00	NQ	Futures	2704.46	2719.75	2701.0	2712.83	26992.0
2011-11-03 14:00:00	NQ	Futures	2713.4	2718.59	2711.1	2716.29	21292.0
2011-11-03 15:00:00	NQ	Futures	2716.57	2729.26	2715.71	2725.51	45802.0
2011-11-03 16:00:00	NQ	Futures	2725.22	2728.97	2722.05	2722.92	7417.0
2011-11-03 17:00:00	NQ	Futures	2723.78	2725.8	2722.05	2724.65	343.0
2011-11-03 18:00:00	NQ	Futures	2724.36	2725.8	2721.19	2723.78	316.0
2011-11-03 19:00:00	NQ	Futures	2723.78	2725.8	2722.34	2724.36	159.0
2011-11-03 20:00:00	NQ	Futures	2723.78	2725.51	2720.03	2720.32	321.0
2011-11-03 21:00:00	NQ	Futures	2720.32	2721.48	2717.73	2721.19	513.0
2011-11-03 22:00:00	NQ	Futures	2721.48	2721.76	2717.15	2718.59	236.0
2011-11-03 23:00:00	NQ	Futures	2718.59	2719.46	2716.86	2718.59	250.0
2011-11-03 00:00:00	YM	Futures	11488.8	11488.8	11450.4	11463.2	422.0
2011-11-03 01:00:00	YM	Futures	11464.2	11483.9	11455.4	11465.2	400.0

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

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