PREVIEW / futures_1hour / 2013-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-22.parquet
  size:    52 KB
  rows:    1,546

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-05-22 00:00:00	ES	Futures	1716.03	1716.8	1715.51	1716.28	2325.0
2013-05-22 01:00:00	ES	Futures	1716.54	1717.06	1716.03	1716.28	3477.0
2013-05-22 02:00:00	ES	Futures	1716.28	1717.83	1715.77	1717.57	8163.0
2013-05-22 03:00:00	ES	Futures	1717.83	1719.38	1716.54	1718.35	19769.0
2013-05-22 04:00:00	ES	Futures	1718.35	1719.89	1717.57	1717.57	14170.0
2013-05-22 05:00:00	ES	Futures	1717.57	1719.63	1716.54	1717.57	16308.0
2013-05-22 06:00:00	ES	Futures	1717.57	1719.38	1716.8	1718.09	14857.0
2013-05-22 07:00:00	ES	Futures	1718.35	1719.38	1717.83	1719.12	19384.0
2013-05-22 08:00:00	ES	Futures	1719.12	1721.44	1718.86	1720.15	35014.0
2013-05-22 09:00:00	ES	Futures	1720.15	1723.24	1718.6	1722.72	193041.0
2013-05-22 10:00:00	ES	Futures	1722.72	1736.89	1721.18	1722.72	878781.0
2013-05-22 11:00:00	ES	Futures	1722.98	1732.77	1721.44	1729.42	297291.0
2013-05-22 12:00:00	ES	Futures	1729.42	1730.45	1724.01	1728.65	146674.0
2013-05-22 13:00:00	ES	Futures	1728.65	1728.65	1713.45	1716.28	277197.0
2013-05-22 14:00:00	ES	Futures	1716.54	1719.38	1703.15	1708.81	482363.0
2013-05-22 15:00:00	ES	Futures	1709.07	1709.07	1696.45	1703.66	409485.0
2013-05-22 16:00:00	ES	Futures	1703.92	1708.3	1703.41	1707.53	103960.0
2013-05-22 17:00:00	ES	Futures	1707.78	1708.04	1707.01	1707.78	2879.0
2013-05-22 18:00:00	ES	Futures	1707.78	1709.33	1706.5	1706.75	9275.0
2013-05-22 19:00:00	ES	Futures	1706.5	1708.04	1706.24	1707.53	3455.0
2013-05-22 20:00:00	ES	Futures	1707.53	1708.81	1704.44	1705.47	13468.0
2013-05-22 21:00:00	ES	Futures	1705.47	1707.27	1704.44	1704.95	11487.0
2013-05-22 22:00:00	ES	Futures	1704.69	1704.95	1702.37	1703.15	14864.0
2013-05-22 23:00:00	ES	Futures	1703.15	1703.92	1699.28	1699.8	17550.0
2013-05-22 00:00:00	NQ	Futures	3525.68	3527.14	3525.1	3526.27	224.0
2013-05-22 01:00:00	NQ	Futures	3526.27	3528.02	3525.97	3526.27	326.0
2013-05-22 02:00:00	NQ	Futures	3525.97	3528.89	3525.39	3528.89	672.0
2013-05-22 03:00:00	NQ	Futures	3528.89	3531.81	3526.56	3530.35	1775.0
2013-05-22 04:00:00	NQ	Futures	3530.35	3533.27	3528.6	3528.6	1307.0
2013-05-22 05:00:00	NQ	Futures	3528.6	3532.39	3526.85	3528.6	1538.0
2013-05-22 06:00:00	NQ	Futures	3528.31	3531.81	3527.14	3530.35	1520.0
2013-05-22 07:00:00	NQ	Futures	3530.06	3533.27	3529.18	3531.81	9735.0
2013-05-22 08:00:00	NQ	Futures	3531.81	3538.22	3531.22	3536.18	5039.0
2013-05-22 09:00:00	NQ	Futures	3536.18	3542.89	3528.31	3542.02	29643.0
2013-05-22 10:00:00	NQ	Futures	3541.43	3562.43	3530.93	3534.14	87687.0
2013-05-22 11:00:00	NQ	Futures	3533.85	3553.1	3530.06	3548.72	34158.0
2013-05-22 12:00:00	NQ	Futures	3548.72	3550.47	3536.18	3543.47	18273.0
2013-05-22 13:00:00	NQ	Futures	3543.18	3543.47	3512.56	3519.27	36082.0
2013-05-22 14:00:00	NQ	Futures	3519.85	3525.68	3492.43	3506.14	70882.0
2013-05-22 15:00:00	NQ	Futures	3506.14	3506.43	3481.06	3500.02	52534.0
2013-05-22 16:00:00	NQ	Futures	3500.02	3508.77	3499.14	3508.18	9954.0
2013-05-22 17:00:00	NQ	Futures	3508.18	3508.18	3506.43	3507.31	225.0
2013-05-22 18:00:00	NQ	Futures	3507.31	3509.93	3506.43	3506.43	815.0
2013-05-22 19:00:00	NQ	Futures	3506.72	3507.6	3504.97	3506.43	465.0
2013-05-22 20:00:00	NQ	Futures	3506.43	3508.77	3499.43	3500.89	1364.0
2013-05-22 21:00:00	NQ	Futures	3501.18	3504.1	3499.14	3500.31	1508.0
2013-05-22 22:00:00	NQ	Futures	3500.02	3500.02	3494.47	3495.35	1511.0
2013-05-22 23:00:00	NQ	Futures	3495.35	3497.68	3490.97	3491.56	1401.0
2013-05-22 00:00:00	YM	Futures	15523.1	15530.1	15523.1	15527.1	295.0
2013-05-22 01:00:00	YM	Futures	15528.1	15533.2	15525.1	15526.1	549.0

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

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