PREVIEW / futures_1hour / 2013-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-20.parquet
  size:    48 KB
  rows:    1,472

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-20 00:00:00	ES	Futures	1713.71	1714.48	1713.45	1713.97	2014.0
2013-05-20 01:00:00	ES	Futures	1713.97	1714.22	1712.94	1712.94	2117.0
2013-05-20 02:00:00	ES	Futures	1713.19	1714.22	1712.16	1712.68	6470.0
2013-05-20 03:00:00	ES	Futures	1712.42	1713.71	1711.91	1711.91	14453.0
2013-05-20 04:00:00	ES	Futures	1712.16	1713.45	1711.91	1712.94	7566.0
2013-05-20 05:00:00	ES	Futures	1713.19	1713.71	1711.91	1713.19	10414.0
2013-05-20 06:00:00	ES	Futures	1713.19	1713.97	1712.42	1713.19	12273.0
2013-05-20 07:00:00	ES	Futures	1713.19	1713.71	1711.91	1712.68	15942.0
2013-05-20 08:00:00	ES	Futures	1712.68	1713.45	1710.1	1710.62	52448.0
2013-05-20 09:00:00	ES	Futures	1710.88	1716.54	1710.36	1715.25	269565.0
2013-05-20 10:00:00	ES	Futures	1715.0	1717.31	1714.74	1716.54	289009.0
2013-05-20 11:00:00	ES	Futures	1716.54	1720.92	1716.28	1720.41	228279.0
2013-05-20 12:00:00	ES	Futures	1720.41	1721.44	1717.31	1717.83	162521.0
2013-05-20 13:00:00	ES	Futures	1718.09	1718.6	1712.42	1714.74	193082.0
2013-05-20 14:00:00	ES	Futures	1714.74	1716.54	1711.39	1714.74	164366.0
2013-05-20 15:00:00	ES	Futures	1714.74	1716.28	1712.94	1714.74	199129.0
2013-05-20 16:00:00	ES	Futures	1714.74	1715.51	1714.22	1714.48	62838.0
2013-05-20 17:00:00	ES	Futures	1714.74	1714.74	1714.48	1714.48	1196.0
2013-05-20 18:00:00	ES	Futures	1713.97	1714.74	1713.71	1713.71	3236.0
2013-05-20 19:00:00	ES	Futures	1713.97	1714.48	1713.45	1714.48	3189.0
2013-05-20 20:00:00	ES	Futures	1714.48	1714.48	1712.94	1713.45	4018.0
2013-05-20 21:00:00	ES	Futures	1713.45	1713.97	1713.19	1713.97	3029.0
2013-05-20 22:00:00	ES	Futures	1713.71	1714.48	1713.45	1713.71	2137.0
2013-05-20 23:00:00	ES	Futures	1713.71	1714.22	1713.19	1713.97	2505.0
2013-05-20 00:00:00	NQ	Futures	3525.39	3527.14	3525.39	3526.27	364.0
2013-05-20 01:00:00	NQ	Futures	3526.27	3526.56	3523.93	3524.22	782.0
2013-05-20 02:00:00	NQ	Futures	3524.52	3525.97	3522.47	3523.06	535.0
2013-05-20 03:00:00	NQ	Futures	3523.06	3525.1	3521.02	3521.02	1893.0
2013-05-20 04:00:00	NQ	Futures	3521.02	3523.64	3521.02	3523.35	1609.0
2013-05-20 05:00:00	NQ	Futures	3523.35	3525.1	3521.6	3524.22	980.0
2013-05-20 06:00:00	NQ	Futures	3524.22	3525.68	3523.93	3524.81	1511.0
2013-05-20 07:00:00	NQ	Futures	3524.81	3526.27	3521.6	3522.18	3639.0
2013-05-20 08:00:00	NQ	Futures	3522.77	3523.93	3516.64	3517.52	5493.0
2013-05-20 09:00:00	NQ	Futures	3517.22	3530.93	3517.22	3530.06	30935.0
2013-05-20 10:00:00	NQ	Futures	3530.06	3535.6	3525.97	3528.89	28995.0
2013-05-20 11:00:00	NQ	Futures	3528.89	3537.35	3528.6	3535.6	18324.0
2013-05-20 12:00:00	NQ	Futures	3535.6	3537.06	3522.77	3525.1	18893.0
2013-05-20 13:00:00	NQ	Futures	3525.39	3528.6	3514.31	3518.1	25909.0
2013-05-20 14:00:00	NQ	Futures	3518.1	3526.56	3511.68	3522.77	19447.0
2013-05-20 15:00:00	NQ	Futures	3523.06	3528.6	3520.14	3524.81	20803.0
2013-05-20 16:00:00	NQ	Futures	3524.81	3526.85	3523.35	3525.97	5873.0
2013-05-20 17:00:00	NQ	Futures	3525.68	3525.68	3522.47	3522.77	841.0
2013-05-20 18:00:00	NQ	Futures	3522.77	3523.93	3522.18	3522.18	501.0
2013-05-20 19:00:00	NQ	Futures	3521.89	3523.35	3521.6	3523.06	150.0
2013-05-20 20:00:00	NQ	Futures	3523.06	3523.35	3521.31	3522.47	414.0
2013-05-20 21:00:00	NQ	Futures	3522.77	3523.35	3521.89	3523.35	470.0
2013-05-20 22:00:00	NQ	Futures	3523.35	3525.1	3523.06	3523.64	426.0
2013-05-20 23:00:00	NQ	Futures	3523.93	3524.22	3523.06	3524.22	171.0
2013-05-20 00:00:00	YM	Futures	15483.6	15489.7	15483.6	15488.7	372.0
2013-05-20 01:00:00	YM	Futures	15487.7	15487.7	15479.6	15480.6	265.0

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

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