PREVIEW / futures_30min / 2010-08-04
file: by_date/futures_30min/2010/2010-08-04.parquet size: 71 KB rows: 2,547
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-08-04 00:00:00 | ES | Futures | 1095.86 | 1096.36 | 1094.64 | 1094.88 | 3592.0 |
| 2010-08-04 00:30:00 | ES | Futures | 1095.13 | 1095.62 | 1094.39 | 1094.88 | 2677.0 |
| 2010-08-04 01:00:00 | ES | Futures | 1095.13 | 1095.37 | 1094.15 | 1094.15 | 1765.0 |
| 2010-08-04 01:30:00 | ES | Futures | 1094.39 | 1094.88 | 1093.66 | 1094.15 | 1819.0 |
| 2010-08-04 02:00:00 | ES | Futures | 1094.39 | 1095.13 | 1093.17 | 1094.88 | 6171.0 |
| 2010-08-04 02:30:00 | ES | Futures | 1095.13 | 1096.36 | 1094.88 | 1096.11 | 3873.0 |
| 2010-08-04 03:00:00 | ES | Futures | 1095.86 | 1096.36 | 1094.15 | 1094.64 | 11403.0 |
| 2010-08-04 03:30:00 | ES | Futures | 1094.39 | 1095.13 | 1093.41 | 1093.9 | 11460.0 |
| 2010-08-04 04:00:00 | ES | Futures | 1093.9 | 1094.64 | 1093.17 | 1093.66 | 8789.0 |
| 2010-08-04 04:30:00 | ES | Futures | 1093.9 | 1094.15 | 1092.18 | 1093.17 | 15557.0 |
| 2010-08-04 05:00:00 | ES | Futures | 1093.41 | 1094.15 | 1092.92 | 1093.17 | 6045.0 |
| 2010-08-04 05:30:00 | ES | Futures | 1093.17 | 1093.41 | 1091.69 | 1093.17 | 9886.0 |
| 2010-08-04 06:00:00 | ES | Futures | 1093.41 | 1094.64 | 1092.67 | 1094.15 | 6349.0 |
| 2010-08-04 06:30:00 | ES | Futures | 1094.39 | 1094.88 | 1093.9 | 1094.15 | 5677.0 |
| 2010-08-04 07:00:00 | ES | Futures | 1094.39 | 1096.36 | 1094.39 | 1095.86 | 10215.0 |
| 2010-08-04 07:30:00 | ES | Futures | 1095.86 | 1096.11 | 1094.15 | 1094.64 | 15059.0 |
| 2010-08-04 08:00:00 | ES | Futures | 1094.88 | 1100.53 | 1093.41 | 1100.04 | 67171.0 |
| 2010-08-04 08:30:00 | ES | Futures | 1100.28 | 1100.77 | 1098.32 | 1099.3 | 29823.0 |
| 2010-08-04 09:00:00 | ES | Futures | 1099.55 | 1100.53 | 1099.05 | 1099.55 | 24567.0 |
| 2010-08-04 09:30:00 | ES | Futures | 1099.55 | 1101.51 | 1097.58 | 1100.77 | 160665.0 |
| 2010-08-04 10:00:00 | ES | Futures | 1100.77 | 1104.45 | 1096.11 | 1098.07 | 249972.0 |
| 2010-08-04 10:30:00 | ES | Futures | 1097.83 | 1099.3 | 1095.62 | 1098.07 | 153477.0 |
| 2010-08-04 11:00:00 | ES | Futures | 1098.32 | 1100.77 | 1097.34 | 1100.28 | 70328.0 |
| 2010-08-04 11:30:00 | ES | Futures | 1100.28 | 1102.0 | 1099.55 | 1100.04 | 64049.0 |
| 2010-08-04 12:00:00 | ES | Futures | 1100.28 | 1103.23 | 1099.55 | 1102.0 | 57012.0 |
| 2010-08-04 12:30:00 | ES | Futures | 1102.0 | 1103.23 | 1101.02 | 1101.51 | 39644.0 |
| 2010-08-04 13:00:00 | ES | Futures | 1101.75 | 1102.0 | 1098.56 | 1099.3 | 65792.0 |
| 2010-08-04 13:30:00 | ES | Futures | 1099.3 | 1101.02 | 1098.81 | 1100.04 | 48454.0 |
| 2010-08-04 14:00:00 | ES | Futures | 1100.04 | 1102.49 | 1099.55 | 1101.75 | 55435.0 |
| 2010-08-04 14:30:00 | ES | Futures | 1101.75 | 1103.23 | 1100.53 | 1102.49 | 54840.0 |
| 2010-08-04 15:00:00 | ES | Futures | 1102.49 | 1104.94 | 1101.51 | 1104.21 | 91664.0 |
| 2010-08-04 15:30:00 | ES | Futures | 1104.45 | 1105.19 | 1102.98 | 1103.72 | 135087.0 |
| 2010-08-04 16:00:00 | ES | Futures | 1103.96 | 1104.21 | 1103.23 | 1103.96 | 73782.0 |
| 2010-08-04 16:30:00 | ES | Futures | 1103.96 | 1104.7 | 1103.72 | 1104.21 | 2859.0 |
| 2010-08-04 17:00:00 | ES | Futures | 1104.45 | 1104.45 | 1102.74 | 1103.23 | 2839.0 |
| 2010-08-04 18:00:00 | ES | Futures | 1103.23 | 1103.72 | 1102.98 | 1102.98 | 1232.0 |
| 2010-08-04 18:30:00 | ES | Futures | 1102.98 | 1103.23 | 1102.24 | 1102.74 | 1283.0 |
| 2010-08-04 19:00:00 | ES | Futures | 1102.49 | 1102.74 | 1102.24 | 1102.49 | 659.0 |
| 2010-08-04 19:30:00 | ES | Futures | 1102.74 | 1103.96 | 1102.49 | 1103.72 | 1730.0 |
| 2010-08-04 20:00:00 | ES | Futures | 1103.96 | 1104.94 | 1103.72 | 1104.7 | 1936.0 |
| 2010-08-04 20:30:00 | ES | Futures | 1104.94 | 1104.94 | 1103.96 | 1103.96 | 1725.0 |
| 2010-08-04 21:00:00 | ES | Futures | 1103.96 | 1104.45 | 1103.47 | 1104.21 | 2128.0 |
| 2010-08-04 21:30:00 | ES | Futures | 1103.96 | 1103.96 | 1102.49 | 1102.98 | 2341.0 |
| 2010-08-04 22:00:00 | ES | Futures | 1102.74 | 1103.23 | 1102.0 | 1102.74 | 2693.0 |
| 2010-08-04 22:30:00 | ES | Futures | 1102.74 | 1103.47 | 1102.49 | 1102.98 | 1109.0 |
| 2010-08-04 23:00:00 | ES | Futures | 1102.98 | 1102.98 | 1102.0 | 1102.24 | 1604.0 |
| 2010-08-04 23:30:00 | ES | Futures | 1102.0 | 1102.49 | 1101.75 | 1102.0 | 1532.0 |
| 2010-08-04 00:00:00 | NQ | Futures | 2168.45 | 2168.73 | 2165.58 | 2166.44 | 132.0 |
| 2010-08-04 00:30:00 | NQ | Futures | 2166.73 | 2166.73 | 2165.58 | 2166.44 | 109.0 |
| 2010-08-04 01:00:00 | NQ | Futures | 2166.44 | 2166.44 | 2165.58 | 2165.87 | 40.0 |
> showing 50 of 2,547 rows — these rows as CSV