PREVIEW / futures_5min / 2010-01-31
file: by_date/futures_5min/2010/2010-01-31.parquet size: 42 KB rows: 2,110
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-01-31 18:00:00 | ES | Futures | 1041.15 | 1042.12 | 1039.93 | 1040.9 | 4528.0 |
| 2010-01-31 18:05:00 | ES | Futures | 1041.15 | 1041.39 | 1039.2 | 1040.17 | 2910.0 |
| 2010-01-31 18:10:00 | ES | Futures | 1040.17 | 1041.15 | 1039.44 | 1041.15 | 1583.0 |
| 2010-01-31 18:15:00 | ES | Futures | 1040.9 | 1041.39 | 1040.17 | 1040.9 | 1510.0 |
| 2010-01-31 18:20:00 | ES | Futures | 1041.15 | 1041.15 | 1040.42 | 1040.66 | 683.0 |
| 2010-01-31 18:25:00 | ES | Futures | 1040.66 | 1040.9 | 1039.93 | 1040.9 | 1360.0 |
| 2010-01-31 18:30:00 | ES | Futures | 1040.9 | 1041.39 | 1040.66 | 1041.15 | 901.0 |
| 2010-01-31 18:35:00 | ES | Futures | 1041.15 | 1041.15 | 1040.66 | 1040.9 | 282.0 |
| 2010-01-31 18:40:00 | ES | Futures | 1040.9 | 1043.58 | 1040.9 | 1043.34 | 3195.0 |
| 2010-01-31 18:45:00 | ES | Futures | 1043.09 | 1043.34 | 1042.36 | 1042.61 | 1022.0 |
| 2010-01-31 18:50:00 | ES | Futures | 1042.61 | 1042.85 | 1041.63 | 1042.36 | 1122.0 |
| 2010-01-31 18:55:00 | ES | Futures | 1042.61 | 1042.85 | 1042.12 | 1042.85 | 572.0 |
| 2010-01-31 19:00:00 | ES | Futures | 1042.61 | 1042.85 | 1042.12 | 1042.61 | 854.0 |
| 2010-01-31 19:05:00 | ES | Futures | 1042.36 | 1043.09 | 1041.88 | 1043.09 | 1775.0 |
| 2010-01-31 19:10:00 | ES | Futures | 1042.85 | 1043.58 | 1042.85 | 1042.85 | 1074.0 |
| 2010-01-31 19:15:00 | ES | Futures | 1042.85 | 1043.82 | 1042.61 | 1043.58 | 1031.0 |
| 2010-01-31 19:20:00 | ES | Futures | 1043.58 | 1043.82 | 1042.85 | 1043.58 | 565.0 |
| 2010-01-31 19:25:00 | ES | Futures | 1043.34 | 1044.55 | 1043.34 | 1044.55 | 1898.0 |
| 2010-01-31 19:30:00 | ES | Futures | 1044.55 | 1044.55 | 1043.58 | 1044.55 | 1329.0 |
| 2010-01-31 19:35:00 | ES | Futures | 1044.55 | 1044.8 | 1044.07 | 1044.07 | 1355.0 |
| 2010-01-31 19:40:00 | ES | Futures | 1044.07 | 1044.07 | 1043.34 | 1043.82 | 931.0 |
| 2010-01-31 19:45:00 | ES | Futures | 1043.82 | 1043.82 | 1043.34 | 1043.58 | 480.0 |
| 2010-01-31 19:50:00 | ES | Futures | 1043.58 | 1043.58 | 1043.34 | 1043.58 | 193.0 |
| 2010-01-31 19:55:00 | ES | Futures | 1043.58 | 1043.82 | 1043.09 | 1043.34 | 848.0 |
| 2010-01-31 20:00:00 | ES | Futures | 1043.34 | 1044.07 | 1043.34 | 1044.07 | 542.0 |
| 2010-01-31 20:05:00 | ES | Futures | 1044.07 | 1044.31 | 1043.82 | 1043.82 | 435.0 |
| 2010-01-31 20:10:00 | ES | Futures | 1044.07 | 1044.07 | 1043.34 | 1043.34 | 454.0 |
| 2010-01-31 20:15:00 | ES | Futures | 1043.34 | 1043.58 | 1043.09 | 1043.34 | 1035.0 |
| 2010-01-31 20:20:00 | ES | Futures | 1043.34 | 1043.58 | 1042.61 | 1043.09 | 1168.0 |
| 2010-01-31 20:25:00 | ES | Futures | 1042.85 | 1042.85 | 1042.36 | 1042.61 | 1085.0 |
| 2010-01-31 20:30:00 | ES | Futures | 1042.61 | 1042.61 | 1041.88 | 1042.36 | 871.0 |
| 2010-01-31 20:35:00 | ES | Futures | 1042.36 | 1042.36 | 1041.88 | 1042.12 | 508.0 |
| 2010-01-31 20:40:00 | ES | Futures | 1042.12 | 1042.12 | 1040.17 | 1040.42 | 1597.0 |
| 2010-01-31 20:45:00 | ES | Futures | 1040.17 | 1040.9 | 1039.69 | 1040.9 | 1015.0 |
| 2010-01-31 20:50:00 | ES | Futures | 1040.9 | 1041.15 | 1040.66 | 1040.9 | 544.0 |
| 2010-01-31 20:55:00 | ES | Futures | 1041.15 | 1043.09 | 1041.15 | 1042.85 | 1711.0 |
| 2010-01-31 21:00:00 | ES | Futures | 1042.61 | 1042.61 | 1041.88 | 1042.36 | 1018.0 |
| 2010-01-31 21:05:00 | ES | Futures | 1042.61 | 1042.85 | 1042.12 | 1042.12 | 361.0 |
| 2010-01-31 21:10:00 | ES | Futures | 1042.12 | 1042.12 | 1040.9 | 1041.15 | 848.0 |
| 2010-01-31 21:15:00 | ES | Futures | 1040.9 | 1041.39 | 1040.42 | 1040.9 | 1051.0 |
| 2010-01-31 21:20:00 | ES | Futures | 1041.15 | 1041.63 | 1040.9 | 1041.63 | 489.0 |
| 2010-01-31 21:25:00 | ES | Futures | 1041.63 | 1042.36 | 1040.9 | 1042.12 | 1320.0 |
| 2010-01-31 21:30:00 | ES | Futures | 1041.88 | 1042.61 | 1041.63 | 1042.36 | 491.0 |
| 2010-01-31 21:35:00 | ES | Futures | 1042.36 | 1042.36 | 1041.63 | 1041.88 | 212.0 |
| 2010-01-31 21:40:00 | ES | Futures | 1041.88 | 1042.36 | 1041.63 | 1042.12 | 180.0 |
| 2010-01-31 21:45:00 | ES | Futures | 1042.12 | 1043.34 | 1042.12 | 1043.09 | 675.0 |
| 2010-01-31 21:50:00 | ES | Futures | 1043.09 | 1043.34 | 1042.85 | 1043.09 | 268.0 |
| 2010-01-31 21:55:00 | ES | Futures | 1043.09 | 1043.09 | 1042.36 | 1042.36 | 403.0 |
| 2010-01-31 22:00:00 | ES | Futures | 1042.36 | 1042.36 | 1041.88 | 1041.88 | 220.0 |
| 2010-01-31 22:05:00 | ES | Futures | 1042.12 | 1042.12 | 1041.15 | 1041.88 | 528.0 |
> showing 50 of 2,110 rows — these rows as CSV