PREVIEW / futures_30min / 2019-01-30
file: by_date/futures_30min/2019/2019-01-30.parquet size: 90 KB rows: 3,330
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-01-30 00:00:00 | ES | Futures | 2871.74 | 2872.28 | 2869.29 | 2869.29 | 2339.0 |
| 2019-01-30 00:30:00 | ES | Futures | 2869.56 | 2870.65 | 2866.85 | 2867.93 | 3929.0 |
| 2019-01-30 01:00:00 | ES | Futures | 2867.93 | 2870.11 | 2867.66 | 2868.48 | 3730.0 |
| 2019-01-30 01:30:00 | ES | Futures | 2868.2 | 2868.75 | 2866.03 | 2866.3 | 3126.0 |
| 2019-01-30 02:00:00 | ES | Futures | 2866.58 | 2866.58 | 2863.86 | 2865.76 | 5213.0 |
| 2019-01-30 02:30:00 | ES | Futures | 2866.03 | 2869.02 | 2866.03 | 2869.02 | 4035.0 |
| 2019-01-30 03:00:00 | ES | Futures | 2869.02 | 2870.65 | 2867.12 | 2869.56 | 9353.0 |
| 2019-01-30 03:30:00 | ES | Futures | 2869.56 | 2874.18 | 2869.02 | 2873.91 | 6490.0 |
| 2019-01-30 04:00:00 | ES | Futures | 2873.91 | 2875.27 | 2872.28 | 2874.72 | 6451.0 |
| 2019-01-30 04:30:00 | ES | Futures | 2874.72 | 2876.62 | 2874.18 | 2874.72 | 6013.0 |
| 2019-01-30 05:00:00 | ES | Futures | 2874.72 | 2876.08 | 2873.09 | 2873.91 | 4370.0 |
| 2019-01-30 05:30:00 | ES | Futures | 2874.18 | 2876.08 | 2873.36 | 2875.54 | 2908.0 |
| 2019-01-30 06:00:00 | ES | Futures | 2875.27 | 2876.9 | 2874.72 | 2875.81 | 4447.0 |
| 2019-01-30 06:30:00 | ES | Futures | 2875.54 | 2877.71 | 2874.45 | 2877.71 | 3504.0 |
| 2019-01-30 07:00:00 | ES | Futures | 2877.71 | 2880.43 | 2876.9 | 2879.07 | 10059.0 |
| 2019-01-30 07:30:00 | ES | Futures | 2879.34 | 2884.5 | 2879.07 | 2880.7 | 29090.0 |
| 2019-01-30 08:00:00 | ES | Futures | 2880.7 | 2882.06 | 2877.71 | 2877.98 | 11219.0 |
| 2019-01-30 08:30:00 | ES | Futures | 2878.25 | 2882.33 | 2877.98 | 2881.24 | 14549.0 |
| 2019-01-30 09:00:00 | ES | Futures | 2881.24 | 2885.04 | 2880.43 | 2884.5 | 19528.0 |
| 2019-01-30 09:30:00 | ES | Futures | 2884.5 | 2886.13 | 2877.71 | 2878.8 | 144259.0 |
| 2019-01-30 10:00:00 | ES | Futures | 2878.52 | 2880.97 | 2874.99 | 2880.7 | 88295.0 |
| 2019-01-30 10:30:00 | ES | Futures | 2880.7 | 2884.23 | 2878.52 | 2882.06 | 74781.0 |
| 2019-01-30 11:00:00 | ES | Futures | 2881.78 | 2889.93 | 2881.78 | 2888.03 | 86279.0 |
| 2019-01-30 11:30:00 | ES | Futures | 2888.03 | 2892.65 | 2885.86 | 2892.1 | 57400.0 |
| 2019-01-30 12:00:00 | ES | Futures | 2892.38 | 2897.26 | 2891.56 | 2894.55 | 59999.0 |
| 2019-01-30 12:30:00 | ES | Futures | 2894.55 | 2895.36 | 2890.75 | 2891.56 | 40668.0 |
| 2019-01-30 13:00:00 | ES | Futures | 2891.83 | 2893.46 | 2889.12 | 2889.66 | 27949.0 |
| 2019-01-30 13:30:00 | ES | Futures | 2889.66 | 2890.75 | 2886.4 | 2888.57 | 30533.0 |
| 2019-01-30 14:00:00 | ES | Futures | 2888.57 | 2916.0 | 2884.23 | 2910.3 | 224506.0 |
| 2019-01-30 14:30:00 | ES | Futures | 2910.57 | 2921.98 | 2906.77 | 2921.44 | 119169.0 |
| 2019-01-30 15:00:00 | ES | Futures | 2921.71 | 2921.71 | 2908.4 | 2910.03 | 106930.0 |
| 2019-01-30 15:30:00 | ES | Futures | 2910.03 | 2911.93 | 2905.14 | 2911.66 | 158555.0 |
| 2019-01-30 16:00:00 | ES | Futures | 2911.93 | 2914.92 | 2906.23 | 2914.1 | 70007.0 |
| 2019-01-30 16:30:00 | ES | Futures | 2914.65 | 2916.82 | 2912.47 | 2914.92 | 7649.0 |
| 2019-01-30 18:00:00 | ES | Futures | 2915.19 | 2918.72 | 2913.29 | 2918.45 | 8867.0 |
| 2019-01-30 18:30:00 | ES | Futures | 2918.72 | 2920.08 | 2917.36 | 2919.53 | 4947.0 |
| 2019-01-30 19:00:00 | ES | Futures | 2919.81 | 2919.81 | 2916.0 | 2917.09 | 8560.0 |
| 2019-01-30 19:30:00 | ES | Futures | 2916.82 | 2917.36 | 2913.02 | 2914.65 | 9466.0 |
| 2019-01-30 20:00:00 | ES | Futures | 2914.37 | 2917.9 | 2914.37 | 2915.46 | 8004.0 |
| 2019-01-30 20:30:00 | ES | Futures | 2915.46 | 2918.99 | 2913.83 | 2918.45 | 6504.0 |
| 2019-01-30 21:00:00 | ES | Futures | 2918.45 | 2919.81 | 2917.09 | 2918.99 | 5087.0 |
| 2019-01-30 21:30:00 | ES | Futures | 2919.26 | 2921.44 | 2918.18 | 2920.62 | 4632.0 |
| 2019-01-30 22:00:00 | ES | Futures | 2920.62 | 2922.25 | 2919.81 | 2920.08 | 6376.0 |
| 2019-01-30 22:30:00 | ES | Futures | 2920.08 | 2924.15 | 2920.08 | 2923.06 | 5345.0 |
| 2019-01-30 23:00:00 | ES | Futures | 2923.06 | 2924.15 | 2922.25 | 2922.79 | 2440.0 |
| 2019-01-30 23:30:00 | ES | Futures | 2923.06 | 2923.34 | 2920.89 | 2921.16 | 2477.0 |
| 2019-01-30 00:00:00 | NQ | Futures | 7813.14 | 7813.73 | 7803.79 | 7804.38 | 1338.0 |
| 2019-01-30 00:30:00 | NQ | Futures | 7804.67 | 7810.51 | 7797.95 | 7799.7 | 2097.0 |
| 2019-01-30 01:00:00 | NQ | Futures | 7799.99 | 7809.34 | 7798.83 | 7803.79 | 2080.0 |
| 2019-01-30 01:30:00 | NQ | Futures | 7804.08 | 7807.01 | 7798.53 | 7800.87 | 1242.0 |
> showing 50 of 3,330 rows — these rows as CSV