PREVIEW / futures_1hour / 2013-08-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	1742.0	1742.77	1741.74	1742.26	1060.0
2013-08-12 01:00:00	ES	Futures	1742.0	1743.29	1741.74	1743.29	2429.0
2013-08-12 02:00:00	ES	Futures	1743.29	1744.32	1741.74	1741.74	10627.0
2013-08-12 03:00:00	ES	Futures	1741.48	1742.51	1738.12	1739.41	29452.0
2013-08-12 04:00:00	ES	Futures	1739.15	1739.41	1734.5	1735.53	28219.0
2013-08-12 05:00:00	ES	Futures	1735.53	1735.53	1732.17	1733.72	26492.0
2013-08-12 06:00:00	ES	Futures	1733.98	1735.02	1733.72	1735.02	13043.0
2013-08-12 07:00:00	ES	Futures	1735.02	1736.83	1734.5	1735.53	18715.0
2013-08-12 08:00:00	ES	Futures	1735.79	1738.12	1735.02	1737.34	28768.0
2013-08-12 09:00:00	ES	Futures	1737.6	1743.03	1735.79	1741.22	207368.0
2013-08-12 10:00:00	ES	Futures	1741.22	1745.36	1741.22	1744.84	252087.0
2013-08-12 11:00:00	ES	Futures	1744.84	1745.62	1742.77	1743.81	132459.0
2013-08-12 12:00:00	ES	Futures	1743.81	1743.81	1740.45	1743.03	85046.0
2013-08-12 13:00:00	ES	Futures	1743.29	1743.81	1739.93	1740.7	93785.0
2013-08-12 14:00:00	ES	Futures	1740.7	1742.51	1740.19	1742.26	89133.0
2013-08-12 15:00:00	ES	Futures	1742.51	1745.1	1741.22	1743.55	132827.0
2013-08-12 16:00:00	ES	Futures	1743.55	1745.62	1743.29	1745.62	60815.0
2013-08-12 17:00:00	ES	Futures	1745.36	1745.87	1745.36	1745.62	2285.0
2013-08-12 18:00:00	ES	Futures	1745.36	1745.87	1744.84	1745.1	3977.0
2013-08-12 19:00:00	ES	Futures	1745.1	1745.36	1744.06	1744.58	2938.0
2013-08-12 20:00:00	ES	Futures	1744.32	1745.1	1744.06	1744.84	2984.0
2013-08-12 21:00:00	ES	Futures	1744.84	1745.36	1744.32	1744.58	2509.0
2013-08-12 22:00:00	ES	Futures	1744.84	1744.84	1744.32	1744.58	1234.0
2013-08-12 23:00:00	ES	Futures	1744.58	1746.65	1744.32	1745.87	4680.0
2013-08-12 00:00:00	NQ	Futures	3640.67	3640.97	3640.09	3640.38	264.0
2013-08-12 01:00:00	NQ	Futures	3640.38	3642.72	3640.09	3642.43	396.0
2013-08-12 02:00:00	NQ	Futures	3642.43	3644.77	3640.09	3640.38	1025.0
2013-08-12 03:00:00	NQ	Futures	3640.09	3640.38	3630.15	3632.49	4883.0
2013-08-12 04:00:00	NQ	Futures	3632.2	3632.49	3623.14	3624.02	3233.0
2013-08-12 05:00:00	NQ	Futures	3624.02	3624.02	3617.0	3620.22	3466.0
2013-08-12 06:00:00	NQ	Futures	3620.22	3624.02	3620.22	3623.72	1479.0
2013-08-12 07:00:00	NQ	Futures	3623.43	3628.4	3623.14	3626.65	2703.0
2013-08-12 08:00:00	NQ	Futures	3626.65	3631.62	3626.35	3630.74	2722.0
2013-08-12 09:00:00	NQ	Futures	3630.74	3647.98	3627.52	3645.06	35743.0
2013-08-12 10:00:00	NQ	Futures	3645.06	3656.75	3644.77	3656.46	34048.0
2013-08-12 11:00:00	NQ	Futures	3656.46	3658.21	3649.73	3652.36	18498.0
2013-08-12 12:00:00	NQ	Futures	3652.36	3652.36	3643.01	3650.9	13425.0
2013-08-12 13:00:00	NQ	Futures	3650.9	3654.12	3645.35	3647.1	9797.0
2013-08-12 14:00:00	NQ	Futures	3646.81	3652.07	3645.06	3652.07	13903.0
2013-08-12 15:00:00	NQ	Futures	3652.07	3655.58	3649.15	3650.9	15780.0
2013-08-12 16:00:00	NQ	Futures	3651.19	3654.99	3649.73	3654.99	4222.0
2013-08-12 17:00:00	NQ	Futures	3654.7	3655.29	3654.7	3654.99	74.0
2013-08-12 18:00:00	NQ	Futures	3654.12	3654.99	3653.24	3653.82	190.0
2013-08-12 19:00:00	NQ	Futures	3653.53	3653.82	3650.9	3652.36	271.0
2013-08-12 20:00:00	NQ	Futures	3652.07	3653.82	3651.49	3653.82	336.0
2013-08-12 21:00:00	NQ	Futures	3653.53	3654.7	3651.78	3652.66	488.0
2013-08-12 22:00:00	NQ	Futures	3652.95	3653.53	3652.36	3653.53	157.0
2013-08-12 23:00:00	NQ	Futures	3653.53	3656.75	3653.24	3656.16	354.0
2013-08-12 00:00:00	YM	Futures	15603.9	15608.0	15603.9	15604.9	286.0
2013-08-12 01:00:00	YM	Futures	15604.9	15617.1	15602.9	15615.1	574.0

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

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