PREVIEW / futures_30min / 2010-06-07
file: by_date/futures_30min/2010/2010-06-07.parquet size: 70 KB rows: 2,469
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-06-07 00:00:00 | ES | Futures | 1033.19 | 1035.39 | 1032.7 | 1034.66 | 3268.0 |
| 2010-06-07 00:30:00 | ES | Futures | 1034.66 | 1036.12 | 1034.41 | 1035.15 | 2562.0 |
| 2010-06-07 01:00:00 | ES | Futures | 1035.15 | 1037.35 | 1033.68 | 1034.41 | 4297.0 |
| 2010-06-07 01:30:00 | ES | Futures | 1034.41 | 1038.08 | 1033.92 | 1036.12 | 5519.0 |
| 2010-06-07 02:00:00 | ES | Futures | 1036.12 | 1037.59 | 1032.7 | 1034.9 | 7201.0 |
| 2010-06-07 02:30:00 | ES | Futures | 1034.9 | 1037.59 | 1034.9 | 1036.86 | 6686.0 |
| 2010-06-07 03:00:00 | ES | Futures | 1036.86 | 1040.28 | 1036.12 | 1038.57 | 23927.0 |
| 2010-06-07 03:30:00 | ES | Futures | 1038.81 | 1039.54 | 1034.66 | 1035.63 | 19726.0 |
| 2010-06-07 04:00:00 | ES | Futures | 1035.39 | 1038.57 | 1034.41 | 1037.35 | 16346.0 |
| 2010-06-07 04:30:00 | ES | Futures | 1037.59 | 1039.79 | 1036.86 | 1039.06 | 13408.0 |
| 2010-06-07 05:00:00 | ES | Futures | 1039.3 | 1039.3 | 1037.35 | 1038.57 | 9485.0 |
| 2010-06-07 05:30:00 | ES | Futures | 1038.32 | 1042.48 | 1038.08 | 1042.23 | 15223.0 |
| 2010-06-07 06:00:00 | ES | Futures | 1042.23 | 1044.19 | 1040.77 | 1043.46 | 15051.0 |
| 2010-06-07 06:30:00 | ES | Futures | 1043.46 | 1044.68 | 1042.97 | 1043.7 | 12082.0 |
| 2010-06-07 07:00:00 | ES | Futures | 1043.7 | 1045.66 | 1043.7 | 1045.17 | 17551.0 |
| 2010-06-07 07:30:00 | ES | Futures | 1045.41 | 1045.9 | 1042.72 | 1043.94 | 22121.0 |
| 2010-06-07 08:00:00 | ES | Futures | 1043.7 | 1046.39 | 1042.97 | 1045.66 | 24737.0 |
| 2010-06-07 08:30:00 | ES | Futures | 1045.66 | 1046.88 | 1043.7 | 1043.94 | 26264.0 |
| 2010-06-07 09:00:00 | ES | Futures | 1043.94 | 1045.17 | 1040.52 | 1043.21 | 49043.0 |
| 2010-06-07 09:30:00 | ES | Futures | 1042.97 | 1045.17 | 1036.86 | 1043.7 | 269544.0 |
| 2010-06-07 10:00:00 | ES | Futures | 1043.7 | 1046.88 | 1042.23 | 1044.19 | 172262.0 |
| 2010-06-07 10:30:00 | ES | Futures | 1044.19 | 1044.43 | 1034.66 | 1035.39 | 206738.0 |
| 2010-06-07 11:00:00 | ES | Futures | 1035.39 | 1038.57 | 1033.92 | 1037.59 | 155256.0 |
| 2010-06-07 11:30:00 | ES | Futures | 1037.59 | 1041.26 | 1037.1 | 1041.26 | 99212.0 |
| 2010-06-07 12:00:00 | ES | Futures | 1041.26 | 1043.94 | 1040.03 | 1040.52 | 91256.0 |
| 2010-06-07 12:30:00 | ES | Futures | 1040.52 | 1043.21 | 1040.03 | 1042.23 | 42791.0 |
| 2010-06-07 13:00:00 | ES | Futures | 1042.48 | 1044.19 | 1040.52 | 1044.19 | 51468.0 |
| 2010-06-07 13:30:00 | ES | Futures | 1044.19 | 1044.92 | 1037.83 | 1039.06 | 82983.0 |
| 2010-06-07 14:00:00 | ES | Futures | 1039.06 | 1040.77 | 1036.12 | 1038.32 | 79549.0 |
| 2010-06-07 14:30:00 | ES | Futures | 1038.32 | 1039.3 | 1032.7 | 1034.41 | 122423.0 |
| 2010-06-07 15:00:00 | ES | Futures | 1034.41 | 1037.83 | 1028.06 | 1028.06 | 180816.0 |
| 2010-06-07 15:30:00 | ES | Futures | 1028.06 | 1031.23 | 1025.37 | 1026.35 | 275720.0 |
| 2010-06-07 16:00:00 | ES | Futures | 1026.35 | 1027.57 | 1023.66 | 1024.15 | 116314.0 |
| 2010-06-07 16:30:00 | ES | Futures | 1024.88 | 1026.1 | 1024.15 | 1025.86 | 8261.0 |
| 2010-06-07 17:00:00 | ES | Futures | 1026.1 | 1026.35 | 1025.37 | 1025.86 | 3394.0 |
| 2010-06-07 18:00:00 | ES | Futures | 1025.61 | 1026.1 | 1024.15 | 1025.61 | 3563.0 |
| 2010-06-07 18:30:00 | ES | Futures | 1025.61 | 1026.1 | 1025.37 | 1025.86 | 1421.0 |
| 2010-06-07 19:00:00 | ES | Futures | 1025.86 | 1027.81 | 1025.86 | 1027.81 | 2348.0 |
| 2010-06-07 19:30:00 | ES | Futures | 1027.57 | 1028.55 | 1027.08 | 1028.06 | 4103.0 |
| 2010-06-07 20:00:00 | ES | Futures | 1028.06 | 1030.01 | 1027.57 | 1029.77 | 7383.0 |
| 2010-06-07 20:30:00 | ES | Futures | 1029.52 | 1030.01 | 1027.57 | 1029.52 | 4376.0 |
| 2010-06-07 21:00:00 | ES | Futures | 1029.52 | 1031.48 | 1029.52 | 1030.75 | 8281.0 |
| 2010-06-07 21:30:00 | ES | Futures | 1030.99 | 1033.19 | 1030.75 | 1031.72 | 7524.0 |
| 2010-06-07 22:00:00 | ES | Futures | 1031.97 | 1032.46 | 1030.5 | 1031.48 | 3377.0 |
| 2010-06-07 22:30:00 | ES | Futures | 1031.48 | 1032.21 | 1030.75 | 1031.23 | 3023.0 |
| 2010-06-07 23:00:00 | ES | Futures | 1031.23 | 1032.7 | 1030.99 | 1031.97 | 2473.0 |
| 2010-06-07 23:30:00 | ES | Futures | 1031.97 | 1033.43 | 1031.72 | 1032.95 | 3626.0 |
| 2010-06-07 00:00:00 | NQ | Futures | 2085.08 | 2087.08 | 2083.36 | 2085.08 | 667.0 |
| 2010-06-07 00:30:00 | NQ | Futures | 2085.65 | 2088.52 | 2085.37 | 2088.52 | 596.0 |
| 2010-06-07 01:00:00 | NQ | Futures | 2088.23 | 2092.52 | 2084.22 | 2085.08 | 861.0 |
> showing 50 of 2,469 rows — these rows as CSV