PREVIEW / futures_1hour / 2010-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-25.parquet
  size:    46 KB
  rows:    1,371

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-02-25 00:00:00	ES	Futures	1066.2	1066.69	1065.47	1065.72	4635.0
2010-02-25 01:00:00	ES	Futures	1065.72	1067.42	1065.47	1066.93	7321.0
2010-02-25 02:00:00	ES	Futures	1067.18	1067.91	1065.47	1067.18	13380.0
2010-02-25 03:00:00	ES	Futures	1067.42	1069.61	1065.47	1069.37	35909.0
2010-02-25 04:00:00	ES	Futures	1069.37	1071.8	1067.42	1070.58	23735.0
2010-02-25 05:00:00	ES	Futures	1070.58	1071.31	1068.88	1069.12	15527.0
2010-02-25 06:00:00	ES	Futures	1069.12	1070.1	1068.15	1069.12	13865.0
2010-02-25 07:00:00	ES	Futures	1069.12	1069.37	1065.72	1067.18	30712.0
2010-02-25 08:00:00	ES	Futures	1067.18	1068.15	1061.82	1063.04	142434.0
2010-02-25 09:00:00	ES	Futures	1062.8	1063.04	1055.26	1058.66	387495.0
2010-02-25 10:00:00	ES	Futures	1058.66	1060.85	1056.47	1059.15	341704.0
2010-02-25 11:00:00	ES	Futures	1059.15	1060.12	1056.23	1057.2	225838.0
2010-02-25 12:00:00	ES	Futures	1057.45	1061.34	1056.72	1059.88	164403.0
2010-02-25 13:00:00	ES	Futures	1059.88	1066.69	1058.91	1066.69	275561.0
2010-02-25 14:00:00	ES	Futures	1066.69	1068.88	1065.47	1067.66	376160.0
2010-02-25 15:00:00	ES	Futures	1067.42	1073.01	1066.69	1072.53	479495.0
2010-02-25 16:00:00	ES	Futures	1072.77	1073.26	1071.07	1072.04	105413.0
2010-02-25 17:00:00	ES	Futures	1071.8	1073.01	1071.31	1071.55	4029.0
2010-02-25 18:00:00	ES	Futures	1072.04	1073.74	1071.55	1073.5	6246.0
2010-02-25 19:00:00	ES	Futures	1073.26	1074.96	1073.01	1074.23	8269.0
2010-02-25 20:00:00	ES	Futures	1074.23	1077.88	1073.5	1076.66	10866.0
2010-02-25 21:00:00	ES	Futures	1076.91	1077.15	1075.69	1076.18	3634.0
2010-02-25 22:00:00	ES	Futures	1076.18	1076.42	1074.96	1075.93	3557.0
2010-02-25 23:00:00	ES	Futures	1075.93	1076.66	1075.69	1075.69	1969.0
2010-02-25 00:00:00	NQ	Futures	2057.67	2058.24	2055.67	2057.1	351.0
2010-02-25 01:00:00	NQ	Futures	2057.1	2059.67	2056.82	2059.39	476.0
2010-02-25 02:00:00	NQ	Futures	2059.67	2060.53	2057.1	2059.96	868.0
2010-02-25 03:00:00	NQ	Futures	2059.96	2062.53	2056.53	2061.96	3314.0
2010-02-25 04:00:00	NQ	Futures	2062.24	2067.67	2059.67	2065.38	1552.0
2010-02-25 05:00:00	NQ	Futures	2065.67	2066.81	2062.53	2063.1	1249.0
2010-02-25 06:00:00	NQ	Futures	2063.1	2065.38	2061.39	2063.1	1070.0
2010-02-25 07:00:00	NQ	Futures	2063.1	2063.67	2058.53	2061.96	1543.0
2010-02-25 08:00:00	NQ	Futures	2061.67	2062.81	2051.39	2053.1	10347.0
2010-02-25 09:00:00	NQ	Futures	2052.82	2054.24	2034.25	2039.11	55753.0
2010-02-25 10:00:00	NQ	Futures	2038.82	2043.39	2035.39	2039.39	49329.0
2010-02-25 11:00:00	NQ	Futures	2039.39	2043.68	2035.96	2037.68	33776.0
2010-02-25 12:00:00	NQ	Futures	2037.39	2043.68	2036.54	2042.25	20393.0
2010-02-25 13:00:00	NQ	Futures	2042.25	2060.24	2040.53	2059.96	38760.0
2010-02-25 14:00:00	NQ	Futures	2060.24	2063.67	2057.1	2061.1	47621.0
2010-02-25 15:00:00	NQ	Futures	2061.1	2074.81	2060.24	2071.38	72575.0
2010-02-25 16:00:00	NQ	Futures	2071.1	2073.1	2067.1	2070.24	9121.0
2010-02-25 17:00:00	NQ	Futures	2069.95	2071.67	2069.67	2069.95	131.0
2010-02-25 18:00:00	NQ	Futures	2069.67	2072.24	2069.67	2071.95	365.0
2010-02-25 19:00:00	NQ	Futures	2071.67	2074.81	2071.67	2073.1	618.0
2010-02-25 20:00:00	NQ	Futures	2073.1	2081.95	2072.53	2077.95	1215.0
2010-02-25 21:00:00	NQ	Futures	2078.24	2078.52	2075.95	2076.52	415.0
2010-02-25 22:00:00	NQ	Futures	2076.24	2077.1	2074.24	2076.24	363.0
2010-02-25 23:00:00	NQ	Futures	2075.95	2077.67	2075.67	2075.67	160.0
2010-02-25 00:00:00	YM	Futures	9632.3	9636.1	9625.8	9630.4	339.0
2010-02-25 01:00:00	YM	Futures	9630.4	9642.6	9629.5	9638.9	489.0

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

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