PREVIEW / futures_1hour / 2011-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-09.parquet
  size:    48 KB
  rows:    1,445

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-05-09 00:00:00	ES	Futures	1333.08	1333.82	1332.83	1333.08	3930.0
2011-05-09 01:00:00	ES	Futures	1332.83	1333.33	1331.34	1332.08	5497.0
2011-05-09 02:00:00	ES	Futures	1332.08	1333.82	1331.09	1332.08	10061.0
2011-05-09 03:00:00	ES	Futures	1332.08	1336.06	1330.84	1336.06	31310.0
2011-05-09 04:00:00	ES	Futures	1336.06	1336.56	1330.84	1332.08	25910.0
2011-05-09 05:00:00	ES	Futures	1332.33	1333.08	1329.6	1331.34	18124.0
2011-05-09 06:00:00	ES	Futures	1331.34	1333.08	1330.1	1331.84	12676.0
2011-05-09 07:00:00	ES	Futures	1331.84	1333.33	1330.1	1330.59	27276.0
2011-05-09 08:00:00	ES	Futures	1330.35	1331.34	1326.12	1327.36	76977.0
2011-05-09 09:00:00	ES	Futures	1327.36	1331.34	1326.87	1328.11	256867.0
2011-05-09 10:00:00	ES	Futures	1328.11	1331.59	1326.37	1329.35	323024.0
2011-05-09 11:00:00	ES	Futures	1329.6	1332.83	1328.36	1332.08	191734.0
2011-05-09 12:00:00	ES	Futures	1332.33	1337.8	1331.84	1334.57	250765.0
2011-05-09 13:00:00	ES	Futures	1334.57	1336.56	1334.07	1336.06	74595.0
2011-05-09 14:00:00	ES	Futures	1336.06	1337.8	1334.57	1335.07	83265.0
2011-05-09 15:00:00	ES	Futures	1334.82	1336.56	1333.82	1333.82	151030.0
2011-05-09 16:00:00	ES	Futures	1334.07	1335.81	1333.82	1335.31	85160.0
2011-05-09 17:00:00	ES	Futures	1335.31	1335.56	1334.57	1334.57	1042.0
2011-05-09 18:00:00	ES	Futures	1334.32	1335.31	1334.07	1334.57	4137.0
2011-05-09 19:00:00	ES	Futures	1334.32	1335.56	1334.32	1335.07	1023.0
2011-05-09 20:00:00	ES	Futures	1335.07	1336.31	1334.07	1334.07	4090.0
2011-05-09 21:00:00	ES	Futures	1334.32	1334.32	1330.84	1331.59	12977.0
2011-05-09 22:00:00	ES	Futures	1331.59	1333.33	1331.34	1332.08	3328.0
2011-05-09 23:00:00	ES	Futures	1332.08	1333.08	1331.34	1332.08	1722.0
2011-05-09 00:00:00	NQ	Futures	2741.27	2742.42	2740.98	2741.85	234.0
2011-05-09 01:00:00	NQ	Futures	2741.27	2741.85	2739.83	2741.85	551.0
2011-05-09 02:00:00	NQ	Futures	2741.56	2744.43	2740.41	2742.42	2147.0
2011-05-09 03:00:00	NQ	Futures	2741.85	2753.34	2739.83	2753.05	4067.0
2011-05-09 04:00:00	NQ	Futures	2752.76	2753.91	2743.57	2745.01	1908.0
2011-05-09 05:00:00	NQ	Futures	2745.29	2746.73	2739.83	2743.28	1612.0
2011-05-09 06:00:00	NQ	Futures	2742.99	2747.3	2741.27	2745.01	1109.0
2011-05-09 07:00:00	NQ	Futures	2744.72	2747.02	2740.98	2741.56	2312.0
2011-05-09 08:00:00	NQ	Futures	2741.56	2743.28	2733.8	2735.52	5812.0
2011-05-09 09:00:00	NQ	Futures	2735.52	2738.97	2730.07	2734.09	59849.0
2011-05-09 10:00:00	NQ	Futures	2734.09	2742.13	2728.34	2736.96	65764.0
2011-05-09 11:00:00	NQ	Futures	2736.96	2747.02	2734.66	2746.15	24658.0
2011-05-09 12:00:00	NQ	Futures	2746.15	2755.06	2746.15	2747.59	30998.0
2011-05-09 13:00:00	NQ	Futures	2747.3	2754.2	2747.02	2752.19	11305.0
2011-05-09 14:00:00	NQ	Futures	2752.48	2755.92	2746.44	2748.17	16978.0
2011-05-09 15:00:00	NQ	Futures	2747.88	2751.04	2742.42	2744.14	25155.0
2011-05-09 16:00:00	NQ	Futures	2744.14	2747.3	2742.13	2745.01	6247.0
2011-05-09 17:00:00	NQ	Futures	2745.29	2745.29	2743.57	2744.14	103.0
2011-05-09 18:00:00	NQ	Futures	2744.14	2745.01	2742.99	2744.43	131.0
2011-05-09 19:00:00	NQ	Futures	2743.86	2746.15	2743.57	2745.58	86.0
2011-05-09 20:00:00	NQ	Futures	2745.87	2747.59	2742.99	2743.28	460.0
2011-05-09 21:00:00	NQ	Futures	2743.86	2743.86	2738.4	2739.83	587.0
2011-05-09 22:00:00	NQ	Futures	2739.83	2743.86	2739.55	2741.56	156.0
2011-05-09 23:00:00	NQ	Futures	2741.27	2742.99	2738.97	2740.41	132.0
2011-05-09 00:00:00	YM	Futures	12164.1	12168.9	12160.2	12162.2	208.0
2011-05-09 01:00:00	YM	Futures	12161.2	12162.2	12147.7	12155.4	357.0

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

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