PREVIEW / futures_30min / 2008-09-25
file: by_date/futures_30min/2008/2008-09-25.parquet size: 68 KB rows: 2,223
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-25 00:00:00 | ES | Futures | 1129.53 | 1129.77 | 1127.87 | 1127.87 | 786.0 |
| 2008-09-25 00:30:00 | ES | Futures | 1128.11 | 1129.53 | 1127.87 | 1129.29 | 704.0 |
| 2008-09-25 01:00:00 | ES | Futures | 1129.53 | 1129.53 | 1128.11 | 1129.53 | 977.0 |
| 2008-09-25 01:30:00 | ES | Futures | 1129.53 | 1129.53 | 1127.4 | 1128.11 | 1208.0 |
| 2008-09-25 02:00:00 | ES | Futures | 1128.35 | 1128.35 | 1125.51 | 1125.74 | 4508.0 |
| 2008-09-25 02:30:00 | ES | Futures | 1125.74 | 1127.4 | 1125.51 | 1126.93 | 2241.0 |
| 2008-09-25 03:00:00 | ES | Futures | 1126.93 | 1128.11 | 1125.03 | 1126.69 | 5985.0 |
| 2008-09-25 03:30:00 | ES | Futures | 1126.45 | 1128.35 | 1125.98 | 1127.87 | 5480.0 |
| 2008-09-25 04:00:00 | ES | Futures | 1128.11 | 1129.53 | 1127.4 | 1128.35 | 6763.0 |
| 2008-09-25 04:30:00 | ES | Futures | 1128.35 | 1134.5 | 1128.35 | 1133.55 | 8454.0 |
| 2008-09-25 05:00:00 | ES | Futures | 1133.32 | 1138.52 | 1132.61 | 1136.39 | 15506.0 |
| 2008-09-25 05:30:00 | ES | Futures | 1136.15 | 1139.23 | 1134.5 | 1135.44 | 10383.0 |
| 2008-09-25 06:00:00 | ES | Futures | 1135.44 | 1138.28 | 1134.97 | 1136.63 | 5131.0 |
| 2008-09-25 06:30:00 | ES | Futures | 1136.63 | 1136.86 | 1129.77 | 1129.77 | 28644.0 |
| 2008-09-25 07:00:00 | ES | Futures | 1129.77 | 1131.19 | 1127.64 | 1129.29 | 13591.0 |
| 2008-09-25 07:30:00 | ES | Futures | 1129.29 | 1131.42 | 1125.03 | 1130.95 | 27151.0 |
| 2008-09-25 08:00:00 | ES | Futures | 1130.95 | 1142.31 | 1130.95 | 1138.28 | 68814.0 |
| 2008-09-25 08:30:00 | ES | Futures | 1138.05 | 1140.65 | 1134.03 | 1134.5 | 61386.0 |
| 2008-09-25 09:00:00 | ES | Futures | 1134.5 | 1137.34 | 1130.95 | 1134.5 | 46502.0 |
| 2008-09-25 09:30:00 | ES | Futures | 1134.74 | 1144.67 | 1130.0 | 1141.6 | 275579.0 |
| 2008-09-25 10:00:00 | ES | Futures | 1141.6 | 1151.77 | 1139.47 | 1147.75 | 281621.0 |
| 2008-09-25 10:30:00 | ES | Futures | 1147.75 | 1149.17 | 1141.6 | 1143.96 | 151776.0 |
| 2008-09-25 11:00:00 | ES | Futures | 1144.2 | 1152.48 | 1143.02 | 1151.06 | 161851.0 |
| 2008-09-25 11:30:00 | ES | Futures | 1151.3 | 1152.96 | 1147.28 | 1148.22 | 143809.0 |
| 2008-09-25 12:00:00 | ES | Futures | 1148.22 | 1153.67 | 1147.51 | 1152.25 | 98970.0 |
| 2008-09-25 12:30:00 | ES | Futures | 1152.25 | 1156.51 | 1151.3 | 1153.9 | 134040.0 |
| 2008-09-25 13:00:00 | ES | Futures | 1154.14 | 1159.11 | 1151.77 | 1154.14 | 148679.0 |
| 2008-09-25 13:30:00 | ES | Futures | 1154.38 | 1159.35 | 1152.01 | 1156.03 | 163116.0 |
| 2008-09-25 14:00:00 | ES | Futures | 1155.8 | 1156.74 | 1146.33 | 1149.64 | 172942.0 |
| 2008-09-25 14:30:00 | ES | Futures | 1149.64 | 1152.48 | 1145.62 | 1152.01 | 128242.0 |
| 2008-09-25 15:00:00 | ES | Futures | 1152.01 | 1158.4 | 1151.06 | 1156.27 | 140103.0 |
| 2008-09-25 15:30:00 | ES | Futures | 1156.27 | 1158.16 | 1143.73 | 1151.3 | 268660.0 |
| 2008-09-25 16:00:00 | ES | Futures | 1151.3 | 1151.77 | 1148.22 | 1149.64 | 91765.0 |
| 2008-09-25 16:30:00 | ES | Futures | 1147.51 | 1156.03 | 1146.33 | 1147.04 | 14192.0 |
| 2008-09-25 17:00:00 | ES | Futures | 1147.04 | 1151.54 | 1142.54 | 1150.83 | 16696.0 |
| 2008-09-25 18:00:00 | ES | Futures | 1147.51 | 1147.75 | 1144.67 | 1145.86 | 5242.0 |
| 2008-09-25 18:30:00 | ES | Futures | 1145.62 | 1150.12 | 1145.38 | 1146.33 | 4981.0 |
| 2008-09-25 19:00:00 | ES | Futures | 1146.57 | 1147.75 | 1140.89 | 1141.36 | 9577.0 |
| 2008-09-25 19:30:00 | ES | Futures | 1141.36 | 1143.02 | 1138.28 | 1138.99 | 10802.0 |
| 2008-09-25 20:00:00 | ES | Futures | 1138.99 | 1140.89 | 1134.26 | 1135.92 | 11135.0 |
| 2008-09-25 20:30:00 | ES | Futures | 1135.68 | 1137.81 | 1132.84 | 1136.15 | 8187.0 |
| 2008-09-25 21:00:00 | ES | Futures | 1136.15 | 1137.57 | 1132.84 | 1135.21 | 5518.0 |
| 2008-09-25 21:30:00 | ES | Futures | 1135.21 | 1137.81 | 1133.55 | 1136.39 | 4462.0 |
| 2008-09-25 22:00:00 | ES | Futures | 1136.15 | 1136.86 | 1132.13 | 1133.79 | 4633.0 |
| 2008-09-25 22:30:00 | ES | Futures | 1133.79 | 1134.26 | 1132.37 | 1133.08 | 3128.0 |
| 2008-09-25 23:00:00 | ES | Futures | 1133.32 | 1133.79 | 1131.66 | 1131.66 | 3920.0 |
| 2008-09-25 23:30:00 | ES | Futures | 1131.66 | 1131.9 | 1128.11 | 1130.0 | 7111.0 |
| 2008-09-25 00:00:00 | NQ | Futures | 1891.61 | 1892.18 | 1889.35 | 1889.35 | 78.0 |
| 2008-09-25 00:30:00 | NQ | Futures | 1889.91 | 1892.18 | 1889.91 | 1892.18 | 3.0 |
| 2008-09-25 01:00:00 | NQ | Futures | 1892.18 | 1892.18 | 1891.04 | 1891.61 | 20.0 |
> showing 50 of 2,223 rows — these rows as CSV