PREVIEW / futures_1hour / 2013-08-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1700.12	1700.38	1699.34	1700.12	2989.0
2013-08-20 01:00:00	ES	Futures	1699.86	1700.38	1697.79	1698.05	13162.0
2013-08-20 02:00:00	ES	Futures	1698.05	1701.67	1696.76	1701.41	17306.0
2013-08-20 03:00:00	ES	Futures	1701.67	1701.67	1697.28	1698.83	37442.0
2013-08-20 04:00:00	ES	Futures	1699.09	1701.15	1697.02	1700.12	26378.0
2013-08-20 05:00:00	ES	Futures	1700.12	1700.38	1697.54	1699.6	17438.0
2013-08-20 06:00:00	ES	Futures	1699.34	1701.93	1698.05	1700.38	20592.0
2013-08-20 07:00:00	ES	Futures	1700.38	1705.03	1700.38	1704.0	37631.0
2013-08-20 08:00:00	ES	Futures	1704.0	1705.81	1701.93	1703.48	58249.0
2013-08-20 09:00:00	ES	Futures	1703.22	1703.74	1699.09	1701.41	230312.0
2013-08-20 10:00:00	ES	Futures	1701.41	1708.13	1700.9	1706.58	301466.0
2013-08-20 11:00:00	ES	Futures	1706.58	1711.75	1706.58	1710.72	193272.0
2013-08-20 12:00:00	ES	Futures	1710.98	1712.27	1708.91	1711.24	147207.0
2013-08-20 13:00:00	ES	Futures	1711.24	1713.05	1709.68	1710.72	105236.0
2013-08-20 14:00:00	ES	Futures	1710.72	1711.49	1708.91	1709.94	93822.0
2013-08-20 15:00:00	ES	Futures	1709.94	1712.01	1706.07	1706.58	171117.0
2013-08-20 16:00:00	ES	Futures	1706.58	1707.62	1706.07	1706.84	67285.0
2013-08-20 17:00:00	ES	Futures	1706.58	1707.36	1706.58	1707.1	1113.0
2013-08-20 18:00:00	ES	Futures	1707.1	1707.62	1706.58	1706.84	3020.0
2013-08-20 19:00:00	ES	Futures	1707.1	1707.62	1706.58	1706.84	1195.0
2013-08-20 20:00:00	ES	Futures	1706.84	1707.36	1705.81	1706.32	5424.0
2013-08-20 21:00:00	ES	Futures	1706.58	1706.84	1703.74	1703.74	9196.0
2013-08-20 22:00:00	ES	Futures	1704.0	1704.51	1703.48	1703.74	4998.0
2013-08-20 23:00:00	ES	Futures	1704.0	1704.51	1702.96	1703.22	5799.0
2013-08-20 00:00:00	NQ	Futures	3590.12	3590.41	3588.36	3590.41	642.0
2013-08-20 01:00:00	NQ	Futures	3590.12	3590.12	3584.57	3584.86	1043.0
2013-08-20 02:00:00	NQ	Futures	3585.15	3592.75	3581.64	3592.46	1485.0
2013-08-20 03:00:00	NQ	Futures	3592.46	3592.75	3584.86	3586.61	5105.0
2013-08-20 04:00:00	NQ	Futures	3586.32	3589.53	3581.06	3587.49	2732.0
2013-08-20 05:00:00	NQ	Futures	3587.49	3588.07	3582.81	3585.44	1387.0
2013-08-20 06:00:00	NQ	Futures	3585.44	3592.16	3584.57	3589.83	1870.0
2013-08-20 07:00:00	NQ	Futures	3589.53	3598.88	3589.24	3597.13	2985.0
2013-08-20 08:00:00	NQ	Futures	3596.84	3601.81	3595.38	3598.01	5003.0
2013-08-20 09:00:00	NQ	Futures	3598.3	3602.68	3591.29	3598.59	28809.0
2013-08-20 10:00:00	NQ	Futures	3598.3	3610.87	3594.5	3605.61	26949.0
2013-08-20 11:00:00	NQ	Futures	3605.31	3618.46	3605.02	3616.13	16933.0
2013-08-20 12:00:00	NQ	Futures	3616.13	3620.22	3609.99	3615.25	17678.0
2013-08-20 13:00:00	NQ	Futures	3614.96	3619.05	3610.28	3611.16	8927.0
2013-08-20 14:00:00	NQ	Futures	3611.16	3613.2	3607.07	3608.82	10193.0
2013-08-20 15:00:00	NQ	Futures	3608.82	3613.5	3602.68	3603.27	24770.0
2013-08-20 16:00:00	NQ	Futures	3603.27	3605.31	3602.1	3603.56	4244.0
2013-08-20 17:00:00	NQ	Futures	3603.27	3604.14	3602.98	3602.98	75.0
2013-08-20 18:00:00	NQ	Futures	3602.39	3605.02	3602.39	3603.56	222.0
2013-08-20 19:00:00	NQ	Futures	3603.85	3605.02	3602.98	3604.44	189.0
2013-08-20 20:00:00	NQ	Futures	3604.14	3605.02	3602.39	3603.85	490.0
2013-08-20 21:00:00	NQ	Futures	3603.56	3604.44	3598.88	3598.88	732.0
2013-08-20 22:00:00	NQ	Futures	3598.88	3598.88	3597.42	3598.59	845.0
2013-08-20 23:00:00	NQ	Futures	3598.3	3599.76	3596.55	3596.84	492.0
2013-08-20 00:00:00	YM	Futures	15226.1	15226.1	15220.0	15226.1	515.0
2013-08-20 01:00:00	YM	Futures	15224.0	15228.1	15211.9	15211.9	1832.0

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

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