PREVIEW / futures_1hour / 2012-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-02.parquet
  size:    48 KB
  rows:    1,500

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
2012-02-02 00:00:00	ES	Futures	1331.76	1333.52	1331.76	1333.02	2997.0
2012-02-02 01:00:00	ES	Futures	1333.27	1334.78	1333.02	1334.28	3811.0
2012-02-02 02:00:00	ES	Futures	1334.28	1335.28	1333.52	1334.28	8914.0
2012-02-02 03:00:00	ES	Futures	1334.28	1335.79	1330.5	1330.5	27255.0
2012-02-02 04:00:00	ES	Futures	1330.75	1331.0	1328.73	1329.99	32284.0
2012-02-02 05:00:00	ES	Futures	1330.24	1333.27	1328.98	1330.75	30628.0
2012-02-02 06:00:00	ES	Futures	1330.75	1332.26	1329.49	1330.5	15748.0
2012-02-02 07:00:00	ES	Futures	1330.5	1331.0	1327.47	1328.73	44371.0
2012-02-02 08:00:00	ES	Futures	1328.73	1332.26	1327.98	1331.76	50568.0
2012-02-02 09:00:00	ES	Futures	1331.76	1334.02	1329.74	1332.01	182184.0
2012-02-02 10:00:00	ES	Futures	1332.01	1336.54	1332.01	1334.78	242660.0
2012-02-02 11:00:00	ES	Futures	1334.78	1336.04	1330.75	1332.01	175451.0
2012-02-02 12:00:00	ES	Futures	1331.76	1332.51	1327.98	1331.0	145545.0
2012-02-02 13:00:00	ES	Futures	1331.0	1333.02	1329.99	1332.51	61541.0
2012-02-02 14:00:00	ES	Futures	1332.26	1333.52	1331.0	1332.26	66954.0
2012-02-02 15:00:00	ES	Futures	1332.26	1334.53	1331.76	1332.76	147501.0
2012-02-02 16:00:00	ES	Futures	1332.76	1334.53	1332.51	1333.52	80347.0
2012-02-02 17:00:00	ES	Futures	1333.27	1333.77	1332.76	1332.76	1794.0
2012-02-02 18:00:00	ES	Futures	1333.02	1333.77	1332.76	1333.02	2477.0
2012-02-02 19:00:00	ES	Futures	1333.27	1334.28	1332.51	1334.02	4554.0
2012-02-02 20:00:00	ES	Futures	1334.02	1334.02	1331.5	1332.51	6454.0
2012-02-02 21:00:00	ES	Futures	1332.26	1333.52	1332.01	1332.51	2200.0
2012-02-02 22:00:00	ES	Futures	1332.51	1333.27	1332.01	1332.51	1865.0
2012-02-02 23:00:00	ES	Futures	1332.51	1332.51	1330.5	1331.25	3413.0
2012-02-02 00:00:00	NQ	Futures	2876.43	2877.88	2876.14	2877.88	192.0
2012-02-02 01:00:00	NQ	Futures	2877.88	2880.76	2877.59	2880.19	382.0
2012-02-02 02:00:00	NQ	Futures	2879.61	2881.63	2878.74	2881.34	537.0
2012-02-02 03:00:00	NQ	Futures	2881.05	2883.65	2872.68	2872.97	2631.0
2012-02-02 04:00:00	NQ	Futures	2872.97	2873.25	2868.63	2872.1	1866.0
2012-02-02 05:00:00	NQ	Futures	2872.1	2879.32	2870.37	2873.83	3060.0
2012-02-02 06:00:00	NQ	Futures	2873.83	2876.14	2871.52	2872.97	1449.0
2012-02-02 07:00:00	NQ	Futures	2872.39	2872.68	2864.3	2870.08	6497.0
2012-02-02 08:00:00	NQ	Futures	2870.37	2877.88	2869.21	2876.72	8021.0
2012-02-02 09:00:00	NQ	Futures	2876.72	2881.05	2875.28	2880.47	25671.0
2012-02-02 10:00:00	NQ	Futures	2880.47	2888.56	2879.61	2886.25	35346.0
2012-02-02 11:00:00	NQ	Futures	2886.25	2888.85	2877.3	2880.76	22297.0
2012-02-02 12:00:00	NQ	Futures	2880.76	2881.92	2868.06	2874.99	21232.0
2012-02-02 13:00:00	NQ	Futures	2874.99	2877.3	2870.08	2874.99	14605.0
2012-02-02 14:00:00	NQ	Futures	2874.99	2879.03	2874.12	2877.3	15922.0
2012-02-02 15:00:00	NQ	Futures	2877.01	2881.92	2876.14	2879.61	22239.0
2012-02-02 16:00:00	NQ	Futures	2879.32	2881.05	2876.72	2879.61	6516.0
2012-02-02 17:00:00	NQ	Futures	2879.61	2879.9	2878.45	2878.74	78.0
2012-02-02 18:00:00	NQ	Futures	2879.03	2879.9	2878.16	2879.03	129.0
2012-02-02 19:00:00	NQ	Futures	2878.45	2880.19	2877.59	2879.9	271.0
2012-02-02 20:00:00	NQ	Futures	2879.32	2879.32	2876.43	2879.03	339.0
2012-02-02 21:00:00	NQ	Futures	2878.45	2879.9	2877.3	2878.16	123.0
2012-02-02 22:00:00	NQ	Futures	2878.74	2879.32	2877.88	2878.16	100.0
2012-02-02 23:00:00	NQ	Futures	2878.16	2878.16	2876.14	2877.3	251.0
2012-02-02 00:00:00	YM	Futures	12554.7	12566.6	12551.7	12565.6	203.0
2012-02-02 01:00:00	YM	Futures	12564.6	12577.5	12564.6	12575.5	248.0

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

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