PREVIEW / futures_1hour / 2015-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-24.parquet
  size:    54 KB
  rows:    1,580

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-09-24 00:00:00	ES	Futures	2057.13	2060.34	2055.79	2057.93	5667.0
2015-09-24 01:00:00	ES	Futures	2057.93	2059.0	2056.33	2057.66	4307.0
2015-09-24 02:00:00	ES	Futures	2057.4	2062.21	2057.4	2060.07	12327.0
2015-09-24 03:00:00	ES	Futures	2060.07	2063.02	2054.45	2058.2	34557.0
2015-09-24 04:00:00	ES	Futures	2058.2	2072.38	2058.2	2065.42	36320.0
2015-09-24 05:00:00	ES	Futures	2065.42	2067.56	2056.86	2059.8	23653.0
2015-09-24 06:00:00	ES	Futures	2060.07	2061.14	2046.96	2050.44	49445.0
2015-09-24 07:00:00	ES	Futures	2050.44	2050.71	2041.61	2048.03	57579.0
2015-09-24 08:00:00	ES	Futures	2048.03	2049.9	2041.88	2047.76	71677.0
2015-09-24 09:00:00	ES	Futures	2047.76	2050.97	2036.26	2039.74	257487.0
2015-09-24 10:00:00	ES	Futures	2039.74	2044.02	2032.78	2033.85	330960.0
2015-09-24 11:00:00	ES	Futures	2033.85	2041.34	2030.64	2040.27	249634.0
2015-09-24 12:00:00	ES	Futures	2040.54	2048.57	2038.67	2038.93	194515.0
2015-09-24 13:00:00	ES	Futures	2038.93	2045.62	2035.72	2042.68	162997.0
2015-09-24 14:00:00	ES	Futures	2042.68	2062.21	2040.54	2058.73	268039.0
2015-09-24 15:00:00	ES	Futures	2058.47	2061.68	2048.57	2056.59	330276.0
2015-09-24 16:00:00	ES	Futures	2056.59	2058.2	2052.31	2054.72	75761.0
2015-09-24 18:00:00	ES	Futures	2047.76	2063.55	2047.23	2060.07	25654.0
2015-09-24 19:00:00	ES	Futures	2060.07	2061.14	2054.99	2059.8	7103.0
2015-09-24 20:00:00	ES	Futures	2060.07	2063.28	2057.13	2058.2	12014.0
2015-09-24 21:00:00	ES	Futures	2058.2	2059.27	2054.19	2056.06	10359.0
2015-09-24 22:00:00	ES	Futures	2055.79	2059.0	2052.85	2058.2	11139.0
2015-09-24 23:00:00	ES	Futures	2058.2	2058.73	2054.45	2056.33	5500.0
2015-09-24 00:00:00	NQ	Futures	5039.46	5046.87	5036.79	5038.57	1419.0
2015-09-24 01:00:00	NQ	Futures	5038.86	5042.13	5034.42	5035.6	1433.0
2015-09-24 02:00:00	NQ	Futures	5035.6	5047.76	5035.6	5041.83	2220.0
2015-09-24 03:00:00	NQ	Futures	5041.24	5049.24	5028.49	5037.09	4566.0
2015-09-24 04:00:00	NQ	Futures	5037.98	5074.44	5037.98	5056.95	6650.0
2015-09-24 05:00:00	NQ	Futures	5058.14	5063.47	5032.64	5039.46	5466.0
2015-09-24 06:00:00	NQ	Futures	5040.05	5043.02	5006.55	5017.52	9996.0
2015-09-24 07:00:00	NQ	Futures	5018.11	5018.41	4988.16	5005.36	13391.0
2015-09-24 08:00:00	NQ	Futures	5005.36	5013.96	4991.72	5010.11	10132.0
2015-09-24 09:00:00	NQ	Futures	5010.4	5021.08	4981.35	4994.09	45373.0
2015-09-24 10:00:00	NQ	Futures	4994.09	5004.18	4967.71	4973.34	50284.0
2015-09-24 11:00:00	NQ	Futures	4973.34	4989.05	4963.56	4986.09	32646.0
2015-09-24 12:00:00	NQ	Futures	4985.79	5011.88	4982.83	4986.68	27750.0
2015-09-24 13:00:00	NQ	Futures	4986.68	5000.91	4978.38	4993.5	27500.0
2015-09-24 14:00:00	NQ	Futures	4993.8	5057.84	4988.76	5045.68	44560.0
2015-09-24 15:00:00	NQ	Futures	5045.68	5051.91	5019.89	5039.16	50530.0
2015-09-24 16:00:00	NQ	Futures	5039.46	5043.91	5030.86	5037.09	8575.0
2015-09-24 18:00:00	NQ	Futures	5019.0	5058.14	5016.63	5048.06	3961.0
2015-09-24 19:00:00	NQ	Futures	5048.65	5051.61	5035.6	5049.84	1081.0
2015-09-24 20:00:00	NQ	Futures	5049.24	5060.81	5042.72	5045.39	2371.0
2015-09-24 21:00:00	NQ	Futures	5045.68	5051.02	5032.94	5039.75	2394.0
2015-09-24 22:00:00	NQ	Futures	5039.16	5048.06	5029.38	5045.98	2110.0
2015-09-24 23:00:00	NQ	Futures	5045.98	5046.57	5035.9	5041.53	1154.0
2015-09-24 00:00:00	YM	Futures	17091.1	17114.4	17083.6	17096.3	991.0
2015-09-24 01:00:00	YM	Futures	17097.4	17105.9	17084.7	17095.3	743.0
2015-09-24 02:00:00	YM	Futures	17096.3	17129.2	17094.2	17110.1	2246.0
2015-09-24 03:00:00	YM	Futures	17110.1	17130.2	17066.7	17095.3	4150.0

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

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