PREVIEW / futures_1hour / 2010-03-08
file: by_date/futures_1hour/2010/2010-03-08.parquet size: 42 KB rows: 1,334
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-08 00:00:00 | ES | Futures | 1107.8 | 1107.8 | 1106.34 | 1107.31 | 3173.0 |
| 2010-03-08 01:00:00 | ES | Futures | 1107.07 | 1108.77 | 1107.07 | 1108.53 | 4239.0 |
| 2010-03-08 02:00:00 | ES | Futures | 1108.53 | 1109.02 | 1107.07 | 1107.8 | 8231.0 |
| 2010-03-08 03:00:00 | ES | Futures | 1107.56 | 1107.8 | 1105.12 | 1105.61 | 18648.0 |
| 2010-03-08 04:00:00 | ES | Futures | 1105.37 | 1107.07 | 1104.88 | 1105.12 | 13772.0 |
| 2010-03-08 05:00:00 | ES | Futures | 1105.12 | 1105.61 | 1104.64 | 1104.88 | 9558.0 |
| 2010-03-08 06:00:00 | ES | Futures | 1105.12 | 1106.1 | 1104.39 | 1105.85 | 9105.0 |
| 2010-03-08 07:00:00 | ES | Futures | 1105.61 | 1108.04 | 1105.37 | 1107.56 | 19409.0 |
| 2010-03-08 08:00:00 | ES | Futures | 1107.56 | 1108.53 | 1105.85 | 1106.1 | 30157.0 |
| 2010-03-08 09:00:00 | ES | Futures | 1106.1 | 1109.75 | 1106.1 | 1106.83 | 184643.0 |
| 2010-03-08 10:00:00 | ES | Futures | 1106.83 | 1109.26 | 1106.34 | 1108.29 | 195801.0 |
| 2010-03-08 11:00:00 | ES | Futures | 1108.29 | 1108.77 | 1105.37 | 1105.85 | 142311.0 |
| 2010-03-08 12:00:00 | ES | Futures | 1106.1 | 1107.8 | 1105.61 | 1107.8 | 103723.0 |
| 2010-03-08 13:00:00 | ES | Futures | 1107.56 | 1109.26 | 1107.56 | 1108.53 | 83863.0 |
| 2010-03-08 14:00:00 | ES | Futures | 1108.77 | 1109.26 | 1107.31 | 1107.8 | 74616.0 |
| 2010-03-08 15:00:00 | ES | Futures | 1107.8 | 1108.53 | 1106.83 | 1107.07 | 134238.0 |
| 2010-03-08 16:00:00 | ES | Futures | 1107.31 | 1107.56 | 1105.85 | 1106.58 | 79648.0 |
| 2010-03-08 17:00:00 | ES | Futures | 1106.34 | 1106.34 | 1105.37 | 1105.61 | 1868.0 |
| 2010-03-08 18:00:00 | ES | Futures | 1105.61 | 1106.1 | 1104.88 | 1105.12 | 2501.0 |
| 2010-03-08 19:00:00 | ES | Futures | 1105.12 | 1105.37 | 1104.39 | 1104.88 | 4409.0 |
| 2010-03-08 20:00:00 | ES | Futures | 1105.12 | 1105.61 | 1104.64 | 1105.12 | 2231.0 |
| 2010-03-08 21:00:00 | ES | Futures | 1104.88 | 1105.61 | 1103.67 | 1104.39 | 3680.0 |
| 2010-03-08 22:00:00 | ES | Futures | 1104.39 | 1105.37 | 1104.15 | 1104.88 | 3554.0 |
| 2010-03-08 23:00:00 | ES | Futures | 1104.88 | 1105.37 | 1104.39 | 1104.88 | 1311.0 |
| 2010-03-08 00:00:00 | NQ | Futures | 2155.64 | 2156.21 | 2154.5 | 2155.93 | 177.0 |
| 2010-03-08 01:00:00 | NQ | Futures | 2155.64 | 2158.21 | 2155.64 | 2157.93 | 265.0 |
| 2010-03-08 02:00:00 | NQ | Futures | 2157.93 | 2158.5 | 2155.36 | 2155.93 | 451.0 |
| 2010-03-08 03:00:00 | NQ | Futures | 2155.93 | 2155.93 | 2152.5 | 2153.07 | 969.0 |
| 2010-03-08 04:00:00 | NQ | Futures | 2153.07 | 2155.36 | 2151.93 | 2152.22 | 840.0 |
| 2010-03-08 05:00:00 | NQ | Futures | 2152.22 | 2153.36 | 2151.64 | 2152.79 | 508.0 |
| 2010-03-08 06:00:00 | NQ | Futures | 2152.79 | 2153.64 | 2151.64 | 2153.36 | 541.0 |
| 2010-03-08 07:00:00 | NQ | Futures | 2153.36 | 2157.07 | 2153.36 | 2156.5 | 974.0 |
| 2010-03-08 08:00:00 | NQ | Futures | 2156.79 | 2158.5 | 2154.5 | 2155.36 | 3519.0 |
| 2010-03-08 09:00:00 | NQ | Futures | 2155.36 | 2161.36 | 2155.36 | 2157.07 | 33667.0 |
| 2010-03-08 10:00:00 | NQ | Futures | 2157.07 | 2163.07 | 2156.21 | 2162.21 | 33805.0 |
| 2010-03-08 11:00:00 | NQ | Futures | 2161.93 | 2163.07 | 2156.5 | 2160.21 | 29070.0 |
| 2010-03-08 12:00:00 | NQ | Futures | 2160.21 | 2162.5 | 2158.5 | 2162.5 | 16990.0 |
| 2010-03-08 13:00:00 | NQ | Futures | 2162.21 | 2164.78 | 2162.21 | 2163.64 | 15318.0 |
| 2010-03-08 14:00:00 | NQ | Futures | 2163.93 | 2164.78 | 2160.78 | 2161.07 | 14847.0 |
| 2010-03-08 15:00:00 | NQ | Futures | 2161.36 | 2163.64 | 2159.07 | 2159.36 | 28298.0 |
| 2010-03-08 16:00:00 | NQ | Futures | 2159.36 | 2159.93 | 2155.93 | 2157.64 | 12916.0 |
| 2010-03-08 17:00:00 | NQ | Futures | 2157.64 | 2157.93 | 2156.79 | 2156.79 | 34.0 |
| 2010-03-08 18:00:00 | NQ | Futures | 2156.5 | 2157.36 | 2155.07 | 2155.93 | 318.0 |
| 2010-03-08 19:00:00 | NQ | Futures | 2155.64 | 2156.21 | 2154.79 | 2155.64 | 394.0 |
| 2010-03-08 20:00:00 | NQ | Futures | 2155.36 | 2156.79 | 2155.36 | 2155.64 | 164.0 |
| 2010-03-08 21:00:00 | NQ | Futures | 2155.64 | 2156.79 | 2153.93 | 2155.07 | 202.0 |
| 2010-03-08 22:00:00 | NQ | Futures | 2155.07 | 2156.5 | 2155.07 | 2155.36 | 170.0 |
| 2010-03-08 23:00:00 | NQ | Futures | 2155.64 | 2156.21 | 2155.07 | 2155.64 | 72.0 |
| 2010-03-08 00:00:00 | YM | Futures | 9877.5 | 9879.4 | 9871.9 | 9878.4 | 244.0 |
| 2010-03-08 01:00:00 | YM | Futures | 9877.5 | 9886.9 | 9877.5 | 9886.9 | 260.0 |
> showing 50 of 1,334 rows — these rows as CSV