PREVIEW / futures_1hour / 2013-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-23.parquet
  size:    47 KB
  rows:    1,455

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-23 00:00:00	ES	Futures	1758.52	1759.03	1758.52	1758.77	513.0
2013-09-23 01:00:00	ES	Futures	1759.03	1760.84	1759.03	1760.58	4332.0
2013-09-23 02:00:00	ES	Futures	1760.58	1760.84	1759.29	1760.32	6176.0
2013-09-23 03:00:00	ES	Futures	1760.58	1761.1	1757.74	1759.55	24210.0
2013-09-23 04:00:00	ES	Futures	1759.29	1761.87	1758.77	1760.06	15270.0
2013-09-23 05:00:00	ES	Futures	1759.81	1760.32	1758.26	1759.55	11142.0
2013-09-23 06:00:00	ES	Futures	1759.55	1760.06	1758.77	1759.29	6515.0
2013-09-23 07:00:00	ES	Futures	1759.03	1759.03	1752.58	1752.58	37028.0
2013-09-23 08:00:00	ES	Futures	1752.84	1754.65	1751.81	1753.87	61643.0
2013-09-23 09:00:00	ES	Futures	1754.13	1756.45	1750.26	1750.78	230379.0
2013-09-23 10:00:00	ES	Futures	1750.78	1751.81	1744.59	1745.62	303176.0
2013-09-23 11:00:00	ES	Futures	1745.88	1747.94	1743.3	1745.88	211976.0
2013-09-23 12:00:00	ES	Futures	1745.88	1749.75	1745.88	1749.49	110445.0
2013-09-23 13:00:00	ES	Futures	1749.49	1751.81	1747.17	1751.81	138106.0
2013-09-23 14:00:00	ES	Futures	1751.81	1752.33	1748.46	1751.04	173216.0
2013-09-23 15:00:00	ES	Futures	1751.29	1751.29	1747.42	1748.97	219067.0
2013-09-23 16:00:00	ES	Futures	1749.23	1749.49	1746.13	1746.91	83204.0
2013-09-23 17:00:00	ES	Futures	1747.17	1747.42	1746.65	1746.91	1679.0
2013-09-23 18:00:00	ES	Futures	1747.17	1747.94	1746.91	1747.17	3408.0
2013-09-23 19:00:00	ES	Futures	1747.17	1747.42	1746.39	1746.39	2611.0
2013-09-23 20:00:00	ES	Futures	1746.65	1746.65	1744.59	1744.59	8467.0
2013-09-23 21:00:00	ES	Futures	1744.84	1745.1	1744.07	1744.33	6842.0
2013-09-23 22:00:00	ES	Futures	1744.33	1744.33	1743.81	1744.07	3312.0
2013-09-23 23:00:00	ES	Futures	1743.81	1744.07	1743.3	1743.55	2808.0
2013-09-23 00:00:00	NQ	Futures	3743.09	3744.84	3742.51	3744.55	280.0
2013-09-23 01:00:00	NQ	Futures	3744.84	3747.45	3744.84	3747.45	589.0
2013-09-23 02:00:00	NQ	Futures	3747.16	3747.74	3745.13	3747.16	622.0
2013-09-23 03:00:00	NQ	Futures	3747.45	3748.9	3741.35	3745.71	2322.0
2013-09-23 04:00:00	NQ	Futures	3745.71	3752.68	3745.13	3748.9	2661.0
2013-09-23 05:00:00	NQ	Futures	3748.9	3749.19	3745.42	3747.45	1067.0
2013-09-23 06:00:00	NQ	Futures	3747.74	3749.19	3746.29	3746.58	755.0
2013-09-23 07:00:00	NQ	Futures	3746.58	3746.58	3731.77	3732.06	3961.0
2013-09-23 08:00:00	NQ	Futures	3732.06	3755.58	3731.19	3754.13	13828.0
2013-09-23 09:00:00	NQ	Futures	3754.13	3760.52	3741.06	3742.22	40073.0
2013-09-23 10:00:00	NQ	Futures	3741.93	3743.38	3721.89	3723.64	43413.0
2013-09-23 11:00:00	NQ	Futures	3723.93	3727.41	3715.21	3719.28	30532.0
2013-09-23 12:00:00	NQ	Futures	3719.28	3734.96	3718.99	3734.09	19643.0
2013-09-23 13:00:00	NQ	Futures	3734.09	3740.48	3727.99	3740.48	14952.0
2013-09-23 14:00:00	NQ	Futures	3740.48	3742.51	3730.61	3738.74	21541.0
2013-09-23 15:00:00	NQ	Futures	3738.45	3740.19	3728.57	3733.51	32161.0
2013-09-23 16:00:00	NQ	Futures	3733.51	3734.09	3728.28	3729.44	4973.0
2013-09-23 17:00:00	NQ	Futures	3729.73	3730.32	3729.15	3729.44	110.0
2013-09-23 18:00:00	NQ	Futures	3730.32	3732.64	3730.32	3731.19	292.0
2013-09-23 19:00:00	NQ	Futures	3731.19	3731.19	3729.44	3729.73	173.0
2013-09-23 20:00:00	NQ	Futures	3729.73	3730.32	3725.96	3726.25	731.0
2013-09-23 21:00:00	NQ	Futures	3726.54	3727.7	3724.51	3725.38	705.0
2013-09-23 22:00:00	NQ	Futures	3725.09	3726.25	3724.8	3725.67	238.0
2013-09-23 23:00:00	NQ	Futures	3725.96	3725.96	3724.51	3725.38	310.0
2013-09-23 00:00:00	YM	Futures	15754.8	15756.8	15753.8	15755.8	116.0
2013-09-23 01:00:00	YM	Futures	15757.8	15771.1	15757.8	15770.1	627.0

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

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