PREVIEW / futures_1hour / 2010-03-03
file: by_date/futures_1hour/2010/2010-03-03.parquet size: 44 KB rows: 1,370
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-03-03 00:00:00 | ES | Futures | 1086.39 | 1087.37 | 1086.39 | 1086.88 | 2400.0 |
| 2010-03-03 01:00:00 | ES | Futures | 1086.88 | 1087.37 | 1086.39 | 1086.64 | 1031.0 |
| 2010-03-03 02:00:00 | ES | Futures | 1086.88 | 1087.37 | 1085.91 | 1087.12 | 6024.0 |
| 2010-03-03 03:00:00 | ES | Futures | 1087.37 | 1088.83 | 1085.91 | 1086.39 | 21454.0 |
| 2010-03-03 04:00:00 | ES | Futures | 1086.39 | 1087.61 | 1084.93 | 1086.88 | 16885.0 |
| 2010-03-03 05:00:00 | ES | Futures | 1086.88 | 1088.1 | 1086.88 | 1087.61 | 8435.0 |
| 2010-03-03 06:00:00 | ES | Futures | 1087.61 | 1089.31 | 1086.88 | 1087.85 | 17435.0 |
| 2010-03-03 07:00:00 | ES | Futures | 1087.61 | 1088.1 | 1085.18 | 1086.15 | 32270.0 |
| 2010-03-03 08:00:00 | ES | Futures | 1086.39 | 1090.53 | 1085.18 | 1089.31 | 60071.0 |
| 2010-03-03 09:00:00 | ES | Futures | 1089.31 | 1092.48 | 1088.1 | 1091.26 | 163675.0 |
| 2010-03-03 10:00:00 | ES | Futures | 1091.5 | 1094.18 | 1090.04 | 1093.69 | 295184.0 |
| 2010-03-03 11:00:00 | ES | Futures | 1093.69 | 1094.66 | 1092.96 | 1093.2 | 172793.0 |
| 2010-03-03 12:00:00 | ES | Futures | 1093.2 | 1093.45 | 1090.29 | 1090.77 | 104221.0 |
| 2010-03-03 13:00:00 | ES | Futures | 1090.77 | 1092.48 | 1090.29 | 1091.75 | 83707.0 |
| 2010-03-03 14:00:00 | ES | Futures | 1091.75 | 1092.48 | 1085.42 | 1087.12 | 245842.0 |
| 2010-03-03 15:00:00 | ES | Futures | 1086.88 | 1089.8 | 1086.64 | 1088.1 | 226816.0 |
| 2010-03-03 16:00:00 | ES | Futures | 1088.1 | 1089.56 | 1087.61 | 1087.85 | 74711.0 |
| 2010-03-03 17:00:00 | ES | Futures | 1087.61 | 1088.34 | 1087.61 | 1087.85 | 1649.0 |
| 2010-03-03 18:00:00 | ES | Futures | 1088.34 | 1088.83 | 1087.37 | 1087.61 | 4493.0 |
| 2010-03-03 19:00:00 | ES | Futures | 1087.61 | 1087.85 | 1087.12 | 1087.12 | 1773.0 |
| 2010-03-03 20:00:00 | ES | Futures | 1087.37 | 1087.61 | 1086.88 | 1087.37 | 1392.0 |
| 2010-03-03 21:00:00 | ES | Futures | 1087.37 | 1088.1 | 1087.12 | 1087.12 | 1712.0 |
| 2010-03-03 22:00:00 | ES | Futures | 1087.12 | 1087.12 | 1085.42 | 1085.66 | 6081.0 |
| 2010-03-03 23:00:00 | ES | Futures | 1085.66 | 1085.91 | 1084.45 | 1084.93 | 6749.0 |
| 2010-03-03 00:00:00 | NQ | Futures | 2113.66 | 2115.37 | 2113.37 | 2114.51 | 67.0 |
| 2010-03-03 01:00:00 | NQ | Futures | 2114.51 | 2115.08 | 2113.94 | 2114.23 | 52.0 |
| 2010-03-03 02:00:00 | NQ | Futures | 2114.23 | 2116.23 | 2113.37 | 2116.23 | 424.0 |
| 2010-03-03 03:00:00 | NQ | Futures | 2116.51 | 2118.51 | 2113.94 | 2115.08 | 1768.0 |
| 2010-03-03 04:00:00 | NQ | Futures | 2114.8 | 2117.65 | 2113.08 | 2116.51 | 1261.0 |
| 2010-03-03 05:00:00 | NQ | Futures | 2116.8 | 2118.23 | 2115.94 | 2117.08 | 594.0 |
| 2010-03-03 06:00:00 | NQ | Futures | 2117.08 | 2119.65 | 2115.66 | 2116.23 | 827.0 |
| 2010-03-03 07:00:00 | NQ | Futures | 2116.51 | 2117.08 | 2111.08 | 2113.66 | 2896.0 |
| 2010-03-03 08:00:00 | NQ | Futures | 2113.37 | 2120.51 | 2112.23 | 2119.08 | 4151.0 |
| 2010-03-03 09:00:00 | NQ | Futures | 2118.8 | 2124.22 | 2115.37 | 2121.37 | 28539.0 |
| 2010-03-03 10:00:00 | NQ | Futures | 2121.65 | 2126.51 | 2117.37 | 2124.8 | 42632.0 |
| 2010-03-03 11:00:00 | NQ | Futures | 2124.8 | 2126.51 | 2122.51 | 2124.22 | 24202.0 |
| 2010-03-03 12:00:00 | NQ | Futures | 2124.51 | 2124.51 | 2116.23 | 2117.94 | 17618.0 |
| 2010-03-03 13:00:00 | NQ | Futures | 2117.94 | 2121.08 | 2117.37 | 2120.23 | 14389.0 |
| 2010-03-03 14:00:00 | NQ | Futures | 2120.23 | 2121.65 | 2108.8 | 2110.8 | 35674.0 |
| 2010-03-03 15:00:00 | NQ | Futures | 2110.8 | 2117.94 | 2108.8 | 2115.94 | 33814.0 |
| 2010-03-03 16:00:00 | NQ | Futures | 2115.94 | 2117.65 | 2114.23 | 2114.23 | 5775.0 |
| 2010-03-03 17:00:00 | NQ | Futures | 2114.23 | 2115.37 | 2113.66 | 2113.94 | 115.0 |
| 2010-03-03 18:00:00 | NQ | Futures | 2114.23 | 2115.08 | 2113.37 | 2113.37 | 175.0 |
| 2010-03-03 19:00:00 | NQ | Futures | 2113.66 | 2113.66 | 2112.23 | 2113.08 | 122.0 |
| 2010-03-03 20:00:00 | NQ | Futures | 2113.08 | 2113.37 | 2112.8 | 2112.8 | 59.0 |
| 2010-03-03 21:00:00 | NQ | Futures | 2113.08 | 2113.66 | 2112.51 | 2112.8 | 104.0 |
| 2010-03-03 22:00:00 | NQ | Futures | 2112.8 | 2112.8 | 2109.94 | 2110.23 | 383.0 |
| 2010-03-03 23:00:00 | NQ | Futures | 2110.23 | 2110.23 | 2109.09 | 2109.66 | 394.0 |
| 2010-03-03 00:00:00 | YM | Futures | 9725.9 | 9730.6 | 9725.9 | 9727.8 | 200.0 |
| 2010-03-03 01:00:00 | YM | Futures | 9727.8 | 9730.6 | 9724.0 | 9725.0 | 208.0 |
> showing 50 of 1,370 rows — these rows as CSV