PREVIEW / futures_1hour / 2008-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-18.parquet
  size:    40 KB
  rows:    1,173

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-08-18 00:00:00	ES	Futures	1206.47	1207.17	1206.24	1207.17	893.0
2008-08-18 01:00:00	ES	Futures	1206.93	1207.17	1206.47	1206.93	594.0
2008-08-18 02:00:00	ES	Futures	1206.93	1207.86	1204.38	1204.38	4381.0
2008-08-18 03:00:00	ES	Futures	1204.38	1205.77	1203.45	1204.84	11152.0
2008-08-18 04:00:00	ES	Futures	1204.84	1205.77	1202.98	1205.54	8831.0
2008-08-18 05:00:00	ES	Futures	1205.77	1207.4	1204.84	1205.77	5221.0
2008-08-18 06:00:00	ES	Futures	1205.77	1214.14	1205.54	1212.98	26287.0
2008-08-18 07:00:00	ES	Futures	1213.21	1213.91	1211.12	1211.58	12170.0
2008-08-18 08:00:00	ES	Futures	1211.35	1213.91	1210.65	1213.67	17049.0
2008-08-18 09:00:00	ES	Futures	1213.67	1213.91	1201.12	1202.98	214127.0
2008-08-18 10:00:00	ES	Futures	1202.98	1204.61	1199.73	1203.68	247565.0
2008-08-18 11:00:00	ES	Futures	1203.91	1205.07	1197.87	1197.87	158755.0
2008-08-18 12:00:00	ES	Futures	1198.1	1198.1	1191.83	1192.52	221643.0
2008-08-18 13:00:00	ES	Futures	1192.52	1194.38	1189.5	1189.5	155324.0
2008-08-18 14:00:00	ES	Futures	1189.5	1189.97	1186.02	1188.8	206540.0
2008-08-18 15:00:00	ES	Futures	1188.8	1190.66	1184.39	1189.97	304673.0
2008-08-18 16:00:00	ES	Futures	1189.97	1192.76	1189.27	1192.06	88350.0
2008-08-18 17:00:00	ES	Futures	1192.06	1192.76	1192.06	1192.52	743.0
2008-08-18 18:00:00	ES	Futures	1192.29	1192.76	1191.36	1192.06	1737.0
2008-08-18 19:00:00	ES	Futures	1192.06	1192.06	1191.13	1191.13	1014.0
2008-08-18 20:00:00	ES	Futures	1191.13	1191.36	1190.2	1190.66	1369.0
2008-08-18 21:00:00	ES	Futures	1190.66	1190.66	1189.73	1190.2	1509.0
2008-08-18 22:00:00	ES	Futures	1190.43	1191.36	1189.97	1190.9	1109.0
2008-08-18 23:00:00	ES	Futures	1190.9	1192.29	1190.9	1192.06	1113.0
2008-08-18 00:00:00	NQ	Futures	2207.55	2208.4	2207.55	2208.4	122.0
2008-08-18 01:00:00	NQ	Futures	2208.68	2208.68	2207.55	2208.12	67.0
2008-08-18 02:00:00	NQ	Futures	2208.68	2212.9	2205.3	2205.3	933.0
2008-08-18 03:00:00	NQ	Futures	2205.02	2207.55	2203.34	2204.74	1208.0
2008-08-18 04:00:00	NQ	Futures	2205.02	2208.4	2202.21	2207.55	1307.0
2008-08-18 05:00:00	NQ	Futures	2207.55	2210.93	2206.43	2207.55	515.0
2008-08-18 06:00:00	NQ	Futures	2207.55	2222.74	2207.55	2222.74	2767.0
2008-08-18 07:00:00	NQ	Futures	2222.74	2223.31	2216.56	2217.4	1397.0
2008-08-18 08:00:00	NQ	Futures	2217.12	2221.34	2215.15	2220.21	3040.0
2008-08-18 09:00:00	NQ	Futures	2220.49	2220.78	2194.62	2201.93	45113.0
2008-08-18 10:00:00	NQ	Futures	2201.93	2204.46	2191.8	2202.77	50325.0
2008-08-18 11:00:00	NQ	Futures	2202.77	2205.87	2192.93	2192.93	29995.0
2008-08-18 12:00:00	NQ	Futures	2192.93	2193.21	2173.8	2176.61	54765.0
2008-08-18 13:00:00	NQ	Futures	2176.61	2185.33	2171.55	2171.83	44442.0
2008-08-18 14:00:00	NQ	Futures	2171.83	2177.18	2168.46	2172.11	39450.0
2008-08-18 15:00:00	NQ	Futures	2172.39	2180.83	2164.52	2179.99	61761.0
2008-08-18 16:00:00	NQ	Futures	2179.71	2188.43	2179.71	2186.18	15724.0
2008-08-18 17:00:00	NQ	Futures	2186.18	2190.11	2186.18	2188.15	307.0
2008-08-18 18:00:00	NQ	Futures	2188.15	2188.15	2185.61	2186.74	139.0
2008-08-18 19:00:00	NQ	Futures	2186.46	2186.74	2185.33	2185.33	131.0
2008-08-18 20:00:00	NQ	Futures	2185.05	2185.9	2183.93	2184.49	210.0
2008-08-18 21:00:00	NQ	Futures	2184.49	2185.9	2183.93	2184.77	187.0
2008-08-18 22:00:00	NQ	Futures	2184.77	2186.46	2183.64	2186.46	265.0
2008-08-18 23:00:00	NQ	Futures	2186.74	2188.43	2186.46	2188.43	90.0
2008-08-18 00:00:00	YM	Futures	10581.1	10583.8	10578.4	10583.8	142.0
2008-08-18 01:00:00	YM	Futures	10582.9	10585.7	10580.2	10585.7	48.0

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

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