PREVIEW / futures_30min / 2010-04-15
file: by_date/futures_30min/2010/2010-04-15.parquet size: 69 KB rows: 2,545
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-04-15 00:00:00 | ES | Futures | 1177.89 | 1178.13 | 1177.4 | 1177.89 | 1631.0 |
| 2010-04-15 00:30:00 | ES | Futures | 1177.89 | 1177.89 | 1177.16 | 1177.65 | 1021.0 |
| 2010-04-15 01:00:00 | ES | Futures | 1177.65 | 1177.89 | 1177.4 | 1177.89 | 839.0 |
| 2010-04-15 01:30:00 | ES | Futures | 1177.65 | 1178.13 | 1177.4 | 1177.4 | 1024.0 |
| 2010-04-15 02:00:00 | ES | Futures | 1177.65 | 1178.38 | 1177.4 | 1177.65 | 2889.0 |
| 2010-04-15 02:30:00 | ES | Futures | 1177.65 | 1178.38 | 1177.65 | 1178.13 | 3279.0 |
| 2010-04-15 03:00:00 | ES | Futures | 1178.38 | 1178.38 | 1177.16 | 1177.89 | 9879.0 |
| 2010-04-15 03:30:00 | ES | Futures | 1177.65 | 1178.38 | 1176.91 | 1177.89 | 8986.0 |
| 2010-04-15 04:00:00 | ES | Futures | 1177.89 | 1178.38 | 1177.16 | 1177.65 | 6879.0 |
| 2010-04-15 04:30:00 | ES | Futures | 1177.65 | 1177.65 | 1175.93 | 1176.42 | 9505.0 |
| 2010-04-15 05:00:00 | ES | Futures | 1176.18 | 1176.91 | 1174.47 | 1174.71 | 15804.0 |
| 2010-04-15 05:30:00 | ES | Futures | 1174.71 | 1175.45 | 1174.22 | 1175.45 | 10241.0 |
| 2010-04-15 06:00:00 | ES | Futures | 1175.2 | 1176.67 | 1175.2 | 1176.42 | 7505.0 |
| 2010-04-15 06:30:00 | ES | Futures | 1176.67 | 1177.4 | 1176.42 | 1177.16 | 7362.0 |
| 2010-04-15 07:00:00 | ES | Futures | 1176.91 | 1177.4 | 1176.42 | 1176.91 | 10275.0 |
| 2010-04-15 07:30:00 | ES | Futures | 1176.91 | 1177.4 | 1176.42 | 1177.16 | 7717.0 |
| 2010-04-15 08:00:00 | ES | Futures | 1177.16 | 1178.38 | 1177.16 | 1178.38 | 11957.0 |
| 2010-04-15 08:30:00 | ES | Futures | 1178.13 | 1178.13 | 1175.69 | 1177.4 | 47048.0 |
| 2010-04-15 09:00:00 | ES | Futures | 1177.4 | 1178.38 | 1176.67 | 1178.13 | 22920.0 |
| 2010-04-15 09:30:00 | ES | Futures | 1178.13 | 1179.36 | 1177.89 | 1178.87 | 144364.0 |
| 2010-04-15 10:00:00 | ES | Futures | 1178.62 | 1181.07 | 1177.89 | 1180.33 | 127883.0 |
| 2010-04-15 10:30:00 | ES | Futures | 1180.33 | 1183.02 | 1180.09 | 1182.78 | 173349.0 |
| 2010-04-15 11:00:00 | ES | Futures | 1183.02 | 1183.51 | 1180.09 | 1180.33 | 153610.0 |
| 2010-04-15 11:30:00 | ES | Futures | 1180.09 | 1181.07 | 1178.38 | 1179.36 | 142285.0 |
| 2010-04-15 12:00:00 | ES | Futures | 1179.36 | 1180.58 | 1177.65 | 1178.87 | 115772.0 |
| 2010-04-15 12:30:00 | ES | Futures | 1179.11 | 1180.58 | 1178.62 | 1180.33 | 41663.0 |
| 2010-04-15 13:00:00 | ES | Futures | 1180.33 | 1182.53 | 1179.85 | 1182.53 | 74376.0 |
| 2010-04-15 13:30:00 | ES | Futures | 1182.29 | 1182.78 | 1181.07 | 1182.05 | 46929.0 |
| 2010-04-15 14:00:00 | ES | Futures | 1182.05 | 1182.78 | 1181.56 | 1182.29 | 43714.0 |
| 2010-04-15 14:30:00 | ES | Futures | 1182.29 | 1183.27 | 1181.56 | 1183.27 | 65650.0 |
| 2010-04-15 15:00:00 | ES | Futures | 1183.27 | 1183.27 | 1180.33 | 1180.58 | 80121.0 |
| 2010-04-15 15:30:00 | ES | Futures | 1180.58 | 1181.8 | 1179.11 | 1181.07 | 164657.0 |
| 2010-04-15 16:00:00 | ES | Futures | 1181.31 | 1181.8 | 1179.85 | 1181.31 | 142279.0 |
| 2010-04-15 16:30:00 | ES | Futures | 1181.07 | 1181.56 | 1179.11 | 1179.36 | 15140.0 |
| 2010-04-15 17:00:00 | ES | Futures | 1179.36 | 1179.85 | 1179.11 | 1179.11 | 2627.0 |
| 2010-04-15 18:00:00 | ES | Futures | 1179.36 | 1179.6 | 1179.11 | 1179.36 | 529.0 |
| 2010-04-15 18:30:00 | ES | Futures | 1179.36 | 1179.85 | 1179.36 | 1179.36 | 975.0 |
| 2010-04-15 19:00:00 | ES | Futures | 1179.36 | 1179.6 | 1179.11 | 1179.36 | 472.0 |
| 2010-04-15 19:30:00 | ES | Futures | 1179.11 | 1179.6 | 1178.13 | 1178.62 | 3125.0 |
| 2010-04-15 20:00:00 | ES | Futures | 1178.38 | 1178.38 | 1176.67 | 1176.91 | 5496.0 |
| 2010-04-15 20:30:00 | ES | Futures | 1176.91 | 1177.16 | 1176.67 | 1176.67 | 2245.0 |
| 2010-04-15 21:00:00 | ES | Futures | 1176.91 | 1177.4 | 1176.42 | 1176.67 | 3275.0 |
| 2010-04-15 21:30:00 | ES | Futures | 1176.67 | 1176.67 | 1175.93 | 1176.18 | 5558.0 |
| 2010-04-15 22:00:00 | ES | Futures | 1175.93 | 1176.42 | 1175.2 | 1175.2 | 6019.0 |
| 2010-04-15 22:30:00 | ES | Futures | 1175.45 | 1176.18 | 1174.47 | 1174.96 | 10941.0 |
| 2010-04-15 23:00:00 | ES | Futures | 1174.96 | 1175.69 | 1174.96 | 1175.45 | 2391.0 |
| 2010-04-15 23:30:00 | ES | Futures | 1175.45 | 1176.18 | 1174.96 | 1174.96 | 3154.0 |
| 2010-04-15 00:00:00 | NQ | Futures | 2318.19 | 2319.05 | 2317.9 | 2318.19 | 139.0 |
| 2010-04-15 00:30:00 | NQ | Futures | 2318.19 | 2318.19 | 2317.33 | 2317.9 | 76.0 |
| 2010-04-15 01:00:00 | NQ | Futures | 2318.19 | 2318.47 | 2317.9 | 2318.19 | 75.0 |
> showing 50 of 2,545 rows — these rows as CSV