PREVIEW / futures_30min / 2010-02-01
file: by_date/futures_30min/2010/2010-02-01.parquet size: 71 KB rows: 2,583
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-02-01 00:00:00 | ES | Futures | 1043.34 | 1043.58 | 1042.36 | 1043.09 | 1356.0 |
| 2010-02-01 00:30:00 | ES | Futures | 1043.09 | 1043.82 | 1042.61 | 1042.85 | 1317.0 |
| 2010-02-01 01:00:00 | ES | Futures | 1043.09 | 1043.82 | 1041.63 | 1043.58 | 1265.0 |
| 2010-02-01 01:30:00 | ES | Futures | 1043.58 | 1044.55 | 1042.85 | 1043.09 | 2998.0 |
| 2010-02-01 02:00:00 | ES | Futures | 1043.09 | 1045.04 | 1042.85 | 1045.04 | 6492.0 |
| 2010-02-01 02:30:00 | ES | Futures | 1044.8 | 1045.04 | 1043.82 | 1044.55 | 5777.0 |
| 2010-02-01 03:00:00 | ES | Futures | 1044.31 | 1046.01 | 1043.09 | 1044.8 | 24827.0 |
| 2010-02-01 03:30:00 | ES | Futures | 1044.8 | 1045.77 | 1044.07 | 1045.77 | 11048.0 |
| 2010-02-01 04:00:00 | ES | Futures | 1045.53 | 1048.2 | 1044.8 | 1047.47 | 20108.0 |
| 2010-02-01 04:30:00 | ES | Futures | 1047.47 | 1047.72 | 1045.77 | 1046.74 | 10410.0 |
| 2010-02-01 05:00:00 | ES | Futures | 1046.5 | 1046.99 | 1046.01 | 1046.5 | 5205.0 |
| 2010-02-01 05:30:00 | ES | Futures | 1046.5 | 1046.99 | 1045.28 | 1045.77 | 7126.0 |
| 2010-02-01 06:00:00 | ES | Futures | 1046.01 | 1047.47 | 1045.77 | 1046.74 | 6471.0 |
| 2010-02-01 06:30:00 | ES | Futures | 1046.74 | 1046.99 | 1045.04 | 1045.77 | 6679.0 |
| 2010-02-01 07:00:00 | ES | Futures | 1045.77 | 1046.5 | 1044.8 | 1046.26 | 7324.0 |
| 2010-02-01 07:30:00 | ES | Futures | 1046.01 | 1047.96 | 1046.01 | 1047.72 | 20521.0 |
| 2010-02-01 08:00:00 | ES | Futures | 1047.72 | 1048.93 | 1047.23 | 1047.72 | 25992.0 |
| 2010-02-01 08:30:00 | ES | Futures | 1047.72 | 1048.69 | 1046.26 | 1046.74 | 21746.0 |
| 2010-02-01 09:00:00 | ES | Futures | 1046.5 | 1048.69 | 1046.5 | 1047.72 | 19952.0 |
| 2010-02-01 09:30:00 | ES | Futures | 1047.96 | 1051.36 | 1046.99 | 1049.42 | 199778.0 |
| 2010-02-01 10:00:00 | ES | Futures | 1049.66 | 1054.04 | 1047.47 | 1052.34 | 259840.0 |
| 2010-02-01 10:30:00 | ES | Futures | 1052.09 | 1054.28 | 1049.18 | 1049.42 | 162694.0 |
| 2010-02-01 11:00:00 | ES | Futures | 1049.42 | 1054.77 | 1048.69 | 1053.8 | 136821.0 |
| 2010-02-01 11:30:00 | ES | Futures | 1054.04 | 1054.28 | 1050.39 | 1050.63 | 77458.0 |
| 2010-02-01 12:00:00 | ES | Futures | 1050.63 | 1051.85 | 1049.9 | 1051.61 | 61018.0 |
| 2010-02-01 12:30:00 | ES | Futures | 1051.61 | 1054.28 | 1050.88 | 1053.31 | 79302.0 |
| 2010-02-01 13:00:00 | ES | Futures | 1053.07 | 1055.5 | 1052.09 | 1054.28 | 72027.0 |
| 2010-02-01 13:30:00 | ES | Futures | 1054.53 | 1055.01 | 1052.58 | 1053.8 | 69455.0 |
| 2010-02-01 14:00:00 | ES | Futures | 1053.8 | 1054.77 | 1051.12 | 1053.31 | 77920.0 |
| 2010-02-01 14:30:00 | ES | Futures | 1053.31 | 1055.26 | 1053.07 | 1053.55 | 82252.0 |
| 2010-02-01 15:00:00 | ES | Futures | 1053.8 | 1055.26 | 1051.85 | 1054.28 | 97000.0 |
| 2010-02-01 15:30:00 | ES | Futures | 1054.28 | 1056.96 | 1053.07 | 1055.99 | 160146.0 |
| 2010-02-01 16:00:00 | ES | Futures | 1056.23 | 1057.2 | 1055.99 | 1057.2 | 96851.0 |
| 2010-02-01 16:30:00 | ES | Futures | 1056.72 | 1057.2 | 1056.23 | 1056.47 | 6063.0 |
| 2010-02-01 17:00:00 | ES | Futures | 1056.47 | 1056.96 | 1056.47 | 1056.72 | 737.0 |
| 2010-02-01 18:00:00 | ES | Futures | 1056.47 | 1056.72 | 1055.99 | 1056.72 | 2482.0 |
| 2010-02-01 18:30:00 | ES | Futures | 1056.72 | 1057.2 | 1056.23 | 1056.72 | 1867.0 |
| 2010-02-01 19:00:00 | ES | Futures | 1056.72 | 1057.2 | 1056.47 | 1057.2 | 1458.0 |
| 2010-02-01 19:30:00 | ES | Futures | 1056.96 | 1058.18 | 1056.96 | 1057.69 | 3859.0 |
| 2010-02-01 20:00:00 | ES | Futures | 1057.69 | 1057.93 | 1056.47 | 1056.47 | 2675.0 |
| 2010-02-01 20:30:00 | ES | Futures | 1056.72 | 1056.96 | 1055.74 | 1056.47 | 2129.0 |
| 2010-02-01 21:00:00 | ES | Futures | 1056.23 | 1056.96 | 1056.23 | 1056.47 | 1147.0 |
| 2010-02-01 21:30:00 | ES | Futures | 1056.47 | 1056.72 | 1055.5 | 1055.5 | 1722.0 |
| 2010-02-01 22:00:00 | ES | Futures | 1055.5 | 1056.47 | 1055.5 | 1056.23 | 1732.0 |
| 2010-02-01 22:30:00 | ES | Futures | 1056.23 | 1056.23 | 1055.01 | 1055.26 | 3734.0 |
| 2010-02-01 23:00:00 | ES | Futures | 1055.26 | 1055.26 | 1053.55 | 1053.55 | 3692.0 |
| 2010-02-01 23:30:00 | ES | Futures | 1053.8 | 1055.74 | 1053.07 | 1055.26 | 3499.0 |
| 2010-02-01 00:00:00 | NQ | Futures | 1993.12 | 1993.69 | 1991.12 | 1991.41 | 148.0 |
| 2010-02-01 00:30:00 | NQ | Futures | 1991.69 | 1993.12 | 1991.12 | 1991.69 | 170.0 |
| 2010-02-01 01:00:00 | NQ | Futures | 1991.41 | 1993.12 | 1989.98 | 1993.12 | 232.0 |
> showing 50 of 2,583 rows — these rows as CSV