PREVIEW / futures_30min / 2008-07-21
file: by_date/futures_30min/2008/2008-07-21.parquet size: 65 KB rows: 2,204
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-07-21 00:00:00 | ES | Futures | 1173.0 | 1173.23 | 1172.54 | 1172.54 | 277.0 |
| 2008-07-21 00:30:00 | ES | Futures | 1172.54 | 1172.77 | 1172.3 | 1172.54 | 307.0 |
| 2008-07-21 01:00:00 | ES | Futures | 1172.3 | 1173.7 | 1171.84 | 1173.47 | 978.0 |
| 2008-07-21 01:30:00 | ES | Futures | 1173.47 | 1173.7 | 1173.0 | 1173.47 | 683.0 |
| 2008-07-21 02:00:00 | ES | Futures | 1173.47 | 1174.16 | 1173.0 | 1173.0 | 2643.0 |
| 2008-07-21 02:30:00 | ES | Futures | 1173.0 | 1173.0 | 1171.61 | 1171.84 | 2508.0 |
| 2008-07-21 03:00:00 | ES | Futures | 1171.84 | 1171.84 | 1168.58 | 1168.82 | 10225.0 |
| 2008-07-21 03:30:00 | ES | Futures | 1168.58 | 1169.28 | 1167.89 | 1167.89 | 4469.0 |
| 2008-07-21 04:00:00 | ES | Futures | 1167.89 | 1169.98 | 1167.65 | 1169.28 | 5102.0 |
| 2008-07-21 04:30:00 | ES | Futures | 1169.05 | 1170.21 | 1168.58 | 1169.75 | 3300.0 |
| 2008-07-21 05:00:00 | ES | Futures | 1169.51 | 1172.77 | 1169.05 | 1172.3 | 5891.0 |
| 2008-07-21 05:30:00 | ES | Futures | 1172.07 | 1174.63 | 1171.84 | 1173.47 | 6381.0 |
| 2008-07-21 06:00:00 | ES | Futures | 1173.47 | 1176.49 | 1173.23 | 1175.56 | 10438.0 |
| 2008-07-21 06:30:00 | ES | Futures | 1175.56 | 1175.79 | 1173.93 | 1175.32 | 7504.0 |
| 2008-07-21 07:00:00 | ES | Futures | 1175.32 | 1179.74 | 1174.86 | 1177.65 | 40446.0 |
| 2008-07-21 07:30:00 | ES | Futures | 1177.65 | 1178.11 | 1174.39 | 1174.86 | 17921.0 |
| 2008-07-21 08:00:00 | ES | Futures | 1174.86 | 1177.18 | 1174.39 | 1176.95 | 21057.0 |
| 2008-07-21 08:30:00 | ES | Futures | 1176.95 | 1178.11 | 1176.25 | 1177.88 | 19438.0 |
| 2008-07-21 09:00:00 | ES | Futures | 1177.88 | 1178.35 | 1175.79 | 1176.02 | 25821.0 |
| 2008-07-21 09:30:00 | ES | Futures | 1176.25 | 1178.35 | 1174.86 | 1177.42 | 169065.0 |
| 2008-07-21 10:00:00 | ES | Futures | 1177.18 | 1179.04 | 1173.23 | 1173.7 | 160176.0 |
| 2008-07-21 10:30:00 | ES | Futures | 1173.47 | 1175.79 | 1172.07 | 1174.16 | 122434.0 |
| 2008-07-21 11:00:00 | ES | Futures | 1173.93 | 1175.79 | 1172.07 | 1174.39 | 99392.0 |
| 2008-07-21 11:30:00 | ES | Futures | 1174.39 | 1174.86 | 1168.35 | 1168.58 | 100120.0 |
| 2008-07-21 12:00:00 | ES | Futures | 1168.58 | 1171.37 | 1167.65 | 1170.68 | 80089.0 |
| 2008-07-21 12:30:00 | ES | Futures | 1170.68 | 1173.93 | 1170.68 | 1171.37 | 70105.0 |
| 2008-07-21 13:00:00 | ES | Futures | 1171.14 | 1173.93 | 1171.14 | 1172.77 | 51278.0 |
| 2008-07-21 13:30:00 | ES | Futures | 1172.77 | 1174.86 | 1171.61 | 1172.07 | 49622.0 |
| 2008-07-21 14:00:00 | ES | Futures | 1172.07 | 1173.23 | 1169.28 | 1170.21 | 80961.0 |
| 2008-07-21 14:30:00 | ES | Futures | 1169.98 | 1170.91 | 1168.12 | 1169.28 | 71950.0 |
| 2008-07-21 15:00:00 | ES | Futures | 1169.05 | 1171.14 | 1166.73 | 1170.21 | 88719.0 |
| 2008-07-21 15:30:00 | ES | Futures | 1169.98 | 1171.61 | 1168.35 | 1171.14 | 120835.0 |
| 2008-07-21 16:00:00 | ES | Futures | 1171.14 | 1173.47 | 1170.91 | 1172.77 | 62441.0 |
| 2008-07-21 16:30:00 | ES | Futures | 1169.51 | 1169.98 | 1161.84 | 1162.08 | 45862.0 |
| 2008-07-21 17:00:00 | ES | Futures | 1162.08 | 1162.77 | 1161.15 | 1161.15 | 5356.0 |
| 2008-07-21 18:00:00 | ES | Futures | 1161.15 | 1161.61 | 1160.68 | 1161.15 | 3303.0 |
| 2008-07-21 18:30:00 | ES | Futures | 1161.15 | 1161.61 | 1160.91 | 1160.91 | 1123.0 |
| 2008-07-21 19:00:00 | ES | Futures | 1160.68 | 1161.61 | 1160.45 | 1161.15 | 875.0 |
| 2008-07-21 19:30:00 | ES | Futures | 1160.91 | 1162.08 | 1160.68 | 1161.84 | 1295.0 |
| 2008-07-21 20:00:00 | ES | Futures | 1161.84 | 1162.31 | 1161.38 | 1161.84 | 1091.0 |
| 2008-07-21 20:30:00 | ES | Futures | 1162.08 | 1162.08 | 1161.38 | 1161.84 | 832.0 |
| 2008-07-21 21:00:00 | ES | Futures | 1162.08 | 1162.08 | 1161.38 | 1161.38 | 490.0 |
| 2008-07-21 21:30:00 | ES | Futures | 1161.61 | 1161.84 | 1161.38 | 1161.84 | 323.0 |
| 2008-07-21 22:00:00 | ES | Futures | 1161.84 | 1162.77 | 1161.84 | 1162.08 | 1266.0 |
| 2008-07-21 22:30:00 | ES | Futures | 1162.08 | 1162.77 | 1161.84 | 1162.77 | 737.0 |
| 2008-07-21 23:00:00 | ES | Futures | 1162.77 | 1163.01 | 1162.31 | 1162.31 | 364.0 |
| 2008-07-21 23:30:00 | ES | Futures | 1162.31 | 1162.31 | 1161.38 | 1162.08 | 941.0 |
| 2008-07-21 00:00:00 | NQ | Futures | 2058.47 | 2059.03 | 2057.91 | 2057.91 | 9.0 |
| 2008-07-21 00:30:00 | NQ | Futures | 2057.63 | 2057.91 | 2056.5 | 2057.91 | 17.0 |
| 2008-07-21 01:00:00 | NQ | Futures | 2058.19 | 2058.75 | 2058.19 | 2058.75 | 3.0 |
> showing 50 of 2,204 rows — these rows as CSV