PREVIEW / futures_30min / 2008-09-23
file: by_date/futures_30min/2008/2008-09-23.parquet size: 70 KB rows: 2,265
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-23 00:00:00 | ES | Futures | 1153.43 | 1153.9 | 1152.96 | 1153.19 | 1617.0 |
| 2008-09-23 00:30:00 | ES | Futures | 1153.19 | 1153.19 | 1152.01 | 1152.25 | 726.0 |
| 2008-09-23 01:00:00 | ES | Futures | 1152.25 | 1153.19 | 1152.01 | 1152.72 | 419.0 |
| 2008-09-23 01:30:00 | ES | Futures | 1152.72 | 1152.72 | 1151.77 | 1152.48 | 1135.0 |
| 2008-09-23 02:00:00 | ES | Futures | 1152.48 | 1153.19 | 1151.54 | 1152.48 | 2556.0 |
| 2008-09-23 02:30:00 | ES | Futures | 1152.48 | 1153.67 | 1150.83 | 1153.67 | 4651.0 |
| 2008-09-23 03:00:00 | ES | Futures | 1153.67 | 1154.38 | 1151.06 | 1151.54 | 10326.0 |
| 2008-09-23 03:30:00 | ES | Futures | 1151.3 | 1153.9 | 1149.17 | 1152.01 | 8597.0 |
| 2008-09-23 04:00:00 | ES | Futures | 1152.01 | 1152.72 | 1149.64 | 1151.06 | 7100.0 |
| 2008-09-23 04:30:00 | ES | Futures | 1151.06 | 1152.01 | 1146.8 | 1147.04 | 9167.0 |
| 2008-09-23 05:00:00 | ES | Futures | 1147.28 | 1148.22 | 1145.62 | 1146.09 | 10159.0 |
| 2008-09-23 05:30:00 | ES | Futures | 1146.09 | 1149.64 | 1145.38 | 1149.17 | 7823.0 |
| 2008-09-23 06:00:00 | ES | Futures | 1148.93 | 1149.41 | 1147.51 | 1148.46 | 4037.0 |
| 2008-09-23 06:30:00 | ES | Futures | 1148.46 | 1148.7 | 1144.44 | 1146.33 | 10997.0 |
| 2008-09-23 07:00:00 | ES | Futures | 1146.33 | 1148.22 | 1143.73 | 1146.33 | 12152.0 |
| 2008-09-23 07:30:00 | ES | Futures | 1146.33 | 1149.64 | 1143.25 | 1144.67 | 22508.0 |
| 2008-09-23 08:00:00 | ES | Futures | 1144.67 | 1145.86 | 1142.07 | 1143.96 | 21585.0 |
| 2008-09-23 08:30:00 | ES | Futures | 1144.2 | 1149.17 | 1143.49 | 1146.33 | 30853.0 |
| 2008-09-23 09:00:00 | ES | Futures | 1146.57 | 1148.7 | 1144.91 | 1145.86 | 33423.0 |
| 2008-09-23 09:30:00 | ES | Futures | 1146.09 | 1157.45 | 1142.78 | 1150.83 | 284319.0 |
| 2008-09-23 10:00:00 | ES | Futures | 1150.83 | 1157.22 | 1148.93 | 1154.14 | 197161.0 |
| 2008-09-23 10:30:00 | ES | Futures | 1154.14 | 1156.27 | 1143.49 | 1145.62 | 203210.0 |
| 2008-09-23 11:00:00 | ES | Futures | 1145.62 | 1151.54 | 1142.07 | 1148.46 | 214739.0 |
| 2008-09-23 11:30:00 | ES | Futures | 1148.46 | 1150.35 | 1144.44 | 1144.91 | 103601.0 |
| 2008-09-23 12:00:00 | ES | Futures | 1144.91 | 1148.46 | 1141.36 | 1143.25 | 111417.0 |
| 2008-09-23 12:30:00 | ES | Futures | 1143.25 | 1143.96 | 1136.63 | 1137.1 | 148813.0 |
| 2008-09-23 13:00:00 | ES | Futures | 1137.1 | 1137.57 | 1126.69 | 1129.53 | 253362.0 |
| 2008-09-23 13:30:00 | ES | Futures | 1129.53 | 1129.77 | 1123.38 | 1128.58 | 222207.0 |
| 2008-09-23 14:00:00 | ES | Futures | 1128.82 | 1139.23 | 1124.8 | 1138.52 | 269096.0 |
| 2008-09-23 14:30:00 | ES | Futures | 1138.52 | 1145.38 | 1134.5 | 1140.41 | 229315.0 |
| 2008-09-23 15:00:00 | ES | Futures | 1140.18 | 1149.64 | 1139.94 | 1141.6 | 188465.0 |
| 2008-09-23 15:30:00 | ES | Futures | 1141.83 | 1143.49 | 1124.09 | 1125.51 | 333499.0 |
| 2008-09-23 16:00:00 | ES | Futures | 1125.51 | 1125.74 | 1122.19 | 1123.85 | 108221.0 |
| 2008-09-23 16:30:00 | ES | Futures | 1124.56 | 1126.69 | 1124.56 | 1126.45 | 10050.0 |
| 2008-09-23 17:00:00 | ES | Futures | 1126.69 | 1126.93 | 1125.74 | 1126.93 | 2940.0 |
| 2008-09-23 18:00:00 | ES | Futures | 1135.21 | 1145.62 | 1134.97 | 1142.07 | 47067.0 |
| 2008-09-23 18:30:00 | ES | Futures | 1141.6 | 1142.54 | 1138.05 | 1138.52 | 7162.0 |
| 2008-09-23 19:00:00 | ES | Futures | 1138.76 | 1140.65 | 1137.1 | 1137.81 | 4110.0 |
| 2008-09-23 19:30:00 | ES | Futures | 1137.81 | 1138.52 | 1133.79 | 1138.52 | 6197.0 |
| 2008-09-23 20:00:00 | ES | Futures | 1138.28 | 1138.99 | 1133.79 | 1134.5 | 5282.0 |
| 2008-09-23 20:30:00 | ES | Futures | 1134.26 | 1135.92 | 1133.32 | 1135.44 | 2983.0 |
| 2008-09-23 21:00:00 | ES | Futures | 1135.21 | 1135.92 | 1133.55 | 1133.79 | 2815.0 |
| 2008-09-23 21:30:00 | ES | Futures | 1133.79 | 1138.99 | 1133.32 | 1138.05 | 4776.0 |
| 2008-09-23 22:00:00 | ES | Futures | 1137.81 | 1139.7 | 1137.34 | 1139.7 | 2956.0 |
| 2008-09-23 22:30:00 | ES | Futures | 1139.47 | 1139.7 | 1138.28 | 1139.23 | 1370.0 |
| 2008-09-23 23:00:00 | ES | Futures | 1139.47 | 1139.7 | 1137.34 | 1138.05 | 971.0 |
| 2008-09-23 23:30:00 | ES | Futures | 1138.05 | 1138.99 | 1138.05 | 1138.28 | 683.0 |
| 2008-09-23 00:00:00 | NQ | Futures | 1900.1 | 1904.06 | 1900.1 | 1902.65 | 420.0 |
| 2008-09-23 00:30:00 | NQ | Futures | 1902.65 | 1902.65 | 1899.82 | 1899.82 | 78.0 |
| 2008-09-23 01:00:00 | NQ | Futures | 1900.38 | 1902.08 | 1899.53 | 1901.51 | 34.0 |
> showing 50 of 2,265 rows — these rows as CSV