PREVIEW / futures_1hour / 2021-10-04
file: by_date/futures_1hour/2021/2021-10-04.parquet size: 65 KB rows: 1,986
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-04 00:00:00 | ES | Futures | 4888.2 | 4903.16 | 4886.23 | 4901.46 | 11220.0 |
| 2021-10-04 01:00:00 | ES | Futures | 4901.46 | 4910.21 | 4891.02 | 4895.26 | 15914.0 |
| 2021-10-04 02:00:00 | ES | Futures | 4894.97 | 4895.82 | 4877.19 | 4886.23 | 24747.0 |
| 2021-10-04 03:00:00 | ES | Futures | 4885.94 | 4889.61 | 4870.99 | 4882.84 | 39277.0 |
| 2021-10-04 04:00:00 | ES | Futures | 4882.84 | 4892.72 | 4875.78 | 4888.48 | 24212.0 |
| 2021-10-04 05:00:00 | ES | Futures | 4888.77 | 4894.97 | 4885.94 | 4888.2 | 24799.0 |
| 2021-10-04 06:00:00 | ES | Futures | 4888.2 | 4894.41 | 4881.99 | 4890.74 | 15126.0 |
| 2021-10-04 07:00:00 | ES | Futures | 4890.74 | 4891.87 | 4879.45 | 4884.81 | 23396.0 |
| 2021-10-04 08:00:00 | ES | Futures | 4884.81 | 4900.9 | 4884.25 | 4897.23 | 33303.0 |
| 2021-10-04 09:00:00 | ES | Futures | 4897.51 | 4904.29 | 4883.69 | 4889.89 | 201070.0 |
| 2021-10-04 10:00:00 | ES | Futures | 4889.61 | 4895.54 | 4825.83 | 4836.56 | 406644.0 |
| 2021-10-04 11:00:00 | ES | Futures | 4836.56 | 4845.87 | 4817.37 | 4840.79 | 275185.0 |
| 2021-10-04 12:00:00 | ES | Futures | 4840.51 | 4843.05 | 4821.03 | 4827.53 | 154902.0 |
| 2021-10-04 13:00:00 | ES | Futures | 4827.53 | 4839.1 | 4819.06 | 4828.65 | 127417.0 |
| 2021-10-04 14:00:00 | ES | Futures | 4828.65 | 4842.76 | 4827.24 | 4838.81 | 178287.0 |
| 2021-10-04 15:00:00 | ES | Futures | 4839.1 | 4850.1 | 4828.37 | 4845.02 | 336418.0 |
| 2021-10-04 16:00:00 | ES | Futures | 4845.02 | 4849.82 | 4841.92 | 4847.28 | 68188.0 |
| 2021-10-04 18:00:00 | ES | Futures | 4849.26 | 4854.05 | 4846.72 | 4852.64 | 8276.0 |
| 2021-10-04 19:00:00 | ES | Futures | 4852.92 | 4854.05 | 4843.05 | 4846.72 | 9799.0 |
| 2021-10-04 20:00:00 | ES | Futures | 4846.72 | 4849.26 | 4826.4 | 4828.09 | 19520.0 |
| 2021-10-04 21:00:00 | ES | Futures | 4828.09 | 4838.81 | 4819.06 | 4834.86 | 24079.0 |
| 2021-10-04 22:00:00 | ES | Futures | 4834.58 | 4849.26 | 4831.48 | 4847.28 | 18720.0 |
| 2021-10-04 23:00:00 | ES | Futures | 4847.56 | 4852.08 | 4840.22 | 4851.51 | 11241.0 |
| 2021-10-04 00:00:00 | NQ | Futures | 17042.7 | 17089.94 | 17031.68 | 17079.21 | 5875.0 |
| 2021-10-04 01:00:00 | NQ | Futures | 17078.64 | 17100.95 | 17032.26 | 17047.04 | 7190.0 |
| 2021-10-04 02:00:00 | NQ | Futures | 17045.89 | 17048.2 | 16985.6 | 17020.67 | 10448.0 |
| 2021-10-04 03:00:00 | NQ | Futures | 17016.32 | 17039.22 | 16964.16 | 17007.63 | 13858.0 |
| 2021-10-04 04:00:00 | NQ | Futures | 17008.21 | 17058.64 | 16994.3 | 17034.0 | 11030.0 |
| 2021-10-04 05:00:00 | NQ | Futures | 17035.16 | 17062.12 | 17026.18 | 17038.64 | 8319.0 |
| 2021-10-04 06:00:00 | NQ | Futures | 17038.35 | 17063.27 | 17014.88 | 17045.31 | 6902.0 |
| 2021-10-04 07:00:00 | NQ | Futures | 17045.02 | 17050.81 | 16999.51 | 17026.18 | 8716.0 |
| 2021-10-04 08:00:00 | NQ | Futures | 17026.76 | 17082.4 | 17020.09 | 17067.91 | 10839.0 |
| 2021-10-04 09:00:00 | NQ | Futures | 17067.33 | 17069.07 | 16887.65 | 16917.79 | 95015.0 |
| 2021-10-04 10:00:00 | NQ | Futures | 16917.79 | 16936.33 | 16695.79 | 16740.71 | 156612.0 |
| 2021-10-04 11:00:00 | NQ | Futures | 16740.71 | 16783.02 | 16673.76 | 16745.64 | 107142.0 |
| 2021-10-04 12:00:00 | NQ | Futures | 16745.06 | 16750.56 | 16662.17 | 16689.7 | 68099.0 |
| 2021-10-04 13:00:00 | NQ | Futures | 16689.12 | 16735.49 | 16656.08 | 16693.18 | 61440.0 |
| 2021-10-04 14:00:00 | NQ | Futures | 16693.47 | 16769.98 | 16691.73 | 16750.85 | 62935.0 |
| 2021-10-04 15:00:00 | NQ | Futures | 16752.01 | 16804.18 | 16687.67 | 16771.43 | 97927.0 |
| 2021-10-04 16:00:00 | NQ | Futures | 16771.72 | 16802.44 | 16770.56 | 16796.64 | 19133.0 |
| 2021-10-04 18:00:00 | NQ | Futures | 16802.15 | 16820.99 | 16785.05 | 16814.9 | 4839.0 |
| 2021-10-04 19:00:00 | NQ | Futures | 16815.48 | 16820.12 | 16775.78 | 16793.45 | 5074.0 |
| 2021-10-04 20:00:00 | NQ | Futures | 16794.03 | 16802.73 | 16722.74 | 16729.41 | 9429.0 |
| 2021-10-04 21:00:00 | NQ | Futures | 16728.54 | 16783.31 | 16705.64 | 16763.02 | 10169.0 |
| 2021-10-04 22:00:00 | NQ | Futures | 16763.02 | 16825.62 | 16752.59 | 16812.58 | 9324.0 |
| 2021-10-04 23:00:00 | NQ | Futures | 16813.74 | 16832.0 | 16785.05 | 16826.78 | 7246.0 |
| 2021-10-04 00:00:00 | YM | Futures | 38181.5 | 38313.7 | 38170.3 | 38307.0 | 2287.0 |
| 2021-10-04 01:00:00 | YM | Futures | 38305.9 | 38369.8 | 38221.8 | 38254.3 | 3914.0 |
| 2021-10-04 02:00:00 | YM | Futures | 38252.1 | 38271.1 | 38106.4 | 38182.6 | 5376.0 |
| 2021-10-04 03:00:00 | YM | Futures | 38181.5 | 38217.3 | 38075.0 | 38173.6 | 9262.0 |
> showing 50 of 1,986 rows — these rows as CSV