PREVIEW / futures_1hour / 2013-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-08.parquet
  size:    42 KB
  rows:    1,226

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-08 00:00:00	ES	Futures	1583.94	1584.71	1583.68	1584.71	1566.0
2013-03-08 01:00:00	ES	Futures	1584.71	1584.96	1583.94	1584.19	2030.0
2013-03-08 02:00:00	ES	Futures	1584.45	1586.25	1584.19	1585.73	6284.0
2013-03-08 03:00:00	ES	Futures	1585.73	1588.81	1585.48	1587.79	16040.0
2013-03-08 04:00:00	ES	Futures	1587.53	1588.56	1587.27	1587.79	6732.0
2013-03-08 05:00:00	ES	Futures	1587.53	1589.58	1587.53	1589.07	6293.0
2013-03-08 06:00:00	ES	Futures	1588.81	1589.58	1587.79	1589.07	8462.0
2013-03-08 07:00:00	ES	Futures	1589.07	1589.33	1587.27	1587.79	10105.0
2013-03-08 08:00:00	ES	Futures	1587.79	1594.46	1587.27	1589.33	102160.0
2013-03-08 09:00:00	ES	Futures	1589.33	1592.4	1585.22	1586.76	121059.0
2013-03-08 10:00:00	ES	Futures	1586.5	1587.79	1582.91	1586.76	105495.0
2013-03-08 11:00:00	ES	Futures	1586.5	1589.33	1585.22	1589.07	60771.0
2013-03-08 12:00:00	ES	Futures	1589.07	1589.84	1585.73	1588.04	51141.0
2013-03-08 13:00:00	ES	Futures	1587.79	1589.58	1587.02	1589.07	24105.0
2013-03-08 14:00:00	ES	Futures	1589.33	1590.09	1588.3	1589.84	18051.0
2013-03-08 15:00:00	ES	Futures	1589.58	1592.92	1589.58	1590.61	66838.0
2013-03-08 16:00:00	ES	Futures	1590.61	1591.38	1589.84	1590.61	34871.0
2013-03-08 17:00:00	ES	Futures	1590.61	1591.63	1590.61	1591.12	1117.0
2013-03-08 00:00:00	NQ	Futures	3259.97	3260.85	3259.1	3260.85	183.0
2013-03-08 01:00:00	NQ	Futures	3260.85	3261.72	3259.68	3261.14	210.0
2013-03-08 02:00:00	NQ	Futures	3261.14	3264.92	3261.14	3264.05	317.0
2013-03-08 03:00:00	NQ	Futures	3263.76	3268.12	3262.88	3265.5	765.0
2013-03-08 04:00:00	NQ	Futures	3265.5	3266.67	3263.18	3264.63	980.0
2013-03-08 05:00:00	NQ	Futures	3264.34	3269.58	3263.76	3268.41	929.0
2013-03-08 06:00:00	NQ	Futures	3268.12	3269.0	3266.09	3268.12	520.0
2013-03-08 07:00:00	NQ	Futures	3267.83	3268.71	3264.05	3264.63	1253.0
2013-03-08 08:00:00	NQ	Futures	3264.92	3292.28	3263.18	3269.29	6279.0
2013-03-08 09:00:00	NQ	Futures	3269.29	3275.98	3258.81	3260.26	15269.0
2013-03-08 10:00:00	NQ	Futures	3260.26	3262.3	3251.24	3259.97	12737.0
2013-03-08 11:00:00	NQ	Futures	3259.68	3264.63	3255.61	3263.76	4997.0
2013-03-08 12:00:00	NQ	Futures	3264.05	3266.38	3255.9	3259.39	5065.0
2013-03-08 13:00:00	NQ	Futures	3259.39	3263.76	3258.23	3262.01	2648.0
2013-03-08 14:00:00	NQ	Futures	3262.3	3264.34	3261.14	3263.47	1800.0
2013-03-08 15:00:00	NQ	Futures	3263.47	3269.0	3263.18	3263.47	8061.0
2013-03-08 16:00:00	NQ	Futures	3263.47	3263.76	3260.26	3261.72	1722.0
2013-03-08 17:00:00	NQ	Futures	3262.3	3264.34	3262.3	3264.34	74.0
2013-03-08 00:00:00	YM	Futures	14413.3	14422.4	14412.3	14422.4	389.0
2013-03-08 01:00:00	YM	Futures	14422.4	14426.4	14417.3	14419.4	308.0
2013-03-08 02:00:00	YM	Futures	14420.4	14443.5	14419.4	14437.5	1207.0
2013-03-08 03:00:00	YM	Futures	14438.5	14476.7	14437.5	14457.6	2456.0
2013-03-08 04:00:00	YM	Futures	14457.6	14465.6	14453.6	14453.6	689.0
2013-03-08 05:00:00	YM	Futures	14453.6	14468.7	14453.6	14467.6	305.0
2013-03-08 06:00:00	YM	Futures	14466.6	14468.7	14459.6	14464.6	344.0
2013-03-08 07:00:00	YM	Futures	14464.6	14465.6	14452.6	14454.6	946.0
2013-03-08 08:00:00	YM	Futures	14454.6	14513.9	14452.6	14474.7	6082.0
2013-03-08 09:00:00	YM	Futures	14473.7	14493.8	14426.4	14435.5	12065.0
2013-03-08 10:00:00	YM	Futures	14435.5	14452.6	14410.3	14437.5	10437.0
2013-03-08 11:00:00	YM	Futures	14437.5	14459.6	14428.4	14456.6	6011.0
2013-03-08 12:00:00	YM	Futures	14458.6	14460.6	14425.4	14443.5	4509.0
2013-03-08 13:00:00	YM	Futures	14443.5	14460.6	14435.5	14454.6	2034.0

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

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