PREVIEW / futures_1hour / 2015-12-30

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-30.parquet
  size:    48 KB
  rows:    1,525

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
2015-12-30 00:00:00	ES	Futures	2227.87	2227.87	2225.72	2225.72	1787.0
2015-12-30 01:00:00	ES	Futures	2225.99	2227.6	2225.45	2227.6	1419.0
2015-12-30 02:00:00	ES	Futures	2227.6	2227.87	2225.72	2225.99	3217.0
2015-12-30 03:00:00	ES	Futures	2226.25	2227.33	2221.42	2222.76	12921.0
2015-12-30 04:00:00	ES	Futures	2222.76	2224.91	2222.22	2224.64	7968.0
2015-12-30 05:00:00	ES	Futures	2224.37	2225.72	2223.57	2224.1	5514.0
2015-12-30 06:00:00	ES	Futures	2224.1	2225.45	2223.57	2225.18	4485.0
2015-12-30 07:00:00	ES	Futures	2225.45	2225.72	2222.22	2222.76	9100.0
2015-12-30 08:00:00	ES	Futures	2223.03	2223.57	2221.15	2222.22	11657.0
2015-12-30 09:00:00	ES	Futures	2222.22	2223.3	2217.92	2219.54	104421.0
2015-12-30 10:00:00	ES	Futures	2219.54	2222.22	2215.51	2218.73	118422.0
2015-12-30 11:00:00	ES	Futures	2218.73	2221.15	2217.39	2218.46	75208.0
2015-12-30 12:00:00	ES	Futures	2218.19	2219.81	2216.58	2217.66	41054.0
2015-12-30 13:00:00	ES	Futures	2217.66	2220.07	2215.77	2219.0	49047.0
2015-12-30 14:00:00	ES	Futures	2219.0	2220.34	2216.58	2217.39	44314.0
2015-12-30 15:00:00	ES	Futures	2217.39	2218.46	2207.18	2209.33	154767.0
2015-12-30 16:00:00	ES	Futures	2209.33	2211.21	2207.44	2210.13	57257.0
2015-12-30 18:00:00	ES	Futures	2209.06	2211.21	2208.79	2210.67	2326.0
2015-12-30 19:00:00	ES	Futures	2210.67	2211.74	2210.4	2211.21	1409.0
2015-12-30 20:00:00	ES	Futures	2211.48	2211.48	2209.86	2210.13	1805.0
2015-12-30 21:00:00	ES	Futures	2210.4	2210.94	2209.59	2210.4	1165.0
2015-12-30 22:00:00	ES	Futures	2210.4	2210.67	2207.71	2208.52	2390.0
2015-12-30 23:00:00	ES	Futures	2208.52	2209.33	2207.71	2208.52	1287.0
2015-12-30 00:00:00	NQ	Futures	5569.54	5571.32	5567.17	5567.17	383.0
2015-12-30 01:00:00	NQ	Futures	5566.87	5569.54	5565.98	5568.65	413.0
2015-12-30 02:00:00	NQ	Futures	5569.24	5570.14	5565.98	5566.87	779.0
2015-12-30 03:00:00	NQ	Futures	5566.87	5571.03	5556.18	5557.96	2362.0
2015-12-30 04:00:00	NQ	Futures	5557.96	5563.9	5557.37	5563.31	1092.0
2015-12-30 05:00:00	NQ	Futures	5563.01	5567.17	5561.52	5565.09	1096.0
2015-12-30 06:00:00	NQ	Futures	5564.79	5570.14	5564.2	5569.24	960.0
2015-12-30 07:00:00	NQ	Futures	5569.24	5569.84	5561.52	5563.31	1501.0
2015-12-30 08:00:00	NQ	Futures	5563.6	5564.49	5560.04	5561.82	1774.0
2015-12-30 09:00:00	NQ	Futures	5561.82	5565.09	5536.88	5538.96	21576.0
2015-12-30 10:00:00	NQ	Futures	5539.25	5548.16	5531.83	5541.33	19969.0
2015-12-30 11:00:00	NQ	Futures	5541.63	5548.46	5535.39	5541.33	10742.0
2015-12-30 12:00:00	NQ	Futures	5541.04	5545.79	5538.96	5541.04	7003.0
2015-12-30 13:00:00	NQ	Futures	5541.04	5550.83	5536.88	5545.79	7673.0
2015-12-30 14:00:00	NQ	Futures	5545.49	5548.16	5537.77	5540.14	7158.0
2015-12-30 15:00:00	NQ	Futures	5540.14	5547.27	5515.8	5517.58	23944.0
2015-12-30 16:00:00	NQ	Futures	5517.58	5524.7	5515.2	5523.22	5651.0
2015-12-30 18:00:00	NQ	Futures	5520.55	5527.38	5519.06	5526.78	428.0
2015-12-30 19:00:00	NQ	Futures	5527.08	5528.86	5526.49	5527.08	243.0
2015-12-30 20:00:00	NQ	Futures	5525.89	5526.19	5523.52	5524.41	308.0
2015-12-30 21:00:00	NQ	Futures	5523.81	5526.49	5523.22	5525.0	208.0
2015-12-30 22:00:00	NQ	Futures	5524.7	5525.3	5515.5	5517.58	760.0
2015-12-30 23:00:00	NQ	Futures	5517.88	5521.14	5516.39	5520.55	415.0
2015-12-30 00:00:00	YM	Futures	18767.8	18769.9	18757.2	18758.2	292.0
2015-12-30 01:00:00	YM	Futures	18757.2	18767.8	18756.1	18767.8	380.0
2015-12-30 02:00:00	YM	Futures	18767.8	18773.1	18755.0	18761.4	862.0
2015-12-30 03:00:00	YM	Futures	18762.5	18772.1	18718.9	18726.3	2997.0

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

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