PREVIEW / futures_1hour / 2010-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-02.parquet
  size:    44 KB
  rows:    1,365

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-03-02 00:00:00	ES	Futures	1084.45	1084.93	1083.72	1083.96	1759.0
2010-03-02 01:00:00	ES	Futures	1083.96	1084.93	1083.47	1084.45	2188.0
2010-03-02 02:00:00	ES	Futures	1084.69	1085.18	1083.72	1084.2	7650.0
2010-03-02 03:00:00	ES	Futures	1083.96	1085.18	1082.74	1082.99	24513.0
2010-03-02 04:00:00	ES	Futures	1082.74	1085.18	1082.74	1084.69	15543.0
2010-03-02 05:00:00	ES	Futures	1084.93	1087.12	1083.96	1086.88	18811.0
2010-03-02 06:00:00	ES	Futures	1086.88	1092.48	1086.64	1089.8	50629.0
2010-03-02 07:00:00	ES	Futures	1089.8	1091.02	1088.83	1090.77	24601.0
2010-03-02 08:00:00	ES	Futures	1090.53	1091.5	1089.56	1090.04	34186.0
2010-03-02 09:00:00	ES	Futures	1090.04	1090.77	1087.12	1089.07	189800.0
2010-03-02 10:00:00	ES	Futures	1089.07	1090.77	1086.15	1089.56	240424.0
2010-03-02 11:00:00	ES	Futures	1089.8	1091.75	1089.56	1090.77	156296.0
2010-03-02 12:00:00	ES	Futures	1091.02	1091.5	1088.58	1090.04	104824.0
2010-03-02 13:00:00	ES	Futures	1090.04	1092.48	1089.56	1091.5	84177.0
2010-03-02 14:00:00	ES	Futures	1091.75	1092.48	1087.12	1087.61	186300.0
2010-03-02 15:00:00	ES	Futures	1087.61	1089.07	1085.18	1086.64	243670.0
2010-03-02 16:00:00	ES	Futures	1086.64	1088.34	1086.64	1088.1	74411.0
2010-03-02 17:00:00	ES	Futures	1088.1	1088.58	1087.85	1087.85	1803.0
2010-03-02 18:00:00	ES	Futures	1087.85	1088.34	1087.37	1087.37	2322.0
2010-03-02 19:00:00	ES	Futures	1087.37	1088.34	1087.37	1087.85	2643.0
2010-03-02 20:00:00	ES	Futures	1087.85	1088.1	1087.12	1087.37	5857.0
2010-03-02 21:00:00	ES	Futures	1087.37	1087.37	1085.91	1086.64	6605.0
2010-03-02 22:00:00	ES	Futures	1086.64	1086.88	1085.91	1086.39	1553.0
2010-03-02 23:00:00	ES	Futures	1086.39	1087.12	1086.39	1086.39	1531.0
2010-03-02 00:00:00	NQ	Futures	2109.09	2110.23	2107.94	2108.23	205.0
2010-03-02 01:00:00	NQ	Futures	2108.23	2109.66	2107.66	2108.8	205.0
2010-03-02 02:00:00	NQ	Futures	2109.66	2109.94	2107.66	2108.51	434.0
2010-03-02 03:00:00	NQ	Futures	2108.51	2110.8	2105.94	2106.23	2378.0
2010-03-02 04:00:00	NQ	Futures	2106.8	2108.8	2105.09	2108.23	1589.0
2010-03-02 05:00:00	NQ	Futures	2108.51	2111.66	2108.51	2111.37	1387.0
2010-03-02 06:00:00	NQ	Futures	2111.37	2118.8	2111.08	2114.8	3685.0
2010-03-02 07:00:00	NQ	Futures	2115.08	2117.37	2114.23	2116.23	2420.0
2010-03-02 08:00:00	NQ	Futures	2116.23	2118.23	2114.8	2116.51	4928.0
2010-03-02 09:00:00	NQ	Futures	2116.51	2121.65	2112.8	2119.37	42640.0
2010-03-02 10:00:00	NQ	Futures	2119.08	2121.65	2113.08	2118.23	40219.0
2010-03-02 11:00:00	NQ	Futures	2118.51	2123.94	2118.23	2122.51	30137.0
2010-03-02 12:00:00	NQ	Futures	2122.8	2123.08	2117.37	2120.51	18503.0
2010-03-02 13:00:00	NQ	Futures	2120.8	2127.37	2119.65	2126.22	16741.0
2010-03-02 14:00:00	NQ	Futures	2126.51	2127.65	2114.23	2114.51	30235.0
2010-03-02 15:00:00	NQ	Futures	2114.51	2117.65	2109.66	2113.94	42100.0
2010-03-02 16:00:00	NQ	Futures	2113.66	2117.65	2113.66	2116.8	8459.0
2010-03-02 17:00:00	NQ	Futures	2116.8	2117.65	2116.51	2116.51	56.0
2010-03-02 18:00:00	NQ	Futures	2116.8	2117.37	2115.37	2115.66	150.0
2010-03-02 19:00:00	NQ	Futures	2115.37	2117.08	2115.37	2115.94	353.0
2010-03-02 20:00:00	NQ	Futures	2115.66	2115.94	2114.51	2115.08	246.0
2010-03-02 21:00:00	NQ	Futures	2115.08	2115.08	2113.37	2113.94	285.0
2010-03-02 22:00:00	NQ	Futures	2114.23	2114.51	2113.66	2114.23	71.0
2010-03-02 23:00:00	NQ	Futures	2113.94	2114.8	2113.66	2113.66	86.0
2010-03-02 00:00:00	YM	Futures	9720.3	9722.1	9714.7	9714.7	146.0
2010-03-02 01:00:00	YM	Futures	9714.7	9722.1	9710.0	9718.4	203.0

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

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