PREVIEW / futures_30min / 2010-10-11
file: by_date/futures_30min/2010/2010-10-11.parquet size: 66 KB rows: 2,514
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-10-11 00:00:00 | ES | Futures | 1146.13 | 1146.37 | 1145.63 | 1145.63 | 893.0 |
| 2010-10-11 00:30:00 | ES | Futures | 1145.63 | 1146.37 | 1145.63 | 1145.88 | 1129.0 |
| 2010-10-11 01:00:00 | ES | Futures | 1145.88 | 1145.88 | 1144.65 | 1145.14 | 1569.0 |
| 2010-10-11 01:30:00 | ES | Futures | 1145.39 | 1145.39 | 1144.15 | 1144.4 | 2071.0 |
| 2010-10-11 02:00:00 | ES | Futures | 1144.15 | 1145.63 | 1143.91 | 1145.63 | 2266.0 |
| 2010-10-11 02:30:00 | ES | Futures | 1145.39 | 1145.63 | 1144.65 | 1145.14 | 2165.0 |
| 2010-10-11 03:00:00 | ES | Futures | 1145.14 | 1146.87 | 1144.89 | 1145.14 | 12516.0 |
| 2010-10-11 03:30:00 | ES | Futures | 1145.14 | 1146.13 | 1144.15 | 1145.14 | 13885.0 |
| 2010-10-11 04:00:00 | ES | Futures | 1145.39 | 1146.87 | 1144.89 | 1146.62 | 7731.0 |
| 2010-10-11 04:30:00 | ES | Futures | 1146.37 | 1147.85 | 1146.37 | 1147.36 | 4819.0 |
| 2010-10-11 05:00:00 | ES | Futures | 1147.11 | 1147.85 | 1146.62 | 1147.61 | 4941.0 |
| 2010-10-11 05:30:00 | ES | Futures | 1147.61 | 1147.85 | 1146.87 | 1147.36 | 5176.0 |
| 2010-10-11 06:00:00 | ES | Futures | 1147.36 | 1147.36 | 1146.37 | 1146.87 | 3315.0 |
| 2010-10-11 06:30:00 | ES | Futures | 1147.11 | 1147.36 | 1146.13 | 1146.37 | 3895.0 |
| 2010-10-11 07:00:00 | ES | Futures | 1146.37 | 1147.11 | 1145.88 | 1147.11 | 3275.0 |
| 2010-10-11 07:30:00 | ES | Futures | 1146.87 | 1147.36 | 1146.62 | 1147.11 | 5397.0 |
| 2010-10-11 08:00:00 | ES | Futures | 1147.11 | 1147.36 | 1146.13 | 1146.62 | 13494.0 |
| 2010-10-11 08:30:00 | ES | Futures | 1146.87 | 1146.87 | 1145.63 | 1145.88 | 11142.0 |
| 2010-10-11 09:00:00 | ES | Futures | 1145.88 | 1146.37 | 1145.14 | 1146.37 | 13942.0 |
| 2010-10-11 09:30:00 | ES | Futures | 1146.37 | 1147.36 | 1144.15 | 1145.14 | 128785.0 |
| 2010-10-11 10:00:00 | ES | Futures | 1144.89 | 1148.35 | 1144.89 | 1148.1 | 97345.0 |
| 2010-10-11 10:30:00 | ES | Futures | 1148.1 | 1148.59 | 1144.15 | 1144.89 | 100550.0 |
| 2010-10-11 11:00:00 | ES | Futures | 1145.14 | 1146.37 | 1143.91 | 1145.88 | 60089.0 |
| 2010-10-11 11:30:00 | ES | Futures | 1146.13 | 1147.61 | 1145.88 | 1146.37 | 52890.0 |
| 2010-10-11 12:00:00 | ES | Futures | 1146.62 | 1147.11 | 1145.88 | 1146.87 | 28859.0 |
| 2010-10-11 12:30:00 | ES | Futures | 1146.87 | 1147.85 | 1145.88 | 1146.62 | 28042.0 |
| 2010-10-11 13:00:00 | ES | Futures | 1146.87 | 1147.36 | 1146.13 | 1147.11 | 17380.0 |
| 2010-10-11 13:30:00 | ES | Futures | 1147.11 | 1147.85 | 1146.62 | 1147.61 | 22010.0 |
| 2010-10-11 14:00:00 | ES | Futures | 1147.61 | 1147.85 | 1146.37 | 1146.87 | 37468.0 |
| 2010-10-11 14:30:00 | ES | Futures | 1146.87 | 1147.61 | 1146.13 | 1146.62 | 30548.0 |
| 2010-10-11 15:00:00 | ES | Futures | 1146.62 | 1147.11 | 1144.4 | 1144.65 | 51921.0 |
| 2010-10-11 15:30:00 | ES | Futures | 1144.4 | 1145.63 | 1141.44 | 1145.63 | 154727.0 |
| 2010-10-11 16:00:00 | ES | Futures | 1145.63 | 1146.62 | 1145.14 | 1145.88 | 57989.0 |
| 2010-10-11 16:30:00 | ES | Futures | 1146.13 | 1146.62 | 1145.39 | 1145.63 | 3938.0 |
| 2010-10-11 17:00:00 | ES | Futures | 1145.88 | 1146.37 | 1145.39 | 1145.63 | 774.0 |
| 2010-10-11 18:00:00 | ES | Futures | 1145.63 | 1146.13 | 1145.39 | 1146.13 | 667.0 |
| 2010-10-11 18:30:00 | ES | Futures | 1145.88 | 1146.37 | 1145.63 | 1146.13 | 292.0 |
| 2010-10-11 19:00:00 | ES | Futures | 1146.37 | 1146.37 | 1144.89 | 1144.89 | 1518.0 |
| 2010-10-11 19:30:00 | ES | Futures | 1144.89 | 1146.13 | 1144.65 | 1145.88 | 1205.0 |
| 2010-10-11 20:00:00 | ES | Futures | 1146.13 | 1146.37 | 1145.14 | 1145.39 | 2503.0 |
| 2010-10-11 20:30:00 | ES | Futures | 1145.63 | 1145.88 | 1143.66 | 1143.91 | 4428.0 |
| 2010-10-11 21:00:00 | ES | Futures | 1143.91 | 1144.15 | 1140.46 | 1141.2 | 11158.0 |
| 2010-10-11 21:30:00 | ES | Futures | 1141.44 | 1141.69 | 1140.21 | 1140.46 | 5599.0 |
| 2010-10-11 22:00:00 | ES | Futures | 1140.46 | 1140.95 | 1140.21 | 1140.7 | 4377.0 |
| 2010-10-11 22:30:00 | ES | Futures | 1140.46 | 1141.44 | 1140.46 | 1141.44 | 2630.0 |
| 2010-10-11 23:00:00 | ES | Futures | 1141.44 | 1141.44 | 1140.21 | 1140.7 | 2045.0 |
| 2010-10-11 23:30:00 | ES | Futures | 1140.46 | 1140.46 | 1137.5 | 1137.5 | 12215.0 |
| 2010-10-11 00:00:00 | NQ | Futures | 2323.62 | 2324.48 | 2323.34 | 2323.34 | 21.0 |
| 2010-10-11 00:30:00 | NQ | Futures | 2323.34 | 2324.2 | 2323.05 | 2323.05 | 49.0 |
| 2010-10-11 01:00:00 | NQ | Futures | 2322.76 | 2322.76 | 2320.47 | 2321.04 | 83.0 |
> showing 50 of 2,514 rows — these rows as CSV