PREVIEW / futures_1hour / 2013-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-12.parquet
  size:    50 KB
  rows:    1,547

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-02-12 00:00:00	ES	Futures	1551.35	1551.61	1548.27	1549.55	13495.0
2013-02-12 01:00:00	ES	Futures	1549.3	1550.32	1549.04	1549.81	2542.0
2013-02-12 02:00:00	ES	Futures	1550.07	1551.86	1549.81	1550.84	8439.0
2013-02-12 03:00:00	ES	Futures	1550.84	1551.35	1548.78	1549.55	26577.0
2013-02-12 04:00:00	ES	Futures	1549.81	1551.86	1549.55	1550.07	21300.0
2013-02-12 05:00:00	ES	Futures	1549.81	1553.15	1549.81	1552.12	23585.0
2013-02-12 06:00:00	ES	Futures	1552.12	1553.4	1552.12	1552.38	22037.0
2013-02-12 07:00:00	ES	Futures	1552.63	1553.15	1551.09	1552.12	23556.0
2013-02-12 08:00:00	ES	Futures	1552.38	1555.71	1551.35	1553.92	55848.0
2013-02-12 09:00:00	ES	Futures	1553.92	1554.94	1551.86	1553.15	169249.0
2013-02-12 10:00:00	ES	Futures	1553.4	1556.22	1553.15	1554.94	223442.0
2013-02-12 11:00:00	ES	Futures	1554.94	1555.97	1553.66	1554.94	160042.0
2013-02-12 12:00:00	ES	Futures	1554.94	1557.76	1554.69	1557.25	102647.0
2013-02-12 13:00:00	ES	Futures	1557.51	1559.05	1556.99	1557.51	84591.0
2013-02-12 14:00:00	ES	Futures	1557.51	1557.76	1556.22	1556.74	54278.0
2013-02-12 15:00:00	ES	Futures	1556.74	1556.74	1554.94	1555.97	174167.0
2013-02-12 16:00:00	ES	Futures	1555.97	1557.25	1555.71	1556.74	68007.0
2013-02-12 17:00:00	ES	Futures	1556.99	1558.02	1556.74	1557.76	2634.0
2013-02-12 18:00:00	ES	Futures	1557.51	1558.02	1557.51	1557.76	3427.0
2013-02-12 19:00:00	ES	Futures	1558.02	1558.02	1556.99	1557.51	4455.0
2013-02-12 20:00:00	ES	Futures	1557.51	1557.76	1556.99	1557.76	2090.0
2013-02-12 21:00:00	ES	Futures	1557.51	1558.28	1557.51	1557.51	3256.0
2013-02-12 22:00:00	ES	Futures	1557.51	1558.02	1557.51	1557.51	2096.0
2013-02-12 23:00:00	ES	Futures	1557.51	1557.76	1557.25	1557.25	4779.0
2013-02-12 00:00:00	NQ	Futures	3223.59	3223.59	3217.77	3220.39	833.0
2013-02-12 01:00:00	NQ	Futures	3220.1	3221.84	3219.81	3221.55	191.0
2013-02-12 02:00:00	NQ	Futures	3221.55	3225.34	3221.55	3223.59	481.0
2013-02-12 03:00:00	NQ	Futures	3223.59	3223.88	3218.64	3220.68	2061.0
2013-02-12 04:00:00	NQ	Futures	3220.68	3224.46	3219.81	3220.68	1569.0
2013-02-12 05:00:00	NQ	Futures	3220.68	3227.67	3220.68	3225.63	1567.0
2013-02-12 06:00:00	NQ	Futures	3225.63	3227.67	3222.13	3222.43	2259.0
2013-02-12 07:00:00	NQ	Futures	3222.72	3223.88	3220.1	3222.72	2481.0
2013-02-12 08:00:00	NQ	Futures	3222.43	3227.67	3219.81	3224.75	4986.0
2013-02-12 09:00:00	NQ	Futures	3224.75	3226.79	3219.52	3220.39	21906.0
2013-02-12 10:00:00	NQ	Futures	3220.68	3230.28	3215.73	3224.17	35867.0
2013-02-12 11:00:00	NQ	Futures	3224.17	3225.05	3211.95	3216.6	25141.0
2013-02-12 12:00:00	NQ	Futures	3216.6	3226.21	3214.28	3224.75	16825.0
2013-02-12 13:00:00	NQ	Futures	3224.75	3227.37	3219.52	3220.39	12169.0
2013-02-12 14:00:00	NQ	Futures	3220.1	3222.43	3218.35	3218.64	10193.0
2013-02-12 15:00:00	NQ	Futures	3218.93	3219.81	3213.11	3214.28	22366.0
2013-02-12 16:00:00	NQ	Futures	3213.98	3220.39	3213.69	3219.52	7704.0
2013-02-12 17:00:00	NQ	Futures	3219.52	3221.26	3219.52	3220.68	220.0
2013-02-12 18:00:00	NQ	Futures	3219.52	3220.97	3219.52	3219.81	195.0
2013-02-12 19:00:00	NQ	Futures	3219.81	3220.1	3218.64	3219.81	246.0
2013-02-12 20:00:00	NQ	Futures	3219.81	3220.39	3218.35	3219.22	228.0
2013-02-12 21:00:00	NQ	Futures	3219.22	3220.1	3218.93	3219.22	273.0
2013-02-12 22:00:00	NQ	Futures	3219.22	3219.81	3218.93	3219.22	213.0
2013-02-12 23:00:00	NQ	Futures	3219.22	3219.52	3218.35	3219.22	365.0
2013-02-12 00:00:00	YM	Futures	13995.8	13995.8	13971.7	13975.7	771.0
2013-02-12 01:00:00	YM	Futures	13974.7	13983.7	13973.7	13981.7	246.0

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

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