PREVIEW / futures_30min / 2018-04-10
file: by_date/futures_30min/2018/2018-04-10.parquet size: 85 KB rows: 3,177
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 |
|---|---|---|---|---|---|---|---|
| 2018-04-10 00:00:00 | ES | Futures | 2886.28 | 2891.46 | 2885.18 | 2891.19 | 5730.0 |
| 2018-04-10 00:30:00 | ES | Futures | 2890.91 | 2891.73 | 2887.91 | 2890.64 | 2631.0 |
| 2018-04-10 01:00:00 | ES | Futures | 2890.37 | 2891.46 | 2886.0 | 2891.19 | 4340.0 |
| 2018-04-10 01:30:00 | ES | Futures | 2891.46 | 2894.19 | 2889.55 | 2891.73 | 4944.0 |
| 2018-04-10 02:00:00 | ES | Futures | 2891.73 | 2898.01 | 2889.82 | 2897.46 | 9407.0 |
| 2018-04-10 02:30:00 | ES | Futures | 2897.46 | 2899.65 | 2896.65 | 2898.01 | 7777.0 |
| 2018-04-10 03:00:00 | ES | Futures | 2898.01 | 2898.28 | 2889.55 | 2892.83 | 15638.0 |
| 2018-04-10 03:30:00 | ES | Futures | 2892.83 | 2893.64 | 2882.73 | 2884.64 | 17048.0 |
| 2018-04-10 04:00:00 | ES | Futures | 2884.64 | 2892.83 | 2882.45 | 2892.01 | 15363.0 |
| 2018-04-10 04:30:00 | ES | Futures | 2892.01 | 2892.28 | 2886.28 | 2887.64 | 5427.0 |
| 2018-04-10 05:00:00 | ES | Futures | 2887.64 | 2891.46 | 2886.82 | 2891.19 | 5684.0 |
| 2018-04-10 05:30:00 | ES | Futures | 2891.19 | 2893.1 | 2889.82 | 2890.37 | 4805.0 |
| 2018-04-10 06:00:00 | ES | Futures | 2890.37 | 2891.19 | 2887.37 | 2890.91 | 5581.0 |
| 2018-04-10 06:30:00 | ES | Futures | 2890.64 | 2892.55 | 2888.46 | 2889.55 | 6152.0 |
| 2018-04-10 07:00:00 | ES | Futures | 2889.55 | 2891.73 | 2887.91 | 2889.82 | 7563.0 |
| 2018-04-10 07:30:00 | ES | Futures | 2889.82 | 2895.01 | 2889.82 | 2892.55 | 17850.0 |
| 2018-04-10 08:00:00 | ES | Futures | 2892.83 | 2893.1 | 2889.28 | 2890.1 | 12156.0 |
| 2018-04-10 08:30:00 | ES | Futures | 2890.37 | 2892.83 | 2886.82 | 2889.55 | 23776.0 |
| 2018-04-10 09:00:00 | ES | Futures | 2889.82 | 2892.28 | 2889.0 | 2890.37 | 20186.0 |
| 2018-04-10 09:30:00 | ES | Futures | 2890.37 | 2893.92 | 2880.27 | 2882.18 | 182889.0 |
| 2018-04-10 10:00:00 | ES | Futures | 2881.91 | 2897.46 | 2880.54 | 2895.28 | 137173.0 |
| 2018-04-10 10:30:00 | ES | Futures | 2895.01 | 2903.47 | 2895.01 | 2898.56 | 109301.0 |
| 2018-04-10 11:00:00 | ES | Futures | 2898.28 | 2904.56 | 2895.55 | 2899.65 | 86406.0 |
| 2018-04-10 11:30:00 | ES | Futures | 2899.65 | 2907.02 | 2889.82 | 2901.29 | 136495.0 |
| 2018-04-10 12:00:00 | ES | Futures | 2901.01 | 2902.38 | 2876.45 | 2883.82 | 141419.0 |
| 2018-04-10 12:30:00 | ES | Futures | 2883.82 | 2895.83 | 2882.45 | 2891.73 | 108156.0 |
| 2018-04-10 13:00:00 | ES | Futures | 2891.73 | 2898.83 | 2889.0 | 2897.74 | 69198.0 |
| 2018-04-10 13:30:00 | ES | Futures | 2898.01 | 2902.1 | 2888.73 | 2900.74 | 100320.0 |
| 2018-04-10 14:00:00 | ES | Futures | 2901.01 | 2906.2 | 2897.46 | 2898.56 | 67458.0 |
| 2018-04-10 14:30:00 | ES | Futures | 2898.56 | 2904.56 | 2890.1 | 2904.01 | 113487.0 |
| 2018-04-10 15:00:00 | ES | Futures | 2904.29 | 2910.56 | 2898.83 | 2905.11 | 114311.0 |
| 2018-04-10 15:30:00 | ES | Futures | 2905.11 | 2905.65 | 2898.28 | 2899.92 | 153173.0 |
| 2018-04-10 16:00:00 | ES | Futures | 2899.92 | 2900.74 | 2896.1 | 2898.56 | 72617.0 |
| 2018-04-10 16:30:00 | ES | Futures | 2898.01 | 2898.83 | 2896.1 | 2897.74 | 7432.0 |
| 2018-04-10 18:00:00 | ES | Futures | 2897.74 | 2898.28 | 2894.46 | 2894.74 | 4682.0 |
| 2018-04-10 18:30:00 | ES | Futures | 2894.74 | 2897.74 | 2893.92 | 2895.28 | 2466.0 |
| 2018-04-10 19:00:00 | ES | Futures | 2895.28 | 2896.1 | 2892.01 | 2895.28 | 3024.0 |
| 2018-04-10 19:30:00 | ES | Futures | 2895.28 | 2897.19 | 2887.91 | 2891.46 | 5419.0 |
| 2018-04-10 20:00:00 | ES | Futures | 2891.46 | 2891.73 | 2885.46 | 2888.46 | 12275.0 |
| 2018-04-10 20:30:00 | ES | Futures | 2888.46 | 2889.55 | 2882.18 | 2884.09 | 8759.0 |
| 2018-04-10 21:00:00 | ES | Futures | 2884.09 | 2887.37 | 2884.09 | 2886.82 | 4593.0 |
| 2018-04-10 21:30:00 | ES | Futures | 2886.55 | 2888.73 | 2883.27 | 2883.55 | 7979.0 |
| 2018-04-10 22:00:00 | ES | Futures | 2883.55 | 2884.91 | 2883.0 | 2884.64 | 5817.0 |
| 2018-04-10 22:30:00 | ES | Futures | 2884.37 | 2885.73 | 2883.55 | 2884.91 | 3016.0 |
| 2018-04-10 23:00:00 | ES | Futures | 2884.91 | 2886.0 | 2884.64 | 2885.46 | 3141.0 |
| 2018-04-10 23:30:00 | ES | Futures | 2885.46 | 2885.46 | 2883.55 | 2884.64 | 2224.0 |
| 2018-04-10 00:00:00 | NQ | Futures | 7788.16 | 7807.07 | 7786.39 | 7802.64 | 2731.0 |
| 2018-04-10 00:30:00 | NQ | Futures | 7804.41 | 7807.66 | 7795.55 | 7799.68 | 1415.0 |
| 2018-04-10 01:00:00 | NQ | Futures | 7799.39 | 7800.57 | 7783.13 | 7798.21 | 2711.0 |
| 2018-04-10 01:30:00 | NQ | Futures | 7799.09 | 7805.59 | 7792.59 | 7797.91 | 1305.0 |
> showing 50 of 3,177 rows — these rows as CSV