PREVIEW / futures_30min / 2008-03-14
file: by_date/futures_30min/2008/2008-03-14.parquet size: 59 KB rows: 1,839
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-14 00:00:00 | ES | Futures | 1216.14 | 1216.84 | 1213.35 | 1214.28 | 4898.0 |
| 2008-03-14 00:30:00 | ES | Futures | 1214.28 | 1216.38 | 1214.05 | 1215.91 | 937.0 |
| 2008-03-14 01:00:00 | ES | Futures | 1215.68 | 1217.54 | 1213.35 | 1213.81 | 1680.0 |
| 2008-03-14 01:30:00 | ES | Futures | 1213.81 | 1215.91 | 1212.65 | 1215.44 | 1629.0 |
| 2008-03-14 02:00:00 | ES | Futures | 1215.44 | 1217.77 | 1214.98 | 1217.54 | 1097.0 |
| 2008-03-14 02:30:00 | ES | Futures | 1217.54 | 1219.17 | 1217.07 | 1218.94 | 674.0 |
| 2008-03-14 03:00:00 | ES | Futures | 1218.94 | 1219.64 | 1218.01 | 1219.4 | 2205.0 |
| 2008-03-14 03:30:00 | ES | Futures | 1219.4 | 1220.57 | 1216.84 | 1217.07 | 2992.0 |
| 2008-03-14 04:00:00 | ES | Futures | 1217.31 | 1219.4 | 1216.14 | 1217.77 | 4717.0 |
| 2008-03-14 04:30:00 | ES | Futures | 1217.54 | 1222.43 | 1216.38 | 1222.2 | 6465.0 |
| 2008-03-14 05:00:00 | ES | Futures | 1222.2 | 1223.59 | 1220.33 | 1222.66 | 3936.0 |
| 2008-03-14 05:30:00 | ES | Futures | 1222.66 | 1223.83 | 1221.96 | 1223.13 | 4710.0 |
| 2008-03-14 06:00:00 | ES | Futures | 1223.36 | 1223.59 | 1221.96 | 1223.13 | 4149.0 |
| 2008-03-14 06:30:00 | ES | Futures | 1223.36 | 1224.29 | 1220.8 | 1221.03 | 4537.0 |
| 2008-03-14 07:00:00 | ES | Futures | 1221.03 | 1221.03 | 1216.14 | 1217.07 | 14141.0 |
| 2008-03-14 07:30:00 | ES | Futures | 1216.84 | 1218.94 | 1214.75 | 1218.01 | 19107.0 |
| 2008-03-14 08:00:00 | ES | Futures | 1218.01 | 1220.33 | 1216.84 | 1220.33 | 25190.0 |
| 2008-03-14 08:30:00 | ES | Futures | 1220.57 | 1236.4 | 1220.57 | 1233.84 | 128082.0 |
| 2008-03-14 09:00:00 | ES | Futures | 1233.84 | 1244.32 | 1233.61 | 1234.77 | 151323.0 |
| 2008-03-14 09:30:00 | ES | Futures | 1235.0 | 1235.47 | 1203.34 | 1203.57 | 493221.0 |
| 2008-03-14 10:00:00 | ES | Futures | 1203.8 | 1217.31 | 1191.46 | 1207.76 | 430028.0 |
| 2008-03-14 10:30:00 | ES | Futures | 1207.76 | 1212.42 | 1197.75 | 1208.92 | 185562.0 |
| 2008-03-14 11:00:00 | ES | Futures | 1208.92 | 1211.72 | 1201.47 | 1203.8 | 158155.0 |
| 2008-03-14 11:30:00 | ES | Futures | 1203.8 | 1213.58 | 1201.94 | 1205.9 | 155149.0 |
| 2008-03-14 12:00:00 | ES | Futures | 1205.66 | 1209.39 | 1204.03 | 1206.36 | 91566.0 |
| 2008-03-14 12:30:00 | ES | Futures | 1206.13 | 1208.69 | 1198.91 | 1202.87 | 165133.0 |
| 2008-03-14 13:00:00 | ES | Futures | 1202.87 | 1203.1 | 1196.58 | 1198.68 | 141953.0 |
| 2008-03-14 13:30:00 | ES | Futures | 1198.91 | 1203.8 | 1196.12 | 1197.52 | 110468.0 |
| 2008-03-14 14:00:00 | ES | Futures | 1197.28 | 1200.08 | 1189.13 | 1191.0 | 182376.0 |
| 2008-03-14 14:30:00 | ES | Futures | 1191.0 | 1199.38 | 1187.97 | 1194.02 | 203381.0 |
| 2008-03-14 15:00:00 | ES | Futures | 1194.26 | 1211.95 | 1192.39 | 1207.99 | 230254.0 |
| 2008-03-14 15:30:00 | ES | Futures | 1207.99 | 1209.39 | 1195.89 | 1201.71 | 313482.0 |
| 2008-03-14 16:00:00 | ES | Futures | 1201.71 | 1204.97 | 1197.98 | 1203.8 | 110723.0 |
| 2008-03-14 00:00:00 | NQ | Futures | 1977.25 | 1980.65 | 1973.86 | 1974.14 | 395.0 |
| 2008-03-14 00:30:00 | NQ | Futures | 1974.14 | 1977.25 | 1974.14 | 1976.69 | 79.0 |
| 2008-03-14 01:00:00 | NQ | Futures | 1976.97 | 1978.95 | 1972.16 | 1973.86 | 128.0 |
| 2008-03-14 01:30:00 | NQ | Futures | 1973.86 | 1974.99 | 1970.18 | 1974.43 | 161.0 |
| 2008-03-14 02:00:00 | NQ | Futures | 1974.14 | 1977.54 | 1974.14 | 1977.54 | 163.0 |
| 2008-03-14 02:30:00 | NQ | Futures | 1977.82 | 1979.23 | 1977.54 | 1979.23 | 61.0 |
| 2008-03-14 03:00:00 | NQ | Futures | 1979.8 | 1979.8 | 1976.69 | 1979.23 | 232.0 |
| 2008-03-14 03:30:00 | NQ | Futures | 1979.23 | 1979.8 | 1975.84 | 1976.12 | 170.0 |
| 2008-03-14 04:00:00 | NQ | Futures | 1977.25 | 1979.8 | 1974.71 | 1976.97 | 317.0 |
| 2008-03-14 04:30:00 | NQ | Futures | 1977.54 | 1984.33 | 1974.71 | 1984.04 | 464.0 |
| 2008-03-14 05:00:00 | NQ | Futures | 1983.76 | 1986.02 | 1982.06 | 1985.46 | 367.0 |
| 2008-03-14 05:30:00 | NQ | Futures | 1984.89 | 1986.59 | 1984.33 | 1985.74 | 283.0 |
| 2008-03-14 06:00:00 | NQ | Futures | 1986.02 | 1986.87 | 1983.48 | 1986.59 | 493.0 |
| 2008-03-14 06:30:00 | NQ | Futures | 1986.59 | 1987.72 | 1981.78 | 1981.78 | 322.0 |
| 2008-03-14 07:00:00 | NQ | Futures | 1981.78 | 1982.06 | 1976.69 | 1978.39 | 595.0 |
| 2008-03-14 07:30:00 | NQ | Futures | 1978.1 | 1979.52 | 1973.58 | 1978.1 | 1520.0 |
| 2008-03-14 08:00:00 | NQ | Futures | 1978.39 | 1988.85 | 1976.69 | 1984.89 | 3891.0 |
> showing 50 of 1,839 rows — these rows as CSV