PREVIEW / futures_1hour / 2008-08-22
file: by_date/futures_1hour/2008/2008-08-22.parquet size: 36 KB rows: 974
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-08-22 00:00:00 | ES | Futures | 1185.09 | 1185.32 | 1183.69 | 1183.92 | 700.0 |
| 2008-08-22 01:00:00 | ES | Futures | 1183.92 | 1184.62 | 1183.69 | 1183.92 | 1016.0 |
| 2008-08-22 02:00:00 | ES | Futures | 1184.16 | 1185.09 | 1183.92 | 1185.09 | 2670.0 |
| 2008-08-22 03:00:00 | ES | Futures | 1185.32 | 1185.32 | 1182.53 | 1185.09 | 10810.0 |
| 2008-08-22 04:00:00 | ES | Futures | 1185.09 | 1187.64 | 1184.39 | 1187.18 | 10838.0 |
| 2008-08-22 05:00:00 | ES | Futures | 1186.95 | 1189.5 | 1186.95 | 1188.34 | 10610.0 |
| 2008-08-22 06:00:00 | ES | Futures | 1188.57 | 1188.8 | 1187.18 | 1187.87 | 5846.0 |
| 2008-08-22 07:00:00 | ES | Futures | 1187.64 | 1197.87 | 1187.18 | 1195.31 | 52667.0 |
| 2008-08-22 08:00:00 | ES | Futures | 1195.08 | 1196.47 | 1192.76 | 1195.54 | 43069.0 |
| 2008-08-22 09:00:00 | ES | Futures | 1195.31 | 1199.03 | 1192.52 | 1198.1 | 194507.0 |
| 2008-08-22 10:00:00 | ES | Futures | 1198.1 | 1202.98 | 1196.01 | 1199.5 | 278673.0 |
| 2008-08-22 11:00:00 | ES | Futures | 1199.5 | 1200.19 | 1196.01 | 1197.4 | 153689.0 |
| 2008-08-22 12:00:00 | ES | Futures | 1197.17 | 1197.4 | 1192.76 | 1196.24 | 141505.0 |
| 2008-08-22 13:00:00 | ES | Futures | 1196.47 | 1200.43 | 1196.01 | 1199.26 | 120580.0 |
| 2008-08-22 14:00:00 | ES | Futures | 1199.26 | 1201.59 | 1196.47 | 1198.57 | 118652.0 |
| 2008-08-22 15:00:00 | ES | Futures | 1198.33 | 1202.05 | 1196.94 | 1201.59 | 148649.0 |
| 2008-08-22 16:00:00 | ES | Futures | 1201.59 | 1202.05 | 1200.66 | 1201.35 | 65861.0 |
| 2008-08-22 00:00:00 | NQ | Futures | 2143.14 | 2143.42 | 2141.45 | 2141.45 | 29.0 |
| 2008-08-22 01:00:00 | NQ | Futures | 2141.45 | 2143.98 | 2141.17 | 2141.45 | 91.0 |
| 2008-08-22 02:00:00 | NQ | Futures | 2141.73 | 2143.7 | 2141.73 | 2143.14 | 294.0 |
| 2008-08-22 03:00:00 | NQ | Futures | 2143.14 | 2145.39 | 2139.48 | 2145.39 | 877.0 |
| 2008-08-22 04:00:00 | NQ | Futures | 2145.39 | 2150.45 | 2143.98 | 2149.33 | 1113.0 |
| 2008-08-22 05:00:00 | NQ | Futures | 2149.33 | 2153.83 | 2149.33 | 2152.42 | 1089.0 |
| 2008-08-22 06:00:00 | NQ | Futures | 2152.14 | 2152.42 | 2149.89 | 2151.02 | 514.0 |
| 2008-08-22 07:00:00 | NQ | Futures | 2150.45 | 2169.3 | 2149.61 | 2164.8 | 5818.0 |
| 2008-08-22 08:00:00 | NQ | Futures | 2164.52 | 2165.36 | 2155.52 | 2160.58 | 5757.0 |
| 2008-08-22 09:00:00 | NQ | Futures | 2160.58 | 2170.99 | 2155.52 | 2167.05 | 49989.0 |
| 2008-08-22 10:00:00 | NQ | Futures | 2167.33 | 2178.86 | 2163.95 | 2170.99 | 51604.0 |
| 2008-08-22 11:00:00 | NQ | Futures | 2170.71 | 2173.8 | 2167.05 | 2169.86 | 27207.0 |
| 2008-08-22 12:00:00 | NQ | Futures | 2169.86 | 2169.86 | 2160.3 | 2169.02 | 23195.0 |
| 2008-08-22 13:00:00 | NQ | Futures | 2169.3 | 2177.18 | 2167.89 | 2176.05 | 23829.0 |
| 2008-08-22 14:00:00 | NQ | Futures | 2176.05 | 2184.21 | 2171.83 | 2178.58 | 30751.0 |
| 2008-08-22 15:00:00 | NQ | Futures | 2178.58 | 2180.27 | 2173.8 | 2174.64 | 35700.0 |
| 2008-08-22 16:00:00 | NQ | Futures | 2174.64 | 2176.05 | 2170.71 | 2171.55 | 12685.0 |
| 2008-08-22 00:00:00 | YM | Futures | 10363.0 | 10363.0 | 10353.0 | 10355.7 | 108.0 |
| 2008-08-22 01:00:00 | YM | Futures | 10354.8 | 10357.5 | 10352.1 | 10352.1 | 34.0 |
| 2008-08-22 02:00:00 | YM | Futures | 10352.1 | 10363.9 | 10351.2 | 10363.9 | 136.0 |
| 2008-08-22 03:00:00 | YM | Futures | 10363.9 | 10363.9 | 10340.3 | 10363.0 | 919.0 |
| 2008-08-22 04:00:00 | YM | Futures | 10363.9 | 10383.9 | 10358.4 | 10377.5 | 1223.0 |
| 2008-08-22 05:00:00 | YM | Futures | 10378.4 | 10397.5 | 10378.4 | 10389.3 | 789.0 |
| 2008-08-22 06:00:00 | YM | Futures | 10388.4 | 10389.3 | 10377.5 | 10383.0 | 437.0 |
| 2008-08-22 07:00:00 | YM | Futures | 10380.3 | 10458.4 | 10377.5 | 10443.0 | 4168.0 |
| 2008-08-22 08:00:00 | YM | Futures | 10443.0 | 10461.1 | 10433.9 | 10460.2 | 3708.0 |
| 2008-08-22 09:00:00 | YM | Futures | 10460.2 | 10516.6 | 10434.8 | 10507.5 | 28042.0 |
| 2008-08-22 10:00:00 | YM | Futures | 10507.5 | 10575.7 | 10484.8 | 10560.2 | 44447.0 |
| 2008-08-22 11:00:00 | YM | Futures | 10560.2 | 10568.4 | 10522.9 | 10537.5 | 20142.0 |
| 2008-08-22 12:00:00 | YM | Futures | 10536.6 | 10537.5 | 10498.4 | 10531.1 | 16793.0 |
| 2008-08-22 13:00:00 | YM | Futures | 10529.3 | 10567.5 | 10525.7 | 10558.4 | 16079.0 |
| 2008-08-22 14:00:00 | YM | Futures | 10558.4 | 10573.8 | 10532.0 | 10551.1 | 15894.0 |
| 2008-08-22 15:00:00 | YM | Futures | 10550.2 | 10573.8 | 10532.9 | 10562.9 | 17063.0 |
> showing 50 of 974 rows — these rows as CSV