PREVIEW / futures_1hour / 2010-03-01
file: by_date/futures_1hour/2010/2010-03-01.parquet size: 44 KB rows: 1,328
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-01 00:00:00 | ES | Futures | 1078.61 | 1078.85 | 1078.12 | 1078.37 | 1803.0 |
| 2010-03-01 01:00:00 | ES | Futures | 1078.37 | 1079.1 | 1077.88 | 1079.1 | 2946.0 |
| 2010-03-01 02:00:00 | ES | Futures | 1079.1 | 1081.29 | 1078.37 | 1080.56 | 17875.0 |
| 2010-03-01 03:00:00 | ES | Futures | 1080.56 | 1081.53 | 1079.58 | 1080.31 | 28507.0 |
| 2010-03-01 04:00:00 | ES | Futures | 1080.31 | 1080.8 | 1078.12 | 1079.83 | 16183.0 |
| 2010-03-01 05:00:00 | ES | Futures | 1079.83 | 1080.56 | 1077.88 | 1078.12 | 13310.0 |
| 2010-03-01 06:00:00 | ES | Futures | 1078.12 | 1078.61 | 1074.47 | 1076.42 | 29610.0 |
| 2010-03-01 07:00:00 | ES | Futures | 1076.42 | 1078.12 | 1074.72 | 1074.72 | 32682.0 |
| 2010-03-01 08:00:00 | ES | Futures | 1074.96 | 1077.39 | 1074.96 | 1077.39 | 38108.0 |
| 2010-03-01 09:00:00 | ES | Futures | 1077.15 | 1081.04 | 1076.91 | 1078.61 | 191263.0 |
| 2010-03-01 10:00:00 | ES | Futures | 1078.61 | 1083.47 | 1077.15 | 1081.53 | 388215.0 |
| 2010-03-01 11:00:00 | ES | Futures | 1081.29 | 1084.45 | 1081.29 | 1083.23 | 189418.0 |
| 2010-03-01 12:00:00 | ES | Futures | 1083.47 | 1084.69 | 1082.02 | 1082.5 | 99911.0 |
| 2010-03-01 13:00:00 | ES | Futures | 1082.5 | 1084.45 | 1081.53 | 1083.96 | 103851.0 |
| 2010-03-01 14:00:00 | ES | Futures | 1084.2 | 1085.42 | 1082.74 | 1083.47 | 117349.0 |
| 2010-03-01 15:00:00 | ES | Futures | 1083.23 | 1084.69 | 1082.02 | 1084.2 | 189368.0 |
| 2010-03-01 16:00:00 | ES | Futures | 1084.2 | 1084.69 | 1083.47 | 1084.69 | 102190.0 |
| 2010-03-01 17:00:00 | ES | Futures | 1084.45 | 1084.69 | 1084.2 | 1084.45 | 1868.0 |
| 2010-03-01 18:00:00 | ES | Futures | 1084.2 | 1084.69 | 1083.96 | 1084.2 | 3030.0 |
| 2010-03-01 19:00:00 | ES | Futures | 1084.2 | 1084.93 | 1083.96 | 1084.69 | 3624.0 |
| 2010-03-01 20:00:00 | ES | Futures | 1084.45 | 1084.69 | 1083.72 | 1083.72 | 3873.0 |
| 2010-03-01 21:00:00 | ES | Futures | 1083.96 | 1084.45 | 1083.72 | 1083.96 | 2093.0 |
| 2010-03-01 22:00:00 | ES | Futures | 1084.2 | 1084.93 | 1083.23 | 1083.72 | 3662.0 |
| 2010-03-01 23:00:00 | ES | Futures | 1083.96 | 1084.45 | 1083.23 | 1084.45 | 2493.0 |
| 2010-03-01 00:00:00 | NQ | Futures | 2088.81 | 2089.09 | 2088.23 | 2088.81 | 72.0 |
| 2010-03-01 01:00:00 | NQ | Futures | 2089.09 | 2089.66 | 2087.95 | 2089.38 | 117.0 |
| 2010-03-01 02:00:00 | NQ | Futures | 2089.38 | 2091.09 | 2088.81 | 2090.81 | 1263.0 |
| 2010-03-01 03:00:00 | NQ | Futures | 2090.81 | 2092.23 | 2089.66 | 2091.38 | 2895.0 |
| 2010-03-01 04:00:00 | NQ | Futures | 2091.38 | 2092.52 | 2087.38 | 2090.23 | 1176.0 |
| 2010-03-01 05:00:00 | NQ | Futures | 2089.95 | 2091.09 | 2086.24 | 2086.24 | 1120.0 |
| 2010-03-01 06:00:00 | NQ | Futures | 2086.52 | 2088.23 | 2081.67 | 2085.09 | 2228.0 |
| 2010-03-01 07:00:00 | NQ | Futures | 2084.81 | 2087.09 | 2081.95 | 2081.95 | 1340.0 |
| 2010-03-01 08:00:00 | NQ | Futures | 2082.24 | 2085.09 | 2082.24 | 2084.81 | 3286.0 |
| 2010-03-01 09:00:00 | NQ | Futures | 2084.81 | 2095.09 | 2084.24 | 2090.81 | 36457.0 |
| 2010-03-01 10:00:00 | NQ | Futures | 2090.81 | 2105.09 | 2087.38 | 2103.09 | 68690.0 |
| 2010-03-01 11:00:00 | NQ | Futures | 2103.09 | 2108.51 | 2103.09 | 2106.23 | 33370.0 |
| 2010-03-01 12:00:00 | NQ | Futures | 2106.23 | 2109.94 | 2105.09 | 2105.66 | 17780.0 |
| 2010-03-01 13:00:00 | NQ | Futures | 2105.66 | 2109.66 | 2104.52 | 2108.8 | 17304.0 |
| 2010-03-01 14:00:00 | NQ | Futures | 2108.8 | 2111.94 | 2105.94 | 2107.37 | 18454.0 |
| 2010-03-01 15:00:00 | NQ | Futures | 2107.37 | 2109.66 | 2105.09 | 2107.94 | 33968.0 |
| 2010-03-01 16:00:00 | NQ | Futures | 2107.94 | 2108.51 | 2104.8 | 2107.94 | 14220.0 |
| 2010-03-01 17:00:00 | NQ | Futures | 2107.94 | 2108.23 | 2107.37 | 2107.66 | 188.0 |
| 2010-03-01 18:00:00 | NQ | Futures | 2107.37 | 2108.23 | 2106.8 | 2107.37 | 221.0 |
| 2010-03-01 19:00:00 | NQ | Futures | 2107.09 | 2108.23 | 2106.51 | 2107.37 | 254.0 |
| 2010-03-01 20:00:00 | NQ | Futures | 2107.09 | 2107.37 | 2105.94 | 2107.09 | 266.0 |
| 2010-03-01 21:00:00 | NQ | Futures | 2107.09 | 2108.23 | 2106.51 | 2107.37 | 170.0 |
| 2010-03-01 22:00:00 | NQ | Futures | 2107.37 | 2108.51 | 2106.23 | 2107.09 | 388.0 |
| 2010-03-01 23:00:00 | NQ | Futures | 2107.09 | 2109.09 | 2106.23 | 2109.09 | 258.0 |
| 2010-03-01 00:00:00 | CL | Futures | 170.65 | 170.76 | 170.59 | 170.69 | 190.0 |
| 2010-03-01 01:00:00 | CL | Futures | 170.69 | 170.71 | 169.97 | 170.18 | 732.0 |
> showing 50 of 1,328 rows — these rows as CSV