PREVIEW / futures_30min / 2008-07-25
file: by_date/futures_30min/2008/2008-07-25.parquet size: 57 KB rows: 1,827
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-25 00:00:00 | ES | Futures | 1163.24 | 1163.7 | 1162.77 | 1163.01 | 1211.0 |
| 2008-07-25 00:30:00 | ES | Futures | 1162.77 | 1163.7 | 1162.77 | 1163.24 | 912.0 |
| 2008-07-25 01:00:00 | ES | Futures | 1163.47 | 1163.47 | 1162.54 | 1163.01 | 710.0 |
| 2008-07-25 01:30:00 | ES | Futures | 1163.01 | 1163.94 | 1162.77 | 1163.94 | 1042.0 |
| 2008-07-25 02:00:00 | ES | Futures | 1163.94 | 1164.87 | 1163.24 | 1163.94 | 3429.0 |
| 2008-07-25 02:30:00 | ES | Futures | 1163.94 | 1164.17 | 1162.54 | 1162.77 | 2447.0 |
| 2008-07-25 03:00:00 | ES | Futures | 1162.77 | 1164.4 | 1161.38 | 1163.24 | 12728.0 |
| 2008-07-25 03:30:00 | ES | Futures | 1163.01 | 1165.33 | 1162.77 | 1164.4 | 7726.0 |
| 2008-07-25 04:00:00 | ES | Futures | 1164.4 | 1167.89 | 1164.17 | 1167.19 | 8469.0 |
| 2008-07-25 04:30:00 | ES | Futures | 1166.96 | 1167.42 | 1164.63 | 1165.8 | 6618.0 |
| 2008-07-25 05:00:00 | ES | Futures | 1165.8 | 1165.8 | 1161.84 | 1162.54 | 9427.0 |
| 2008-07-25 05:30:00 | ES | Futures | 1162.77 | 1165.1 | 1162.08 | 1164.17 | 3973.0 |
| 2008-07-25 06:00:00 | ES | Futures | 1164.17 | 1165.56 | 1163.7 | 1164.63 | 2447.0 |
| 2008-07-25 06:30:00 | ES | Futures | 1164.87 | 1166.49 | 1163.01 | 1163.47 | 4808.0 |
| 2008-07-25 07:00:00 | ES | Futures | 1163.47 | 1165.1 | 1163.24 | 1164.63 | 5635.0 |
| 2008-07-25 07:30:00 | ES | Futures | 1164.87 | 1168.82 | 1164.87 | 1167.65 | 15195.0 |
| 2008-07-25 08:00:00 | ES | Futures | 1167.65 | 1167.89 | 1166.26 | 1166.49 | 8527.0 |
| 2008-07-25 08:30:00 | ES | Futures | 1166.49 | 1171.37 | 1166.49 | 1168.82 | 43792.0 |
| 2008-07-25 09:00:00 | ES | Futures | 1168.82 | 1170.21 | 1167.19 | 1169.75 | 29178.0 |
| 2008-07-25 09:30:00 | ES | Futures | 1169.75 | 1171.37 | 1164.17 | 1170.68 | 213607.0 |
| 2008-07-25 10:00:00 | ES | Futures | 1170.91 | 1173.93 | 1166.73 | 1166.96 | 216391.0 |
| 2008-07-25 10:30:00 | ES | Futures | 1166.96 | 1173.7 | 1166.49 | 1173.23 | 127855.0 |
| 2008-07-25 11:00:00 | ES | Futures | 1173.0 | 1173.47 | 1168.58 | 1169.51 | 76158.0 |
| 2008-07-25 11:30:00 | ES | Futures | 1169.51 | 1172.54 | 1169.05 | 1169.75 | 70636.0 |
| 2008-07-25 12:00:00 | ES | Futures | 1169.51 | 1170.44 | 1167.19 | 1168.82 | 56141.0 |
| 2008-07-25 12:30:00 | ES | Futures | 1169.05 | 1170.68 | 1167.65 | 1170.44 | 44898.0 |
| 2008-07-25 13:00:00 | ES | Futures | 1170.21 | 1171.61 | 1165.56 | 1166.49 | 113487.0 |
| 2008-07-25 13:30:00 | ES | Futures | 1166.26 | 1167.65 | 1163.24 | 1166.26 | 92742.0 |
| 2008-07-25 14:00:00 | ES | Futures | 1166.26 | 1169.98 | 1166.03 | 1166.73 | 99827.0 |
| 2008-07-25 14:30:00 | ES | Futures | 1166.96 | 1169.98 | 1166.26 | 1169.51 | 64217.0 |
| 2008-07-25 15:00:00 | ES | Futures | 1169.51 | 1169.98 | 1165.1 | 1165.8 | 57816.0 |
| 2008-07-25 15:30:00 | ES | Futures | 1165.56 | 1169.98 | 1164.17 | 1167.89 | 116171.0 |
| 2008-07-25 16:00:00 | ES | Futures | 1167.89 | 1168.58 | 1164.87 | 1165.56 | 66469.0 |
| 2008-07-25 00:00:00 | NQ | Futures | 2044.97 | 2044.97 | 2042.44 | 2044.41 | 295.0 |
| 2008-07-25 00:30:00 | NQ | Futures | 2044.13 | 2045.25 | 2043.84 | 2045.25 | 407.0 |
| 2008-07-25 01:00:00 | NQ | Futures | 2044.69 | 2044.97 | 2043.84 | 2044.97 | 992.0 |
| 2008-07-25 01:30:00 | NQ | Futures | 2044.97 | 2046.66 | 2044.41 | 2045.81 | 21.0 |
| 2008-07-25 02:00:00 | NQ | Futures | 2046.38 | 2048.63 | 2045.81 | 2048.06 | 108.0 |
| 2008-07-25 02:30:00 | NQ | Futures | 2047.22 | 2047.22 | 2044.41 | 2044.41 | 184.0 |
| 2008-07-25 03:00:00 | NQ | Futures | 2044.41 | 2050.6 | 2044.13 | 2046.66 | 1872.0 |
| 2008-07-25 03:30:00 | NQ | Futures | 2046.38 | 2052.56 | 2045.81 | 2052.0 | 618.0 |
| 2008-07-25 04:00:00 | NQ | Futures | 2052.0 | 2057.91 | 2051.44 | 2056.22 | 1247.0 |
| 2008-07-25 04:30:00 | NQ | Futures | 2056.5 | 2056.78 | 2051.72 | 2052.28 | 723.0 |
| 2008-07-25 05:00:00 | NQ | Futures | 2052.0 | 2052.28 | 2043.84 | 2046.09 | 410.0 |
| 2008-07-25 05:30:00 | NQ | Futures | 2046.09 | 2049.19 | 2045.25 | 2047.78 | 306.0 |
| 2008-07-25 06:00:00 | NQ | Futures | 2047.5 | 2048.91 | 2046.38 | 2047.22 | 374.0 |
| 2008-07-25 06:30:00 | NQ | Futures | 2048.06 | 2050.03 | 2044.13 | 2044.41 | 604.0 |
| 2008-07-25 07:00:00 | NQ | Futures | 2044.41 | 2047.22 | 2044.41 | 2046.66 | 398.0 |
| 2008-07-25 07:30:00 | NQ | Futures | 2046.94 | 2056.78 | 2046.94 | 2055.94 | 2092.0 |
| 2008-07-25 08:00:00 | NQ | Futures | 2055.66 | 2056.78 | 2052.85 | 2053.41 | 2307.0 |
> showing 50 of 1,827 rows — these rows as CSV