PREVIEW / futures_30min / 2010-07-20
file: by_date/futures_30min/2010/2010-07-20.parquet size: 73 KB rows: 2,565
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-20 00:00:00 | ES | Futures | 1046.05 | 1047.03 | 1045.81 | 1046.3 | 2889.0 |
| 2010-07-20 00:30:00 | ES | Futures | 1046.05 | 1046.79 | 1045.32 | 1045.56 | 1900.0 |
| 2010-07-20 01:00:00 | ES | Futures | 1045.56 | 1047.03 | 1045.32 | 1046.54 | 2073.0 |
| 2010-07-20 01:30:00 | ES | Futures | 1046.79 | 1047.03 | 1043.35 | 1043.6 | 6270.0 |
| 2010-07-20 02:00:00 | ES | Futures | 1043.6 | 1046.79 | 1043.35 | 1045.56 | 6503.0 |
| 2010-07-20 02:30:00 | ES | Futures | 1045.56 | 1046.54 | 1045.07 | 1045.81 | 5707.0 |
| 2010-07-20 03:00:00 | ES | Futures | 1045.81 | 1046.79 | 1042.62 | 1043.35 | 18329.0 |
| 2010-07-20 03:30:00 | ES | Futures | 1043.35 | 1043.6 | 1040.41 | 1040.65 | 18898.0 |
| 2010-07-20 04:00:00 | ES | Futures | 1040.65 | 1042.13 | 1039.92 | 1041.64 | 16228.0 |
| 2010-07-20 04:30:00 | ES | Futures | 1041.64 | 1043.11 | 1041.64 | 1042.13 | 7828.0 |
| 2010-07-20 05:00:00 | ES | Futures | 1041.88 | 1042.37 | 1040.41 | 1040.65 | 7819.0 |
| 2010-07-20 05:30:00 | ES | Futures | 1040.65 | 1040.9 | 1035.5 | 1036.48 | 33697.0 |
| 2010-07-20 06:00:00 | ES | Futures | 1036.48 | 1036.48 | 1033.05 | 1034.03 | 28486.0 |
| 2010-07-20 06:30:00 | ES | Futures | 1033.78 | 1036.24 | 1033.29 | 1035.75 | 11142.0 |
| 2010-07-20 07:00:00 | ES | Futures | 1035.75 | 1037.22 | 1035.5 | 1036.73 | 9406.0 |
| 2010-07-20 07:30:00 | ES | Futures | 1036.73 | 1037.22 | 1033.78 | 1036.24 | 18962.0 |
| 2010-07-20 08:00:00 | ES | Futures | 1036.24 | 1036.73 | 1031.58 | 1032.07 | 91388.0 |
| 2010-07-20 08:30:00 | ES | Futures | 1032.07 | 1036.48 | 1031.33 | 1035.26 | 61641.0 |
| 2010-07-20 09:00:00 | ES | Futures | 1035.26 | 1036.24 | 1033.78 | 1034.03 | 31551.0 |
| 2010-07-20 09:30:00 | ES | Futures | 1033.78 | 1040.16 | 1033.54 | 1038.69 | 198621.0 |
| 2010-07-20 10:00:00 | ES | Futures | 1038.69 | 1041.39 | 1035.5 | 1039.92 | 178340.0 |
| 2010-07-20 10:30:00 | ES | Futures | 1039.92 | 1042.13 | 1038.94 | 1040.16 | 127385.0 |
| 2010-07-20 11:00:00 | ES | Futures | 1040.41 | 1045.56 | 1039.92 | 1044.83 | 142419.0 |
| 2010-07-20 11:30:00 | ES | Futures | 1044.58 | 1045.32 | 1041.39 | 1041.64 | 80279.0 |
| 2010-07-20 12:00:00 | ES | Futures | 1041.64 | 1043.84 | 1040.16 | 1041.39 | 67159.0 |
| 2010-07-20 12:30:00 | ES | Futures | 1041.15 | 1044.34 | 1040.9 | 1043.84 | 40943.0 |
| 2010-07-20 13:00:00 | ES | Futures | 1044.09 | 1046.05 | 1043.35 | 1045.81 | 66101.0 |
| 2010-07-20 13:30:00 | ES | Futures | 1045.56 | 1055.13 | 1045.32 | 1054.89 | 223363.0 |
| 2010-07-20 14:00:00 | ES | Futures | 1054.64 | 1054.89 | 1050.47 | 1052.43 | 135936.0 |
| 2010-07-20 14:30:00 | ES | Futures | 1052.43 | 1054.64 | 1051.45 | 1052.43 | 104267.0 |
| 2010-07-20 15:00:00 | ES | Futures | 1052.68 | 1058.57 | 1051.45 | 1057.34 | 155394.0 |
| 2010-07-20 15:30:00 | ES | Futures | 1057.34 | 1060.53 | 1056.6 | 1059.55 | 242090.0 |
| 2010-07-20 16:00:00 | ES | Futures | 1059.55 | 1060.78 | 1058.81 | 1060.53 | 71014.0 |
| 2010-07-20 16:30:00 | ES | Futures | 1059.55 | 1064.95 | 1057.34 | 1061.51 | 35771.0 |
| 2010-07-20 17:00:00 | ES | Futures | 1061.76 | 1062.25 | 1060.53 | 1060.78 | 3417.0 |
| 2010-07-20 18:00:00 | ES | Futures | 1060.78 | 1061.51 | 1060.28 | 1060.28 | 3222.0 |
| 2010-07-20 18:30:00 | ES | Futures | 1060.28 | 1060.53 | 1060.04 | 1060.04 | 1790.0 |
| 2010-07-20 19:00:00 | ES | Futures | 1060.04 | 1060.78 | 1059.79 | 1060.78 | 956.0 |
| 2010-07-20 19:30:00 | ES | Futures | 1060.78 | 1061.76 | 1060.53 | 1061.02 | 2149.0 |
| 2010-07-20 20:00:00 | ES | Futures | 1061.02 | 1061.27 | 1058.32 | 1058.81 | 5490.0 |
| 2010-07-20 20:30:00 | ES | Futures | 1058.81 | 1059.06 | 1057.83 | 1057.83 | 2516.0 |
| 2010-07-20 21:00:00 | ES | Futures | 1058.08 | 1059.06 | 1057.34 | 1058.81 | 3065.0 |
| 2010-07-20 21:30:00 | ES | Futures | 1058.57 | 1060.53 | 1058.08 | 1058.81 | 4016.0 |
| 2010-07-20 22:00:00 | ES | Futures | 1058.81 | 1059.3 | 1057.59 | 1058.08 | 1604.0 |
| 2010-07-20 22:30:00 | ES | Futures | 1057.83 | 1059.79 | 1057.83 | 1059.3 | 1645.0 |
| 2010-07-20 23:00:00 | ES | Futures | 1059.06 | 1059.3 | 1058.08 | 1058.08 | 857.0 |
| 2010-07-20 23:30:00 | ES | Futures | 1058.08 | 1058.08 | 1056.6 | 1057.59 | 3637.0 |
| 2010-07-20 00:00:00 | NQ | Futures | 2071.59 | 2072.73 | 2071.59 | 2071.59 | 206.0 |
| 2010-07-20 00:30:00 | NQ | Futures | 2071.3 | 2072.16 | 2069.29 | 2070.44 | 267.0 |
| 2010-07-20 01:00:00 | NQ | Futures | 2070.44 | 2075.88 | 2069.87 | 2073.88 | 475.0 |
> showing 50 of 2,565 rows — these rows as CSV