PREVIEW / futures_1hour / 2013-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-10.parquet
  size:    46 KB
  rows:    1,391

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-06-10 00:00:00	ES	Futures	1690.53	1690.78	1690.01	1690.27	2146.0
2013-06-10 01:00:00	ES	Futures	1690.27	1691.56	1689.75	1691.3	5318.0
2013-06-10 02:00:00	ES	Futures	1691.3	1693.36	1690.78	1693.1	11773.0
2013-06-10 03:00:00	ES	Futures	1693.1	1694.39	1691.3	1693.36	27623.0
2013-06-10 04:00:00	ES	Futures	1693.62	1696.19	1693.1	1695.16	25754.0
2013-06-10 05:00:00	ES	Futures	1695.42	1695.68	1693.87	1695.16	11452.0
2013-06-10 06:00:00	ES	Futures	1695.16	1695.42	1693.62	1694.39	14344.0
2013-06-10 07:00:00	ES	Futures	1694.65	1696.71	1693.87	1694.9	35096.0
2013-06-10 08:00:00	ES	Futures	1694.9	1695.94	1691.3	1694.9	73961.0
2013-06-10 09:00:00	ES	Futures	1694.9	1698.51	1690.53	1691.81	307964.0
2013-06-10 10:00:00	ES	Futures	1692.07	1696.19	1687.95	1694.39	315681.0
2013-06-10 11:00:00	ES	Futures	1694.39	1696.97	1692.59	1695.16	220727.0
2013-06-10 12:00:00	ES	Futures	1695.16	1697.22	1691.3	1691.81	146190.0
2013-06-10 13:00:00	ES	Futures	1692.07	1693.36	1689.5	1692.07	125440.0
2013-06-10 14:00:00	ES	Futures	1691.81	1694.13	1688.72	1693.87	122442.0
2013-06-10 15:00:00	ES	Futures	1693.87	1694.13	1689.24	1691.81	163360.0
2013-06-10 16:00:00	ES	Futures	1691.81	1692.84	1691.3	1691.81	51855.0
2013-06-10 17:00:00	ES	Futures	1691.81	1692.07	1691.56	1691.81	1329.0
2013-06-10 18:00:00	ES	Futures	1691.81	1692.33	1690.78	1691.3	3312.0
2013-06-10 19:00:00	ES	Futures	1691.56	1691.81	1691.04	1691.56	982.0
2013-06-10 20:00:00	ES	Futures	1691.3	1691.56	1690.01	1691.04	4067.0
2013-06-10 21:00:00	ES	Futures	1691.3	1692.07	1690.53	1691.3	4525.0
2013-06-10 22:00:00	ES	Futures	1691.3	1691.81	1689.24	1689.5	4993.0
2013-06-10 23:00:00	ES	Futures	1689.75	1690.01	1687.95	1688.98	11145.0
2013-06-10 00:00:00	NQ	Futures	3484.56	3486.31	3483.97	3484.56	335.0
2013-06-10 01:00:00	NQ	Futures	3484.56	3486.89	3483.68	3486.89	456.0
2013-06-10 02:00:00	NQ	Futures	3486.89	3488.93	3486.31	3488.35	648.0
2013-06-10 03:00:00	NQ	Futures	3488.06	3491.56	3485.72	3489.52	2945.0
2013-06-10 04:00:00	NQ	Futures	3489.81	3493.31	3488.35	3491.56	3891.0
2013-06-10 05:00:00	NQ	Futures	3491.56	3492.43	3488.35	3490.97	1988.0
2013-06-10 06:00:00	NQ	Futures	3490.97	3491.27	3487.47	3488.93	2544.0
2013-06-10 07:00:00	NQ	Futures	3489.22	3492.72	3488.64	3490.1	3396.0
2013-06-10 08:00:00	NQ	Futures	3490.1	3490.39	3481.93	3488.06	7280.0
2013-06-10 09:00:00	NQ	Futures	3488.06	3494.77	3484.85	3490.68	47967.0
2013-06-10 10:00:00	NQ	Futures	3490.68	3502.35	3483.97	3498.85	41652.0
2013-06-10 11:00:00	NQ	Futures	3498.56	3503.52	3495.64	3500.89	36272.0
2013-06-10 12:00:00	NQ	Futures	3501.18	3504.68	3491.56	3492.43	21900.0
2013-06-10 13:00:00	NQ	Futures	3492.43	3496.81	3485.43	3491.56	16558.0
2013-06-10 14:00:00	NQ	Futures	3491.27	3494.47	3480.77	3491.85	20584.0
2013-06-10 15:00:00	NQ	Futures	3491.56	3491.85	3482.81	3488.06	23262.0
2013-06-10 16:00:00	NQ	Futures	3487.77	3488.64	3485.43	3485.43	3217.0
2013-06-10 17:00:00	NQ	Futures	3486.02	3486.31	3485.43	3485.72	39.0
2013-06-10 18:00:00	NQ	Futures	3485.72	3487.18	3483.68	3484.56	404.0
2013-06-10 19:00:00	NQ	Futures	3484.85	3485.72	3484.27	3484.56	191.0
2013-06-10 20:00:00	NQ	Futures	3484.85	3486.02	3482.81	3485.72	603.0
2013-06-10 21:00:00	NQ	Futures	3485.43	3486.6	3484.27	3485.14	363.0
2013-06-10 22:00:00	NQ	Futures	3485.43	3486.02	3480.77	3481.35	853.0
2013-06-10 23:00:00	NQ	Futures	3481.64	3483.1	3479.31	3480.47	1497.0
2013-06-10 00:00:00	YM	Futures	15392.6	15399.8	15392.6	15399.8	8.0
2013-06-10 01:00:00	YM	Futures	15396.7	15396.7	15392.6	15395.7	15.0

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

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