PREVIEW / futures_1hour / 2010-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-22.parquet
  size:    42 KB
  rows:    1,321

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-22 00:00:00	ES	Futures	1079.34	1079.58	1078.85	1079.34	1275.0
2010-02-22 01:00:00	ES	Futures	1079.1	1080.31	1078.37	1078.85	4826.0
2010-02-22 02:00:00	ES	Futures	1078.85	1080.8	1078.12	1080.8	11610.0
2010-02-22 03:00:00	ES	Futures	1080.8	1081.04	1077.15	1077.39	26418.0
2010-02-22 04:00:00	ES	Futures	1077.64	1079.58	1076.42	1077.88	19001.0
2010-02-22 05:00:00	ES	Futures	1078.12	1079.34	1077.15	1078.37	11947.0
2010-02-22 06:00:00	ES	Futures	1078.37	1078.85	1077.64	1078.12	9743.0
2010-02-22 07:00:00	ES	Futures	1078.12	1082.74	1078.12	1082.26	31604.0
2010-02-22 08:00:00	ES	Futures	1082.26	1082.26	1080.31	1080.8	26105.0
2010-02-22 09:00:00	ES	Futures	1080.8	1081.04	1075.45	1077.64	190453.0
2010-02-22 10:00:00	ES	Futures	1077.64	1078.61	1073.74	1076.18	248869.0
2010-02-22 11:00:00	ES	Futures	1076.18	1076.91	1074.47	1075.2	155226.0
2010-02-22 12:00:00	ES	Futures	1075.2	1077.88	1074.72	1077.39	78503.0
2010-02-22 13:00:00	ES	Futures	1077.15	1078.61	1075.93	1076.66	78147.0
2010-02-22 14:00:00	ES	Futures	1076.66	1079.83	1076.66	1079.1	93370.0
2010-02-22 15:00:00	ES	Futures	1079.1	1080.31	1074.96	1076.66	212468.0
2010-02-22 16:00:00	ES	Futures	1076.66	1078.12	1076.66	1076.66	80371.0
2010-02-22 17:00:00	ES	Futures	1076.91	1077.64	1076.66	1077.39	1860.0
2010-02-22 18:00:00	ES	Futures	1076.91	1077.64	1076.42	1077.15	2763.0
2010-02-22 19:00:00	ES	Futures	1077.39	1077.88	1076.42	1076.66	2886.0
2010-02-22 20:00:00	ES	Futures	1076.42	1076.91	1075.69	1075.69	3238.0
2010-02-22 21:00:00	ES	Futures	1075.69	1076.42	1075.45	1075.93	3340.0
2010-02-22 22:00:00	ES	Futures	1076.18	1077.39	1075.45	1077.15	4330.0
2010-02-22 23:00:00	ES	Futures	1076.91	1078.85	1076.91	1078.12	3843.0
2010-02-22 00:00:00	NQ	Futures	2085.38	2085.66	2084.81	2085.09	47.0
2010-02-22 01:00:00	NQ	Futures	2085.09	2088.81	2085.09	2086.24	525.0
2010-02-22 02:00:00	NQ	Futures	2086.24	2089.66	2085.09	2089.66	631.0
2010-02-22 03:00:00	NQ	Futures	2089.66	2089.95	2081.67	2082.24	2220.0
2010-02-22 04:00:00	NQ	Futures	2082.52	2085.95	2080.52	2083.95	1487.0
2010-02-22 05:00:00	NQ	Futures	2083.66	2086.52	2083.38	2085.38	947.0
2010-02-22 06:00:00	NQ	Futures	2085.66	2087.95	2084.81	2086.24	1258.0
2010-02-22 07:00:00	NQ	Futures	2086.52	2094.23	2086.24	2092.52	3108.0
2010-02-22 08:00:00	NQ	Futures	2091.95	2092.52	2089.09	2091.09	3380.0
2010-02-22 09:00:00	NQ	Futures	2091.09	2091.66	2073.1	2075.95	44750.0
2010-02-22 10:00:00	NQ	Futures	2075.95	2079.09	2068.24	2074.81	49791.0
2010-02-22 11:00:00	NQ	Futures	2074.81	2076.81	2069.95	2071.38	29343.0
2010-02-22 12:00:00	NQ	Futures	2071.38	2076.24	2070.24	2074.81	12416.0
2010-02-22 13:00:00	NQ	Futures	2074.52	2078.52	2072.24	2075.1	15491.0
2010-02-22 14:00:00	NQ	Futures	2075.1	2081.67	2074.81	2080.81	16483.0
2010-02-22 15:00:00	NQ	Futures	2080.81	2082.24	2072.81	2075.95	31060.0
2010-02-22 16:00:00	NQ	Futures	2075.95	2081.09	2075.38	2078.81	11446.0
2010-02-22 17:00:00	NQ	Futures	2078.52	2079.09	2078.24	2078.81	258.0
2010-02-22 18:00:00	NQ	Futures	2078.81	2079.38	2077.67	2079.09	246.0
2010-02-22 19:00:00	NQ	Futures	2079.09	2079.95	2077.67	2077.95	310.0
2010-02-22 20:00:00	NQ	Futures	2077.95	2079.95	2076.81	2076.81	332.0
2010-02-22 21:00:00	NQ	Futures	2076.52	2077.67	2076.24	2076.81	333.0
2010-02-22 22:00:00	NQ	Futures	2077.38	2079.38	2076.24	2079.09	199.0
2010-02-22 23:00:00	NQ	Futures	2078.81	2081.95	2078.81	2081.67	361.0
2010-02-22 00:00:00	YM	Futures	9737.1	9738.1	9733.4	9735.2	64.0
2010-02-22 01:00:00	YM	Futures	9734.3	9742.7	9727.8	9731.5	375.0

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

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