PREVIEW / futures_30min / 2008-11-09
file: by_date/futures_30min/2008/2008-11-09.parquet size: 19 KB rows: 434
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-09 18:00:00 | ES | Futures | 890.75 | 902.58 | 890.75 | 901.16 | 18798.0 |
| 2008-11-09 18:30:00 | ES | Futures | 901.16 | 903.29 | 899.74 | 902.11 | 5925.0 |
| 2008-11-09 19:00:00 | ES | Futures | 902.11 | 905.66 | 902.11 | 905.66 | 7709.0 |
| 2008-11-09 19:30:00 | ES | Futures | 905.66 | 906.6 | 903.06 | 904.0 | 4234.0 |
| 2008-11-09 20:00:00 | ES | Futures | 904.0 | 904.0 | 900.45 | 901.16 | 2794.0 |
| 2008-11-09 20:30:00 | ES | Futures | 900.93 | 902.11 | 899.51 | 901.87 | 3333.0 |
| 2008-11-09 21:00:00 | ES | Futures | 901.87 | 904.0 | 900.69 | 903.76 | 3421.0 |
| 2008-11-09 21:30:00 | ES | Futures | 903.76 | 904.71 | 901.64 | 901.87 | 3611.0 |
| 2008-11-09 22:00:00 | ES | Futures | 902.35 | 902.58 | 899.98 | 900.45 | 1318.0 |
| 2008-11-09 22:30:00 | ES | Futures | 900.45 | 901.64 | 899.27 | 901.4 | 2862.0 |
| 2008-11-09 23:00:00 | ES | Futures | 901.4 | 903.06 | 900.93 | 902.11 | 1397.0 |
| 2008-11-09 23:30:00 | ES | Futures | 901.87 | 901.87 | 900.69 | 900.93 | 828.0 |
| 2008-11-09 18:00:00 | NQ | Futures | 1463.49 | 1481.31 | 1463.49 | 1478.2 | 880.0 |
| 2008-11-09 18:30:00 | NQ | Futures | 1479.62 | 1484.99 | 1477.63 | 1481.6 | 288.0 |
| 2008-11-09 19:00:00 | NQ | Futures | 1483.29 | 1488.67 | 1483.01 | 1488.1 | 248.0 |
| 2008-11-09 19:30:00 | NQ | Futures | 1488.67 | 1489.52 | 1482.73 | 1484.43 | 178.0 |
| 2008-11-09 20:00:00 | NQ | Futures | 1484.43 | 1485.84 | 1480.18 | 1483.29 | 134.0 |
| 2008-11-09 20:30:00 | NQ | Futures | 1481.6 | 1483.01 | 1479.33 | 1481.88 | 100.0 |
| 2008-11-09 21:00:00 | NQ | Futures | 1482.73 | 1484.99 | 1482.16 | 1484.99 | 56.0 |
| 2008-11-09 21:30:00 | NQ | Futures | 1486.69 | 1487.26 | 1482.45 | 1482.45 | 69.0 |
| 2008-11-09 22:00:00 | NQ | Futures | 1482.45 | 1483.29 | 1479.05 | 1479.33 | 35.0 |
| 2008-11-09 22:30:00 | NQ | Futures | 1480.18 | 1481.31 | 1478.48 | 1481.31 | 81.0 |
| 2008-11-09 23:00:00 | NQ | Futures | 1480.46 | 1484.99 | 1480.46 | 1482.73 | 47.0 |
| 2008-11-09 23:30:00 | NQ | Futures | 1482.73 | 1482.73 | 1479.33 | 1479.33 | 9.0 |
| 2008-11-09 18:00:00 | YM | Futures | 8205.7 | 8318.5 | 8205.7 | 8310.3 | 1027.0 |
| 2008-11-09 18:30:00 | YM | Futures | 8313.0 | 8329.4 | 8301.2 | 8319.4 | 535.0 |
| 2008-11-09 19:00:00 | YM | Futures | 8319.4 | 8348.5 | 8319.4 | 8347.6 | 434.0 |
| 2008-11-09 19:30:00 | YM | Futures | 8348.5 | 8354.8 | 8320.3 | 8331.2 | 550.0 |
| 2008-11-09 20:00:00 | YM | Futures | 8329.4 | 8329.4 | 8303.9 | 8305.7 | 390.0 |
| 2008-11-09 20:30:00 | YM | Futures | 8304.8 | 8314.8 | 8291.2 | 8311.2 | 262.0 |
| 2008-11-09 21:00:00 | YM | Futures | 8311.2 | 8324.8 | 8302.1 | 8323.9 | 142.0 |
| 2008-11-09 21:30:00 | YM | Futures | 8322.1 | 8331.2 | 8306.6 | 8306.6 | 270.0 |
| 2008-11-09 22:00:00 | YM | Futures | 8309.4 | 8311.2 | 8287.5 | 8294.8 | 187.0 |
| 2008-11-09 22:30:00 | YM | Futures | 8294.8 | 8303.0 | 8283.0 | 8299.4 | 269.0 |
| 2008-11-09 23:00:00 | YM | Futures | 8296.6 | 8312.1 | 8293.9 | 8299.4 | 159.0 |
| 2008-11-09 23:30:00 | YM | Futures | 8299.4 | 8300.3 | 8291.2 | 8294.8 | 73.0 |
| 2008-11-09 18:00:00 | CL | Futures | 231.81 | 236.98 | 231.77 | 236.76 | 2024.0 |
| 2008-11-09 18:30:00 | CL | Futures | 236.83 | 237.06 | 235.71 | 236.83 | 691.0 |
| 2008-11-09 19:00:00 | CL | Futures | 236.87 | 241.18 | 236.49 | 240.06 | 1632.0 |
| 2008-11-09 19:30:00 | CL | Futures | 240.17 | 240.96 | 239.61 | 239.72 | 586.0 |
| 2008-11-09 20:00:00 | CL | Futures | 239.68 | 240.88 | 239.01 | 239.12 | 571.0 |
| 2008-11-09 20:30:00 | CL | Futures | 239.42 | 239.83 | 239.12 | 239.72 | 214.0 |
| 2008-11-09 21:00:00 | CL | Futures | 239.72 | 239.98 | 239.49 | 239.53 | 177.0 |
| 2008-11-09 21:30:00 | CL | Futures | 239.72 | 240.06 | 239.42 | 240.06 | 205.0 |
| 2008-11-09 22:00:00 | CL | Futures | 240.09 | 240.99 | 239.83 | 240.77 | 296.0 |
| 2008-11-09 22:30:00 | CL | Futures | 240.66 | 240.66 | 239.12 | 239.12 | 229.0 |
| 2008-11-09 23:00:00 | CL | Futures | 239.16 | 239.61 | 238.03 | 238.89 | 493.0 |
| 2008-11-09 23:30:00 | CL | Futures | 238.82 | 238.93 | 237.88 | 237.96 | 264.0 |
| 2008-11-09 18:00:00 | GC | Futures | 1055.9 | 1068.0 | 1053.9 | 1067.6 | 1127.0 |
| 2008-11-09 18:30:00 | GC | Futures | 1066.8 | 1069.7 | 1064.1 | 1068.6 | 611.0 |
> showing 50 of 434 rows — these rows as CSV