PREVIEW / futures_1hour / 2013-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-10.parquet
  size:    51 KB
  rows:    1,554

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-10-10 00:00:00	ES	Futures	1707.96	1709.76	1706.92	1709.5	7812.0
2013-10-10 01:00:00	ES	Futures	1709.76	1709.76	1708.47	1709.25	5348.0
2013-10-10 02:00:00	ES	Futures	1709.25	1710.54	1708.73	1709.5	9183.0
2013-10-10 03:00:00	ES	Futures	1709.5	1714.15	1707.18	1712.86	43267.0
2013-10-10 04:00:00	ES	Futures	1712.6	1716.21	1712.34	1714.4	25634.0
2013-10-10 05:00:00	ES	Futures	1714.4	1716.73	1714.15	1715.44	16880.0
2013-10-10 06:00:00	ES	Futures	1715.69	1718.79	1715.69	1718.02	34344.0
2013-10-10 07:00:00	ES	Futures	1718.02	1719.31	1716.21	1716.47	43305.0
2013-10-10 08:00:00	ES	Futures	1716.47	1718.79	1713.89	1718.79	75720.0
2013-10-10 09:00:00	ES	Futures	1718.79	1727.3	1718.53	1726.27	355800.0
2013-10-10 10:00:00	ES	Futures	1726.53	1730.14	1724.47	1727.04	321289.0
2013-10-10 11:00:00	ES	Futures	1727.3	1733.75	1723.95	1732.46	367679.0
2013-10-10 12:00:00	ES	Futures	1732.46	1733.75	1731.43	1732.46	122044.0
2013-10-10 13:00:00	ES	Futures	1732.72	1733.49	1730.4	1732.72	125182.0
2013-10-10 14:00:00	ES	Futures	1732.72	1732.98	1729.62	1732.46	119933.0
2013-10-10 15:00:00	ES	Futures	1732.46	1741.49	1732.2	1740.46	417222.0
2013-10-10 16:00:00	ES	Futures	1740.2	1741.23	1735.3	1736.07	147766.0
2013-10-10 17:00:00	ES	Futures	1736.07	1736.85	1735.3	1736.59	3137.0
2013-10-10 18:00:00	ES	Futures	1736.59	1737.62	1726.27	1734.27	61526.0
2013-10-10 19:00:00	ES	Futures	1734.53	1737.62	1733.49	1735.56	10888.0
2013-10-10 20:00:00	ES	Futures	1735.56	1739.43	1734.78	1737.36	14176.0
2013-10-10 21:00:00	ES	Futures	1737.36	1741.23	1736.33	1740.97	9454.0
2013-10-10 22:00:00	ES	Futures	1740.97	1740.97	1739.94	1740.72	5703.0
2013-10-10 23:00:00	ES	Futures	1740.72	1742.78	1740.2	1740.72	5973.0
2013-10-10 00:00:00	NQ	Futures	3650.45	3653.35	3648.99	3653.06	950.0
2013-10-10 01:00:00	NQ	Futures	3653.06	3653.64	3651.03	3653.35	576.0
2013-10-10 02:00:00	NQ	Futures	3653.64	3654.51	3652.19	3653.64	855.0
2013-10-10 03:00:00	NQ	Futures	3653.93	3663.81	3649.28	3661.48	4691.0
2013-10-10 04:00:00	NQ	Futures	3661.77	3667.0	3660.32	3665.55	2851.0
2013-10-10 05:00:00	NQ	Futures	3665.55	3669.03	3664.97	3667.58	2923.0
2013-10-10 06:00:00	NQ	Futures	3667.87	3674.84	3667.87	3672.23	3486.0
2013-10-10 07:00:00	NQ	Futures	3672.23	3675.42	3671.65	3671.94	4080.0
2013-10-10 08:00:00	NQ	Futures	3671.94	3677.17	3667.29	3676.88	9025.0
2013-10-10 09:00:00	NQ	Futures	3677.46	3703.01	3677.17	3701.27	64691.0
2013-10-10 10:00:00	NQ	Futures	3701.56	3707.08	3691.4	3697.79	49176.0
2013-10-10 11:00:00	NQ	Futures	3697.79	3714.05	3692.27	3711.73	51591.0
2013-10-10 12:00:00	NQ	Futures	3711.73	3716.96	3709.4	3714.05	19791.0
2013-10-10 13:00:00	NQ	Futures	3713.76	3714.05	3708.53	3711.73	16438.0
2013-10-10 14:00:00	NQ	Futures	3712.02	3712.6	3702.72	3712.31	19362.0
2013-10-10 15:00:00	NQ	Futures	3712.31	3728.57	3712.02	3719.28	69425.0
2013-10-10 16:00:00	NQ	Futures	3719.28	3719.86	3706.79	3708.82	16148.0
2013-10-10 17:00:00	NQ	Futures	3708.82	3709.69	3707.08	3709.69	375.0
2013-10-10 18:00:00	NQ	Futures	3709.98	3710.86	3689.36	3704.47	7413.0
2013-10-10 19:00:00	NQ	Futures	3704.18	3710.86	3703.3	3707.08	1063.0
2013-10-10 20:00:00	NQ	Futures	3707.08	3714.05	3705.34	3709.4	2695.0
2013-10-10 21:00:00	NQ	Futures	3709.69	3717.83	3706.5	3717.83	2346.0
2013-10-10 22:00:00	NQ	Futures	3717.25	3718.12	3715.21	3718.12	779.0
2013-10-10 23:00:00	NQ	Futures	3718.12	3721.31	3716.37	3716.66	1091.0
2013-10-10 00:00:00	YM	Futures	15087.9	15103.2	15082.8	15101.2	1175.0
2013-10-10 01:00:00	YM	Futures	15101.2	15102.2	15093.0	15100.2	651.0

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

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