PREVIEW / futures_1hour / 2011-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-26.parquet
  size:    49 KB
  rows:    1,479

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-04-26 00:00:00	ES	Futures	1320.41	1321.15	1319.66	1321.15	3006.0
2011-04-26 01:00:00	ES	Futures	1321.15	1322.15	1320.91	1321.15	2282.0
2011-04-26 02:00:00	ES	Futures	1321.15	1322.15	1320.66	1321.65	7169.0
2011-04-26 03:00:00	ES	Futures	1321.9	1325.13	1321.15	1324.63	22128.0
2011-04-26 04:00:00	ES	Futures	1324.63	1327.36	1324.38	1326.87	21867.0
2011-04-26 05:00:00	ES	Futures	1326.62	1329.1	1325.87	1327.86	22284.0
2011-04-26 06:00:00	ES	Futures	1327.86	1328.11	1326.62	1327.36	8823.0
2011-04-26 07:00:00	ES	Futures	1327.12	1328.85	1326.12	1328.36	20030.0
2011-04-26 08:00:00	ES	Futures	1328.61	1328.61	1327.36	1327.86	25613.0
2011-04-26 09:00:00	ES	Futures	1327.86	1329.6	1326.12	1328.36	171119.0
2011-04-26 10:00:00	ES	Futures	1328.61	1333.58	1326.62	1333.33	302075.0
2011-04-26 11:00:00	ES	Futures	1333.58	1336.56	1333.08	1336.31	179550.0
2011-04-26 12:00:00	ES	Futures	1336.56	1337.8	1335.07	1335.56	152750.0
2011-04-26 13:00:00	ES	Futures	1335.56	1335.81	1333.08	1334.32	92769.0
2011-04-26 14:00:00	ES	Futures	1334.07	1335.81	1333.58	1335.56	66125.0
2011-04-26 15:00:00	ES	Futures	1335.56	1337.05	1334.07	1335.07	162047.0
2011-04-26 16:00:00	ES	Futures	1335.07	1335.07	1331.84	1333.58	94612.0
2011-04-26 17:00:00	ES	Futures	1333.58	1333.82	1333.08	1333.58	2069.0
2011-04-26 18:00:00	ES	Futures	1333.33	1334.32	1333.08	1334.07	3919.0
2011-04-26 19:00:00	ES	Futures	1334.32	1334.82	1333.82	1334.82	2337.0
2011-04-26 20:00:00	ES	Futures	1334.57	1335.56	1334.32	1335.31	4620.0
2011-04-26 21:00:00	ES	Futures	1335.31	1336.06	1334.07	1334.07	5705.0
2011-04-26 22:00:00	ES	Futures	1334.32	1334.82	1333.58	1334.57	4149.0
2011-04-26 23:00:00	ES	Futures	1334.57	1334.57	1333.58	1334.07	1710.0
2011-04-26 00:00:00	NQ	Futures	2728.05	2730.64	2726.9	2730.64	290.0
2011-04-26 01:00:00	NQ	Futures	2730.64	2732.36	2729.2	2729.78	183.0
2011-04-26 02:00:00	NQ	Futures	2729.78	2734.09	2728.92	2730.07	1159.0
2011-04-26 03:00:00	NQ	Futures	2730.07	2736.67	2729.2	2736.1	1684.0
2011-04-26 04:00:00	NQ	Futures	2736.1	2740.98	2735.52	2740.41	2912.0
2011-04-26 05:00:00	NQ	Futures	2740.7	2745.01	2738.97	2742.13	1775.0
2011-04-26 06:00:00	NQ	Futures	2742.42	2742.42	2740.12	2741.56	718.0
2011-04-26 07:00:00	NQ	Futures	2741.85	2743.86	2739.55	2743.28	2208.0
2011-04-26 08:00:00	NQ	Futures	2742.99	2742.99	2740.98	2741.85	1922.0
2011-04-26 09:00:00	NQ	Futures	2741.85	2746.44	2736.1	2744.43	37693.0
2011-04-26 10:00:00	NQ	Futures	2744.43	2754.49	2738.68	2754.2	53289.0
2011-04-26 11:00:00	NQ	Futures	2754.2	2756.79	2751.33	2756.5	19804.0
2011-04-26 12:00:00	NQ	Futures	2756.5	2760.52	2751.61	2752.19	22199.0
2011-04-26 13:00:00	NQ	Futures	2752.19	2752.19	2743.28	2747.59	21412.0
2011-04-26 14:00:00	NQ	Futures	2747.59	2753.91	2745.29	2751.9	13628.0
2011-04-26 15:00:00	NQ	Futures	2751.61	2755.92	2745.29	2750.75	24878.0
2011-04-26 16:00:00	NQ	Futures	2750.75	2753.62	2738.11	2748.17	19041.0
2011-04-26 17:00:00	NQ	Futures	2748.17	2749.89	2747.59	2749.03	91.0
2011-04-26 18:00:00	NQ	Futures	2747.59	2749.89	2746.44	2749.6	529.0
2011-04-26 19:00:00	NQ	Futures	2749.89	2750.46	2749.32	2750.18	162.0
2011-04-26 20:00:00	NQ	Futures	2749.89	2752.19	2749.89	2751.9	428.0
2011-04-26 21:00:00	NQ	Futures	2751.61	2753.62	2749.03	2749.6	468.0
2011-04-26 22:00:00	NQ	Futures	2749.6	2750.46	2747.59	2749.89	300.0
2011-04-26 23:00:00	NQ	Futures	2749.89	2750.18	2747.88	2748.74	99.0
2011-04-26 00:00:00	YM	Futures	11945.5	11950.3	11940.6	11950.3	155.0
2011-04-26 01:00:00	YM	Futures	11951.2	11955.1	11949.3	11952.2	164.0

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

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