PREVIEW / futures_1hour / 2013-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-08.parquet
  size:    50 KB
  rows:    1,522

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-04-08 00:00:00	ES	Futures	1594.45	1594.96	1594.19	1594.7	2398.0
2013-04-08 01:00:00	ES	Futures	1594.7	1594.96	1592.39	1592.64	4955.0
2013-04-08 02:00:00	ES	Futures	1592.64	1593.42	1591.87	1593.16	9579.0
2013-04-08 03:00:00	ES	Futures	1592.9	1596.77	1592.39	1595.48	26708.0
2013-04-08 04:00:00	ES	Futures	1595.73	1598.05	1594.96	1597.8	21561.0
2013-04-08 05:00:00	ES	Futures	1597.54	1598.05	1595.99	1597.02	17157.0
2013-04-08 06:00:00	ES	Futures	1597.02	1598.05	1596.51	1597.8	14769.0
2013-04-08 07:00:00	ES	Futures	1597.8	1599.08	1597.28	1598.57	28452.0
2013-04-08 08:00:00	ES	Futures	1598.57	1599.08	1596.77	1597.02	24323.0
2013-04-08 09:00:00	ES	Futures	1597.02	1597.28	1590.58	1592.9	231201.0
2013-04-08 10:00:00	ES	Futures	1592.64	1595.22	1589.81	1594.96	234886.0
2013-04-08 11:00:00	ES	Futures	1594.7	1595.22	1592.39	1593.16	136434.0
2013-04-08 12:00:00	ES	Futures	1593.16	1594.7	1591.87	1593.67	68435.0
2013-04-08 13:00:00	ES	Futures	1593.67	1599.08	1593.67	1598.83	123973.0
2013-04-08 14:00:00	ES	Futures	1598.83	1600.89	1598.31	1599.6	119844.0
2013-04-08 15:00:00	ES	Futures	1599.6	1605.52	1599.34	1605.01	207440.0
2013-04-08 16:00:00	ES	Futures	1605.01	1610.16	1604.75	1610.16	120417.0
2013-04-08 17:00:00	ES	Futures	1609.9	1610.16	1608.1	1608.36	6590.0
2013-04-08 18:00:00	ES	Futures	1608.1	1608.61	1606.81	1607.58	7511.0
2013-04-08 19:00:00	ES	Futures	1607.33	1607.84	1607.07	1607.33	2105.0
2013-04-08 20:00:00	ES	Futures	1607.33	1608.87	1607.07	1608.1	6681.0
2013-04-08 21:00:00	ES	Futures	1608.1	1609.13	1607.58	1608.87	6481.0
2013-04-08 22:00:00	ES	Futures	1608.87	1611.19	1608.87	1609.64	7375.0
2013-04-08 23:00:00	ES	Futures	1609.64	1609.9	1608.61	1608.61	2408.0
2013-04-08 00:00:00	NQ	Futures	3228.18	3229.06	3228.18	3229.06	226.0
2013-04-08 01:00:00	NQ	Futures	3228.76	3229.35	3225.85	3225.85	887.0
2013-04-08 02:00:00	NQ	Futures	3225.56	3225.85	3222.64	3223.51	1259.0
2013-04-08 03:00:00	NQ	Futures	3223.51	3232.26	3222.64	3230.81	2573.0
2013-04-08 04:00:00	NQ	Futures	3230.81	3234.89	3229.93	3233.72	1837.0
2013-04-08 05:00:00	NQ	Futures	3233.72	3234.31	3229.35	3231.1	1586.0
2013-04-08 06:00:00	NQ	Futures	3231.39	3233.72	3230.81	3233.14	1271.0
2013-04-08 07:00:00	NQ	Futures	3232.85	3236.64	3232.56	3236.35	2606.0
2013-04-08 08:00:00	NQ	Futures	3236.35	3236.35	3231.68	3231.97	2495.0
2013-04-08 09:00:00	NQ	Futures	3232.26	3232.26	3221.18	3225.56	31814.0
2013-04-08 10:00:00	NQ	Futures	3225.56	3227.6	3216.51	3225.85	29286.0
2013-04-08 11:00:00	NQ	Futures	3225.56	3226.43	3219.72	3221.76	17182.0
2013-04-08 12:00:00	NQ	Futures	3221.76	3223.22	3217.1	3221.47	9051.0
2013-04-08 13:00:00	NQ	Futures	3221.47	3232.26	3220.89	3231.97	18766.0
2013-04-08 14:00:00	NQ	Futures	3231.97	3236.93	3230.22	3231.1	15064.0
2013-04-08 15:00:00	NQ	Futures	3230.81	3243.35	3230.51	3242.76	25787.0
2013-04-08 16:00:00	NQ	Futures	3242.47	3252.97	3241.6	3252.97	11191.0
2013-04-08 17:00:00	NQ	Futures	3252.68	3252.68	3249.47	3249.76	166.0
2013-04-08 18:00:00	NQ	Futures	3248.89	3250.93	3247.43	3247.72	438.0
2013-04-08 19:00:00	NQ	Futures	3247.72	3248.6	3246.85	3247.43	75.0
2013-04-08 20:00:00	NQ	Futures	3247.43	3251.22	3247.43	3250.35	519.0
2013-04-08 21:00:00	NQ	Futures	3250.06	3252.68	3249.18	3251.81	423.0
2013-04-08 22:00:00	NQ	Futures	3252.1	3255.01	3251.51	3251.81	410.0
2013-04-08 23:00:00	NQ	Futures	3251.81	3252.68	3250.64	3251.22	138.0
2013-04-08 00:00:00	YM	Futures	14648.6	14650.6	14645.6	14649.6	134.0
2013-04-08 01:00:00	YM	Futures	14649.6	14649.6	14633.4	14633.4	437.0

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

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