PREVIEW / futures_30min / 2008-03-20
file: by_date/futures_30min/2008/2008-03-20.parquet size: 60 KB rows: 1,854
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-20 00:00:00 | ES | Futures | 1202.64 | 1204.03 | 1202.64 | 1203.34 | 519.0 |
| 2008-03-20 00:30:00 | ES | Futures | 1203.57 | 1204.03 | 1203.34 | 1203.57 | 323.0 |
| 2008-03-20 01:00:00 | ES | Futures | 1203.57 | 1206.6 | 1203.57 | 1206.36 | 1959.0 |
| 2008-03-20 01:30:00 | ES | Futures | 1206.6 | 1207.06 | 1205.2 | 1206.6 | 1836.0 |
| 2008-03-20 02:00:00 | ES | Futures | 1206.36 | 1206.83 | 1204.27 | 1205.2 | 1188.0 |
| 2008-03-20 02:30:00 | ES | Futures | 1204.97 | 1207.99 | 1204.97 | 1207.76 | 3975.0 |
| 2008-03-20 03:00:00 | ES | Futures | 1207.76 | 1209.62 | 1207.29 | 1207.76 | 5451.0 |
| 2008-03-20 03:30:00 | ES | Futures | 1207.76 | 1208.23 | 1206.83 | 1207.99 | 4249.0 |
| 2008-03-20 04:00:00 | ES | Futures | 1208.23 | 1211.95 | 1207.76 | 1210.32 | 19809.0 |
| 2008-03-20 04:30:00 | ES | Futures | 1210.32 | 1212.18 | 1209.62 | 1211.49 | 16766.0 |
| 2008-03-20 05:00:00 | ES | Futures | 1211.49 | 1213.35 | 1211.25 | 1213.12 | 12695.0 |
| 2008-03-20 05:30:00 | ES | Futures | 1213.12 | 1218.01 | 1212.65 | 1215.91 | 19895.0 |
| 2008-03-20 06:00:00 | ES | Futures | 1215.91 | 1218.01 | 1215.91 | 1216.61 | 11473.0 |
| 2008-03-20 06:30:00 | ES | Futures | 1216.61 | 1217.54 | 1212.65 | 1213.12 | 13354.0 |
| 2008-03-20 07:00:00 | ES | Futures | 1213.35 | 1214.75 | 1212.18 | 1213.58 | 11983.0 |
| 2008-03-20 07:30:00 | ES | Futures | 1213.35 | 1217.77 | 1213.12 | 1216.14 | 21352.0 |
| 2008-03-20 08:00:00 | ES | Futures | 1216.14 | 1216.61 | 1214.05 | 1214.05 | 22509.0 |
| 2008-03-20 08:30:00 | ES | Futures | 1214.05 | 1215.91 | 1207.06 | 1207.99 | 64595.0 |
| 2008-03-20 09:00:00 | ES | Futures | 1207.99 | 1215.21 | 1207.53 | 1214.05 | 50611.0 |
| 2008-03-20 09:30:00 | ES | Futures | 1214.05 | 1215.68 | 1206.6 | 1214.05 | 237433.0 |
| 2008-03-20 10:00:00 | ES | Futures | 1214.05 | 1222.2 | 1213.58 | 1220.1 | 210001.0 |
| 2008-03-20 10:30:00 | ES | Futures | 1220.1 | 1224.99 | 1218.01 | 1224.76 | 151215.0 |
| 2008-03-20 11:00:00 | ES | Futures | 1224.53 | 1226.62 | 1221.96 | 1225.92 | 118608.0 |
| 2008-03-20 11:30:00 | ES | Futures | 1225.92 | 1226.39 | 1218.24 | 1219.17 | 139306.0 |
| 2008-03-20 12:00:00 | ES | Futures | 1218.94 | 1224.99 | 1218.94 | 1219.87 | 110084.0 |
| 2008-03-20 12:30:00 | ES | Futures | 1219.87 | 1221.73 | 1216.61 | 1219.17 | 74597.0 |
| 2008-03-20 13:00:00 | ES | Futures | 1218.94 | 1224.06 | 1218.94 | 1223.83 | 48180.0 |
| 2008-03-20 13:30:00 | ES | Futures | 1223.83 | 1228.72 | 1223.13 | 1227.78 | 82594.0 |
| 2008-03-20 14:00:00 | ES | Futures | 1227.78 | 1230.35 | 1226.15 | 1229.88 | 93142.0 |
| 2008-03-20 14:30:00 | ES | Futures | 1230.11 | 1236.4 | 1229.41 | 1235.7 | 125899.0 |
| 2008-03-20 15:00:00 | ES | Futures | 1235.7 | 1241.06 | 1235.0 | 1236.17 | 113915.0 |
| 2008-03-20 15:30:00 | ES | Futures | 1236.4 | 1240.82 | 1233.37 | 1239.66 | 183380.0 |
| 2008-03-20 16:00:00 | ES | Futures | 1239.43 | 1239.66 | 1232.44 | 1234.07 | 118188.0 |
| 2008-03-20 00:00:00 | NQ | Futures | 1938.22 | 1938.22 | 1938.22 | 1938.22 | 2.0 |
| 2008-03-20 00:30:00 | NQ | Futures | 1938.51 | 1941.05 | 1937.94 | 1940.2 | 69.0 |
| 2008-03-20 01:00:00 | NQ | Futures | 1941.34 | 1945.58 | 1940.2 | 1945.01 | 92.0 |
| 2008-03-20 01:30:00 | NQ | Futures | 1945.58 | 1945.58 | 1943.03 | 1944.73 | 41.0 |
| 2008-03-20 02:00:00 | NQ | Futures | 1944.45 | 1945.58 | 1941.9 | 1944.45 | 35.0 |
| 2008-03-20 02:30:00 | NQ | Futures | 1944.16 | 1950.39 | 1944.16 | 1947.56 | 293.0 |
| 2008-03-20 03:00:00 | NQ | Futures | 1947.56 | 1950.39 | 1946.71 | 1948.69 | 151.0 |
| 2008-03-20 03:30:00 | NQ | Futures | 1946.99 | 1949.25 | 1946.14 | 1947.56 | 164.0 |
| 2008-03-20 04:00:00 | NQ | Futures | 1947.84 | 1955.19 | 1947.28 | 1952.37 | 813.0 |
| 2008-03-20 04:30:00 | NQ | Futures | 1952.37 | 1953.5 | 1950.39 | 1951.8 | 620.0 |
| 2008-03-20 05:00:00 | NQ | Futures | 1952.08 | 1955.76 | 1950.39 | 1952.08 | 498.0 |
| 2008-03-20 05:30:00 | NQ | Futures | 1952.37 | 1959.44 | 1950.1 | 1957.17 | 1113.0 |
| 2008-03-20 06:00:00 | NQ | Futures | 1957.17 | 1960.29 | 1957.17 | 1958.31 | 430.0 |
| 2008-03-20 06:30:00 | NQ | Futures | 1957.74 | 1961.42 | 1954.35 | 1955.76 | 817.0 |
| 2008-03-20 07:00:00 | NQ | Futures | 1955.48 | 1958.02 | 1954.63 | 1956.61 | 545.0 |
| 2008-03-20 07:30:00 | NQ | Futures | 1955.76 | 1961.98 | 1954.63 | 1958.02 | 879.0 |
| 2008-03-20 08:00:00 | NQ | Futures | 1957.17 | 1960.57 | 1954.63 | 1956.89 | 1689.0 |
> showing 50 of 1,854 rows — these rows as CSV