PREVIEW / futures_1hour / 2013-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-17.parquet
  size:    50 KB
  rows:    1,507

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-07-17 00:00:00	ES	Futures	1728.81	1729.33	1728.55	1728.81	1765.0
2013-07-17 01:00:00	ES	Futures	1728.81	1729.07	1727.78	1728.55	3305.0
2013-07-17 02:00:00	ES	Futures	1728.3	1729.33	1727.0	1727.78	6477.0
2013-07-17 03:00:00	ES	Futures	1727.52	1729.07	1726.75	1728.81	16576.0
2013-07-17 04:00:00	ES	Futures	1729.07	1729.33	1723.9	1725.97	27535.0
2013-07-17 05:00:00	ES	Futures	1725.97	1725.97	1722.35	1723.13	17424.0
2013-07-17 06:00:00	ES	Futures	1723.13	1726.75	1723.13	1726.75	11681.0
2013-07-17 07:00:00	ES	Futures	1726.75	1729.85	1726.49	1727.0	33941.0
2013-07-17 08:00:00	ES	Futures	1727.0	1734.5	1727.0	1732.43	101545.0
2013-07-17 09:00:00	ES	Futures	1732.43	1735.79	1730.36	1732.69	221462.0
2013-07-17 10:00:00	ES	Futures	1732.69	1737.6	1731.14	1733.72	269264.0
2013-07-17 11:00:00	ES	Futures	1733.98	1735.53	1730.11	1731.4	147190.0
2013-07-17 12:00:00	ES	Futures	1731.4	1735.28	1731.4	1734.24	87967.0
2013-07-17 13:00:00	ES	Futures	1734.24	1735.79	1732.69	1734.5	95703.0
2013-07-17 14:00:00	ES	Futures	1734.5	1735.02	1730.36	1731.4	98991.0
2013-07-17 15:00:00	ES	Futures	1731.4	1733.47	1729.59	1732.17	166168.0
2013-07-17 16:00:00	ES	Futures	1731.92	1733.98	1731.14	1732.43	83187.0
2013-07-17 17:00:00	ES	Futures	1732.43	1733.98	1732.17	1733.47	2106.0
2013-07-17 18:00:00	ES	Futures	1733.72	1733.98	1732.95	1733.21	2529.0
2013-07-17 19:00:00	ES	Futures	1733.21	1733.21	1730.36	1730.88	4852.0
2013-07-17 20:00:00	ES	Futures	1730.88	1731.14	1729.33	1729.33	5944.0
2013-07-17 21:00:00	ES	Futures	1729.59	1730.36	1728.55	1729.85	6444.0
2013-07-17 22:00:00	ES	Futures	1729.85	1730.36	1729.33	1729.59	1949.0
2013-07-17 23:00:00	ES	Futures	1729.85	1730.36	1729.59	1730.11	1912.0
2013-07-17 00:00:00	NQ	Futures	3593.92	3595.38	3593.92	3595.09	240.0
2013-07-17 01:00:00	NQ	Futures	3595.38	3595.96	3593.04	3594.5	387.0
2013-07-17 02:00:00	NQ	Futures	3594.79	3595.96	3591.58	3592.46	741.0
2013-07-17 03:00:00	NQ	Futures	3592.75	3595.38	3591.29	3595.38	2498.0
2013-07-17 04:00:00	NQ	Futures	3595.38	3595.96	3586.32	3589.53	3565.0
2013-07-17 05:00:00	NQ	Futures	3589.24	3589.24	3583.4	3585.44	1916.0
2013-07-17 06:00:00	NQ	Futures	3585.44	3590.99	3585.15	3590.7	1225.0
2013-07-17 07:00:00	NQ	Futures	3590.41	3596.55	3590.41	3591.58	4229.0
2013-07-17 08:00:00	NQ	Futures	3592.16	3603.27	3592.16	3598.59	11405.0
2013-07-17 09:00:00	NQ	Futures	3598.88	3605.61	3594.5	3597.72	31012.0
2013-07-17 10:00:00	NQ	Futures	3597.72	3607.94	3595.09	3599.47	37222.0
2013-07-17 11:00:00	NQ	Futures	3599.76	3602.39	3591.29	3596.55	23138.0
2013-07-17 12:00:00	NQ	Futures	3596.55	3605.02	3595.96	3601.81	10169.0
2013-07-17 13:00:00	NQ	Futures	3601.81	3605.61	3597.42	3600.05	13384.0
2013-07-17 14:00:00	NQ	Futures	3600.05	3601.51	3588.95	3593.04	15829.0
2013-07-17 15:00:00	NQ	Futures	3592.75	3600.64	3591.58	3598.88	19147.0
2013-07-17 16:00:00	NQ	Futures	3598.88	3603.56	3593.92	3593.92	8174.0
2013-07-17 17:00:00	NQ	Futures	3594.21	3596.55	3593.92	3595.96	128.0
2013-07-17 18:00:00	NQ	Futures	3594.79	3595.67	3593.92	3594.5	123.0
2013-07-17 19:00:00	NQ	Futures	3594.5	3594.5	3589.83	3590.99	374.0
2013-07-17 20:00:00	NQ	Futures	3590.99	3591.58	3588.66	3588.95	566.0
2013-07-17 21:00:00	NQ	Futures	3588.95	3590.7	3586.61	3588.95	870.0
2013-07-17 22:00:00	NQ	Futures	3588.66	3590.12	3588.07	3589.24	289.0
2013-07-17 23:00:00	NQ	Futures	3589.53	3590.7	3589.24	3590.12	196.0
2013-07-17 00:00:00	YM	Futures	15637.4	15642.5	15637.4	15638.4	354.0
2013-07-17 01:00:00	YM	Futures	15638.4	15640.5	15628.3	15633.4	359.0

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

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