PREVIEW / futures_30min / 2010-08-25
file: by_date/futures_30min/2010/2010-08-25.parquet size: 72 KB rows: 2,523
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-08-25 00:00:00 | ES | Futures | 1033.54 | 1033.78 | 1030.84 | 1031.08 | 3174.0 |
| 2010-08-25 00:30:00 | ES | Futures | 1031.08 | 1032.8 | 1030.84 | 1032.07 | 2012.0 |
| 2010-08-25 01:00:00 | ES | Futures | 1032.31 | 1032.31 | 1029.37 | 1029.61 | 3977.0 |
| 2010-08-25 01:30:00 | ES | Futures | 1029.86 | 1030.1 | 1028.14 | 1028.88 | 5261.0 |
| 2010-08-25 02:00:00 | ES | Futures | 1028.88 | 1030.59 | 1028.39 | 1029.86 | 6025.0 |
| 2010-08-25 02:30:00 | ES | Futures | 1029.86 | 1031.82 | 1029.37 | 1031.82 | 5264.0 |
| 2010-08-25 03:00:00 | ES | Futures | 1031.58 | 1032.31 | 1029.61 | 1031.82 | 14242.0 |
| 2010-08-25 03:30:00 | ES | Futures | 1032.07 | 1035.5 | 1031.33 | 1033.78 | 19973.0 |
| 2010-08-25 04:00:00 | ES | Futures | 1034.03 | 1035.99 | 1033.78 | 1034.52 | 18808.0 |
| 2010-08-25 04:30:00 | ES | Futures | 1034.52 | 1035.01 | 1031.82 | 1031.82 | 12951.0 |
| 2010-08-25 05:00:00 | ES | Futures | 1032.07 | 1033.29 | 1031.82 | 1032.8 | 6771.0 |
| 2010-08-25 05:30:00 | ES | Futures | 1032.56 | 1032.8 | 1029.37 | 1030.1 | 12317.0 |
| 2010-08-25 06:00:00 | ES | Futures | 1030.1 | 1030.59 | 1028.63 | 1029.86 | 11660.0 |
| 2010-08-25 06:30:00 | ES | Futures | 1030.1 | 1031.08 | 1029.37 | 1030.1 | 5991.0 |
| 2010-08-25 07:00:00 | ES | Futures | 1030.1 | 1030.35 | 1027.4 | 1027.65 | 15537.0 |
| 2010-08-25 07:30:00 | ES | Futures | 1027.89 | 1029.12 | 1026.91 | 1028.63 | 16096.0 |
| 2010-08-25 08:00:00 | ES | Futures | 1028.63 | 1028.88 | 1025.93 | 1026.91 | 26818.0 |
| 2010-08-25 08:30:00 | ES | Futures | 1026.42 | 1026.42 | 1021.76 | 1023.23 | 85093.0 |
| 2010-08-25 09:00:00 | ES | Futures | 1023.48 | 1024.95 | 1022.01 | 1024.7 | 38489.0 |
| 2010-08-25 09:30:00 | ES | Futures | 1024.7 | 1028.14 | 1020.04 | 1022.25 | 278131.0 |
| 2010-08-25 10:00:00 | ES | Futures | 1022.25 | 1025.69 | 1017.83 | 1023.97 | 275176.0 |
| 2010-08-25 10:30:00 | ES | Futures | 1023.72 | 1026.67 | 1020.29 | 1025.93 | 198540.0 |
| 2010-08-25 11:00:00 | ES | Futures | 1026.18 | 1029.37 | 1023.97 | 1028.88 | 216828.0 |
| 2010-08-25 11:30:00 | ES | Futures | 1028.88 | 1028.88 | 1025.93 | 1027.65 | 91478.0 |
| 2010-08-25 12:00:00 | ES | Futures | 1027.65 | 1028.88 | 1025.93 | 1026.42 | 74256.0 |
| 2010-08-25 12:30:00 | ES | Futures | 1026.42 | 1027.65 | 1024.21 | 1024.95 | 78373.0 |
| 2010-08-25 13:00:00 | ES | Futures | 1025.2 | 1027.65 | 1024.46 | 1025.93 | 61023.0 |
| 2010-08-25 13:30:00 | ES | Futures | 1025.93 | 1029.37 | 1025.44 | 1028.14 | 64448.0 |
| 2010-08-25 14:00:00 | ES | Futures | 1028.14 | 1031.33 | 1027.89 | 1029.37 | 113830.0 |
| 2010-08-25 14:30:00 | ES | Futures | 1029.61 | 1035.01 | 1028.88 | 1034.52 | 184431.0 |
| 2010-08-25 15:00:00 | ES | Futures | 1034.77 | 1035.5 | 1031.08 | 1031.58 | 130580.0 |
| 2010-08-25 15:30:00 | ES | Futures | 1031.82 | 1038.2 | 1031.58 | 1034.27 | 247163.0 |
| 2010-08-25 16:00:00 | ES | Futures | 1034.27 | 1035.99 | 1032.8 | 1035.75 | 99261.0 |
| 2010-08-25 16:30:00 | ES | Futures | 1035.75 | 1036.73 | 1035.26 | 1035.75 | 4803.0 |
| 2010-08-25 17:00:00 | ES | Futures | 1035.75 | 1035.99 | 1035.26 | 1035.5 | 1562.0 |
| 2010-08-25 18:00:00 | ES | Futures | 1035.26 | 1035.5 | 1034.77 | 1034.77 | 1277.0 |
| 2010-08-25 18:30:00 | ES | Futures | 1034.77 | 1035.5 | 1034.77 | 1035.26 | 543.0 |
| 2010-08-25 19:00:00 | ES | Futures | 1035.26 | 1036.73 | 1035.26 | 1036.48 | 1942.0 |
| 2010-08-25 19:30:00 | ES | Futures | 1036.73 | 1036.97 | 1035.99 | 1036.73 | 1778.0 |
| 2010-08-25 20:00:00 | ES | Futures | 1036.97 | 1036.97 | 1035.26 | 1035.75 | 3515.0 |
| 2010-08-25 20:30:00 | ES | Futures | 1035.75 | 1035.99 | 1034.03 | 1035.01 | 4844.0 |
| 2010-08-25 21:00:00 | ES | Futures | 1035.01 | 1035.75 | 1034.77 | 1035.75 | 2254.0 |
| 2010-08-25 21:30:00 | ES | Futures | 1035.5 | 1035.99 | 1035.01 | 1035.99 | 2027.0 |
| 2010-08-25 22:00:00 | ES | Futures | 1035.99 | 1036.97 | 1035.75 | 1036.24 | 3766.0 |
| 2010-08-25 22:30:00 | ES | Futures | 1035.99 | 1036.97 | 1035.99 | 1036.73 | 1061.0 |
| 2010-08-25 23:00:00 | ES | Futures | 1036.97 | 1036.97 | 1035.99 | 1036.73 | 1062.0 |
| 2010-08-25 23:30:00 | ES | Futures | 1036.73 | 1037.71 | 1036.73 | 1037.22 | 2272.0 |
| 2010-08-25 00:00:00 | NQ | Futures | 2037.48 | 2038.92 | 2032.9 | 2033.19 | 90.0 |
| 2010-08-25 00:30:00 | NQ | Futures | 2033.76 | 2036.91 | 2033.76 | 2035.77 | 68.0 |
| 2010-08-25 01:00:00 | NQ | Futures | 2035.77 | 2036.05 | 2031.18 | 2031.47 | 172.0 |
> showing 50 of 2,523 rows — these rows as CSV