PREVIEW / futures_1hour / 2008-08-24
file: by_date/futures_1hour/2008/2008-08-24.parquet size: 13 KB rows: 207
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-24 18:00:00 | ES | Futures | 1200.19 | 1201.35 | 1199.5 | 1200.19 | 2352.0 |
| 2008-08-24 19:00:00 | ES | Futures | 1200.19 | 1200.43 | 1196.94 | 1197.64 | 3235.0 |
| 2008-08-24 20:00:00 | ES | Futures | 1197.64 | 1198.57 | 1197.4 | 1198.1 | 1830.0 |
| 2008-08-24 21:00:00 | ES | Futures | 1198.1 | 1199.96 | 1197.87 | 1199.03 | 2664.0 |
| 2008-08-24 22:00:00 | ES | Futures | 1198.8 | 1199.26 | 1198.33 | 1198.8 | 1251.0 |
| 2008-08-24 23:00:00 | ES | Futures | 1198.8 | 1199.26 | 1198.8 | 1199.26 | 479.0 |
| 2008-08-24 18:00:00 | NQ | Futures | 2171.55 | 2171.55 | 2168.46 | 2169.86 | 154.0 |
| 2008-08-24 19:00:00 | NQ | Futures | 2169.86 | 2169.86 | 2163.95 | 2165.92 | 530.0 |
| 2008-08-24 20:00:00 | NQ | Futures | 2166.2 | 2167.05 | 2165.92 | 2166.77 | 213.0 |
| 2008-08-24 21:00:00 | NQ | Futures | 2167.33 | 2170.42 | 2165.92 | 2169.02 | 401.0 |
| 2008-08-24 22:00:00 | NQ | Futures | 2168.74 | 2169.02 | 2167.61 | 2168.17 | 24.0 |
| 2008-08-24 23:00:00 | NQ | Futures | 2168.17 | 2169.3 | 2168.17 | 2168.46 | 44.0 |
| 2008-08-24 18:00:00 | YM | Futures | 10558.4 | 10561.1 | 10544.8 | 10549.3 | 146.0 |
| 2008-08-24 19:00:00 | YM | Futures | 10550.2 | 10552.0 | 10530.2 | 10532.9 | 272.0 |
| 2008-08-24 20:00:00 | YM | Futures | 10533.9 | 10542.9 | 10532.0 | 10541.1 | 201.0 |
| 2008-08-24 21:00:00 | YM | Futures | 10540.2 | 10551.1 | 10538.4 | 10544.8 | 243.0 |
| 2008-08-24 22:00:00 | YM | Futures | 10544.8 | 10548.4 | 10540.2 | 10542.9 | 90.0 |
| 2008-08-24 23:00:00 | YM | Futures | 10545.7 | 10549.3 | 10538.4 | 10546.6 | 164.0 |
| 2008-08-24 18:00:00 | CL | Futures | 433.64 | 434.43 | 431.33 | 431.78 | 680.0 |
| 2008-08-24 19:00:00 | CL | Futures | 431.63 | 433.15 | 431.33 | 433.15 | 480.0 |
| 2008-08-24 20:00:00 | CL | Futures | 433.03 | 433.64 | 431.37 | 431.67 | 324.0 |
| 2008-08-24 21:00:00 | CL | Futures | 431.41 | 432.43 | 431.14 | 432.35 | 305.0 |
| 2008-08-24 22:00:00 | CL | Futures | 432.24 | 433.56 | 432.24 | 433.37 | 208.0 |
| 2008-08-24 23:00:00 | CL | Futures | 433.6 | 433.94 | 432.92 | 433.15 | 216.0 |
| 2008-08-24 18:00:00 | GC | Futures | 1186.2 | 1186.3 | 1179.5 | 1182.2 | 605.0 |
| 2008-08-24 19:00:00 | GC | Futures | 1182.3 | 1183.6 | 1180.7 | 1180.7 | 241.0 |
| 2008-08-24 20:00:00 | GC | Futures | 1180.9 | 1181.2 | 1173.9 | 1174.0 | 2733.0 |
| 2008-08-24 21:00:00 | GC | Futures | 1173.9 | 1177.2 | 1173.9 | 1177.0 | 732.0 |
| 2008-08-24 22:00:00 | GC | Futures | 1177.2 | 1178.0 | 1175.7 | 1178.0 | 617.0 |
| 2008-08-24 23:00:00 | GC | Futures | 1177.9 | 1178.2 | 1175.9 | 1176.3 | 537.0 |
| 2008-08-24 18:00:00 | ZN | Futures | 86.891902 | 86.903603 | 86.833397 | 86.8685 | 2082.0 |
| 2008-08-24 19:00:00 | ZN | Futures | 86.891902 | 86.985511 | 86.880201 | 86.962109 | 3284.0 |
| 2008-08-24 20:00:00 | ZN | Futures | 86.97381 | 86.985511 | 86.880201 | 86.880201 | 2010.0 |
| 2008-08-24 21:00:00 | ZN | Futures | 86.880201 | 86.962109 | 86.880201 | 86.950408 | 3850.0 |
| 2008-08-24 22:00:00 | ZN | Futures | 86.950408 | 86.985511 | 86.938706 | 86.97381 | 1471.0 |
| 2008-08-24 23:00:00 | ZN | Futures | 86.97381 | 86.985511 | 86.962109 | 86.97381 | 635.0 |
> showing 36 of 207 rows — these rows as CSV