PREVIEW / futures_1hour / 2011-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-03.parquet
  size:    49 KB
  rows:    1,459

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-03 00:00:00	ES	Futures	1297.01	1300.72	1296.77	1299.98	18801.0
2011-03-03 01:00:00	ES	Futures	1300.23	1302.7	1298.99	1299.24	24373.0
2011-03-03 02:00:00	ES	Futures	1299.49	1300.72	1298.74	1299.73	11070.0
2011-03-03 03:00:00	ES	Futures	1299.98	1300.23	1296.52	1297.01	24891.0
2011-03-03 04:00:00	ES	Futures	1297.01	1299.49	1296.77	1298.5	20238.0
2011-03-03 05:00:00	ES	Futures	1298.5	1302.21	1298.5	1301.47	20209.0
2011-03-03 06:00:00	ES	Futures	1301.47	1305.43	1300.97	1304.93	43549.0
2011-03-03 07:00:00	ES	Futures	1305.18	1305.43	1303.2	1304.19	29143.0
2011-03-03 08:00:00	ES	Futures	1304.19	1307.4	1302.46	1304.44	118580.0
2011-03-03 09:00:00	ES	Futures	1304.19	1311.86	1303.45	1310.37	402242.0
2011-03-03 10:00:00	ES	Futures	1310.13	1312.85	1307.16	1310.87	466055.0
2011-03-03 11:00:00	ES	Futures	1311.12	1314.33	1310.62	1313.84	299297.0
2011-03-03 12:00:00	ES	Futures	1313.84	1315.32	1312.35	1314.33	134264.0
2011-03-03 13:00:00	ES	Futures	1314.58	1315.32	1313.34	1314.09	93038.0
2011-03-03 14:00:00	ES	Futures	1314.09	1318.04	1313.84	1317.8	228413.0
2011-03-03 15:00:00	ES	Futures	1317.55	1318.29	1315.32	1316.56	248518.0
2011-03-03 16:00:00	ES	Futures	1316.31	1316.81	1315.57	1315.82	126959.0
2011-03-03 17:00:00	ES	Futures	1315.82	1316.56	1315.57	1316.06	3059.0
2011-03-03 18:00:00	ES	Futures	1316.06	1319.28	1316.06	1318.04	11252.0
2011-03-03 19:00:00	ES	Futures	1318.04	1318.29	1316.31	1316.81	5489.0
2011-03-03 20:00:00	ES	Futures	1316.81	1317.55	1315.82	1317.3	4765.0
2011-03-03 21:00:00	ES	Futures	1317.3	1318.04	1316.81	1317.3	2468.0
2011-03-03 22:00:00	ES	Futures	1317.05	1317.8	1316.56	1316.56	2679.0
2011-03-03 23:00:00	ES	Futures	1316.81	1317.3	1315.82	1316.81	3232.0
2011-03-03 00:00:00	NQ	Futures	2674.86	2680.6	2674.57	2680.02	1154.0
2011-03-03 01:00:00	NQ	Futures	2680.02	2686.34	2678.01	2678.01	1681.0
2011-03-03 02:00:00	NQ	Futures	2678.01	2681.17	2676.86	2680.02	537.0
2011-03-03 03:00:00	NQ	Futures	2680.02	2680.31	2672.56	2673.99	1783.0
2011-03-03 04:00:00	NQ	Futures	2673.71	2679.73	2673.42	2676.86	1535.0
2011-03-03 05:00:00	NQ	Futures	2676.58	2685.19	2676.58	2682.61	1716.0
2011-03-03 06:00:00	NQ	Futures	2682.61	2692.36	2681.46	2690.93	2639.0
2011-03-03 07:00:00	NQ	Futures	2691.22	2691.22	2686.62	2690.07	4414.0
2011-03-03 08:00:00	NQ	Futures	2690.07	2697.24	2686.91	2692.36	8726.0
2011-03-03 09:00:00	NQ	Futures	2691.79	2713.03	2690.64	2711.6	58872.0
2011-03-03 10:00:00	NQ	Futures	2711.31	2720.21	2707.0	2717.62	67784.0
2011-03-03 11:00:00	NQ	Futures	2717.62	2723.36	2716.19	2722.79	35536.0
2011-03-03 12:00:00	NQ	Futures	2723.08	2725.37	2720.78	2722.79	18245.0
2011-03-03 13:00:00	NQ	Futures	2722.79	2725.09	2720.49	2721.64	15565.0
2011-03-03 14:00:00	NQ	Futures	2721.64	2727.67	2721.35	2726.81	22589.0
2011-03-03 15:00:00	NQ	Futures	2726.81	2727.96	2721.64	2723.36	34213.0
2011-03-03 16:00:00	NQ	Futures	2723.08	2725.37	2722.22	2723.65	9740.0
2011-03-03 17:00:00	NQ	Futures	2724.22	2724.8	2723.08	2724.51	103.0
2011-03-03 18:00:00	NQ	Futures	2723.94	2731.11	2723.65	2727.96	673.0
2011-03-03 19:00:00	NQ	Futures	2728.53	2729.1	2725.09	2726.23	337.0
2011-03-03 20:00:00	NQ	Futures	2726.23	2726.81	2721.93	2726.23	430.0
2011-03-03 21:00:00	NQ	Futures	2726.23	2728.53	2726.23	2727.1	168.0
2011-03-03 22:00:00	NQ	Futures	2726.81	2728.24	2725.66	2726.52	253.0
2011-03-03 23:00:00	NQ	Futures	2726.52	2726.52	2723.36	2724.8	141.0
2011-03-03 00:00:00	YM	Futures	11575.8	11600.7	11574.8	11596.8	584.0
2011-03-03 01:00:00	YM	Futures	11596.8	11617.9	11589.2	11589.2	777.0

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

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