PREVIEW / futures_1hour / 2008-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-09.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-04-09 00:00:00	ES	Futures	1274.35	1275.05	1273.42	1274.12	1855.0
2008-04-09 01:00:00	ES	Futures	1274.12	1274.82	1272.49	1273.89	3096.0
2008-04-09 02:00:00	ES	Futures	1273.89	1273.89	1271.33	1271.79	5722.0
2008-04-09 03:00:00	ES	Futures	1271.56	1272.03	1269.7	1271.33	10315.0
2008-04-09 04:00:00	ES	Futures	1271.33	1272.03	1269.46	1270.63	8282.0
2008-04-09 05:00:00	ES	Futures	1270.4	1271.79	1270.16	1270.63	5487.0
2008-04-09 06:00:00	ES	Futures	1270.4	1275.75	1269.46	1274.82	14432.0
2008-04-09 07:00:00	ES	Futures	1274.82	1278.31	1273.19	1275.05	28803.0
2008-04-09 08:00:00	ES	Futures	1275.28	1276.45	1273.19	1274.59	28416.0
2008-04-09 09:00:00	ES	Futures	1274.35	1276.68	1269.7	1270.86	184452.0
2008-04-09 10:00:00	ES	Futures	1270.86	1271.79	1267.37	1270.63	287868.0
2008-04-09 11:00:00	ES	Futures	1270.63	1272.03	1262.01	1262.48	294627.0
2008-04-09 12:00:00	ES	Futures	1262.48	1265.27	1260.85	1261.31	163562.0
2008-04-09 13:00:00	ES	Futures	1261.08	1265.27	1259.68	1265.04	174552.0
2008-04-09 14:00:00	ES	Futures	1265.27	1266.2	1259.45	1260.15	221607.0
2008-04-09 15:00:00	ES	Futures	1260.15	1265.27	1258.52	1263.41	289500.0
2008-04-09 16:00:00	ES	Futures	1263.64	1267.37	1263.41	1266.2	70490.0
2008-04-09 17:00:00	ES	Futures	1266.2	1267.14	1265.97	1266.9	1506.0
2008-04-09 18:00:00	ES	Futures	1266.67	1267.37	1265.51	1265.97	1703.0
2008-04-09 19:00:00	ES	Futures	1265.97	1266.9	1265.04	1266.44	1529.0
2008-04-09 20:00:00	ES	Futures	1266.2	1266.67	1265.27	1265.51	2112.0
2008-04-09 21:00:00	ES	Futures	1265.51	1268.53	1265.51	1267.83	4378.0
2008-04-09 22:00:00	ES	Futures	1267.83	1267.83	1265.97	1267.37	1456.0
2008-04-09 23:00:00	ES	Futures	1267.37	1267.6	1265.51	1265.51	939.0
2008-04-09 00:00:00	NQ	Futures	2097.74	2097.74	2094.91	2095.19	52.0
2008-04-09 01:00:00	NQ	Futures	2095.48	2096.61	2093.78	2095.76	133.0
2008-04-09 02:00:00	NQ	Futures	2095.19	2096.89	2092.93	2092.93	206.0
2008-04-09 03:00:00	NQ	Futures	2092.93	2095.48	2090.1	2094.06	1056.0
2008-04-09 04:00:00	NQ	Futures	2094.06	2095.48	2091.8	2093.5	1440.0
2008-04-09 05:00:00	NQ	Futures	2093.5	2094.91	2090.67	2091.8	574.0
2008-04-09 06:00:00	NQ	Futures	2091.8	2099.15	2090.39	2098.59	931.0
2008-04-09 07:00:00	NQ	Futures	2098.87	2107.07	2098.59	2100.29	4625.0
2008-04-09 08:00:00	NQ	Futures	2100.29	2102.83	2097.46	2101.42	3845.0
2008-04-09 09:00:00	NQ	Futures	2101.42	2101.7	2079.36	2083.32	41406.0
2008-04-09 10:00:00	NQ	Futures	2083.32	2089.26	2076.24	2083.03	48973.0
2008-04-09 11:00:00	NQ	Futures	2083.03	2084.73	2064.65	2066.91	54010.0
2008-04-09 12:00:00	NQ	Futures	2067.19	2072.0	2065.21	2065.78	21996.0
2008-04-09 13:00:00	NQ	Futures	2065.5	2074.83	2064.93	2074.27	27723.0
2008-04-09 14:00:00	NQ	Futures	2074.55	2077.09	2059.56	2062.39	46669.0
2008-04-09 15:00:00	NQ	Futures	2062.39	2076.24	2060.12	2072.57	67847.0
2008-04-09 16:00:00	NQ	Futures	2072.29	2081.05	2072.29	2076.81	11489.0
2008-04-09 17:00:00	NQ	Futures	2077.09	2078.79	2077.09	2078.51	177.0
2008-04-09 18:00:00	NQ	Futures	2078.22	2078.79	2075.4	2075.68	101.0
2008-04-09 19:00:00	NQ	Futures	2076.53	2077.38	2074.27	2076.24	261.0
2008-04-09 20:00:00	NQ	Futures	2075.96	2076.81	2074.27	2074.83	146.0
2008-04-09 21:00:00	NQ	Futures	2075.11	2085.01	2075.11	2083.88	694.0
2008-04-09 22:00:00	NQ	Futures	2083.32	2083.32	2079.64	2082.75	137.0
2008-04-09 23:00:00	NQ	Futures	2082.75	2083.6	2079.36	2079.92	195.0
2008-04-09 00:00:00	YM	Futures	11442.6	11446.3	11431.7	11435.4	322.0
2008-04-09 01:00:00	YM	Futures	11438.1	11441.7	11426.3	11436.3	229.0

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

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