PREVIEW / futures_1hour / 2013-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-02.parquet
  size:    34 KB
  rows:    1,007

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-02 00:00:00	ES	Futures	1698.57	1699.86	1698.57	1698.83	2138.0
2013-09-02 01:00:00	ES	Futures	1698.83	1699.34	1697.79	1698.57	3482.0
2013-09-02 02:00:00	ES	Futures	1698.57	1700.38	1698.05	1698.31	8108.0
2013-09-02 03:00:00	ES	Futures	1698.05	1701.93	1698.05	1700.38	25471.0
2013-09-02 04:00:00	ES	Futures	1700.38	1703.22	1700.12	1702.71	15848.0
2013-09-02 05:00:00	ES	Futures	1702.45	1702.45	1701.15	1702.19	10310.0
2013-09-02 06:00:00	ES	Futures	1701.93	1702.96	1701.67	1702.71	8185.0
2013-09-02 07:00:00	ES	Futures	1702.71	1704.51	1701.93	1703.22	18707.0
2013-09-02 08:00:00	ES	Futures	1703.22	1704.26	1702.71	1702.96	11664.0
2013-09-02 09:00:00	ES	Futures	1703.22	1703.22	1701.15	1701.67	13622.0
2013-09-02 10:00:00	ES	Futures	1701.93	1704.26	1701.41	1703.74	13341.0
2013-09-02 11:00:00	ES	Futures	1704.0	1704.26	1702.45	1703.48	10663.0
2013-09-02 18:00:00	ES	Futures	1703.48	1704.51	1701.15	1701.41	5768.0
2013-09-02 19:00:00	ES	Futures	1701.41	1702.45	1701.15	1701.41	1839.0
2013-09-02 20:00:00	ES	Futures	1701.15	1703.22	1701.15	1703.22	6310.0
2013-09-02 21:00:00	ES	Futures	1703.22	1703.22	1701.93	1702.71	2564.0
2013-09-02 22:00:00	ES	Futures	1702.71	1703.48	1702.19	1702.45	3888.0
2013-09-02 23:00:00	ES	Futures	1702.71	1704.26	1702.45	1704.0	5272.0
2013-09-02 00:00:00	NQ	Futures	3621.68	3624.02	3621.68	3622.56	285.0
2013-09-02 01:00:00	NQ	Futures	3622.56	3624.31	3621.97	3623.72	446.0
2013-09-02 02:00:00	NQ	Futures	3623.72	3627.82	3623.43	3624.6	998.0
2013-09-02 03:00:00	NQ	Futures	3624.89	3630.74	3624.02	3628.11	3786.0
2013-09-02 04:00:00	NQ	Futures	3628.11	3631.91	3626.94	3630.74	2036.0
2013-09-02 05:00:00	NQ	Futures	3630.45	3630.74	3628.11	3629.86	893.0
2013-09-02 06:00:00	NQ	Futures	3629.57	3633.66	3628.4	3633.66	1280.0
2013-09-02 07:00:00	NQ	Futures	3633.37	3639.21	3632.2	3634.83	2083.0
2013-09-02 08:00:00	NQ	Futures	3634.83	3636.29	3632.49	3632.78	1274.0
2013-09-02 09:00:00	NQ	Futures	3632.78	3633.95	3629.57	3633.08	1722.0
2013-09-02 10:00:00	NQ	Futures	3633.37	3636.88	3632.78	3636.88	1634.0
2013-09-02 11:00:00	NQ	Futures	3636.58	3636.88	3633.66	3634.25	862.0
2013-09-02 18:00:00	NQ	Futures	3633.37	3635.71	3630.74	3631.91	684.0
2013-09-02 19:00:00	NQ	Futures	3631.91	3633.08	3630.74	3630.74	271.0
2013-09-02 20:00:00	NQ	Futures	3631.03	3636.0	3630.74	3635.41	647.0
2013-09-02 21:00:00	NQ	Futures	3635.71	3635.71	3633.95	3634.54	378.0
2013-09-02 22:00:00	NQ	Futures	3634.83	3635.71	3633.95	3634.25	192.0
2013-09-02 23:00:00	NQ	Futures	3634.54	3637.17	3633.37	3635.71	616.0
2013-09-02 00:00:00	YM	Futures	15109.3	15121.5	15108.3	15110.3	293.0
2013-09-02 01:00:00	YM	Futures	15110.3	15116.4	15104.2	15116.4	554.0
2013-09-02 02:00:00	YM	Futures	15116.4	15123.5	15110.3	15111.3	927.0
2013-09-02 03:00:00	YM	Futures	15111.3	15142.8	15111.3	15131.6	2611.0
2013-09-02 04:00:00	YM	Futures	15132.6	15150.9	15128.6	15141.8	1924.0
2013-09-02 05:00:00	YM	Futures	15140.8	15140.8	15125.5	15135.7	801.0
2013-09-02 06:00:00	YM	Futures	15136.7	15146.9	15132.6	15140.8	366.0
2013-09-02 07:00:00	YM	Futures	15139.7	15155.0	15135.7	15142.8	939.0
2013-09-02 08:00:00	YM	Futures	15142.8	15150.9	15142.8	15143.8	978.0
2013-09-02 09:00:00	YM	Futures	15143.8	15146.9	15127.6	15136.7	1961.0
2013-09-02 10:00:00	YM	Futures	15134.7	15145.8	15131.6	15142.8	820.0
2013-09-02 11:00:00	YM	Futures	15142.8	15144.8	15130.6	15140.8	919.0
2013-09-02 18:00:00	YM	Futures	15141.8	15152.9	15127.6	15129.6	715.0
2013-09-02 19:00:00	YM	Futures	15130.6	15138.7	15128.6	15130.6	318.0

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

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