PREVIEW / futures_1hour / 2016-07-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	2338.71	2338.98	2337.63	2338.98	2848.0
2016-07-18 01:00:00	ES	Futures	2338.71	2341.69	2338.17	2340.88	6090.0
2016-07-18 02:00:00	ES	Futures	2341.15	2343.59	2339.8	2342.24	10312.0
2016-07-18 03:00:00	ES	Futures	2341.97	2346.58	2340.61	2343.32	30514.0
2016-07-18 04:00:00	ES	Futures	2343.32	2343.59	2339.25	2343.32	21437.0
2016-07-18 05:00:00	ES	Futures	2343.59	2343.86	2338.17	2338.98	17041.0
2016-07-18 06:00:00	ES	Futures	2339.25	2340.88	2336.81	2339.8	16612.0
2016-07-18 07:00:00	ES	Futures	2339.8	2343.05	2338.98	2343.05	21783.0
2016-07-18 08:00:00	ES	Futures	2343.05	2343.05	2337.9	2338.44	32322.0
2016-07-18 09:00:00	ES	Futures	2338.44	2340.07	2335.19	2338.71	196326.0
2016-07-18 10:00:00	ES	Futures	2338.44	2344.68	2338.17	2343.86	195189.0
2016-07-18 11:00:00	ES	Futures	2344.14	2345.22	2341.97	2343.59	125115.0
2016-07-18 12:00:00	ES	Futures	2343.59	2343.86	2340.61	2342.24	85773.0
2016-07-18 13:00:00	ES	Futures	2342.24	2344.41	2340.07	2343.86	75360.0
2016-07-18 14:00:00	ES	Futures	2343.86	2345.22	2342.24	2345.22	77482.0
2016-07-18 15:00:00	ES	Futures	2344.95	2345.76	2343.05	2343.32	141524.0
2016-07-18 16:00:00	ES	Futures	2343.32	2344.14	2341.15	2343.32	86727.0
2016-07-18 18:00:00	ES	Futures	2343.05	2343.86	2342.51	2343.59	3043.0
2016-07-18 19:00:00	ES	Futures	2343.59	2343.59	2342.78	2343.32	1310.0
2016-07-18 20:00:00	ES	Futures	2343.59	2343.59	2341.42	2341.69	4138.0
2016-07-18 21:00:00	ES	Futures	2341.69	2341.97	2338.17	2338.17	7757.0
2016-07-18 22:00:00	ES	Futures	2338.17	2340.34	2337.9	2339.53	3852.0
2016-07-18 23:00:00	ES	Futures	2339.8	2340.34	2339.25	2340.34	2154.0
2016-07-18 00:00:00	NQ	Futures	5466.27	5466.56	5462.39	5465.97	951.0
2016-07-18 01:00:00	NQ	Futures	5465.67	5470.74	5463.88	5469.54	1134.0
2016-07-18 02:00:00	NQ	Futures	5469.54	5474.31	5466.86	5471.63	2157.0
2016-07-18 03:00:00	NQ	Futures	5471.33	5482.66	5467.76	5475.21	3915.0
2016-07-18 04:00:00	NQ	Futures	5475.51	5476.1	5465.37	5474.91	2550.0
2016-07-18 05:00:00	NQ	Futures	5474.91	5476.1	5462.99	5464.78	1722.0
2016-07-18 06:00:00	NQ	Futures	5465.07	5468.35	5459.71	5465.67	1860.0
2016-07-18 07:00:00	NQ	Futures	5465.07	5474.02	5464.18	5473.42	1685.0
2016-07-18 08:00:00	NQ	Futures	5473.12	5474.02	5466.27	5466.56	3257.0
2016-07-18 09:00:00	NQ	Futures	5466.56	5476.1	5465.67	5476.1	24251.0
2016-07-18 10:00:00	NQ	Futures	5476.1	5502.03	5475.51	5499.65	33292.0
2016-07-18 11:00:00	NQ	Futures	5499.95	5510.08	5499.35	5505.61	25390.0
2016-07-18 12:00:00	NQ	Futures	5505.31	5506.5	5495.77	5499.35	13382.0
2016-07-18 13:00:00	NQ	Futures	5499.65	5507.1	5494.28	5505.91	11109.0
2016-07-18 14:00:00	NQ	Futures	5505.91	5507.69	5501.44	5506.8	9935.0
2016-07-18 15:00:00	NQ	Futures	5506.5	5507.69	5499.35	5499.65	18086.0
2016-07-18 16:00:00	NQ	Futures	5499.95	5501.44	5486.83	5495.18	11127.0
2016-07-18 18:00:00	NQ	Futures	5495.47	5497.56	5493.39	5496.37	761.0
2016-07-18 19:00:00	NQ	Futures	5496.37	5496.96	5494.28	5496.07	247.0
2016-07-18 20:00:00	NQ	Futures	5496.37	5496.67	5491.0	5491.6	589.0
2016-07-18 21:00:00	NQ	Futures	5491.3	5491.6	5483.85	5484.15	1155.0
2016-07-18 22:00:00	NQ	Futures	5483.85	5490.71	5482.96	5489.51	971.0
2016-07-18 23:00:00	NQ	Futures	5489.51	5490.41	5487.13	5488.62	299.0
2016-07-18 00:00:00	YM	Futures	19844.1	19846.3	19828.0	19843.1	2774.0
2016-07-18 01:00:00	YM	Futures	19844.1	19865.7	19837.7	19860.3	2080.0
2016-07-18 02:00:00	YM	Futures	19861.4	19875.4	19851.7	19865.7	1622.0
2016-07-18 03:00:00	YM	Futures	19864.6	19902.3	19854.9	19876.4	3810.0

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

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