PREVIEW / futures_1hour / 2013-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-19.parquet
  size:    49 KB
  rows:    1,489

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-08-19 00:00:00	ES	Futures	1707.62	1708.39	1706.58	1706.84	1917.0
2013-08-19 01:00:00	ES	Futures	1707.1	1708.91	1706.58	1708.65	3341.0
2013-08-19 02:00:00	ES	Futures	1708.65	1711.24	1708.39	1710.2	10565.0
2013-08-19 03:00:00	ES	Futures	1710.2	1710.46	1706.32	1708.13	23532.0
2013-08-19 04:00:00	ES	Futures	1708.39	1708.39	1706.32	1707.62	14640.0
2013-08-19 05:00:00	ES	Futures	1707.62	1709.68	1707.1	1708.13	12837.0
2013-08-19 06:00:00	ES	Futures	1708.13	1709.68	1706.84	1707.62	13157.0
2013-08-19 07:00:00	ES	Futures	1707.62	1707.88	1704.77	1705.29	31511.0
2013-08-19 08:00:00	ES	Futures	1705.29	1708.65	1704.51	1707.36	36868.0
2013-08-19 09:00:00	ES	Futures	1707.36	1712.01	1704.77	1711.75	244076.0
2013-08-19 10:00:00	ES	Futures	1711.49	1713.3	1709.17	1710.46	228298.0
2013-08-19 11:00:00	ES	Futures	1710.2	1710.72	1707.1	1707.88	164309.0
2013-08-19 12:00:00	ES	Futures	1708.13	1709.17	1706.58	1708.13	96138.0
2013-08-19 13:00:00	ES	Futures	1708.13	1708.39	1703.22	1705.55	116904.0
2013-08-19 14:00:00	ES	Futures	1705.81	1706.58	1702.71	1704.51	124935.0
2013-08-19 15:00:00	ES	Futures	1704.77	1704.77	1698.05	1698.05	236636.0
2013-08-19 16:00:00	ES	Futures	1698.31	1700.9	1698.05	1699.86	73563.0
2013-08-19 17:00:00	ES	Futures	1699.86	1700.38	1699.6	1699.6	1419.0
2013-08-19 18:00:00	ES	Futures	1700.12	1701.93	1699.86	1700.38	6891.0
2013-08-19 19:00:00	ES	Futures	1700.38	1700.9	1700.12	1700.64	1472.0
2013-08-19 20:00:00	ES	Futures	1700.64	1703.22	1700.64	1702.96	9312.0
2013-08-19 21:00:00	ES	Futures	1702.96	1704.26	1702.19	1703.74	8196.0
2013-08-19 22:00:00	ES	Futures	1703.74	1703.74	1701.15	1701.93	4445.0
2013-08-19 23:00:00	ES	Futures	1702.19	1702.19	1699.86	1700.12	4441.0
2013-08-19 00:00:00	NQ	Futures	3589.53	3590.41	3587.49	3587.49	197.0
2013-08-19 01:00:00	NQ	Futures	3587.49	3591.29	3586.9	3590.41	282.0
2013-08-19 02:00:00	NQ	Futures	3590.99	3596.55	3590.7	3595.67	555.0
2013-08-19 03:00:00	NQ	Futures	3595.67	3595.67	3584.27	3591.87	4862.0
2013-08-19 04:00:00	NQ	Futures	3591.87	3592.46	3588.07	3591.58	2914.0
2013-08-19 05:00:00	NQ	Futures	3591.58	3596.25	3590.41	3593.33	1927.0
2013-08-19 06:00:00	NQ	Futures	3593.33	3596.55	3590.99	3593.04	1797.0
2013-08-19 07:00:00	NQ	Futures	3593.04	3594.21	3588.66	3589.83	2637.0
2013-08-19 08:00:00	NQ	Futures	3589.83	3597.42	3587.78	3594.79	3908.0
2013-08-19 09:00:00	NQ	Futures	3594.79	3614.08	3590.41	3613.79	33841.0
2013-08-19 10:00:00	NQ	Futures	3613.79	3624.31	3613.2	3621.09	37664.0
2013-08-19 11:00:00	NQ	Futures	3621.09	3622.26	3613.5	3614.96	17135.0
2013-08-19 12:00:00	NQ	Futures	3614.96	3617.88	3609.99	3615.83	13211.0
2013-08-19 13:00:00	NQ	Futures	3615.83	3616.13	3606.48	3613.2	16683.0
2013-08-19 14:00:00	NQ	Futures	3612.91	3613.79	3601.51	3604.14	20348.0
2013-08-19 15:00:00	NQ	Futures	3604.14	3604.44	3586.61	3587.2	41010.0
2013-08-19 16:00:00	NQ	Futures	3587.2	3591.58	3585.15	3589.53	8086.0
2013-08-19 17:00:00	NQ	Futures	3589.53	3589.83	3588.95	3588.95	80.0
2013-08-19 18:00:00	NQ	Futures	3590.12	3592.75	3588.95	3590.7	400.0
2013-08-19 19:00:00	NQ	Futures	3590.99	3591.87	3589.83	3591.29	179.0
2013-08-19 20:00:00	NQ	Futures	3591.29	3597.42	3591.29	3596.55	742.0
2013-08-19 21:00:00	NQ	Futures	3595.96	3598.59	3595.38	3597.13	661.0
2013-08-19 22:00:00	NQ	Futures	3597.42	3597.42	3592.75	3593.92	413.0
2013-08-19 23:00:00	NQ	Futures	3594.5	3594.5	3589.24	3590.12	623.0
2013-08-19 00:00:00	YM	Futures	15280.9	15287.0	15273.8	15275.8	260.0
2013-08-19 01:00:00	YM	Futures	15275.8	15291.1	15273.8	15290.1	475.0

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

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