PREVIEW / futures_1hour / 2011-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-27.parquet
  size:    50 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-27 00:00:00	ES	Futures	1334.32	1335.31	1333.58	1335.31	2311.0
2011-04-27 01:00:00	ES	Futures	1335.31	1335.31	1333.33	1333.33	3164.0
2011-04-27 02:00:00	ES	Futures	1333.33	1334.82	1333.33	1334.57	8668.0
2011-04-27 03:00:00	ES	Futures	1334.57	1334.82	1332.33	1333.08	20848.0
2011-04-27 04:00:00	ES	Futures	1332.83	1335.07	1332.58	1335.07	13185.0
2011-04-27 05:00:00	ES	Futures	1335.07	1337.55	1334.82	1337.05	19156.0
2011-04-27 06:00:00	ES	Futures	1337.05	1337.55	1336.06	1337.3	9490.0
2011-04-27 07:00:00	ES	Futures	1337.3	1337.8	1336.06	1336.31	15237.0
2011-04-27 08:00:00	ES	Futures	1336.56	1337.55	1335.81	1337.55	23088.0
2011-04-27 09:00:00	ES	Futures	1337.55	1338.3	1335.07	1336.31	159159.0
2011-04-27 10:00:00	ES	Futures	1336.06	1336.31	1331.84	1332.33	212215.0
2011-04-27 11:00:00	ES	Futures	1332.58	1335.07	1332.33	1334.32	106597.0
2011-04-27 12:00:00	ES	Futures	1334.32	1337.55	1333.08	1336.8	143535.0
2011-04-27 13:00:00	ES	Futures	1336.8	1338.79	1335.81	1338.3	102399.0
2011-04-27 14:00:00	ES	Futures	1338.05	1340.03	1335.81	1339.79	167785.0
2011-04-27 15:00:00	ES	Futures	1339.79	1345.75	1339.54	1343.26	274972.0
2011-04-27 16:00:00	ES	Futures	1343.02	1343.76	1342.02	1343.26	72797.0
2011-04-27 17:00:00	ES	Futures	1343.51	1343.51	1342.77	1343.02	3198.0
2011-04-27 18:00:00	ES	Futures	1343.02	1343.51	1342.77	1343.26	1591.0
2011-04-27 19:00:00	ES	Futures	1343.02	1343.26	1342.52	1342.77	1722.0
2011-04-27 20:00:00	ES	Futures	1342.52	1347.24	1342.27	1345.5	14973.0
2011-04-27 21:00:00	ES	Futures	1345.5	1346.49	1344.75	1346.25	5241.0
2011-04-27 22:00:00	ES	Futures	1346.0	1347.74	1346.0	1347.24	6747.0
2011-04-27 23:00:00	ES	Futures	1347.24	1347.49	1346.25	1346.74	2556.0
2011-04-27 00:00:00	NQ	Futures	2749.03	2751.33	2747.59	2751.33	131.0
2011-04-27 01:00:00	NQ	Futures	2750.75	2750.75	2747.3	2747.59	208.0
2011-04-27 02:00:00	NQ	Futures	2747.59	2749.89	2747.02	2749.6	272.0
2011-04-27 03:00:00	NQ	Futures	2749.32	2749.89	2745.87	2747.3	882.0
2011-04-27 04:00:00	NQ	Futures	2747.3	2752.76	2746.73	2752.76	1509.0
2011-04-27 05:00:00	NQ	Futures	2752.76	2757.65	2752.48	2757.36	2116.0
2011-04-27 06:00:00	NQ	Futures	2757.07	2759.08	2755.35	2758.51	1578.0
2011-04-27 07:00:00	NQ	Futures	2758.51	2759.66	2755.64	2756.21	3446.0
2011-04-27 08:00:00	NQ	Futures	2756.5	2757.93	2754.2	2757.93	4680.0
2011-04-27 09:00:00	NQ	Futures	2757.93	2760.52	2752.48	2755.92	36447.0
2011-04-27 10:00:00	NQ	Futures	2755.64	2755.92	2743.57	2745.29	31361.0
2011-04-27 11:00:00	NQ	Futures	2745.29	2752.48	2745.29	2750.46	13550.0
2011-04-27 12:00:00	NQ	Futures	2750.75	2757.07	2746.73	2756.21	27007.0
2011-04-27 13:00:00	NQ	Futures	2756.5	2759.66	2754.2	2757.93	16243.0
2011-04-27 14:00:00	NQ	Futures	2757.93	2763.68	2753.91	2763.11	25294.0
2011-04-27 15:00:00	NQ	Futures	2763.11	2772.88	2762.53	2769.71	36720.0
2011-04-27 16:00:00	NQ	Futures	2769.71	2771.44	2766.27	2767.7	8986.0
2011-04-27 17:00:00	NQ	Futures	2767.7	2768.57	2767.13	2767.42	288.0
2011-04-27 18:00:00	NQ	Futures	2767.13	2768.57	2767.13	2767.7	132.0
2011-04-27 19:00:00	NQ	Futures	2767.7	2768.57	2766.55	2767.42	143.0
2011-04-27 20:00:00	NQ	Futures	2767.13	2776.32	2766.84	2773.74	1139.0
2011-04-27 21:00:00	NQ	Futures	2773.74	2774.89	2772.59	2773.45	612.0
2011-04-27 22:00:00	NQ	Futures	2773.16	2776.32	2772.88	2774.31	824.0
2011-04-27 23:00:00	NQ	Futures	2774.31	2774.6	2772.88	2772.88	274.0
2011-04-27 00:00:00	YM	Futures	12075.5	12083.2	12071.6	12082.2	146.0
2011-04-27 01:00:00	YM	Futures	12081.3	12081.3	12070.7	12071.6	187.0

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

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