PREVIEW / futures_30min / 2010-02-04
file: by_date/futures_30min/2010/2010-02-04.parquet size: 77 KB rows: 2,628
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-02-04 00:00:00 | ES | Futures | 1065.23 | 1066.45 | 1064.99 | 1066.2 | 1524.0 |
| 2010-02-04 00:30:00 | ES | Futures | 1066.2 | 1066.45 | 1065.23 | 1065.47 | 1627.0 |
| 2010-02-04 01:00:00 | ES | Futures | 1065.47 | 1066.2 | 1065.23 | 1065.23 | 701.0 |
| 2010-02-04 01:30:00 | ES | Futures | 1065.23 | 1065.72 | 1064.5 | 1064.74 | 1266.0 |
| 2010-02-04 02:00:00 | ES | Futures | 1064.74 | 1064.99 | 1063.28 | 1064.5 | 4955.0 |
| 2010-02-04 02:30:00 | ES | Futures | 1064.5 | 1064.99 | 1062.8 | 1062.8 | 4488.0 |
| 2010-02-04 03:00:00 | ES | Futures | 1062.8 | 1065.23 | 1062.55 | 1064.74 | 14895.0 |
| 2010-02-04 03:30:00 | ES | Futures | 1064.74 | 1064.74 | 1061.34 | 1061.58 | 19562.0 |
| 2010-02-04 04:00:00 | ES | Futures | 1061.34 | 1062.07 | 1058.91 | 1059.39 | 33055.0 |
| 2010-02-04 04:30:00 | ES | Futures | 1059.39 | 1060.85 | 1059.15 | 1060.12 | 15931.0 |
| 2010-02-04 05:00:00 | ES | Futures | 1060.12 | 1060.61 | 1058.66 | 1060.61 | 12589.0 |
| 2010-02-04 05:30:00 | ES | Futures | 1060.61 | 1060.85 | 1058.18 | 1059.88 | 12869.0 |
| 2010-02-04 06:00:00 | ES | Futures | 1059.64 | 1060.61 | 1059.15 | 1059.88 | 10555.0 |
| 2010-02-04 06:30:00 | ES | Futures | 1060.12 | 1061.09 | 1059.39 | 1060.12 | 9856.0 |
| 2010-02-04 07:00:00 | ES | Futures | 1059.88 | 1060.85 | 1058.91 | 1060.85 | 8317.0 |
| 2010-02-04 07:30:00 | ES | Futures | 1060.85 | 1062.31 | 1060.37 | 1060.85 | 17397.0 |
| 2010-02-04 08:00:00 | ES | Futures | 1060.85 | 1061.58 | 1059.88 | 1060.12 | 18748.0 |
| 2010-02-04 08:30:00 | ES | Futures | 1060.12 | 1060.12 | 1055.5 | 1056.47 | 87933.0 |
| 2010-02-04 09:00:00 | ES | Futures | 1056.47 | 1056.96 | 1054.77 | 1055.74 | 46295.0 |
| 2010-02-04 09:30:00 | ES | Futures | 1055.74 | 1056.47 | 1044.55 | 1045.77 | 377038.0 |
| 2010-02-04 10:00:00 | ES | Futures | 1045.53 | 1047.96 | 1041.39 | 1042.12 | 311750.0 |
| 2010-02-04 10:30:00 | ES | Futures | 1042.36 | 1045.04 | 1040.9 | 1041.15 | 218040.0 |
| 2010-02-04 11:00:00 | ES | Futures | 1041.15 | 1044.55 | 1040.42 | 1043.82 | 200432.0 |
| 2010-02-04 11:30:00 | ES | Futures | 1044.07 | 1044.07 | 1037.01 | 1040.9 | 269199.0 |
| 2010-02-04 12:00:00 | ES | Futures | 1040.66 | 1041.39 | 1038.47 | 1039.44 | 109939.0 |
| 2010-02-04 12:30:00 | ES | Futures | 1039.44 | 1040.66 | 1036.04 | 1039.2 | 150622.0 |
| 2010-02-04 13:00:00 | ES | Futures | 1038.96 | 1039.93 | 1037.5 | 1039.44 | 74113.0 |
| 2010-02-04 13:30:00 | ES | Futures | 1039.2 | 1039.69 | 1035.8 | 1036.53 | 155716.0 |
| 2010-02-04 14:00:00 | ES | Futures | 1036.77 | 1040.17 | 1035.07 | 1039.44 | 185405.0 |
| 2010-02-04 14:30:00 | ES | Futures | 1039.2 | 1040.66 | 1038.47 | 1038.96 | 123223.0 |
| 2010-02-04 15:00:00 | ES | Futures | 1039.2 | 1039.44 | 1033.61 | 1034.82 | 213279.0 |
| 2010-02-04 15:30:00 | ES | Futures | 1034.82 | 1035.55 | 1030.69 | 1031.17 | 358380.0 |
| 2010-02-04 16:00:00 | ES | Futures | 1031.17 | 1033.85 | 1030.93 | 1033.12 | 185497.0 |
| 2010-02-04 16:30:00 | ES | Futures | 1033.12 | 1034.09 | 1032.39 | 1032.88 | 9151.0 |
| 2010-02-04 17:00:00 | ES | Futures | 1032.88 | 1033.85 | 1032.39 | 1033.61 | 2387.0 |
| 2010-02-04 18:00:00 | ES | Futures | 1034.09 | 1035.07 | 1033.85 | 1034.34 | 5163.0 |
| 2010-02-04 18:30:00 | ES | Futures | 1034.34 | 1035.07 | 1034.09 | 1034.82 | 1692.0 |
| 2010-02-04 19:00:00 | ES | Futures | 1034.58 | 1035.07 | 1034.09 | 1034.82 | 4080.0 |
| 2010-02-04 19:30:00 | ES | Futures | 1034.58 | 1035.07 | 1033.12 | 1033.85 | 4151.0 |
| 2010-02-04 20:00:00 | ES | Futures | 1033.85 | 1034.82 | 1032.39 | 1032.88 | 6207.0 |
| 2010-02-04 20:30:00 | ES | Futures | 1032.63 | 1035.07 | 1032.63 | 1034.82 | 3963.0 |
| 2010-02-04 21:00:00 | ES | Futures | 1035.07 | 1035.31 | 1034.34 | 1035.07 | 3099.0 |
| 2010-02-04 21:30:00 | ES | Futures | 1035.07 | 1035.31 | 1034.09 | 1034.82 | 2801.0 |
| 2010-02-04 22:00:00 | ES | Futures | 1035.07 | 1035.31 | 1034.58 | 1035.07 | 1248.0 |
| 2010-02-04 22:30:00 | ES | Futures | 1034.82 | 1035.8 | 1034.58 | 1035.55 | 3073.0 |
| 2010-02-04 23:00:00 | ES | Futures | 1035.55 | 1036.04 | 1035.31 | 1035.8 | 2878.0 |
| 2010-02-04 23:30:00 | ES | Futures | 1035.8 | 1036.04 | 1035.31 | 1035.31 | 935.0 |
| 2010-02-04 00:00:00 | NQ | Futures | 2041.39 | 2042.25 | 2041.11 | 2041.68 | 384.0 |
| 2010-02-04 00:30:00 | NQ | Futures | 2041.96 | 2042.25 | 2040.25 | 2040.25 | 322.0 |
| 2010-02-04 01:00:00 | NQ | Futures | 2040.53 | 2041.39 | 2039.68 | 2040.25 | 95.0 |
> showing 50 of 2,628 rows — these rows as CSV