PREVIEW / futures_1hour / 2010-03-04
file: by_date/futures_1hour/2010/2010-03-04.parquet size: 45 KB rows: 1,372
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-04 00:00:00 | ES | Futures | 1084.93 | 1085.18 | 1083.96 | 1084.2 | 3629.0 |
| 2010-03-04 01:00:00 | ES | Futures | 1084.2 | 1084.93 | 1083.96 | 1084.2 | 4488.0 |
| 2010-03-04 02:00:00 | ES | Futures | 1084.45 | 1085.42 | 1083.96 | 1084.69 | 10214.0 |
| 2010-03-04 03:00:00 | ES | Futures | 1084.93 | 1086.88 | 1084.45 | 1086.64 | 25886.0 |
| 2010-03-04 04:00:00 | ES | Futures | 1086.39 | 1087.37 | 1085.66 | 1086.88 | 12146.0 |
| 2010-03-04 05:00:00 | ES | Futures | 1086.88 | 1088.34 | 1086.88 | 1088.1 | 12195.0 |
| 2010-03-04 06:00:00 | ES | Futures | 1088.1 | 1089.31 | 1086.15 | 1087.85 | 20313.0 |
| 2010-03-04 07:00:00 | ES | Futures | 1087.85 | 1089.31 | 1087.12 | 1089.31 | 20599.0 |
| 2010-03-04 08:00:00 | ES | Futures | 1089.07 | 1091.26 | 1087.85 | 1090.29 | 76084.0 |
| 2010-03-04 09:00:00 | ES | Futures | 1090.29 | 1092.48 | 1088.83 | 1091.5 | 178369.0 |
| 2010-03-04 10:00:00 | ES | Futures | 1091.5 | 1092.72 | 1085.42 | 1087.37 | 330497.0 |
| 2010-03-04 11:00:00 | ES | Futures | 1087.61 | 1089.8 | 1087.12 | 1089.07 | 154303.0 |
| 2010-03-04 12:00:00 | ES | Futures | 1089.07 | 1089.56 | 1087.61 | 1088.83 | 75297.0 |
| 2010-03-04 13:00:00 | ES | Futures | 1088.83 | 1090.53 | 1087.12 | 1088.83 | 105914.0 |
| 2010-03-04 14:00:00 | ES | Futures | 1088.83 | 1090.53 | 1087.85 | 1090.04 | 95774.0 |
| 2010-03-04 15:00:00 | ES | Futures | 1090.04 | 1093.2 | 1088.83 | 1091.5 | 209039.0 |
| 2010-03-04 16:00:00 | ES | Futures | 1091.26 | 1092.72 | 1091.02 | 1091.99 | 79476.0 |
| 2010-03-04 17:00:00 | ES | Futures | 1091.99 | 1092.23 | 1091.75 | 1092.23 | 1436.0 |
| 2010-03-04 18:00:00 | ES | Futures | 1092.23 | 1092.96 | 1091.5 | 1092.72 | 4479.0 |
| 2010-03-04 19:00:00 | ES | Futures | 1092.96 | 1093.69 | 1092.72 | 1092.96 | 5122.0 |
| 2010-03-04 20:00:00 | ES | Futures | 1093.2 | 1093.45 | 1092.96 | 1093.45 | 1162.0 |
| 2010-03-04 21:00:00 | ES | Futures | 1093.45 | 1093.69 | 1092.72 | 1092.72 | 1754.0 |
| 2010-03-04 22:00:00 | ES | Futures | 1092.72 | 1093.45 | 1092.23 | 1093.2 | 2250.0 |
| 2010-03-04 23:00:00 | ES | Futures | 1093.2 | 1093.45 | 1092.72 | 1093.45 | 2308.0 |
| 2010-03-04 00:00:00 | NQ | Futures | 2109.66 | 2109.94 | 2109.09 | 2109.66 | 272.0 |
| 2010-03-04 01:00:00 | NQ | Futures | 2109.37 | 2109.66 | 2107.09 | 2107.37 | 664.0 |
| 2010-03-04 02:00:00 | NQ | Futures | 2107.66 | 2109.66 | 2107.37 | 2109.66 | 558.0 |
| 2010-03-04 03:00:00 | NQ | Futures | 2109.09 | 2114.23 | 2108.8 | 2113.08 | 936.0 |
| 2010-03-04 04:00:00 | NQ | Futures | 2113.08 | 2114.23 | 2111.37 | 2113.08 | 455.0 |
| 2010-03-04 05:00:00 | NQ | Futures | 2113.37 | 2116.23 | 2113.37 | 2115.66 | 1104.0 |
| 2010-03-04 06:00:00 | NQ | Futures | 2115.37 | 2117.94 | 2113.08 | 2115.37 | 945.0 |
| 2010-03-04 07:00:00 | NQ | Futures | 2115.37 | 2116.51 | 2113.08 | 2116.23 | 3078.0 |
| 2010-03-04 08:00:00 | NQ | Futures | 2116.23 | 2123.08 | 2113.66 | 2119.94 | 5983.0 |
| 2010-03-04 09:00:00 | NQ | Futures | 2120.23 | 2123.94 | 2113.94 | 2122.22 | 29661.0 |
| 2010-03-04 10:00:00 | NQ | Futures | 2122.22 | 2122.8 | 2107.37 | 2113.94 | 44542.0 |
| 2010-03-04 11:00:00 | NQ | Futures | 2114.23 | 2119.08 | 2113.08 | 2117.37 | 22812.0 |
| 2010-03-04 12:00:00 | NQ | Futures | 2117.65 | 2117.94 | 2113.66 | 2115.66 | 14644.0 |
| 2010-03-04 13:00:00 | NQ | Futures | 2115.94 | 2118.8 | 2113.08 | 2116.51 | 14016.0 |
| 2010-03-04 14:00:00 | NQ | Futures | 2116.23 | 2121.37 | 2115.66 | 2119.65 | 16293.0 |
| 2010-03-04 15:00:00 | NQ | Futures | 2119.94 | 2125.94 | 2117.37 | 2123.37 | 30332.0 |
| 2010-03-04 16:00:00 | NQ | Futures | 2123.37 | 2125.37 | 2122.51 | 2122.8 | 7644.0 |
| 2010-03-04 17:00:00 | NQ | Futures | 2122.8 | 2123.65 | 2122.8 | 2123.37 | 33.0 |
| 2010-03-04 18:00:00 | NQ | Futures | 2123.37 | 2125.37 | 2121.65 | 2125.37 | 317.0 |
| 2010-03-04 19:00:00 | NQ | Futures | 2125.37 | 2126.79 | 2125.37 | 2125.37 | 384.0 |
| 2010-03-04 20:00:00 | NQ | Futures | 2125.65 | 2126.51 | 2125.08 | 2125.94 | 124.0 |
| 2010-03-04 21:00:00 | NQ | Futures | 2125.94 | 2126.51 | 2124.8 | 2124.8 | 126.0 |
| 2010-03-04 22:00:00 | NQ | Futures | 2124.8 | 2126.22 | 2124.8 | 2125.94 | 155.0 |
| 2010-03-04 23:00:00 | NQ | Futures | 2126.22 | 2126.22 | 2124.8 | 2125.65 | 137.0 |
| 2010-03-04 00:00:00 | YM | Futures | 9695.0 | 9695.9 | 9686.6 | 9692.2 | 232.0 |
| 2010-03-04 01:00:00 | YM | Futures | 9691.3 | 9694.1 | 9688.5 | 9692.2 | 362.0 |
> showing 50 of 1,372 rows — these rows as CSV