PREVIEW / futures_1hour / 2013-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-23.parquet
  size:    15 KB
  rows:    266

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-23 18:00:00	ES	Futures	1637.56	1637.82	1631.88	1634.2	10905.0
2013-06-23 19:00:00	ES	Futures	1634.2	1640.15	1633.69	1638.34	8840.0
2013-06-23 20:00:00	ES	Futures	1638.6	1638.86	1634.2	1634.2	7081.0
2013-06-23 21:00:00	ES	Futures	1634.2	1634.46	1630.07	1632.65	13316.0
2013-06-23 22:00:00	ES	Futures	1632.65	1633.95	1629.81	1631.1	9547.0
2013-06-23 23:00:00	ES	Futures	1631.1	1631.36	1626.97	1630.84	8354.0
2013-06-23 18:00:00	NQ	Futures	3350.78	3350.78	3339.09	3344.05	639.0
2013-06-23 19:00:00	NQ	Futures	3344.64	3355.74	3343.47	3353.11	610.0
2013-06-23 20:00:00	NQ	Futures	3352.82	3353.7	3342.89	3343.18	775.0
2013-06-23 21:00:00	NQ	Futures	3343.18	3344.93	3336.46	3340.84	1800.0
2013-06-23 22:00:00	NQ	Futures	3340.84	3343.47	3335.58	3338.21	1658.0
2013-06-23 23:00:00	NQ	Futures	3338.21	3339.67	3331.49	3338.5	1165.0
2013-06-23 18:00:00	YM	Futures	14945.8	14945.8	14894.0	14916.3	980.0
2013-06-23 19:00:00	YM	Futures	14917.3	14962.0	14913.2	14949.8	965.0
2013-06-23 20:00:00	YM	Futures	14950.8	14951.8	14912.2	14912.2	1159.0
2013-06-23 21:00:00	YM	Futures	14913.2	14915.3	14880.7	14901.1	2319.0
2013-06-23 22:00:00	YM	Futures	14900.0	14910.2	14877.7	14887.9	2238.0
2013-06-23 23:00:00	YM	Futures	14887.9	14891.9	14860.4	14888.9	1439.0
2013-06-23 18:00:00	CL	Futures	146.72	146.86	146.08	146.62	1747.0
2013-06-23 19:00:00	CL	Futures	146.58	146.73	146.5	146.73	537.0
2013-06-23 20:00:00	CL	Futures	146.69	146.69	146.39	146.48	664.0
2013-06-23 21:00:00	CL	Futures	146.48	146.48	146.01	146.19	1462.0
2013-06-23 22:00:00	CL	Futures	146.17	146.45	146.09	146.26	939.0
2013-06-23 23:00:00	CL	Futures	146.25	146.45	146.09	146.33	603.0
2013-06-23 18:00:00	GC	Futures	1777.9	1782.0	1777.4	1781.8	1249.0
2013-06-23 19:00:00	GC	Futures	1781.6	1783.9	1781.0	1782.4	1394.0
2013-06-23 20:00:00	GC	Futures	1782.4	1783.5	1777.7	1780.3	2228.0
2013-06-23 21:00:00	GC	Futures	1780.3	1783.8	1772.9	1773.3	5232.0
2013-06-23 22:00:00	GC	Futures	1773.3	1774.3	1767.6	1768.7	3874.0
2013-06-23 23:00:00	GC	Futures	1768.7	1772.1	1766.7	1770.2	2048.0
2013-06-23 18:00:00	ZN	Futures	114.311691	114.339993	114.170181	114.184332	8806.0
2013-06-23 19:00:00	ZN	Futures	114.184332	114.212634	114.141879	114.184332	6946.0
2013-06-23 20:00:00	ZN	Futures	114.184332	114.269238	114.170181	114.212634	9186.0
2013-06-23 21:00:00	ZN	Futures	114.198483	114.240936	114.000369	114.01452	22855.0
2013-06-23 22:00:00	ZN	Futures	114.01452	114.071124	113.929614	113.972067	24229.0
2013-06-23 23:00:00	ZN	Futures	113.972067	113.972067	113.844708	113.901312	13252.0

> showing 36 of 266 rows — these rows as CSV

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