PREVIEW / futures_1hour / 2008-07-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	1194.85	1195.54	1194.61	1194.85	432.0
2008-07-01 01:00:00	ES	Futures	1194.85	1196.01	1192.29	1192.52	1733.0
2008-07-01 02:00:00	ES	Futures	1192.76	1193.22	1191.36	1192.76	6274.0
2008-07-01 03:00:00	ES	Futures	1192.76	1194.15	1190.2	1190.43	13450.0
2008-07-01 04:00:00	ES	Futures	1190.2	1190.43	1180.44	1180.9	33863.0
2008-07-01 05:00:00	ES	Futures	1180.9	1183.92	1176.72	1179.74	37596.0
2008-07-01 06:00:00	ES	Futures	1179.74	1181.13	1177.18	1178.58	21699.0
2008-07-01 07:00:00	ES	Futures	1178.81	1180.44	1177.42	1179.04	32290.0
2008-07-01 08:00:00	ES	Futures	1178.81	1180.67	1178.11	1178.81	38566.0
2008-07-01 09:00:00	ES	Futures	1179.04	1183.46	1176.02	1182.99	274958.0
2008-07-01 10:00:00	ES	Futures	1182.76	1191.59	1182.06	1191.59	606716.0
2008-07-01 11:00:00	ES	Futures	1191.59	1193.45	1182.76	1183.46	350434.0
2008-07-01 12:00:00	ES	Futures	1183.46	1183.69	1172.3	1177.65	468657.0
2008-07-01 13:00:00	ES	Futures	1177.42	1184.16	1174.63	1181.37	305266.0
2008-07-01 14:00:00	ES	Futures	1181.37	1196.01	1181.13	1191.83	504864.0
2008-07-01 15:00:00	ES	Futures	1191.83	1195.78	1188.34	1195.31	377255.0
2008-07-01 16:00:00	ES	Futures	1195.08	1196.47	1194.85	1196.24	98762.0
2008-07-01 17:00:00	ES	Futures	1196.01	1197.17	1195.78	1196.47	2534.0
2008-07-01 18:00:00	ES	Futures	1196.71	1196.94	1195.78	1196.01	1537.0
2008-07-01 19:00:00	ES	Futures	1196.01	1196.24	1195.31	1195.31	2437.0
2008-07-01 20:00:00	ES	Futures	1195.31	1195.54	1193.45	1193.69	6720.0
2008-07-01 21:00:00	ES	Futures	1193.92	1194.61	1193.22	1194.15	2298.0
2008-07-01 22:00:00	ES	Futures	1194.38	1194.61	1193.22	1193.22	1467.0
2008-07-01 23:00:00	ES	Futures	1193.45	1195.31	1193.45	1195.08	1151.0
2008-07-01 00:00:00	NQ	Futures	2083.22	2084.63	2083.22	2084.35	76.0
2008-07-01 01:00:00	NQ	Futures	2084.35	2085.19	2080.41	2080.97	175.0
2008-07-01 02:00:00	NQ	Futures	2080.97	2080.97	2077.6	2079.57	1005.0
2008-07-01 03:00:00	NQ	Futures	2079.57	2081.54	2072.82	2072.82	1723.0
2008-07-01 04:00:00	NQ	Futures	2072.82	2073.66	2055.66	2056.5	2419.0
2008-07-01 05:00:00	NQ	Futures	2056.78	2061.57	2047.5	2050.6	3330.0
2008-07-01 06:00:00	NQ	Futures	2050.31	2052.85	2043.0	2045.81	3130.0
2008-07-01 07:00:00	NQ	Futures	2045.53	2050.03	2043.84	2049.47	4556.0
2008-07-01 08:00:00	NQ	Futures	2048.91	2055.38	2048.91	2054.81	6495.0
2008-07-01 09:00:00	NQ	Futures	2054.81	2068.04	2047.78	2065.5	70202.0
2008-07-01 10:00:00	NQ	Futures	2065.5	2088.85	2063.25	2088.57	101321.0
2008-07-01 11:00:00	NQ	Futures	2088.57	2092.51	2068.32	2070.57	66114.0
2008-07-01 12:00:00	NQ	Futures	2070.85	2072.54	2050.88	2062.97	84297.0
2008-07-01 13:00:00	NQ	Futures	2062.69	2081.26	2058.19	2075.91	57857.0
2008-07-01 14:00:00	NQ	Futures	2075.91	2106.01	2075.63	2096.16	93162.0
2008-07-01 15:00:00	NQ	Futures	2095.6	2105.17	2087.73	2103.48	69686.0
2008-07-01 16:00:00	NQ	Futures	2104.04	2106.29	2102.07	2105.17	13662.0
2008-07-01 17:00:00	NQ	Futures	2104.88	2106.85	2104.32	2105.45	342.0
2008-07-01 18:00:00	NQ	Futures	2104.88	2106.29	2104.04	2104.04	161.0
2008-07-01 19:00:00	NQ	Futures	2104.04	2104.32	2103.2	2104.32	72.0
2008-07-01 20:00:00	NQ	Futures	2104.32	2104.32	2098.7	2099.26	96.0
2008-07-01 21:00:00	NQ	Futures	2099.54	2100.95	2098.41	2099.54	105.0
2008-07-01 22:00:00	NQ	Futures	2099.54	2099.82	2098.7	2098.7	37.0
2008-07-01 23:00:00	NQ	Futures	2099.54	2101.23	2099.54	2101.23	71.0
2008-07-01 00:00:00	YM	Futures	10333.0	10337.5	10331.2	10332.1	110.0
2008-07-01 01:00:00	YM	Futures	10334.8	10340.3	10316.6	10320.3	165.0

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

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