PREVIEW / futures_1hour / 2013-09-10

all futures 1-hour files

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

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-09-10 00:00:00	ES	Futures	1726.23	1727.52	1726.23	1727.52	1768.0
2013-09-10 01:00:00	ES	Futures	1727.26	1729.59	1727.26	1728.81	6804.0
2013-09-10 02:00:00	ES	Futures	1728.81	1729.85	1727.52	1729.33	10028.0
2013-09-10 03:00:00	ES	Futures	1729.33	1734.24	1728.3	1733.21	40722.0
2013-09-10 04:00:00	ES	Futures	1733.21	1734.76	1732.95	1733.47	18261.0
2013-09-10 05:00:00	ES	Futures	1733.47	1734.76	1732.69	1734.24	16317.0
2013-09-10 06:00:00	ES	Futures	1734.24	1735.53	1733.98	1734.5	16256.0
2013-09-10 07:00:00	ES	Futures	1734.24	1738.38	1733.98	1737.09	62516.0
2013-09-10 08:00:00	ES	Futures	1736.83	1737.86	1735.53	1736.05	45337.0
2013-09-10 09:00:00	ES	Futures	1736.31	1738.38	1733.72	1736.57	232093.0
2013-09-10 10:00:00	ES	Futures	1736.83	1740.19	1736.05	1738.89	271273.0
2013-09-10 11:00:00	ES	Futures	1738.89	1739.41	1733.72	1735.53	232422.0
2013-09-10 12:00:00	ES	Futures	1735.79	1738.38	1735.53	1737.86	119399.0
2013-09-10 13:00:00	ES	Futures	1737.6	1739.15	1736.05	1738.12	179619.0
2013-09-10 14:00:00	ES	Futures	1738.38	1739.15	1736.31	1738.64	148377.0
2013-09-10 15:00:00	ES	Futures	1738.64	1740.45	1737.34	1740.45	227293.0
2013-09-10 16:00:00	ES	Futures	1740.19	1740.45	1738.89	1739.93	92523.0
2013-09-10 17:00:00	ES	Futures	1739.67	1740.19	1739.41	1739.93	2504.0
2013-09-10 18:00:00	ES	Futures	1739.41	1739.67	1738.64	1739.15	5117.0
2013-09-10 19:00:00	ES	Futures	1739.15	1739.15	1738.12	1738.64	3264.0
2013-09-10 20:00:00	ES	Futures	1738.64	1738.64	1737.34	1738.12	5043.0
2013-09-10 21:00:00	ES	Futures	1738.12	1741.22	1736.83	1738.89	19899.0
2013-09-10 22:00:00	ES	Futures	1738.89	1739.93	1737.6	1738.38	4594.0
2013-09-10 23:00:00	ES	Futures	1738.12	1738.38	1737.09	1738.38	4569.0
2013-09-10 00:00:00	NQ	Futures	3704.67	3707.01	3704.67	3706.14	242.0
2013-09-10 01:00:00	NQ	Futures	3706.72	3711.1	3706.43	3710.81	846.0
2013-09-10 02:00:00	NQ	Futures	3710.52	3712.56	3707.3	3712.27	1368.0
2013-09-10 03:00:00	NQ	Futures	3711.98	3720.75	3710.23	3719.29	4269.0
2013-09-10 04:00:00	NQ	Futures	3719.29	3721.92	3718.12	3718.41	2467.0
2013-09-10 05:00:00	NQ	Futures	3718.12	3721.62	3716.95	3721.04	2113.0
2013-09-10 06:00:00	NQ	Futures	3721.04	3722.79	3720.75	3721.04	2198.0
2013-09-10 07:00:00	NQ	Futures	3721.33	3728.05	3719.87	3725.13	7445.0
2013-09-10 08:00:00	NQ	Futures	3725.13	3726.3	3721.04	3722.21	4588.0
2013-09-10 09:00:00	NQ	Futures	3721.92	3726.3	3716.36	3720.16	33018.0
2013-09-10 10:00:00	NQ	Futures	3720.75	3727.47	3716.07	3721.92	38726.0
2013-09-10 11:00:00	NQ	Futures	3722.21	3728.05	3717.82	3720.45	16975.0
2013-09-10 12:00:00	NQ	Futures	3720.75	3722.21	3714.03	3721.04	16590.0
2013-09-10 13:00:00	NQ	Futures	3721.04	3726.3	3715.78	3724.25	23314.0
2013-09-10 14:00:00	NQ	Futures	3724.25	3726.59	3709.35	3720.16	32979.0
2013-09-10 15:00:00	NQ	Futures	3720.16	3724.84	3715.78	3722.21	29050.0
2013-09-10 16:00:00	NQ	Futures	3722.21	3723.67	3720.16	3722.5	6338.0
2013-09-10 17:00:00	NQ	Futures	3722.79	3723.67	3722.79	3723.67	297.0
2013-09-10 18:00:00	NQ	Futures	3722.21	3722.79	3719.87	3720.75	333.0
2013-09-10 19:00:00	NQ	Futures	3720.75	3720.75	3718.7	3718.99	363.0
2013-09-10 20:00:00	NQ	Futures	3718.7	3719.58	3717.82	3718.99	514.0
2013-09-10 21:00:00	NQ	Futures	3719.29	3727.47	3717.24	3721.92	2238.0
2013-09-10 22:00:00	NQ	Futures	3722.21	3722.79	3718.7	3720.45	727.0
2013-09-10 23:00:00	NQ	Futures	3719.58	3720.45	3717.82	3719.58	516.0
2013-09-10 00:00:00	YM	Futures	15281.9	15289.1	15281.9	15285.0	18.0
2013-09-10 01:00:00	YM	Futures	15290.1	15314.6	15288.1	15307.5	11.0

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

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