PREVIEW / futures_1hour / 2013-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-01.parquet
  size:    43 KB
  rows:    1,253

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
2013-03-01 00:00:00	ES	Futures	1550.84	1551.86	1550.84	1551.61	2891.0
2013-03-01 01:00:00	ES	Futures	1551.61	1551.61	1550.07	1550.32	3883.0
2013-03-01 02:00:00	ES	Futures	1550.32	1550.84	1548.27	1550.07	13651.0
2013-03-01 03:00:00	ES	Futures	1550.32	1553.4	1549.81	1552.63	37535.0
2013-03-01 04:00:00	ES	Futures	1552.63	1553.4	1548.27	1548.53	30450.0
2013-03-01 05:00:00	ES	Futures	1548.53	1549.81	1547.24	1549.04	35440.0
2013-03-01 06:00:00	ES	Futures	1549.3	1549.3	1545.96	1547.24	30120.0
2013-03-01 07:00:00	ES	Futures	1547.5	1547.76	1543.91	1543.91	69658.0
2013-03-01 08:00:00	ES	Futures	1544.17	1546.99	1542.88	1546.47	79929.0
2013-03-01 09:00:00	ES	Futures	1546.47	1546.73	1539.03	1544.17	353782.0
2013-03-01 10:00:00	ES	Futures	1544.42	1555.71	1544.42	1555.46	522112.0
2013-03-01 11:00:00	ES	Futures	1555.46	1557.51	1548.78	1551.61	359554.0
2013-03-01 12:00:00	ES	Futures	1551.61	1559.05	1551.61	1558.02	227126.0
2013-03-01 13:00:00	ES	Futures	1558.28	1559.05	1554.17	1556.22	148881.0
2013-03-01 14:00:00	ES	Futures	1555.97	1558.28	1553.92	1555.97	156545.0
2013-03-01 15:00:00	ES	Futures	1555.97	1557.51	1553.92	1556.99	266754.0
2013-03-01 16:00:00	ES	Futures	1556.74	1558.02	1555.46	1555.71	111474.0
2013-03-01 17:00:00	ES	Futures	1555.97	1556.99	1555.46	1556.74	2062.0
2013-03-01 00:00:00	NQ	Futures	3188.08	3189.83	3188.08	3189.53	260.0
2013-03-01 01:00:00	NQ	Futures	3189.24	3190.12	3186.92	3186.92	581.0
2013-03-01 02:00:00	NQ	Futures	3186.92	3187.5	3182.26	3186.04	1089.0
2013-03-01 03:00:00	NQ	Futures	3185.75	3193.61	3185.46	3192.74	2744.0
2013-03-01 04:00:00	NQ	Futures	3192.15	3193.9	3184.0	3185.75	2564.0
2013-03-01 05:00:00	NQ	Futures	3185.46	3186.92	3181.68	3182.55	3081.0
2013-03-01 06:00:00	NQ	Futures	3182.26	3183.13	3174.98	3179.64	3350.0
2013-03-01 07:00:00	NQ	Futures	3179.64	3179.64	3170.91	3170.91	3690.0
2013-03-01 08:00:00	NQ	Futures	3171.2	3176.44	3170.32	3174.98	8871.0
2013-03-01 09:00:00	NQ	Futures	3174.98	3175.27	3157.23	3164.21	45175.0
2013-03-01 10:00:00	NQ	Futures	3164.21	3195.07	3163.92	3195.07	69263.0
2013-03-01 11:00:00	NQ	Futures	3194.77	3200.01	3180.51	3187.21	41080.0
2013-03-01 12:00:00	NQ	Futures	3186.92	3203.51	3186.92	3200.89	27043.0
2013-03-01 13:00:00	NQ	Futures	3200.6	3202.92	3192.74	3197.68	14952.0
2013-03-01 14:00:00	NQ	Futures	3198.27	3202.34	3193.32	3196.81	15773.0
2013-03-01 15:00:00	NQ	Futures	3196.81	3201.47	3194.19	3197.68	28330.0
2013-03-01 16:00:00	NQ	Futures	3198.27	3200.89	3196.81	3200.3	6274.0
2013-03-01 17:00:00	NQ	Futures	3199.72	3201.76	3199.43	3200.6	226.0
2013-03-01 00:00:00	YM	Futures	14115.5	14121.6	14114.5	14119.6	230.0
2013-03-01 01:00:00	YM	Futures	14120.6	14121.6	14111.5	14112.5	276.0
2013-03-01 02:00:00	YM	Futures	14112.5	14116.5	14097.4	14110.5	1395.0
2013-03-01 03:00:00	YM	Futures	14112.5	14138.7	14110.5	14134.6	3170.0
2013-03-01 04:00:00	YM	Futures	14132.6	14137.7	14099.4	14103.5	2457.0
2013-03-01 05:00:00	YM	Futures	14103.5	14110.5	14093.4	14103.5	3290.0
2013-03-01 06:00:00	YM	Futures	14103.5	14105.5	14075.3	14086.4	3204.0
2013-03-01 07:00:00	YM	Futures	14085.4	14086.4	14057.2	14059.2	4414.0
2013-03-01 08:00:00	YM	Futures	14059.2	14081.3	14051.1	14077.3	6398.0
2013-03-01 09:00:00	YM	Futures	14078.3	14079.3	14002.9	14050.1	33174.0
2013-03-01 10:00:00	YM	Futures	14051.1	14142.7	14051.1	14142.7	38688.0
2013-03-01 11:00:00	YM	Futures	14141.7	14154.8	14093.4	14111.5	27962.0
2013-03-01 12:00:00	YM	Futures	14110.5	14177.9	14110.5	14171.9	18781.0
2013-03-01 13:00:00	YM	Futures	14171.9	14176.9	14139.7	14153.8	13482.0

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

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