PREVIEW / futures_1hour / 2013-08-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	1715.11	1715.37	1713.56	1715.11	3427.0
2013-08-16 01:00:00	ES	Futures	1715.11	1715.11	1709.94	1711.75	11457.0
2013-08-16 02:00:00	ES	Futures	1711.75	1715.11	1711.49	1714.6	9791.0
2013-08-16 03:00:00	ES	Futures	1714.6	1717.7	1713.56	1716.15	32125.0
2013-08-16 04:00:00	ES	Futures	1715.89	1716.41	1713.05	1715.11	15920.0
2013-08-16 05:00:00	ES	Futures	1715.11	1716.15	1713.56	1715.63	16660.0
2013-08-16 06:00:00	ES	Futures	1715.89	1717.7	1715.63	1716.15	20088.0
2013-08-16 07:00:00	ES	Futures	1716.41	1718.47	1715.89	1716.41	25247.0
2013-08-16 08:00:00	ES	Futures	1716.41	1716.66	1713.82	1714.34	32961.0
2013-08-16 09:00:00	ES	Futures	1714.08	1715.11	1709.94	1714.34	286783.0
2013-08-16 10:00:00	ES	Futures	1714.6	1717.7	1711.75	1716.92	257152.0
2013-08-16 11:00:00	ES	Futures	1716.92	1717.96	1713.05	1715.89	189479.0
2013-08-16 12:00:00	ES	Futures	1715.89	1716.41	1710.98	1711.49	128009.0
2013-08-16 13:00:00	ES	Futures	1711.75	1712.27	1706.32	1708.91	188212.0
2013-08-16 14:00:00	ES	Futures	1708.91	1712.27	1705.55	1711.75	175344.0
2013-08-16 15:00:00	ES	Futures	1712.01	1714.08	1708.91	1709.68	211227.0
2013-08-16 16:00:00	ES	Futures	1709.68	1710.2	1706.32	1706.58	84618.0
2013-08-16 17:00:00	ES	Futures	1706.58	1707.1	1706.07	1706.32	2538.0
2013-08-16 00:00:00	NQ	Futures	3596.25	3597.13	3593.92	3597.13	475.0
2013-08-16 01:00:00	NQ	Futures	3596.55	3596.84	3586.61	3590.12	1573.0
2013-08-16 02:00:00	NQ	Futures	3590.7	3598.3	3590.7	3596.84	1111.0
2013-08-16 03:00:00	NQ	Futures	3597.13	3602.1	3594.5	3599.47	4917.0
2013-08-16 04:00:00	NQ	Futures	3599.18	3599.76	3593.62	3596.84	2716.0
2013-08-16 05:00:00	NQ	Futures	3597.13	3599.18	3593.04	3598.01	3053.0
2013-08-16 06:00:00	NQ	Futures	3598.3	3600.35	3597.72	3598.3	2824.0
2013-08-16 07:00:00	NQ	Futures	3598.01	3600.05	3597.42	3598.88	3038.0
2013-08-16 08:00:00	NQ	Futures	3599.18	3599.47	3595.38	3595.96	2557.0
2013-08-16 09:00:00	NQ	Futures	3595.96	3602.68	3586.9	3601.22	35104.0
2013-08-16 10:00:00	NQ	Futures	3601.22	3610.87	3594.79	3609.41	32834.0
2013-08-16 11:00:00	NQ	Futures	3609.41	3612.04	3601.81	3606.78	18072.0
2013-08-16 12:00:00	NQ	Futures	3606.78	3608.82	3598.01	3600.93	13321.0
2013-08-16 13:00:00	NQ	Futures	3600.93	3602.39	3590.99	3596.25	19184.0
2013-08-16 14:00:00	NQ	Futures	3596.25	3600.64	3590.12	3599.76	16060.0
2013-08-16 15:00:00	NQ	Futures	3599.76	3603.56	3591.29	3592.46	20117.0
2013-08-16 16:00:00	NQ	Futures	3592.16	3593.04	3587.49	3588.36	6485.0
2013-08-16 17:00:00	NQ	Futures	3588.07	3588.36	3587.2	3587.2	153.0
2013-08-16 00:00:00	YM	Futures	15330.7	15333.7	15321.6	15333.7	405.0
2013-08-16 01:00:00	YM	Futures	15332.7	15332.7	15288.0	15300.2	2267.0
2013-08-16 02:00:00	YM	Futures	15300.2	15327.6	15299.2	15320.5	1692.0
2013-08-16 03:00:00	YM	Futures	15320.5	15333.7	15312.4	15326.6	4673.0
2013-08-16 04:00:00	YM	Futures	15326.6	15327.6	15307.3	15314.4	2667.0
2013-08-16 05:00:00	YM	Futures	15314.4	15322.6	15305.3	15320.5	1339.0
2013-08-16 06:00:00	YM	Futures	15321.6	15331.7	15318.5	15323.6	1833.0
2013-08-16 07:00:00	YM	Futures	15323.6	15337.8	15322.6	15324.6	1723.0
2013-08-16 08:00:00	YM	Futures	15325.6	15328.7	15311.4	15313.4	1974.0
2013-08-16 09:00:00	YM	Futures	15312.4	15331.7	15288.0	15329.7	21420.0
2013-08-16 10:00:00	YM	Futures	15329.7	15350.0	15303.3	15337.8	24264.0
2013-08-16 11:00:00	YM	Futures	15337.8	15348.0	15309.4	15331.7	13166.0
2013-08-16 12:00:00	YM	Futures	15330.7	15332.7	15297.2	15302.3	11580.0
2013-08-16 13:00:00	YM	Futures	15303.3	15307.3	15267.7	15285.0	15367.0

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

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