PREVIEW / futures_30min / 2010-09-01
file: by_date/futures_30min/2010/2010-09-01.parquet size: 72 KB rows: 2,516
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-09-01 00:00:00 | ES | Futures | 1037.96 | 1038.45 | 1036.73 | 1037.22 | 2410.0 |
| 2010-09-01 00:30:00 | ES | Futures | 1037.46 | 1037.71 | 1036.48 | 1037.46 | 1260.0 |
| 2010-09-01 01:00:00 | ES | Futures | 1037.46 | 1037.46 | 1036.48 | 1036.48 | 1237.0 |
| 2010-09-01 01:30:00 | ES | Futures | 1036.73 | 1037.46 | 1036.48 | 1036.97 | 1870.0 |
| 2010-09-01 02:00:00 | ES | Futures | 1036.73 | 1038.2 | 1035.75 | 1036.97 | 4737.0 |
| 2010-09-01 02:30:00 | ES | Futures | 1036.97 | 1037.22 | 1035.75 | 1036.48 | 4169.0 |
| 2010-09-01 03:00:00 | ES | Futures | 1036.48 | 1036.73 | 1032.56 | 1033.05 | 19334.0 |
| 2010-09-01 03:30:00 | ES | Futures | 1033.05 | 1033.54 | 1031.33 | 1033.29 | 16651.0 |
| 2010-09-01 04:00:00 | ES | Futures | 1033.29 | 1035.26 | 1033.05 | 1034.03 | 16579.0 |
| 2010-09-01 04:30:00 | ES | Futures | 1034.03 | 1038.94 | 1033.29 | 1038.69 | 15684.0 |
| 2010-09-01 05:00:00 | ES | Futures | 1038.69 | 1039.67 | 1037.46 | 1039.67 | 18024.0 |
| 2010-09-01 05:30:00 | ES | Futures | 1039.43 | 1043.11 | 1039.43 | 1040.65 | 34596.0 |
| 2010-09-01 06:00:00 | ES | Futures | 1040.65 | 1042.13 | 1040.16 | 1040.16 | 10233.0 |
| 2010-09-01 06:30:00 | ES | Futures | 1040.16 | 1041.39 | 1039.92 | 1041.39 | 6755.0 |
| 2010-09-01 07:00:00 | ES | Futures | 1041.39 | 1041.64 | 1039.67 | 1040.16 | 9377.0 |
| 2010-09-01 07:30:00 | ES | Futures | 1039.92 | 1041.39 | 1039.92 | 1040.41 | 18324.0 |
| 2010-09-01 08:00:00 | ES | Futures | 1040.41 | 1042.13 | 1037.96 | 1041.64 | 64134.0 |
| 2010-09-01 08:30:00 | ES | Futures | 1041.88 | 1042.62 | 1040.9 | 1041.39 | 29362.0 |
| 2010-09-01 09:00:00 | ES | Futures | 1041.39 | 1042.86 | 1041.15 | 1042.13 | 34069.0 |
| 2010-09-01 09:30:00 | ES | Futures | 1041.88 | 1047.28 | 1041.39 | 1046.05 | 281965.0 |
| 2010-09-01 10:00:00 | ES | Futures | 1046.05 | 1056.85 | 1043.84 | 1054.64 | 429147.0 |
| 2010-09-01 10:30:00 | ES | Futures | 1054.64 | 1058.57 | 1053.91 | 1057.09 | 212334.0 |
| 2010-09-01 11:00:00 | ES | Futures | 1057.34 | 1058.08 | 1056.11 | 1057.09 | 104835.0 |
| 2010-09-01 11:30:00 | ES | Futures | 1057.09 | 1059.55 | 1056.85 | 1058.08 | 86254.0 |
| 2010-09-01 12:00:00 | ES | Futures | 1057.83 | 1058.57 | 1056.11 | 1056.85 | 65478.0 |
| 2010-09-01 12:30:00 | ES | Futures | 1056.85 | 1057.09 | 1055.87 | 1056.6 | 48212.0 |
| 2010-09-01 13:00:00 | ES | Futures | 1056.85 | 1057.83 | 1056.36 | 1057.34 | 40512.0 |
| 2010-09-01 13:30:00 | ES | Futures | 1057.09 | 1059.06 | 1057.09 | 1058.32 | 50119.0 |
| 2010-09-01 14:00:00 | ES | Futures | 1058.08 | 1059.06 | 1055.38 | 1056.85 | 82451.0 |
| 2010-09-01 14:30:00 | ES | Futures | 1056.6 | 1057.34 | 1055.38 | 1056.36 | 61676.0 |
| 2010-09-01 15:00:00 | ES | Futures | 1056.11 | 1058.08 | 1055.13 | 1056.36 | 103329.0 |
| 2010-09-01 15:30:00 | ES | Futures | 1056.36 | 1060.78 | 1055.62 | 1059.3 | 254250.0 |
| 2010-09-01 16:00:00 | ES | Futures | 1059.06 | 1062.49 | 1058.81 | 1062.0 | 162804.0 |
| 2010-09-01 16:30:00 | ES | Futures | 1061.51 | 1061.51 | 1060.53 | 1061.02 | 6683.0 |
| 2010-09-01 17:00:00 | ES | Futures | 1061.02 | 1061.76 | 1060.28 | 1060.28 | 2636.0 |
| 2010-09-01 18:00:00 | ES | Futures | 1060.28 | 1061.27 | 1060.04 | 1060.78 | 2262.0 |
| 2010-09-01 18:30:00 | ES | Futures | 1060.78 | 1061.02 | 1060.28 | 1060.28 | 570.0 |
| 2010-09-01 19:00:00 | ES | Futures | 1060.53 | 1061.02 | 1060.28 | 1060.78 | 787.0 |
| 2010-09-01 19:30:00 | ES | Futures | 1060.78 | 1062.25 | 1060.04 | 1061.02 | 3725.0 |
| 2010-09-01 20:00:00 | ES | Futures | 1061.27 | 1061.51 | 1059.3 | 1059.3 | 4654.0 |
| 2010-09-01 20:30:00 | ES | Futures | 1059.3 | 1059.55 | 1058.32 | 1058.57 | 5119.0 |
| 2010-09-01 21:00:00 | ES | Futures | 1058.57 | 1059.06 | 1058.32 | 1058.57 | 1695.0 |
| 2010-09-01 21:30:00 | ES | Futures | 1058.81 | 1059.06 | 1058.08 | 1058.81 | 2327.0 |
| 2010-09-01 22:00:00 | ES | Futures | 1058.81 | 1059.3 | 1058.08 | 1058.32 | 2285.0 |
| 2010-09-01 22:30:00 | ES | Futures | 1058.32 | 1059.06 | 1058.08 | 1058.32 | 1153.0 |
| 2010-09-01 23:00:00 | ES | Futures | 1058.32 | 1058.57 | 1057.83 | 1057.83 | 1086.0 |
| 2010-09-01 23:30:00 | ES | Futures | 1057.83 | 1058.08 | 1056.6 | 1056.85 | 4428.0 |
| 2010-09-01 00:00:00 | NQ | Futures | 2046.37 | 2046.65 | 2042.93 | 2044.65 | 193.0 |
| 2010-09-01 00:30:00 | NQ | Futures | 2044.08 | 2044.94 | 2042.93 | 2044.65 | 47.0 |
| 2010-09-01 01:00:00 | NQ | Futures | 2044.36 | 2044.65 | 2042.07 | 2042.07 | 176.0 |
> showing 50 of 2,516 rows — these rows as CSV