PREVIEW / futures_1hour / 2013-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-30.parquet
  size:    41 KB
  rows:    1,232

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-08-30 00:00:00	ES	Futures	1697.54	1699.09	1697.28	1698.83	9346.0
2013-08-30 01:00:00	ES	Futures	1698.83	1700.9	1697.79	1698.31	17898.0
2013-08-30 02:00:00	ES	Futures	1698.05	1699.6	1697.54	1698.83	9095.0
2013-08-30 03:00:00	ES	Futures	1698.83	1699.86	1693.4	1694.43	26695.0
2013-08-30 04:00:00	ES	Futures	1694.43	1694.95	1691.85	1694.17	24557.0
2013-08-30 05:00:00	ES	Futures	1694.17	1696.5	1693.4	1695.47	19703.0
2013-08-30 06:00:00	ES	Futures	1695.47	1697.02	1694.95	1696.76	12561.0
2013-08-30 07:00:00	ES	Futures	1696.76	1696.76	1693.4	1695.47	23995.0
2013-08-30 08:00:00	ES	Futures	1695.47	1695.98	1692.11	1693.92	33551.0
2013-08-30 09:00:00	ES	Futures	1693.66	1695.73	1690.04	1691.07	202976.0
2013-08-30 10:00:00	ES	Futures	1691.07	1691.33	1684.87	1685.9	286657.0
2013-08-30 11:00:00	ES	Futures	1685.9	1688.75	1683.84	1685.13	223209.0
2013-08-30 12:00:00	ES	Futures	1684.87	1687.97	1684.35	1687.2	115549.0
2013-08-30 13:00:00	ES	Futures	1687.2	1690.3	1681.25	1684.87	263418.0
2013-08-30 14:00:00	ES	Futures	1684.87	1689.01	1683.84	1687.97	132721.0
2013-08-30 15:00:00	ES	Futures	1687.97	1689.52	1680.73	1685.13	343954.0
2013-08-30 16:00:00	ES	Futures	1685.13	1689.26	1683.84	1687.71	121092.0
2013-08-30 17:00:00	ES	Futures	1687.45	1688.23	1687.45	1687.71	2654.0
2013-08-30 00:00:00	NQ	Futures	3622.26	3624.31	3621.39	3623.72	1134.0
2013-08-30 01:00:00	NQ	Futures	3623.43	3627.82	3621.68	3621.97	1423.0
2013-08-30 02:00:00	NQ	Futures	3621.39	3624.02	3620.51	3623.43	2088.0
2013-08-30 03:00:00	NQ	Futures	3623.14	3625.77	3613.5	3614.96	5740.0
2013-08-30 04:00:00	NQ	Futures	3614.96	3617.0	3610.57	3616.71	4038.0
2013-08-30 05:00:00	NQ	Futures	3616.71	3621.97	3614.08	3619.34	3468.0
2013-08-30 06:00:00	NQ	Futures	3619.63	3622.85	3619.05	3621.68	2998.0
2013-08-30 07:00:00	NQ	Futures	3621.97	3621.97	3615.54	3619.63	2167.0
2013-08-30 08:00:00	NQ	Futures	3619.63	3619.93	3612.33	3615.54	5283.0
2013-08-30 09:00:00	NQ	Futures	3615.25	3620.22	3602.68	3605.31	36421.0
2013-08-30 10:00:00	NQ	Futures	3605.02	3605.61	3588.95	3590.99	41093.0
2013-08-30 11:00:00	NQ	Futures	3590.99	3597.13	3585.44	3589.24	25174.0
2013-08-30 12:00:00	NQ	Futures	3588.95	3596.55	3586.9	3594.21	15508.0
2013-08-30 13:00:00	NQ	Futures	3594.21	3600.05	3579.3	3589.53	37359.0
2013-08-30 14:00:00	NQ	Futures	3589.83	3598.59	3587.49	3595.38	17109.0
2013-08-30 15:00:00	NQ	Futures	3595.09	3598.3	3583.4	3592.16	36364.0
2013-08-30 16:00:00	NQ	Futures	3592.16	3602.39	3590.99	3599.47	10437.0
2013-08-30 17:00:00	NQ	Futures	3599.47	3600.05	3598.3	3599.47	129.0
2013-08-30 00:00:00	YM	Futures	15103.2	15111.3	15101.1	15109.3	427.0
2013-08-30 01:00:00	YM	Futures	15110.3	15127.6	15104.2	15107.2	1093.0
2013-08-30 02:00:00	YM	Futures	15106.2	15115.4	15101.1	15109.3	918.0
2013-08-30 03:00:00	YM	Futures	15110.3	15120.4	15068.6	15077.8	2924.0
2013-08-30 04:00:00	YM	Futures	15076.8	15082.9	15055.4	15077.8	3076.0
2013-08-30 05:00:00	YM	Futures	15077.8	15094.0	15068.6	15080.8	2304.0
2013-08-30 06:00:00	YM	Futures	15082.9	15096.1	15078.8	15095.1	834.0
2013-08-30 07:00:00	YM	Futures	15095.1	15095.1	15069.7	15083.9	1439.0
2013-08-30 08:00:00	YM	Futures	15085.9	15087.9	15054.4	15066.6	3010.0
2013-08-30 09:00:00	YM	Futures	15066.6	15085.9	15028.0	15043.3	15421.0
2013-08-30 10:00:00	YM	Futures	15042.2	15045.3	15000.6	15009.7	20110.0
2013-08-30 11:00:00	YM	Futures	15009.7	15030.1	14990.4	15001.6	13733.0
2013-08-30 12:00:00	YM	Futures	15001.6	15027.0	14997.5	15020.9	8584.0
2013-08-30 13:00:00	YM	Futures	15018.9	15047.3	14976.2	15009.7	23862.0

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

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