PREVIEW / futures_30min / 2008-03-23
file: by_date/futures_30min/2008/2008-03-23.parquet size: 20 KB rows: 428
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-03-23 18:00:00 | ES | Futures | 1235.24 | 1237.8 | 1234.3 | 1237.33 | 4780.0 |
| 2008-03-23 18:30:00 | ES | Futures | 1237.33 | 1237.33 | 1234.77 | 1235.24 | 1262.0 |
| 2008-03-23 19:00:00 | ES | Futures | 1235.47 | 1236.87 | 1234.77 | 1236.63 | 529.0 |
| 2008-03-23 19:30:00 | ES | Futures | 1236.63 | 1238.26 | 1236.4 | 1237.56 | 1239.0 |
| 2008-03-23 20:00:00 | ES | Futures | 1237.8 | 1240.59 | 1237.33 | 1240.36 | 2677.0 |
| 2008-03-23 20:30:00 | ES | Futures | 1240.36 | 1244.78 | 1240.13 | 1242.45 | 5993.0 |
| 2008-03-23 21:00:00 | ES | Futures | 1242.22 | 1243.39 | 1241.76 | 1242.92 | 2509.0 |
| 2008-03-23 21:30:00 | ES | Futures | 1242.92 | 1243.15 | 1241.06 | 1241.29 | 1307.0 |
| 2008-03-23 22:00:00 | ES | Futures | 1241.52 | 1242.45 | 1240.82 | 1241.52 | 1110.0 |
| 2008-03-23 22:30:00 | ES | Futures | 1241.29 | 1242.69 | 1241.29 | 1242.22 | 555.0 |
| 2008-03-23 23:00:00 | ES | Futures | 1242.45 | 1242.92 | 1240.13 | 1240.13 | 854.0 |
| 2008-03-23 23:30:00 | ES | Futures | 1240.13 | 1241.52 | 1240.13 | 1241.06 | 678.0 |
| 2008-03-23 18:00:00 | NQ | Futures | 1982.91 | 1985.74 | 1978.1 | 1982.35 | 799.0 |
| 2008-03-23 18:30:00 | NQ | Futures | 1983.48 | 1983.76 | 1978.95 | 1978.95 | 99.0 |
| 2008-03-23 19:00:00 | NQ | Futures | 1979.23 | 1982.63 | 1979.23 | 1982.63 | 44.0 |
| 2008-03-23 19:30:00 | NQ | Futures | 1982.63 | 1985.46 | 1981.78 | 1984.33 | 29.0 |
| 2008-03-23 20:00:00 | NQ | Futures | 1984.33 | 1990.27 | 1984.33 | 1989.98 | 87.0 |
| 2008-03-23 20:30:00 | NQ | Futures | 1989.98 | 1996.49 | 1989.98 | 1992.81 | 381.0 |
| 2008-03-23 21:00:00 | NQ | Futures | 1991.96 | 1992.81 | 1989.42 | 1989.98 | 735.0 |
| 2008-03-23 21:30:00 | NQ | Futures | 1989.7 | 1990.27 | 1986.02 | 1987.15 | 360.0 |
| 2008-03-23 22:00:00 | NQ | Futures | 1987.15 | 1989.13 | 1986.59 | 1987.15 | 102.0 |
| 2008-03-23 22:30:00 | NQ | Futures | 1987.15 | 1990.27 | 1987.15 | 1990.27 | 34.0 |
| 2008-03-23 23:00:00 | NQ | Futures | 1989.42 | 1990.27 | 1986.31 | 1986.31 | 51.0 |
| 2008-03-23 23:30:00 | NQ | Futures | 1986.02 | 1988.57 | 1983.76 | 1985.74 | 82.0 |
| 2008-03-23 18:00:00 | YM | Futures | 11203.7 | 11220.9 | 11191.9 | 11212.8 | 127.0 |
| 2008-03-23 18:30:00 | YM | Futures | 11213.7 | 11217.3 | 11203.7 | 11205.5 | 58.0 |
| 2008-03-23 19:00:00 | YM | Futures | 11206.4 | 11218.2 | 11205.5 | 11212.8 | 33.0 |
| 2008-03-23 19:30:00 | YM | Futures | 11215.5 | 11230.0 | 11214.6 | 11220.0 | 91.0 |
| 2008-03-23 20:00:00 | YM | Futures | 11221.8 | 11250.9 | 11217.3 | 11245.5 | 100.0 |
| 2008-03-23 20:30:00 | YM | Futures | 11245.5 | 11267.3 | 11245.5 | 11265.5 | 243.0 |
| 2008-03-23 21:00:00 | YM | Futures | 11256.4 | 11265.5 | 11253.6 | 11260.9 | 65.0 |
| 2008-03-23 21:30:00 | YM | Futures | 11259.1 | 11264.6 | 11245.5 | 11247.3 | 92.0 |
| 2008-03-23 22:00:00 | YM | Futures | 11250.0 | 11265.5 | 11247.3 | 11253.6 | 132.0 |
| 2008-03-23 22:30:00 | YM | Futures | 11252.7 | 11267.3 | 11251.8 | 11262.7 | 65.0 |
| 2008-03-23 23:00:00 | YM | Futures | 11262.7 | 11264.6 | 11249.1 | 11249.1 | 63.0 |
| 2008-03-23 23:30:00 | YM | Futures | 11249.1 | 11258.2 | 11249.1 | 11255.5 | 83.0 |
| 2008-03-23 18:00:00 | CL | Futures | 383.98 | 383.98 | 380.81 | 381.49 | 503.0 |
| 2008-03-23 18:30:00 | CL | Futures | 381.52 | 381.9 | 380.92 | 381.71 | 156.0 |
| 2008-03-23 19:00:00 | CL | Futures | 381.71 | 381.71 | 380.77 | 381.07 | 111.0 |
| 2008-03-23 19:30:00 | CL | Futures | 380.99 | 380.99 | 379.82 | 380.16 | 397.0 |
| 2008-03-23 20:00:00 | CL | Futures | 380.39 | 381.3 | 379.45 | 380.81 | 226.0 |
| 2008-03-23 20:30:00 | CL | Futures | 380.96 | 381.71 | 379.18 | 379.22 | 459.0 |
| 2008-03-23 21:00:00 | CL | Futures | 379.26 | 379.94 | 378.31 | 379.94 | 347.0 |
| 2008-03-23 21:30:00 | CL | Futures | 379.98 | 380.39 | 379.22 | 379.41 | 127.0 |
| 2008-03-23 22:00:00 | CL | Futures | 379.3 | 379.45 | 378.39 | 378.43 | 185.0 |
| 2008-03-23 22:30:00 | CL | Futures | 378.58 | 379.3 | 378.16 | 378.5 | 289.0 |
| 2008-03-23 23:00:00 | CL | Futures | 378.77 | 378.92 | 378.24 | 378.43 | 117.0 |
| 2008-03-23 23:30:00 | CL | Futures | 378.39 | 379.18 | 378.01 | 378.05 | 76.0 |
| 2008-03-23 18:00:00 | GC | Futures | 1336.8 | 1340.4 | 1330.4 | 1333.2 | 868.0 |
| 2008-03-23 18:30:00 | GC | Futures | 1333.2 | 1334.3 | 1326.9 | 1330.4 | 798.0 |
> showing 50 of 428 rows — these rows as CSV