PREVIEW / futures_30min / 2010-11-03
file: by_date/futures_30min/2010/2010-11-03.parquet size: 75 KB rows: 2,643
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-03 00:00:00 | ES | Futures | 1175.95 | 1176.94 | 1175.7 | 1175.95 | 1078.0 |
| 2010-11-03 00:30:00 | ES | Futures | 1175.95 | 1175.95 | 1175.21 | 1175.95 | 1238.0 |
| 2010-11-03 01:00:00 | ES | Futures | 1175.95 | 1175.95 | 1175.21 | 1175.46 | 1005.0 |
| 2010-11-03 01:30:00 | ES | Futures | 1175.21 | 1176.2 | 1175.21 | 1175.7 | 1314.0 |
| 2010-11-03 02:00:00 | ES | Futures | 1175.46 | 1176.69 | 1175.46 | 1176.69 | 703.0 |
| 2010-11-03 02:30:00 | ES | Futures | 1176.69 | 1176.94 | 1175.95 | 1176.44 | 830.0 |
| 2010-11-03 03:00:00 | ES | Futures | 1176.44 | 1176.94 | 1175.46 | 1176.2 | 5456.0 |
| 2010-11-03 03:30:00 | ES | Futures | 1176.44 | 1176.44 | 1174.23 | 1176.2 | 7937.0 |
| 2010-11-03 04:00:00 | ES | Futures | 1175.95 | 1176.44 | 1174.23 | 1175.7 | 15385.0 |
| 2010-11-03 04:30:00 | ES | Futures | 1175.7 | 1175.95 | 1173.98 | 1174.72 | 10117.0 |
| 2010-11-03 05:00:00 | ES | Futures | 1174.72 | 1176.69 | 1173.98 | 1175.95 | 11908.0 |
| 2010-11-03 05:30:00 | ES | Futures | 1175.95 | 1177.43 | 1175.7 | 1177.18 | 7724.0 |
| 2010-11-03 06:00:00 | ES | Futures | 1177.18 | 1177.68 | 1176.69 | 1176.94 | 11591.0 |
| 2010-11-03 06:30:00 | ES | Futures | 1176.94 | 1177.43 | 1176.2 | 1176.94 | 6848.0 |
| 2010-11-03 07:00:00 | ES | Futures | 1176.69 | 1176.94 | 1175.95 | 1176.94 | 7473.0 |
| 2010-11-03 07:30:00 | ES | Futures | 1176.69 | 1177.92 | 1176.44 | 1177.43 | 10215.0 |
| 2010-11-03 08:00:00 | ES | Futures | 1177.18 | 1178.42 | 1176.44 | 1177.68 | 28904.0 |
| 2010-11-03 08:30:00 | ES | Futures | 1177.43 | 1178.17 | 1176.44 | 1177.68 | 22094.0 |
| 2010-11-03 09:00:00 | ES | Futures | 1177.43 | 1177.68 | 1174.96 | 1175.46 | 28482.0 |
| 2010-11-03 09:30:00 | ES | Futures | 1175.46 | 1176.2 | 1173.49 | 1174.23 | 124014.0 |
| 2010-11-03 10:00:00 | ES | Futures | 1174.23 | 1175.95 | 1173.24 | 1174.72 | 107778.0 |
| 2010-11-03 10:30:00 | ES | Futures | 1174.72 | 1175.95 | 1172.25 | 1172.75 | 111525.0 |
| 2010-11-03 11:00:00 | ES | Futures | 1172.75 | 1173.24 | 1169.3 | 1170.28 | 152454.0 |
| 2010-11-03 11:30:00 | ES | Futures | 1170.53 | 1172.25 | 1169.79 | 1170.53 | 67486.0 |
| 2010-11-03 12:00:00 | ES | Futures | 1170.77 | 1170.77 | 1168.06 | 1169.54 | 90882.0 |
| 2010-11-03 12:30:00 | ES | Futures | 1169.54 | 1171.27 | 1169.05 | 1170.04 | 64988.0 |
| 2010-11-03 13:00:00 | ES | Futures | 1170.04 | 1172.01 | 1169.54 | 1169.79 | 55389.0 |
| 2010-11-03 13:30:00 | ES | Futures | 1169.79 | 1171.02 | 1169.05 | 1170.53 | 46131.0 |
| 2010-11-03 14:00:00 | ES | Futures | 1170.28 | 1176.94 | 1165.11 | 1166.58 | 396142.0 |
| 2010-11-03 14:30:00 | ES | Futures | 1166.58 | 1176.44 | 1162.89 | 1175.21 | 363392.0 |
| 2010-11-03 15:00:00 | ES | Futures | 1174.96 | 1178.66 | 1174.23 | 1175.95 | 239725.0 |
| 2010-11-03 15:30:00 | ES | Futures | 1176.2 | 1178.17 | 1173.49 | 1178.17 | 183429.0 |
| 2010-11-03 16:00:00 | ES | Futures | 1177.92 | 1181.13 | 1177.92 | 1180.88 | 132464.0 |
| 2010-11-03 16:30:00 | ES | Futures | 1180.63 | 1181.13 | 1179.15 | 1180.14 | 12783.0 |
| 2010-11-03 17:00:00 | ES | Futures | 1180.14 | 1180.39 | 1179.89 | 1180.14 | 2331.0 |
| 2010-11-03 18:00:00 | ES | Futures | 1180.63 | 1180.63 | 1179.15 | 1179.65 | 2989.0 |
| 2010-11-03 18:30:00 | ES | Futures | 1179.4 | 1179.89 | 1179.15 | 1179.89 | 1460.0 |
| 2010-11-03 19:00:00 | ES | Futures | 1179.65 | 1180.14 | 1179.4 | 1179.65 | 2605.0 |
| 2010-11-03 19:30:00 | ES | Futures | 1179.65 | 1180.88 | 1179.65 | 1179.89 | 4227.0 |
| 2010-11-03 20:00:00 | ES | Futures | 1180.14 | 1180.63 | 1179.4 | 1179.89 | 2766.0 |
| 2010-11-03 20:30:00 | ES | Futures | 1179.65 | 1180.63 | 1179.15 | 1179.4 | 4851.0 |
| 2010-11-03 21:00:00 | ES | Futures | 1179.65 | 1180.63 | 1179.4 | 1179.89 | 2587.0 |
| 2010-11-03 21:30:00 | ES | Futures | 1179.89 | 1180.63 | 1179.65 | 1180.14 | 1778.0 |
| 2010-11-03 22:00:00 | ES | Futures | 1180.14 | 1180.88 | 1179.65 | 1180.63 | 2794.0 |
| 2010-11-03 22:30:00 | ES | Futures | 1180.63 | 1180.88 | 1180.39 | 1180.39 | 2358.0 |
| 2010-11-03 23:00:00 | ES | Futures | 1180.39 | 1181.13 | 1179.65 | 1180.63 | 2422.0 |
| 2010-11-03 23:30:00 | ES | Futures | 1180.63 | 1181.13 | 1179.89 | 1180.14 | 2654.0 |
| 2010-11-03 00:00:00 | NQ | Futures | 2469.66 | 2470.52 | 2469.37 | 2469.66 | 123.0 |
| 2010-11-03 00:30:00 | NQ | Futures | 2469.66 | 2469.66 | 2468.51 | 2469.08 | 96.0 |
| 2010-11-03 01:00:00 | NQ | Futures | 2469.08 | 2469.08 | 2467.94 | 2468.8 | 46.0 |
> showing 50 of 2,643 rows — these rows as CSV