PREVIEW / futures_1hour / 2019-02-08
file: by_date/futures_1hour/2019/2019-02-08.parquet size: 47 KB rows: 1,425
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-08 00:00:00 | ES | Futures | 2924.69 | 2926.32 | 2922.79 | 2926.05 | 4674.0 |
| 2019-02-08 01:00:00 | ES | Futures | 2925.78 | 2926.6 | 2924.15 | 2926.32 | 3061.0 |
| 2019-02-08 02:00:00 | ES | Futures | 2926.32 | 2928.77 | 2924.15 | 2925.24 | 11764.0 |
| 2019-02-08 03:00:00 | ES | Futures | 2925.24 | 2930.13 | 2924.15 | 2930.13 | 24129.0 |
| 2019-02-08 04:00:00 | ES | Futures | 2930.13 | 2932.3 | 2927.14 | 2928.22 | 15313.0 |
| 2019-02-08 05:00:00 | ES | Futures | 2928.5 | 2929.31 | 2924.69 | 2927.41 | 16823.0 |
| 2019-02-08 06:00:00 | ES | Futures | 2927.68 | 2928.77 | 2919.53 | 2920.89 | 21363.0 |
| 2019-02-08 07:00:00 | ES | Futures | 2920.62 | 2922.25 | 2918.99 | 2920.08 | 32123.0 |
| 2019-02-08 08:00:00 | ES | Futures | 2919.81 | 2925.78 | 2919.81 | 2922.25 | 34849.0 |
| 2019-02-08 09:00:00 | ES | Futures | 2922.52 | 2929.85 | 2919.53 | 2921.16 | 202543.0 |
| 2019-02-08 10:00:00 | ES | Futures | 2920.89 | 2926.6 | 2914.92 | 2917.9 | 271021.0 |
| 2019-02-08 11:00:00 | ES | Futures | 2917.63 | 2921.44 | 2912.2 | 2920.62 | 216273.0 |
| 2019-02-08 12:00:00 | ES | Futures | 2920.62 | 2925.24 | 2916.55 | 2923.34 | 114264.0 |
| 2019-02-08 13:00:00 | ES | Futures | 2923.34 | 2928.77 | 2923.06 | 2927.95 | 93682.0 |
| 2019-02-08 14:00:00 | ES | Futures | 2928.22 | 2934.74 | 2926.32 | 2931.21 | 113451.0 |
| 2019-02-08 15:00:00 | ES | Futures | 2931.48 | 2941.53 | 2929.31 | 2941.26 | 195926.0 |
| 2019-02-08 16:00:00 | ES | Futures | 2941.26 | 2942.89 | 2938.27 | 2941.8 | 79965.0 |
| 2019-02-08 00:00:00 | NQ | Futures | 8026.73 | 8030.24 | 8020.31 | 8028.49 | 2215.0 |
| 2019-02-08 01:00:00 | NQ | Futures | 8028.19 | 8033.75 | 8024.4 | 8032.87 | 1706.0 |
| 2019-02-08 02:00:00 | NQ | Futures | 8032.58 | 8039.59 | 8023.52 | 8026.15 | 4865.0 |
| 2019-02-08 03:00:00 | NQ | Futures | 8025.86 | 8038.13 | 8020.89 | 8037.54 | 7221.0 |
| 2019-02-08 04:00:00 | NQ | Futures | 8037.25 | 8045.73 | 8028.49 | 8032.58 | 4385.0 |
| 2019-02-08 05:00:00 | NQ | Futures | 8032.87 | 8035.5 | 8022.06 | 8031.99 | 5495.0 |
| 2019-02-08 06:00:00 | NQ | Futures | 8032.28 | 8036.38 | 8001.6 | 8006.28 | 7265.0 |
| 2019-02-08 07:00:00 | NQ | Futures | 8006.28 | 8011.25 | 7997.81 | 8000.44 | 11060.0 |
| 2019-02-08 08:00:00 | NQ | Futures | 8000.44 | 8017.09 | 8000.44 | 8005.7 | 10187.0 |
| 2019-02-08 09:00:00 | NQ | Futures | 8005.7 | 8037.54 | 8000.44 | 8007.16 | 69689.0 |
| 2019-02-08 10:00:00 | NQ | Futures | 8007.16 | 8044.56 | 7995.47 | 8023.52 | 89512.0 |
| 2019-02-08 11:00:00 | NQ | Futures | 8023.23 | 8033.45 | 7997.81 | 8030.53 | 67582.0 |
| 2019-02-08 12:00:00 | NQ | Futures | 8030.24 | 8039.01 | 8008.91 | 8033.45 | 39446.0 |
| 2019-02-08 13:00:00 | NQ | Futures | 8033.16 | 8057.71 | 8032.87 | 8055.37 | 30859.0 |
| 2019-02-08 14:00:00 | NQ | Futures | 8055.37 | 8079.33 | 8050.69 | 8068.22 | 34628.0 |
| 2019-02-08 15:00:00 | NQ | Futures | 8068.22 | 8089.26 | 8059.17 | 8088.97 | 42126.0 |
| 2019-02-08 16:00:00 | NQ | Futures | 8088.97 | 8095.11 | 8081.37 | 8092.48 | 12310.0 |
| 2019-02-08 00:00:00 | YM | Futures | 27169.8 | 27186.1 | 27152.4 | 27182.8 | 1607.0 |
| 2019-02-08 01:00:00 | YM | Futures | 27181.8 | 27183.9 | 27162.2 | 27182.8 | 1167.0 |
| 2019-02-08 02:00:00 | YM | Futures | 27181.8 | 27205.6 | 27159.0 | 27170.9 | 3765.0 |
| 2019-02-08 03:00:00 | YM | Futures | 27168.7 | 27221.9 | 27160.0 | 27219.8 | 6027.0 |
| 2019-02-08 04:00:00 | YM | Futures | 27218.7 | 27241.5 | 27197.0 | 27208.9 | 4130.0 |
| 2019-02-08 05:00:00 | YM | Futures | 27210.0 | 27217.6 | 27176.3 | 27198.0 | 3924.0 |
| 2019-02-08 06:00:00 | YM | Futures | 27199.1 | 27212.2 | 27128.6 | 27138.3 | 4873.0 |
| 2019-02-08 07:00:00 | YM | Futures | 27137.2 | 27152.4 | 27117.7 | 27142.7 | 5301.0 |
| 2019-02-08 08:00:00 | YM | Futures | 27143.8 | 27189.4 | 27143.8 | 27149.2 | 6474.0 |
| 2019-02-08 09:00:00 | YM | Futures | 27149.2 | 27199.1 | 27092.7 | 27102.5 | 27495.0 |
| 2019-02-08 10:00:00 | YM | Futures | 27100.3 | 27128.6 | 27030.8 | 27042.8 | 39051.0 |
| 2019-02-08 11:00:00 | YM | Futures | 27042.8 | 27078.6 | 26992.8 | 27069.9 | 30983.0 |
| 2019-02-08 12:00:00 | YM | Futures | 27069.9 | 27121.0 | 27033.0 | 27097.1 | 18308.0 |
| 2019-02-08 13:00:00 | YM | Futures | 27098.2 | 27140.5 | 27092.7 | 27127.5 | 13016.0 |
| 2019-02-08 14:00:00 | YM | Futures | 27127.5 | 27160.0 | 27111.2 | 27127.5 | 13254.0 |
| 2019-02-08 15:00:00 | YM | Futures | 27127.5 | 27238.2 | 27107.9 | 27233.9 | 21135.0 |
> showing 50 of 1,425 rows — these rows as CSV