PREVIEW / futures_1hour / 2009-05-24
file: by_date/futures_1hour/2009/2009-05-24.parquet size: 10 KB rows: 159
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-24 18:00:00 | ES | Futures | 848.3 | 850.22 | 848.3 | 849.74 | 1818.0 |
| 2009-05-24 19:00:00 | ES | Futures | 849.5 | 850.94 | 849.26 | 850.22 | 1064.0 |
| 2009-05-24 20:00:00 | ES | Futures | 850.22 | 854.05 | 850.22 | 852.86 | 4030.0 |
| 2009-05-24 21:00:00 | ES | Futures | 853.1 | 853.34 | 849.74 | 849.74 | 2533.0 |
| 2009-05-24 22:00:00 | ES | Futures | 849.74 | 850.22 | 841.83 | 845.43 | 7273.0 |
| 2009-05-24 23:00:00 | ES | Futures | 845.43 | 847.82 | 844.47 | 847.35 | 2017.0 |
| 2009-05-24 18:00:00 | NQ | Futures | 1545.44 | 1549.7 | 1544.58 | 1547.43 | 170.0 |
| 2009-05-24 19:00:00 | NQ | Futures | 1547.99 | 1549.98 | 1546.29 | 1549.98 | 19.0 |
| 2009-05-24 20:00:00 | NQ | Futures | 1550.27 | 1554.24 | 1549.13 | 1551.97 | 276.0 |
| 2009-05-24 21:00:00 | NQ | Futures | 1553.11 | 1553.11 | 1547.99 | 1547.99 | 152.0 |
| 2009-05-24 22:00:00 | NQ | Futures | 1547.99 | 1548.28 | 1533.22 | 1538.62 | 465.0 |
| 2009-05-24 23:00:00 | NQ | Futures | 1539.47 | 1543.16 | 1537.48 | 1542.6 | 159.0 |
| 2009-05-24 18:00:00 | YM | Futures | 7598.8 | 7604.3 | 7594.2 | 7597.9 | 84.0 |
| 2009-05-24 19:00:00 | YM | Futures | 7595.1 | 7604.3 | 7595.1 | 7599.7 | 48.0 |
| 2009-05-24 20:00:00 | YM | Futures | 7602.5 | 7634.6 | 7602.5 | 7624.5 | 416.0 |
| 2009-05-24 21:00:00 | YM | Futures | 7625.4 | 7626.4 | 7603.4 | 7603.4 | 270.0 |
| 2009-05-24 22:00:00 | YM | Futures | 7603.4 | 7606.1 | 7539.1 | 7568.5 | 708.0 |
| 2009-05-24 23:00:00 | YM | Futures | 7570.3 | 7583.2 | 7560.2 | 7580.4 | 298.0 |
| 2009-05-24 18:00:00 | CL | Futures | 146.923 | 148.499 | 146.899 | 148.356 | 466.0 |
| 2009-05-24 19:00:00 | CL | Futures | 148.356 | 148.428 | 147.759 | 148.117 | 166.0 |
| 2009-05-24 20:00:00 | CL | Futures | 148.022 | 148.045 | 147.568 | 147.878 | 196.0 |
| 2009-05-24 21:00:00 | CL | Futures | 147.878 | 147.95 | 147.209 | 147.233 | 212.0 |
| 2009-05-24 22:00:00 | CL | Futures | 147.185 | 147.377 | 146.373 | 146.445 | 286.0 |
| 2009-05-24 23:00:00 | CL | Futures | 146.516 | 146.803 | 146.397 | 146.731 | 194.0 |
| 2009-05-24 18:00:00 | GC | Futures | 1359.0 | 1359.5 | 1357.5 | 1359.0 | 157.0 |
| 2009-05-24 19:00:00 | GC | Futures | 1358.4 | 1359.5 | 1357.8 | 1359.1 | 65.0 |
| 2009-05-24 20:00:00 | GC | Futures | 1358.8 | 1359.0 | 1356.7 | 1358.2 | 320.0 |
| 2009-05-24 21:00:00 | GC | Futures | 1357.7 | 1358.7 | 1356.8 | 1357.0 | 275.0 |
| 2009-05-24 22:00:00 | GC | Futures | 1357.0 | 1357.3 | 1353.6 | 1354.6 | 774.0 |
| 2009-05-24 23:00:00 | GC | Futures | 1354.6 | 1357.1 | 1354.6 | 1355.8 | 604.0 |
| 2009-05-24 18:00:00 | ZN | Futures | 93.11136 | 93.135779 | 92.952633 | 92.952633 | 1296.0 |
| 2009-05-24 19:00:00 | ZN | Futures | 92.952633 | 93.062521 | 92.952633 | 93.050311 | 1318.0 |
| 2009-05-24 20:00:00 | ZN | Futures | 93.050311 | 93.147989 | 93.050311 | 93.147989 | 601.0 |
| 2009-05-24 21:00:00 | ZN | Futures | 93.160199 | 93.209037 | 93.147989 | 93.196828 | 708.0 |
| 2009-05-24 22:00:00 | ZN | Futures | 93.196828 | 93.306715 | 93.172408 | 93.245667 | 1817.0 |
| 2009-05-24 23:00:00 | ZN | Futures | 93.245667 | 93.245667 | 93.184618 | 93.209037 | 245.0 |
> showing 36 of 159 rows — these rows as CSV