PREVIEW / futures_1hour / 2008-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-25.parquet
  size:    39 KB
  rows:    1,120

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-25 00:00:00	ES	Futures	1199.03	1199.5	1197.17	1197.64	1548.0
2008-08-25 01:00:00	ES	Futures	1197.64	1198.57	1197.64	1197.64	727.0
2008-08-25 02:00:00	ES	Futures	1197.64	1198.33	1196.94	1197.64	2560.0
2008-08-25 03:00:00	ES	Futures	1197.87	1198.1	1196.01	1197.17	8971.0
2008-08-25 04:00:00	ES	Futures	1197.17	1199.03	1196.47	1197.4	3681.0
2008-08-25 05:00:00	ES	Futures	1197.17	1198.57	1196.24	1197.4	3041.0
2008-08-25 06:00:00	ES	Futures	1197.4	1198.57	1196.47	1197.17	2564.0
2008-08-25 07:00:00	ES	Futures	1197.17	1200.43	1196.94	1200.43	8790.0
2008-08-25 08:00:00	ES	Futures	1200.43	1201.12	1192.99	1194.15	38860.0
2008-08-25 09:00:00	ES	Futures	1194.38	1195.78	1190.66	1191.59	165606.0
2008-08-25 10:00:00	ES	Futures	1191.59	1194.38	1187.18	1188.11	252298.0
2008-08-25 11:00:00	ES	Futures	1188.11	1188.57	1179.74	1180.9	236373.0
2008-08-25 12:00:00	ES	Futures	1180.9	1180.9	1176.72	1178.58	217279.0
2008-08-25 13:00:00	ES	Futures	1178.58	1182.3	1178.11	1180.67	178569.0
2008-08-25 14:00:00	ES	Futures	1180.67	1182.76	1177.65	1178.58	132121.0
2008-08-25 15:00:00	ES	Futures	1178.58	1179.74	1175.32	1178.81	276062.0
2008-08-25 16:00:00	ES	Futures	1178.81	1179.04	1177.18	1177.88	98170.0
2008-08-25 17:00:00	ES	Futures	1178.11	1178.58	1177.88	1178.58	1442.0
2008-08-25 18:00:00	ES	Futures	1178.35	1178.81	1177.88	1177.88	721.0
2008-08-25 19:00:00	ES	Futures	1178.11	1178.35	1177.65	1178.11	971.0
2008-08-25 20:00:00	ES	Futures	1178.11	1178.81	1178.11	1178.58	1172.0
2008-08-25 21:00:00	ES	Futures	1178.58	1179.51	1178.58	1179.28	1164.0
2008-08-25 22:00:00	ES	Futures	1179.28	1179.97	1179.04	1179.51	1022.0
2008-08-25 23:00:00	ES	Futures	1179.51	1179.74	1178.81	1179.04	441.0
2008-08-25 00:00:00	NQ	Futures	2168.46	2168.46	2165.36	2165.92	89.0
2008-08-25 01:00:00	NQ	Futures	2166.49	2167.61	2165.92	2167.05	93.0
2008-08-25 02:00:00	NQ	Futures	2167.05	2167.61	2164.52	2166.49	155.0
2008-08-25 03:00:00	NQ	Futures	2166.2	2167.61	2162.27	2164.8	871.0
2008-08-25 04:00:00	NQ	Futures	2164.52	2167.61	2163.67	2164.8	449.0
2008-08-25 05:00:00	NQ	Futures	2165.36	2166.77	2163.11	2164.52	291.0
2008-08-25 06:00:00	NQ	Futures	2164.24	2167.33	2163.39	2165.64	259.0
2008-08-25 07:00:00	NQ	Futures	2165.08	2171.55	2165.08	2171.55	776.0
2008-08-25 08:00:00	NQ	Futures	2171.55	2172.39	2157.2	2159.45	5043.0
2008-08-25 09:00:00	NQ	Futures	2159.74	2161.7	2150.73	2152.98	38918.0
2008-08-25 10:00:00	NQ	Futures	2153.27	2161.99	2143.42	2145.11	58275.0
2008-08-25 11:00:00	NQ	Futures	2145.11	2145.67	2129.64	2130.2	58086.0
2008-08-25 12:00:00	NQ	Futures	2130.2	2132.73	2124.86	2129.07	57520.0
2008-08-25 13:00:00	NQ	Futures	2129.36	2135.54	2128.51	2130.76	34855.0
2008-08-25 14:00:00	NQ	Futures	2130.48	2134.98	2125.7	2128.23	27082.0
2008-08-25 15:00:00	NQ	Futures	2128.23	2133.01	2123.17	2132.17	53115.0
2008-08-25 16:00:00	NQ	Futures	2132.17	2134.14	2128.23	2134.14	14170.0
2008-08-25 17:00:00	NQ	Futures	2133.29	2134.14	2133.01	2133.58	59.0
2008-08-25 18:00:00	NQ	Futures	2133.29	2134.42	2132.45	2133.01	184.0
2008-08-25 19:00:00	NQ	Futures	2133.01	2133.01	2132.45	2133.01	68.0
2008-08-25 20:00:00	NQ	Futures	2133.01	2134.14	2132.17	2133.58	344.0
2008-08-25 21:00:00	NQ	Futures	2133.58	2135.26	2133.01	2134.42	153.0
2008-08-25 22:00:00	NQ	Futures	2134.7	2136.39	2134.42	2136.39	28.0
2008-08-25 23:00:00	NQ	Futures	2135.26	2135.54	2134.98	2135.54	23.0
2008-08-25 00:00:00	YM	Futures	10544.8	10545.7	10532.0	10533.9	117.0
2008-08-25 01:00:00	YM	Futures	10536.6	10544.8	10536.6	10542.0	424.0

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

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