PREVIEW / futures_30min / 2010-06-01
file: by_date/futures_30min/2010/2010-06-01.parquet size: 74 KB rows: 2,540
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-01 00:00:00 | ES | Futures | 1058.12 | 1058.37 | 1056.65 | 1057.39 | 2067.0 |
| 2010-06-01 00:30:00 | ES | Futures | 1057.39 | 1058.37 | 1055.92 | 1057.88 | 2486.0 |
| 2010-06-01 01:00:00 | ES | Futures | 1058.12 | 1060.32 | 1057.88 | 1059.34 | 2560.0 |
| 2010-06-01 01:30:00 | ES | Futures | 1059.1 | 1061.79 | 1059.1 | 1060.08 | 2785.0 |
| 2010-06-01 02:00:00 | ES | Futures | 1060.08 | 1063.5 | 1060.08 | 1061.3 | 8093.0 |
| 2010-06-01 02:30:00 | ES | Futures | 1061.3 | 1061.79 | 1058.37 | 1060.57 | 4424.0 |
| 2010-06-01 03:00:00 | ES | Futures | 1060.57 | 1061.79 | 1051.77 | 1052.99 | 30735.0 |
| 2010-06-01 03:30:00 | ES | Futures | 1052.74 | 1054.45 | 1049.08 | 1051.77 | 23950.0 |
| 2010-06-01 04:00:00 | ES | Futures | 1052.01 | 1053.23 | 1050.06 | 1050.79 | 15212.0 |
| 2010-06-01 04:30:00 | ES | Futures | 1050.79 | 1052.01 | 1045.17 | 1048.1 | 25425.0 |
| 2010-06-01 05:00:00 | ES | Futures | 1048.1 | 1048.59 | 1045.41 | 1047.12 | 12656.0 |
| 2010-06-01 05:30:00 | ES | Futures | 1047.12 | 1049.32 | 1046.88 | 1048.59 | 11213.0 |
| 2010-06-01 06:00:00 | ES | Futures | 1048.83 | 1050.06 | 1047.86 | 1049.57 | 8265.0 |
| 2010-06-01 06:30:00 | ES | Futures | 1049.57 | 1050.06 | 1048.59 | 1049.57 | 6072.0 |
| 2010-06-01 07:00:00 | ES | Futures | 1049.57 | 1052.01 | 1048.34 | 1050.06 | 19534.0 |
| 2010-06-01 07:30:00 | ES | Futures | 1050.06 | 1051.52 | 1048.83 | 1049.81 | 24432.0 |
| 2010-06-01 08:00:00 | ES | Futures | 1049.81 | 1050.79 | 1048.34 | 1049.32 | 24785.0 |
| 2010-06-01 08:30:00 | ES | Futures | 1049.32 | 1051.52 | 1049.08 | 1050.3 | 18821.0 |
| 2010-06-01 09:00:00 | ES | Futures | 1050.06 | 1054.7 | 1050.06 | 1054.21 | 48233.0 |
| 2010-06-01 09:30:00 | ES | Futures | 1054.21 | 1059.59 | 1052.74 | 1056.41 | 241573.0 |
| 2010-06-01 10:00:00 | ES | Futures | 1056.17 | 1069.36 | 1056.17 | 1067.41 | 296175.0 |
| 2010-06-01 10:30:00 | ES | Futures | 1067.41 | 1070.1 | 1064.97 | 1065.94 | 166038.0 |
| 2010-06-01 11:00:00 | ES | Futures | 1066.19 | 1066.43 | 1062.03 | 1064.72 | 142816.0 |
| 2010-06-01 11:30:00 | ES | Futures | 1064.72 | 1065.7 | 1058.61 | 1059.59 | 137613.0 |
| 2010-06-01 12:00:00 | ES | Futures | 1059.34 | 1063.25 | 1058.61 | 1063.01 | 93862.0 |
| 2010-06-01 12:30:00 | ES | Futures | 1063.01 | 1064.23 | 1060.08 | 1060.32 | 67357.0 |
| 2010-06-01 13:00:00 | ES | Futures | 1060.08 | 1067.65 | 1060.08 | 1067.41 | 88545.0 |
| 2010-06-01 13:30:00 | ES | Futures | 1067.41 | 1068.14 | 1063.01 | 1063.01 | 85933.0 |
| 2010-06-01 14:00:00 | ES | Futures | 1063.25 | 1063.25 | 1057.63 | 1061.79 | 162528.0 |
| 2010-06-01 14:30:00 | ES | Futures | 1061.79 | 1064.72 | 1058.85 | 1061.54 | 95518.0 |
| 2010-06-01 15:00:00 | ES | Futures | 1061.54 | 1062.28 | 1053.72 | 1056.17 | 162221.0 |
| 2010-06-01 15:30:00 | ES | Futures | 1055.92 | 1058.85 | 1044.68 | 1046.14 | 305966.0 |
| 2010-06-01 16:00:00 | ES | Futures | 1046.14 | 1047.12 | 1044.92 | 1045.41 | 111656.0 |
| 2010-06-01 16:30:00 | ES | Futures | 1045.41 | 1046.39 | 1043.7 | 1046.39 | 11290.0 |
| 2010-06-01 17:00:00 | ES | Futures | 1046.14 | 1046.39 | 1043.94 | 1044.19 | 3169.0 |
| 2010-06-01 18:00:00 | ES | Futures | 1043.7 | 1045.66 | 1043.46 | 1045.41 | 5132.0 |
| 2010-06-01 18:30:00 | ES | Futures | 1045.17 | 1045.66 | 1044.92 | 1045.66 | 1052.0 |
| 2010-06-01 19:00:00 | ES | Futures | 1045.66 | 1047.86 | 1045.17 | 1046.63 | 4289.0 |
| 2010-06-01 19:30:00 | ES | Futures | 1046.88 | 1047.86 | 1046.14 | 1047.61 | 3305.0 |
| 2010-06-01 20:00:00 | ES | Futures | 1047.86 | 1048.1 | 1046.14 | 1046.39 | 3581.0 |
| 2010-06-01 20:30:00 | ES | Futures | 1046.63 | 1049.08 | 1046.14 | 1049.08 | 4222.0 |
| 2010-06-01 21:00:00 | ES | Futures | 1049.08 | 1050.06 | 1048.34 | 1049.81 | 4636.0 |
| 2010-06-01 21:30:00 | ES | Futures | 1049.81 | 1052.01 | 1049.57 | 1051.77 | 8797.0 |
| 2010-06-01 22:00:00 | ES | Futures | 1051.77 | 1051.77 | 1050.79 | 1051.28 | 2984.0 |
| 2010-06-01 22:30:00 | ES | Futures | 1051.28 | 1052.01 | 1051.03 | 1051.52 | 3181.0 |
| 2010-06-01 23:00:00 | ES | Futures | 1051.52 | 1051.77 | 1049.81 | 1050.06 | 2789.0 |
| 2010-06-01 23:30:00 | ES | Futures | 1050.3 | 1050.3 | 1047.12 | 1047.86 | 6499.0 |
| 2010-06-01 00:00:00 | NQ | Futures | 2116.87 | 2117.44 | 2113.72 | 2115.72 | 234.0 |
| 2010-06-01 00:30:00 | NQ | Futures | 2115.72 | 2116.87 | 2113.43 | 2116.01 | 234.0 |
| 2010-06-01 01:00:00 | NQ | Futures | 2116.01 | 2120.3 | 2116.01 | 2118.3 | 332.0 |
> showing 50 of 2,540 rows — these rows as CSV