PREVIEW / futures_30min / 2010-11-30
file: by_date/futures_30min/2010/2010-11-30.parquet size: 75 KB rows: 2,683
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-30 00:00:00 | ES | Futures | 1165.85 | 1166.34 | 1165.35 | 1166.09 | 2419.0 |
| 2010-11-30 00:30:00 | ES | Futures | 1166.09 | 1167.08 | 1165.11 | 1165.11 | 5038.0 |
| 2010-11-30 01:00:00 | ES | Futures | 1165.11 | 1166.58 | 1164.61 | 1165.85 | 3740.0 |
| 2010-11-30 01:30:00 | ES | Futures | 1166.09 | 1167.82 | 1165.85 | 1167.57 | 3026.0 |
| 2010-11-30 02:00:00 | ES | Futures | 1167.32 | 1169.05 | 1167.08 | 1167.57 | 6043.0 |
| 2010-11-30 02:30:00 | ES | Futures | 1167.57 | 1169.3 | 1165.85 | 1168.31 | 8731.0 |
| 2010-11-30 03:00:00 | ES | Futures | 1168.31 | 1171.02 | 1166.34 | 1168.06 | 41029.0 |
| 2010-11-30 03:30:00 | ES | Futures | 1168.06 | 1169.3 | 1164.86 | 1165.11 | 35497.0 |
| 2010-11-30 04:00:00 | ES | Futures | 1165.11 | 1167.32 | 1164.12 | 1164.86 | 27380.0 |
| 2010-11-30 04:30:00 | ES | Futures | 1164.61 | 1167.57 | 1164.37 | 1167.08 | 25394.0 |
| 2010-11-30 05:00:00 | ES | Futures | 1166.83 | 1168.8 | 1165.35 | 1168.31 | 26574.0 |
| 2010-11-30 05:30:00 | ES | Futures | 1168.31 | 1171.27 | 1168.06 | 1170.28 | 25515.0 |
| 2010-11-30 06:00:00 | ES | Futures | 1170.04 | 1171.02 | 1166.34 | 1167.08 | 30520.0 |
| 2010-11-30 06:30:00 | ES | Futures | 1167.08 | 1169.54 | 1166.58 | 1168.06 | 26683.0 |
| 2010-11-30 07:00:00 | ES | Futures | 1168.06 | 1168.31 | 1162.64 | 1162.89 | 31469.0 |
| 2010-11-30 07:30:00 | ES | Futures | 1163.13 | 1165.35 | 1161.9 | 1161.9 | 32377.0 |
| 2010-11-30 08:00:00 | ES | Futures | 1162.15 | 1163.38 | 1158.7 | 1159.93 | 59521.0 |
| 2010-11-30 08:30:00 | ES | Futures | 1159.93 | 1160.18 | 1156.97 | 1158.94 | 65773.0 |
| 2010-11-30 09:00:00 | ES | Futures | 1158.7 | 1160.18 | 1157.96 | 1158.45 | 49830.0 |
| 2010-11-30 09:30:00 | ES | Futures | 1158.2 | 1162.89 | 1156.48 | 1162.64 | 290476.0 |
| 2010-11-30 10:00:00 | ES | Futures | 1162.39 | 1167.08 | 1160.67 | 1166.34 | 269163.0 |
| 2010-11-30 10:30:00 | ES | Futures | 1166.34 | 1166.34 | 1160.92 | 1163.13 | 166235.0 |
| 2010-11-30 11:00:00 | ES | Futures | 1163.38 | 1164.86 | 1161.16 | 1162.89 | 165589.0 |
| 2010-11-30 11:30:00 | ES | Futures | 1162.64 | 1165.85 | 1161.41 | 1164.86 | 128621.0 |
| 2010-11-30 12:00:00 | ES | Futures | 1164.86 | 1165.6 | 1163.13 | 1164.61 | 87429.0 |
| 2010-11-30 12:30:00 | ES | Futures | 1164.61 | 1166.09 | 1162.89 | 1165.85 | 96035.0 |
| 2010-11-30 13:00:00 | ES | Futures | 1165.6 | 1170.28 | 1165.11 | 1168.8 | 207095.0 |
| 2010-11-30 13:30:00 | ES | Futures | 1168.8 | 1169.79 | 1166.83 | 1167.82 | 124079.0 |
| 2010-11-30 14:00:00 | ES | Futures | 1168.06 | 1169.79 | 1164.12 | 1165.11 | 164998.0 |
| 2010-11-30 14:30:00 | ES | Futures | 1164.86 | 1168.06 | 1163.63 | 1166.83 | 149897.0 |
| 2010-11-30 15:00:00 | ES | Futures | 1167.08 | 1168.8 | 1165.6 | 1168.06 | 133941.0 |
| 2010-11-30 15:30:00 | ES | Futures | 1168.06 | 1168.56 | 1162.39 | 1162.89 | 326798.0 |
| 2010-11-30 16:00:00 | ES | Futures | 1163.13 | 1163.13 | 1158.94 | 1160.42 | 214226.0 |
| 2010-11-30 16:30:00 | ES | Futures | 1161.16 | 1162.15 | 1160.42 | 1161.65 | 9373.0 |
| 2010-11-30 17:00:00 | ES | Futures | 1161.65 | 1162.15 | 1160.92 | 1161.65 | 3767.0 |
| 2010-11-30 18:00:00 | ES | Futures | 1161.9 | 1162.15 | 1160.92 | 1161.41 | 3903.0 |
| 2010-11-30 18:30:00 | ES | Futures | 1161.16 | 1161.41 | 1159.68 | 1160.42 | 3410.0 |
| 2010-11-30 19:00:00 | ES | Futures | 1160.42 | 1161.9 | 1160.42 | 1161.65 | 3987.0 |
| 2010-11-30 19:30:00 | ES | Futures | 1161.65 | 1161.65 | 1160.42 | 1161.16 | 1716.0 |
| 2010-11-30 20:00:00 | ES | Futures | 1161.16 | 1162.64 | 1160.92 | 1160.92 | 3763.0 |
| 2010-11-30 20:30:00 | ES | Futures | 1160.92 | 1162.64 | 1159.93 | 1161.65 | 3063.0 |
| 2010-11-30 21:00:00 | ES | Futures | 1161.9 | 1162.64 | 1161.41 | 1162.15 | 2066.0 |
| 2010-11-30 21:30:00 | ES | Futures | 1162.15 | 1162.89 | 1161.9 | 1162.89 | 2023.0 |
| 2010-11-30 22:00:00 | ES | Futures | 1162.89 | 1162.89 | 1161.41 | 1161.65 | 2494.0 |
| 2010-11-30 22:30:00 | ES | Futures | 1161.65 | 1163.87 | 1160.67 | 1163.63 | 4319.0 |
| 2010-11-30 23:00:00 | ES | Futures | 1163.87 | 1165.11 | 1163.63 | 1164.37 | 4504.0 |
| 2010-11-30 23:30:00 | ES | Futures | 1164.12 | 1164.86 | 1163.87 | 1163.87 | 1245.0 |
| 2010-11-30 00:00:00 | NQ | Futures | 2452.73 | 2453.88 | 2452.16 | 2453.59 | 91.0 |
| 2010-11-30 00:30:00 | NQ | Futures | 2453.59 | 2454.45 | 2451.87 | 2451.87 | 120.0 |
| 2010-11-30 01:00:00 | NQ | Futures | 2451.58 | 2453.02 | 2448.71 | 2452.73 | 225.0 |
> showing 50 of 2,683 rows — these rows as CSV