PREVIEW / futures_1hour / 2013-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-12.parquet
  size:    48 KB
  rows:    1,497

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-09-12 00:00:00	ES	Futures	1745.87	1746.13	1744.84	1745.1	1647.0
2013-09-12 01:00:00	ES	Futures	1744.84	1746.13	1744.84	1745.62	4264.0
2013-09-12 02:00:00	ES	Futures	1745.87	1745.87	1744.06	1744.32	5804.0
2013-09-12 03:00:00	ES	Futures	1744.58	1745.62	1744.06	1744.84	13933.0
2013-09-12 04:00:00	ES	Futures	1745.1	1745.62	1743.81	1744.06	14627.0
2013-09-12 05:00:00	ES	Futures	1744.32	1744.32	1742.51	1743.29	16047.0
2013-09-12 06:00:00	ES	Futures	1743.55	1745.1	1742.51	1744.84	13339.0
2013-09-12 07:00:00	ES	Futures	1744.84	1746.91	1744.06	1746.65	24272.0
2013-09-12 08:00:00	ES	Futures	1746.65	1746.91	1744.32	1746.13	30799.0
2013-09-12 09:00:00	ES	Futures	1745.87	1746.39	1742.26	1745.36	163482.0
2013-09-12 10:00:00	ES	Futures	1745.36	1747.42	1744.32	1745.1	107791.0
2013-09-12 11:00:00	ES	Futures	1745.1	1746.13	1741.48	1742.51	133403.0
2013-09-12 12:00:00	ES	Futures	1742.51	1742.77	1738.89	1741.48	105410.0
2013-09-12 13:00:00	ES	Futures	1741.74	1744.84	1741.22	1743.03	60716.0
2013-09-12 14:00:00	ES	Futures	1743.03	1744.06	1740.96	1744.06	75535.0
2013-09-12 15:00:00	ES	Futures	1744.06	1744.06	1738.38	1740.96	160124.0
2013-09-12 16:00:00	ES	Futures	1740.96	1743.03	1740.7	1742.51	64698.0
2013-09-12 17:00:00	ES	Futures	1742.77	1743.03	1742.0	1742.77	2284.0
2013-09-12 18:00:00	ES	Futures	1742.0	1743.03	1742.0	1743.03	2013.0
2013-09-12 19:00:00	ES	Futures	1743.03	1743.03	1742.26	1742.77	610.0
2013-09-12 20:00:00	ES	Futures	1743.03	1744.58	1742.77	1744.06	3576.0
2013-09-12 21:00:00	ES	Futures	1744.06	1744.32	1743.03	1743.29	1940.0
2013-09-12 22:00:00	ES	Futures	1743.55	1743.55	1742.0	1742.77	1419.0
2013-09-12 23:00:00	ES	Futures	1742.51	1743.29	1741.74	1743.03	1413.0
2013-09-12 00:00:00	NQ	Futures	3717.82	3718.41	3716.07	3716.36	209.0
2013-09-12 01:00:00	NQ	Futures	3716.36	3719.29	3716.07	3716.95	851.0
2013-09-12 02:00:00	NQ	Futures	3716.95	3717.24	3713.15	3714.32	784.0
2013-09-12 03:00:00	NQ	Futures	3714.03	3716.07	3713.44	3715.19	1783.0
2013-09-12 04:00:00	NQ	Futures	3715.49	3716.66	3713.15	3713.15	2355.0
2013-09-12 05:00:00	NQ	Futures	3713.44	3714.03	3709.93	3713.15	2157.0
2013-09-12 06:00:00	NQ	Futures	3713.15	3717.82	3711.4	3716.95	2135.0
2013-09-12 07:00:00	NQ	Futures	3717.24	3721.33	3715.19	3721.04	2427.0
2013-09-12 08:00:00	NQ	Futures	3721.04	3722.21	3717.53	3720.16	4358.0
2013-09-12 09:00:00	NQ	Futures	3719.87	3720.16	3705.84	3719.29	28096.0
2013-09-12 10:00:00	NQ	Futures	3719.29	3725.13	3716.36	3719.87	15808.0
2013-09-12 11:00:00	NQ	Futures	3719.58	3724.55	3709.35	3716.36	18747.0
2013-09-12 12:00:00	NQ	Futures	3716.66	3717.82	3709.93	3715.49	11096.0
2013-09-12 13:00:00	NQ	Futures	3715.19	3722.79	3714.9	3717.82	13001.0
2013-09-12 14:00:00	NQ	Futures	3717.82	3721.04	3714.03	3719.87	16941.0
2013-09-12 15:00:00	NQ	Futures	3720.16	3720.16	3707.89	3713.15	24580.0
2013-09-12 16:00:00	NQ	Futures	3713.15	3716.95	3712.27	3716.07	3317.0
2013-09-12 17:00:00	NQ	Futures	3716.07	3716.95	3715.49	3716.36	107.0
2013-09-12 18:00:00	NQ	Futures	3714.03	3716.36	3714.03	3715.78	143.0
2013-09-12 19:00:00	NQ	Futures	3716.07	3716.36	3714.61	3715.49	121.0
2013-09-12 20:00:00	NQ	Futures	3715.49	3719.29	3715.49	3718.99	280.0
2013-09-12 21:00:00	NQ	Futures	3719.29	3719.29	3717.24	3718.41	304.0
2013-09-12 22:00:00	NQ	Futures	3717.82	3718.41	3714.9	3715.49	203.0
2013-09-12 23:00:00	NQ	Futures	3715.78	3717.53	3715.19	3716.36	50.0
2013-09-12 00:00:00	YM	Futures	15584.2	15587.3	15584.2	15586.3	22.0
2013-09-12 01:00:00	YM	Futures	15586.3	15590.4	15579.1	15585.3	275.0

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

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