PREVIEW / futures_1hour / 2017-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-26.parquet
  size:    53 KB
  rows:    1,638

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
2017-07-26 00:00:00	ES	Futures	2703.87	2703.87	2703.33	2703.33	1045.0
2017-07-26 01:00:00	ES	Futures	2703.6	2704.69	2703.33	2703.87	1898.0
2017-07-26 02:00:00	ES	Futures	2703.87	2704.97	2703.87	2704.42	3498.0
2017-07-26 03:00:00	ES	Futures	2704.42	2707.97	2704.42	2707.43	24653.0
2017-07-26 04:00:00	ES	Futures	2707.43	2707.7	2706.33	2707.7	15950.0
2017-07-26 05:00:00	ES	Futures	2707.7	2709.07	2706.61	2708.25	12425.0
2017-07-26 06:00:00	ES	Futures	2708.25	2708.25	2706.61	2708.25	14245.0
2017-07-26 07:00:00	ES	Futures	2708.25	2709.89	2707.15	2709.61	17791.0
2017-07-26 08:00:00	ES	Futures	2709.89	2710.98	2708.79	2710.43	24073.0
2017-07-26 09:00:00	ES	Futures	2710.43	2711.25	2706.33	2707.7	131970.0
2017-07-26 10:00:00	ES	Futures	2707.7	2709.89	2705.79	2706.33	132424.0
2017-07-26 11:00:00	ES	Futures	2706.06	2707.7	2706.06	2707.15	75639.0
2017-07-26 12:00:00	ES	Futures	2707.15	2708.52	2706.61	2706.88	43337.0
2017-07-26 13:00:00	ES	Futures	2706.88	2707.15	2704.69	2704.69	64234.0
2017-07-26 14:00:00	ES	Futures	2704.69	2708.52	2704.42	2705.24	119625.0
2017-07-26 15:00:00	ES	Futures	2705.24	2706.61	2702.23	2705.79	177089.0
2017-07-26 16:00:00	ES	Futures	2705.79	2706.88	2703.87	2705.24	65220.0
2017-07-26 18:00:00	ES	Futures	2705.51	2708.25	2705.51	2707.7	6056.0
2017-07-26 19:00:00	ES	Futures	2707.7	2709.07	2707.7	2707.97	3893.0
2017-07-26 20:00:00	ES	Futures	2707.97	2709.34	2706.61	2708.79	8455.0
2017-07-26 21:00:00	ES	Futures	2708.79	2709.61	2708.25	2708.52	6694.0
2017-07-26 22:00:00	ES	Futures	2708.52	2709.07	2708.25	2708.52	2756.0
2017-07-26 23:00:00	ES	Futures	2708.52	2709.07	2708.52	2708.79	2820.0
2017-07-26 00:00:00	NQ	Futures	7061.77	7062.06	7059.09	7059.98	552.0
2017-07-26 01:00:00	NQ	Futures	7060.28	7063.85	7059.38	7062.66	490.0
2017-07-26 02:00:00	NQ	Futures	7062.06	7063.85	7059.68	7060.87	720.0
2017-07-26 03:00:00	NQ	Futures	7061.17	7069.51	7059.68	7068.91	2129.0
2017-07-26 04:00:00	NQ	Futures	7068.91	7070.4	7064.45	7067.42	1336.0
2017-07-26 05:00:00	NQ	Futures	7067.42	7072.49	7065.64	7069.81	1288.0
2017-07-26 06:00:00	NQ	Futures	7070.1	7074.57	7064.45	7074.27	2023.0
2017-07-26 07:00:00	NQ	Futures	7074.27	7076.36	7069.81	7075.17	1812.0
2017-07-26 08:00:00	NQ	Futures	7075.46	7089.16	7073.08	7087.97	6433.0
2017-07-26 09:00:00	NQ	Futures	7087.97	7089.75	7076.65	7086.18	31977.0
2017-07-26 10:00:00	NQ	Futures	7085.88	7091.84	7076.36	7078.14	30888.0
2017-07-26 11:00:00	NQ	Futures	7077.84	7082.31	7072.49	7076.95	17140.0
2017-07-26 12:00:00	NQ	Futures	7076.65	7084.4	7076.65	7079.33	11767.0
2017-07-26 13:00:00	NQ	Futures	7079.33	7084.69	7074.57	7076.95	10781.0
2017-07-26 14:00:00	NQ	Futures	7077.84	7085.88	7070.4	7078.14	24246.0
2017-07-26 15:00:00	NQ	Futures	7078.14	7088.56	7076.36	7087.67	25748.0
2017-07-26 16:00:00	NQ	Futures	7087.67	7096.01	7071.59	7090.05	15256.0
2017-07-26 18:00:00	NQ	Futures	7099.58	7109.11	7099.58	7105.24	2814.0
2017-07-26 19:00:00	NQ	Futures	7105.24	7110.0	7105.24	7108.51	1146.0
2017-07-26 20:00:00	NQ	Futures	7108.51	7131.14	7107.32	7121.61	4836.0
2017-07-26 21:00:00	NQ	Futures	7121.61	7123.1	7117.15	7119.83	1398.0
2017-07-26 22:00:00	NQ	Futures	7119.83	7121.61	7119.23	7119.53	709.0
2017-07-26 23:00:00	NQ	Futures	7119.53	7124.0	7118.93	7123.7	979.0
2017-07-26 00:00:00	YM	Futures	23460.0	23461.1	23457.9	23459.0	197.0
2017-07-26 01:00:00	YM	Futures	23460.0	23476.4	23457.9	23470.9	1072.0
2017-07-26 02:00:00	YM	Futures	23469.8	23474.2	23465.5	23470.9	614.0
2017-07-26 03:00:00	YM	Futures	23470.9	23492.7	23468.8	23491.6	2279.0

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

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