PREVIEW / futures_1hour / 2010-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-24.parquet
  size:    40 KB
  rows:    1,146

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
2010-09-24 00:00:00	ES	Futures	1106.2	1108.91	1105.7	1108.17	11727.0
2010-09-24 01:00:00	ES	Futures	1108.17	1108.42	1105.95	1107.18	4268.0
2010-09-24 02:00:00	ES	Futures	1107.18	1107.18	1104.96	1106.44	6607.0
2010-09-24 03:00:00	ES	Futures	1106.44	1108.42	1105.7	1106.2	25991.0
2010-09-24 04:00:00	ES	Futures	1106.2	1110.39	1105.7	1108.17	35467.0
2010-09-24 05:00:00	ES	Futures	1108.17	1109.65	1108.17	1108.42	15621.0
2010-09-24 06:00:00	ES	Futures	1108.42	1108.42	1106.2	1107.68	14170.0
2010-09-24 07:00:00	ES	Futures	1107.68	1109.65	1107.68	1109.4	19821.0
2010-09-24 08:00:00	ES	Futures	1109.15	1118.27	1109.15	1117.04	155522.0
2010-09-24 09:00:00	ES	Futures	1117.29	1122.96	1115.81	1121.97	279403.0
2010-09-24 10:00:00	ES	Futures	1122.22	1126.65	1120.25	1124.68	415843.0
2010-09-24 11:00:00	ES	Futures	1124.68	1127.15	1123.7	1125.67	162803.0
2010-09-24 12:00:00	ES	Futures	1125.67	1127.39	1124.44	1126.65	98403.0
2010-09-24 13:00:00	ES	Futures	1126.65	1128.38	1125.92	1126.41	97065.0
2010-09-24 14:00:00	ES	Futures	1126.41	1128.38	1124.93	1127.39	113822.0
2010-09-24 15:00:00	ES	Futures	1127.39	1128.38	1125.67	1127.39	219588.0
2010-09-24 16:00:00	ES	Futures	1127.15	1127.64	1125.92	1126.9	136309.0
2010-09-24 00:00:00	NQ	Futures	2277.72	2283.46	2277.43	2282.02	584.0
2010-09-24 01:00:00	NQ	Futures	2282.31	2282.31	2278.01	2279.73	191.0
2010-09-24 02:00:00	NQ	Futures	2279.73	2280.3	2275.14	2278.58	678.0
2010-09-24 03:00:00	NQ	Futures	2278.58	2282.88	2277.72	2279.44	3122.0
2010-09-24 04:00:00	NQ	Futures	2278.87	2287.47	2278.58	2283.74	2919.0
2010-09-24 05:00:00	NQ	Futures	2284.32	2287.47	2284.03	2286.04	2519.0
2010-09-24 06:00:00	NQ	Futures	2286.04	2286.04	2281.16	2284.03	2048.0
2010-09-24 07:00:00	NQ	Futures	2284.03	2288.05	2284.03	2286.9	2266.0
2010-09-24 08:00:00	NQ	Futures	2286.33	2305.55	2286.33	2300.1	21068.0
2010-09-24 09:00:00	NQ	Futures	2300.38	2307.84	2294.93	2306.7	54042.0
2010-09-24 10:00:00	NQ	Futures	2306.7	2314.73	2302.68	2312.72	61352.0
2010-09-24 11:00:00	NQ	Futures	2312.72	2318.75	2311.57	2316.45	33069.0
2010-09-24 12:00:00	NQ	Futures	2316.45	2320.47	2313.87	2318.46	21193.0
2010-09-24 13:00:00	NQ	Futures	2318.46	2319.89	2314.44	2314.73	21810.0
2010-09-24 14:00:00	NQ	Futures	2314.73	2319.03	2311.86	2315.59	23935.0
2010-09-24 15:00:00	NQ	Futures	2315.88	2319.89	2313.29	2319.32	36154.0
2010-09-24 16:00:00	NQ	Futures	2319.03	2320.18	2315.88	2317.6	13327.0
2010-09-24 00:00:00	YM	Futures	10114.3	10137.2	10112.4	10133.4	798.0
2010-09-24 01:00:00	YM	Futures	10133.4	10133.4	10115.3	10123.9	413.0
2010-09-24 02:00:00	YM	Futures	10122.0	10125.8	10106.7	10116.2	876.0
2010-09-24 03:00:00	YM	Futures	10117.2	10134.3	10112.4	10117.2	1791.0
2010-09-24 04:00:00	YM	Futures	10116.2	10149.6	10115.3	10133.4	2791.0
2010-09-24 05:00:00	YM	Futures	10131.5	10145.8	10129.6	10137.2	1997.0
2010-09-24 06:00:00	YM	Futures	10136.2	10136.2	10117.2	10129.6	766.0
2010-09-24 07:00:00	YM	Futures	10129.6	10146.7	10129.6	10143.9	768.0
2010-09-24 08:00:00	YM	Futures	10141.0	10216.3	10140.1	10205.8	8046.0
2010-09-24 09:00:00	YM	Futures	10206.7	10256.3	10194.3	10246.7	21719.0
2010-09-24 10:00:00	YM	Futures	10246.7	10280.1	10232.4	10265.8	26462.0
2010-09-24 11:00:00	YM	Futures	10264.8	10278.2	10249.6	10264.8	12932.0
2010-09-24 12:00:00	YM	Futures	10264.8	10279.1	10255.3	10273.4	7115.0
2010-09-24 13:00:00	YM	Futures	10274.4	10285.8	10266.7	10267.7	7819.0
2010-09-24 14:00:00	YM	Futures	10268.6	10288.7	10259.1	10280.1	9464.0
2010-09-24 15:00:00	YM	Futures	10280.1	10283.9	10265.8	10280.1	14407.0

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

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