PREVIEW / futures_1hour / 2010-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-23.parquet
  size:    47 KB
  rows:    1,383

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-23 00:00:00	ES	Futures	1078.12	1078.85	1078.12	1078.37	2125.0
2010-02-23 01:00:00	ES	Futures	1078.37	1078.85	1077.39	1078.61	2220.0
2010-02-23 02:00:00	ES	Futures	1078.37	1081.77	1078.12	1081.04	17679.0
2010-02-23 03:00:00	ES	Futures	1080.8	1082.74	1080.8	1081.29	23616.0
2010-02-23 04:00:00	ES	Futures	1081.29	1081.29	1079.34	1080.31	18353.0
2010-02-23 05:00:00	ES	Futures	1080.07	1080.07	1074.47	1075.2	41041.0
2010-02-23 06:00:00	ES	Futures	1075.2	1075.93	1072.53	1073.99	34510.0
2010-02-23 07:00:00	ES	Futures	1073.99	1075.69	1072.77	1074.96	27941.0
2010-02-23 08:00:00	ES	Futures	1074.96	1075.93	1072.28	1074.23	44875.0
2010-02-23 09:00:00	ES	Futures	1074.23	1077.64	1073.01	1076.18	207263.0
2010-02-23 10:00:00	ES	Futures	1075.93	1075.93	1064.01	1067.42	509234.0
2010-02-23 11:00:00	ES	Futures	1067.18	1068.39	1065.23	1065.96	194344.0
2010-02-23 12:00:00	ES	Futures	1065.96	1066.2	1061.58	1063.77	245586.0
2010-02-23 13:00:00	ES	Futures	1063.77	1065.23	1061.82	1062.55	174257.0
2010-02-23 14:00:00	ES	Futures	1062.55	1066.69	1060.85	1065.72	237203.0
2010-02-23 15:00:00	ES	Futures	1065.96	1067.66	1062.8	1063.53	280662.0
2010-02-23 16:00:00	ES	Futures	1063.53	1067.91	1063.28	1067.18	136466.0
2010-02-23 17:00:00	ES	Futures	1066.93	1067.18	1066.45	1066.69	2063.0
2010-02-23 18:00:00	ES	Futures	1066.69	1067.18	1065.96	1066.2	4370.0
2010-02-23 19:00:00	ES	Futures	1066.45	1066.45	1065.72	1066.2	2735.0
2010-02-23 20:00:00	ES	Futures	1065.96	1067.66	1065.72	1067.18	4940.0
2010-02-23 21:00:00	ES	Futures	1067.42	1068.39	1066.93	1067.42	5421.0
2010-02-23 22:00:00	ES	Futures	1067.66	1069.12	1066.93	1068.39	5856.0
2010-02-23 23:00:00	ES	Futures	1068.39	1068.88	1066.93	1067.42	3150.0
2010-02-23 00:00:00	NQ	Futures	2081.67	2082.81	2081.38	2082.52	263.0
2010-02-23 01:00:00	NQ	Futures	2082.24	2082.81	2079.95	2081.38	178.0
2010-02-23 02:00:00	NQ	Futures	2081.38	2086.24	2081.09	2086.24	1091.0
2010-02-23 03:00:00	NQ	Futures	2085.95	2089.66	2085.09	2087.95	2535.0
2010-02-23 04:00:00	NQ	Futures	2087.95	2087.95	2082.52	2084.81	1748.0
2010-02-23 05:00:00	NQ	Futures	2084.81	2084.81	2071.95	2072.24	5477.0
2010-02-23 06:00:00	NQ	Futures	2071.95	2073.95	2068.53	2070.81	2560.0
2010-02-23 07:00:00	NQ	Futures	2070.81	2073.67	2070.81	2072.81	2188.0
2010-02-23 08:00:00	NQ	Futures	2072.53	2074.81	2069.67	2073.38	4197.0
2010-02-23 09:00:00	NQ	Futures	2073.1	2076.52	2067.95	2072.81	36447.0
2010-02-23 10:00:00	NQ	Futures	2072.81	2073.67	2048.25	2053.67	90778.0
2010-02-23 11:00:00	NQ	Futures	2053.67	2055.67	2047.39	2049.1	35267.0
2010-02-23 12:00:00	NQ	Futures	2048.82	2049.1	2039.68	2045.1	43728.0
2010-02-23 13:00:00	NQ	Futures	2044.82	2047.96	2042.25	2045.39	26728.0
2010-02-23 14:00:00	NQ	Futures	2045.68	2054.24	2042.53	2052.25	34605.0
2010-02-23 15:00:00	NQ	Futures	2052.25	2055.39	2047.68	2048.53	42559.0
2010-02-23 16:00:00	NQ	Futures	2048.53	2058.24	2048.53	2056.53	16641.0
2010-02-23 17:00:00	NQ	Futures	2056.24	2056.24	2055.67	2055.96	137.0
2010-02-23 18:00:00	NQ	Futures	2056.82	2056.82	2055.1	2055.96	434.0
2010-02-23 19:00:00	NQ	Futures	2055.96	2055.96	2054.24	2055.39	215.0
2010-02-23 20:00:00	NQ	Futures	2055.39	2057.67	2054.53	2057.1	554.0
2010-02-23 21:00:00	NQ	Futures	2057.39	2059.39	2057.1	2057.67	552.0
2010-02-23 22:00:00	NQ	Futures	2057.67	2060.53	2057.1	2059.67	467.0
2010-02-23 23:00:00	NQ	Futures	2059.39	2061.1	2057.96	2058.24	490.0
2010-02-23 00:00:00	YM	Futures	9715.6	9719.3	9714.7	9717.5	149.0
2010-02-23 01:00:00	YM	Futures	9717.5	9722.1	9710.9	9716.5	176.0

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

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