PREVIEW / futures_1hour / 2008-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-18.parquet
  size:    25 KB
  rows:    609

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
2008-01-18 00:00:00	ES	Futures	1258.11	1259.98	1257.88	1259.74	8076.0
2008-01-18 01:00:00	ES	Futures	1259.98	1260.21	1258.81	1259.04	3638.0
2008-01-18 02:00:00	ES	Futures	1259.04	1262.31	1258.11	1262.07	12686.0
2008-01-18 03:00:00	ES	Futures	1261.84	1262.31	1255.55	1257.64	23014.0
2008-01-18 04:00:00	ES	Futures	1257.88	1259.28	1254.15	1258.58	27256.0
2008-01-18 05:00:00	ES	Futures	1258.58	1265.8	1258.11	1262.07	34102.0
2008-01-18 06:00:00	ES	Futures	1262.07	1265.34	1260.21	1264.64	25268.0
2008-01-18 07:00:00	ES	Futures	1264.87	1268.37	1260.68	1267.2	47557.0
2008-01-18 08:00:00	ES	Futures	1267.2	1268.84	1262.77	1264.17	66460.0
2008-01-18 09:00:00	ES	Futures	1264.17	1264.41	1250.42	1252.51	410837.0
2008-01-18 10:00:00	ES	Futures	1252.51	1263.94	1249.72	1251.35	502673.0
2008-01-18 11:00:00	ES	Futures	1251.12	1252.28	1227.1	1230.37	612139.0
2008-01-18 12:00:00	ES	Futures	1230.13	1244.12	1229.2	1238.99	359084.0
2008-01-18 13:00:00	ES	Futures	1238.99	1243.89	1231.53	1235.49	231494.0
2008-01-18 14:00:00	ES	Futures	1235.26	1241.09	1229.67	1235.49	270224.0
2008-01-18 15:00:00	ES	Futures	1235.49	1242.02	1231.3	1240.16	404670.0
2008-01-18 16:00:00	ES	Futures	1240.16	1241.32	1235.26	1235.96	114467.0
2008-01-18 00:00:00	NQ	Futures	2123.72	2125.42	2123.15	2125.42	268.0
2008-01-18 01:00:00	NQ	Futures	2125.14	2126.27	2123.72	2125.42	188.0
2008-01-18 02:00:00	NQ	Futures	2125.42	2127.69	2123.15	2126.56	987.0
2008-01-18 03:00:00	NQ	Futures	2127.69	2127.69	2117.47	2121.73	1312.0
2008-01-18 04:00:00	NQ	Futures	2122.02	2124.57	2115.2	2124.29	1906.0
2008-01-18 05:00:00	NQ	Futures	2124.0	2133.37	2123.15	2127.12	2619.0
2008-01-18 06:00:00	NQ	Futures	2126.84	2132.8	2124.0	2132.52	1483.0
2008-01-18 07:00:00	NQ	Futures	2132.52	2136.21	2124.29	2135.64	4693.0
2008-01-18 08:00:00	NQ	Futures	2135.64	2139.05	2127.41	2132.8	8014.0
2008-01-18 09:00:00	NQ	Futures	2132.52	2133.09	2108.67	2120.31	87012.0
2008-01-18 10:00:00	NQ	Futures	2120.31	2142.45	2117.76	2124.85	94763.0
2008-01-18 11:00:00	NQ	Futures	2124.85	2127.12	2087.95	2093.91	127494.0
2008-01-18 12:00:00	NQ	Futures	2094.2	2125.14	2092.5	2114.07	86059.0
2008-01-18 13:00:00	NQ	Futures	2114.35	2124.57	2101.29	2106.97	53472.0
2008-01-18 14:00:00	NQ	Futures	2106.97	2113.5	2090.22	2103.85	65728.0
2008-01-18 15:00:00	NQ	Futures	2103.85	2114.07	2095.62	2106.69	85226.0
2008-01-18 16:00:00	NQ	Futures	2106.4	2106.69	2095.05	2099.02	14623.0
2008-01-18 00:00:00	YM	Futures	11160.9	11179.1	11160.9	11179.1	373.0
2008-01-18 01:00:00	YM	Futures	11177.3	11184.5	11169.1	11180.0	304.0
2008-01-18 02:00:00	YM	Futures	11181.8	11199.1	11176.3	11198.1	1145.0
2008-01-18 03:00:00	YM	Futures	11198.1	11199.1	11149.1	11164.5	2164.0
2008-01-18 04:00:00	YM	Futures	11164.5	11171.8	11137.3	11167.3	3339.0
2008-01-18 05:00:00	YM	Futures	11167.3	11216.3	11162.7	11191.8	2061.0
2008-01-18 06:00:00	YM	Futures	11192.7	11213.6	11176.3	11205.4	1268.0
2008-01-18 07:00:00	YM	Futures	11206.3	11247.2	11180.9	11244.5	2737.0
2008-01-18 08:00:00	YM	Futures	11244.5	11250.8	11201.8	11211.8	5168.0
2008-01-18 09:00:00	YM	Futures	11210.9	11214.5	11133.6	11154.5	25508.0
2008-01-18 10:00:00	YM	Futures	11149.1	11236.3	11129.1	11140.0	38814.0
2008-01-18 11:00:00	YM	Futures	11141.8	11150.0	10957.4	10979.2	57926.0
2008-01-18 12:00:00	YM	Futures	10980.1	11094.6	10971.9	11042.8	40817.0
2008-01-18 13:00:00	YM	Futures	11041.9	11077.3	10978.3	11001.9	28507.0
2008-01-18 14:00:00	YM	Futures	11002.8	11051.0	10948.3	10997.4	31719.0
2008-01-18 15:00:00	YM	Futures	10997.4	11045.5	10960.1	11023.7	37390.0

> showing 50 of 609 rows — these rows as CSV

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