PREVIEW / futures_1hour / 2016-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-11.parquet
  size:    53 KB
  rows:    1,588

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-01-11 00:00:00	ES	Futures	2055.62	2055.62	2050.25	2052.67	9864.0
2016-01-11 01:00:00	ES	Futures	2052.67	2056.97	2044.61	2045.68	14437.0
2016-01-11 02:00:00	ES	Futures	2045.95	2059.39	2045.95	2054.01	33243.0
2016-01-11 03:00:00	ES	Futures	2054.28	2072.82	2054.28	2070.94	55443.0
2016-01-11 04:00:00	ES	Futures	2070.94	2071.48	2062.61	2066.91	27541.0
2016-01-11 05:00:00	ES	Futures	2066.64	2067.18	2057.24	2061.0	27468.0
2016-01-11 06:00:00	ES	Futures	2061.27	2066.64	2057.77	2064.22	26076.0
2016-01-11 07:00:00	ES	Futures	2064.22	2066.64	2060.46	2062.88	25121.0
2016-01-11 08:00:00	ES	Futures	2063.15	2072.82	2062.34	2067.98	59064.0
2016-01-11 09:00:00	ES	Futures	2068.25	2073.36	2056.97	2058.85	273179.0
2016-01-11 10:00:00	ES	Futures	2058.85	2067.18	2050.79	2052.4	314086.0
2016-01-11 11:00:00	ES	Futures	2052.4	2062.34	2047.83	2059.12	260003.0
2016-01-11 12:00:00	ES	Futures	2059.12	2059.92	2047.83	2050.52	169021.0
2016-01-11 13:00:00	ES	Futures	2050.52	2053.21	2034.13	2038.16	231319.0
2016-01-11 14:00:00	ES	Futures	2038.16	2053.21	2036.28	2047.03	263176.0
2016-01-11 15:00:00	ES	Futures	2047.03	2066.64	2038.96	2058.58	429125.0
2016-01-11 16:00:00	ES	Futures	2058.58	2059.92	2054.28	2055.62	97500.0
2016-01-11 18:00:00	ES	Futures	2056.7	2062.88	2055.89	2062.61	9534.0
2016-01-11 19:00:00	ES	Futures	2062.34	2063.69	2059.39	2062.34	11249.0
2016-01-11 20:00:00	ES	Futures	2062.34	2064.22	2055.36	2058.85	19425.0
2016-01-11 21:00:00	ES	Futures	2058.85	2060.46	2054.28	2057.24	13212.0
2016-01-11 22:00:00	ES	Futures	2057.51	2060.19	2055.62	2057.24	7995.0
2016-01-11 23:00:00	ES	Futures	2057.24	2059.39	2047.56	2050.25	11066.0
2016-01-11 00:00:00	NQ	Futures	5065.35	5065.65	5050.51	5057.63	2213.0
2016-01-11 01:00:00	NQ	Futures	5058.52	5070.1	5033.88	5036.55	3169.0
2016-01-11 02:00:00	NQ	Futures	5037.44	5066.84	5034.77	5052.88	6212.0
2016-01-11 03:00:00	NQ	Futures	5053.18	5097.72	5053.18	5091.18	9632.0
2016-01-11 04:00:00	NQ	Futures	5091.78	5092.97	5073.96	5085.84	5589.0
2016-01-11 05:00:00	NQ	Futures	5085.84	5087.32	5060.01	5068.91	6314.0
2016-01-11 06:00:00	NQ	Futures	5069.21	5086.14	5061.19	5080.79	4450.0
2016-01-11 07:00:00	NQ	Futures	5080.79	5089.4	5073.37	5079.01	3830.0
2016-01-11 08:00:00	NQ	Futures	5079.6	5100.09	5077.82	5094.15	8781.0
2016-01-11 09:00:00	NQ	Futures	5094.45	5112.56	5064.76	5069.81	48455.0
2016-01-11 10:00:00	NQ	Futures	5069.51	5089.11	5042.49	5048.72	53716.0
2016-01-11 11:00:00	NQ	Futures	5048.72	5080.5	5035.06	5069.21	43201.0
2016-01-11 12:00:00	NQ	Futures	5070.1	5071.29	5034.77	5042.49	30725.0
2016-01-11 13:00:00	NQ	Futures	5042.78	5050.8	4998.84	5008.64	39070.0
2016-01-11 14:00:00	NQ	Futures	5008.93	5058.82	5002.4	5038.63	48838.0
2016-01-11 15:00:00	NQ	Futures	5038.63	5097.72	5013.69	5078.42	74935.0
2016-01-11 16:00:00	NQ	Futures	5078.12	5080.79	5067.13	5070.1	11692.0
2016-01-11 18:00:00	NQ	Futures	5074.26	5087.62	5070.4	5086.73	2331.0
2016-01-11 19:00:00	NQ	Futures	5086.43	5090.0	5078.71	5087.62	2207.0
2016-01-11 20:00:00	NQ	Futures	5087.32	5091.78	5067.73	5078.71	4209.0
2016-01-11 21:00:00	NQ	Futures	5079.6	5082.87	5063.87	5071.88	2707.0
2016-01-11 22:00:00	NQ	Futures	5071.88	5080.79	5068.32	5075.45	2357.0
2016-01-11 23:00:00	NQ	Futures	5075.45	5080.2	5049.91	5056.15	1769.0
2016-01-11 00:00:00	YM	Futures	17277.5	17279.7	17233.9	17247.7	3648.0
2016-01-11 01:00:00	YM	Futures	17249.9	17283.9	17191.3	17197.7	4398.0
2016-01-11 02:00:00	YM	Futures	17199.8	17297.8	17198.8	17260.5	6685.0
2016-01-11 03:00:00	YM	Futures	17262.6	17408.5	17262.6	17392.5	10606.0

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

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