PREVIEW / futures_1hour / 2013-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-01.parquet
  size:    45 KB
  rows:    1,349

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-01 00:00:00	ES	Futures	1640.3	1640.55	1639.78	1640.04	1127.0
2013-05-01 01:00:00	ES	Futures	1640.3	1640.55	1640.04	1640.04	1064.0
2013-05-01 02:00:00	ES	Futures	1640.3	1640.3	1639.78	1640.04	2294.0
2013-05-01 03:00:00	ES	Futures	1640.3	1642.1	1639.78	1641.84	6576.0
2013-05-01 04:00:00	ES	Futures	1641.84	1643.39	1641.58	1643.39	8423.0
2013-05-01 05:00:00	ES	Futures	1643.39	1643.65	1642.1	1642.36	6187.0
2013-05-01 06:00:00	ES	Futures	1642.36	1643.13	1641.58	1642.87	10759.0
2013-05-01 07:00:00	ES	Futures	1642.87	1643.9	1641.58	1642.1	16905.0
2013-05-01 08:00:00	ES	Futures	1641.84	1642.36	1637.98	1638.24	53880.0
2013-05-01 09:00:00	ES	Futures	1638.49	1638.49	1634.12	1635.15	198605.0
2013-05-01 10:00:00	ES	Futures	1635.15	1637.46	1630.77	1635.66	243588.0
2013-05-01 11:00:00	ES	Futures	1635.92	1636.43	1632.83	1635.66	101400.0
2013-05-01 12:00:00	ES	Futures	1635.4	1635.92	1631.28	1631.54	71177.0
2013-05-01 13:00:00	ES	Futures	1631.54	1632.05	1627.42	1629.22	153283.0
2013-05-01 14:00:00	ES	Futures	1629.22	1634.37	1628.96	1631.8	213388.0
2013-05-01 15:00:00	ES	Futures	1631.8	1632.31	1623.81	1626.13	258850.0
2013-05-01 16:00:00	ES	Futures	1626.13	1626.9	1624.33	1626.65	99567.0
2013-05-01 17:00:00	ES	Futures	1626.39	1627.16	1626.39	1626.65	1861.0
2013-05-01 18:00:00	ES	Futures	1627.16	1628.45	1626.9	1628.19	6713.0
2013-05-01 19:00:00	ES	Futures	1627.93	1628.45	1626.65	1627.16	2521.0
2013-05-01 20:00:00	ES	Futures	1627.16	1629.74	1626.9	1628.71	6987.0
2013-05-01 21:00:00	ES	Futures	1628.71	1629.22	1627.16	1627.93	4433.0
2013-05-01 22:00:00	ES	Futures	1628.19	1629.22	1627.93	1629.22	2578.0
2013-05-01 23:00:00	ES	Futures	1628.96	1629.99	1628.96	1629.22	3387.0
2013-05-01 00:00:00	NQ	Futures	3361.77	3362.93	3361.47	3361.47	129.0
2013-05-01 01:00:00	NQ	Futures	3361.77	3362.06	3361.47	3361.47	67.0
2013-05-01 02:00:00	NQ	Futures	3361.47	3361.77	3360.6	3360.6	126.0
2013-05-01 03:00:00	NQ	Futures	3360.6	3362.64	3360.6	3361.77	594.0
2013-05-01 04:00:00	NQ	Futures	3361.47	3366.43	3361.18	3366.14	829.0
2013-05-01 05:00:00	NQ	Futures	3366.43	3367.02	3362.35	3363.22	1021.0
2013-05-01 06:00:00	NQ	Futures	3363.22	3364.39	3361.77	3362.93	1057.0
2013-05-01 07:00:00	NQ	Futures	3362.64	3366.43	3361.77	3363.81	2654.0
2013-05-01 08:00:00	NQ	Futures	3363.81	3366.72	3360.31	3360.89	6216.0
2013-05-01 09:00:00	NQ	Futures	3361.18	3368.18	3355.93	3359.14	23605.0
2013-05-01 10:00:00	NQ	Futures	3359.72	3363.22	3345.72	3357.68	26489.0
2013-05-01 11:00:00	NQ	Futures	3357.68	3361.47	3353.02	3359.43	11629.0
2013-05-01 12:00:00	NQ	Futures	3359.43	3360.02	3350.68	3350.97	8028.0
2013-05-01 13:00:00	NQ	Futures	3351.27	3351.56	3343.39	3347.77	12884.0
2013-05-01 14:00:00	NQ	Futures	3348.06	3358.27	3346.6	3355.35	20445.0
2013-05-01 15:00:00	NQ	Futures	3355.06	3357.39	3339.31	3346.6	27965.0
2013-05-01 16:00:00	NQ	Futures	3346.6	3346.89	3340.77	3344.56	7671.0
2013-05-01 17:00:00	NQ	Futures	3344.56	3345.43	3344.56	3344.85	331.0
2013-05-01 18:00:00	NQ	Futures	3346.02	3348.35	3345.43	3348.06	467.0
2013-05-01 19:00:00	NQ	Futures	3348.35	3348.64	3345.14	3346.02	312.0
2013-05-01 20:00:00	NQ	Futures	3346.02	3351.27	3345.72	3348.93	538.0
2013-05-01 21:00:00	NQ	Futures	3349.22	3350.1	3345.43	3348.06	534.0
2013-05-01 22:00:00	NQ	Futures	3348.06	3350.68	3347.77	3350.39	219.0
2013-05-01 23:00:00	NQ	Futures	3350.68	3351.27	3349.81	3349.81	294.0
2013-05-01 00:00:00	YM	Futures	14934.7	14941.8	14933.7	14936.7	221.0
2013-05-01 01:00:00	YM	Futures	14937.7	14940.8	14936.7	14937.7	73.0

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

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