PREVIEW / futures_1hour / 2011-07-05

all futures 1-hour files

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

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-07-05 00:00:00	ES	Futures	1330.83	1331.33	1329.08	1329.58	1903.0
2011-07-05 01:00:00	ES	Futures	1329.58	1330.33	1328.83	1329.08	3334.0
2011-07-05 02:00:00	ES	Futures	1328.83	1329.33	1327.84	1329.33	9542.0
2011-07-05 03:00:00	ES	Futures	1329.08	1332.32	1328.08	1330.08	24298.0
2011-07-05 04:00:00	ES	Futures	1330.08	1332.32	1329.58	1330.33	13493.0
2011-07-05 05:00:00	ES	Futures	1330.33	1333.57	1329.83	1333.32	19157.0
2011-07-05 06:00:00	ES	Futures	1333.32	1334.57	1332.32	1333.07	26987.0
2011-07-05 07:00:00	ES	Futures	1333.07	1333.32	1329.33	1329.58	28859.0
2011-07-05 08:00:00	ES	Futures	1329.58	1330.08	1327.84	1330.08	41255.0
2011-07-05 09:00:00	ES	Futures	1330.08	1330.58	1327.09	1329.33	196365.0
2011-07-05 10:00:00	ES	Futures	1329.33	1332.07	1326.84	1327.59	295693.0
2011-07-05 11:00:00	ES	Futures	1327.59	1330.33	1326.09	1330.08	163342.0
2011-07-05 12:00:00	ES	Futures	1330.08	1331.58	1329.58	1330.83	75645.0
2011-07-05 13:00:00	ES	Futures	1330.83	1333.07	1330.58	1332.57	85820.0
2011-07-05 14:00:00	ES	Futures	1332.82	1333.07	1326.09	1329.33	227845.0
2011-07-05 15:00:00	ES	Futures	1329.58	1332.82	1328.33	1330.08	230145.0
2011-07-05 16:00:00	ES	Futures	1330.08	1333.82	1328.83	1332.32	128629.0
2011-07-05 17:00:00	ES	Futures	1332.32	1332.82	1332.07	1332.07	1351.0
2011-07-05 18:00:00	ES	Futures	1332.32	1332.57	1332.07	1332.32	665.0
2011-07-05 19:00:00	ES	Futures	1332.07	1332.57	1332.07	1332.32	1366.0
2011-07-05 20:00:00	ES	Futures	1332.07	1332.82	1331.33	1332.57	8614.0
2011-07-05 21:00:00	ES	Futures	1332.82	1334.07	1332.32	1332.82	7365.0
2011-07-05 22:00:00	ES	Futures	1333.07	1334.32	1332.82	1333.82	4457.0
2011-07-05 23:00:00	ES	Futures	1333.57	1337.56	1333.57	1336.81	13394.0
2011-07-05 00:00:00	NQ	Futures	2719.96	2719.96	2716.5	2717.66	174.0
2011-07-05 01:00:00	NQ	Futures	2716.5	2719.09	2715.93	2716.5	324.0
2011-07-05 02:00:00	NQ	Futures	2716.79	2717.94	2715.07	2717.37	837.0
2011-07-05 03:00:00	NQ	Futures	2717.66	2721.97	2714.49	2718.52	2599.0
2011-07-05 04:00:00	NQ	Futures	2718.52	2721.68	2716.79	2717.37	2024.0
2011-07-05 05:00:00	NQ	Futures	2717.37	2723.12	2716.22	2722.55	2037.0
2011-07-05 06:00:00	NQ	Futures	2722.55	2725.14	2720.82	2721.97	2057.0
2011-07-05 07:00:00	NQ	Futures	2722.26	2722.26	2715.35	2715.64	1972.0
2011-07-05 08:00:00	NQ	Futures	2715.64	2716.5	2713.05	2715.64	4802.0
2011-07-05 09:00:00	NQ	Futures	2715.93	2717.08	2712.76	2715.64	41143.0
2011-07-05 10:00:00	NQ	Futures	2715.93	2721.11	2709.6	2714.2	51585.0
2011-07-05 11:00:00	NQ	Futures	2714.2	2724.85	2712.19	2721.68	19952.0
2011-07-05 12:00:00	NQ	Futures	2721.68	2724.27	2719.96	2723.7	11161.0
2011-07-05 13:00:00	NQ	Futures	2723.99	2727.73	2723.41	2727.44	21734.0
2011-07-05 14:00:00	NQ	Futures	2727.15	2728.88	2715.64	2721.97	29047.0
2011-07-05 15:00:00	NQ	Futures	2721.97	2728.88	2719.09	2726.0	25718.0
2011-07-05 16:00:00	NQ	Futures	2725.71	2730.32	2720.82	2727.15	11150.0
2011-07-05 17:00:00	NQ	Futures	2728.3	2728.88	2726.86	2727.44	65.0
2011-07-05 18:00:00	NQ	Futures	2728.3	2729.17	2727.73	2728.3	375.0
2011-07-05 19:00:00	NQ	Futures	2728.01	2729.17	2727.44	2727.73	317.0
2011-07-05 20:00:00	NQ	Futures	2727.15	2729.17	2726.58	2728.01	500.0
2011-07-05 21:00:00	NQ	Futures	2729.17	2732.33	2728.59	2730.03	772.0
2011-07-05 22:00:00	NQ	Futures	2729.45	2732.62	2729.45	2732.04	232.0
2011-07-05 23:00:00	NQ	Futures	2731.47	2738.66	2731.47	2737.22	973.0
2011-07-05 00:00:00	YM	Futures	12140.8	12140.8	12125.3	12129.2	106.0
2011-07-05 01:00:00	YM	Futures	12128.2	12134.0	12123.4	12124.4	185.0

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

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