PREVIEW / futures_1hour / 2016-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-10.parquet
  size:    52 KB
  rows:    1,576

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-10-10 00:00:00	ES	Futures	2342.06	2342.6	2341.51	2342.06	1167.0
2016-10-10 01:00:00	ES	Futures	2342.06	2342.6	2341.51	2342.06	2111.0
2016-10-10 02:00:00	ES	Futures	2341.78	2343.14	2341.24	2341.78	5217.0
2016-10-10 03:00:00	ES	Futures	2342.06	2343.69	2339.61	2340.15	26611.0
2016-10-10 04:00:00	ES	Futures	2340.15	2342.6	2338.25	2342.06	15591.0
2016-10-10 05:00:00	ES	Futures	2342.06	2344.5	2340.97	2343.96	11733.0
2016-10-10 06:00:00	ES	Futures	2344.23	2345.32	2343.42	2344.23	12344.0
2016-10-10 07:00:00	ES	Futures	2344.5	2348.04	2344.23	2345.87	24338.0
2016-10-10 08:00:00	ES	Futures	2345.87	2349.67	2345.05	2349.13	27058.0
2016-10-10 09:00:00	ES	Futures	2349.13	2354.57	2346.68	2353.48	224377.0
2016-10-10 10:00:00	ES	Futures	2353.48	2354.57	2352.12	2353.76	123375.0
2016-10-10 11:00:00	ES	Futures	2353.76	2354.3	2351.03	2351.58	84405.0
2016-10-10 12:00:00	ES	Futures	2351.58	2352.12	2347.77	2349.67	68053.0
2016-10-10 13:00:00	ES	Futures	2349.4	2351.85	2349.13	2349.67	50256.0
2016-10-10 14:00:00	ES	Futures	2349.67	2351.03	2348.31	2349.67	42213.0
2016-10-10 15:00:00	ES	Futures	2349.67	2350.49	2346.68	2348.04	122046.0
2016-10-10 16:00:00	ES	Futures	2348.04	2350.49	2346.68	2350.22	64924.0
2016-10-10 18:00:00	ES	Futures	2350.22	2351.58	2349.67	2351.31	4365.0
2016-10-10 19:00:00	ES	Futures	2351.58	2351.58	2350.49	2350.76	2597.0
2016-10-10 20:00:00	ES	Futures	2350.76	2351.31	2350.22	2351.03	3447.0
2016-10-10 21:00:00	ES	Futures	2350.76	2351.03	2348.31	2348.59	7218.0
2016-10-10 22:00:00	ES	Futures	2348.59	2349.4	2346.95	2346.95	6887.0
2016-10-10 23:00:00	ES	Futures	2346.95	2347.23	2343.69	2344.5	12100.0
2016-10-10 00:00:00	NQ	Futures	5811.27	5811.86	5809.48	5811.27	165.0
2016-10-10 01:00:00	NQ	Futures	5811.27	5811.86	5809.77	5810.67	254.0
2016-10-10 02:00:00	NQ	Futures	5810.07	5814.25	5808.58	5811.56	584.0
2016-10-10 03:00:00	NQ	Futures	5811.56	5815.74	5805.6	5807.09	2770.0
2016-10-10 04:00:00	NQ	Futures	5806.79	5813.06	5802.32	5812.16	1740.0
2016-10-10 05:00:00	NQ	Futures	5812.46	5817.53	5810.07	5816.34	1597.0
2016-10-10 06:00:00	NQ	Futures	5816.64	5819.32	5815.14	5817.53	2190.0
2016-10-10 07:00:00	NQ	Futures	5817.23	5824.39	5817.23	5820.51	3592.0
2016-10-10 08:00:00	NQ	Futures	5820.51	5828.87	5818.13	5827.08	5196.0
2016-10-10 09:00:00	NQ	Futures	5827.08	5845.57	5824.39	5843.49	37407.0
2016-10-10 10:00:00	NQ	Futures	5843.78	5849.15	5840.8	5847.36	22498.0
2016-10-10 11:00:00	NQ	Futures	5847.66	5848.56	5840.5	5844.68	14107.0
2016-10-10 12:00:00	NQ	Futures	5844.98	5844.98	5835.73	5841.99	11750.0
2016-10-10 13:00:00	NQ	Futures	5841.7	5847.07	5839.91	5843.49	12966.0
2016-10-10 14:00:00	NQ	Futures	5843.78	5848.86	5842.89	5845.87	10150.0
2016-10-10 15:00:00	NQ	Futures	5846.17	5846.77	5833.34	5835.73	15613.0
2016-10-10 16:00:00	NQ	Futures	5835.73	5840.5	5832.45	5838.41	5305.0
2016-10-10 18:00:00	NQ	Futures	5837.82	5841.99	5836.92	5841.99	512.0
2016-10-10 19:00:00	NQ	Futures	5841.99	5841.99	5840.2	5841.1	642.0
2016-10-10 20:00:00	NQ	Futures	5840.8	5844.08	5839.61	5843.19	837.0
2016-10-10 21:00:00	NQ	Futures	5843.49	5843.49	5836.92	5837.52	1010.0
2016-10-10 22:00:00	NQ	Futures	5837.82	5839.31	5832.45	5833.34	1090.0
2016-10-10 23:00:00	NQ	Futures	5833.04	5833.34	5824.99	5827.97	1900.0
2016-10-10 00:00:00	YM	Futures	19664.5	19666.6	19658.0	19664.5	227.0
2016-10-10 01:00:00	YM	Futures	19663.4	19665.6	19658.0	19661.2	323.0
2016-10-10 02:00:00	YM	Futures	19661.2	19668.8	19655.8	19661.2	702.0
2016-10-10 03:00:00	YM	Futures	19661.2	19676.4	19646.1	19650.4	3897.0

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

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