PREVIEW / futures_1hour / 2008-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-08.parquet
  size:    43 KB
  rows:    1,231

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-07-08 00:00:00	ES	Futures	1156.03	1156.73	1154.87	1155.34	3611.0
2008-07-08 01:00:00	ES	Futures	1155.34	1156.27	1154.64	1155.8	3417.0
2008-07-08 02:00:00	ES	Futures	1155.8	1158.13	1155.8	1156.03	7894.0
2008-07-08 03:00:00	ES	Futures	1156.03	1157.43	1150.46	1151.62	29265.0
2008-07-08 04:00:00	ES	Futures	1151.39	1153.01	1149.53	1152.08	20754.0
2008-07-08 05:00:00	ES	Futures	1152.08	1156.96	1151.85	1156.96	18868.0
2008-07-08 06:00:00	ES	Futures	1156.96	1160.45	1155.34	1159.75	22131.0
2008-07-08 07:00:00	ES	Futures	1159.75	1160.91	1154.87	1156.5	35682.0
2008-07-08 08:00:00	ES	Futures	1156.5	1165.8	1156.5	1161.38	102566.0
2008-07-08 09:00:00	ES	Futures	1161.61	1169.28	1159.99	1165.33	353129.0
2008-07-08 10:00:00	ES	Futures	1165.1	1167.89	1156.03	1161.38	472636.0
2008-07-08 11:00:00	ES	Futures	1161.15	1168.58	1158.82	1165.56	323777.0
2008-07-08 12:00:00	ES	Futures	1165.33	1172.3	1164.17	1168.82	224286.0
2008-07-08 13:00:00	ES	Futures	1168.82	1172.07	1162.31	1163.7	201877.0
2008-07-08 14:00:00	ES	Futures	1163.7	1177.65	1162.54	1177.42	298753.0
2008-07-08 15:00:00	ES	Futures	1177.42	1186.02	1176.02	1185.09	506562.0
2008-07-08 16:00:00	ES	Futures	1185.09	1186.48	1183.69	1184.85	113419.0
2008-07-08 17:00:00	ES	Futures	1185.09	1185.55	1184.85	1185.55	1923.0
2008-07-08 18:00:00	ES	Futures	1185.55	1186.95	1184.85	1185.32	2293.0
2008-07-08 19:00:00	ES	Futures	1185.32	1185.55	1184.39	1185.09	4340.0
2008-07-08 20:00:00	ES	Futures	1185.09	1185.32	1184.16	1184.39	2072.0
2008-07-08 21:00:00	ES	Futures	1184.39	1185.55	1184.39	1185.09	1380.0
2008-07-08 22:00:00	ES	Futures	1185.09	1185.55	1183.46	1184.16	2854.0
2008-07-08 23:00:00	ES	Futures	1184.16	1185.55	1183.69	1185.09	1122.0
2008-07-08 00:00:00	NQ	Futures	2048.63	2051.16	2046.38	2047.78	267.0
2008-07-08 01:00:00	NQ	Futures	2047.78	2049.19	2046.09	2048.34	264.0
2008-07-08 02:00:00	NQ	Futures	2047.78	2052.28	2047.78	2049.47	428.0
2008-07-08 03:00:00	NQ	Futures	2049.47	2050.31	2038.22	2039.06	2061.0
2008-07-08 04:00:00	NQ	Futures	2039.34	2042.72	2037.37	2041.31	1162.0
2008-07-08 05:00:00	NQ	Futures	2041.88	2049.47	2040.75	2049.47	1579.0
2008-07-08 06:00:00	NQ	Futures	2049.47	2055.1	2046.09	2054.25	1628.0
2008-07-08 07:00:00	NQ	Futures	2053.97	2056.78	2046.38	2050.31	3422.0
2008-07-08 08:00:00	NQ	Futures	2050.03	2067.19	2050.03	2059.6	10688.0
2008-07-08 09:00:00	NQ	Futures	2059.6	2083.22	2054.53	2077.88	63893.0
2008-07-08 10:00:00	NQ	Futures	2077.32	2083.79	2057.06	2065.5	92950.0
2008-07-08 11:00:00	NQ	Futures	2065.22	2081.54	2057.06	2073.1	61520.0
2008-07-08 12:00:00	NQ	Futures	2073.38	2090.82	2069.72	2084.35	45707.0
2008-07-08 13:00:00	NQ	Futures	2084.35	2089.13	2068.32	2070.29	40308.0
2008-07-08 14:00:00	NQ	Futures	2070.29	2099.54	2069.16	2098.41	63329.0
2008-07-08 15:00:00	NQ	Futures	2098.41	2111.63	2094.48	2110.79	83615.0
2008-07-08 16:00:00	NQ	Futures	2110.79	2111.63	2096.45	2100.1	18978.0
2008-07-08 17:00:00	NQ	Futures	2100.1	2100.38	2099.54	2100.1	1677.0
2008-07-08 18:00:00	NQ	Futures	2100.66	2104.04	2100.38	2100.66	644.0
2008-07-08 19:00:00	NQ	Futures	2100.66	2102.07	2099.82	2101.79	393.0
2008-07-08 20:00:00	NQ	Futures	2101.51	2101.79	2099.54	2100.1	131.0
2008-07-08 21:00:00	NQ	Futures	2100.95	2102.35	2100.95	2102.07	125.0
2008-07-08 22:00:00	NQ	Futures	2101.79	2101.79	2099.26	2099.54	225.0
2008-07-08 23:00:00	NQ	Futures	2100.1	2102.07	2099.54	2101.51	128.0
2008-07-08 00:00:00	YM	Futures	10121.2	10132.1	10116.7	10118.5	254.0
2008-07-08 01:00:00	YM	Futures	10118.5	10127.6	10116.7	10127.6	215.0

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

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