PREVIEW / futures_1hour / 2013-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-08.parquet
  size:    49 KB
  rows:    1,504

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-08 00:00:00	ES	Futures	1685.13	1685.13	1683.58	1684.35	3220.0
2013-07-08 01:00:00	ES	Futures	1684.35	1684.61	1682.28	1682.8	6744.0
2013-07-08 02:00:00	ES	Futures	1682.8	1685.13	1681.25	1684.87	9652.0
2013-07-08 03:00:00	ES	Futures	1684.61	1689.01	1683.58	1687.97	34890.0
2013-07-08 04:00:00	ES	Futures	1687.97	1688.75	1686.16	1688.23	14605.0
2013-07-08 05:00:00	ES	Futures	1688.23	1693.66	1687.97	1692.37	38125.0
2013-07-08 06:00:00	ES	Futures	1692.11	1693.66	1691.33	1691.59	20303.0
2013-07-08 07:00:00	ES	Futures	1691.59	1692.37	1690.04	1692.11	24966.0
2013-07-08 08:00:00	ES	Futures	1692.11	1692.62	1689.26	1689.78	30206.0
2013-07-08 09:00:00	ES	Futures	1689.78	1692.88	1687.2	1692.11	223673.0
2013-07-08 10:00:00	ES	Futures	1691.85	1695.21	1691.07	1691.85	250951.0
2013-07-08 11:00:00	ES	Futures	1691.85	1693.66	1687.45	1688.49	147788.0
2013-07-08 12:00:00	ES	Futures	1688.49	1690.04	1686.68	1687.97	110063.0
2013-07-08 13:00:00	ES	Futures	1687.71	1691.59	1686.68	1691.07	72606.0
2013-07-08 14:00:00	ES	Futures	1691.07	1692.37	1689.26	1691.59	65715.0
2013-07-08 15:00:00	ES	Futures	1691.59	1691.59	1687.71	1689.78	151031.0
2013-07-08 16:00:00	ES	Futures	1689.78	1693.14	1689.52	1692.62	63426.0
2013-07-08 17:00:00	ES	Futures	1692.88	1693.14	1692.37	1692.62	1686.0
2013-07-08 18:00:00	ES	Futures	1692.37	1692.62	1691.59	1692.11	2945.0
2013-07-08 19:00:00	ES	Futures	1692.11	1693.4	1692.11	1693.14	2667.0
2013-07-08 20:00:00	ES	Futures	1693.14	1693.4	1691.33	1692.37	3942.0
2013-07-08 21:00:00	ES	Futures	1692.37	1697.54	1691.59	1696.5	13559.0
2013-07-08 22:00:00	ES	Futures	1696.5	1697.28	1695.21	1695.73	5251.0
2013-07-08 23:00:00	ES	Futures	1695.47	1697.02	1694.95	1697.02	3878.0
2013-07-08 00:00:00	NQ	Futures	3467.38	3467.38	3464.16	3466.21	346.0
2013-07-08 01:00:00	NQ	Futures	3466.21	3466.21	3462.41	3463.58	586.0
2013-07-08 02:00:00	NQ	Futures	3463.29	3467.96	3460.66	3467.96	762.0
2013-07-08 03:00:00	NQ	Futures	3467.38	3474.39	3465.92	3471.76	4669.0
2013-07-08 04:00:00	NQ	Futures	3471.76	3472.35	3467.09	3470.89	1940.0
2013-07-08 05:00:00	NQ	Futures	3471.18	3480.24	3470.89	3478.19	3114.0
2013-07-08 06:00:00	NQ	Futures	3478.19	3481.41	3476.15	3476.44	2222.0
2013-07-08 07:00:00	NQ	Futures	3476.15	3477.61	3473.81	3477.02	3607.0
2013-07-08 08:00:00	NQ	Futures	3477.02	3478.19	3472.64	3473.22	3470.0
2013-07-08 09:00:00	NQ	Futures	3473.22	3476.73	3465.33	3468.55	37751.0
2013-07-08 10:00:00	NQ	Futures	3468.55	3475.85	3456.57	3459.2	43510.0
2013-07-08 11:00:00	NQ	Futures	3458.9	3463.58	3451.89	3452.77	25113.0
2013-07-08 12:00:00	NQ	Futures	3452.77	3455.69	3446.92	3449.55	26128.0
2013-07-08 13:00:00	NQ	Futures	3449.26	3457.15	3447.51	3455.1	11349.0
2013-07-08 14:00:00	NQ	Futures	3455.69	3458.9	3451.01	3457.44	8930.0
2013-07-08 15:00:00	NQ	Futures	3457.73	3460.36	3451.01	3459.78	18193.0
2013-07-08 16:00:00	NQ	Futures	3459.49	3464.16	3458.9	3462.99	3847.0
2013-07-08 17:00:00	NQ	Futures	3463.29	3463.58	3462.7	3462.7	87.0
2013-07-08 18:00:00	NQ	Futures	3461.24	3461.53	3460.36	3460.66	195.0
2013-07-08 19:00:00	NQ	Futures	3460.66	3462.41	3460.66	3462.41	262.0
2013-07-08 20:00:00	NQ	Futures	3462.12	3462.99	3458.9	3460.36	491.0
2013-07-08 21:00:00	NQ	Futures	3460.66	3470.59	3459.2	3469.13	1651.0
2013-07-08 22:00:00	NQ	Futures	3469.13	3470.01	3466.5	3468.26	819.0
2013-07-08 23:00:00	NQ	Futures	3467.96	3470.01	3466.79	3469.72	426.0
2013-07-08 00:00:00	YM	Futures	15324.6	15325.6	15313.4	15323.6	534.0
2013-07-08 01:00:00	YM	Futures	15322.6	15322.6	15304.3	15309.4	1169.0

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

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