PREVIEW / futures_30min / 2010-07-09
file: by_date/futures_30min/2010/2010-07-09.parquet size: 58 KB rows: 2,022
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-09 00:00:00 | ES | Futures | 1048.02 | 1048.02 | 1047.53 | 1048.02 | 970.0 |
| 2010-07-09 00:30:00 | ES | Futures | 1047.77 | 1048.26 | 1047.53 | 1048.02 | 1025.0 |
| 2010-07-09 01:00:00 | ES | Futures | 1048.02 | 1048.51 | 1047.53 | 1047.53 | 1148.0 |
| 2010-07-09 01:30:00 | ES | Futures | 1047.77 | 1049.24 | 1046.79 | 1047.53 | 6531.0 |
| 2010-07-09 02:00:00 | ES | Futures | 1047.53 | 1047.77 | 1046.54 | 1046.54 | 4345.0 |
| 2010-07-09 02:30:00 | ES | Futures | 1046.54 | 1047.77 | 1046.54 | 1047.28 | 2440.0 |
| 2010-07-09 03:00:00 | ES | Futures | 1047.53 | 1047.77 | 1046.3 | 1047.28 | 11073.0 |
| 2010-07-09 03:30:00 | ES | Futures | 1047.28 | 1047.77 | 1045.56 | 1045.81 | 9043.0 |
| 2010-07-09 04:00:00 | ES | Futures | 1045.81 | 1048.75 | 1045.56 | 1047.77 | 14648.0 |
| 2010-07-09 04:30:00 | ES | Futures | 1047.77 | 1048.02 | 1045.81 | 1046.3 | 7511.0 |
| 2010-07-09 05:00:00 | ES | Futures | 1046.3 | 1047.03 | 1045.07 | 1047.03 | 7860.0 |
| 2010-07-09 05:30:00 | ES | Futures | 1046.79 | 1047.03 | 1046.05 | 1046.79 | 5323.0 |
| 2010-07-09 06:00:00 | ES | Futures | 1047.03 | 1047.77 | 1046.3 | 1046.54 | 6138.0 |
| 2010-07-09 06:30:00 | ES | Futures | 1046.3 | 1047.03 | 1045.56 | 1045.81 | 6663.0 |
| 2010-07-09 07:00:00 | ES | Futures | 1046.05 | 1049.0 | 1046.05 | 1048.02 | 12777.0 |
| 2010-07-09 07:30:00 | ES | Futures | 1048.02 | 1048.75 | 1046.3 | 1046.79 | 8565.0 |
| 2010-07-09 08:00:00 | ES | Futures | 1046.79 | 1047.53 | 1045.56 | 1045.81 | 15162.0 |
| 2010-07-09 08:30:00 | ES | Futures | 1045.81 | 1046.05 | 1043.6 | 1045.56 | 33971.0 |
| 2010-07-09 09:00:00 | ES | Futures | 1045.56 | 1047.03 | 1045.07 | 1046.54 | 20991.0 |
| 2010-07-09 09:30:00 | ES | Futures | 1046.54 | 1048.75 | 1044.58 | 1046.79 | 171326.0 |
| 2010-07-09 10:00:00 | ES | Futures | 1046.79 | 1050.96 | 1046.54 | 1049.24 | 159474.0 |
| 2010-07-09 10:30:00 | ES | Futures | 1049.24 | 1051.94 | 1047.77 | 1048.51 | 112941.0 |
| 2010-07-09 11:00:00 | ES | Futures | 1048.26 | 1049.24 | 1045.81 | 1047.53 | 82072.0 |
| 2010-07-09 11:30:00 | ES | Futures | 1047.53 | 1049.49 | 1047.03 | 1047.53 | 67319.0 |
| 2010-07-09 12:00:00 | ES | Futures | 1047.53 | 1049.49 | 1047.28 | 1048.75 | 36336.0 |
| 2010-07-09 12:30:00 | ES | Futures | 1049.0 | 1049.49 | 1047.03 | 1048.26 | 38494.0 |
| 2010-07-09 13:00:00 | ES | Futures | 1048.26 | 1049.73 | 1047.53 | 1048.51 | 42229.0 |
| 2010-07-09 13:30:00 | ES | Futures | 1048.26 | 1050.22 | 1047.77 | 1049.73 | 44110.0 |
| 2010-07-09 14:00:00 | ES | Futures | 1049.98 | 1050.72 | 1048.02 | 1049.0 | 51998.0 |
| 2010-07-09 14:30:00 | ES | Futures | 1049.0 | 1053.66 | 1048.51 | 1052.92 | 80063.0 |
| 2010-07-09 15:00:00 | ES | Futures | 1053.17 | 1053.91 | 1050.96 | 1051.45 | 83628.0 |
| 2010-07-09 15:30:00 | ES | Futures | 1051.21 | 1054.89 | 1050.72 | 1054.4 | 141131.0 |
| 2010-07-09 16:00:00 | ES | Futures | 1054.15 | 1055.13 | 1051.7 | 1051.94 | 104711.0 |
| 2010-07-09 00:00:00 | NQ | Futures | 2060.12 | 2060.41 | 2058.12 | 2059.26 | 146.0 |
| 2010-07-09 00:30:00 | NQ | Futures | 2058.98 | 2060.12 | 2058.69 | 2060.12 | 113.0 |
| 2010-07-09 01:00:00 | NQ | Futures | 2059.55 | 2060.41 | 2058.4 | 2058.98 | 223.0 |
| 2010-07-09 01:30:00 | NQ | Futures | 2058.98 | 2062.7 | 2058.4 | 2060.12 | 425.0 |
| 2010-07-09 02:00:00 | NQ | Futures | 2059.84 | 2060.41 | 2058.12 | 2058.98 | 300.0 |
| 2010-07-09 02:30:00 | NQ | Futures | 2058.69 | 2060.7 | 2058.69 | 2060.41 | 163.0 |
| 2010-07-09 03:00:00 | NQ | Futures | 2060.41 | 2060.7 | 2057.83 | 2059.84 | 941.0 |
| 2010-07-09 03:30:00 | NQ | Futures | 2060.12 | 2060.41 | 2055.82 | 2056.4 | 443.0 |
| 2010-07-09 04:00:00 | NQ | Futures | 2056.11 | 2061.27 | 2056.11 | 2059.84 | 664.0 |
| 2010-07-09 04:30:00 | NQ | Futures | 2059.84 | 2059.84 | 2055.25 | 2056.68 | 653.0 |
| 2010-07-09 05:00:00 | NQ | Futures | 2056.68 | 2059.55 | 2055.25 | 2058.98 | 719.0 |
| 2010-07-09 05:30:00 | NQ | Futures | 2059.26 | 2059.55 | 2057.54 | 2059.55 | 306.0 |
| 2010-07-09 06:00:00 | NQ | Futures | 2059.26 | 2059.84 | 2057.83 | 2057.83 | 406.0 |
| 2010-07-09 06:30:00 | NQ | Futures | 2057.54 | 2059.26 | 2055.82 | 2056.68 | 582.0 |
| 2010-07-09 07:00:00 | NQ | Futures | 2056.97 | 2062.13 | 2056.97 | 2060.7 | 976.0 |
| 2010-07-09 07:30:00 | NQ | Futures | 2060.7 | 2061.84 | 2057.83 | 2058.12 | 631.0 |
| 2010-07-09 08:00:00 | NQ | Futures | 2058.12 | 2058.69 | 2055.25 | 2056.11 | 1958.0 |
> showing 50 of 2,022 rows — these rows as CSV