PREVIEW / futures_1hour / 2016-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-20.parquet
  size:    53 KB
  rows:    1,612

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-20 00:00:00	ES	Futures	2339.8	2340.34	2339.25	2340.07	1513.0
2016-07-20 01:00:00	ES	Futures	2340.07	2341.42	2339.8	2341.42	3728.0
2016-07-20 02:00:00	ES	Futures	2341.42	2344.95	2341.15	2344.41	12064.0
2016-07-20 03:00:00	ES	Futures	2344.41	2346.03	2341.42	2344.68	26630.0
2016-07-20 04:00:00	ES	Futures	2344.68	2348.47	2343.59	2347.12	21959.0
2016-07-20 05:00:00	ES	Futures	2346.85	2350.92	2346.85	2350.1	26689.0
2016-07-20 06:00:00	ES	Futures	2350.1	2350.64	2349.02	2349.29	10182.0
2016-07-20 07:00:00	ES	Futures	2349.02	2349.56	2347.39	2347.93	16397.0
2016-07-20 08:00:00	ES	Futures	2347.93	2347.93	2345.76	2346.3	29927.0
2016-07-20 09:00:00	ES	Futures	2346.58	2347.93	2341.42	2344.41	173101.0
2016-07-20 10:00:00	ES	Futures	2344.41	2351.46	2343.05	2350.92	211688.0
2016-07-20 11:00:00	ES	Futures	2351.19	2353.63	2350.37	2351.46	134946.0
2016-07-20 12:00:00	ES	Futures	2351.46	2351.73	2350.1	2350.64	57298.0
2016-07-20 13:00:00	ES	Futures	2350.92	2353.63	2350.64	2352.27	69302.0
2016-07-20 14:00:00	ES	Futures	2352.27	2353.63	2351.19	2351.46	85798.0
2016-07-20 15:00:00	ES	Futures	2351.46	2352.54	2349.83	2350.37	148684.0
2016-07-20 16:00:00	ES	Futures	2350.64	2352.81	2350.1	2352.54	70867.0
2016-07-20 18:00:00	ES	Futures	2352.0	2352.27	2350.92	2350.92	3407.0
2016-07-20 19:00:00	ES	Futures	2350.92	2351.46	2350.1	2350.64	3397.0
2016-07-20 20:00:00	ES	Futures	2350.64	2351.46	2350.37	2351.19	2535.0
2016-07-20 21:00:00	ES	Futures	2350.92	2352.27	2350.37	2351.19	4521.0
2016-07-20 22:00:00	ES	Futures	2351.46	2352.0	2351.19	2351.73	1870.0
2016-07-20 23:00:00	ES	Futures	2351.46	2352.54	2351.19	2351.46	2847.0
2016-07-20 00:00:00	NQ	Futures	5488.32	5490.11	5486.53	5489.51	245.0
2016-07-20 01:00:00	NQ	Futures	5489.51	5491.6	5487.73	5491.6	515.0
2016-07-20 02:00:00	NQ	Futures	5491.6	5499.95	5490.71	5498.16	1749.0
2016-07-20 03:00:00	NQ	Futures	5498.75	5502.93	5488.62	5497.26	3411.0
2016-07-20 04:00:00	NQ	Futures	5497.86	5509.48	5495.18	5506.2	2584.0
2016-07-20 05:00:00	NQ	Futures	5505.61	5516.04	5505.61	5513.66	3232.0
2016-07-20 06:00:00	NQ	Futures	5513.95	5514.55	5509.48	5509.78	1625.0
2016-07-20 07:00:00	NQ	Futures	5509.48	5510.68	5507.1	5508.29	2195.0
2016-07-20 08:00:00	NQ	Futures	5508.29	5509.19	5505.01	5506.8	3522.0
2016-07-20 09:00:00	NQ	Futures	5506.5	5520.21	5502.63	5519.32	34313.0
2016-07-20 10:00:00	NQ	Futures	5519.02	5541.67	5516.93	5540.18	33201.0
2016-07-20 11:00:00	NQ	Futures	5540.18	5546.74	5536.31	5544.06	20387.0
2016-07-20 12:00:00	NQ	Futures	5544.36	5545.85	5540.78	5541.97	10690.0
2016-07-20 13:00:00	NQ	Futures	5541.97	5550.91	5541.67	5549.12	10295.0
2016-07-20 14:00:00	NQ	Futures	5549.42	5554.49	5544.65	5544.95	12877.0
2016-07-20 15:00:00	NQ	Futures	5544.65	5550.91	5541.08	5544.06	24076.0
2016-07-20 16:00:00	NQ	Futures	5543.76	5551.51	5537.5	5551.51	10029.0
2016-07-20 18:00:00	NQ	Futures	5548.53	5549.42	5546.14	5547.04	439.0
2016-07-20 19:00:00	NQ	Futures	5546.74	5548.23	5545.85	5547.34	316.0
2016-07-20 20:00:00	NQ	Futures	5546.74	5548.83	5545.85	5547.93	250.0
2016-07-20 21:00:00	NQ	Futures	5548.53	5553.3	5547.04	5551.21	1147.0
2016-07-20 22:00:00	NQ	Futures	5551.21	5552.4	5550.02	5551.81	305.0
2016-07-20 23:00:00	NQ	Futures	5551.51	5554.19	5550.32	5551.21	494.0
2016-07-20 00:00:00	YM	Futures	19885.0	19890.4	19880.7	19888.3	332.0
2016-07-20 01:00:00	YM	Futures	19888.3	19895.8	19885.0	19894.7	734.0
2016-07-20 02:00:00	YM	Futures	19894.7	19932.4	19893.6	19924.9	3478.0
2016-07-20 03:00:00	YM	Futures	19924.9	19938.9	19904.4	19929.2	3775.0

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

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