PREVIEW / futures_1hour / 2008-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-10.parquet
  size:    41 KB
  rows:    1,167

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-06-10 00:00:00	ES	Futures	1263.64	1264.34	1262.01	1262.71	2263.0
2008-06-10 01:00:00	ES	Futures	1262.94	1264.57	1262.25	1263.41	1892.0
2008-06-10 02:00:00	ES	Futures	1263.41	1263.88	1259.68	1260.15	12116.0
2008-06-10 03:00:00	ES	Futures	1259.92	1262.48	1257.59	1261.08	23784.0
2008-06-10 04:00:00	ES	Futures	1261.08	1261.31	1254.79	1256.89	26915.0
2008-06-10 05:00:00	ES	Futures	1256.89	1262.94	1256.66	1261.31	22311.0
2008-06-10 06:00:00	ES	Futures	1261.31	1263.88	1258.99	1261.31	19091.0
2008-06-10 07:00:00	ES	Futures	1261.55	1262.71	1258.29	1259.45	25352.0
2008-06-10 08:00:00	ES	Futures	1259.45	1260.15	1255.26	1258.75	42752.0
2008-06-10 09:00:00	ES	Futures	1258.52	1263.88	1256.19	1261.08	256990.0
2008-06-10 10:00:00	ES	Futures	1261.08	1267.83	1259.92	1264.11	348778.0
2008-06-10 11:00:00	ES	Futures	1264.11	1269.0	1260.62	1265.27	287952.0
2008-06-10 12:00:00	ES	Futures	1265.04	1270.86	1262.94	1269.0	208081.0
2008-06-10 13:00:00	ES	Futures	1269.0	1273.42	1267.14	1267.83	194158.0
2008-06-10 14:00:00	ES	Futures	1267.83	1268.53	1261.55	1266.67	234972.0
2008-06-10 15:00:00	ES	Futures	1266.9	1269.23	1264.11	1264.34	250801.0
2008-06-10 16:00:00	ES	Futures	1264.34	1264.57	1262.01	1262.25	95524.0
2008-06-10 17:00:00	ES	Futures	1262.25	1263.18	1262.25	1262.71	727.0
2008-06-10 18:00:00	ES	Futures	1262.01	1262.71	1260.62	1262.48	2468.0
2008-06-10 19:00:00	ES	Futures	1262.71	1263.64	1262.01	1263.64	1399.0
2008-06-10 20:00:00	ES	Futures	1263.64	1264.34	1263.41	1263.88	1203.0
2008-06-10 21:00:00	ES	Futures	1264.11	1264.11	1261.31	1261.55	1958.0
2008-06-10 22:00:00	ES	Futures	1261.78	1262.94	1260.85	1262.94	1440.0
2008-06-10 23:00:00	ES	Futures	1262.94	1265.04	1262.48	1264.81	2517.0
2008-06-10 00:00:00	NQ	Futures	2237.46	2238.87	2233.78	2235.19	353.0
2008-06-10 01:00:00	NQ	Futures	2236.89	2237.74	2234.91	2235.48	368.0
2008-06-10 02:00:00	NQ	Futures	2235.48	2235.76	2229.26	2229.82	1536.0
2008-06-10 03:00:00	NQ	Futures	2229.26	2233.21	2222.47	2227.28	3828.0
2008-06-10 04:00:00	NQ	Futures	2227.28	2227.28	2218.22	2221.05	1878.0
2008-06-10 05:00:00	NQ	Futures	2221.34	2233.21	2221.34	2229.82	1615.0
2008-06-10 06:00:00	NQ	Futures	2229.82	2234.06	2227.28	2230.95	1753.0
2008-06-10 07:00:00	NQ	Futures	2231.23	2233.78	2226.43	2228.12	3051.0
2008-06-10 08:00:00	NQ	Futures	2228.12	2228.69	2215.4	2217.09	8364.0
2008-06-10 09:00:00	NQ	Futures	2217.38	2229.82	2213.42	2226.14	53903.0
2008-06-10 10:00:00	NQ	Futures	2225.86	2235.19	2217.66	2227.28	72958.0
2008-06-10 11:00:00	NQ	Futures	2227.28	2234.06	2218.79	2226.71	52160.0
2008-06-10 12:00:00	NQ	Futures	2226.71	2244.81	2222.75	2239.72	48618.0
2008-06-10 13:00:00	NQ	Futures	2239.72	2250.75	2234.63	2239.44	45286.0
2008-06-10 14:00:00	NQ	Futures	2239.15	2240.0	2224.45	2232.08	46291.0
2008-06-10 15:00:00	NQ	Futures	2232.08	2240.0	2230.67	2232.37	47664.0
2008-06-10 16:00:00	NQ	Futures	2232.08	2233.5	2229.26	2231.52	11059.0
2008-06-10 17:00:00	NQ	Futures	2231.23	2232.37	2230.95	2231.23	83.0
2008-06-10 18:00:00	NQ	Futures	2230.67	2232.37	2228.97	2232.08	351.0
2008-06-10 19:00:00	NQ	Futures	2232.37	2233.5	2230.1	2232.93	138.0
2008-06-10 20:00:00	NQ	Futures	2233.21	2234.91	2232.93	2234.91	104.0
2008-06-10 21:00:00	NQ	Futures	2234.35	2234.63	2229.82	2230.67	233.0
2008-06-10 22:00:00	NQ	Futures	2230.39	2232.08	2228.41	2231.23	306.0
2008-06-10 23:00:00	NQ	Futures	2231.8	2235.48	2231.8	2235.19	292.0
2008-06-10 00:00:00	YM	Futures	11124.6	11140.1	11124.6	11140.1	5.0
2008-06-10 01:00:00	YM	Futures	11131.0	11131.0	11131.0	11131.0	1.0

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

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