PREVIEW / futures_1hour / 2013-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-17.parquet
  size:    52 KB
  rows:    1,570

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-17 00:00:00	ES	Futures	1611.45	1613.51	1610.93	1613.25	4868.0
2013-04-17 01:00:00	ES	Futures	1613.51	1613.77	1612.48	1613.25	4523.0
2013-04-17 02:00:00	ES	Futures	1612.99	1615.57	1612.48	1614.54	11571.0
2013-04-17 03:00:00	ES	Futures	1614.8	1615.31	1605.01	1609.39	79967.0
2013-04-17 04:00:00	ES	Futures	1609.13	1610.16	1606.04	1609.13	45707.0
2013-04-17 05:00:00	ES	Futures	1609.13	1609.64	1607.07	1608.61	17345.0
2013-04-17 06:00:00	ES	Futures	1608.87	1608.87	1602.95	1603.98	34451.0
2013-04-17 07:00:00	ES	Futures	1603.98	1605.78	1602.43	1604.75	51624.0
2013-04-17 08:00:00	ES	Futures	1605.01	1608.1	1603.72	1603.98	61752.0
2013-04-17 09:00:00	ES	Futures	1603.98	1606.81	1599.08	1602.17	354618.0
2013-04-17 10:00:00	ES	Futures	1602.17	1603.46	1589.3	1589.55	563718.0
2013-04-17 11:00:00	ES	Futures	1589.55	1593.93	1586.98	1591.36	431195.0
2013-04-17 12:00:00	ES	Futures	1591.36	1592.9	1584.66	1590.07	320268.0
2013-04-17 13:00:00	ES	Futures	1589.81	1596.25	1588.27	1593.16	253893.0
2013-04-17 14:00:00	ES	Futures	1593.42	1596.25	1589.3	1592.9	224629.0
2013-04-17 15:00:00	ES	Futures	1592.9	1597.28	1591.36	1592.64	338692.0
2013-04-17 16:00:00	ES	Futures	1592.64	1594.96	1591.61	1592.9	122419.0
2013-04-17 17:00:00	ES	Futures	1592.9	1593.16	1591.36	1591.61	4008.0
2013-04-17 18:00:00	ES	Futures	1591.36	1593.42	1591.1	1593.42	7841.0
2013-04-17 19:00:00	ES	Futures	1593.42	1595.22	1593.16	1594.96	4393.0
2013-04-17 20:00:00	ES	Futures	1594.7	1594.96	1592.13	1592.39	8679.0
2013-04-17 21:00:00	ES	Futures	1592.13	1592.9	1588.78	1592.13	15149.0
2013-04-17 22:00:00	ES	Futures	1592.39	1595.48	1592.39	1594.45	7755.0
2013-04-17 23:00:00	ES	Futures	1594.45	1594.96	1592.9	1594.45	5307.0
2013-04-17 00:00:00	NQ	Futures	3290.31	3295.26	3289.43	3294.97	441.0
2013-04-17 01:00:00	NQ	Futures	3294.97	3295.26	3293.22	3294.1	404.0
2013-04-17 02:00:00	NQ	Futures	3293.81	3299.93	3293.81	3297.01	896.0
2013-04-17 03:00:00	NQ	Futures	3297.6	3299.93	3275.43	3283.31	7810.0
2013-04-17 04:00:00	NQ	Futures	3283.31	3283.89	3276.01	3281.26	3534.0
2013-04-17 05:00:00	NQ	Futures	3281.26	3283.01	3277.47	3280.1	1613.0
2013-04-17 06:00:00	NQ	Futures	3280.1	3281.26	3271.64	3273.39	2794.0
2013-04-17 07:00:00	NQ	Futures	3273.39	3278.06	3268.43	3275.14	5738.0
2013-04-17 08:00:00	NQ	Futures	3275.14	3280.97	3271.06	3271.93	7742.0
2013-04-17 09:00:00	NQ	Futures	3271.93	3276.6	3260.56	3264.93	49076.0
2013-04-17 10:00:00	NQ	Futures	3264.93	3267.85	3229.64	3230.22	84809.0
2013-04-17 11:00:00	NQ	Futures	3229.93	3244.22	3225.26	3234.01	53057.0
2013-04-17 12:00:00	NQ	Futures	3234.01	3237.81	3217.97	3231.97	41932.0
2013-04-17 13:00:00	NQ	Futures	3231.97	3249.18	3229.06	3242.18	33247.0
2013-04-17 14:00:00	NQ	Futures	3242.18	3246.56	3227.6	3234.6	28528.0
2013-04-17 15:00:00	NQ	Futures	3234.31	3243.64	3230.81	3237.22	44051.0
2013-04-17 16:00:00	NQ	Futures	3237.51	3241.89	3231.97	3235.76	9460.0
2013-04-17 17:00:00	NQ	Futures	3235.47	3236.35	3232.85	3234.6	208.0
2013-04-17 18:00:00	NQ	Futures	3232.26	3237.81	3231.1	3237.51	735.0
2013-04-17 19:00:00	NQ	Futures	3237.81	3242.47	3236.93	3241.89	825.0
2013-04-17 20:00:00	NQ	Futures	3242.18	3242.18	3236.35	3236.35	1236.0
2013-04-17 21:00:00	NQ	Futures	3236.93	3237.81	3229.35	3236.64	2083.0
2013-04-17 22:00:00	NQ	Futures	3236.64	3243.93	3236.64	3241.6	1059.0
2013-04-17 23:00:00	NQ	Futures	3241.6	3243.93	3238.97	3242.47	905.0
2013-04-17 00:00:00	YM	Futures	14810.3	14827.5	14806.3	14826.5	590.0
2013-04-17 01:00:00	YM	Futures	14825.5	14829.6	14823.5	14827.5	436.0

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

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