PREVIEW / futures_1hour / 2010-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-25.parquet
  size:    45 KB
  rows:    1,385

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
2010-01-25 00:00:00	ES	Futures	1067.42	1067.91	1066.69	1066.93	3541.0
2010-01-25 01:00:00	ES	Futures	1066.93	1067.66	1066.69	1066.93	2595.0
2010-01-25 02:00:00	ES	Futures	1066.69	1069.37	1066.45	1069.37	19380.0
2010-01-25 03:00:00	ES	Futures	1069.37	1071.8	1068.64	1071.07	56841.0
2010-01-25 04:00:00	ES	Futures	1070.83	1071.55	1069.85	1070.83	22873.0
2010-01-25 05:00:00	ES	Futures	1070.58	1073.26	1070.34	1072.04	34587.0
2010-01-25 06:00:00	ES	Futures	1072.04	1073.26	1070.1	1070.83	21450.0
2010-01-25 07:00:00	ES	Futures	1070.83	1071.31	1067.18	1068.39	47660.0
2010-01-25 08:00:00	ES	Futures	1068.15	1069.85	1067.42	1068.39	49867.0
2010-01-25 09:00:00	ES	Futures	1068.15	1070.34	1066.2	1067.42	251247.0
2010-01-25 10:00:00	ES	Futures	1067.42	1069.37	1062.31	1065.72	434677.0
2010-01-25 11:00:00	ES	Futures	1065.47	1065.96	1060.37	1064.26	283782.0
2010-01-25 12:00:00	ES	Futures	1064.01	1067.91	1064.01	1066.93	144770.0
2010-01-25 13:00:00	ES	Futures	1066.93	1068.15	1064.99	1066.2	92971.0
2010-01-25 14:00:00	ES	Futures	1065.96	1069.61	1065.96	1069.37	146721.0
2010-01-25 15:00:00	ES	Futures	1069.37	1069.85	1063.04	1063.77	299575.0
2010-01-25 16:00:00	ES	Futures	1063.77	1066.2	1060.61	1064.01	153831.0
2010-01-25 17:00:00	ES	Futures	1064.01	1064.26	1060.85	1062.07	8571.0
2010-01-25 18:00:00	ES	Futures	1063.04	1063.77	1062.31	1063.53	5074.0
2010-01-25 19:00:00	ES	Futures	1063.53	1065.47	1063.04	1064.99	5671.0
2010-01-25 20:00:00	ES	Futures	1064.99	1066.45	1064.74	1065.23	6053.0
2010-01-25 21:00:00	ES	Futures	1065.23	1065.23	1060.85	1061.34	8719.0
2010-01-25 22:00:00	ES	Futures	1061.58	1061.58	1052.82	1055.26	29981.0
2010-01-25 23:00:00	ES	Futures	1055.01	1056.23	1052.82	1052.82	11579.0
2010-01-25 00:00:00	NQ	Futures	2061.1	2061.39	2059.39	2060.24	155.0
2010-01-25 01:00:00	NQ	Futures	2060.53	2061.1	2059.67	2060.53	262.0
2010-01-25 02:00:00	NQ	Futures	2060.53	2063.67	2059.67	2063.38	1884.0
2010-01-25 03:00:00	NQ	Futures	2063.1	2066.81	2061.67	2065.1	5381.0
2010-01-25 04:00:00	NQ	Futures	2065.1	2066.81	2064.53	2065.1	3266.0
2010-01-25 05:00:00	NQ	Futures	2064.81	2069.95	2064.81	2067.1	2762.0
2010-01-25 06:00:00	NQ	Futures	2067.38	2069.95	2063.67	2064.53	1598.0
2010-01-25 07:00:00	NQ	Futures	2065.1	2065.96	2059.1	2061.67	3462.0
2010-01-25 08:00:00	NQ	Futures	2061.39	2065.1	2060.53	2061.96	5923.0
2010-01-25 09:00:00	NQ	Futures	2061.67	2067.1	2058.24	2064.53	52524.0
2010-01-25 10:00:00	NQ	Futures	2064.53	2069.67	2058.53	2064.81	77748.0
2010-01-25 11:00:00	NQ	Futures	2064.81	2065.38	2047.96	2053.39	52642.0
2010-01-25 12:00:00	NQ	Futures	2053.39	2062.53	2053.1	2060.81	28498.0
2010-01-25 13:00:00	NQ	Futures	2060.81	2063.67	2057.39	2060.53	18255.0
2010-01-25 14:00:00	NQ	Futures	2060.53	2067.67	2060.24	2067.1	27259.0
2010-01-25 15:00:00	NQ	Futures	2066.81	2067.67	2055.67	2056.24	43061.0
2010-01-25 16:00:00	NQ	Futures	2056.24	2071.67	2037.96	2060.24	37532.0
2010-01-25 17:00:00	NQ	Futures	2059.96	2061.67	2049.1	2054.24	6596.0
2010-01-25 18:00:00	NQ	Futures	2058.53	2061.1	2058.53	2059.96	848.0
2010-01-25 19:00:00	NQ	Futures	2060.24	2062.24	2059.67	2061.96	295.0
2010-01-25 20:00:00	NQ	Futures	2061.96	2063.38	2060.53	2061.1	362.0
2010-01-25 21:00:00	NQ	Futures	2060.53	2060.53	2056.24	2056.24	759.0
2010-01-25 22:00:00	NQ	Futures	2055.96	2056.24	2043.39	2046.82	2404.0
2010-01-25 23:00:00	NQ	Futures	2046.82	2047.68	2041.96	2041.96	952.0
2010-01-25 00:00:00	YM	Futures	9543.4	9543.4	9535.9	9537.8	156.0
2010-01-25 01:00:00	YM	Futures	9537.8	9541.5	9535.0	9536.9	139.0

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

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