PREVIEW / futures_1hour / 2008-07-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	1195.31	1196.01	1194.38	1194.61	1350.0
2008-07-02 01:00:00	ES	Futures	1194.85	1195.08	1192.99	1193.69	2367.0
2008-07-02 02:00:00	ES	Futures	1193.22	1196.47	1192.76	1196.47	9354.0
2008-07-02 03:00:00	ES	Futures	1196.47	1198.33	1191.59	1197.64	24681.0
2008-07-02 04:00:00	ES	Futures	1197.4	1198.33	1196.24	1197.4	12501.0
2008-07-02 05:00:00	ES	Futures	1197.64	1202.75	1196.94	1201.35	24704.0
2008-07-02 06:00:00	ES	Futures	1201.35	1203.21	1199.26	1201.82	22841.0
2008-07-02 07:00:00	ES	Futures	1201.82	1203.68	1201.59	1202.52	23315.0
2008-07-02 08:00:00	ES	Futures	1202.28	1202.75	1197.17	1197.4	64143.0
2008-07-02 09:00:00	ES	Futures	1197.4	1201.59	1197.17	1200.19	228736.0
2008-07-02 10:00:00	ES	Futures	1200.19	1202.28	1196.01	1199.73	357793.0
2008-07-02 11:00:00	ES	Futures	1199.73	1199.96	1189.04	1190.2	361858.0
2008-07-02 12:00:00	ES	Futures	1190.2	1193.22	1186.71	1190.43	211478.0
2008-07-02 13:00:00	ES	Futures	1190.43	1195.31	1186.95	1194.38	190024.0
2008-07-02 14:00:00	ES	Futures	1194.15	1195.31	1183.46	1184.85	303699.0
2008-07-02 15:00:00	ES	Futures	1184.85	1185.78	1173.0	1173.23	472075.0
2008-07-02 16:00:00	ES	Futures	1173.23	1175.09	1172.3	1174.63	101743.0
2008-07-02 17:00:00	ES	Futures	1174.63	1174.63	1173.0	1173.47	4603.0
2008-07-02 18:00:00	ES	Futures	1173.47	1174.86	1173.0	1174.63	2814.0
2008-07-02 19:00:00	ES	Futures	1174.39	1175.32	1174.39	1174.63	1257.0
2008-07-02 20:00:00	ES	Futures	1174.39	1174.86	1172.77	1174.63	2091.0
2008-07-02 21:00:00	ES	Futures	1174.63	1175.09	1173.7	1174.63	2057.0
2008-07-02 22:00:00	ES	Futures	1174.86	1175.56	1174.39	1175.09	1357.0
2008-07-02 23:00:00	ES	Futures	1175.09	1175.56	1174.16	1174.39	2153.0
2008-07-02 00:00:00	NQ	Futures	2102.07	2102.07	2100.66	2100.66	12.0
2008-07-02 01:00:00	NQ	Futures	2101.23	2101.51	2097.85	2100.1	83.0
2008-07-02 02:00:00	NQ	Futures	2099.82	2103.76	2097.85	2103.48	376.0
2008-07-02 03:00:00	NQ	Futures	2103.48	2106.85	2094.2	2106.29	1632.0
2008-07-02 04:00:00	NQ	Futures	2105.73	2107.98	2104.04	2107.42	1061.0
2008-07-02 05:00:00	NQ	Futures	2107.13	2114.17	2105.73	2113.32	1166.0
2008-07-02 06:00:00	NQ	Futures	2114.17	2120.64	2113.6	2118.95	3635.0
2008-07-02 07:00:00	NQ	Futures	2118.95	2123.45	2118.95	2121.2	2598.0
2008-07-02 08:00:00	NQ	Futures	2121.48	2121.76	2112.48	2112.76	6154.0
2008-07-02 09:00:00	NQ	Futures	2112.76	2117.54	2100.95	2104.6	66744.0
2008-07-02 10:00:00	NQ	Futures	2104.88	2111.35	2092.79	2104.32	76168.0
2008-07-02 11:00:00	NQ	Futures	2104.04	2104.32	2075.35	2079.57	65137.0
2008-07-02 12:00:00	NQ	Futures	2079.29	2088.01	2071.13	2077.04	55443.0
2008-07-02 13:00:00	NQ	Futures	2077.32	2093.63	2071.97	2091.38	42360.0
2008-07-02 14:00:00	NQ	Futures	2091.38	2092.23	2069.16	2073.38	58714.0
2008-07-02 15:00:00	NQ	Futures	2073.1	2077.04	2048.34	2050.03	79307.0
2008-07-02 16:00:00	NQ	Futures	2050.03	2055.94	2049.75	2050.6	14886.0
2008-07-02 17:00:00	NQ	Futures	2050.31	2050.6	2039.91	2042.16	2004.0
2008-07-02 18:00:00	NQ	Futures	2041.88	2046.09	2041.88	2043.84	551.0
2008-07-02 19:00:00	NQ	Futures	2044.13	2046.38	2043.84	2044.41	271.0
2008-07-02 20:00:00	NQ	Futures	2044.97	2046.94	2042.72	2046.94	314.0
2008-07-02 21:00:00	NQ	Futures	2046.94	2047.5	2044.97	2046.09	96.0
2008-07-02 22:00:00	NQ	Futures	2046.38	2046.94	2045.53	2045.81	202.0
2008-07-02 23:00:00	NQ	Futures	2046.09	2046.09	2044.97	2044.97	80.0
2008-07-02 00:00:00	YM	Futures	10332.1	10334.8	10320.3	10323.9	131.0
2008-07-02 01:00:00	YM	Futures	10324.8	10326.6	10313.9	10322.1	194.0

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

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