PREVIEW / futures_30min / 2018-12-14
file: by_date/futures_30min/2018/2018-12-14.parquet size: 72 KB rows: 2,586
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-12-14 00:00:00 | ES | Futures | 2857.34 | 2859.24 | 2855.98 | 2859.24 | 1704.0 |
| 2018-12-14 00:30:00 | ES | Futures | 2858.97 | 2859.24 | 2853.27 | 2854.35 | 2386.0 |
| 2018-12-14 01:00:00 | ES | Futures | 2854.35 | 2856.25 | 2853.0 | 2855.98 | 1547.0 |
| 2018-12-14 01:30:00 | ES | Futures | 2855.98 | 2857.61 | 2854.9 | 2856.8 | 1348.0 |
| 2018-12-14 02:00:00 | ES | Futures | 2856.8 | 2859.79 | 2854.35 | 2855.98 | 3865.0 |
| 2018-12-14 02:30:00 | ES | Futures | 2855.98 | 2858.7 | 2854.9 | 2856.25 | 2675.0 |
| 2018-12-14 03:00:00 | ES | Futures | 2856.53 | 2858.7 | 2851.37 | 2853.54 | 7784.0 |
| 2018-12-14 03:30:00 | ES | Futures | 2853.27 | 2854.35 | 2845.39 | 2845.66 | 9250.0 |
| 2018-12-14 04:00:00 | ES | Futures | 2845.39 | 2849.19 | 2844.31 | 2844.58 | 5864.0 |
| 2018-12-14 04:30:00 | ES | Futures | 2844.58 | 2847.56 | 2843.22 | 2846.48 | 5041.0 |
| 2018-12-14 05:00:00 | ES | Futures | 2846.48 | 2853.54 | 2846.48 | 2852.45 | 7412.0 |
| 2018-12-14 05:30:00 | ES | Futures | 2852.45 | 2854.35 | 2849.74 | 2852.45 | 4425.0 |
| 2018-12-14 06:00:00 | ES | Futures | 2852.18 | 2855.44 | 2851.37 | 2853.81 | 4523.0 |
| 2018-12-14 06:30:00 | ES | Futures | 2854.08 | 2856.53 | 2851.37 | 2854.35 | 4474.0 |
| 2018-12-14 07:00:00 | ES | Futures | 2854.35 | 2855.98 | 2850.82 | 2853.54 | 5724.0 |
| 2018-12-14 07:30:00 | ES | Futures | 2853.27 | 2856.8 | 2853.27 | 2854.08 | 4258.0 |
| 2018-12-14 08:00:00 | ES | Futures | 2854.08 | 2855.71 | 2851.37 | 2851.64 | 6589.0 |
| 2018-12-14 08:30:00 | ES | Futures | 2851.91 | 2858.7 | 2851.91 | 2857.07 | 12234.0 |
| 2018-12-14 09:00:00 | ES | Futures | 2856.8 | 2858.16 | 2854.63 | 2855.71 | 12101.0 |
| 2018-12-14 09:30:00 | ES | Futures | 2855.71 | 2865.49 | 2851.64 | 2863.32 | 128684.0 |
| 2018-12-14 10:00:00 | ES | Futures | 2863.32 | 2867.66 | 2856.53 | 2856.8 | 77851.0 |
| 2018-12-14 10:30:00 | ES | Futures | 2856.8 | 2863.86 | 2849.47 | 2856.53 | 87174.0 |
| 2018-12-14 11:00:00 | ES | Futures | 2856.53 | 2861.96 | 2845.39 | 2847.84 | 87335.0 |
| 2018-12-14 11:30:00 | ES | Futures | 2847.84 | 2854.35 | 2834.8 | 2836.7 | 106852.0 |
| 2018-12-14 12:00:00 | ES | Futures | 2836.43 | 2845.39 | 2835.89 | 2844.31 | 87167.0 |
| 2018-12-14 12:30:00 | ES | Futures | 2844.03 | 2849.47 | 2840.5 | 2842.13 | 45085.0 |
| 2018-12-14 13:00:00 | ES | Futures | 2842.13 | 2847.84 | 2838.06 | 2840.5 | 44681.0 |
| 2018-12-14 13:30:00 | ES | Futures | 2840.23 | 2841.05 | 2832.63 | 2835.61 | 61215.0 |
| 2018-12-14 14:00:00 | ES | Futures | 2835.34 | 2840.77 | 2832.63 | 2837.79 | 46475.0 |
| 2018-12-14 14:30:00 | ES | Futures | 2837.79 | 2838.33 | 2823.12 | 2831.27 | 99911.0 |
| 2018-12-14 15:00:00 | ES | Futures | 2831.54 | 2838.6 | 2828.01 | 2829.37 | 89876.0 |
| 2018-12-14 15:30:00 | ES | Futures | 2829.37 | 2832.36 | 2821.49 | 2828.82 | 157782.0 |
| 2018-12-14 16:00:00 | ES | Futures | 2829.1 | 2832.63 | 2827.2 | 2830.18 | 53274.0 |
| 2018-12-14 16:30:00 | ES | Futures | 2829.1 | 2829.37 | 2823.94 | 2824.75 | 6095.0 |
| 2018-12-14 00:00:00 | NQ | Futures | 7847.91 | 7855.22 | 7842.07 | 7854.63 | 772.0 |
| 2018-12-14 00:30:00 | NQ | Futures | 7854.05 | 7854.63 | 7837.1 | 7840.9 | 761.0 |
| 2018-12-14 01:00:00 | NQ | Futures | 7841.49 | 7845.58 | 7834.18 | 7844.7 | 839.0 |
| 2018-12-14 01:30:00 | NQ | Futures | 7844.7 | 7849.08 | 7842.36 | 7846.45 | 669.0 |
| 2018-12-14 02:00:00 | NQ | Futures | 7846.74 | 7857.85 | 7837.69 | 7844.11 | 1523.0 |
| 2018-12-14 02:30:00 | NQ | Futures | 7843.82 | 7854.63 | 7841.19 | 7846.16 | 1054.0 |
| 2018-12-14 03:00:00 | NQ | Futures | 7846.16 | 7854.34 | 7826.88 | 7832.14 | 2682.0 |
| 2018-12-14 03:30:00 | NQ | Futures | 7831.84 | 7834.18 | 7804.96 | 7807.59 | 3466.0 |
| 2018-12-14 04:00:00 | NQ | Futures | 7807.01 | 7818.99 | 7805.25 | 7808.18 | 2324.0 |
| 2018-12-14 04:30:00 | NQ | Futures | 7808.47 | 7817.23 | 7801.75 | 7813.43 | 1589.0 |
| 2018-12-14 05:00:00 | NQ | Futures | 7813.43 | 7836.81 | 7813.43 | 7835.06 | 2842.0 |
| 2018-12-14 05:30:00 | NQ | Futures | 7835.06 | 7843.53 | 7828.63 | 7836.81 | 1794.0 |
| 2018-12-14 06:00:00 | NQ | Futures | 7837.1 | 7847.04 | 7832.14 | 7840.32 | 1840.0 |
| 2018-12-14 06:30:00 | NQ | Futures | 7840.9 | 7851.42 | 7833.6 | 7844.99 | 1757.0 |
| 2018-12-14 07:00:00 | NQ | Futures | 7844.99 | 7853.76 | 7837.39 | 7845.58 | 1778.0 |
| 2018-12-14 07:30:00 | NQ | Futures | 7845.28 | 7854.63 | 7839.44 | 7842.95 | 1643.0 |
> showing 50 of 2,586 rows — these rows as CSV