PREVIEW / futures_1hour / 2008-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-09.parquet
  size:    43 KB
  rows:    1,236

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-07-09 00:00:00	ES	Futures	1184.85	1185.32	1181.83	1182.06	4211.0
2008-07-09 01:00:00	ES	Futures	1181.83	1182.06	1181.13	1181.6	3319.0
2008-07-09 02:00:00	ES	Futures	1181.6	1182.53	1179.97	1180.44	8874.0
2008-07-09 03:00:00	ES	Futures	1180.21	1182.53	1179.04	1180.9	14057.0
2008-07-09 04:00:00	ES	Futures	1180.9	1183.23	1179.97	1182.3	12725.0
2008-07-09 05:00:00	ES	Futures	1182.3	1183.92	1180.9	1182.53	14371.0
2008-07-09 06:00:00	ES	Futures	1182.3	1182.76	1179.51	1181.13	12004.0
2008-07-09 07:00:00	ES	Futures	1181.13	1186.95	1179.97	1186.71	31283.0
2008-07-09 08:00:00	ES	Futures	1186.48	1188.8	1185.78	1187.64	48810.0
2008-07-09 09:00:00	ES	Futures	1187.64	1188.8	1181.37	1183.69	295534.0
2008-07-09 10:00:00	ES	Futures	1183.46	1187.87	1179.97	1186.02	393219.0
2008-07-09 11:00:00	ES	Futures	1186.02	1188.8	1182.3	1183.92	288191.0
2008-07-09 12:00:00	ES	Futures	1183.92	1185.78	1179.04	1179.97	168645.0
2008-07-09 13:00:00	ES	Futures	1179.97	1180.9	1176.02	1178.35	177224.0
2008-07-09 14:00:00	ES	Futures	1178.11	1178.81	1167.89	1169.28	312163.0
2008-07-09 15:00:00	ES	Futures	1169.05	1169.51	1157.2	1157.89	484184.0
2008-07-09 16:00:00	ES	Futures	1157.89	1161.38	1157.66	1158.13	118792.0
2008-07-09 17:00:00	ES	Futures	1158.13	1158.36	1157.66	1158.36	2440.0
2008-07-09 18:00:00	ES	Futures	1158.13	1158.36	1156.96	1157.43	4593.0
2008-07-09 19:00:00	ES	Futures	1157.66	1158.59	1157.2	1157.89	2457.0
2008-07-09 20:00:00	ES	Futures	1157.89	1158.36	1157.43	1158.36	2659.0
2008-07-09 21:00:00	ES	Futures	1158.13	1158.59	1156.96	1158.13	2525.0
2008-07-09 22:00:00	ES	Futures	1158.13	1159.75	1157.89	1159.75	3800.0
2008-07-09 23:00:00	ES	Futures	1159.52	1160.68	1159.06	1160.45	2723.0
2008-07-09 00:00:00	NQ	Futures	2101.51	2102.63	2095.88	2096.16	199.0
2008-07-09 01:00:00	NQ	Futures	2096.16	2096.45	2093.91	2095.04	218.0
2008-07-09 02:00:00	NQ	Futures	2094.76	2097.01	2092.51	2094.2	1115.0
2008-07-09 03:00:00	NQ	Futures	2094.2	2097.85	2091.66	2094.48	1445.0
2008-07-09 04:00:00	NQ	Futures	2094.2	2101.79	2093.35	2099.26	2271.0
2008-07-09 05:00:00	NQ	Futures	2098.98	2102.63	2096.73	2101.79	1183.0
2008-07-09 06:00:00	NQ	Futures	2101.79	2102.35	2095.88	2098.41	853.0
2008-07-09 07:00:00	NQ	Futures	2098.7	2109.67	2096.45	2109.38	2792.0
2008-07-09 08:00:00	NQ	Futures	2109.38	2112.48	2108.26	2108.54	4971.0
2008-07-09 09:00:00	NQ	Futures	2108.26	2109.38	2091.38	2097.57	53501.0
2008-07-09 10:00:00	NQ	Futures	2097.85	2107.42	2091.38	2103.48	69381.0
2008-07-09 11:00:00	NQ	Futures	2103.48	2112.48	2098.41	2100.1	56503.0
2008-07-09 12:00:00	NQ	Futures	2100.38	2101.79	2089.41	2093.35	34502.0
2008-07-09 13:00:00	NQ	Futures	2093.35	2096.45	2084.91	2093.07	36282.0
2008-07-09 14:00:00	NQ	Futures	2093.07	2098.13	2075.63	2079.85	55631.0
2008-07-09 15:00:00	NQ	Futures	2079.85	2079.85	2052.0	2052.56	83152.0
2008-07-09 16:00:00	NQ	Futures	2052.85	2062.13	2052.0	2055.94	16385.0
2008-07-09 17:00:00	NQ	Futures	2055.66	2056.5	2054.81	2056.22	410.0
2008-07-09 18:00:00	NQ	Futures	2055.94	2057.35	2054.81	2057.35	436.0
2008-07-09 19:00:00	NQ	Futures	2056.5	2056.78	2053.97	2056.78	289.0
2008-07-09 20:00:00	NQ	Futures	2056.5	2058.75	2055.38	2057.35	175.0
2008-07-09 21:00:00	NQ	Futures	2057.35	2057.91	2055.66	2056.22	111.0
2008-07-09 22:00:00	NQ	Futures	2056.22	2059.6	2056.22	2059.6	60.0
2008-07-09 23:00:00	NQ	Futures	2058.75	2061.85	2058.75	2061.0	94.0
2008-07-09 00:00:00	YM	Futures	10353.9	10354.8	10329.4	10329.4	357.0
2008-07-09 01:00:00	YM	Futures	10329.4	10330.3	10325.7	10328.4	252.0

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

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