PREVIEW / futures_1hour / 2010-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-24.parquet
  size:    45 KB
  rows:    1,378

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-24 00:00:00	ES	Futures	1067.42	1068.39	1067.18	1068.15	2877.0
2010-02-24 01:00:00	ES	Futures	1068.15	1069.12	1067.42	1068.64	3010.0
2010-02-24 02:00:00	ES	Futures	1068.88	1068.88	1066.69	1067.18	9384.0
2010-02-24 03:00:00	ES	Futures	1067.18	1068.64	1064.74	1064.99	25684.0
2010-02-24 04:00:00	ES	Futures	1064.99	1065.47	1063.04	1064.99	36344.0
2010-02-24 05:00:00	ES	Futures	1065.23	1066.45	1064.5	1066.2	15791.0
2010-02-24 06:00:00	ES	Futures	1066.2	1068.64	1064.99	1068.39	24155.0
2010-02-24 07:00:00	ES	Futures	1068.39	1069.85	1067.18	1068.88	31711.0
2010-02-24 08:00:00	ES	Futures	1069.12	1069.12	1067.66	1068.39	32192.0
2010-02-24 09:00:00	ES	Futures	1068.64	1072.28	1066.69	1070.58	184049.0
2010-02-24 10:00:00	ES	Futures	1070.58	1074.72	1064.26	1073.26	572217.0
2010-02-24 11:00:00	ES	Futures	1073.01	1075.2	1071.07	1072.53	206354.0
2010-02-24 12:00:00	ES	Futures	1072.77	1074.23	1071.31	1072.28	87001.0
2010-02-24 13:00:00	ES	Futures	1072.53	1075.69	1071.55	1073.99	117272.0
2010-02-24 14:00:00	ES	Futures	1073.99	1074.47	1069.37	1070.58	185784.0
2010-02-24 15:00:00	ES	Futures	1070.58	1074.47	1070.34	1073.74	225372.0
2010-02-24 16:00:00	ES	Futures	1073.74	1074.23	1072.28	1072.77	91243.0
2010-02-24 17:00:00	ES	Futures	1072.53	1073.26	1072.53	1072.77	1175.0
2010-02-24 18:00:00	ES	Futures	1073.01	1073.74	1072.53	1073.5	4502.0
2010-02-24 19:00:00	ES	Futures	1073.26	1073.74	1072.53	1072.53	3425.0
2010-02-24 20:00:00	ES	Futures	1072.77	1073.01	1070.34	1070.58	7209.0
2010-02-24 21:00:00	ES	Futures	1070.58	1072.04	1069.61	1070.34	6073.0
2010-02-24 22:00:00	ES	Futures	1070.34	1071.31	1067.66	1067.91	8914.0
2010-02-24 23:00:00	ES	Futures	1067.91	1068.15	1064.74	1065.96	14641.0
2010-02-24 00:00:00	NQ	Futures	2058.53	2059.96	2057.67	2059.1	175.0
2010-02-24 01:00:00	NQ	Futures	2059.39	2062.53	2059.1	2061.39	501.0
2010-02-24 02:00:00	NQ	Futures	2061.39	2061.39	2057.67	2057.96	1138.0
2010-02-24 03:00:00	NQ	Futures	2057.96	2061.67	2055.67	2055.67	3345.0
2010-02-24 04:00:00	NQ	Futures	2055.96	2056.82	2052.53	2055.67	2338.0
2010-02-24 05:00:00	NQ	Futures	2055.96	2059.67	2055.67	2058.53	1867.0
2010-02-24 06:00:00	NQ	Futures	2058.24	2062.81	2055.96	2062.53	1460.0
2010-02-24 07:00:00	NQ	Futures	2062.53	2064.81	2061.1	2063.38	2455.0
2010-02-24 08:00:00	NQ	Futures	2063.67	2063.67	2060.24	2062.53	3978.0
2010-02-24 09:00:00	NQ	Futures	2062.53	2072.53	2059.96	2070.53	47558.0
2010-02-24 10:00:00	NQ	Futures	2069.95	2079.09	2057.1	2074.52	82590.0
2010-02-24 11:00:00	NQ	Futures	2074.52	2077.1	2068.53	2071.67	35880.0
2010-02-24 12:00:00	NQ	Futures	2071.67	2075.1	2069.95	2072.24	16468.0
2010-02-24 13:00:00	NQ	Futures	2071.95	2077.1	2071.38	2075.1	20284.0
2010-02-24 14:00:00	NQ	Futures	2075.1	2075.38	2063.67	2064.24	28484.0
2010-02-24 15:00:00	NQ	Futures	2064.24	2071.67	2061.96	2070.24	37445.0
2010-02-24 16:00:00	NQ	Futures	2070.24	2073.1	2069.1	2071.1	9860.0
2010-02-24 17:00:00	NQ	Futures	2071.38	2071.38	2070.53	2070.81	151.0
2010-02-24 18:00:00	NQ	Futures	2071.1	2071.95	2070.81	2071.38	313.0
2010-02-24 19:00:00	NQ	Futures	2071.38	2072.53	2069.67	2069.95	457.0
2010-02-24 20:00:00	NQ	Futures	2069.95	2071.67	2067.38	2069.1	1031.0
2010-02-24 21:00:00	NQ	Futures	2069.1	2070.81	2066.81	2067.67	421.0
2010-02-24 22:00:00	NQ	Futures	2067.67	2069.1	2061.67	2061.96	901.0
2010-02-24 23:00:00	NQ	Futures	2061.96	2062.24	2054.53	2057.39	2135.0
2010-02-24 00:00:00	YM	Futures	9640.7	9647.3	9638.9	9645.4	176.0
2010-02-24 01:00:00	YM	Futures	9646.3	9652.0	9637.9	9649.2	425.0

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

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