PREVIEW / futures_30min / 2008-05-18
file: by_date/futures_30min/2008/2008-05-18.parquet size: 17 KB rows: 394
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-05-18 18:00:00 | ES | Futures | 1327.44 | 1328.14 | 1327.21 | 1327.67 | 2894.0 |
| 2008-05-18 18:30:00 | ES | Futures | 1327.91 | 1327.91 | 1327.44 | 1327.67 | 225.0 |
| 2008-05-18 19:00:00 | ES | Futures | 1327.67 | 1327.91 | 1327.21 | 1327.44 | 196.0 |
| 2008-05-18 19:30:00 | ES | Futures | 1327.44 | 1327.67 | 1327.21 | 1327.21 | 388.0 |
| 2008-05-18 20:00:00 | ES | Futures | 1327.21 | 1327.44 | 1326.51 | 1326.98 | 1609.0 |
| 2008-05-18 20:30:00 | ES | Futures | 1327.21 | 1327.21 | 1326.04 | 1326.98 | 1421.0 |
| 2008-05-18 21:00:00 | ES | Futures | 1327.21 | 1327.67 | 1326.98 | 1327.21 | 563.0 |
| 2008-05-18 21:30:00 | ES | Futures | 1327.21 | 1327.21 | 1326.51 | 1326.74 | 891.0 |
| 2008-05-18 22:00:00 | ES | Futures | 1326.74 | 1327.44 | 1326.51 | 1326.98 | 376.0 |
| 2008-05-18 22:30:00 | ES | Futures | 1326.74 | 1327.21 | 1326.51 | 1326.74 | 328.0 |
| 2008-05-18 23:00:00 | ES | Futures | 1326.74 | 1326.98 | 1326.74 | 1326.74 | 121.0 |
| 2008-05-18 23:30:00 | ES | Futures | 1326.74 | 1327.21 | 1326.74 | 1327.21 | 170.0 |
| 2008-05-18 18:00:00 | NQ | Futures | 2302.79 | 2304.2 | 2302.22 | 2303.92 | 234.0 |
| 2008-05-18 18:30:00 | NQ | Futures | 2303.64 | 2303.64 | 2303.36 | 2303.36 | 13.0 |
| 2008-05-18 19:00:00 | NQ | Futures | 2303.07 | 2303.36 | 2302.79 | 2303.36 | 12.0 |
| 2008-05-18 19:30:00 | NQ | Futures | 2303.07 | 2303.07 | 2302.51 | 2302.79 | 17.0 |
| 2008-05-18 20:00:00 | NQ | Futures | 2302.22 | 2302.22 | 2300.25 | 2300.25 | 67.0 |
| 2008-05-18 20:30:00 | NQ | Futures | 2300.81 | 2302.22 | 2299.96 | 2301.94 | 86.0 |
| 2008-05-18 21:00:00 | NQ | Futures | 2301.94 | 2302.79 | 2301.66 | 2301.66 | 20.0 |
| 2008-05-18 21:30:00 | NQ | Futures | 2301.66 | 2301.66 | 2299.96 | 2299.96 | 54.0 |
| 2008-05-18 22:00:00 | NQ | Futures | 2300.53 | 2300.81 | 2299.96 | 2300.25 | 66.0 |
| 2008-05-18 22:30:00 | NQ | Futures | 2300.25 | 2300.53 | 2300.25 | 2300.53 | 7.0 |
| 2008-05-18 23:00:00 | NQ | Futures | 2300.25 | 2301.66 | 2300.25 | 2301.38 | 47.0 |
| 2008-05-18 23:30:00 | NQ | Futures | 2301.38 | 2301.38 | 2299.96 | 2301.09 | 36.0 |
| 2008-05-18 18:00:00 | YM | Futures | 11799.7 | 11803.4 | 11793.4 | 11800.7 | 56.0 |
| 2008-05-18 18:30:00 | YM | Futures | 11796.1 | 11796.1 | 11790.7 | 11794.3 | 16.0 |
| 2008-05-18 19:00:00 | YM | Futures | 11792.5 | 11795.2 | 11790.7 | 11790.7 | 19.0 |
| 2008-05-18 19:30:00 | YM | Futures | 11790.7 | 11792.5 | 11787.0 | 11790.7 | 106.0 |
| 2008-05-18 20:00:00 | YM | Futures | 11789.8 | 11791.6 | 11787.0 | 11787.0 | 36.0 |
| 2008-05-18 20:30:00 | YM | Futures | 11787.0 | 11789.8 | 11785.2 | 11788.8 | 50.0 |
| 2008-05-18 21:00:00 | YM | Futures | 11788.8 | 11793.4 | 11787.0 | 11787.9 | 80.0 |
| 2008-05-18 21:30:00 | YM | Futures | 11787.9 | 11787.9 | 11785.2 | 11786.1 | 36.0 |
| 2008-05-18 22:00:00 | YM | Futures | 11785.2 | 11787.9 | 11784.3 | 11784.3 | 67.0 |
| 2008-05-18 22:30:00 | YM | Futures | 11785.2 | 11789.8 | 11785.2 | 11787.0 | 41.0 |
| 2008-05-18 23:00:00 | YM | Futures | 11787.0 | 11789.8 | 11784.3 | 11787.9 | 22.0 |
| 2008-05-18 23:30:00 | YM | Futures | 11787.9 | 11792.5 | 11787.9 | 11787.9 | 22.0 |
| 2008-05-18 18:00:00 | CL | Futures | 480.84 | 480.84 | 480.04 | 480.42 | 275.0 |
| 2008-05-18 18:30:00 | CL | Futures | 480.31 | 481.8 | 480.27 | 481.34 | 307.0 |
| 2008-05-18 19:00:00 | CL | Futures | 481.41 | 482.06 | 481.41 | 481.64 | 208.0 |
| 2008-05-18 19:30:00 | CL | Futures | 481.61 | 481.91 | 481.57 | 481.91 | 127.0 |
| 2008-05-18 20:00:00 | CL | Futures | 481.95 | 481.95 | 481.38 | 481.76 | 97.0 |
| 2008-05-18 20:30:00 | CL | Futures | 481.64 | 481.8 | 481.53 | 481.8 | 47.0 |
| 2008-05-18 21:00:00 | CL | Futures | 481.72 | 481.87 | 481.53 | 481.68 | 79.0 |
| 2008-05-18 21:30:00 | CL | Futures | 481.68 | 481.83 | 481.61 | 481.76 | 77.0 |
| 2008-05-18 22:00:00 | CL | Futures | 481.76 | 482.18 | 481.53 | 481.53 | 245.0 |
| 2008-05-18 22:30:00 | CL | Futures | 481.57 | 481.57 | 481.19 | 481.38 | 90.0 |
| 2008-05-18 23:00:00 | CL | Futures | 481.41 | 482.67 | 481.38 | 482.63 | 177.0 |
| 2008-05-18 23:30:00 | CL | Futures | 482.63 | 482.71 | 482.48 | 482.56 | 47.0 |
| 2008-05-18 18:00:00 | GC | Futures | 1308.6 | 1312.0 | 1307.7 | 1309.7 | 759.0 |
| 2008-05-18 18:30:00 | GC | Futures | 1310.0 | 1312.6 | 1309.3 | 1312.5 | 394.0 |
> showing 50 of 394 rows — these rows as CSV