PREVIEW / futures_30min / 2010-07-08
file: by_date/futures_30min/2010/2010-07-08.parquet size: 70 KB rows: 2,517
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-07-08 00:00:00 | ES | Futures | 1039.67 | 1040.41 | 1039.43 | 1040.41 | 988.0 |
| 2010-07-08 00:30:00 | ES | Futures | 1040.16 | 1040.65 | 1038.2 | 1038.45 | 2452.0 |
| 2010-07-08 01:00:00 | ES | Futures | 1038.45 | 1039.43 | 1037.96 | 1039.18 | 2714.0 |
| 2010-07-08 01:30:00 | ES | Futures | 1039.18 | 1040.16 | 1037.22 | 1037.71 | 5890.0 |
| 2010-07-08 02:00:00 | ES | Futures | 1037.46 | 1038.94 | 1036.73 | 1038.69 | 10360.0 |
| 2010-07-08 02:30:00 | ES | Futures | 1038.45 | 1038.69 | 1037.22 | 1037.22 | 7728.0 |
| 2010-07-08 03:00:00 | ES | Futures | 1037.22 | 1038.2 | 1036.24 | 1036.97 | 18037.0 |
| 2010-07-08 03:30:00 | ES | Futures | 1037.22 | 1038.2 | 1036.48 | 1036.97 | 12117.0 |
| 2010-07-08 04:00:00 | ES | Futures | 1036.97 | 1037.96 | 1035.99 | 1036.97 | 13551.0 |
| 2010-07-08 04:30:00 | ES | Futures | 1037.22 | 1037.46 | 1035.99 | 1036.24 | 7865.0 |
| 2010-07-08 05:00:00 | ES | Futures | 1036.48 | 1038.69 | 1035.5 | 1037.96 | 13356.0 |
| 2010-07-08 05:30:00 | ES | Futures | 1038.2 | 1038.2 | 1036.48 | 1036.97 | 15416.0 |
| 2010-07-08 06:00:00 | ES | Futures | 1036.97 | 1037.71 | 1036.73 | 1037.46 | 10417.0 |
| 2010-07-08 06:30:00 | ES | Futures | 1037.46 | 1039.43 | 1037.22 | 1038.94 | 5530.0 |
| 2010-07-08 07:00:00 | ES | Futures | 1038.94 | 1039.43 | 1037.71 | 1037.71 | 6028.0 |
| 2010-07-08 07:30:00 | ES | Futures | 1037.96 | 1038.45 | 1036.97 | 1038.2 | 5954.0 |
| 2010-07-08 08:00:00 | ES | Futures | 1038.2 | 1040.41 | 1037.96 | 1039.92 | 21456.0 |
| 2010-07-08 08:30:00 | ES | Futures | 1039.92 | 1045.56 | 1039.67 | 1044.09 | 85750.0 |
| 2010-07-08 09:00:00 | ES | Futures | 1044.09 | 1046.3 | 1043.6 | 1044.83 | 49407.0 |
| 2010-07-08 09:30:00 | ES | Futures | 1044.83 | 1048.02 | 1040.9 | 1042.86 | 259719.0 |
| 2010-07-08 10:00:00 | ES | Futures | 1042.86 | 1044.83 | 1040.41 | 1044.34 | 173482.0 |
| 2010-07-08 10:30:00 | ES | Futures | 1044.58 | 1044.58 | 1039.67 | 1040.41 | 144078.0 |
| 2010-07-08 11:00:00 | ES | Futures | 1040.41 | 1041.39 | 1037.46 | 1039.18 | 151338.0 |
| 2010-07-08 11:30:00 | ES | Futures | 1039.18 | 1040.65 | 1035.75 | 1036.97 | 124010.0 |
| 2010-07-08 12:00:00 | ES | Futures | 1037.22 | 1040.16 | 1036.24 | 1039.18 | 80212.0 |
| 2010-07-08 12:30:00 | ES | Futures | 1039.18 | 1039.67 | 1037.22 | 1037.71 | 62767.0 |
| 2010-07-08 13:00:00 | ES | Futures | 1037.96 | 1042.37 | 1037.71 | 1040.16 | 75062.0 |
| 2010-07-08 13:30:00 | ES | Futures | 1039.92 | 1041.39 | 1037.96 | 1038.69 | 53317.0 |
| 2010-07-08 14:00:00 | ES | Futures | 1038.94 | 1039.67 | 1034.52 | 1036.97 | 104627.0 |
| 2010-07-08 14:30:00 | ES | Futures | 1036.73 | 1040.9 | 1036.24 | 1039.67 | 72674.0 |
| 2010-07-08 15:00:00 | ES | Futures | 1039.92 | 1042.86 | 1037.22 | 1042.62 | 102151.0 |
| 2010-07-08 15:30:00 | ES | Futures | 1042.86 | 1046.79 | 1042.37 | 1046.54 | 241325.0 |
| 2010-07-08 16:00:00 | ES | Futures | 1046.79 | 1048.75 | 1046.3 | 1047.28 | 108766.0 |
| 2010-07-08 16:30:00 | ES | Futures | 1047.03 | 1047.28 | 1046.54 | 1046.79 | 3649.0 |
| 2010-07-08 17:00:00 | ES | Futures | 1046.79 | 1047.28 | 1045.81 | 1047.28 | 2258.0 |
| 2010-07-08 18:00:00 | ES | Futures | 1047.03 | 1047.28 | 1045.81 | 1046.05 | 1723.0 |
| 2010-07-08 18:30:00 | ES | Futures | 1045.81 | 1046.54 | 1045.56 | 1046.05 | 922.0 |
| 2010-07-08 19:00:00 | ES | Futures | 1046.05 | 1046.54 | 1045.81 | 1046.54 | 668.0 |
| 2010-07-08 19:30:00 | ES | Futures | 1046.54 | 1046.79 | 1044.58 | 1045.56 | 2498.0 |
| 2010-07-08 20:00:00 | ES | Futures | 1045.56 | 1045.81 | 1044.83 | 1045.32 | 2933.0 |
| 2010-07-08 20:30:00 | ES | Futures | 1045.07 | 1045.56 | 1044.58 | 1044.58 | 2507.0 |
| 2010-07-08 21:00:00 | ES | Futures | 1044.58 | 1045.32 | 1044.58 | 1044.83 | 1945.0 |
| 2010-07-08 21:30:00 | ES | Futures | 1044.83 | 1046.3 | 1044.83 | 1045.81 | 2171.0 |
| 2010-07-08 22:00:00 | ES | Futures | 1045.81 | 1046.3 | 1045.32 | 1046.3 | 1164.0 |
| 2010-07-08 22:30:00 | ES | Futures | 1046.05 | 1048.02 | 1045.81 | 1047.77 | 2891.0 |
| 2010-07-08 23:00:00 | ES | Futures | 1047.53 | 1048.02 | 1046.54 | 1047.77 | 1880.0 |
| 2010-07-08 23:30:00 | ES | Futures | 1047.53 | 1048.26 | 1046.79 | 1048.02 | 1990.0 |
| 2010-07-08 00:00:00 | NQ | Futures | 2051.53 | 2052.39 | 2051.24 | 2052.39 | 104.0 |
| 2010-07-08 00:30:00 | NQ | Futures | 2052.39 | 2052.67 | 2048.95 | 2049.52 | 247.0 |
| 2010-07-08 01:00:00 | NQ | Futures | 2049.52 | 2050.67 | 2048.95 | 2050.09 | 233.0 |
> showing 50 of 2,517 rows — these rows as CSV