PREVIEW / futures_30min / 2010-02-02
file: by_date/futures_30min/2010/2010-02-02.parquet size: 70 KB rows: 2,607
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-02 00:00:00 | ES | Futures | 1055.26 | 1056.23 | 1055.01 | 1055.5 | 1393.0 |
| 2010-02-02 00:30:00 | ES | Futures | 1055.5 | 1055.5 | 1054.28 | 1054.53 | 1356.0 |
| 2010-02-02 01:00:00 | ES | Futures | 1054.28 | 1055.74 | 1054.28 | 1055.01 | 1115.0 |
| 2010-02-02 01:30:00 | ES | Futures | 1055.01 | 1055.01 | 1054.04 | 1054.53 | 2106.0 |
| 2010-02-02 02:00:00 | ES | Futures | 1054.28 | 1056.96 | 1054.28 | 1056.72 | 4960.0 |
| 2010-02-02 02:30:00 | ES | Futures | 1056.72 | 1057.69 | 1056.23 | 1057.2 | 7137.0 |
| 2010-02-02 03:00:00 | ES | Futures | 1057.2 | 1057.69 | 1053.07 | 1053.31 | 26072.0 |
| 2010-02-02 03:30:00 | ES | Futures | 1053.07 | 1055.5 | 1052.82 | 1055.26 | 8963.0 |
| 2010-02-02 04:00:00 | ES | Futures | 1055.5 | 1056.96 | 1054.53 | 1056.72 | 7867.0 |
| 2010-02-02 04:30:00 | ES | Futures | 1056.47 | 1058.42 | 1056.23 | 1058.18 | 12534.0 |
| 2010-02-02 05:00:00 | ES | Futures | 1058.18 | 1061.58 | 1058.18 | 1061.09 | 25363.0 |
| 2010-02-02 05:30:00 | ES | Futures | 1061.09 | 1062.55 | 1060.61 | 1061.58 | 14020.0 |
| 2010-02-02 06:00:00 | ES | Futures | 1061.58 | 1061.58 | 1059.15 | 1060.37 | 11396.0 |
| 2010-02-02 06:30:00 | ES | Futures | 1060.37 | 1061.09 | 1058.66 | 1059.39 | 12971.0 |
| 2010-02-02 07:00:00 | ES | Futures | 1059.39 | 1060.37 | 1059.15 | 1059.64 | 5622.0 |
| 2010-02-02 07:30:00 | ES | Futures | 1059.64 | 1061.58 | 1059.39 | 1059.88 | 18641.0 |
| 2010-02-02 08:00:00 | ES | Futures | 1060.12 | 1060.37 | 1058.18 | 1059.15 | 28281.0 |
| 2010-02-02 08:30:00 | ES | Futures | 1059.15 | 1059.39 | 1057.2 | 1057.93 | 16469.0 |
| 2010-02-02 09:00:00 | ES | Futures | 1057.93 | 1059.39 | 1057.45 | 1058.66 | 25016.0 |
| 2010-02-02 09:30:00 | ES | Futures | 1058.42 | 1059.64 | 1055.26 | 1056.96 | 200692.0 |
| 2010-02-02 10:00:00 | ES | Futures | 1056.72 | 1063.28 | 1055.01 | 1062.8 | 224517.0 |
| 2010-02-02 10:30:00 | ES | Futures | 1063.04 | 1065.72 | 1062.8 | 1064.5 | 194362.0 |
| 2010-02-02 11:00:00 | ES | Futures | 1064.5 | 1064.5 | 1061.58 | 1064.01 | 151499.0 |
| 2010-02-02 11:30:00 | ES | Futures | 1064.01 | 1065.23 | 1062.8 | 1064.26 | 80402.0 |
| 2010-02-02 12:00:00 | ES | Futures | 1064.01 | 1067.42 | 1063.28 | 1067.18 | 101344.0 |
| 2010-02-02 12:30:00 | ES | Futures | 1067.18 | 1067.42 | 1065.72 | 1067.18 | 55039.0 |
| 2010-02-02 13:00:00 | ES | Futures | 1067.18 | 1067.91 | 1065.23 | 1067.91 | 68430.0 |
| 2010-02-02 13:30:00 | ES | Futures | 1067.91 | 1069.85 | 1067.18 | 1069.12 | 130075.0 |
| 2010-02-02 14:00:00 | ES | Futures | 1069.37 | 1069.61 | 1066.45 | 1067.91 | 78488.0 |
| 2010-02-02 14:30:00 | ES | Futures | 1068.15 | 1068.64 | 1065.96 | 1068.15 | 86628.0 |
| 2010-02-02 15:00:00 | ES | Futures | 1068.15 | 1071.8 | 1066.93 | 1069.85 | 169765.0 |
| 2010-02-02 15:30:00 | ES | Futures | 1069.61 | 1070.83 | 1068.39 | 1069.85 | 174719.0 |
| 2010-02-02 16:00:00 | ES | Futures | 1069.85 | 1069.85 | 1067.18 | 1067.66 | 116475.0 |
| 2010-02-02 16:30:00 | ES | Futures | 1067.42 | 1069.12 | 1067.42 | 1068.88 | 11089.0 |
| 2010-02-02 17:00:00 | ES | Futures | 1069.12 | 1069.12 | 1068.39 | 1068.88 | 1819.0 |
| 2010-02-02 18:00:00 | ES | Futures | 1068.64 | 1070.1 | 1068.64 | 1069.85 | 4820.0 |
| 2010-02-02 18:30:00 | ES | Futures | 1069.61 | 1069.85 | 1068.64 | 1068.64 | 1367.0 |
| 2010-02-02 19:00:00 | ES | Futures | 1068.64 | 1069.12 | 1068.39 | 1068.88 | 3395.0 |
| 2010-02-02 19:30:00 | ES | Futures | 1068.88 | 1069.61 | 1067.66 | 1067.91 | 3617.0 |
| 2010-02-02 20:00:00 | ES | Futures | 1067.91 | 1068.64 | 1067.66 | 1067.91 | 2132.0 |
| 2010-02-02 20:30:00 | ES | Futures | 1067.91 | 1068.39 | 1067.42 | 1067.66 | 1458.0 |
| 2010-02-02 21:00:00 | ES | Futures | 1067.66 | 1067.91 | 1066.69 | 1066.93 | 1969.0 |
| 2010-02-02 21:30:00 | ES | Futures | 1066.69 | 1067.66 | 1065.96 | 1067.42 | 4060.0 |
| 2010-02-02 22:00:00 | ES | Futures | 1067.18 | 1067.66 | 1066.69 | 1067.66 | 1630.0 |
| 2010-02-02 22:30:00 | ES | Futures | 1067.42 | 1068.15 | 1067.18 | 1068.15 | 2960.0 |
| 2010-02-02 23:00:00 | ES | Futures | 1068.15 | 1068.39 | 1066.69 | 1068.39 | 2301.0 |
| 2010-02-02 23:30:00 | ES | Futures | 1068.15 | 1069.12 | 1067.91 | 1068.39 | 1911.0 |
| 2010-02-02 00:00:00 | NQ | Futures | 2004.26 | 2006.26 | 2003.97 | 2004.83 | 183.0 |
| 2010-02-02 00:30:00 | NQ | Futures | 2004.83 | 2004.83 | 2002.26 | 2002.55 | 225.0 |
| 2010-02-02 01:00:00 | NQ | Futures | 2002.55 | 2004.83 | 2002.55 | 2003.12 | 88.0 |
> showing 50 of 2,607 rows — these rows as CSV