PREVIEW / futures_30min / 2010-08-16
file: by_date/futures_30min/2010/2010-08-16.parquet size: 67 KB rows: 2,377
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-16 00:00:00 | ES | Futures | 1052.19 | 1057.34 | 1051.94 | 1056.6 | 5268.0 |
| 2010-08-16 00:30:00 | ES | Futures | 1056.6 | 1057.34 | 1055.62 | 1055.87 | 1225.0 |
| 2010-08-16 01:00:00 | ES | Futures | 1055.87 | 1058.08 | 1055.62 | 1058.08 | 2277.0 |
| 2010-08-16 01:30:00 | ES | Futures | 1057.83 | 1058.32 | 1056.85 | 1057.59 | 2974.0 |
| 2010-08-16 02:00:00 | ES | Futures | 1057.34 | 1059.06 | 1057.34 | 1058.57 | 4410.0 |
| 2010-08-16 02:30:00 | ES | Futures | 1058.81 | 1060.04 | 1058.08 | 1059.06 | 6580.0 |
| 2010-08-16 03:00:00 | ES | Futures | 1058.81 | 1061.51 | 1058.57 | 1060.53 | 15382.0 |
| 2010-08-16 03:30:00 | ES | Futures | 1060.53 | 1061.27 | 1057.09 | 1057.09 | 11647.0 |
| 2010-08-16 04:00:00 | ES | Futures | 1056.85 | 1057.09 | 1051.7 | 1051.7 | 20486.0 |
| 2010-08-16 04:30:00 | ES | Futures | 1051.7 | 1053.91 | 1051.45 | 1053.41 | 18697.0 |
| 2010-08-16 05:00:00 | ES | Futures | 1053.17 | 1056.6 | 1051.94 | 1055.87 | 14293.0 |
| 2010-08-16 05:30:00 | ES | Futures | 1055.87 | 1056.6 | 1053.17 | 1053.41 | 8255.0 |
| 2010-08-16 06:00:00 | ES | Futures | 1053.41 | 1055.13 | 1052.68 | 1054.15 | 6396.0 |
| 2010-08-16 06:30:00 | ES | Futures | 1054.15 | 1055.38 | 1053.17 | 1053.66 | 8365.0 |
| 2010-08-16 07:00:00 | ES | Futures | 1053.41 | 1054.64 | 1052.68 | 1053.41 | 7448.0 |
| 2010-08-16 07:30:00 | ES | Futures | 1053.66 | 1053.66 | 1051.21 | 1052.92 | 17661.0 |
| 2010-08-16 08:00:00 | ES | Futures | 1052.68 | 1053.66 | 1050.72 | 1051.94 | 19174.0 |
| 2010-08-16 08:30:00 | ES | Futures | 1051.94 | 1055.38 | 1051.21 | 1053.41 | 23128.0 |
| 2010-08-16 09:00:00 | ES | Futures | 1053.41 | 1054.64 | 1049.98 | 1050.47 | 44244.0 |
| 2010-08-16 09:30:00 | ES | Futures | 1050.47 | 1054.89 | 1046.54 | 1052.68 | 239706.0 |
| 2010-08-16 10:00:00 | ES | Futures | 1052.68 | 1058.81 | 1051.21 | 1057.34 | 200232.0 |
| 2010-08-16 10:30:00 | ES | Futures | 1057.59 | 1059.55 | 1057.09 | 1057.83 | 104081.0 |
| 2010-08-16 11:00:00 | ES | Futures | 1058.08 | 1058.32 | 1055.13 | 1055.62 | 81736.0 |
| 2010-08-16 11:30:00 | ES | Futures | 1055.62 | 1059.06 | 1055.62 | 1058.32 | 65442.0 |
| 2010-08-16 12:00:00 | ES | Futures | 1058.32 | 1060.28 | 1058.08 | 1060.04 | 51062.0 |
| 2010-08-16 12:30:00 | ES | Futures | 1060.04 | 1060.78 | 1058.57 | 1059.3 | 66620.0 |
| 2010-08-16 13:00:00 | ES | Futures | 1059.3 | 1060.28 | 1058.57 | 1059.3 | 43970.0 |
| 2010-08-16 13:30:00 | ES | Futures | 1059.55 | 1060.04 | 1057.59 | 1058.32 | 37178.0 |
| 2010-08-16 14:00:00 | ES | Futures | 1058.32 | 1059.3 | 1055.62 | 1057.34 | 54663.0 |
| 2010-08-16 14:30:00 | ES | Futures | 1057.34 | 1057.83 | 1053.41 | 1053.91 | 98592.0 |
| 2010-08-16 15:00:00 | ES | Futures | 1053.66 | 1055.62 | 1052.92 | 1055.13 | 83941.0 |
| 2010-08-16 15:30:00 | ES | Futures | 1054.89 | 1058.08 | 1054.4 | 1057.59 | 122430.0 |
| 2010-08-16 16:00:00 | ES | Futures | 1057.34 | 1057.83 | 1056.85 | 1057.34 | 70228.0 |
| 2010-08-16 16:30:00 | ES | Futures | 1057.34 | 1058.32 | 1057.09 | 1057.34 | 3849.0 |
| 2010-08-16 17:00:00 | ES | Futures | 1057.34 | 1058.57 | 1057.34 | 1057.59 | 1396.0 |
| 2010-08-16 18:00:00 | ES | Futures | 1057.83 | 1058.57 | 1057.59 | 1057.83 | 837.0 |
| 2010-08-16 18:30:00 | ES | Futures | 1057.83 | 1057.83 | 1057.09 | 1057.34 | 1221.0 |
| 2010-08-16 19:00:00 | ES | Futures | 1057.09 | 1057.59 | 1055.87 | 1056.11 | 1307.0 |
| 2010-08-16 19:30:00 | ES | Futures | 1056.36 | 1056.6 | 1055.13 | 1055.62 | 1696.0 |
| 2010-08-16 20:00:00 | ES | Futures | 1055.87 | 1057.34 | 1054.64 | 1056.36 | 3717.0 |
| 2010-08-16 20:30:00 | ES | Futures | 1056.36 | 1056.85 | 1054.89 | 1055.38 | 2961.0 |
| 2010-08-16 21:00:00 | ES | Futures | 1055.62 | 1058.32 | 1055.38 | 1058.32 | 4331.0 |
| 2010-08-16 21:30:00 | ES | Futures | 1058.08 | 1058.32 | 1057.09 | 1058.32 | 2056.0 |
| 2010-08-16 22:00:00 | ES | Futures | 1058.08 | 1059.3 | 1056.85 | 1058.57 | 3905.0 |
| 2010-08-16 22:30:00 | ES | Futures | 1058.57 | 1059.79 | 1057.83 | 1059.55 | 2535.0 |
| 2010-08-16 23:00:00 | ES | Futures | 1059.79 | 1060.78 | 1059.55 | 1060.53 | 3275.0 |
| 2010-08-16 23:30:00 | ES | Futures | 1060.53 | 1061.51 | 1060.04 | 1060.28 | 2445.0 |
| 2010-08-16 00:00:00 | NQ | Futures | 2075.31 | 2084.77 | 2075.02 | 2083.91 | 427.0 |
| 2010-08-16 00:30:00 | NQ | Futures | 2083.62 | 2084.48 | 2082.19 | 2082.48 | 113.0 |
| 2010-08-16 01:00:00 | NQ | Futures | 2083.05 | 2085.91 | 2082.48 | 2085.91 | 212.0 |
> showing 50 of 2,377 rows — these rows as CSV