PREVIEW / futures_1hour / 2013-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-13.parquet
  size:    41 KB
  rows:    1,217

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-09-13 00:00:00	ES	Futures	1743.03	1743.55	1742.51	1743.03	797.0
2013-09-13 01:00:00	ES	Futures	1743.03	1743.29	1737.6	1739.67	10100.0
2013-09-13 02:00:00	ES	Futures	1739.41	1740.96	1739.41	1739.93	3838.0
2013-09-13 03:00:00	ES	Futures	1739.93	1743.03	1739.41	1742.0	7945.0
2013-09-13 04:00:00	ES	Futures	1741.74	1742.0	1738.64	1739.93	6896.0
2013-09-13 05:00:00	ES	Futures	1740.19	1740.96	1739.41	1739.93	3334.0
2013-09-13 06:00:00	ES	Futures	1739.67	1740.96	1739.67	1740.45	3022.0
2013-09-13 07:00:00	ES	Futures	1740.45	1743.03	1739.93	1742.26	9800.0
2013-09-13 08:00:00	ES	Futures	1742.0	1744.32	1741.74	1743.55	16655.0
2013-09-13 09:00:00	ES	Futures	1743.55	1746.39	1741.74	1744.06	51616.0
2013-09-13 10:00:00	ES	Futures	1744.06	1744.32	1738.89	1743.03	69194.0
2013-09-13 11:00:00	ES	Futures	1743.03	1745.36	1742.26	1744.58	32417.0
2013-09-13 12:00:00	ES	Futures	1744.58	1745.62	1743.03	1743.55	16044.0
2013-09-13 13:00:00	ES	Futures	1743.55	1745.1	1743.29	1745.1	10772.0
2013-09-13 14:00:00	ES	Futures	1745.1	1746.13	1744.06	1744.58	13672.0
2013-09-13 15:00:00	ES	Futures	1744.58	1745.62	1742.51	1745.36	55029.0
2013-09-13 16:00:00	ES	Futures	1745.1	1747.94	1744.06	1747.42	29616.0
2013-09-13 17:00:00	ES	Futures	1747.42	1747.42	1746.65	1746.91	1092.0
2013-09-13 00:00:00	NQ	Futures	3717.24	3717.53	3716.07	3717.53	21.0
2013-09-13 01:00:00	NQ	Futures	3717.53	3717.82	3708.47	3711.69	376.0
2013-09-13 02:00:00	NQ	Futures	3711.98	3713.73	3710.81	3712.27	287.0
2013-09-13 03:00:00	NQ	Futures	3712.27	3718.7	3711.1	3717.24	615.0
2013-09-13 04:00:00	NQ	Futures	3717.82	3718.12	3710.81	3714.32	447.0
2013-09-13 05:00:00	NQ	Futures	3713.44	3716.36	3712.86	3714.32	432.0
2013-09-13 06:00:00	NQ	Futures	3714.32	3715.78	3712.27	3714.03	608.0
2013-09-13 07:00:00	NQ	Futures	3713.73	3718.41	3713.44	3716.36	352.0
2013-09-13 08:00:00	NQ	Futures	3716.36	3719.29	3714.32	3718.12	801.0
2013-09-13 09:00:00	NQ	Futures	3718.41	3720.16	3711.4	3714.61	5681.0
2013-09-13 10:00:00	NQ	Futures	3714.32	3714.9	3695.91	3705.26	10836.0
2013-09-13 11:00:00	NQ	Futures	3704.97	3712.27	3702.92	3709.35	4796.0
2013-09-13 12:00:00	NQ	Futures	3709.93	3716.07	3707.01	3709.93	2618.0
2013-09-13 13:00:00	NQ	Futures	3710.23	3714.9	3710.23	3714.9	1585.0
2013-09-13 14:00:00	NQ	Futures	3715.19	3716.66	3713.73	3714.32	1729.0
2013-09-13 15:00:00	NQ	Futures	3714.03	3716.95	3711.1	3715.78	4360.0
2013-09-13 16:00:00	NQ	Futures	3716.07	3719.58	3713.15	3718.7	2062.0
2013-09-13 17:00:00	NQ	Futures	3718.7	3718.99	3718.12	3718.12	73.0
2013-09-13 00:00:00	YM	Futures	15571.0	15578.1	15571.0	15575.0	65.0
2013-09-13 01:00:00	YM	Futures	15575.0	15576.1	15535.2	15551.6	884.0
2013-09-13 02:00:00	YM	Futures	15551.6	15567.9	15551.6	15558.7	427.0
2013-09-13 03:00:00	YM	Futures	15559.7	15583.2	15555.6	15575.0	660.0
2013-09-13 04:00:00	YM	Futures	15575.0	15575.0	15552.6	15564.8	948.0
2013-09-13 05:00:00	YM	Futures	15564.8	15574.0	15559.7	15563.8	666.0
2013-09-13 06:00:00	YM	Futures	15563.8	15574.0	15562.8	15571.0	493.0
2013-09-13 07:00:00	YM	Futures	15569.9	15587.3	15566.9	15583.2	1092.0
2013-09-13 08:00:00	YM	Futures	15582.2	15599.5	15581.2	15595.5	1701.0
2013-09-13 09:00:00	YM	Futures	15596.5	15644.5	15585.3	15622.0	13416.0
2013-09-13 10:00:00	YM	Futures	15622.0	15626.1	15584.2	15613.8	13427.0
2013-09-13 11:00:00	YM	Futures	15613.8	15634.3	15607.7	15627.1	8667.0
2013-09-13 12:00:00	YM	Futures	15627.1	15638.4	15611.8	15611.8	4927.0
2013-09-13 13:00:00	YM	Futures	15612.8	15632.2	15612.8	15631.2	2773.0

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

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