PREVIEW / futures_30min / 2019-06-13
file: by_date/futures_30min/2019/2019-06-13.parquet size: 81 KB rows: 3,195
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-06-13 00:00:00 | ES | Futures | 3119.84 | 3120.93 | 3117.41 | 3117.68 | 3635.0 |
| 2019-06-13 00:30:00 | ES | Futures | 3117.95 | 3120.12 | 3117.95 | 3119.57 | 2170.0 |
| 2019-06-13 01:00:00 | ES | Futures | 3119.57 | 3120.93 | 3116.05 | 3117.41 | 5765.0 |
| 2019-06-13 01:30:00 | ES | Futures | 3117.41 | 3122.01 | 3117.13 | 3120.66 | 4333.0 |
| 2019-06-13 02:00:00 | ES | Futures | 3120.93 | 3122.01 | 3118.76 | 3119.3 | 4946.0 |
| 2019-06-13 02:30:00 | ES | Futures | 3119.3 | 3123.1 | 3119.03 | 3121.2 | 7995.0 |
| 2019-06-13 03:00:00 | ES | Futures | 3121.2 | 3123.91 | 3118.76 | 3123.64 | 14459.0 |
| 2019-06-13 03:30:00 | ES | Futures | 3123.64 | 3133.13 | 3123.37 | 3130.15 | 20703.0 |
| 2019-06-13 04:00:00 | ES | Futures | 3130.15 | 3133.13 | 3128.52 | 3131.23 | 11758.0 |
| 2019-06-13 04:30:00 | ES | Futures | 3131.23 | 3136.92 | 3131.23 | 3134.48 | 13945.0 |
| 2019-06-13 05:00:00 | ES | Futures | 3134.48 | 3136.38 | 3133.4 | 3135.3 | 10101.0 |
| 2019-06-13 05:30:00 | ES | Futures | 3135.3 | 3135.84 | 3132.32 | 3132.32 | 7836.0 |
| 2019-06-13 06:00:00 | ES | Futures | 3132.59 | 3135.03 | 3131.5 | 3134.76 | 7882.0 |
| 2019-06-13 06:30:00 | ES | Futures | 3134.76 | 3138.82 | 3131.23 | 3138.55 | 12663.0 |
| 2019-06-13 07:00:00 | ES | Futures | 3138.28 | 3138.82 | 3134.48 | 3135.03 | 9336.0 |
| 2019-06-13 07:30:00 | ES | Futures | 3135.03 | 3136.11 | 3132.86 | 3134.48 | 6058.0 |
| 2019-06-13 08:00:00 | ES | Futures | 3134.48 | 3135.03 | 3130.96 | 3132.59 | 11241.0 |
| 2019-06-13 08:30:00 | ES | Futures | 3132.32 | 3136.11 | 3130.96 | 3134.76 | 14377.0 |
| 2019-06-13 09:00:00 | ES | Futures | 3134.76 | 3135.57 | 3132.59 | 3134.48 | 14969.0 |
| 2019-06-13 09:30:00 | ES | Futures | 3134.48 | 3140.99 | 3131.77 | 3138.01 | 109152.0 |
| 2019-06-13 10:00:00 | ES | Futures | 3138.01 | 3139.36 | 3128.79 | 3135.84 | 92100.0 |
| 2019-06-13 10:30:00 | ES | Futures | 3135.57 | 3137.2 | 3129.06 | 3129.33 | 71284.0 |
| 2019-06-13 11:00:00 | ES | Futures | 3129.33 | 3132.59 | 3126.08 | 3132.04 | 63708.0 |
| 2019-06-13 11:30:00 | ES | Futures | 3131.77 | 3134.21 | 3129.88 | 3133.13 | 40694.0 |
| 2019-06-13 12:00:00 | ES | Futures | 3133.4 | 3135.84 | 3130.69 | 3130.96 | 39558.0 |
| 2019-06-13 12:30:00 | ES | Futures | 3130.69 | 3138.01 | 3130.15 | 3137.74 | 52362.0 |
| 2019-06-13 13:00:00 | ES | Futures | 3138.01 | 3139.91 | 3135.57 | 3136.65 | 36590.0 |
| 2019-06-13 13:30:00 | ES | Futures | 3136.92 | 3137.74 | 3134.21 | 3136.38 | 25773.0 |
| 2019-06-13 14:00:00 | ES | Futures | 3136.38 | 3136.65 | 3130.42 | 3133.94 | 37377.0 |
| 2019-06-13 14:30:00 | ES | Futures | 3134.21 | 3134.76 | 3129.33 | 3132.32 | 41106.0 |
| 2019-06-13 15:00:00 | ES | Futures | 3132.32 | 3132.86 | 3126.35 | 3129.06 | 54002.0 |
| 2019-06-13 15:30:00 | ES | Futures | 3129.06 | 3138.55 | 3127.98 | 3137.47 | 132785.0 |
| 2019-06-13 16:00:00 | ES | Futures | 3137.47 | 3139.09 | 3136.38 | 3138.82 | 44141.0 |
| 2019-06-13 16:30:00 | ES | Futures | 3139.09 | 3139.91 | 3138.55 | 3138.82 | 6500.0 |
| 2019-06-13 18:00:00 | ES | Futures | 3138.01 | 3138.28 | 3135.03 | 3137.2 | 3335.0 |
| 2019-06-13 18:30:00 | ES | Futures | 3136.92 | 3137.2 | 3133.94 | 3136.65 | 1570.0 |
| 2019-06-13 19:00:00 | ES | Futures | 3136.38 | 3138.28 | 3135.57 | 3136.11 | 1429.0 |
| 2019-06-13 19:30:00 | ES | Futures | 3136.11 | 3138.28 | 3135.03 | 3135.3 | 2633.0 |
| 2019-06-13 20:00:00 | ES | Futures | 3135.3 | 3137.47 | 3132.86 | 3137.47 | 6345.0 |
| 2019-06-13 20:30:00 | ES | Futures | 3137.2 | 3138.82 | 3136.11 | 3136.65 | 3148.0 |
| 2019-06-13 21:00:00 | ES | Futures | 3136.92 | 3140.45 | 3136.11 | 3139.36 | 6325.0 |
| 2019-06-13 21:30:00 | ES | Futures | 3139.36 | 3143.43 | 3138.82 | 3140.18 | 9569.0 |
| 2019-06-13 22:00:00 | ES | Futures | 3140.18 | 3141.53 | 3138.55 | 3141.53 | 3827.0 |
| 2019-06-13 22:30:00 | ES | Futures | 3141.53 | 3142.35 | 3140.18 | 3142.08 | 2571.0 |
| 2019-06-13 23:00:00 | ES | Futures | 3142.35 | 3142.35 | 3140.45 | 3140.72 | 1709.0 |
| 2019-06-13 23:30:00 | ES | Futures | 3140.72 | 3141.53 | 3140.45 | 3140.99 | 850.0 |
| 2019-06-13 00:00:00 | NQ | Futures | 8685.77 | 8688.97 | 8676.45 | 8678.49 | 1545.0 |
| 2019-06-13 00:30:00 | NQ | Futures | 8678.78 | 8685.77 | 8677.91 | 8683.73 | 1007.0 |
| 2019-06-13 01:00:00 | NQ | Futures | 8683.44 | 8689.26 | 8671.79 | 8676.45 | 2862.0 |
| 2019-06-13 01:30:00 | NQ | Futures | 8676.45 | 8691.3 | 8675.29 | 8687.22 | 1746.0 |
> showing 50 of 3,195 rows — these rows as CSV