PREVIEW / futures_30min / 2008-09-21
file: by_date/futures_30min/2008/2008-09-21.parquet size: 18 KB rows: 404
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-09-21 18:00:00 | ES | Futures | 1177.57 | 1178.04 | 1159.58 | 1163.84 | 32919.0 |
| 2008-09-21 18:30:00 | ES | Futures | 1163.84 | 1166.21 | 1160.53 | 1161.48 | 15826.0 |
| 2008-09-21 19:00:00 | ES | Futures | 1161.24 | 1167.63 | 1158.16 | 1167.63 | 13559.0 |
| 2008-09-21 19:30:00 | ES | Futures | 1167.16 | 1173.07 | 1165.26 | 1171.42 | 9424.0 |
| 2008-09-21 20:00:00 | ES | Futures | 1171.65 | 1173.31 | 1166.68 | 1169.76 | 6464.0 |
| 2008-09-21 20:30:00 | ES | Futures | 1169.52 | 1171.18 | 1166.92 | 1169.76 | 4582.0 |
| 2008-09-21 21:00:00 | ES | Futures | 1170.0 | 1170.0 | 1165.5 | 1169.05 | 4610.0 |
| 2008-09-21 21:30:00 | ES | Futures | 1169.05 | 1172.84 | 1169.05 | 1169.76 | 6480.0 |
| 2008-09-21 22:00:00 | ES | Futures | 1170.0 | 1170.0 | 1168.1 | 1168.81 | 4135.0 |
| 2008-09-21 22:30:00 | ES | Futures | 1169.05 | 1170.71 | 1168.34 | 1170.71 | 1884.0 |
| 2008-09-21 23:00:00 | ES | Futures | 1170.71 | 1170.71 | 1169.05 | 1170.47 | 1026.0 |
| 2008-09-21 23:30:00 | ES | Futures | 1170.47 | 1172.13 | 1170.23 | 1171.42 | 973.0 |
| 2008-09-21 18:00:00 | NQ | Futures | 1963.77 | 1963.77 | 1948.2 | 1949.05 | 2316.0 |
| 2008-09-21 18:30:00 | NQ | Futures | 1950.47 | 1951.88 | 1938.86 | 1939.71 | 828.0 |
| 2008-09-21 19:00:00 | NQ | Futures | 1939.15 | 1946.51 | 1930.38 | 1946.51 | 957.0 |
| 2008-09-21 19:30:00 | NQ | Futures | 1945.94 | 1956.41 | 1944.52 | 1956.41 | 592.0 |
| 2008-09-21 20:00:00 | NQ | Futures | 1956.41 | 1957.54 | 1948.49 | 1954.15 | 223.0 |
| 2008-09-21 20:30:00 | NQ | Futures | 1954.15 | 1956.13 | 1950.75 | 1954.99 | 124.0 |
| 2008-09-21 21:00:00 | NQ | Futures | 1953.58 | 1954.71 | 1947.07 | 1952.45 | 393.0 |
| 2008-09-21 21:30:00 | NQ | Futures | 1954.15 | 1959.24 | 1953.01 | 1956.13 | 868.0 |
| 2008-09-21 22:00:00 | NQ | Futures | 1956.13 | 1956.13 | 1953.01 | 1953.58 | 164.0 |
| 2008-09-21 22:30:00 | NQ | Futures | 1953.01 | 1956.69 | 1952.45 | 1956.69 | 138.0 |
| 2008-09-21 23:00:00 | NQ | Futures | 1956.69 | 1956.69 | 1953.86 | 1955.56 | 153.0 |
| 2008-09-21 23:30:00 | NQ | Futures | 1955.56 | 1957.54 | 1953.58 | 1955.28 | 160.0 |
| 2008-09-21 18:00:00 | YM | Futures | 10301.2 | 10304.8 | 10156.6 | 10184.8 | 1530.0 |
| 2008-09-21 18:30:00 | YM | Futures | 10183.0 | 10208.4 | 10163.9 | 10163.9 | 805.0 |
| 2008-09-21 19:00:00 | YM | Futures | 10163.9 | 10204.8 | 10141.1 | 10204.8 | 690.0 |
| 2008-09-21 19:30:00 | YM | Futures | 10208.4 | 10253.0 | 10187.5 | 10238.5 | 618.0 |
| 2008-09-21 20:00:00 | YM | Futures | 10234.8 | 10241.2 | 10196.6 | 10218.4 | 323.0 |
| 2008-09-21 20:30:00 | YM | Futures | 10217.5 | 10236.6 | 10199.3 | 10229.4 | 208.0 |
| 2008-09-21 21:00:00 | YM | Futures | 10227.5 | 10227.5 | 10197.5 | 10223.0 | 321.0 |
| 2008-09-21 21:30:00 | YM | Futures | 10221.2 | 10250.3 | 10221.2 | 10230.3 | 463.0 |
| 2008-09-21 22:00:00 | YM | Futures | 10228.4 | 10230.3 | 10211.2 | 10222.1 | 204.0 |
| 2008-09-21 22:30:00 | YM | Futures | 10224.8 | 10241.2 | 10219.4 | 10241.2 | 85.0 |
| 2008-09-21 23:00:00 | YM | Futures | 10237.5 | 10237.5 | 10223.9 | 10234.8 | 78.0 |
| 2008-09-21 23:30:00 | YM | Futures | 10238.5 | 10243.9 | 10233.9 | 10240.3 | 91.0 |
| 2008-09-21 18:00:00 | CL | Futures | 386.52 | 388.1 | 386.06 | 386.06 | 213.0 |
| 2008-09-21 18:30:00 | CL | Futures | 386.33 | 387.19 | 385.01 | 385.01 | 304.0 |
| 2008-09-21 19:00:00 | CL | Futures | 385.01 | 385.69 | 384.63 | 385.38 | 198.0 |
| 2008-09-21 19:30:00 | CL | Futures | 385.27 | 386.4 | 385.16 | 386.21 | 291.0 |
| 2008-09-21 20:00:00 | CL | Futures | 386.4 | 392.25 | 386.21 | 391.53 | 740.0 |
| 2008-09-21 20:30:00 | CL | Futures | 391.83 | 391.95 | 391.31 | 391.31 | 350.0 |
| 2008-09-21 21:00:00 | CL | Futures | 391.31 | 391.31 | 387.87 | 387.95 | 620.0 |
| 2008-09-21 21:30:00 | CL | Futures | 387.95 | 389.83 | 387.8 | 389.8 | 175.0 |
| 2008-09-21 22:00:00 | CL | Futures | 389.42 | 390.48 | 389.23 | 390.06 | 126.0 |
| 2008-09-21 22:30:00 | CL | Futures | 390.02 | 390.02 | 389.04 | 389.12 | 280.0 |
| 2008-09-21 23:00:00 | CL | Futures | 389.12 | 389.68 | 389.04 | 389.31 | 119.0 |
| 2008-09-21 23:30:00 | CL | Futures | 389.46 | 391.49 | 389.46 | 391.46 | 279.0 |
| 2008-09-21 18:00:00 | GC | Futures | 1248.2 | 1260.8 | 1248.2 | 1258.8 | 1000.0 |
| 2008-09-21 18:30:00 | GC | Futures | 1258.7 | 1266.4 | 1257.1 | 1258.2 | 986.0 |
> showing 50 of 404 rows — these rows as CSV