PREVIEW / futures_1hour / 2008-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-01.parquet
  size:    31 KB
  rows:    844

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-09-01 00:00:00	ES	Futures	1188.34	1189.27	1187.87	1189.27	602.0
2008-09-01 01:00:00	ES	Futures	1189.04	1190.2	1188.8	1189.97	727.0
2008-09-01 02:00:00	ES	Futures	1189.97	1190.2	1188.34	1189.5	1987.0
2008-09-01 03:00:00	ES	Futures	1189.73	1190.2	1186.95	1187.87	5825.0
2008-09-01 04:00:00	ES	Futures	1187.87	1190.66	1187.64	1188.57	4879.0
2008-09-01 05:00:00	ES	Futures	1188.57	1190.43	1188.34	1190.2	1880.0
2008-09-01 06:00:00	ES	Futures	1190.2	1192.06	1189.5	1191.83	3280.0
2008-09-01 07:00:00	ES	Futures	1191.59	1192.99	1191.13	1191.13	3798.0
2008-09-01 08:00:00	ES	Futures	1191.36	1191.59	1189.97	1190.43	1986.0
2008-09-01 09:00:00	ES	Futures	1190.2	1191.13	1188.8	1190.2	7871.0
2008-09-01 10:00:00	ES	Futures	1190.2	1194.15	1188.57	1193.69	18120.0
2008-09-01 11:00:00	ES	Futures	1193.69	1194.61	1192.06	1192.52	10964.0
2008-09-01 18:00:00	ES	Futures	1193.92	1194.85	1193.45	1194.15	3980.0
2008-09-01 19:00:00	ES	Futures	1194.38	1195.54	1194.15	1194.38	1577.0
2008-09-01 20:00:00	ES	Futures	1194.38	1194.61	1193.45	1194.15	2189.0
2008-09-01 21:00:00	ES	Futures	1194.15	1194.61	1193.92	1193.92	1817.0
2008-09-01 22:00:00	ES	Futures	1193.92	1195.31	1193.69	1194.85	1665.0
2008-09-01 23:00:00	ES	Futures	1195.08	1195.08	1193.69	1193.69	699.0
2008-09-01 00:00:00	NQ	Futures	2104.32	2104.6	2102.35	2104.32	144.0
2008-09-01 01:00:00	NQ	Futures	2104.32	2105.73	2104.32	2104.32	143.0
2008-09-01 02:00:00	NQ	Futures	2104.88	2105.73	2103.48	2105.45	239.0
2008-09-01 03:00:00	NQ	Futures	2105.17	2106.01	2101.51	2102.63	967.0
2008-09-01 04:00:00	NQ	Futures	2102.07	2104.32	2101.51	2101.51	1015.0
2008-09-01 05:00:00	NQ	Futures	2101.79	2104.6	2101.51	2104.04	263.0
2008-09-01 06:00:00	NQ	Futures	2104.04	2107.7	2103.48	2106.57	203.0
2008-09-01 07:00:00	NQ	Futures	2106.29	2108.54	2105.45	2105.45	473.0
2008-09-01 08:00:00	NQ	Futures	2106.01	2108.54	2104.32	2106.01	434.0
2008-09-01 09:00:00	NQ	Futures	2106.01	2107.13	2104.32	2105.73	1171.0
2008-09-01 10:00:00	NQ	Futures	2106.01	2113.32	2103.2	2113.32	1265.0
2008-09-01 11:00:00	NQ	Futures	2112.76	2114.17	2110.51	2111.92	699.0
2008-09-01 18:00:00	NQ	Futures	2114.17	2116.14	2113.89	2115.29	336.0
2008-09-01 19:00:00	NQ	Futures	2115.01	2116.98	2115.01	2115.29	217.0
2008-09-01 20:00:00	NQ	Futures	2115.29	2115.29	2113.89	2113.89	96.0
2008-09-01 21:00:00	NQ	Futures	2114.17	2115.57	2114.17	2114.73	211.0
2008-09-01 22:00:00	NQ	Futures	2114.45	2118.95	2114.17	2117.26	707.0
2008-09-01 23:00:00	NQ	Futures	2117.26	2117.26	2114.73	2115.01	255.0
2008-09-01 00:00:00	YM	Futures	10462.1	10469.3	10459.3	10466.6	182.0
2008-09-01 01:00:00	YM	Futures	10467.5	10474.8	10463.0	10470.2	93.0
2008-09-01 02:00:00	YM	Futures	10465.7	10471.1	10461.1	10467.5	68.0
2008-09-01 03:00:00	YM	Futures	10472.0	10474.8	10451.1	10461.1	483.0
2008-09-01 04:00:00	YM	Futures	10458.4	10485.7	10455.7	10466.6	245.0
2008-09-01 05:00:00	YM	Futures	10467.5	10479.3	10467.5	10478.4	96.0
2008-09-01 06:00:00	YM	Futures	10480.2	10490.2	10474.8	10489.3	231.0
2008-09-01 07:00:00	YM	Futures	10489.3	10497.5	10487.5	10490.2	347.0
2008-09-01 08:00:00	YM	Futures	10490.2	10490.2	10479.3	10483.9	185.0
2008-09-01 09:00:00	YM	Futures	10483.0	10488.4	10472.0	10482.0	750.0
2008-09-01 10:00:00	YM	Futures	10483.0	10510.2	10463.9	10505.7	1764.0
2008-09-01 11:00:00	YM	Futures	10508.4	10519.3	10501.1	10506.6	880.0
2008-09-01 18:00:00	YM	Futures	10512.0	10520.2	10509.3	10515.7	312.0
2008-09-01 19:00:00	YM	Futures	10515.7	10524.8	10515.7	10517.5	187.0

> showing 50 of 844 rows — these rows as CSV

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