PREVIEW / futures_1hour / 2008-01-31

all futures 1-hour files

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

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-31 00:00:00	ES	Futures	1252.98	1255.31	1250.42	1254.61	3473.0
2008-01-31 01:00:00	ES	Futures	1254.38	1256.48	1253.21	1255.31	3499.0
2008-01-31 02:00:00	ES	Futures	1255.55	1261.37	1255.31	1259.51	20857.0
2008-01-31 03:00:00	ES	Futures	1259.74	1263.71	1253.91	1255.31	31630.0
2008-01-31 04:00:00	ES	Futures	1255.55	1257.18	1250.65	1256.94	30389.0
2008-01-31 05:00:00	ES	Futures	1256.94	1259.98	1254.38	1255.78	22986.0
2008-01-31 06:00:00	ES	Futures	1255.78	1256.94	1251.82	1256.25	26656.0
2008-01-31 07:00:00	ES	Futures	1256.25	1257.41	1253.45	1256.01	34515.0
2008-01-31 08:00:00	ES	Futures	1256.01	1256.48	1241.79	1243.42	121334.0
2008-01-31 09:00:00	ES	Futures	1243.42	1255.78	1243.19	1254.61	277838.0
2008-01-31 10:00:00	ES	Futures	1254.61	1262.54	1250.88	1262.07	418522.0
2008-01-31 11:00:00	ES	Futures	1262.07	1283.76	1258.11	1277.46	525534.0
2008-01-31 12:00:00	ES	Futures	1277.46	1278.4	1268.14	1271.17	273234.0
2008-01-31 13:00:00	ES	Futures	1271.17	1279.79	1268.84	1276.06	210881.0
2008-01-31 14:00:00	ES	Futures	1276.3	1284.46	1274.43	1284.22	278678.0
2008-01-31 15:00:00	ES	Futures	1284.22	1293.78	1278.4	1281.66	613726.0
2008-01-31 16:00:00	ES	Futures	1281.66	1283.76	1269.3	1281.66	200694.0
2008-01-31 17:00:00	ES	Futures	1281.43	1283.76	1280.26	1281.43	4254.0
2008-01-31 18:00:00	ES	Futures	1281.43	1284.92	1281.19	1282.59	5010.0
2008-01-31 19:00:00	ES	Futures	1282.36	1284.92	1282.13	1282.36	3027.0
2008-01-31 20:00:00	ES	Futures	1282.13	1284.22	1280.73	1282.13	2459.0
2008-01-31 21:00:00	ES	Futures	1282.13	1282.83	1280.73	1280.96	1720.0
2008-01-31 22:00:00	ES	Futures	1281.19	1282.13	1280.26	1281.89	1159.0
2008-01-31 23:00:00	ES	Futures	1281.66	1283.99	1281.43	1283.06	1106.0
2008-01-31 00:00:00	NQ	Futures	2036.29	2042.26	2031.19	2041.12	283.0
2008-01-31 01:00:00	NQ	Futures	2041.12	2042.26	2038.28	2041.4	150.0
2008-01-31 02:00:00	NQ	Futures	2041.4	2052.76	2040.55	2049.35	1101.0
2008-01-31 03:00:00	NQ	Futures	2049.64	2057.02	2039.98	2041.97	1612.0
2008-01-31 04:00:00	NQ	Futures	2041.69	2047.93	2032.6	2045.95	3101.0
2008-01-31 05:00:00	NQ	Futures	2047.08	2050.2	2041.12	2045.09	1985.0
2008-01-31 06:00:00	NQ	Futures	2045.38	2048.22	2040.55	2047.65	1487.0
2008-01-31 07:00:00	NQ	Futures	2047.08	2050.77	2042.54	2047.36	1740.0
2008-01-31 08:00:00	NQ	Futures	2047.08	2049.35	2024.94	2026.93	13652.0
2008-01-31 09:00:00	NQ	Futures	2027.21	2043.96	2026.08	2041.4	53718.0
2008-01-31 10:00:00	NQ	Futures	2041.12	2049.92	2037.43	2049.07	85015.0
2008-01-31 11:00:00	NQ	Futures	2048.78	2086.25	2042.54	2078.59	107665.0
2008-01-31 12:00:00	NQ	Futures	2078.59	2079.72	2065.25	2070.07	47946.0
2008-01-31 13:00:00	NQ	Futures	2070.07	2085.4	2065.53	2078.87	37860.0
2008-01-31 14:00:00	NQ	Futures	2078.87	2094.48	2077.74	2093.63	61528.0
2008-01-31 15:00:00	NQ	Futures	2093.91	2112.36	2087.39	2090.22	112232.0
2008-01-31 16:00:00	NQ	Futures	2089.94	2090.51	2058.43	2080.57	42355.0
2008-01-31 17:00:00	NQ	Futures	2081.71	2087.39	2081.14	2082.28	1540.0
2008-01-31 18:00:00	NQ	Futures	2084.26	2089.09	2083.41	2089.09	806.0
2008-01-31 19:00:00	NQ	Futures	2089.09	2091.36	2083.41	2086.25	1165.0
2008-01-31 20:00:00	NQ	Futures	2086.25	2087.39	2083.98	2087.39	64.0
2008-01-31 21:00:00	NQ	Futures	2086.82	2087.67	2085.4	2085.97	97.0
2008-01-31 22:00:00	NQ	Futures	2085.97	2088.81	2085.4	2087.95	277.0
2008-01-31 23:00:00	NQ	Futures	2089.09	2091.08	2086.82	2089.66	365.0
2008-01-31 00:00:00	YM	Futures	11208.1	11223.6	11196.3	11223.6	206.0
2008-01-31 01:00:00	YM	Futures	11219.0	11232.7	11208.1	11220.0	394.0

> showing 50 of 814 rows — these rows as CSV

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