PREVIEW / futures_1hour / 2011-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-06.parquet
  size:    43 KB
  rows:    1,187

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-06 00:00:00	ES	Futures	1327.12	1327.36	1325.63	1325.63	2256.0
2011-05-06 01:00:00	ES	Futures	1325.63	1329.6	1325.38	1327.12	8490.0
2011-05-06 02:00:00	ES	Futures	1327.36	1329.1	1326.37	1328.85	11018.0
2011-05-06 03:00:00	ES	Futures	1328.85	1329.6	1325.87	1326.37	29823.0
2011-05-06 04:00:00	ES	Futures	1326.37	1329.85	1325.38	1329.1	21389.0
2011-05-06 05:00:00	ES	Futures	1328.85	1332.58	1328.85	1330.84	25576.0
2011-05-06 06:00:00	ES	Futures	1330.84	1332.33	1329.85	1330.59	17546.0
2011-05-06 07:00:00	ES	Futures	1330.59	1330.84	1327.36	1328.85	25477.0
2011-05-06 08:00:00	ES	Futures	1328.85	1339.54	1328.11	1338.05	166359.0
2011-05-06 09:00:00	ES	Futures	1338.3	1341.28	1335.07	1336.8	378763.0
2011-05-06 10:00:00	ES	Futures	1336.8	1339.79	1334.57	1338.05	270393.0
2011-05-06 11:00:00	ES	Futures	1337.8	1343.26	1337.8	1339.79	300875.0
2011-05-06 12:00:00	ES	Futures	1339.79	1341.03	1330.35	1333.82	427366.0
2011-05-06 13:00:00	ES	Futures	1334.07	1335.56	1327.12	1329.6	277680.0
2011-05-06 14:00:00	ES	Futures	1329.6	1332.83	1323.39	1326.37	259401.0
2011-05-06 15:00:00	ES	Futures	1326.62	1331.34	1326.12	1328.61	302111.0
2011-05-06 16:00:00	ES	Futures	1328.61	1328.85	1325.63	1326.62	95522.0
2011-05-06 00:00:00	NQ	Futures	2730.64	2731.79	2728.34	2728.92	247.0
2011-05-06 01:00:00	NQ	Futures	2729.2	2736.96	2728.34	2732.65	518.0
2011-05-06 02:00:00	NQ	Futures	2732.65	2737.25	2731.5	2737.25	423.0
2011-05-06 03:00:00	NQ	Futures	2737.54	2738.4	2731.21	2732.08	2184.0
2011-05-06 04:00:00	NQ	Futures	2732.08	2738.11	2730.07	2737.25	1548.0
2011-05-06 05:00:00	NQ	Futures	2737.25	2745.58	2737.25	2742.99	2344.0
2011-05-06 06:00:00	NQ	Futures	2742.71	2746.44	2742.13	2742.42	1363.0
2011-05-06 07:00:00	NQ	Futures	2742.42	2742.71	2735.52	2737.82	1410.0
2011-05-06 08:00:00	NQ	Futures	2737.54	2763.68	2736.39	2761.67	18766.0
2011-05-06 09:00:00	NQ	Futures	2761.96	2765.69	2743.86	2750.46	65871.0
2011-05-06 10:00:00	NQ	Futures	2750.75	2758.22	2745.87	2756.79	51022.0
2011-05-06 11:00:00	NQ	Futures	2757.07	2769.43	2756.5	2765.69	41590.0
2011-05-06 12:00:00	NQ	Futures	2765.69	2767.42	2747.88	2753.05	43118.0
2011-05-06 13:00:00	NQ	Futures	2753.34	2755.06	2738.68	2740.41	37990.0
2011-05-06 14:00:00	NQ	Futures	2740.7	2747.59	2726.9	2732.65	41165.0
2011-05-06 15:00:00	NQ	Futures	2732.36	2742.42	2731.5	2734.66	37946.0
2011-05-06 16:00:00	NQ	Futures	2734.95	2735.52	2726.9	2727.48	8004.0
2011-05-06 00:00:00	YM	Futures	12102.5	12105.3	12091.9	12092.8	149.0
2011-05-06 01:00:00	YM	Futures	12093.8	12136.2	12093.8	12115.9	1230.0
2011-05-06 02:00:00	YM	Futures	12116.9	12133.3	12110.2	12127.5	745.0
2011-05-06 03:00:00	YM	Futures	12127.5	12131.3	12097.6	12101.5	1811.0
2011-05-06 04:00:00	YM	Futures	12101.5	12129.4	12091.9	12121.7	1573.0
2011-05-06 05:00:00	YM	Futures	12121.7	12146.8	12121.7	12135.2	1505.0
2011-05-06 06:00:00	YM	Futures	12134.2	12143.9	12128.5	12130.4	822.0
2011-05-06 07:00:00	YM	Futures	12131.3	12133.3	12109.2	12117.9	866.0
2011-05-06 08:00:00	YM	Futures	12116.9	12222.9	12114.0	12216.1	8952.0
2011-05-06 09:00:00	YM	Futures	12216.1	12231.5	12170.8	12199.7	29825.0
2011-05-06 10:00:00	YM	Futures	12198.8	12229.6	12183.4	12207.4	20261.0
2011-05-06 11:00:00	YM	Futures	12207.4	12246.0	12207.4	12226.7	17207.0
2011-05-06 12:00:00	YM	Futures	12225.7	12232.5	12146.8	12174.7	26378.0
2011-05-06 13:00:00	YM	Futures	12174.7	12191.1	12115.9	12135.2	18180.0
2011-05-06 14:00:00	YM	Futures	12135.2	12165.1	12090.9	12112.1	14378.0
2011-05-06 15:00:00	YM	Futures	12111.1	12153.5	12107.3	12132.3	17029.0

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

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