PREVIEW / futures_1hour / 2014-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-04.parquet
  size:    26 KB
  rows:    769

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
2014-07-04 00:00:00	ES	Futures	2060.67	2060.67	2060.41	2060.67	700.0
2014-07-04 01:00:00	ES	Futures	2060.41	2060.67	2060.15	2060.15	666.0
2014-07-04 02:00:00	ES	Futures	2060.15	2060.41	2059.63	2059.89	2490.0
2014-07-04 03:00:00	ES	Futures	2059.89	2060.15	2058.33	2059.63	7525.0
2014-07-04 04:00:00	ES	Futures	2059.63	2060.15	2059.37	2060.15	4880.0
2014-07-04 05:00:00	ES	Futures	2059.89	2060.15	2058.85	2059.11	3104.0
2014-07-04 06:00:00	ES	Futures	2058.85	2059.89	2058.85	2059.63	3059.0
2014-07-04 07:00:00	ES	Futures	2059.63	2060.41	2059.63	2060.15	3014.0
2014-07-04 08:00:00	ES	Futures	2060.15	2060.41	2059.37	2059.63	2574.0
2014-07-04 09:00:00	ES	Futures	2059.89	2060.15	2058.85	2059.89	4668.0
2014-07-04 10:00:00	ES	Futures	2059.89	2059.89	2058.85	2058.85	3488.0
2014-07-04 11:00:00	ES	Futures	2059.11	2059.37	2058.59	2059.11	5046.0
2014-07-04 12:00:00	ES	Futures	2059.37	2059.89	2058.85	2059.37	2583.0
2014-07-04 00:00:00	NQ	Futures	4573.53	4574.7	4573.24	4574.12	159.0
2014-07-04 01:00:00	NQ	Futures	4574.12	4574.7	4573.83	4574.12	116.0
2014-07-04 02:00:00	NQ	Futures	4573.83	4574.12	4573.24	4573.24	183.0
2014-07-04 03:00:00	NQ	Futures	4573.24	4573.53	4569.74	4571.49	874.0
2014-07-04 04:00:00	NQ	Futures	4571.49	4573.24	4570.91	4572.66	702.0
2014-07-04 05:00:00	NQ	Futures	4572.66	4574.12	4571.2	4571.2	396.0
2014-07-04 06:00:00	NQ	Futures	4571.2	4572.37	4570.32	4570.91	425.0
2014-07-04 07:00:00	NQ	Futures	4571.2	4572.37	4570.91	4572.37	258.0
2014-07-04 08:00:00	NQ	Futures	4572.37	4572.37	4570.61	4571.49	380.0
2014-07-04 09:00:00	NQ	Futures	4571.49	4572.07	4569.74	4571.2	1055.0
2014-07-04 10:00:00	NQ	Futures	4571.2	4571.2	4570.03	4570.32	522.0
2014-07-04 11:00:00	NQ	Futures	4570.32	4570.91	4568.86	4570.91	536.0
2014-07-04 12:00:00	NQ	Futures	4570.91	4571.78	4569.45	4571.49	509.0
2014-07-04 00:00:00	YM	Futures	17561.8	17565.9	17561.8	17563.8	134.0
2014-07-04 01:00:00	YM	Futures	17563.8	17563.8	17560.7	17561.8	105.0
2014-07-04 02:00:00	YM	Futures	17560.7	17564.9	17559.7	17560.7	225.0
2014-07-04 03:00:00	YM	Futures	17562.8	17562.8	17552.5	17560.7	1312.0
2014-07-04 04:00:00	YM	Futures	17559.7	17562.8	17554.5	17557.6	680.0
2014-07-04 05:00:00	YM	Futures	17557.6	17558.7	17549.4	17550.4	570.0
2014-07-04 06:00:00	YM	Futures	17551.4	17557.6	17549.4	17554.5	577.0
2014-07-04 07:00:00	YM	Futures	17555.6	17563.8	17555.6	17562.8	473.0
2014-07-04 08:00:00	YM	Futures	17562.8	17563.8	17557.6	17559.7	317.0
2014-07-04 09:00:00	YM	Futures	17559.7	17561.8	17555.6	17559.7	628.0
2014-07-04 10:00:00	YM	Futures	17560.7	17561.8	17553.5	17554.5	278.0
2014-07-04 11:00:00	YM	Futures	17555.6	17556.6	17549.4	17553.5	478.0
2014-07-04 12:00:00	YM	Futures	17553.5	17560.7	17549.4	17558.7	534.0
2014-07-04 00:00:00	CL	Futures	169.1	169.19	169.02	169.11	290.0
2014-07-04 01:00:00	CL	Futures	169.15	169.15	169.0	169.1	304.0
2014-07-04 02:00:00	CL	Futures	169.1	169.15	169.03	169.13	333.0
2014-07-04 03:00:00	CL	Futures	169.08	169.34	169.06	169.23	987.0
2014-07-04 04:00:00	CL	Futures	169.23	169.37	169.11	169.13	1455.0
2014-07-04 05:00:00	CL	Futures	169.11	169.16	168.89	168.92	1394.0
2014-07-04 06:00:00	CL	Futures	168.93	168.97	168.84	168.92	816.0
2014-07-04 07:00:00	CL	Futures	168.93	168.95	168.58	168.71	1864.0
2014-07-04 08:00:00	CL	Futures	168.69	168.77	168.61	168.76	919.0
2014-07-04 09:00:00	CL	Futures	168.76	168.97	168.71	168.8	1592.0
2014-07-04 10:00:00	CL	Futures	168.79	168.93	168.71	168.8	1068.0

> showing 50 of 769 rows — these rows as CSV

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