PREVIEW / futures_30min / 2010-07-12
file: by_date/futures_30min/2010/2010-07-12.parquet size: 67 KB rows: 2,440
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-07-12 00:00:00 | ES | Futures | 1050.96 | 1051.7 | 1050.72 | 1051.21 | 447.0 |
| 2010-07-12 00:30:00 | ES | Futures | 1051.21 | 1051.21 | 1049.73 | 1050.22 | 523.0 |
| 2010-07-12 01:00:00 | ES | Futures | 1049.98 | 1050.22 | 1048.51 | 1048.51 | 1618.0 |
| 2010-07-12 01:30:00 | ES | Futures | 1048.51 | 1049.0 | 1047.53 | 1047.53 | 3482.0 |
| 2010-07-12 02:00:00 | ES | Futures | 1047.53 | 1048.51 | 1046.54 | 1046.54 | 5349.0 |
| 2010-07-12 02:30:00 | ES | Futures | 1046.54 | 1048.75 | 1046.54 | 1048.26 | 3924.0 |
| 2010-07-12 03:00:00 | ES | Futures | 1048.26 | 1049.24 | 1046.05 | 1046.54 | 13066.0 |
| 2010-07-12 03:30:00 | ES | Futures | 1046.54 | 1047.28 | 1045.81 | 1047.03 | 13137.0 |
| 2010-07-12 04:00:00 | ES | Futures | 1047.03 | 1049.24 | 1046.79 | 1047.53 | 9740.0 |
| 2010-07-12 04:30:00 | ES | Futures | 1047.77 | 1048.26 | 1045.81 | 1046.54 | 11569.0 |
| 2010-07-12 05:00:00 | ES | Futures | 1046.79 | 1047.28 | 1045.81 | 1046.79 | 5802.0 |
| 2010-07-12 05:30:00 | ES | Futures | 1046.79 | 1047.77 | 1046.3 | 1047.53 | 3047.0 |
| 2010-07-12 06:00:00 | ES | Futures | 1047.77 | 1047.77 | 1046.54 | 1047.28 | 4868.0 |
| 2010-07-12 06:30:00 | ES | Futures | 1047.28 | 1048.75 | 1047.28 | 1047.77 | 4636.0 |
| 2010-07-12 07:00:00 | ES | Futures | 1047.77 | 1049.73 | 1047.77 | 1049.0 | 6644.0 |
| 2010-07-12 07:30:00 | ES | Futures | 1049.0 | 1049.98 | 1048.51 | 1049.24 | 7589.0 |
| 2010-07-12 08:00:00 | ES | Futures | 1049.24 | 1051.45 | 1049.0 | 1050.22 | 13920.0 |
| 2010-07-12 08:30:00 | ES | Futures | 1050.22 | 1050.96 | 1049.49 | 1050.96 | 9382.0 |
| 2010-07-12 09:00:00 | ES | Futures | 1050.96 | 1051.7 | 1050.47 | 1051.21 | 15283.0 |
| 2010-07-12 09:30:00 | ES | Futures | 1051.21 | 1057.34 | 1049.73 | 1056.36 | 213426.0 |
| 2010-07-12 10:00:00 | ES | Futures | 1056.11 | 1056.85 | 1052.43 | 1052.43 | 124149.0 |
| 2010-07-12 10:30:00 | ES | Futures | 1052.43 | 1053.91 | 1049.98 | 1051.45 | 116629.0 |
| 2010-07-12 11:00:00 | ES | Futures | 1051.21 | 1051.21 | 1046.79 | 1049.73 | 139451.0 |
| 2010-07-12 11:30:00 | ES | Futures | 1049.49 | 1050.72 | 1049.0 | 1049.98 | 61394.0 |
| 2010-07-12 12:00:00 | ES | Futures | 1049.73 | 1053.66 | 1049.73 | 1051.94 | 72582.0 |
| 2010-07-12 12:30:00 | ES | Futures | 1051.94 | 1054.64 | 1050.96 | 1050.96 | 65708.0 |
| 2010-07-12 13:00:00 | ES | Futures | 1050.96 | 1054.64 | 1050.47 | 1054.15 | 41030.0 |
| 2010-07-12 13:30:00 | ES | Futures | 1054.4 | 1055.87 | 1052.68 | 1055.38 | 48222.0 |
| 2010-07-12 14:00:00 | ES | Futures | 1055.13 | 1055.62 | 1052.19 | 1053.17 | 31814.0 |
| 2010-07-12 14:30:00 | ES | Futures | 1053.17 | 1055.13 | 1051.7 | 1053.66 | 58225.0 |
| 2010-07-12 15:00:00 | ES | Futures | 1053.91 | 1054.89 | 1051.45 | 1054.15 | 80129.0 |
| 2010-07-12 15:30:00 | ES | Futures | 1054.4 | 1055.87 | 1053.17 | 1055.38 | 99822.0 |
| 2010-07-12 16:00:00 | ES | Futures | 1055.13 | 1057.34 | 1054.89 | 1056.36 | 70808.0 |
| 2010-07-12 16:30:00 | ES | Futures | 1056.11 | 1058.81 | 1055.62 | 1058.57 | 7921.0 |
| 2010-07-12 17:00:00 | ES | Futures | 1058.57 | 1061.02 | 1058.57 | 1059.06 | 6793.0 |
| 2010-07-12 18:00:00 | ES | Futures | 1058.81 | 1059.06 | 1058.08 | 1058.57 | 1944.0 |
| 2010-07-12 18:30:00 | ES | Futures | 1058.57 | 1058.81 | 1058.32 | 1058.81 | 571.0 |
| 2010-07-12 19:00:00 | ES | Futures | 1058.81 | 1059.55 | 1058.57 | 1059.55 | 696.0 |
| 2010-07-12 19:30:00 | ES | Futures | 1059.3 | 1059.79 | 1058.81 | 1059.55 | 1649.0 |
| 2010-07-12 20:00:00 | ES | Futures | 1059.55 | 1062.0 | 1059.3 | 1061.02 | 5522.0 |
| 2010-07-12 20:30:00 | ES | Futures | 1061.02 | 1062.0 | 1060.28 | 1061.02 | 2737.0 |
| 2010-07-12 21:00:00 | ES | Futures | 1061.27 | 1061.51 | 1060.53 | 1061.02 | 3447.0 |
| 2010-07-12 21:30:00 | ES | Futures | 1060.78 | 1061.02 | 1059.55 | 1059.55 | 5312.0 |
| 2010-07-12 22:00:00 | ES | Futures | 1059.79 | 1059.79 | 1058.08 | 1059.06 | 2482.0 |
| 2010-07-12 22:30:00 | ES | Futures | 1059.06 | 1059.06 | 1057.34 | 1057.59 | 2237.0 |
| 2010-07-12 23:00:00 | ES | Futures | 1057.83 | 1057.83 | 1056.6 | 1057.09 | 1778.0 |
| 2010-07-12 23:30:00 | ES | Futures | 1057.34 | 1057.34 | 1055.13 | 1055.62 | 3519.0 |
| 2010-07-12 00:00:00 | NQ | Futures | 2073.02 | 2074.45 | 2073.02 | 2073.59 | 66.0 |
| 2010-07-12 00:30:00 | NQ | Futures | 2073.02 | 2073.02 | 2071.59 | 2072.16 | 74.0 |
| 2010-07-12 01:00:00 | NQ | Futures | 2072.16 | 2072.45 | 2069.58 | 2069.58 | 98.0 |
> showing 50 of 2,440 rows — these rows as CSV