PREVIEW / futures_1hour / 2008-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-22.parquet
  size:    42 KB
  rows:    1,224

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-22 00:00:00	ES	Futures	1287.16	1288.32	1286.93	1287.86	1045.0
2008-04-22 01:00:00	ES	Futures	1287.86	1289.49	1287.63	1287.86	1855.0
2008-04-22 02:00:00	ES	Futures	1287.86	1288.56	1286.69	1288.09	4670.0
2008-04-22 03:00:00	ES	Futures	1288.32	1290.42	1286.93	1289.95	13370.0
2008-04-22 04:00:00	ES	Futures	1289.95	1291.35	1289.02	1289.72	8615.0
2008-04-22 05:00:00	ES	Futures	1289.72	1294.15	1288.79	1293.68	12609.0
2008-04-22 06:00:00	ES	Futures	1293.68	1294.84	1291.12	1292.05	10499.0
2008-04-22 07:00:00	ES	Futures	1292.05	1294.38	1291.35	1292.05	24667.0
2008-04-22 08:00:00	ES	Futures	1292.05	1293.45	1289.95	1290.65	29376.0
2008-04-22 09:00:00	ES	Futures	1290.65	1291.12	1284.37	1286.0	193430.0
2008-04-22 10:00:00	ES	Futures	1286.0	1290.19	1283.2	1287.63	325544.0
2008-04-22 11:00:00	ES	Futures	1287.63	1288.56	1281.34	1282.27	261703.0
2008-04-22 12:00:00	ES	Futures	1282.27	1283.2	1276.91	1277.61	216369.0
2008-04-22 13:00:00	ES	Futures	1277.61	1282.04	1276.91	1281.34	158548.0
2008-04-22 14:00:00	ES	Futures	1281.34	1282.97	1276.68	1278.54	192820.0
2008-04-22 15:00:00	ES	Futures	1278.54	1284.37	1277.61	1284.13	214300.0
2008-04-22 16:00:00	ES	Futures	1283.9	1287.63	1283.9	1286.93	74896.0
2008-04-22 17:00:00	ES	Futures	1286.93	1287.63	1286.69	1287.63	1122.0
2008-04-22 18:00:00	ES	Futures	1287.63	1287.63	1286.0	1286.0	1461.0
2008-04-22 19:00:00	ES	Futures	1286.0	1287.39	1285.76	1286.69	1262.0
2008-04-22 20:00:00	ES	Futures	1286.69	1288.09	1286.23	1287.39	993.0
2008-04-22 21:00:00	ES	Futures	1287.39	1288.09	1287.16	1287.63	775.0
2008-04-22 22:00:00	ES	Futures	1288.09	1288.79	1287.63	1288.79	2180.0
2008-04-22 23:00:00	ES	Futures	1288.79	1289.26	1288.56	1288.56	1389.0
2008-04-22 00:00:00	NQ	Futures	2153.17	2155.15	2153.17	2155.15	117.0
2008-04-22 01:00:00	NQ	Futures	2153.46	2156.29	2153.17	2154.02	116.0
2008-04-22 02:00:00	NQ	Futures	2154.31	2155.15	2152.89	2154.59	212.0
2008-04-22 03:00:00	NQ	Futures	2154.59	2156.0	2152.61	2154.87	1649.0
2008-04-22 04:00:00	NQ	Futures	2154.87	2156.57	2153.46	2154.87	754.0
2008-04-22 05:00:00	NQ	Futures	2155.44	2161.94	2153.46	2161.38	548.0
2008-04-22 06:00:00	NQ	Futures	2161.66	2163.92	2156.0	2157.98	648.0
2008-04-22 07:00:00	NQ	Futures	2157.42	2163.64	2156.85	2159.68	2373.0
2008-04-22 08:00:00	NQ	Futures	2159.96	2162.22	2156.57	2157.7	2090.0
2008-04-22 09:00:00	NQ	Futures	2157.42	2157.98	2148.93	2151.48	33294.0
2008-04-22 10:00:00	NQ	Futures	2151.19	2158.27	2144.41	2151.19	41620.0
2008-04-22 11:00:00	NQ	Futures	2151.19	2153.17	2135.92	2137.34	37312.0
2008-04-22 12:00:00	NQ	Futures	2137.05	2137.62	2118.67	2120.93	48958.0
2008-04-22 13:00:00	NQ	Futures	2120.93	2134.22	2120.08	2132.53	30887.0
2008-04-22 14:00:00	NQ	Futures	2132.53	2135.36	2124.61	2128.0	28508.0
2008-04-22 15:00:00	NQ	Futures	2128.0	2138.75	2126.31	2137.9	42633.0
2008-04-22 16:00:00	NQ	Futures	2137.9	2152.33	2136.77	2144.41	14382.0
2008-04-22 17:00:00	NQ	Futures	2144.69	2146.95	2144.41	2146.95	155.0
2008-04-22 18:00:00	NQ	Futures	2146.67	2148.65	2144.69	2145.54	159.0
2008-04-22 19:00:00	NQ	Futures	2145.54	2146.95	2144.69	2145.26	190.0
2008-04-22 20:00:00	NQ	Futures	2144.69	2146.67	2144.41	2145.54	20.0
2008-04-22 21:00:00	NQ	Futures	2146.67	2147.8	2145.82	2147.8	82.0
2008-04-22 22:00:00	NQ	Futures	2147.52	2150.91	2147.52	2150.06	212.0
2008-04-22 23:00:00	NQ	Futures	2150.06	2150.35	2149.5	2150.06	28.0
2008-04-22 00:00:00	YM	Futures	11606.2	11619.8	11606.2	11612.6	358.0
2008-04-22 01:00:00	YM	Futures	11611.7	11619.8	11605.3	11605.3	136.0

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

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