PREVIEW / futures_1hour / 2013-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-21.parquet
  size:    14 KB
  rows:    259

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-21 18:00:00	ES	Futures	1747.42	1750.01	1747.42	1748.72	9103.0
2013-07-21 19:00:00	ES	Futures	1748.72	1749.75	1748.2	1748.98	3693.0
2013-07-21 20:00:00	ES	Futures	1748.72	1749.75	1747.94	1749.49	6926.0
2013-07-21 21:00:00	ES	Futures	1749.49	1751.82	1748.72	1748.98	11715.0
2013-07-21 22:00:00	ES	Futures	1749.23	1749.75	1748.46	1748.98	4109.0
2013-07-21 23:00:00	ES	Futures	1748.72	1749.49	1747.94	1748.98	2913.0
2013-07-21 18:00:00	NQ	Futures	3557.97	3562.36	3557.97	3560.02	910.0
2013-07-21 19:00:00	NQ	Futures	3559.73	3562.06	3559.73	3561.48	536.0
2013-07-21 20:00:00	NQ	Futures	3561.48	3564.11	3559.73	3563.82	1042.0
2013-07-21 21:00:00	NQ	Futures	3563.82	3567.91	3563.52	3565.28	2063.0
2013-07-21 22:00:00	NQ	Futures	3565.28	3565.86	3562.94	3564.4	800.0
2013-07-21 23:00:00	NQ	Futures	3564.11	3564.69	3561.19	3563.23	521.0
2013-07-21 18:00:00	YM	Futures	15750.2	15772.5	15750.2	15761.3	789.0
2013-07-21 19:00:00	YM	Futures	15761.3	15768.5	15757.3	15763.4	301.0
2013-07-21 20:00:00	YM	Futures	15762.4	15768.5	15756.3	15766.4	796.0
2013-07-21 21:00:00	YM	Futures	15767.4	15784.7	15764.4	15766.4	1581.0
2013-07-21 22:00:00	YM	Futures	15766.4	15770.5	15760.3	15765.4	533.0
2013-07-21 23:00:00	YM	Futures	15766.4	15770.5	15758.3	15766.4	349.0
2013-07-21 18:00:00	CL	Futures	169.87	170.13	169.58	170.13	1359.0
2013-07-21 19:00:00	CL	Futures	170.13	170.22	169.89	169.98	638.0
2013-07-21 20:00:00	CL	Futures	169.98	170.14	169.95	170.0	562.0
2013-07-21 21:00:00	CL	Futures	170.0	170.11	169.95	170.0	804.0
2013-07-21 22:00:00	CL	Futures	170.0	170.19	169.95	170.03	621.0
2013-07-21 23:00:00	CL	Futures	170.05	170.14	169.75	169.84	472.0
2013-07-21 18:00:00	GC	Futures	1777.7	1809.4	1776.6	1800.5	9953.0
2013-07-21 19:00:00	GC	Futures	1800.3	1801.9	1796.1	1799.9	2687.0
2013-07-21 20:00:00	GC	Futures	1800.2	1801.6	1797.9	1799.5	3060.0
2013-07-21 21:00:00	GC	Futures	1799.7	1806.7	1796.9	1802.0	6337.0
2013-07-21 22:00:00	GC	Futures	1802.0	1803.4	1801.0	1802.0	2515.0
2013-07-21 23:00:00	GC	Futures	1802.0	1804.7	1801.0	1802.4	2356.0
2013-07-21 18:00:00	ZN	Futures	115.089995	115.189052	115.089995	115.174901	3383.0
2013-07-21 19:00:00	ZN	Futures	115.189052	115.189052	115.132448	115.146599	2321.0
2013-07-21 20:00:00	ZN	Futures	115.16075	115.217354	115.146599	115.203203	5520.0
2013-07-21 21:00:00	ZN	Futures	115.203203	115.217354	115.16075	115.203203	7991.0
2013-07-21 22:00:00	ZN	Futures	115.189052	115.245656	115.189052	115.231505	6443.0
2013-07-21 23:00:00	ZN	Futures	115.231505	115.30226	115.231505	115.288109	9316.0

> showing 36 of 259 rows — these rows as CSV

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