PREVIEW / futures_1hour / 2008-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-17.parquet
  size:    44 KB
  rows:    1,254

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-04-17 00:00:00	ES	Futures	1276.45	1276.45	1274.82	1275.28	923.0
2008-04-17 01:00:00	ES	Futures	1275.28	1275.28	1273.66	1273.89	1645.0
2008-04-17 02:00:00	ES	Futures	1274.12	1274.59	1272.49	1272.96	6006.0
2008-04-17 03:00:00	ES	Futures	1272.96	1274.35	1271.56	1271.79	13967.0
2008-04-17 04:00:00	ES	Futures	1271.79	1273.19	1270.86	1272.72	9924.0
2008-04-17 05:00:00	ES	Futures	1272.72	1274.59	1270.86	1273.89	11880.0
2008-04-17 06:00:00	ES	Futures	1273.89	1275.98	1269.7	1273.66	35340.0
2008-04-17 07:00:00	ES	Futures	1273.66	1274.35	1270.16	1270.86	24961.0
2008-04-17 08:00:00	ES	Futures	1270.86	1272.03	1266.9	1268.3	78204.0
2008-04-17 09:00:00	ES	Futures	1268.3	1270.86	1267.14	1269.46	181312.0
2008-04-17 10:00:00	ES	Futures	1269.46	1274.59	1265.97	1271.33	333323.0
2008-04-17 11:00:00	ES	Futures	1271.09	1271.79	1265.27	1266.67	241673.0
2008-04-17 12:00:00	ES	Futures	1266.67	1269.93	1265.27	1269.46	122671.0
2008-04-17 13:00:00	ES	Futures	1269.7	1273.42	1269.0	1270.4	165300.0
2008-04-17 14:00:00	ES	Futures	1270.4	1272.96	1268.53	1270.4	142135.0
2008-04-17 15:00:00	ES	Futures	1270.4	1276.45	1269.46	1272.96	241680.0
2008-04-17 16:00:00	ES	Futures	1272.96	1281.8	1271.33	1279.94	138210.0
2008-04-17 17:00:00	ES	Futures	1279.94	1281.11	1279.71	1280.87	3540.0
2008-04-17 18:00:00	ES	Futures	1280.41	1280.64	1279.48	1280.64	1809.0
2008-04-17 19:00:00	ES	Futures	1280.41	1280.64	1279.24	1279.48	1135.0
2008-04-17 20:00:00	ES	Futures	1279.71	1279.94	1278.78	1279.01	1385.0
2008-04-17 21:00:00	ES	Futures	1279.24	1279.94	1278.08	1278.31	1490.0
2008-04-17 22:00:00	ES	Futures	1278.54	1278.78	1276.91	1277.15	2307.0
2008-04-17 23:00:00	ES	Futures	1277.15	1278.31	1276.91	1278.31	844.0
2008-04-17 00:00:00	NQ	Futures	2109.05	2109.05	2105.38	2107.36	151.0
2008-04-17 01:00:00	NQ	Futures	2107.36	2107.36	2104.53	2104.81	81.0
2008-04-17 02:00:00	NQ	Futures	2104.53	2105.38	2101.13	2102.27	642.0
2008-04-17 03:00:00	NQ	Futures	2102.27	2104.24	2099.44	2099.72	1043.0
2008-04-17 04:00:00	NQ	Futures	2100.0	2101.7	2098.31	2100.85	769.0
2008-04-17 05:00:00	NQ	Futures	2100.85	2105.09	2099.44	2104.81	836.0
2008-04-17 06:00:00	NQ	Futures	2103.96	2107.36	2097.46	2103.11	3152.0
2008-04-17 07:00:00	NQ	Futures	2103.11	2105.09	2098.02	2100.57	2442.0
2008-04-17 08:00:00	NQ	Futures	2100.57	2101.98	2094.35	2096.04	7468.0
2008-04-17 09:00:00	NQ	Futures	2096.04	2098.87	2086.14	2090.67	40468.0
2008-04-17 10:00:00	NQ	Futures	2090.95	2095.19	2083.03	2087.84	49061.0
2008-04-17 11:00:00	NQ	Futures	2087.84	2088.97	2076.53	2079.64	40793.0
2008-04-17 12:00:00	NQ	Futures	2079.64	2087.84	2075.4	2086.14	30892.0
2008-04-17 13:00:00	NQ	Futures	2086.43	2088.12	2081.62	2082.75	25723.0
2008-04-17 14:00:00	NQ	Futures	2082.18	2087.28	2078.79	2081.9	24131.0
2008-04-17 15:00:00	NQ	Futures	2081.9	2096.33	2080.49	2089.54	56859.0
2008-04-17 16:00:00	NQ	Futures	2088.97	2124.04	2088.12	2121.78	42341.0
2008-04-17 17:00:00	NQ	Futures	2121.21	2124.33	2119.52	2123.19	1547.0
2008-04-17 18:00:00	NQ	Futures	2123.19	2123.19	2120.37	2121.78	439.0
2008-04-17 19:00:00	NQ	Futures	2121.78	2122.35	2120.93	2120.93	305.0
2008-04-17 20:00:00	NQ	Futures	2121.78	2122.06	2120.65	2120.93	175.0
2008-04-17 21:00:00	NQ	Futures	2121.5	2121.78	2119.23	2119.23	177.0
2008-04-17 22:00:00	NQ	Futures	2119.23	2120.93	2118.1	2119.23	250.0
2008-04-17 23:00:00	NQ	Futures	2119.23	2121.21	2118.39	2121.21	35.0
2008-04-17 00:00:00	YM	Futures	11494.4	11494.4	11483.5	11488.1	83.0
2008-04-17 01:00:00	YM	Futures	11487.2	11487.2	11477.2	11478.1	131.0

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

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