PREVIEW / futures_30min / 2008-10-19
file: by_date/futures_30min/2008/2008-10-19.parquet size: 18 KB rows: 413
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-10-19 18:00:00 | ES | Futures | 887.44 | 890.75 | 876.08 | 877.5 | 13653.0 |
| 2008-10-19 18:30:00 | ES | Futures | 877.73 | 884.6 | 877.26 | 884.12 | 3614.0 |
| 2008-10-19 19:00:00 | ES | Futures | 884.12 | 889.33 | 883.41 | 887.44 | 4043.0 |
| 2008-10-19 19:30:00 | ES | Futures | 886.96 | 891.7 | 885.54 | 891.7 | 3987.0 |
| 2008-10-19 20:00:00 | ES | Futures | 891.7 | 891.7 | 886.25 | 890.51 | 3529.0 |
| 2008-10-19 20:30:00 | ES | Futures | 890.51 | 893.59 | 890.51 | 893.12 | 3945.0 |
| 2008-10-19 21:00:00 | ES | Futures | 893.12 | 893.59 | 890.75 | 892.41 | 2804.0 |
| 2008-10-19 21:30:00 | ES | Futures | 892.41 | 893.35 | 886.73 | 888.62 | 2734.0 |
| 2008-10-19 22:00:00 | ES | Futures | 888.86 | 891.46 | 888.15 | 890.75 | 1834.0 |
| 2008-10-19 22:30:00 | ES | Futures | 890.51 | 892.64 | 889.57 | 891.93 | 1272.0 |
| 2008-10-19 23:00:00 | ES | Futures | 891.93 | 892.64 | 890.75 | 891.7 | 818.0 |
| 2008-10-19 23:30:00 | ES | Futures | 891.93 | 894.54 | 891.7 | 894.06 | 2557.0 |
| 2008-10-19 18:00:00 | NQ | Futures | 1487.26 | 1494.33 | 1469.15 | 1469.43 | 1152.0 |
| 2008-10-19 18:30:00 | NQ | Futures | 1471.13 | 1482.73 | 1470.84 | 1482.16 | 245.0 |
| 2008-10-19 19:00:00 | NQ | Futures | 1481.88 | 1489.52 | 1477.35 | 1486.12 | 360.0 |
| 2008-10-19 19:30:00 | NQ | Futures | 1486.12 | 1497.44 | 1486.12 | 1497.44 | 231.0 |
| 2008-10-19 20:00:00 | NQ | Futures | 1496.03 | 1496.03 | 1486.69 | 1492.35 | 174.0 |
| 2008-10-19 20:30:00 | NQ | Futures | 1492.35 | 1498.01 | 1492.35 | 1496.88 | 218.0 |
| 2008-10-19 21:00:00 | NQ | Futures | 1496.59 | 1499.42 | 1495.46 | 1497.73 | 248.0 |
| 2008-10-19 21:30:00 | NQ | Futures | 1497.44 | 1499.71 | 1488.67 | 1492.35 | 156.0 |
| 2008-10-19 22:00:00 | NQ | Futures | 1491.78 | 1497.44 | 1491.78 | 1496.59 | 103.0 |
| 2008-10-19 22:30:00 | NQ | Futures | 1496.31 | 1498.86 | 1495.46 | 1498.57 | 174.0 |
| 2008-10-19 23:00:00 | NQ | Futures | 1498.57 | 1498.57 | 1496.88 | 1497.44 | 50.0 |
| 2008-10-19 23:30:00 | NQ | Futures | 1498.57 | 1502.54 | 1498.57 | 1502.25 | 131.0 |
| 2008-10-19 18:00:00 | YM | Futures | 8004.7 | 8032.0 | 7912.8 | 7921.9 | 696.0 |
| 2008-10-19 18:30:00 | YM | Futures | 7921.9 | 7980.1 | 7921.9 | 7974.7 | 248.0 |
| 2008-10-19 19:00:00 | YM | Futures | 7969.2 | 8021.0 | 7967.4 | 8001.0 | 288.0 |
| 2008-10-19 19:30:00 | YM | Futures | 7997.4 | 8045.6 | 7990.1 | 8045.6 | 410.0 |
| 2008-10-19 20:00:00 | YM | Futures | 8044.7 | 8045.6 | 7996.5 | 8022.9 | 480.0 |
| 2008-10-19 20:30:00 | YM | Futures | 8022.9 | 8050.2 | 8022.9 | 8048.3 | 362.0 |
| 2008-10-19 21:00:00 | YM | Futures | 8048.3 | 8051.1 | 8025.6 | 8045.6 | 200.0 |
| 2008-10-19 21:30:00 | YM | Futures | 8040.1 | 8043.8 | 7990.1 | 8006.5 | 254.0 |
| 2008-10-19 22:00:00 | YM | Futures | 8010.1 | 8035.6 | 8004.7 | 8025.6 | 205.0 |
| 2008-10-19 22:30:00 | YM | Futures | 8030.1 | 8042.0 | 8018.3 | 8038.3 | 133.0 |
| 2008-10-19 23:00:00 | YM | Futures | 8036.5 | 8042.9 | 8028.3 | 8033.8 | 108.0 |
| 2008-10-19 23:30:00 | YM | Futures | 8033.8 | 8062.9 | 8033.8 | 8052.9 | 248.0 |
| 2008-10-19 18:00:00 | CL | Futures | 272.69 | 275.28 | 269.99 | 271.75 | 193.0 |
| 2008-10-19 18:30:00 | CL | Futures | 271.0 | 272.24 | 271.0 | 271.94 | 68.0 |
| 2008-10-19 19:00:00 | CL | Futures | 272.35 | 273.37 | 271.56 | 272.65 | 94.0 |
| 2008-10-19 19:30:00 | CL | Futures | 272.8 | 274.08 | 272.35 | 274.08 | 47.0 |
| 2008-10-19 20:00:00 | CL | Futures | 273.74 | 274.19 | 273.52 | 273.82 | 176.0 |
| 2008-10-19 20:30:00 | CL | Futures | 274.04 | 274.45 | 273.82 | 274.23 | 69.0 |
| 2008-10-19 21:00:00 | CL | Futures | 274.19 | 274.45 | 274.0 | 274.34 | 56.0 |
| 2008-10-19 21:30:00 | CL | Futures | 274.49 | 274.49 | 273.82 | 274.0 | 60.0 |
| 2008-10-19 22:00:00 | CL | Futures | 274.27 | 274.64 | 273.97 | 274.53 | 47.0 |
| 2008-10-19 22:30:00 | CL | Futures | 274.15 | 275.02 | 274.15 | 274.45 | 108.0 |
| 2008-10-19 23:00:00 | CL | Futures | 274.49 | 275.05 | 274.49 | 274.87 | 78.0 |
| 2008-10-19 23:30:00 | CL | Futures | 274.87 | 276.14 | 274.87 | 275.92 | 225.0 |
| 2008-10-19 18:00:00 | GC | Futures | 1119.8 | 1126.2 | 1117.2 | 1121.9 | 262.0 |
| 2008-10-19 18:30:00 | GC | Futures | 1123.1 | 1124.2 | 1122.1 | 1124.2 | 47.0 |
> showing 50 of 413 rows — these rows as CSV