PREVIEW / futures_30min / 2010-11-02
file: by_date/futures_30min/2010/2010-11-02.parquet size: 69 KB rows: 2,607
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-02 00:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1167.08 | 1500.0 |
| 2010-11-02 00:30:00 | ES | Futures | 1167.08 | 1168.06 | 1166.83 | 1167.82 | 1919.0 |
| 2010-11-02 01:00:00 | ES | Futures | 1167.82 | 1168.31 | 1167.57 | 1168.06 | 1231.0 |
| 2010-11-02 01:30:00 | ES | Futures | 1168.31 | 1168.8 | 1167.08 | 1167.32 | 3198.0 |
| 2010-11-02 02:00:00 | ES | Futures | 1167.57 | 1168.06 | 1167.08 | 1167.57 | 2245.0 |
| 2010-11-02 02:30:00 | ES | Futures | 1167.57 | 1167.82 | 1167.08 | 1167.08 | 539.0 |
| 2010-11-02 03:00:00 | ES | Futures | 1167.32 | 1167.82 | 1166.58 | 1167.57 | 2378.0 |
| 2010-11-02 03:30:00 | ES | Futures | 1167.82 | 1168.31 | 1167.57 | 1167.57 | 5212.0 |
| 2010-11-02 04:00:00 | ES | Futures | 1167.82 | 1170.53 | 1167.32 | 1170.04 | 21067.0 |
| 2010-11-02 04:30:00 | ES | Futures | 1170.04 | 1170.04 | 1168.56 | 1169.05 | 11086.0 |
| 2010-11-02 05:00:00 | ES | Futures | 1169.05 | 1170.53 | 1168.8 | 1170.53 | 7864.0 |
| 2010-11-02 05:30:00 | ES | Futures | 1170.53 | 1171.02 | 1169.79 | 1169.79 | 10523.0 |
| 2010-11-02 06:00:00 | ES | Futures | 1170.04 | 1170.77 | 1169.54 | 1170.77 | 9136.0 |
| 2010-11-02 06:30:00 | ES | Futures | 1170.77 | 1171.76 | 1170.04 | 1171.02 | 16751.0 |
| 2010-11-02 07:00:00 | ES | Futures | 1170.77 | 1171.76 | 1170.28 | 1171.76 | 8956.0 |
| 2010-11-02 07:30:00 | ES | Futures | 1171.51 | 1173.49 | 1171.51 | 1172.75 | 26523.0 |
| 2010-11-02 08:00:00 | ES | Futures | 1172.75 | 1174.47 | 1172.5 | 1174.23 | 44167.0 |
| 2010-11-02 08:30:00 | ES | Futures | 1174.23 | 1174.47 | 1172.5 | 1173.24 | 25192.0 |
| 2010-11-02 09:00:00 | ES | Futures | 1173.24 | 1174.23 | 1172.5 | 1172.99 | 26296.0 |
| 2010-11-02 09:30:00 | ES | Futures | 1172.99 | 1175.21 | 1171.51 | 1172.75 | 231107.0 |
| 2010-11-02 10:00:00 | ES | Futures | 1172.75 | 1173.49 | 1170.53 | 1171.27 | 147313.0 |
| 2010-11-02 10:30:00 | ES | Futures | 1171.51 | 1172.01 | 1169.54 | 1171.27 | 116143.0 |
| 2010-11-02 11:00:00 | ES | Futures | 1171.02 | 1172.99 | 1170.53 | 1172.01 | 84869.0 |
| 2010-11-02 11:30:00 | ES | Futures | 1172.01 | 1172.99 | 1171.51 | 1172.01 | 57299.0 |
| 2010-11-02 12:00:00 | ES | Futures | 1172.25 | 1173.24 | 1171.76 | 1172.25 | 59356.0 |
| 2010-11-02 12:30:00 | ES | Futures | 1172.01 | 1174.23 | 1171.76 | 1173.73 | 61507.0 |
| 2010-11-02 13:00:00 | ES | Futures | 1173.73 | 1174.72 | 1173.49 | 1173.98 | 46127.0 |
| 2010-11-02 13:30:00 | ES | Futures | 1173.98 | 1176.2 | 1173.73 | 1175.7 | 91398.0 |
| 2010-11-02 14:00:00 | ES | Futures | 1175.46 | 1175.95 | 1173.49 | 1174.47 | 53276.0 |
| 2010-11-02 14:30:00 | ES | Futures | 1174.23 | 1174.72 | 1172.75 | 1173.49 | 66832.0 |
| 2010-11-02 15:00:00 | ES | Futures | 1173.49 | 1174.96 | 1173.24 | 1173.98 | 44840.0 |
| 2010-11-02 15:30:00 | ES | Futures | 1173.98 | 1174.47 | 1172.5 | 1173.24 | 142106.0 |
| 2010-11-02 16:00:00 | ES | Futures | 1173.49 | 1176.69 | 1172.99 | 1176.2 | 114628.0 |
| 2010-11-02 16:30:00 | ES | Futures | 1175.95 | 1176.44 | 1175.46 | 1175.95 | 6040.0 |
| 2010-11-02 17:00:00 | ES | Futures | 1175.95 | 1176.69 | 1175.7 | 1175.7 | 2074.0 |
| 2010-11-02 18:00:00 | ES | Futures | 1175.95 | 1176.94 | 1175.7 | 1176.69 | 1310.0 |
| 2010-11-02 18:30:00 | ES | Futures | 1176.69 | 1176.69 | 1176.2 | 1176.44 | 539.0 |
| 2010-11-02 19:00:00 | ES | Futures | 1176.69 | 1179.65 | 1176.44 | 1178.91 | 7776.0 |
| 2010-11-02 19:30:00 | ES | Futures | 1178.91 | 1179.65 | 1178.66 | 1178.91 | 2615.0 |
| 2010-11-02 20:00:00 | ES | Futures | 1178.91 | 1178.91 | 1177.68 | 1178.17 | 4030.0 |
| 2010-11-02 20:30:00 | ES | Futures | 1177.92 | 1177.92 | 1175.95 | 1176.2 | 3278.0 |
| 2010-11-02 21:00:00 | ES | Futures | 1176.2 | 1176.94 | 1175.46 | 1175.46 | 2832.0 |
| 2010-11-02 21:30:00 | ES | Futures | 1175.46 | 1177.43 | 1174.96 | 1176.2 | 3829.0 |
| 2010-11-02 22:00:00 | ES | Futures | 1175.95 | 1176.94 | 1173.98 | 1176.94 | 5540.0 |
| 2010-11-02 22:30:00 | ES | Futures | 1176.94 | 1177.43 | 1176.2 | 1176.69 | 2488.0 |
| 2010-11-02 23:00:00 | ES | Futures | 1176.44 | 1176.94 | 1175.7 | 1175.95 | 1239.0 |
| 2010-11-02 23:30:00 | ES | Futures | 1175.95 | 1176.44 | 1175.95 | 1176.2 | 630.0 |
| 2010-11-02 00:00:00 | NQ | Futures | 2445.27 | 2445.56 | 2444.7 | 2445.56 | 94.0 |
| 2010-11-02 00:30:00 | NQ | Futures | 2445.84 | 2447.28 | 2445.27 | 2447.28 | 135.0 |
| 2010-11-02 01:00:00 | NQ | Futures | 2447.57 | 2448.14 | 2447.28 | 2447.57 | 63.0 |
> showing 50 of 2,607 rows — these rows as CSV