PREVIEW / futures_1hour / 2008-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-16.parquet
  size:    44 KB
  rows:    1,258

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-04-16 00:00:00	ES	Futures	1251.07	1251.53	1250.84	1251.53	518.0
2008-04-16 01:00:00	ES	Futures	1251.77	1252.0	1250.6	1250.84	1094.0
2008-04-16 02:00:00	ES	Futures	1250.84	1250.84	1248.51	1248.51	5332.0
2008-04-16 03:00:00	ES	Futures	1248.74	1249.9	1248.04	1248.97	7819.0
2008-04-16 04:00:00	ES	Futures	1248.74	1251.53	1248.28	1251.53	6469.0
2008-04-16 05:00:00	ES	Futures	1251.3	1251.53	1245.48	1246.65	17819.0
2008-04-16 06:00:00	ES	Futures	1246.65	1249.44	1246.18	1248.51	8622.0
2008-04-16 07:00:00	ES	Futures	1248.97	1251.3	1248.04	1250.37	20535.0
2008-04-16 08:00:00	ES	Futures	1250.37	1254.79	1248.28	1254.56	84508.0
2008-04-16 09:00:00	ES	Futures	1254.79	1258.75	1254.1	1256.42	276551.0
2008-04-16 10:00:00	ES	Futures	1256.66	1264.11	1254.56	1263.88	405586.0
2008-04-16 11:00:00	ES	Futures	1263.88	1264.57	1259.92	1261.08	221054.0
2008-04-16 12:00:00	ES	Futures	1261.08	1265.74	1260.85	1264.81	149987.0
2008-04-16 13:00:00	ES	Futures	1264.81	1265.74	1262.01	1263.41	136269.0
2008-04-16 14:00:00	ES	Futures	1263.41	1267.37	1260.62	1266.2	212223.0
2008-04-16 15:00:00	ES	Futures	1266.2	1273.66	1265.74	1270.63	358961.0
2008-04-16 16:00:00	ES	Futures	1270.63	1278.08	1270.63	1276.45	147659.0
2008-04-16 17:00:00	ES	Futures	1276.22	1276.45	1275.05	1275.05	3331.0
2008-04-16 18:00:00	ES	Futures	1275.28	1275.98	1274.59	1275.75	3179.0
2008-04-16 19:00:00	ES	Futures	1275.75	1275.98	1273.89	1274.12	2088.0
2008-04-16 20:00:00	ES	Futures	1273.89	1274.82	1273.89	1274.35	1085.0
2008-04-16 21:00:00	ES	Futures	1274.59	1275.98	1274.35	1274.82	1327.0
2008-04-16 22:00:00	ES	Futures	1274.82	1274.82	1273.89	1274.59	1383.0
2008-04-16 23:00:00	ES	Futures	1274.59	1276.68	1274.59	1276.45	1831.0
2008-04-16 00:00:00	NQ	Futures	2058.14	2060.12	2057.86	2060.12	120.0
2008-04-16 01:00:00	NQ	Futures	2059.56	2060.97	2058.43	2059.56	253.0
2008-04-16 02:00:00	NQ	Futures	2059.84	2059.84	2055.88	2056.45	615.0
2008-04-16 03:00:00	NQ	Futures	2056.45	2057.3	2055.03	2056.45	717.0
2008-04-16 04:00:00	NQ	Futures	2056.16	2061.25	2055.32	2060.69	999.0
2008-04-16 05:00:00	NQ	Futures	2060.41	2060.41	2052.77	2054.75	2024.0
2008-04-16 06:00:00	NQ	Futures	2055.03	2058.99	2054.18	2058.14	559.0
2008-04-16 07:00:00	NQ	Futures	2058.14	2060.69	2056.73	2060.12	2276.0
2008-04-16 08:00:00	NQ	Futures	2059.84	2064.93	2058.71	2064.37	7948.0
2008-04-16 09:00:00	NQ	Futures	2064.37	2066.35	2058.71	2061.54	49505.0
2008-04-16 10:00:00	NQ	Futures	2061.54	2081.34	2060.41	2081.34	83302.0
2008-04-16 11:00:00	NQ	Futures	2080.77	2088.12	2077.66	2084.16	49154.0
2008-04-16 12:00:00	NQ	Futures	2084.16	2091.52	2083.88	2089.54	35645.0
2008-04-16 13:00:00	NQ	Futures	2089.54	2091.23	2082.47	2084.16	27520.0
2008-04-16 14:00:00	NQ	Futures	2083.88	2093.21	2080.77	2091.52	41592.0
2008-04-16 15:00:00	NQ	Futures	2091.52	2099.15	2089.54	2093.21	65934.0
2008-04-16 16:00:00	NQ	Futures	2093.21	2114.99	2092.65	2107.64	31810.0
2008-04-16 17:00:00	NQ	Futures	2107.64	2107.64	2105.09	2106.51	737.0
2008-04-16 18:00:00	NQ	Futures	2105.94	2105.94	2102.83	2105.38	546.0
2008-04-16 19:00:00	NQ	Futures	2105.38	2105.94	2102.83	2103.11	165.0
2008-04-16 20:00:00	NQ	Futures	2103.4	2104.24	2102.55	2103.4	63.0
2008-04-16 21:00:00	NQ	Futures	2103.68	2105.94	2103.11	2105.38	113.0
2008-04-16 22:00:00	NQ	Futures	2105.38	2107.07	2104.81	2106.51	266.0
2008-04-16 23:00:00	NQ	Futures	2106.51	2108.77	2105.38	2108.77	45.0
2008-04-16 00:00:00	YM	Futures	11270.0	11280.0	11269.1	11280.0	74.0
2008-04-16 01:00:00	YM	Futures	11279.1	11281.8	11273.6	11273.6	226.0

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

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