PREVIEW / futures_1hour / 2022-03-09
file: by_date/futures_1hour/2022/2022-03-09.parquet size: 70 KB rows: 2,061
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-09 00:00:00 | ES | Futures | 4741.74 | 4743.72 | 4717.7 | 4725.62 | 10604.0 |
| 2022-03-09 01:00:00 | ES | Futures | 4725.91 | 4745.42 | 4725.34 | 4738.63 | 9328.0 |
| 2022-03-09 02:00:00 | ES | Futures | 4738.35 | 4770.31 | 4729.3 | 4769.17 | 27957.0 |
| 2022-03-09 03:00:00 | ES | Futures | 4769.17 | 4774.55 | 4748.25 | 4772.0 | 35743.0 |
| 2022-03-09 04:00:00 | ES | Futures | 4772.29 | 4799.15 | 4768.33 | 4798.02 | 36470.0 |
| 2022-03-09 05:00:00 | ES | Futures | 4797.74 | 4803.39 | 4783.03 | 4788.12 | 30072.0 |
| 2022-03-09 06:00:00 | ES | Futures | 4788.41 | 4804.81 | 4780.77 | 4786.43 | 28689.0 |
| 2022-03-09 07:00:00 | ES | Futures | 4786.71 | 4801.98 | 4781.34 | 4800.0 | 29927.0 |
| 2022-03-09 08:00:00 | ES | Futures | 4800.0 | 4813.57 | 4793.21 | 4794.63 | 43473.0 |
| 2022-03-09 09:00:00 | ES | Futures | 4794.91 | 4824.6 | 4785.86 | 4801.13 | 235953.0 |
| 2022-03-09 10:00:00 | ES | Futures | 4801.13 | 4833.09 | 4799.15 | 4829.13 | 211971.0 |
| 2022-03-09 11:00:00 | ES | Futures | 4829.13 | 4839.59 | 4807.92 | 4837.9 | 140282.0 |
| 2022-03-09 12:00:00 | ES | Futures | 4837.9 | 4853.73 | 4831.11 | 4849.49 | 124059.0 |
| 2022-03-09 13:00:00 | ES | Futures | 4849.49 | 4849.77 | 4826.02 | 4830.83 | 102422.0 |
| 2022-03-09 14:00:00 | ES | Futures | 4830.83 | 4846.66 | 4829.13 | 4837.05 | 97040.0 |
| 2022-03-09 15:00:00 | ES | Futures | 4837.33 | 4862.22 | 4829.13 | 4838.46 | 236990.0 |
| 2022-03-09 16:00:00 | ES | Futures | 4838.18 | 4848.92 | 4831.67 | 4841.29 | 73141.0 |
| 2022-03-09 18:00:00 | ES | Futures | 4840.44 | 4844.12 | 4832.52 | 4837.33 | 8814.0 |
| 2022-03-09 19:00:00 | ES | Futures | 4837.61 | 4841.57 | 4830.83 | 4836.2 | 10006.0 |
| 2022-03-09 20:00:00 | ES | Futures | 4835.92 | 4840.72 | 4824.6 | 4832.52 | 15356.0 |
| 2022-03-09 21:00:00 | ES | Futures | 4832.24 | 4843.83 | 4831.67 | 4836.2 | 10465.0 |
| 2022-03-09 22:00:00 | ES | Futures | 4836.48 | 4838.74 | 4829.41 | 4835.35 | 9256.0 |
| 2022-03-09 23:00:00 | ES | Futures | 4835.63 | 4837.61 | 4824.6 | 4828.28 | 10424.0 |
| 2022-03-09 00:00:00 | NQ | Futures | 15450.73 | 15461.46 | 15364.95 | 15402.62 | 5376.0 |
| 2022-03-09 01:00:00 | NQ | Futures | 15401.75 | 15480.58 | 15399.43 | 15449.57 | 6223.0 |
| 2022-03-09 02:00:00 | NQ | Futures | 15450.73 | 15578.25 | 15417.11 | 15562.6 | 13076.0 |
| 2022-03-09 03:00:00 | NQ | Futures | 15561.44 | 15597.96 | 15483.77 | 15590.13 | 19608.0 |
| 2022-03-09 04:00:00 | NQ | Futures | 15590.71 | 15716.2 | 15581.73 | 15708.38 | 20121.0 |
| 2022-03-09 05:00:00 | NQ | Futures | 15708.09 | 15728.96 | 15655.92 | 15673.02 | 17053.0 |
| 2022-03-09 06:00:00 | NQ | Futures | 15673.02 | 15737.07 | 15646.36 | 15666.94 | 14295.0 |
| 2022-03-09 07:00:00 | NQ | Futures | 15666.94 | 15732.72 | 15637.08 | 15725.48 | 16391.0 |
| 2022-03-09 08:00:00 | NQ | Futures | 15725.19 | 15777.36 | 15706.64 | 15713.6 | 21055.0 |
| 2022-03-09 09:00:00 | NQ | Futures | 15713.89 | 15817.35 | 15645.49 | 15729.25 | 105800.0 |
| 2022-03-09 10:00:00 | NQ | Futures | 15729.54 | 15863.14 | 15710.99 | 15842.28 | 91660.0 |
| 2022-03-09 11:00:00 | NQ | Futures | 15841.7 | 15851.26 | 15743.45 | 15841.99 | 57750.0 |
| 2022-03-09 12:00:00 | NQ | Futures | 15841.99 | 15939.07 | 15804.6 | 15908.35 | 54123.0 |
| 2022-03-09 13:00:00 | NQ | Futures | 15909.22 | 15926.61 | 15834.45 | 15871.55 | 39669.0 |
| 2022-03-09 14:00:00 | NQ | Futures | 15871.84 | 15936.76 | 15862.27 | 15907.19 | 37731.0 |
| 2022-03-09 15:00:00 | NQ | Futures | 15908.64 | 15992.98 | 15884.3 | 15930.38 | 64510.0 |
| 2022-03-09 16:00:00 | NQ | Futures | 15928.93 | 16023.12 | 15900.82 | 15967.77 | 22899.0 |
| 2022-03-09 18:00:00 | NQ | Futures | 15972.4 | 15972.4 | 15914.44 | 15936.18 | 6711.0 |
| 2022-03-09 19:00:00 | NQ | Futures | 15936.18 | 15949.22 | 15917.92 | 15933.86 | 4194.0 |
| 2022-03-09 20:00:00 | NQ | Futures | 15930.96 | 15945.74 | 15884.59 | 15911.83 | 5817.0 |
| 2022-03-09 21:00:00 | NQ | Futures | 15910.96 | 15956.17 | 15910.09 | 15917.34 | 4733.0 |
| 2022-03-09 22:00:00 | NQ | Futures | 15917.63 | 15928.35 | 15887.49 | 15918.21 | 4149.0 |
| 2022-03-09 23:00:00 | NQ | Futures | 15918.21 | 15923.71 | 15845.75 | 15863.14 | 4803.0 |
| 2022-03-09 00:00:00 | YM | Futures | 36850.5 | 36853.9 | 36676.3 | 36732.5 | 1894.0 |
| 2022-03-09 01:00:00 | YM | Futures | 36732.5 | 36862.9 | 36723.5 | 36821.3 | 2416.0 |
| 2022-03-09 02:00:00 | YM | Futures | 36832.6 | 37046.1 | 36751.6 | 37038.2 | 9354.0 |
| 2022-03-09 03:00:00 | YM | Futures | 37036.0 | 37075.3 | 36894.4 | 37036.0 | 12965.0 |
> showing 50 of 2,061 rows — these rows as CSV