PREVIEW / futures_1hour / 2013-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-21.parquet
  size:    50 KB
  rows:    1,541

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-21 00:00:00	ES	Futures	1714.22	1714.74	1713.71	1714.48	2509.0
2013-05-21 01:00:00	ES	Futures	1714.22	1714.74	1713.97	1714.22	2179.0
2013-05-21 02:00:00	ES	Futures	1714.22	1716.28	1713.19	1715.77	12247.0
2013-05-21 03:00:00	ES	Futures	1715.77	1716.54	1713.97	1716.03	17752.0
2013-05-21 04:00:00	ES	Futures	1716.03	1716.54	1713.71	1713.71	16286.0
2013-05-21 05:00:00	ES	Futures	1713.71	1713.97	1711.65	1712.94	19616.0
2013-05-21 06:00:00	ES	Futures	1712.94	1714.48	1712.42	1713.71	14797.0
2013-05-21 07:00:00	ES	Futures	1713.71	1714.22	1711.91	1714.22	33298.0
2013-05-21 08:00:00	ES	Futures	1714.22	1716.28	1713.71	1716.03	30636.0
2013-05-21 09:00:00	ES	Futures	1716.28	1720.92	1715.51	1719.12	272132.0
2013-05-21 10:00:00	ES	Futures	1719.12	1719.89	1710.36	1712.42	332382.0
2013-05-21 11:00:00	ES	Futures	1712.42	1717.57	1712.42	1716.54	230041.0
2013-05-21 12:00:00	ES	Futures	1716.54	1719.63	1716.54	1718.86	166136.0
2013-05-21 13:00:00	ES	Futures	1718.86	1723.5	1718.86	1720.92	166598.0
2013-05-21 14:00:00	ES	Futures	1720.66	1724.01	1718.86	1720.66	132747.0
2013-05-21 15:00:00	ES	Futures	1720.41	1721.69	1717.06	1717.57	156575.0
2013-05-21 16:00:00	ES	Futures	1717.57	1717.83	1716.03	1716.28	63567.0
2013-05-21 17:00:00	ES	Futures	1716.54	1716.54	1716.28	1716.28	716.0
2013-05-21 18:00:00	ES	Futures	1716.28	1716.8	1716.03	1716.8	2952.0
2013-05-21 19:00:00	ES	Futures	1716.54	1717.06	1716.28	1716.8	2659.0
2013-05-21 20:00:00	ES	Futures	1716.8	1717.31	1715.51	1716.54	4564.0
2013-05-21 21:00:00	ES	Futures	1716.54	1716.8	1715.77	1716.54	2232.0
2013-05-21 22:00:00	ES	Futures	1716.8	1717.06	1716.03	1716.03	1627.0
2013-05-21 23:00:00	ES	Futures	1716.28	1716.28	1715.25	1716.03	3207.0
2013-05-21 00:00:00	NQ	Futures	3523.93	3525.1	3523.35	3524.81	218.0
2013-05-21 01:00:00	NQ	Futures	3524.81	3525.39	3523.35	3525.1	188.0
2013-05-21 02:00:00	NQ	Futures	3524.81	3528.31	3522.77	3528.02	829.0
2013-05-21 03:00:00	NQ	Futures	3527.43	3529.77	3522.18	3528.89	3599.0
2013-05-21 04:00:00	NQ	Futures	3528.6	3529.47	3522.47	3522.77	1622.0
2013-05-21 05:00:00	NQ	Futures	3522.77	3523.35	3518.68	3520.72	1898.0
2013-05-21 06:00:00	NQ	Futures	3520.72	3523.35	3519.56	3521.89	2235.0
2013-05-21 07:00:00	NQ	Futures	3521.6	3523.06	3518.97	3522.77	2989.0
2013-05-21 08:00:00	NQ	Futures	3522.77	3527.72	3522.77	3527.43	2876.0
2013-05-21 09:00:00	NQ	Futures	3527.43	3532.1	3521.89	3529.77	28230.0
2013-05-21 10:00:00	NQ	Futures	3530.06	3531.22	3511.68	3518.68	43468.0
2013-05-21 11:00:00	NQ	Futures	3518.68	3530.06	3518.39	3527.14	24428.0
2013-05-21 12:00:00	NQ	Futures	3527.43	3535.89	3527.14	3535.02	14944.0
2013-05-21 13:00:00	NQ	Futures	3535.02	3541.43	3534.43	3536.47	15101.0
2013-05-21 14:00:00	NQ	Futures	3536.77	3542.89	3529.77	3534.14	16505.0
2013-05-21 15:00:00	NQ	Futures	3533.85	3538.52	3529.77	3530.06	18544.0
2013-05-21 16:00:00	NQ	Futures	3530.35	3530.35	3525.1	3525.1	4891.0
2013-05-21 17:00:00	NQ	Futures	3525.39	3525.68	3525.1	3525.39	77.0
2013-05-21 18:00:00	NQ	Futures	3525.39	3526.85	3525.39	3526.85	372.0
2013-05-21 19:00:00	NQ	Futures	3526.85	3527.43	3525.97	3527.14	192.0
2013-05-21 20:00:00	NQ	Futures	3527.14	3527.72	3524.81	3525.97	269.0
2013-05-21 21:00:00	NQ	Futures	3525.97	3526.27	3524.52	3525.97	295.0
2013-05-21 22:00:00	NQ	Futures	3525.97	3527.14	3525.39	3525.97	187.0
2013-05-21 23:00:00	NQ	Futures	3525.97	3526.27	3523.93	3525.39	447.0
2013-05-21 00:00:00	YM	Futures	15482.6	15484.6	15479.6	15480.6	288.0
2013-05-21 01:00:00	YM	Futures	15482.6	15484.6	15477.6	15481.6	307.0

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

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