PREVIEW / futures_1hour / 2008-04-25
file: by_date/futures_1hour/2008/2008-04-25.parquet size: 37 KB rows: 1,018
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-25 00:00:00 | ES | Futures | 1292.52 | 1293.45 | 1290.65 | 1291.58 | 2417.0 |
| 2008-04-25 01:00:00 | ES | Futures | 1291.82 | 1293.68 | 1291.35 | 1293.21 | 1047.0 |
| 2008-04-25 02:00:00 | ES | Futures | 1293.45 | 1294.84 | 1291.82 | 1294.61 | 5082.0 |
| 2008-04-25 03:00:00 | ES | Futures | 1294.38 | 1296.94 | 1293.21 | 1296.71 | 17537.0 |
| 2008-04-25 04:00:00 | ES | Futures | 1296.71 | 1297.41 | 1295.08 | 1296.71 | 12287.0 |
| 2008-04-25 05:00:00 | ES | Futures | 1296.71 | 1298.34 | 1296.24 | 1296.94 | 11080.0 |
| 2008-04-25 06:00:00 | ES | Futures | 1296.94 | 1298.34 | 1296.47 | 1296.47 | 10583.0 |
| 2008-04-25 07:00:00 | ES | Futures | 1296.47 | 1299.97 | 1294.38 | 1299.5 | 22736.0 |
| 2008-04-25 08:00:00 | ES | Futures | 1299.5 | 1300.2 | 1297.17 | 1298.57 | 35090.0 |
| 2008-04-25 09:00:00 | ES | Futures | 1298.8 | 1302.06 | 1294.84 | 1295.08 | 183709.0 |
| 2008-04-25 10:00:00 | ES | Futures | 1295.31 | 1298.1 | 1292.05 | 1295.31 | 288400.0 |
| 2008-04-25 11:00:00 | ES | Futures | 1295.31 | 1296.24 | 1285.76 | 1292.28 | 270759.0 |
| 2008-04-25 12:00:00 | ES | Futures | 1292.28 | 1294.15 | 1290.19 | 1291.82 | 93653.0 |
| 2008-04-25 13:00:00 | ES | Futures | 1291.58 | 1295.31 | 1289.26 | 1295.08 | 88703.0 |
| 2008-04-25 14:00:00 | ES | Futures | 1294.84 | 1297.64 | 1294.15 | 1297.41 | 112375.0 |
| 2008-04-25 15:00:00 | ES | Futures | 1297.41 | 1304.62 | 1296.71 | 1303.23 | 317049.0 |
| 2008-04-25 16:00:00 | ES | Futures | 1303.23 | 1303.92 | 1300.66 | 1301.6 | 72101.0 |
| 2008-04-25 00:00:00 | NQ | Futures | 2169.86 | 2171.56 | 2167.03 | 2168.45 | 388.0 |
| 2008-04-25 01:00:00 | NQ | Futures | 2167.03 | 2173.26 | 2167.03 | 2173.26 | 472.0 |
| 2008-04-25 02:00:00 | NQ | Futures | 2173.26 | 2176.37 | 2172.12 | 2176.08 | 501.0 |
| 2008-04-25 03:00:00 | NQ | Futures | 2176.37 | 2181.74 | 2173.54 | 2180.61 | 1728.0 |
| 2008-04-25 04:00:00 | NQ | Futures | 2180.89 | 2182.02 | 2178.06 | 2181.17 | 1177.0 |
| 2008-04-25 05:00:00 | NQ | Futures | 2180.89 | 2183.44 | 2179.48 | 2180.61 | 765.0 |
| 2008-04-25 06:00:00 | NQ | Futures | 2180.89 | 2183.44 | 2180.04 | 2181.17 | 727.0 |
| 2008-04-25 07:00:00 | NQ | Futures | 2181.17 | 2187.68 | 2177.78 | 2187.11 | 2489.0 |
| 2008-04-25 08:00:00 | NQ | Futures | 2186.55 | 2186.55 | 2181.46 | 2184.0 | 4008.0 |
| 2008-04-25 09:00:00 | NQ | Futures | 2184.29 | 2187.11 | 2158.55 | 2162.79 | 51475.0 |
| 2008-04-25 10:00:00 | NQ | Futures | 2162.51 | 2172.41 | 2157.42 | 2164.49 | 64140.0 |
| 2008-04-25 11:00:00 | NQ | Futures | 2164.77 | 2166.47 | 2148.93 | 2159.68 | 46542.0 |
| 2008-04-25 12:00:00 | NQ | Futures | 2159.96 | 2161.94 | 2151.76 | 2155.15 | 23796.0 |
| 2008-04-25 13:00:00 | NQ | Futures | 2155.15 | 2160.81 | 2148.08 | 2160.25 | 17732.0 |
| 2008-04-25 14:00:00 | NQ | Futures | 2159.96 | 2169.3 | 2158.83 | 2167.88 | 22996.0 |
| 2008-04-25 15:00:00 | NQ | Futures | 2168.16 | 2182.31 | 2166.47 | 2176.93 | 48701.0 |
| 2008-04-25 16:00:00 | NQ | Futures | 2176.65 | 2176.65 | 2170.14 | 2172.69 | 8187.0 |
| 2008-04-25 00:00:00 | YM | Futures | 11680.7 | 11686.2 | 11668.0 | 11669.8 | 221.0 |
| 2008-04-25 01:00:00 | YM | Futures | 11674.4 | 11684.3 | 11670.7 | 11682.5 | 252.0 |
| 2008-04-25 02:00:00 | YM | Futures | 11683.4 | 11693.4 | 11673.4 | 11688.0 | 549.0 |
| 2008-04-25 03:00:00 | YM | Futures | 11688.0 | 11712.5 | 11681.6 | 11712.5 | 1727.0 |
| 2008-04-25 04:00:00 | YM | Futures | 11712.5 | 11717.1 | 11698.9 | 11708.0 | 577.0 |
| 2008-04-25 05:00:00 | YM | Futures | 11707.1 | 11721.6 | 11706.2 | 11710.7 | 658.0 |
| 2008-04-25 06:00:00 | YM | Futures | 11712.5 | 11721.6 | 11705.2 | 11707.1 | 514.0 |
| 2008-04-25 07:00:00 | YM | Futures | 11706.2 | 11731.6 | 11688.9 | 11728.0 | 1534.0 |
| 2008-04-25 08:00:00 | YM | Futures | 11727.1 | 11730.7 | 11707.1 | 11717.1 | 2468.0 |
| 2008-04-25 09:00:00 | YM | Futures | 11716.2 | 11734.3 | 11658.9 | 11659.8 | 16024.0 |
| 2008-04-25 10:00:00 | YM | Futures | 11659.8 | 11681.6 | 11628.0 | 11651.6 | 29646.0 |
| 2008-04-25 11:00:00 | YM | Futures | 11651.6 | 11658.0 | 11574.4 | 11622.6 | 30075.0 |
| 2008-04-25 12:00:00 | YM | Futures | 11621.7 | 11633.5 | 11604.4 | 11613.5 | 13980.0 |
| 2008-04-25 13:00:00 | YM | Futures | 11612.6 | 11635.3 | 11595.3 | 11631.6 | 10761.0 |
| 2008-04-25 14:00:00 | YM | Futures | 11630.7 | 11662.5 | 11628.0 | 11661.6 | 12697.0 |
| 2008-04-25 15:00:00 | YM | Futures | 11662.5 | 11719.8 | 11657.1 | 11712.5 | 23247.0 |
> showing 50 of 1,018 rows — these rows as CSV