PREVIEW / futures_1hour / 2010-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-21.parquet
  size:    48 KB
  rows:    1,418

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-01-21 00:00:00	ES	Futures	1106.83	1108.29	1105.85	1108.29	5735.0
2010-01-21 01:00:00	ES	Futures	1108.29	1108.53	1105.85	1106.1	4474.0
2010-01-21 02:00:00	ES	Futures	1106.1	1107.56	1103.91	1104.64	13305.0
2010-01-21 03:00:00	ES	Futures	1104.64	1106.34	1102.94	1103.42	30065.0
2010-01-21 04:00:00	ES	Futures	1103.42	1104.64	1102.45	1103.18	25913.0
2010-01-21 05:00:00	ES	Futures	1103.18	1103.67	1100.26	1100.75	27028.0
2010-01-21 06:00:00	ES	Futures	1100.5	1104.15	1100.5	1104.15	22218.0
2010-01-21 07:00:00	ES	Futures	1103.91	1106.83	1103.91	1105.12	36255.0
2010-01-21 08:00:00	ES	Futures	1105.37	1107.8	1100.26	1101.96	132336.0
2010-01-21 09:00:00	ES	Futures	1101.96	1107.56	1101.48	1103.42	276122.0
2010-01-21 10:00:00	ES	Futures	1103.42	1106.34	1088.83	1091.02	697908.0
2010-01-21 11:00:00	ES	Futures	1091.26	1091.75	1081.53	1084.2	633410.0
2010-01-21 12:00:00	ES	Futures	1084.2	1088.34	1081.77	1082.74	286329.0
2010-01-21 13:00:00	ES	Futures	1082.99	1086.64	1080.8	1085.66	237016.0
2010-01-21 14:00:00	ES	Futures	1085.91	1089.31	1082.99	1086.15	294803.0
2010-01-21 15:00:00	ES	Futures	1086.39	1086.88	1081.77	1082.26	473897.0
2010-01-21 16:00:00	ES	Futures	1082.26	1082.74	1078.61	1079.83	213498.0
2010-01-21 17:00:00	ES	Futures	1079.83	1080.31	1078.61	1078.85	3161.0
2010-01-21 18:00:00	ES	Futures	1078.85	1080.8	1078.61	1080.56	7647.0
2010-01-21 19:00:00	ES	Futures	1080.56	1081.29	1079.83	1081.04	5746.0
2010-01-21 20:00:00	ES	Futures	1080.8	1082.02	1079.34	1081.77	6232.0
2010-01-21 21:00:00	ES	Futures	1081.77	1082.99	1081.29	1081.77	6155.0
2010-01-21 22:00:00	ES	Futures	1081.77	1082.26	1080.31	1081.53	4884.0
2010-01-21 23:00:00	ES	Futures	1081.53	1082.02	1079.58	1082.02	4312.0
2010-01-21 00:00:00	NQ	Futures	2140.22	2143.08	2138.79	2142.79	504.0
2010-01-21 01:00:00	NQ	Futures	2142.79	2143.08	2138.51	2139.08	365.0
2010-01-21 02:00:00	NQ	Futures	2139.08	2140.79	2133.94	2134.79	817.0
2010-01-21 03:00:00	NQ	Futures	2134.79	2137.93	2130.79	2131.08	3135.0
2010-01-21 04:00:00	NQ	Futures	2131.36	2133.08	2128.51	2129.65	1976.0
2010-01-21 05:00:00	NQ	Futures	2129.65	2131.08	2125.08	2126.22	1671.0
2010-01-21 06:00:00	NQ	Futures	2126.51	2133.08	2125.94	2133.08	2253.0
2010-01-21 07:00:00	NQ	Futures	2133.08	2137.65	2132.22	2134.79	2743.0
2010-01-21 08:00:00	NQ	Futures	2135.08	2138.51	2127.65	2131.36	9755.0
2010-01-21 09:00:00	NQ	Futures	2131.36	2148.79	2130.79	2142.5	53813.0
2010-01-21 10:00:00	NQ	Futures	2141.93	2151.93	2111.37	2117.37	118082.0
2010-01-21 11:00:00	NQ	Futures	2117.37	2120.23	2102.52	2108.23	86207.0
2010-01-21 12:00:00	NQ	Futures	2108.23	2114.8	2103.37	2106.23	44876.0
2010-01-21 13:00:00	NQ	Futures	2106.51	2116.23	2102.8	2114.8	31211.0
2010-01-21 14:00:00	NQ	Futures	2114.8	2121.94	2110.23	2116.51	49613.0
2010-01-21 15:00:00	NQ	Futures	2116.23	2117.08	2108.51	2111.08	58295.0
2010-01-21 16:00:00	NQ	Futures	2111.08	2112.8	2098.23	2100.8	33019.0
2010-01-21 17:00:00	NQ	Futures	2100.8	2101.37	2099.09	2099.09	252.0
2010-01-21 18:00:00	NQ	Futures	2099.66	2102.52	2098.52	2101.94	426.0
2010-01-21 19:00:00	NQ	Futures	2101.66	2103.09	2100.8	2102.8	514.0
2010-01-21 20:00:00	NQ	Futures	2102.52	2105.94	2099.95	2104.52	790.0
2010-01-21 21:00:00	NQ	Futures	2104.23	2105.37	2102.52	2102.8	549.0
2010-01-21 22:00:00	NQ	Futures	2103.37	2103.94	2100.8	2103.37	350.0
2010-01-21 23:00:00	NQ	Futures	2103.66	2104.8	2100.23	2104.52	307.0
2010-01-21 00:00:00	YM	Futures	9901.8	9911.2	9893.4	9908.4	423.0
2010-01-21 01:00:00	YM	Futures	9909.3	9909.3	9891.5	9893.4	345.0

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

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