PREVIEW / futures_1hour / 2008-06-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	1225.29	1227.39	1224.83	1227.15	1766.0
2008-06-24 01:00:00	ES	Futures	1227.39	1227.85	1226.92	1227.62	1930.0
2008-06-24 02:00:00	ES	Futures	1227.62	1229.01	1226.46	1227.15	4158.0
2008-06-24 03:00:00	ES	Futures	1227.15	1229.48	1226.69	1227.39	11509.0
2008-06-24 04:00:00	ES	Futures	1227.62	1228.08	1225.06	1225.99	7006.0
2008-06-24 05:00:00	ES	Futures	1226.22	1226.22	1215.3	1218.55	41060.0
2008-06-24 06:00:00	ES	Futures	1218.79	1219.95	1217.62	1219.02	15099.0
2008-06-24 07:00:00	ES	Futures	1219.02	1219.48	1216.46	1218.55	27341.0
2008-06-24 08:00:00	ES	Futures	1218.55	1220.18	1217.39	1219.48	26594.0
2008-06-24 09:00:00	ES	Futures	1219.48	1224.36	1216.46	1216.46	251937.0
2008-06-24 10:00:00	ES	Futures	1216.46	1223.9	1213.44	1223.43	420527.0
2008-06-24 11:00:00	ES	Futures	1223.43	1231.1	1222.97	1229.71	353840.0
2008-06-24 12:00:00	ES	Futures	1229.71	1233.89	1228.55	1229.94	211055.0
2008-06-24 13:00:00	ES	Futures	1230.17	1232.5	1228.08	1231.1	171079.0
2008-06-24 14:00:00	ES	Futures	1231.1	1234.59	1225.53	1227.39	209990.0
2008-06-24 15:00:00	ES	Futures	1227.15	1228.55	1220.65	1223.43	264491.0
2008-06-24 16:00:00	ES	Futures	1223.43	1223.9	1221.81	1223.43	72192.0
2008-06-24 17:00:00	ES	Futures	1223.43	1223.43	1222.27	1223.43	1168.0
2008-06-24 18:00:00	ES	Futures	1223.2	1223.9	1222.97	1223.2	1135.0
2008-06-24 19:00:00	ES	Futures	1223.2	1223.67	1222.97	1223.67	589.0
2008-06-24 20:00:00	ES	Futures	1223.43	1224.6	1223.2	1224.13	1174.0
2008-06-24 21:00:00	ES	Futures	1224.36	1224.36	1222.27	1222.74	899.0
2008-06-24 22:00:00	ES	Futures	1222.97	1223.43	1222.74	1223.43	758.0
2008-06-24 23:00:00	ES	Futures	1223.43	1224.13	1223.2	1223.43	639.0
2008-06-24 00:00:00	NQ	Futures	2156.92	2160.3	2156.92	2160.02	303.0
2008-06-24 01:00:00	NQ	Futures	2160.02	2160.3	2157.77	2159.17	857.0
2008-06-24 02:00:00	NQ	Futures	2159.45	2161.42	2158.05	2159.17	1572.0
2008-06-24 03:00:00	NQ	Futures	2158.89	2162.27	2155.52	2156.36	2596.0
2008-06-24 04:00:00	NQ	Futures	2156.36	2157.2	2152.98	2154.11	1209.0
2008-06-24 05:00:00	NQ	Futures	2154.39	2154.67	2133.01	2139.48	5158.0
2008-06-24 06:00:00	NQ	Futures	2139.76	2145.11	2139.76	2142.3	2792.0
2008-06-24 07:00:00	NQ	Futures	2142.58	2143.7	2137.79	2141.73	2301.0
2008-06-24 08:00:00	NQ	Futures	2141.73	2145.11	2140.33	2144.83	7052.0
2008-06-24 09:00:00	NQ	Futures	2144.55	2159.45	2144.26	2145.11	51171.0
2008-06-24 10:00:00	NQ	Futures	2145.11	2154.39	2132.17	2152.42	83197.0
2008-06-24 11:00:00	NQ	Futures	2152.14	2171.83	2147.64	2167.33	76516.0
2008-06-24 12:00:00	NQ	Futures	2167.33	2170.42	2161.14	2163.67	29990.0
2008-06-24 13:00:00	NQ	Futures	2163.67	2173.24	2161.99	2171.55	34418.0
2008-06-24 14:00:00	NQ	Futures	2171.27	2176.89	2153.55	2158.61	45521.0
2008-06-24 15:00:00	NQ	Futures	2158.61	2162.55	2145.67	2151.86	54386.0
2008-06-24 16:00:00	NQ	Futures	2151.58	2154.11	2147.92	2154.11	11457.0
2008-06-24 17:00:00	NQ	Futures	2153.55	2153.83	2151.3	2153.27	133.0
2008-06-24 18:00:00	NQ	Futures	2152.7	2154.39	2151.86	2152.98	470.0
2008-06-24 19:00:00	NQ	Futures	2152.7	2152.98	2151.58	2152.14	102.0
2008-06-24 20:00:00	NQ	Futures	2152.42	2154.11	2152.14	2153.83	30.0
2008-06-24 21:00:00	NQ	Futures	2153.27	2154.11	2151.58	2151.86	84.0
2008-06-24 22:00:00	NQ	Futures	2151.86	2153.27	2151.86	2153.27	59.0
2008-06-24 23:00:00	NQ	Futures	2152.98	2152.98	2152.42	2152.98	12.0
2008-06-24 00:00:00	YM	Futures	10754.7	10772.0	10752.0	10770.2	120.0
2008-06-24 01:00:00	YM	Futures	10771.1	10777.4	10768.3	10773.8	160.0

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

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