PREVIEW / futures_30min / 2010-05-25
file: by_date/futures_30min/2010/2010-05-25.parquet size: 76 KB rows: 2,584
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-05-25 00:00:00 | ES | Futures | 1029.52 | 1031.97 | 1029.03 | 1031.48 | 5092.0 |
| 2010-05-25 00:30:00 | ES | Futures | 1031.48 | 1031.72 | 1029.28 | 1029.77 | 4989.0 |
| 2010-05-25 01:00:00 | ES | Futures | 1029.77 | 1030.99 | 1028.3 | 1028.55 | 4396.0 |
| 2010-05-25 01:30:00 | ES | Futures | 1028.55 | 1029.52 | 1028.06 | 1028.79 | 4769.0 |
| 2010-05-25 02:00:00 | ES | Futures | 1028.79 | 1031.72 | 1023.17 | 1023.66 | 31337.0 |
| 2010-05-25 02:30:00 | ES | Futures | 1023.66 | 1025.86 | 1019.01 | 1022.44 | 27049.0 |
| 2010-05-25 03:00:00 | ES | Futures | 1022.44 | 1025.12 | 1020.24 | 1021.95 | 47000.0 |
| 2010-05-25 03:30:00 | ES | Futures | 1021.95 | 1024.15 | 1018.28 | 1023.17 | 40475.0 |
| 2010-05-25 04:00:00 | ES | Futures | 1023.41 | 1024.63 | 1019.99 | 1024.39 | 24117.0 |
| 2010-05-25 04:30:00 | ES | Futures | 1024.39 | 1024.39 | 1018.28 | 1019.99 | 23245.0 |
| 2010-05-25 05:00:00 | ES | Futures | 1019.99 | 1022.19 | 1018.77 | 1021.7 | 13634.0 |
| 2010-05-25 05:30:00 | ES | Futures | 1021.7 | 1022.19 | 1018.52 | 1018.52 | 18703.0 |
| 2010-05-25 06:00:00 | ES | Futures | 1018.52 | 1019.99 | 1013.64 | 1019.5 | 40091.0 |
| 2010-05-25 06:30:00 | ES | Futures | 1019.75 | 1023.66 | 1018.04 | 1022.92 | 22305.0 |
| 2010-05-25 07:00:00 | ES | Futures | 1023.17 | 1023.41 | 1017.06 | 1020.97 | 32791.0 |
| 2010-05-25 07:30:00 | ES | Futures | 1020.72 | 1022.92 | 1018.28 | 1021.95 | 27091.0 |
| 2010-05-25 08:00:00 | ES | Futures | 1021.95 | 1025.37 | 1020.97 | 1024.15 | 60126.0 |
| 2010-05-25 08:30:00 | ES | Futures | 1024.15 | 1024.39 | 1019.01 | 1020.24 | 53436.0 |
| 2010-05-25 09:00:00 | ES | Futures | 1020.24 | 1022.68 | 1019.01 | 1022.44 | 54874.0 |
| 2010-05-25 09:30:00 | ES | Futures | 1022.68 | 1025.86 | 1015.35 | 1024.39 | 449819.0 |
| 2010-05-25 10:00:00 | ES | Futures | 1024.39 | 1030.99 | 1022.68 | 1025.86 | 324119.0 |
| 2010-05-25 10:30:00 | ES | Futures | 1025.61 | 1027.81 | 1022.19 | 1026.1 | 202522.0 |
| 2010-05-25 11:00:00 | ES | Futures | 1026.1 | 1032.21 | 1025.86 | 1029.52 | 196873.0 |
| 2010-05-25 11:30:00 | ES | Futures | 1029.52 | 1032.95 | 1026.35 | 1032.21 | 155335.0 |
| 2010-05-25 12:00:00 | ES | Futures | 1032.21 | 1035.15 | 1030.01 | 1030.26 | 154965.0 |
| 2010-05-25 12:30:00 | ES | Futures | 1030.26 | 1032.21 | 1027.57 | 1030.5 | 92662.0 |
| 2010-05-25 13:00:00 | ES | Futures | 1030.5 | 1031.48 | 1026.1 | 1029.52 | 98628.0 |
| 2010-05-25 13:30:00 | ES | Futures | 1029.52 | 1030.01 | 1025.61 | 1027.57 | 91744.0 |
| 2010-05-25 14:00:00 | ES | Futures | 1027.81 | 1034.9 | 1025.86 | 1032.95 | 131774.0 |
| 2010-05-25 14:30:00 | ES | Futures | 1033.19 | 1040.03 | 1030.99 | 1037.1 | 198258.0 |
| 2010-05-25 15:00:00 | ES | Futures | 1037.1 | 1044.92 | 1036.86 | 1043.94 | 246185.0 |
| 2010-05-25 15:30:00 | ES | Futures | 1044.19 | 1049.81 | 1042.97 | 1049.32 | 314442.0 |
| 2010-05-25 16:00:00 | ES | Futures | 1049.32 | 1050.79 | 1048.1 | 1048.59 | 126759.0 |
| 2010-05-25 16:30:00 | ES | Futures | 1048.59 | 1052.74 | 1048.1 | 1052.26 | 11766.0 |
| 2010-05-25 17:00:00 | ES | Futures | 1052.5 | 1060.32 | 1052.5 | 1059.34 | 15179.0 |
| 2010-05-25 18:00:00 | ES | Futures | 1059.34 | 1059.34 | 1054.45 | 1055.43 | 9130.0 |
| 2010-05-25 18:30:00 | ES | Futures | 1055.43 | 1056.9 | 1054.94 | 1055.68 | 3245.0 |
| 2010-05-25 19:00:00 | ES | Futures | 1055.92 | 1056.9 | 1055.19 | 1056.41 | 2788.0 |
| 2010-05-25 19:30:00 | ES | Futures | 1056.17 | 1058.37 | 1055.68 | 1057.88 | 8375.0 |
| 2010-05-25 20:00:00 | ES | Futures | 1057.88 | 1059.1 | 1056.41 | 1056.65 | 9339.0 |
| 2010-05-25 20:30:00 | ES | Futures | 1056.9 | 1057.63 | 1055.68 | 1055.92 | 5377.0 |
| 2010-05-25 21:00:00 | ES | Futures | 1055.68 | 1055.68 | 1051.28 | 1051.77 | 8911.0 |
| 2010-05-25 21:30:00 | ES | Futures | 1052.01 | 1053.48 | 1049.08 | 1049.81 | 10099.0 |
| 2010-05-25 22:00:00 | ES | Futures | 1049.81 | 1050.06 | 1047.86 | 1048.59 | 7317.0 |
| 2010-05-25 22:30:00 | ES | Futures | 1048.59 | 1052.26 | 1048.59 | 1051.77 | 3800.0 |
| 2010-05-25 23:00:00 | ES | Futures | 1051.52 | 1052.26 | 1049.32 | 1050.06 | 3260.0 |
| 2010-05-25 23:30:00 | ES | Futures | 1050.06 | 1054.7 | 1049.81 | 1053.97 | 6587.0 |
| 2010-05-25 00:00:00 | NQ | Futures | 2044.99 | 2048.71 | 2044.13 | 2048.42 | 514.0 |
| 2010-05-25 00:30:00 | NQ | Futures | 2048.42 | 2048.71 | 2044.7 | 2045.85 | 467.0 |
| 2010-05-25 01:00:00 | NQ | Futures | 2045.56 | 2047.56 | 2041.84 | 2042.41 | 401.0 |
> showing 50 of 2,584 rows — these rows as CSV