PREVIEW / futures_1hour / 2008-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-17.parquet
  size:    44 KB
  rows:    1,244

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-17 00:00:00	ES	Futures	1151.39	1152.55	1150.92	1152.32	1070.0
2008-07-17 01:00:00	ES	Futures	1152.32	1153.48	1151.15	1153.25	1789.0
2008-07-17 02:00:00	ES	Futures	1153.48	1155.8	1151.85	1155.34	6101.0
2008-07-17 03:00:00	ES	Futures	1155.34	1156.96	1153.01	1154.41	24725.0
2008-07-17 04:00:00	ES	Futures	1154.17	1154.87	1151.62	1152.55	13661.0
2008-07-17 05:00:00	ES	Futures	1152.55	1156.03	1151.62	1155.8	16775.0
2008-07-17 06:00:00	ES	Futures	1155.8	1161.84	1152.78	1161.38	43555.0
2008-07-17 07:00:00	ES	Futures	1161.38	1166.26	1161.38	1163.24	65412.0
2008-07-17 08:00:00	ES	Futures	1163.24	1166.26	1160.22	1164.17	83349.0
2008-07-17 09:00:00	ES	Futures	1164.17	1170.21	1161.84	1163.24	377552.0
2008-07-17 10:00:00	ES	Futures	1163.47	1165.33	1157.66	1159.52	495322.0
2008-07-17 11:00:00	ES	Futures	1159.75	1164.17	1153.71	1162.54	382269.0
2008-07-17 12:00:00	ES	Futures	1162.54	1162.77	1157.66	1161.38	157297.0
2008-07-17 13:00:00	ES	Futures	1161.38	1173.23	1160.22	1171.14	366593.0
2008-07-17 14:00:00	ES	Futures	1171.37	1174.16	1164.17	1166.03	298971.0
2008-07-17 15:00:00	ES	Futures	1166.26	1171.37	1163.94	1170.91	333143.0
2008-07-17 16:00:00	ES	Futures	1170.68	1172.3	1158.59	1159.99	223999.0
2008-07-17 17:00:00	ES	Futures	1159.99	1160.22	1156.03	1157.89	11012.0
2008-07-17 18:00:00	ES	Futures	1157.43	1159.29	1156.96	1158.13	4685.0
2008-07-17 19:00:00	ES	Futures	1158.13	1158.82	1156.96	1157.2	1093.0
2008-07-17 20:00:00	ES	Futures	1157.2	1158.59	1156.5	1157.43	2845.0
2008-07-17 21:00:00	ES	Futures	1157.2	1157.66	1156.5	1157.2	2085.0
2008-07-17 22:00:00	ES	Futures	1156.96	1157.66	1156.73	1157.2	1689.0
2008-07-17 23:00:00	ES	Futures	1156.96	1157.43	1155.57	1156.03	3701.0
2008-07-17 00:00:00	NQ	Futures	2069.72	2070.57	2069.44	2070.57	42.0
2008-07-17 01:00:00	NQ	Futures	2070.57	2071.69	2069.44	2071.41	217.0
2008-07-17 02:00:00	NQ	Futures	2071.69	2075.91	2070.29	2075.07	459.0
2008-07-17 03:00:00	NQ	Futures	2075.07	2078.16	2070.29	2074.22	2063.0
2008-07-17 04:00:00	NQ	Futures	2074.22	2076.47	2070.0	2071.69	1160.0
2008-07-17 05:00:00	NQ	Futures	2071.69	2079.57	2071.13	2078.44	1481.0
2008-07-17 06:00:00	NQ	Futures	2078.44	2093.35	2074.79	2093.35	4711.0
2008-07-17 07:00:00	NQ	Futures	2093.35	2100.1	2092.79	2095.04	5892.0
2008-07-17 08:00:00	NQ	Futures	2095.04	2100.1	2090.26	2095.32	11006.0
2008-07-17 09:00:00	NQ	Futures	2095.32	2100.38	2081.26	2081.54	73563.0
2008-07-17 10:00:00	NQ	Futures	2081.26	2086.6	2071.69	2075.07	96281.0
2008-07-17 11:00:00	NQ	Futures	2075.07	2083.22	2062.97	2078.16	70284.0
2008-07-17 12:00:00	NQ	Futures	2078.16	2080.13	2066.91	2076.76	32882.0
2008-07-17 13:00:00	NQ	Futures	2077.04	2100.95	2074.22	2096.73	74066.0
2008-07-17 14:00:00	NQ	Futures	2096.73	2102.35	2089.69	2092.79	59141.0
2008-07-17 15:00:00	NQ	Futures	2092.79	2098.98	2082.94	2091.38	64234.0
2008-07-17 16:00:00	NQ	Futures	2091.38	2099.82	2054.81	2057.35	38380.0
2008-07-17 17:00:00	NQ	Futures	2058.19	2058.47	2053.97	2056.5	842.0
2008-07-17 18:00:00	NQ	Futures	2056.22	2058.47	2055.1	2056.5	924.0
2008-07-17 19:00:00	NQ	Futures	2056.5	2059.03	2056.22	2057.06	200.0
2008-07-17 20:00:00	NQ	Futures	2056.5	2059.03	2055.66	2056.78	295.0
2008-07-17 21:00:00	NQ	Futures	2056.78	2056.78	2055.66	2056.22	254.0
2008-07-17 22:00:00	NQ	Futures	2056.5	2057.63	2055.1	2055.66	181.0
2008-07-17 23:00:00	NQ	Futures	2055.1	2055.38	2053.97	2054.53	174.0
2008-07-17 00:00:00	YM	Futures	10163.9	10168.5	10159.4	10168.5	196.0
2008-07-17 01:00:00	YM	Futures	10170.3	10173.9	10161.2	10173.0	229.0

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

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