PREVIEW / futures_30min / 2010-11-01
file: by_date/futures_30min/2010/2010-11-01.parquet size: 71 KB rows: 2,589
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-01 00:00:00 | ES | Futures | 1172.01 | 1172.25 | 1171.76 | 1172.01 | 482.0 |
| 2010-11-01 00:30:00 | ES | Futures | 1171.76 | 1172.25 | 1171.76 | 1172.25 | 1766.0 |
| 2010-11-01 01:00:00 | ES | Futures | 1172.01 | 1172.25 | 1170.04 | 1170.53 | 4259.0 |
| 2010-11-01 01:30:00 | ES | Futures | 1170.53 | 1171.76 | 1170.28 | 1171.51 | 2057.0 |
| 2010-11-01 02:00:00 | ES | Futures | 1171.76 | 1172.25 | 1171.02 | 1171.51 | 2204.0 |
| 2010-11-01 02:30:00 | ES | Futures | 1171.27 | 1171.76 | 1170.77 | 1171.51 | 2484.0 |
| 2010-11-01 03:00:00 | ES | Futures | 1171.51 | 1172.01 | 1171.02 | 1171.51 | 4248.0 |
| 2010-11-01 03:30:00 | ES | Futures | 1171.27 | 1172.25 | 1171.27 | 1171.76 | 4992.0 |
| 2010-11-01 04:00:00 | ES | Futures | 1171.76 | 1172.01 | 1170.28 | 1170.77 | 13394.0 |
| 2010-11-01 04:30:00 | ES | Futures | 1171.02 | 1172.99 | 1170.77 | 1172.99 | 16670.0 |
| 2010-11-01 05:00:00 | ES | Futures | 1172.75 | 1172.99 | 1171.76 | 1172.25 | 9564.0 |
| 2010-11-01 05:30:00 | ES | Futures | 1172.25 | 1172.99 | 1169.3 | 1170.28 | 22083.0 |
| 2010-11-01 06:00:00 | ES | Futures | 1170.28 | 1170.28 | 1167.82 | 1168.06 | 28508.0 |
| 2010-11-01 06:30:00 | ES | Futures | 1168.06 | 1170.53 | 1167.82 | 1169.79 | 18014.0 |
| 2010-11-01 07:00:00 | ES | Futures | 1170.04 | 1170.04 | 1169.05 | 1169.05 | 7484.0 |
| 2010-11-01 07:30:00 | ES | Futures | 1169.05 | 1170.28 | 1168.31 | 1168.31 | 10590.0 |
| 2010-11-01 08:00:00 | ES | Futures | 1168.56 | 1169.05 | 1167.57 | 1168.31 | 22491.0 |
| 2010-11-01 08:30:00 | ES | Futures | 1168.06 | 1169.3 | 1167.32 | 1169.05 | 30318.0 |
| 2010-11-01 09:00:00 | ES | Futures | 1169.05 | 1170.04 | 1168.8 | 1169.3 | 24984.0 |
| 2010-11-01 09:30:00 | ES | Futures | 1169.54 | 1172.99 | 1169.05 | 1171.51 | 185431.0 |
| 2010-11-01 10:00:00 | ES | Futures | 1171.51 | 1175.95 | 1171.51 | 1173.73 | 267375.0 |
| 2010-11-01 10:30:00 | ES | Futures | 1173.73 | 1174.47 | 1171.76 | 1172.5 | 126956.0 |
| 2010-11-01 11:00:00 | ES | Futures | 1172.25 | 1172.5 | 1168.06 | 1168.56 | 184546.0 |
| 2010-11-01 11:30:00 | ES | Futures | 1168.8 | 1169.3 | 1166.34 | 1169.3 | 127510.0 |
| 2010-11-01 12:00:00 | ES | Futures | 1169.3 | 1169.79 | 1167.57 | 1169.3 | 67112.0 |
| 2010-11-01 12:30:00 | ES | Futures | 1169.05 | 1169.3 | 1166.09 | 1167.08 | 63483.0 |
| 2010-11-01 13:00:00 | ES | Futures | 1166.83 | 1168.31 | 1165.6 | 1167.08 | 71680.0 |
| 2010-11-01 13:30:00 | ES | Futures | 1167.08 | 1169.3 | 1166.58 | 1167.82 | 45344.0 |
| 2010-11-01 14:00:00 | ES | Futures | 1167.82 | 1168.31 | 1165.85 | 1166.09 | 35898.0 |
| 2010-11-01 14:30:00 | ES | Futures | 1165.85 | 1166.58 | 1162.15 | 1163.13 | 129934.0 |
| 2010-11-01 15:00:00 | ES | Futures | 1163.13 | 1163.63 | 1157.22 | 1160.42 | 192524.0 |
| 2010-11-01 15:30:00 | ES | Futures | 1160.42 | 1164.61 | 1159.93 | 1164.37 | 164648.0 |
| 2010-11-01 16:00:00 | ES | Futures | 1164.12 | 1166.58 | 1163.87 | 1166.34 | 73702.0 |
| 2010-11-01 16:30:00 | ES | Futures | 1166.09 | 1166.34 | 1165.11 | 1165.6 | 4502.0 |
| 2010-11-01 17:00:00 | ES | Futures | 1165.6 | 1166.09 | 1164.61 | 1165.11 | 2528.0 |
| 2010-11-01 18:00:00 | ES | Futures | 1165.11 | 1165.6 | 1164.12 | 1164.61 | 2725.0 |
| 2010-11-01 18:30:00 | ES | Futures | 1164.61 | 1165.11 | 1164.37 | 1164.86 | 782.0 |
| 2010-11-01 19:00:00 | ES | Futures | 1164.86 | 1165.35 | 1164.86 | 1165.11 | 1000.0 |
| 2010-11-01 19:30:00 | ES | Futures | 1165.11 | 1166.09 | 1165.11 | 1166.09 | 1736.0 |
| 2010-11-01 20:00:00 | ES | Futures | 1165.85 | 1166.58 | 1165.35 | 1166.34 | 3036.0 |
| 2010-11-01 20:30:00 | ES | Futures | 1166.34 | 1167.08 | 1166.09 | 1167.08 | 2811.0 |
| 2010-11-01 21:00:00 | ES | Futures | 1166.83 | 1167.32 | 1165.85 | 1166.09 | 2661.0 |
| 2010-11-01 21:30:00 | ES | Futures | 1166.09 | 1166.34 | 1164.86 | 1165.6 | 1908.0 |
| 2010-11-01 22:00:00 | ES | Futures | 1165.35 | 1165.85 | 1164.86 | 1165.11 | 2294.0 |
| 2010-11-01 22:30:00 | ES | Futures | 1164.86 | 1165.6 | 1164.86 | 1165.35 | 1090.0 |
| 2010-11-01 23:00:00 | ES | Futures | 1165.6 | 1166.34 | 1165.6 | 1165.85 | 1213.0 |
| 2010-11-01 23:30:00 | ES | Futures | 1165.85 | 1167.08 | 1165.6 | 1166.58 | 2527.0 |
| 2010-11-01 00:00:00 | NQ | Futures | 2450.43 | 2450.72 | 2450.43 | 2450.72 | 44.0 |
| 2010-11-01 00:30:00 | NQ | Futures | 2450.43 | 2451.01 | 2450.15 | 2450.72 | 197.0 |
| 2010-11-01 01:00:00 | NQ | Futures | 2450.43 | 2450.72 | 2448.43 | 2448.71 | 220.0 |
> showing 50 of 2,589 rows — these rows as CSV