PREVIEW / futures_1hour / 2013-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-12.parquet
  size:    42 KB
  rows:    1,248

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-12 00:00:00	ES	Futures	1724.42	1725.71	1723.38	1724.94	3631.0
2013-07-12 01:00:00	ES	Futures	1724.94	1725.97	1724.94	1725.45	1909.0
2013-07-12 02:00:00	ES	Futures	1725.45	1725.97	1723.9	1724.42	8032.0
2013-07-12 03:00:00	ES	Futures	1724.68	1726.23	1723.38	1724.16	23085.0
2013-07-12 04:00:00	ES	Futures	1724.16	1726.23	1724.16	1725.45	14130.0
2013-07-12 05:00:00	ES	Futures	1725.71	1727.52	1724.68	1727.0	14070.0
2013-07-12 06:00:00	ES	Futures	1727.0	1729.07	1727.0	1728.81	19526.0
2013-07-12 07:00:00	ES	Futures	1728.81	1729.59	1725.97	1728.55	26181.0
2013-07-12 08:00:00	ES	Futures	1728.55	1728.55	1724.94	1725.71	36458.0
2013-07-12 09:00:00	ES	Futures	1725.71	1727.78	1723.64	1726.23	184340.0
2013-07-12 10:00:00	ES	Futures	1726.23	1729.59	1724.42	1726.75	163017.0
2013-07-12 11:00:00	ES	Futures	1726.75	1727.52	1723.9	1724.16	116490.0
2013-07-12 12:00:00	ES	Futures	1724.42	1725.71	1723.64	1725.45	75902.0
2013-07-12 13:00:00	ES	Futures	1725.45	1727.26	1723.64	1726.23	89212.0
2013-07-12 14:00:00	ES	Futures	1726.23	1727.0	1724.68	1726.75	60601.0
2013-07-12 15:00:00	ES	Futures	1726.75	1731.14	1724.94	1729.33	172523.0
2013-07-12 16:00:00	ES	Futures	1729.33	1729.59	1726.49	1727.26	106823.0
2013-07-12 17:00:00	ES	Futures	1727.0	1727.78	1726.75	1726.75	2307.0
2013-07-12 00:00:00	NQ	Futures	3569.08	3570.25	3567.32	3569.95	449.0
2013-07-12 01:00:00	NQ	Futures	3569.95	3571.12	3569.66	3570.83	169.0
2013-07-12 02:00:00	NQ	Futures	3570.83	3571.71	3567.62	3568.2	1249.0
2013-07-12 03:00:00	NQ	Futures	3568.78	3572.0	3566.45	3568.2	3360.0
2013-07-12 04:00:00	NQ	Futures	3567.91	3571.71	3567.91	3569.66	1673.0
2013-07-12 05:00:00	NQ	Futures	3569.95	3573.17	3567.91	3572.58	1643.0
2013-07-12 06:00:00	NQ	Futures	3573.17	3576.67	3573.17	3576.38	4057.0
2013-07-12 07:00:00	NQ	Futures	3576.38	3578.14	3573.46	3576.67	5568.0
2013-07-12 08:00:00	NQ	Futures	3576.38	3576.67	3569.08	3572.29	4726.0
2013-07-12 09:00:00	NQ	Futures	3572.29	3577.26	3567.91	3572.58	21462.0
2013-07-12 10:00:00	NQ	Futures	3572.88	3579.6	3570.83	3572.58	20173.0
2013-07-12 11:00:00	NQ	Futures	3572.58	3574.04	3564.69	3567.03	14703.0
2013-07-12 12:00:00	NQ	Futures	3567.32	3569.37	3564.4	3567.91	11500.0
2013-07-12 13:00:00	NQ	Futures	3568.2	3573.17	3564.4	3570.54	9987.0
2013-07-12 14:00:00	NQ	Futures	3570.54	3578.72	3570.54	3578.43	9723.0
2013-07-12 15:00:00	NQ	Futures	3578.72	3589.24	3575.8	3588.36	24321.0
2013-07-12 16:00:00	NQ	Futures	3588.36	3588.36	3580.77	3582.81	10301.0
2013-07-12 17:00:00	NQ	Futures	3582.52	3583.4	3581.93	3582.81	103.0
2013-07-12 00:00:00	YM	Futures	15616.1	15623.2	15610.0	15621.2	430.0
2013-07-12 01:00:00	YM	Futures	15622.2	15624.2	15617.1	15623.2	320.0
2013-07-12 02:00:00	YM	Futures	15623.2	15626.3	15613.1	15618.1	739.0
2013-07-12 03:00:00	YM	Futures	15619.1	15633.4	15612.0	15618.1	1752.0
2013-07-12 04:00:00	YM	Futures	15617.1	15639.5	15616.1	15626.3	1675.0
2013-07-12 05:00:00	YM	Futures	15627.3	15640.5	15621.2	15638.4	962.0
2013-07-12 06:00:00	YM	Futures	15638.4	15655.7	15637.4	15654.7	1749.0
2013-07-12 07:00:00	YM	Futures	15654.7	15658.8	15631.3	15653.7	1758.0
2013-07-12 08:00:00	YM	Futures	15653.7	15655.7	15633.4	15639.5	2614.0
2013-07-12 09:00:00	YM	Futures	15639.5	15661.8	15626.3	15651.6	12485.0
2013-07-12 10:00:00	YM	Futures	15652.7	15675.0	15635.4	15657.7	13579.0
2013-07-12 11:00:00	YM	Futures	15657.7	15660.8	15627.3	15630.3	8304.0
2013-07-12 12:00:00	YM	Futures	15630.3	15635.4	15587.7	15599.8	15893.0
2013-07-12 13:00:00	YM	Futures	15599.8	15629.3	15587.7	15623.2	11347.0

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

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