PREVIEW / futures_30min / 2010-06-25
file: by_date/futures_30min/2010/2010-06-25.parquet size: 59 KB rows: 2,007
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-06-25 00:00:00 | ES | Futures | 1052.19 | 1052.19 | 1050.96 | 1051.21 | 2239.0 |
| 2010-06-25 00:30:00 | ES | Futures | 1051.21 | 1052.43 | 1050.72 | 1052.43 | 2135.0 |
| 2010-06-25 01:00:00 | ES | Futures | 1052.43 | 1053.41 | 1052.43 | 1053.41 | 1941.0 |
| 2010-06-25 01:30:00 | ES | Futures | 1053.41 | 1053.91 | 1052.68 | 1053.91 | 2403.0 |
| 2010-06-25 02:00:00 | ES | Futures | 1054.15 | 1054.15 | 1051.94 | 1052.19 | 4300.0 |
| 2010-06-25 02:30:00 | ES | Futures | 1051.94 | 1053.41 | 1050.96 | 1052.92 | 4452.0 |
| 2010-06-25 03:00:00 | ES | Futures | 1052.92 | 1055.13 | 1050.72 | 1054.15 | 21604.0 |
| 2010-06-25 03:30:00 | ES | Futures | 1054.15 | 1055.87 | 1053.66 | 1053.91 | 16123.0 |
| 2010-06-25 04:00:00 | ES | Futures | 1053.91 | 1054.89 | 1050.47 | 1050.96 | 13298.0 |
| 2010-06-25 04:30:00 | ES | Futures | 1050.96 | 1051.21 | 1048.26 | 1049.0 | 24341.0 |
| 2010-06-25 05:00:00 | ES | Futures | 1048.75 | 1049.49 | 1047.28 | 1048.75 | 16830.0 |
| 2010-06-25 05:30:00 | ES | Futures | 1048.75 | 1049.24 | 1045.56 | 1047.77 | 21087.0 |
| 2010-06-25 06:00:00 | ES | Futures | 1047.77 | 1049.24 | 1047.28 | 1049.0 | 11138.0 |
| 2010-06-25 06:30:00 | ES | Futures | 1049.0 | 1051.45 | 1049.0 | 1051.45 | 13631.0 |
| 2010-06-25 07:00:00 | ES | Futures | 1051.21 | 1053.17 | 1050.22 | 1052.68 | 22082.0 |
| 2010-06-25 07:30:00 | ES | Futures | 1052.92 | 1055.38 | 1052.68 | 1054.4 | 25830.0 |
| 2010-06-25 08:00:00 | ES | Futures | 1054.4 | 1054.64 | 1051.45 | 1052.19 | 21358.0 |
| 2010-06-25 08:30:00 | ES | Futures | 1051.94 | 1052.68 | 1047.77 | 1050.22 | 82109.0 |
| 2010-06-25 09:00:00 | ES | Futures | 1050.22 | 1052.92 | 1049.73 | 1052.92 | 38185.0 |
| 2010-06-25 09:30:00 | ES | Futures | 1052.92 | 1052.92 | 1046.3 | 1049.98 | 239623.0 |
| 2010-06-25 10:00:00 | ES | Futures | 1050.22 | 1053.66 | 1047.28 | 1048.75 | 188432.0 |
| 2010-06-25 10:30:00 | ES | Futures | 1048.75 | 1049.24 | 1043.11 | 1044.34 | 211817.0 |
| 2010-06-25 11:00:00 | ES | Futures | 1044.34 | 1048.51 | 1044.09 | 1047.77 | 136919.0 |
| 2010-06-25 11:30:00 | ES | Futures | 1047.77 | 1050.96 | 1045.56 | 1049.24 | 119070.0 |
| 2010-06-25 12:00:00 | ES | Futures | 1049.0 | 1051.7 | 1047.77 | 1050.96 | 101325.0 |
| 2010-06-25 12:30:00 | ES | Futures | 1050.96 | 1052.43 | 1048.51 | 1049.73 | 86684.0 |
| 2010-06-25 13:00:00 | ES | Futures | 1049.73 | 1056.6 | 1049.24 | 1056.6 | 111457.0 |
| 2010-06-25 13:30:00 | ES | Futures | 1056.36 | 1059.55 | 1055.38 | 1057.59 | 144763.0 |
| 2010-06-25 14:00:00 | ES | Futures | 1057.59 | 1059.06 | 1055.38 | 1057.59 | 83411.0 |
| 2010-06-25 14:30:00 | ES | Futures | 1057.83 | 1059.06 | 1055.38 | 1056.85 | 63252.0 |
| 2010-06-25 15:00:00 | ES | Futures | 1056.6 | 1056.85 | 1052.19 | 1053.66 | 119527.0 |
| 2010-06-25 15:30:00 | ES | Futures | 1053.66 | 1057.59 | 1050.72 | 1054.4 | 294901.0 |
| 2010-06-25 16:00:00 | ES | Futures | 1054.4 | 1055.13 | 1050.96 | 1054.89 | 154232.0 |
| 2010-06-25 00:00:00 | NQ | Futures | 2116.0 | 2117.44 | 2114.0 | 2115.43 | 274.0 |
| 2010-06-25 00:30:00 | NQ | Futures | 2114.28 | 2116.58 | 2113.71 | 2116.29 | 95.0 |
| 2010-06-25 01:00:00 | NQ | Futures | 2116.58 | 2118.58 | 2116.0 | 2118.3 | 75.0 |
| 2010-06-25 01:30:00 | NQ | Futures | 2118.87 | 2120.3 | 2116.29 | 2120.3 | 176.0 |
| 2010-06-25 02:00:00 | NQ | Futures | 2120.02 | 2120.02 | 2116.29 | 2118.01 | 366.0 |
| 2010-06-25 02:30:00 | NQ | Futures | 2117.15 | 2119.73 | 2115.43 | 2118.87 | 515.0 |
| 2010-06-25 03:00:00 | NQ | Futures | 2118.58 | 2123.74 | 2114.0 | 2122.59 | 1940.0 |
| 2010-06-25 03:30:00 | NQ | Futures | 2122.88 | 2126.32 | 2121.45 | 2121.45 | 1329.0 |
| 2010-06-25 04:00:00 | NQ | Futures | 2121.73 | 2122.88 | 2115.14 | 2116.0 | 1225.0 |
| 2010-06-25 04:30:00 | NQ | Futures | 2116.0 | 2116.29 | 2111.13 | 2113.42 | 1658.0 |
| 2010-06-25 05:00:00 | NQ | Futures | 2113.42 | 2114.28 | 2109.7 | 2112.85 | 1050.0 |
| 2010-06-25 05:30:00 | NQ | Futures | 2112.85 | 2113.14 | 2105.97 | 2110.27 | 1158.0 |
| 2010-06-25 06:00:00 | NQ | Futures | 2110.56 | 2113.42 | 2109.41 | 2112.85 | 640.0 |
| 2010-06-25 06:30:00 | NQ | Futures | 2113.14 | 2117.44 | 2112.85 | 2117.44 | 1004.0 |
| 2010-06-25 07:00:00 | NQ | Futures | 2117.44 | 2121.16 | 2114.28 | 2120.88 | 1555.0 |
| 2010-06-25 07:30:00 | NQ | Futures | 2120.88 | 2124.31 | 2120.88 | 2122.59 | 1458.0 |
| 2010-06-25 08:00:00 | NQ | Futures | 2122.31 | 2122.59 | 2119.44 | 2119.73 | 3365.0 |
> showing 50 of 2,007 rows — these rows as CSV