PREVIEW / futures_30min / 2008-11-02
file: by_date/futures_30min/2008/2008-11-02.parquet size: 19 KB rows: 422
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-11-02 18:00:00 | ES | Futures | 914.18 | 914.89 | 910.39 | 913.47 | 5507.0 |
| 2008-11-02 18:30:00 | ES | Futures | 913.23 | 916.78 | 911.34 | 913.47 | 3532.0 |
| 2008-11-02 19:00:00 | ES | Futures | 913.47 | 916.54 | 912.52 | 916.54 | 1675.0 |
| 2008-11-02 19:30:00 | ES | Futures | 916.54 | 916.54 | 914.41 | 916.31 | 1845.0 |
| 2008-11-02 20:00:00 | ES | Futures | 916.31 | 919.15 | 915.6 | 916.31 | 1986.0 |
| 2008-11-02 20:30:00 | ES | Futures | 916.31 | 924.83 | 916.31 | 924.35 | 4556.0 |
| 2008-11-02 21:00:00 | ES | Futures | 924.12 | 927.43 | 923.88 | 924.12 | 4302.0 |
| 2008-11-02 21:30:00 | ES | Futures | 923.88 | 926.25 | 923.41 | 923.64 | 2255.0 |
| 2008-11-02 22:00:00 | ES | Futures | 923.64 | 924.59 | 921.99 | 922.7 | 2601.0 |
| 2008-11-02 22:30:00 | ES | Futures | 922.46 | 925.77 | 919.86 | 924.35 | 2658.0 |
| 2008-11-02 23:00:00 | ES | Futures | 924.35 | 925.3 | 923.41 | 923.41 | 547.0 |
| 2008-11-02 23:30:00 | ES | Futures | 923.41 | 925.3 | 921.51 | 925.06 | 1007.0 |
| 2008-11-02 18:00:00 | NQ | Futures | 1516.68 | 1516.68 | 1507.06 | 1512.72 | 250.0 |
| 2008-11-02 18:30:00 | NQ | Futures | 1511.31 | 1516.68 | 1508.76 | 1511.31 | 119.0 |
| 2008-11-02 19:00:00 | NQ | Futures | 1511.59 | 1515.27 | 1510.46 | 1514.42 | 125.0 |
| 2008-11-02 19:30:00 | NQ | Futures | 1514.7 | 1515.55 | 1512.16 | 1514.99 | 47.0 |
| 2008-11-02 20:00:00 | NQ | Futures | 1515.27 | 1516.68 | 1513.57 | 1515.27 | 110.0 |
| 2008-11-02 20:30:00 | NQ | Futures | 1514.7 | 1532.53 | 1514.7 | 1531.96 | 578.0 |
| 2008-11-02 21:00:00 | NQ | Futures | 1529.7 | 1535.36 | 1529.7 | 1529.98 | 103.0 |
| 2008-11-02 21:30:00 | NQ | Futures | 1529.13 | 1531.4 | 1528.0 | 1528.0 | 39.0 |
| 2008-11-02 22:00:00 | NQ | Futures | 1528.57 | 1528.57 | 1523.47 | 1524.61 | 290.0 |
| 2008-11-02 22:30:00 | NQ | Futures | 1523.19 | 1529.13 | 1521.21 | 1529.13 | 123.0 |
| 2008-11-02 23:00:00 | NQ | Futures | 1526.87 | 1529.13 | 1526.87 | 1529.13 | 9.0 |
| 2008-11-02 23:30:00 | NQ | Futures | 1525.74 | 1529.13 | 1522.34 | 1528.85 | 51.0 |
| 2008-11-02 18:00:00 | YM | Futures | 8454.0 | 8454.9 | 8415.8 | 8443.1 | 502.0 |
| 2008-11-02 18:30:00 | YM | Futures | 8439.4 | 8470.3 | 8423.1 | 8442.2 | 150.0 |
| 2008-11-02 19:00:00 | YM | Futures | 8444.9 | 8472.2 | 8435.8 | 8466.7 | 175.0 |
| 2008-11-02 19:30:00 | YM | Futures | 8467.6 | 8471.3 | 8453.1 | 8468.5 | 117.0 |
| 2008-11-02 20:00:00 | YM | Futures | 8469.4 | 8484.0 | 8464.9 | 8472.2 | 197.0 |
| 2008-11-02 20:30:00 | YM | Futures | 8469.4 | 8546.7 | 8469.4 | 8544.9 | 610.0 |
| 2008-11-02 21:00:00 | YM | Futures | 8544.9 | 8568.6 | 8539.5 | 8547.7 | 587.0 |
| 2008-11-02 21:30:00 | YM | Futures | 8545.8 | 8563.1 | 8538.6 | 8540.4 | 199.0 |
| 2008-11-02 22:00:00 | YM | Futures | 8543.1 | 8550.4 | 8528.6 | 8538.6 | 237.0 |
| 2008-11-02 22:30:00 | YM | Futures | 8535.8 | 8557.7 | 8505.8 | 8548.6 | 375.0 |
| 2008-11-02 23:00:00 | YM | Futures | 8545.8 | 8554.0 | 8535.8 | 8541.3 | 226.0 |
| 2008-11-02 23:30:00 | YM | Futures | 8541.3 | 8554.0 | 8526.7 | 8554.0 | 98.0 |
| 2008-11-02 18:00:00 | CL | Futures | 252.7 | 253.79 | 250.11 | 250.75 | 576.0 |
| 2008-11-02 18:30:00 | CL | Futures | 250.67 | 252.25 | 250.67 | 251.76 | 138.0 |
| 2008-11-02 19:00:00 | CL | Futures | 251.91 | 252.25 | 251.27 | 251.8 | 103.0 |
| 2008-11-02 19:30:00 | CL | Futures | 251.83 | 253.19 | 251.5 | 252.92 | 235.0 |
| 2008-11-02 20:00:00 | CL | Futures | 252.81 | 254.76 | 252.81 | 254.69 | 358.0 |
| 2008-11-02 20:30:00 | CL | Futures | 254.72 | 256.11 | 254.72 | 256.04 | 426.0 |
| 2008-11-02 21:00:00 | CL | Futures | 256.07 | 256.82 | 255.66 | 256.19 | 346.0 |
| 2008-11-02 21:30:00 | CL | Futures | 256.26 | 257.8 | 256.19 | 257.27 | 327.0 |
| 2008-11-02 22:00:00 | CL | Futures | 257.39 | 258.59 | 256.49 | 257.01 | 404.0 |
| 2008-11-02 22:30:00 | CL | Futures | 256.97 | 258.7 | 256.56 | 258.62 | 156.0 |
| 2008-11-02 23:00:00 | CL | Futures | 258.4 | 258.7 | 258.06 | 258.21 | 117.0 |
| 2008-11-02 23:30:00 | CL | Futures | 258.25 | 258.51 | 257.72 | 258.47 | 213.0 |
| 2008-11-02 18:00:00 | GC | Futures | 1037.6 | 1041.2 | 1037.3 | 1040.4 | 530.0 |
| 2008-11-02 18:30:00 | GC | Futures | 1040.9 | 1041.2 | 1039.3 | 1041.0 | 178.0 |
> showing 50 of 422 rows — these rows as CSV