PREVIEW / futures_30min / 2010-06-09
file: by_date/futures_30min/2010/2010-06-09.parquet size: 72 KB rows: 2,491
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-09 00:00:00 | ES | Futures | 1032.21 | 1033.19 | 1031.72 | 1032.21 | 1293.0 |
| 2010-06-09 00:30:00 | ES | Futures | 1032.21 | 1033.19 | 1030.75 | 1032.7 | 3728.0 |
| 2010-06-09 01:00:00 | ES | Futures | 1032.7 | 1033.19 | 1030.99 | 1031.48 | 1938.0 |
| 2010-06-09 01:30:00 | ES | Futures | 1031.48 | 1033.92 | 1030.5 | 1033.68 | 4054.0 |
| 2010-06-09 02:00:00 | ES | Futures | 1033.43 | 1036.37 | 1032.95 | 1036.12 | 7998.0 |
| 2010-06-09 02:30:00 | ES | Futures | 1035.88 | 1038.57 | 1035.88 | 1037.1 | 11223.0 |
| 2010-06-09 03:00:00 | ES | Futures | 1037.1 | 1039.54 | 1035.39 | 1039.06 | 19616.0 |
| 2010-06-09 03:30:00 | ES | Futures | 1039.06 | 1040.03 | 1036.61 | 1037.1 | 11918.0 |
| 2010-06-09 04:00:00 | ES | Futures | 1036.86 | 1037.35 | 1034.17 | 1034.17 | 23749.0 |
| 2010-06-09 04:30:00 | ES | Futures | 1034.17 | 1035.15 | 1032.46 | 1033.68 | 13084.0 |
| 2010-06-09 05:00:00 | ES | Futures | 1033.43 | 1035.15 | 1030.99 | 1031.23 | 14280.0 |
| 2010-06-09 05:30:00 | ES | Futures | 1031.23 | 1033.43 | 1030.01 | 1033.19 | 16282.0 |
| 2010-06-09 06:00:00 | ES | Futures | 1033.19 | 1036.37 | 1032.46 | 1035.39 | 13179.0 |
| 2010-06-09 06:30:00 | ES | Futures | 1035.63 | 1038.08 | 1034.9 | 1036.86 | 13430.0 |
| 2010-06-09 07:00:00 | ES | Futures | 1036.86 | 1039.06 | 1036.37 | 1038.57 | 17707.0 |
| 2010-06-09 07:30:00 | ES | Futures | 1038.32 | 1042.23 | 1038.32 | 1041.74 | 32052.0 |
| 2010-06-09 08:00:00 | ES | Futures | 1041.99 | 1043.46 | 1041.26 | 1041.99 | 37047.0 |
| 2010-06-09 08:30:00 | ES | Futures | 1041.99 | 1043.7 | 1041.5 | 1041.99 | 35385.0 |
| 2010-06-09 09:00:00 | ES | Futures | 1041.99 | 1044.19 | 1041.99 | 1043.21 | 45507.0 |
| 2010-06-09 09:30:00 | ES | Futures | 1043.46 | 1045.17 | 1040.52 | 1042.97 | 285761.0 |
| 2010-06-09 10:00:00 | ES | Futures | 1042.72 | 1044.43 | 1039.3 | 1042.97 | 171917.0 |
| 2010-06-09 10:30:00 | ES | Futures | 1042.72 | 1046.39 | 1039.79 | 1046.14 | 177914.0 |
| 2010-06-09 11:00:00 | ES | Futures | 1046.14 | 1053.72 | 1045.41 | 1052.5 | 256466.0 |
| 2010-06-09 11:30:00 | ES | Futures | 1052.74 | 1052.99 | 1050.3 | 1050.79 | 116617.0 |
| 2010-06-09 12:00:00 | ES | Futures | 1050.79 | 1052.26 | 1049.57 | 1051.03 | 58513.0 |
| 2010-06-09 12:30:00 | ES | Futures | 1051.03 | 1051.28 | 1048.59 | 1048.59 | 68409.0 |
| 2010-06-09 13:00:00 | ES | Futures | 1048.83 | 1050.06 | 1047.61 | 1048.1 | 71208.0 |
| 2010-06-09 13:30:00 | ES | Futures | 1048.1 | 1048.34 | 1044.92 | 1047.12 | 107157.0 |
| 2010-06-09 14:00:00 | ES | Futures | 1047.12 | 1048.1 | 1042.72 | 1046.88 | 152162.0 |
| 2010-06-09 14:30:00 | ES | Futures | 1046.88 | 1047.37 | 1037.35 | 1037.83 | 159315.0 |
| 2010-06-09 15:00:00 | ES | Futures | 1037.59 | 1039.79 | 1030.5 | 1035.63 | 258246.0 |
| 2010-06-09 15:30:00 | ES | Futures | 1035.88 | 1036.12 | 1027.81 | 1031.23 | 335731.0 |
| 2010-06-09 16:00:00 | ES | Futures | 1031.23 | 1032.95 | 1030.75 | 1031.72 | 91194.0 |
| 2010-06-09 16:30:00 | ES | Futures | 1031.48 | 1031.97 | 1030.5 | 1030.99 | 8236.0 |
| 2010-06-09 17:00:00 | ES | Futures | 1030.99 | 1031.23 | 1029.52 | 1029.52 | 3030.0 |
| 2010-06-09 18:00:00 | ES | Futures | 1029.03 | 1031.23 | 1028.79 | 1030.99 | 4904.0 |
| 2010-06-09 18:30:00 | ES | Futures | 1030.99 | 1031.72 | 1030.26 | 1030.75 | 1607.0 |
| 2010-06-09 19:00:00 | ES | Futures | 1030.75 | 1031.72 | 1030.01 | 1030.01 | 1654.0 |
| 2010-06-09 19:30:00 | ES | Futures | 1030.01 | 1031.97 | 1029.03 | 1031.72 | 3265.0 |
| 2010-06-09 20:00:00 | ES | Futures | 1031.72 | 1032.21 | 1029.03 | 1029.28 | 2724.0 |
| 2010-06-09 20:30:00 | ES | Futures | 1029.03 | 1031.48 | 1029.03 | 1029.77 | 3409.0 |
| 2010-06-09 21:00:00 | ES | Futures | 1029.77 | 1031.23 | 1029.52 | 1030.75 | 1852.0 |
| 2010-06-09 21:30:00 | ES | Futures | 1030.75 | 1033.68 | 1030.5 | 1033.43 | 5342.0 |
| 2010-06-09 22:00:00 | ES | Futures | 1033.19 | 1034.66 | 1032.21 | 1033.19 | 3984.0 |
| 2010-06-09 22:30:00 | ES | Futures | 1033.43 | 1033.92 | 1030.99 | 1031.72 | 1855.0 |
| 2010-06-09 23:00:00 | ES | Futures | 1031.97 | 1034.66 | 1030.75 | 1034.17 | 2876.0 |
| 2010-06-09 23:30:00 | ES | Futures | 1034.17 | 1036.12 | 1033.43 | 1034.9 | 4975.0 |
| 2010-06-09 00:00:00 | NQ | Futures | 2046.7 | 2049.28 | 2046.42 | 2046.7 | 98.0 |
| 2010-06-09 00:30:00 | NQ | Futures | 2046.99 | 2048.71 | 2043.84 | 2048.42 | 162.0 |
| 2010-06-09 01:00:00 | NQ | Futures | 2048.42 | 2048.71 | 2045.56 | 2045.56 | 102.0 |
> showing 50 of 2,491 rows — these rows as CSV