PREVIEW / futures_1hour / 2016-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-25.parquet
  size:    52 KB
  rows:    1,588

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
2016-07-25 00:00:00	ES	Futures	2350.1	2350.37	2349.29	2350.1	2245.0
2016-07-25 01:00:00	ES	Futures	2349.83	2350.92	2348.75	2349.83	3414.0
2016-07-25 02:00:00	ES	Futures	2349.56	2350.64	2348.75	2349.56	5009.0
2016-07-25 03:00:00	ES	Futures	2349.56	2351.73	2347.12	2349.56	32077.0
2016-07-25 04:00:00	ES	Futures	2349.83	2354.98	2349.83	2352.54	29753.0
2016-07-25 05:00:00	ES	Futures	2352.81	2353.36	2350.92	2352.0	13245.0
2016-07-25 06:00:00	ES	Futures	2352.0	2352.81	2349.83	2352.27	11087.0
2016-07-25 07:00:00	ES	Futures	2352.27	2353.36	2351.19	2352.54	15756.0
2016-07-25 08:00:00	ES	Futures	2352.54	2353.08	2350.1	2350.37	20184.0
2016-07-25 09:00:00	ES	Futures	2350.37	2351.46	2344.68	2345.22	210284.0
2016-07-25 10:00:00	ES	Futures	2344.95	2345.76	2340.88	2341.97	243542.0
2016-07-25 11:00:00	ES	Futures	2341.69	2342.51	2338.71	2339.8	133794.0
2016-07-25 12:00:00	ES	Futures	2340.07	2342.24	2338.44	2341.15	97829.0
2016-07-25 13:00:00	ES	Futures	2341.15	2343.05	2339.8	2342.24	70835.0
2016-07-25 14:00:00	ES	Futures	2342.24	2344.41	2341.15	2341.69	89118.0
2016-07-25 15:00:00	ES	Futures	2341.69	2346.3	2340.61	2346.3	166169.0
2016-07-25 16:00:00	ES	Futures	2346.3	2346.85	2344.68	2346.58	71028.0
2016-07-25 18:00:00	ES	Futures	2346.03	2346.03	2344.68	2345.22	3091.0
2016-07-25 19:00:00	ES	Futures	2345.22	2345.76	2344.68	2345.22	1552.0
2016-07-25 20:00:00	ES	Futures	2345.22	2345.49	2341.69	2341.69	8444.0
2016-07-25 21:00:00	ES	Futures	2341.97	2344.95	2341.15	2344.14	7819.0
2016-07-25 22:00:00	ES	Futures	2344.14	2346.85	2342.78	2346.03	6776.0
2016-07-25 23:00:00	ES	Futures	2346.3	2348.2	2345.49	2347.66	4853.0
2016-07-25 00:00:00	NQ	Futures	5546.74	5547.34	5543.46	5546.14	651.0
2016-07-25 01:00:00	NQ	Futures	5546.44	5548.83	5543.76	5545.85	661.0
2016-07-25 02:00:00	NQ	Futures	5545.85	5548.53	5542.27	5544.65	918.0
2016-07-25 03:00:00	NQ	Futures	5544.65	5550.91	5538.39	5543.46	3480.0
2016-07-25 04:00:00	NQ	Futures	5544.06	5558.36	5544.06	5553.59	3287.0
2016-07-25 05:00:00	NQ	Futures	5553.59	5555.09	5550.32	5551.81	1376.0
2016-07-25 06:00:00	NQ	Futures	5551.51	5553.3	5546.14	5552.4	1227.0
2016-07-25 07:00:00	NQ	Futures	5552.1	5554.19	5549.72	5552.1	1272.0
2016-07-25 08:00:00	NQ	Futures	5552.1	5553.59	5548.83	5548.83	2250.0
2016-07-25 09:00:00	NQ	Futures	5548.83	5556.28	5543.16	5544.95	27431.0
2016-07-25 10:00:00	NQ	Futures	5544.65	5551.51	5538.39	5546.74	25025.0
2016-07-25 11:00:00	NQ	Futures	5546.74	5549.72	5538.99	5540.78	16022.0
2016-07-25 12:00:00	NQ	Futures	5540.78	5544.65	5536.01	5542.27	13960.0
2016-07-25 13:00:00	NQ	Futures	5542.57	5549.72	5538.99	5546.14	9427.0
2016-07-25 14:00:00	NQ	Futures	5545.85	5550.91	5543.46	5544.95	10502.0
2016-07-25 15:00:00	NQ	Futures	5544.95	5555.38	5541.67	5555.38	16048.0
2016-07-25 16:00:00	NQ	Futures	5555.09	5555.68	5546.74	5553.0	6233.0
2016-07-25 18:00:00	NQ	Futures	5553.89	5553.89	5548.83	5550.02	600.0
2016-07-25 19:00:00	NQ	Futures	5549.42	5551.21	5549.12	5550.02	343.0
2016-07-25 20:00:00	NQ	Futures	5550.02	5550.32	5538.69	5539.88	1221.0
2016-07-25 21:00:00	NQ	Futures	5540.48	5547.04	5538.1	5544.65	1216.0
2016-07-25 22:00:00	NQ	Futures	5544.65	5553.3	5541.37	5551.81	1047.0
2016-07-25 23:00:00	NQ	Futures	5552.1	5557.17	5550.91	5555.38	873.0
2016-07-25 00:00:00	YM	Futures	19885.0	19887.2	19878.6	19886.1	405.0
2016-07-25 01:00:00	YM	Futures	19887.2	19894.7	19879.7	19885.0	803.0
2016-07-25 02:00:00	YM	Futures	19884.0	19891.5	19874.3	19880.7	1162.0
2016-07-25 03:00:00	YM	Futures	19880.7	19894.7	19861.4	19876.4	4271.0

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

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