PREVIEW / futures_30min / 2010-06-02
file: by_date/futures_30min/2010/2010-06-02.parquet size: 72 KB rows: 2,514
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-02 00:00:00 | ES | Futures | 1047.86 | 1049.81 | 1046.14 | 1046.14 | 3649.0 |
| 2010-06-02 00:30:00 | ES | Futures | 1046.39 | 1046.88 | 1044.43 | 1045.66 | 5026.0 |
| 2010-06-02 01:00:00 | ES | Futures | 1045.41 | 1048.1 | 1043.94 | 1047.86 | 3123.0 |
| 2010-06-02 01:30:00 | ES | Futures | 1048.1 | 1049.81 | 1047.37 | 1049.08 | 4905.0 |
| 2010-06-02 02:00:00 | ES | Futures | 1049.08 | 1050.54 | 1048.1 | 1049.08 | 5905.0 |
| 2010-06-02 02:30:00 | ES | Futures | 1049.08 | 1050.79 | 1047.61 | 1050.54 | 5858.0 |
| 2010-06-02 03:00:00 | ES | Futures | 1050.3 | 1053.97 | 1048.83 | 1052.74 | 30456.0 |
| 2010-06-02 03:30:00 | ES | Futures | 1052.74 | 1052.74 | 1048.34 | 1049.08 | 20324.0 |
| 2010-06-02 04:00:00 | ES | Futures | 1049.08 | 1051.03 | 1046.14 | 1046.88 | 15722.0 |
| 2010-06-02 04:30:00 | ES | Futures | 1047.12 | 1047.86 | 1044.92 | 1046.63 | 17540.0 |
| 2010-06-02 05:00:00 | ES | Futures | 1046.63 | 1049.57 | 1046.63 | 1049.08 | 10638.0 |
| 2010-06-02 05:30:00 | ES | Futures | 1049.08 | 1053.72 | 1048.83 | 1052.26 | 12880.0 |
| 2010-06-02 06:00:00 | ES | Futures | 1052.01 | 1052.74 | 1050.06 | 1050.54 | 10706.0 |
| 2010-06-02 06:30:00 | ES | Futures | 1050.54 | 1052.26 | 1048.34 | 1052.01 | 14071.0 |
| 2010-06-02 07:00:00 | ES | Futures | 1051.77 | 1052.99 | 1049.81 | 1052.26 | 15587.0 |
| 2010-06-02 07:30:00 | ES | Futures | 1052.01 | 1052.5 | 1050.06 | 1051.77 | 15759.0 |
| 2010-06-02 08:00:00 | ES | Futures | 1051.77 | 1052.01 | 1049.32 | 1049.81 | 19072.0 |
| 2010-06-02 08:30:00 | ES | Futures | 1049.81 | 1050.54 | 1047.86 | 1049.08 | 32898.0 |
| 2010-06-02 09:00:00 | ES | Futures | 1049.08 | 1051.77 | 1048.59 | 1051.77 | 34824.0 |
| 2010-06-02 09:30:00 | ES | Futures | 1051.77 | 1053.72 | 1046.88 | 1050.3 | 245493.0 |
| 2010-06-02 10:00:00 | ES | Futures | 1050.3 | 1055.92 | 1048.83 | 1053.48 | 222496.0 |
| 2010-06-02 10:30:00 | ES | Futures | 1053.23 | 1056.65 | 1051.03 | 1053.97 | 144145.0 |
| 2010-06-02 11:00:00 | ES | Futures | 1053.97 | 1058.37 | 1053.72 | 1056.65 | 137608.0 |
| 2010-06-02 11:30:00 | ES | Futures | 1056.65 | 1061.3 | 1055.68 | 1060.32 | 109901.0 |
| 2010-06-02 12:00:00 | ES | Futures | 1060.08 | 1062.03 | 1058.85 | 1059.59 | 69948.0 |
| 2010-06-02 12:30:00 | ES | Futures | 1059.83 | 1062.03 | 1059.34 | 1061.54 | 44953.0 |
| 2010-06-02 13:00:00 | ES | Futures | 1061.54 | 1062.77 | 1059.59 | 1060.32 | 60980.0 |
| 2010-06-02 13:30:00 | ES | Futures | 1060.32 | 1061.54 | 1058.37 | 1059.1 | 65931.0 |
| 2010-06-02 14:00:00 | ES | Futures | 1058.85 | 1059.34 | 1056.17 | 1058.85 | 90890.0 |
| 2010-06-02 14:30:00 | ES | Futures | 1058.61 | 1066.43 | 1058.37 | 1065.21 | 153566.0 |
| 2010-06-02 15:00:00 | ES | Futures | 1065.45 | 1069.61 | 1064.97 | 1069.12 | 139831.0 |
| 2010-06-02 15:30:00 | ES | Futures | 1069.12 | 1073.76 | 1066.43 | 1073.28 | 272760.0 |
| 2010-06-02 16:00:00 | ES | Futures | 1073.28 | 1073.52 | 1071.56 | 1072.54 | 100241.0 |
| 2010-06-02 16:30:00 | ES | Futures | 1072.54 | 1073.52 | 1071.81 | 1073.28 | 7499.0 |
| 2010-06-02 17:00:00 | ES | Futures | 1073.52 | 1075.23 | 1073.03 | 1074.74 | 3752.0 |
| 2010-06-02 18:00:00 | ES | Futures | 1074.74 | 1074.74 | 1072.05 | 1072.54 | 3161.0 |
| 2010-06-02 18:30:00 | ES | Futures | 1072.54 | 1073.03 | 1071.56 | 1072.3 | 2302.0 |
| 2010-06-02 19:00:00 | ES | Futures | 1072.05 | 1072.79 | 1071.81 | 1072.79 | 1080.0 |
| 2010-06-02 19:30:00 | ES | Futures | 1072.54 | 1073.76 | 1072.05 | 1072.54 | 2050.0 |
| 2010-06-02 20:00:00 | ES | Futures | 1072.54 | 1073.28 | 1071.56 | 1071.81 | 3663.0 |
| 2010-06-02 20:30:00 | ES | Futures | 1071.56 | 1074.5 | 1070.83 | 1073.52 | 5456.0 |
| 2010-06-02 21:00:00 | ES | Futures | 1073.52 | 1075.48 | 1073.52 | 1075.23 | 4979.0 |
| 2010-06-02 21:30:00 | ES | Futures | 1075.23 | 1076.45 | 1073.76 | 1074.74 | 5717.0 |
| 2010-06-02 22:00:00 | ES | Futures | 1074.5 | 1075.23 | 1073.52 | 1074.5 | 2796.0 |
| 2010-06-02 22:30:00 | ES | Futures | 1074.25 | 1075.72 | 1073.76 | 1074.01 | 1868.0 |
| 2010-06-02 23:00:00 | ES | Futures | 1074.25 | 1076.21 | 1074.01 | 1076.21 | 1401.0 |
| 2010-06-02 23:30:00 | ES | Futures | 1075.96 | 1077.19 | 1075.23 | 1075.48 | 3236.0 |
| 2010-06-02 00:00:00 | NQ | Futures | 2105.12 | 2107.99 | 2103.12 | 2103.41 | 148.0 |
| 2010-06-02 00:30:00 | NQ | Futures | 2103.41 | 2103.69 | 2099.68 | 2100.26 | 240.0 |
| 2010-06-02 01:00:00 | NQ | Futures | 2100.26 | 2105.41 | 2098.54 | 2104.27 | 254.0 |
> showing 50 of 2,514 rows — these rows as CSV