PREVIEW / futures_1hour / 2008-04-06
file: by_date/futures_1hour/2008/2008-04-06.parquet size: 14 KB rows: 240
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-06 18:00:00 | ES | Futures | 1278.31 | 1280.17 | 1275.75 | 1279.94 | 3405.0 |
| 2008-04-06 19:00:00 | ES | Futures | 1279.94 | 1280.17 | 1278.78 | 1279.01 | 960.0 |
| 2008-04-06 20:00:00 | ES | Futures | 1278.78 | 1281.8 | 1278.31 | 1281.57 | 2954.0 |
| 2008-04-06 21:00:00 | ES | Futures | 1281.34 | 1281.57 | 1280.87 | 1281.34 | 1810.0 |
| 2008-04-06 22:00:00 | ES | Futures | 1281.34 | 1285.3 | 1279.94 | 1284.13 | 5769.0 |
| 2008-04-06 23:00:00 | ES | Futures | 1284.13 | 1285.3 | 1283.2 | 1284.83 | 2441.0 |
| 2008-04-06 18:00:00 | NQ | Futures | 2113.3 | 2119.23 | 2111.88 | 2119.23 | 318.0 |
| 2008-04-06 19:00:00 | NQ | Futures | 2119.23 | 2119.23 | 2116.41 | 2116.41 | 63.0 |
| 2008-04-06 20:00:00 | NQ | Futures | 2116.41 | 2121.21 | 2116.41 | 2121.21 | 119.0 |
| 2008-04-06 21:00:00 | NQ | Futures | 2120.93 | 2121.21 | 2120.08 | 2121.21 | 64.0 |
| 2008-04-06 22:00:00 | NQ | Futures | 2120.08 | 2127.44 | 2118.67 | 2126.31 | 356.0 |
| 2008-04-06 23:00:00 | NQ | Futures | 2126.02 | 2128.0 | 2125.17 | 2127.72 | 185.0 |
| 2008-04-06 18:00:00 | YM | Futures | 11457.2 | 11471.7 | 11444.5 | 11471.7 | 295.0 |
| 2008-04-06 19:00:00 | YM | Futures | 11470.8 | 11471.7 | 11462.6 | 11466.3 | 98.0 |
| 2008-04-06 20:00:00 | YM | Futures | 11467.2 | 11487.2 | 11464.5 | 11484.4 | 244.0 |
| 2008-04-06 21:00:00 | YM | Futures | 11483.5 | 11488.1 | 11483.5 | 11486.3 | 122.0 |
| 2008-04-06 22:00:00 | YM | Futures | 11484.4 | 11509.9 | 11476.3 | 11505.3 | 366.0 |
| 2008-04-06 23:00:00 | YM | Futures | 11505.3 | 11515.3 | 11499.0 | 11507.2 | 173.0 |
| 2008-04-06 18:00:00 | CL | Futures | 400.67 | 402.36 | 399.68 | 402.25 | 911.0 |
| 2008-04-06 19:00:00 | CL | Futures | 402.14 | 403.65 | 401.65 | 403.27 | 821.0 |
| 2008-04-06 20:00:00 | CL | Futures | 403.08 | 403.57 | 402.78 | 403.27 | 401.0 |
| 2008-04-06 21:00:00 | CL | Futures | 403.27 | 403.27 | 402.29 | 402.29 | 155.0 |
| 2008-04-06 22:00:00 | CL | Futures | 402.29 | 402.48 | 401.76 | 402.18 | 449.0 |
| 2008-04-06 23:00:00 | CL | Futures | 402.29 | 402.52 | 402.14 | 402.44 | 68.0 |
| 2008-04-06 18:00:00 | GC | Futures | 1328.6 | 1333.6 | 1328.3 | 1332.0 | 856.0 |
| 2008-04-06 19:00:00 | GC | Futures | 1331.6 | 1334.8 | 1331.6 | 1334.1 | 703.0 |
| 2008-04-06 20:00:00 | GC | Futures | 1334.1 | 1335.1 | 1331.5 | 1332.8 | 1236.0 |
| 2008-04-06 21:00:00 | GC | Futures | 1332.9 | 1333.8 | 1329.6 | 1330.0 | 851.0 |
| 2008-04-06 22:00:00 | GC | Futures | 1330.0 | 1330.4 | 1326.7 | 1329.1 | 783.0 |
| 2008-04-06 23:00:00 | GC | Futures | 1329.3 | 1332.0 | 1328.9 | 1331.6 | 391.0 |
| 2008-04-06 18:00:00 | ZN | Futures | 87.592592 | 87.592592 | 87.488536 | 87.500097 | 1149.0 |
| 2008-04-06 19:00:00 | ZN | Futures | 87.511659 | 87.534783 | 87.488536 | 87.500097 | 1154.0 |
| 2008-04-06 20:00:00 | ZN | Futures | 87.511659 | 87.511659 | 87.407603 | 87.442288 | 3725.0 |
| 2008-04-06 21:00:00 | ZN | Futures | 87.442288 | 87.442288 | 87.372917 | 87.372917 | 3196.0 |
| 2008-04-06 22:00:00 | ZN | Futures | 87.372917 | 87.372917 | 87.303546 | 87.315108 | 7133.0 |
| 2008-04-06 23:00:00 | ZN | Futures | 87.32667 | 87.349793 | 87.291984 | 87.32667 | 2326.0 |
> showing 36 of 240 rows — these rows as CSV