PREVIEW / futures_1hour / 2010-11-25
file: by_date/futures_1hour/2010/2010-11-25.parquet size: 32 KB rows: 908
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-11-25 00:00:00 | ES | Futures | 1178.42 | 1178.42 | 1176.2 | 1177.18 | 2903.0 |
| 2010-11-25 01:00:00 | ES | Futures | 1177.18 | 1178.17 | 1176.44 | 1177.43 | 1332.0 |
| 2010-11-25 02:00:00 | ES | Futures | 1177.43 | 1178.66 | 1176.69 | 1177.68 | 5976.0 |
| 2010-11-25 03:00:00 | ES | Futures | 1177.43 | 1180.14 | 1176.2 | 1178.91 | 18669.0 |
| 2010-11-25 04:00:00 | ES | Futures | 1179.15 | 1179.89 | 1176.94 | 1177.92 | 25451.0 |
| 2010-11-25 05:00:00 | ES | Futures | 1178.17 | 1178.42 | 1176.44 | 1177.18 | 14163.0 |
| 2010-11-25 06:00:00 | ES | Futures | 1176.94 | 1178.17 | 1176.69 | 1177.18 | 4264.0 |
| 2010-11-25 07:00:00 | ES | Futures | 1177.18 | 1178.91 | 1176.94 | 1178.17 | 3269.0 |
| 2010-11-25 08:00:00 | ES | Futures | 1177.92 | 1178.66 | 1177.43 | 1177.68 | 3300.0 |
| 2010-11-25 09:00:00 | ES | Futures | 1177.68 | 1179.15 | 1176.94 | 1178.17 | 6318.0 |
| 2010-11-25 10:00:00 | ES | Futures | 1178.17 | 1182.11 | 1177.92 | 1181.87 | 14531.0 |
| 2010-11-25 11:00:00 | ES | Futures | 1182.11 | 1183.59 | 1181.87 | 1183.1 | 12408.0 |
| 2010-11-25 18:00:00 | ES | Futures | 1182.11 | 1182.61 | 1181.13 | 1181.13 | 3243.0 |
| 2010-11-25 19:00:00 | ES | Futures | 1181.13 | 1182.11 | 1180.88 | 1181.62 | 2509.0 |
| 2010-11-25 20:00:00 | ES | Futures | 1181.87 | 1181.87 | 1180.39 | 1180.88 | 2002.0 |
| 2010-11-25 21:00:00 | ES | Futures | 1180.88 | 1181.13 | 1180.14 | 1180.63 | 786.0 |
| 2010-11-25 22:00:00 | ES | Futures | 1180.63 | 1182.11 | 1179.89 | 1181.62 | 1897.0 |
| 2010-11-25 23:00:00 | ES | Futures | 1181.62 | 1181.62 | 1179.65 | 1179.89 | 1795.0 |
| 2010-11-25 00:00:00 | NQ | Futures | 2475.68 | 2475.68 | 2471.67 | 2473.67 | 188.0 |
| 2010-11-25 01:00:00 | NQ | Futures | 2473.39 | 2475.68 | 2472.24 | 2475.39 | 84.0 |
| 2010-11-25 02:00:00 | NQ | Futures | 2475.11 | 2477.69 | 2473.67 | 2475.11 | 358.0 |
| 2010-11-25 03:00:00 | NQ | Futures | 2474.82 | 2478.55 | 2471.67 | 2476.26 | 1168.0 |
| 2010-11-25 04:00:00 | NQ | Futures | 2476.54 | 2477.98 | 2474.82 | 2475.39 | 1286.0 |
| 2010-11-25 05:00:00 | NQ | Futures | 2475.97 | 2476.54 | 2472.53 | 2475.11 | 932.0 |
| 2010-11-25 06:00:00 | NQ | Futures | 2474.82 | 2477.12 | 2473.39 | 2473.67 | 264.0 |
| 2010-11-25 07:00:00 | NQ | Futures | 2473.67 | 2476.83 | 2473.1 | 2475.68 | 153.0 |
| 2010-11-25 08:00:00 | NQ | Futures | 2475.68 | 2476.54 | 2475.39 | 2475.97 | 247.0 |
| 2010-11-25 09:00:00 | NQ | Futures | 2475.68 | 2477.12 | 2470.52 | 2471.38 | 2144.0 |
| 2010-11-25 10:00:00 | NQ | Futures | 2471.09 | 2479.41 | 2470.8 | 2479.12 | 1867.0 |
| 2010-11-25 11:00:00 | NQ | Futures | 2479.41 | 2482.57 | 2479.12 | 2480.56 | 955.0 |
| 2010-11-25 18:00:00 | NQ | Futures | 2480.85 | 2482.28 | 2476.26 | 2478.84 | 111.0 |
| 2010-11-25 19:00:00 | NQ | Futures | 2479.12 | 2479.7 | 2477.69 | 2479.12 | 188.0 |
| 2010-11-25 20:00:00 | NQ | Futures | 2479.41 | 2479.41 | 2477.12 | 2477.69 | 175.0 |
| 2010-11-25 21:00:00 | NQ | Futures | 2477.69 | 2478.26 | 2475.97 | 2477.12 | 160.0 |
| 2010-11-25 22:00:00 | NQ | Futures | 2477.12 | 2479.41 | 2476.54 | 2479.12 | 123.0 |
| 2010-11-25 23:00:00 | NQ | Futures | 2478.84 | 2478.84 | 2474.82 | 2474.82 | 152.0 |
| 2010-11-25 00:00:00 | YM | Futures | 10619.2 | 10619.2 | 10600.1 | 10606.8 | 267.0 |
| 2010-11-25 01:00:00 | YM | Futures | 10606.8 | 10615.4 | 10603.0 | 10608.7 | 155.0 |
| 2010-11-25 02:00:00 | YM | Futures | 10608.7 | 10616.3 | 10601.1 | 10606.8 | 453.0 |
| 2010-11-25 03:00:00 | YM | Futures | 10606.8 | 10628.7 | 10595.4 | 10622.0 | 1410.0 |
| 2010-11-25 04:00:00 | YM | Futures | 10623.0 | 10625.9 | 10605.9 | 10610.6 | 632.0 |
| 2010-11-25 05:00:00 | YM | Futures | 10612.5 | 10616.3 | 10602.0 | 10608.7 | 517.0 |
| 2010-11-25 06:00:00 | YM | Futures | 10606.8 | 10616.3 | 10603.9 | 10607.8 | 423.0 |
| 2010-11-25 07:00:00 | YM | Futures | 10607.8 | 10621.1 | 10607.8 | 10615.4 | 595.0 |
| 2010-11-25 08:00:00 | YM | Futures | 10614.4 | 10618.2 | 10609.7 | 10610.6 | 361.0 |
| 2010-11-25 09:00:00 | YM | Futures | 10610.6 | 10622.0 | 10605.9 | 10614.4 | 434.0 |
| 2010-11-25 10:00:00 | YM | Futures | 10613.5 | 10646.8 | 10613.5 | 10646.8 | 806.0 |
| 2010-11-25 11:00:00 | YM | Futures | 10646.8 | 10658.2 | 10644.9 | 10655.4 | 629.0 |
| 2010-11-25 18:00:00 | YM | Futures | 10652.5 | 10652.5 | 10638.2 | 10644.0 | 152.0 |
| 2010-11-25 19:00:00 | YM | Futures | 10644.0 | 10645.9 | 10639.2 | 10643.0 | 112.0 |
> showing 50 of 908 rows — these rows as CSV