PREVIEW / futures_1hour / 2016-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-14.parquet
  size:    54 KB
  rows:    1,625

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-14 00:00:00	ES	Futures	2327.05	2328.41	2326.78	2327.59	2805.0
2016-07-14 01:00:00	ES	Futures	2327.86	2330.58	2327.59	2330.58	8961.0
2016-07-14 02:00:00	ES	Futures	2330.3	2340.07	2329.76	2339.25	39745.0
2016-07-14 03:00:00	ES	Futures	2339.25	2344.68	2338.17	2342.24	54966.0
2016-07-14 04:00:00	ES	Futures	2342.24	2343.86	2341.97	2342.24	23880.0
2016-07-14 05:00:00	ES	Futures	2342.24	2351.73	2341.97	2350.92	45872.0
2016-07-14 06:00:00	ES	Futures	2350.92	2350.92	2343.59	2345.76	42142.0
2016-07-14 07:00:00	ES	Futures	2345.76	2348.75	2338.44	2347.66	99097.0
2016-07-14 08:00:00	ES	Futures	2347.66	2347.93	2344.14	2346.58	57157.0
2016-07-14 09:00:00	ES	Futures	2346.3	2346.58	2338.17	2341.97	275900.0
2016-07-14 10:00:00	ES	Futures	2341.69	2346.3	2340.34	2341.69	292364.0
2016-07-14 11:00:00	ES	Futures	2341.69	2344.95	2339.8	2340.34	182365.0
2016-07-14 12:00:00	ES	Futures	2340.34	2342.51	2338.98	2340.34	98647.0
2016-07-14 13:00:00	ES	Futures	2340.07	2340.34	2335.19	2337.08	118993.0
2016-07-14 14:00:00	ES	Futures	2336.81	2341.42	2336.0	2340.34	102831.0
2016-07-14 15:00:00	ES	Futures	2340.07	2343.86	2339.25	2339.8	220727.0
2016-07-14 16:00:00	ES	Futures	2339.8	2341.69	2337.63	2340.61	79623.0
2016-07-14 18:00:00	ES	Futures	2339.25	2340.07	2336.0	2336.81	8798.0
2016-07-14 19:00:00	ES	Futures	2336.81	2336.81	2334.92	2336.27	5798.0
2016-07-14 20:00:00	ES	Futures	2336.27	2337.36	2333.56	2334.1	10574.0
2016-07-14 21:00:00	ES	Futures	2334.1	2336.54	2333.83	2336.0	5153.0
2016-07-14 22:00:00	ES	Futures	2336.27	2341.97	2336.27	2340.61	11708.0
2016-07-14 23:00:00	ES	Futures	2340.88	2341.69	2338.98	2339.8	3838.0
2016-07-14 00:00:00	NQ	Futures	5437.95	5440.63	5437.06	5439.14	302.0
2016-07-14 01:00:00	NQ	Futures	5439.74	5445.7	5439.74	5445.4	850.0
2016-07-14 02:00:00	NQ	Futures	5445.4	5470.74	5443.02	5466.86	5334.0
2016-07-14 03:00:00	NQ	Futures	5466.56	5479.08	5464.18	5472.82	4526.0
2016-07-14 04:00:00	NQ	Futures	5472.52	5475.51	5471.03	5471.63	1471.0
2016-07-14 05:00:00	NQ	Futures	5471.33	5493.98	5470.14	5491.0	3471.0
2016-07-14 06:00:00	NQ	Futures	5491.0	5491.0	5473.42	5476.4	3997.0
2016-07-14 07:00:00	NQ	Futures	5476.4	5479.08	5459.71	5477.29	8785.0
2016-07-14 08:00:00	NQ	Futures	5477.29	5477.89	5470.44	5476.7	4199.0
2016-07-14 09:00:00	NQ	Futures	5476.4	5477.0	5459.11	5465.97	33754.0
2016-07-14 10:00:00	NQ	Futures	5465.67	5482.96	5464.78	5471.93	33930.0
2016-07-14 11:00:00	NQ	Futures	5472.23	5478.78	5464.48	5467.76	19597.0
2016-07-14 12:00:00	NQ	Futures	5468.05	5473.42	5465.97	5469.54	12134.0
2016-07-14 13:00:00	NQ	Futures	5469.54	5469.84	5458.52	5461.79	13649.0
2016-07-14 14:00:00	NQ	Futures	5461.79	5471.93	5458.81	5470.44	11136.0
2016-07-14 15:00:00	NQ	Futures	5470.44	5479.38	5468.35	5471.63	20205.0
2016-07-14 16:00:00	NQ	Futures	5471.63	5474.91	5467.76	5471.33	4664.0
2016-07-14 18:00:00	NQ	Futures	5466.27	5470.44	5459.71	5463.88	1005.0
2016-07-14 19:00:00	NQ	Futures	5464.18	5464.18	5460.3	5462.09	680.0
2016-07-14 20:00:00	NQ	Futures	5461.79	5464.78	5455.83	5458.22	1102.0
2016-07-14 21:00:00	NQ	Futures	5458.22	5464.48	5457.92	5463.29	804.0
2016-07-14 22:00:00	NQ	Futures	5464.18	5477.89	5464.18	5476.7	1764.0
2016-07-14 23:00:00	NQ	Futures	5476.7	5477.29	5471.63	5472.52	403.0
2016-07-14 00:00:00	YM	Futures	19683.8	19689.2	19679.5	19685.9	495.0
2016-07-14 01:00:00	YM	Futures	19684.9	19711.8	19677.3	19702.1	6584.0
2016-07-14 02:00:00	YM	Futures	19703.2	19792.5	19697.8	19783.9	7502.0
2016-07-14 03:00:00	YM	Futures	19785.0	19825.8	19777.4	19805.4	5419.0

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

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