PREVIEW / futures_1hour / 2013-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-17.parquet
  size:    48 KB
  rows:    1,461

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-06-17 00:00:00	ES	Futures	1680.22	1680.73	1679.7	1679.96	2132.0
2013-06-17 01:00:00	ES	Futures	1679.96	1681.77	1679.7	1681.77	3271.0
2013-06-17 02:00:00	ES	Futures	1681.77	1686.16	1681.51	1684.61	13473.0
2013-06-17 03:00:00	ES	Futures	1684.61	1688.75	1683.32	1687.97	32320.0
2013-06-17 04:00:00	ES	Futures	1687.97	1688.75	1685.64	1686.94	13452.0
2013-06-17 05:00:00	ES	Futures	1686.94	1689.52	1686.68	1689.01	12751.0
2013-06-17 06:00:00	ES	Futures	1689.01	1690.3	1687.45	1687.97	20751.0
2013-06-17 07:00:00	ES	Futures	1688.23	1688.75	1684.87	1685.64	37676.0
2013-06-17 08:00:00	ES	Futures	1685.64	1687.45	1684.35	1686.42	39441.0
2013-06-17 09:00:00	ES	Futures	1686.42	1693.92	1685.13	1692.37	242226.0
2013-06-17 10:00:00	ES	Futures	1692.62	1694.95	1690.81	1694.43	208081.0
2013-06-17 11:00:00	ES	Futures	1694.69	1696.76	1691.85	1693.14	152946.0
2013-06-17 12:00:00	ES	Futures	1693.14	1693.66	1691.59	1692.62	69441.0
2013-06-17 13:00:00	ES	Futures	1692.37	1695.21	1691.33	1693.92	70587.0
2013-06-17 14:00:00	ES	Futures	1694.17	1694.43	1678.92	1680.99	285224.0
2013-06-17 15:00:00	ES	Futures	1681.25	1690.56	1679.7	1688.49	292251.0
2013-06-17 16:00:00	ES	Futures	1688.49	1690.81	1687.71	1690.3	62759.0
2013-06-17 17:00:00	ES	Futures	1690.3	1691.33	1690.04	1690.81	2472.0
2013-06-17 18:00:00	ES	Futures	1690.3	1691.07	1689.52	1690.56	3882.0
2013-06-17 19:00:00	ES	Futures	1690.3	1690.81	1689.52	1689.52	1783.0
2013-06-17 20:00:00	ES	Futures	1689.52	1691.07	1689.01	1689.26	3607.0
2013-06-17 21:00:00	ES	Futures	1689.26	1689.52	1687.71	1688.23	2823.0
2013-06-17 22:00:00	ES	Futures	1688.49	1689.01	1687.71	1688.49	2444.0
2013-06-17 23:00:00	ES	Futures	1688.49	1689.78	1687.71	1689.01	6285.0
2013-06-17 00:00:00	NQ	Futures	3447.8	3448.09	3446.05	3446.34	226.0
2013-06-17 01:00:00	NQ	Futures	3446.34	3450.14	3445.46	3450.14	154.0
2013-06-17 02:00:00	NQ	Futures	3449.84	3459.2	3449.84	3456.86	650.0
2013-06-17 03:00:00	NQ	Futures	3457.15	3470.01	3455.98	3468.26	5353.0
2013-06-17 04:00:00	NQ	Futures	3468.55	3469.13	3463.87	3465.92	1894.0
2013-06-17 05:00:00	NQ	Futures	3466.21	3470.89	3465.92	3468.55	1878.0
2013-06-17 06:00:00	NQ	Futures	3468.84	3471.18	3466.21	3467.38	2608.0
2013-06-17 07:00:00	NQ	Futures	3467.38	3467.96	3460.66	3462.41	6506.0
2013-06-17 08:00:00	NQ	Futures	3462.41	3465.33	3459.49	3464.16	4679.0
2013-06-17 09:00:00	NQ	Futures	3464.16	3475.27	3460.36	3473.22	38696.0
2013-06-17 10:00:00	NQ	Futures	3473.52	3483.45	3470.89	3481.99	32793.0
2013-06-17 11:00:00	NQ	Futures	3482.28	3489.3	3479.36	3482.28	25135.0
2013-06-17 12:00:00	NQ	Futures	3481.99	3485.2	3479.94	3484.04	9534.0
2013-06-17 13:00:00	NQ	Futures	3484.04	3488.42	3480.82	3485.2	7932.0
2013-06-17 14:00:00	NQ	Futures	3485.5	3487.25	3449.84	3455.1	43481.0
2013-06-17 15:00:00	NQ	Futures	3455.4	3472.64	3452.18	3467.09	38254.0
2013-06-17 16:00:00	NQ	Futures	3467.09	3470.89	3465.92	3469.13	5650.0
2013-06-17 17:00:00	NQ	Futures	3468.84	3471.47	3468.84	3471.47	175.0
2013-06-17 18:00:00	NQ	Futures	3470.89	3470.89	3467.96	3469.42	157.0
2013-06-17 19:00:00	NQ	Futures	3469.42	3470.01	3467.67	3467.96	150.0
2013-06-17 20:00:00	NQ	Futures	3467.96	3470.89	3467.67	3469.13	394.0
2013-06-17 21:00:00	NQ	Futures	3469.13	3469.72	3467.09	3468.55	455.0
2013-06-17 22:00:00	NQ	Futures	3468.26	3469.72	3467.09	3468.55	293.0
2013-06-17 23:00:00	NQ	Futures	3468.26	3470.3	3467.09	3468.26	670.0
2013-06-17 00:00:00	YM	Futures	15281.9	15284.0	15277.9	15279.9	217.0
2013-06-17 01:00:00	YM	Futures	15278.9	15292.1	15275.8	15292.1	301.0

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

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