PREVIEW / futures_1hour / 2016-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-01.parquet
  size:    54 KB
  rows:    1,626

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-02-01 00:00:00	ES	Futures	2069.87	2074.43	2069.33	2072.28	8409.0
2016-02-01 01:00:00	ES	Futures	2072.28	2073.9	2070.67	2073.36	5819.0
2016-02-01 02:00:00	ES	Futures	2073.63	2073.9	2068.52	2072.82	17829.0
2016-02-01 03:00:00	ES	Futures	2072.55	2072.82	2064.76	2070.13	37847.0
2016-02-01 04:00:00	ES	Futures	2070.13	2070.4	2061.27	2061.27	32461.0
2016-02-01 05:00:00	ES	Futures	2061.54	2066.37	2061.0	2066.37	20220.0
2016-02-01 06:00:00	ES	Futures	2066.1	2069.87	2064.22	2065.3	17088.0
2016-02-01 07:00:00	ES	Futures	2065.3	2066.1	2056.97	2059.92	46753.0
2016-02-01 08:00:00	ES	Futures	2059.92	2062.61	2057.51	2061.27	67165.0
2016-02-01 09:00:00	ES	Futures	2061.0	2066.37	2058.58	2061.54	223387.0
2016-02-01 10:00:00	ES	Futures	2061.27	2070.4	2055.62	2069.06	277344.0
2016-02-01 11:00:00	ES	Futures	2069.06	2073.09	2064.49	2070.13	150539.0
2016-02-01 12:00:00	ES	Futures	2070.4	2071.48	2062.07	2063.15	101609.0
2016-02-01 13:00:00	ES	Futures	2063.15	2070.67	2062.34	2070.4	101952.0
2016-02-01 14:00:00	ES	Futures	2070.4	2077.93	2066.37	2077.12	132524.0
2016-02-01 15:00:00	ES	Futures	2076.85	2085.18	2073.9	2075.24	306066.0
2016-02-01 16:00:00	ES	Futures	2075.51	2081.15	2072.55	2073.09	103391.0
2016-02-01 18:00:00	ES	Futures	2072.82	2073.63	2067.45	2067.98	10510.0
2016-02-01 19:00:00	ES	Futures	2067.98	2069.33	2066.91	2068.25	9918.0
2016-02-01 20:00:00	ES	Futures	2068.52	2070.4	2067.72	2069.87	8432.0
2016-02-01 21:00:00	ES	Futures	2070.13	2071.75	2069.06	2070.4	5833.0
2016-02-01 22:00:00	ES	Futures	2070.4	2070.67	2061.8	2063.15	12182.0
2016-02-01 23:00:00	ES	Futures	2063.42	2065.03	2061.27	2063.15	8247.0
2016-02-01 00:00:00	NQ	Futures	5054.37	5066.54	5052.58	5058.82	1485.0
2016-02-01 01:00:00	NQ	Futures	5058.82	5063.57	5054.66	5061.49	802.0
2016-02-01 02:00:00	NQ	Futures	5062.38	5063.57	5049.02	5060.3	2880.0
2016-02-01 03:00:00	NQ	Futures	5060.3	5061.19	5038.63	5052.29	7006.0
2016-02-01 04:00:00	NQ	Futures	5052.29	5053.47	5032.39	5032.99	4410.0
2016-02-01 05:00:00	NQ	Futures	5032.69	5043.97	5031.5	5043.68	2718.0
2016-02-01 06:00:00	NQ	Futures	5043.97	5053.18	5038.33	5041.6	2395.0
2016-02-01 07:00:00	NQ	Futures	5041.89	5043.97	5024.97	5034.17	5418.0
2016-02-01 08:00:00	NQ	Futures	5034.17	5044.57	5030.31	5038.33	9221.0
2016-02-01 09:00:00	NQ	Futures	5038.33	5056.44	5028.83	5039.82	36455.0
2016-02-01 10:00:00	NQ	Futures	5040.41	5069.21	5022.3	5064.76	44607.0
2016-02-01 11:00:00	NQ	Futures	5064.76	5070.99	5050.51	5060.9	23929.0
2016-02-01 12:00:00	NQ	Futures	5061.79	5064.76	5040.71	5045.16	17536.0
2016-02-01 13:00:00	NQ	Futures	5044.86	5067.13	5042.19	5065.95	16942.0
2016-02-01 14:00:00	NQ	Futures	5065.65	5082.57	5051.1	5080.2	21775.0
2016-02-01 15:00:00	NQ	Futures	5079.9	5099.2	5072.18	5078.42	33488.0
2016-02-01 16:00:00	NQ	Futures	5078.42	5118.21	5076.34	5090.89	17965.0
2016-02-01 18:00:00	NQ	Futures	5091.18	5091.78	5073.07	5073.96	1634.0
2016-02-01 19:00:00	NQ	Futures	5074.56	5077.82	5072.18	5073.37	1629.0
2016-02-01 20:00:00	NQ	Futures	5073.67	5080.79	5072.18	5079.31	1241.0
2016-02-01 21:00:00	NQ	Futures	5079.01	5086.14	5077.23	5083.46	917.0
2016-02-01 22:00:00	NQ	Futures	5083.46	5084.36	5061.19	5065.65	2271.0
2016-02-01 23:00:00	NQ	Futures	5065.95	5068.91	5060.01	5065.05	1293.0
2016-02-01 00:00:00	YM	Futures	17379.7	17414.9	17375.5	17396.8	1517.0
2016-02-01 01:00:00	YM	Futures	17394.6	17410.6	17381.9	17404.2	964.0
2016-02-01 02:00:00	YM	Futures	17405.3	17409.5	17370.2	17405.3	2534.0
2016-02-01 03:00:00	YM	Futures	17404.2	17405.3	17338.2	17382.9	7611.0

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

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