PREVIEW / futures_1hour / 2010-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-27.parquet
  size:    48 KB
  rows:    1,428

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-27 00:00:00	ES	Futures	1060.37	1060.61	1058.42	1059.39	6447.0
2010-01-27 01:00:00	ES	Futures	1059.39	1059.39	1058.18	1058.18	2477.0
2010-01-27 02:00:00	ES	Futures	1058.18	1058.42	1055.26	1057.2	19855.0
2010-01-27 03:00:00	ES	Futures	1057.2	1058.66	1054.04	1054.53	46052.0
2010-01-27 04:00:00	ES	Futures	1054.53	1057.45	1054.04	1055.74	35751.0
2010-01-27 05:00:00	ES	Futures	1055.74	1059.15	1055.5	1057.45	31718.0
2010-01-27 06:00:00	ES	Futures	1057.45	1061.34	1057.2	1061.09	21320.0
2010-01-27 07:00:00	ES	Futures	1061.09	1061.58	1059.15	1059.39	39046.0
2010-01-27 08:00:00	ES	Futures	1059.39	1060.12	1057.93	1058.18	46215.0
2010-01-27 09:00:00	ES	Futures	1058.42	1061.09	1054.53	1058.42	330554.0
2010-01-27 10:00:00	ES	Futures	1058.18	1059.15	1051.85	1058.42	434998.0
2010-01-27 11:00:00	ES	Futures	1058.42	1058.66	1054.77	1056.96	206089.0
2010-01-27 12:00:00	ES	Futures	1056.96	1057.69	1053.31	1054.28	117131.0
2010-01-27 13:00:00	ES	Futures	1054.53	1055.26	1052.58	1054.04	142529.0
2010-01-27 14:00:00	ES	Futures	1054.04	1062.31	1049.42	1061.09	525748.0
2010-01-27 15:00:00	ES	Futures	1061.09	1066.69	1055.99	1064.26	489406.0
2010-01-27 16:00:00	ES	Futures	1064.01	1065.72	1064.01	1065.72	88107.0
2010-01-27 17:00:00	ES	Futures	1065.47	1066.2	1064.99	1065.96	5720.0
2010-01-27 18:00:00	ES	Futures	1065.72	1068.15	1065.72	1066.93	11864.0
2010-01-27 19:00:00	ES	Futures	1066.93	1067.66	1065.96	1066.69	6190.0
2010-01-27 20:00:00	ES	Futures	1066.69	1069.12	1066.45	1067.91	8798.0
2010-01-27 21:00:00	ES	Futures	1067.91	1070.58	1067.18	1070.58	16723.0
2010-01-27 22:00:00	ES	Futures	1070.58	1073.5	1069.85	1073.01	18988.0
2010-01-27 23:00:00	ES	Futures	1073.26	1073.74	1071.55	1073.74	5665.0
2010-01-27 00:00:00	NQ	Futures	2056.53	2056.53	2052.53	2054.24	552.0
2010-01-27 01:00:00	NQ	Futures	2053.96	2054.24	2052.53	2052.82	262.0
2010-01-27 02:00:00	NQ	Futures	2053.1	2053.1	2047.96	2050.53	1231.0
2010-01-27 03:00:00	NQ	Futures	2050.53	2053.1	2043.96	2045.1	5099.0
2010-01-27 04:00:00	NQ	Futures	2045.1	2050.25	2044.53	2047.39	2972.0
2010-01-27 05:00:00	NQ	Futures	2047.68	2054.82	2047.39	2050.82	3192.0
2010-01-27 06:00:00	NQ	Futures	2050.25	2058.81	2050.25	2057.96	1715.0
2010-01-27 07:00:00	NQ	Futures	2057.96	2059.39	2054.53	2055.1	2247.0
2010-01-27 08:00:00	NQ	Futures	2055.1	2057.1	2053.1	2053.96	4877.0
2010-01-27 09:00:00	NQ	Futures	2053.67	2067.38	2048.82	2062.53	52754.0
2010-01-27 10:00:00	NQ	Futures	2062.81	2063.67	2047.1	2061.1	70741.0
2010-01-27 11:00:00	NQ	Futures	2061.1	2062.53	2053.67	2057.1	31839.0
2010-01-27 12:00:00	NQ	Futures	2057.1	2060.81	2053.67	2055.39	21132.0
2010-01-27 13:00:00	NQ	Futures	2055.1	2057.1	2042.53	2051.1	48826.0
2010-01-27 14:00:00	NQ	Futures	2050.82	2075.95	2047.96	2072.24	99412.0
2010-01-27 15:00:00	NQ	Futures	2072.24	2081.09	2058.24	2074.24	73604.0
2010-01-27 16:00:00	NQ	Futures	2073.95	2074.24	2063.96	2067.38	17264.0
2010-01-27 17:00:00	NQ	Futures	2067.1	2067.95	2065.1	2066.81	614.0
2010-01-27 18:00:00	NQ	Futures	2066.53	2071.67	2065.96	2068.81	719.0
2010-01-27 19:00:00	NQ	Futures	2068.81	2070.81	2067.95	2069.1	363.0
2010-01-27 20:00:00	NQ	Futures	2069.38	2073.38	2069.38	2070.53	1223.0
2010-01-27 21:00:00	NQ	Futures	2070.81	2075.1	2069.95	2073.95	1715.0
2010-01-27 22:00:00	NQ	Futures	2073.95	2079.09	2072.81	2078.52	1935.0
2010-01-27 23:00:00	NQ	Futures	2078.52	2079.38	2075.95	2079.38	823.0
2010-01-27 00:00:00	YM	Futures	9506.9	9506.9	9490.1	9496.6	298.0
2010-01-27 01:00:00	YM	Futures	9495.7	9496.6	9489.1	9489.1	163.0

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

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