PREVIEW / futures_1hour / 2023-08-21
file: by_date/futures_1hour/2023/2023-08-21.parquet size: 65 KB rows: 2,008
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-21 00:00:00 | ES | Futures | 4814.38 | 4815.48 | 4811.64 | 4812.46 | 3003.0 |
| 2023-08-21 01:00:00 | ES | Futures | 4812.46 | 4814.93 | 4806.97 | 4808.07 | 8044.0 |
| 2023-08-21 02:00:00 | ES | Futures | 4808.34 | 4811.36 | 4804.77 | 4808.07 | 6434.0 |
| 2023-08-21 03:00:00 | ES | Futures | 4808.07 | 4829.75 | 4807.79 | 4828.11 | 21508.0 |
| 2023-08-21 04:00:00 | ES | Futures | 4827.83 | 4830.85 | 4824.81 | 4830.58 | 14948.0 |
| 2023-08-21 05:00:00 | ES | Futures | 4830.58 | 4837.17 | 4830.58 | 4836.34 | 13009.0 |
| 2023-08-21 06:00:00 | ES | Futures | 4836.07 | 4838.54 | 4831.13 | 4832.77 | 11116.0 |
| 2023-08-21 07:00:00 | ES | Futures | 4832.77 | 4839.09 | 4831.68 | 4837.44 | 15422.0 |
| 2023-08-21 08:00:00 | ES | Futures | 4837.71 | 4839.64 | 4825.09 | 4825.64 | 28537.0 |
| 2023-08-21 09:00:00 | ES | Futures | 4825.64 | 4838.81 | 4820.97 | 4838.81 | 165333.0 |
| 2023-08-21 10:00:00 | ES | Futures | 4838.81 | 4840.73 | 4813.01 | 4816.58 | 226416.0 |
| 2023-08-21 11:00:00 | ES | Futures | 4816.58 | 4820.15 | 4800.93 | 4804.5 | 159348.0 |
| 2023-08-21 12:00:00 | ES | Futures | 4804.22 | 4824.26 | 4803.13 | 4823.17 | 116298.0 |
| 2023-08-21 13:00:00 | ES | Futures | 4823.17 | 4835.79 | 4819.05 | 4831.4 | 112575.0 |
| 2023-08-21 14:00:00 | ES | Futures | 4831.4 | 4844.58 | 4829.48 | 4841.83 | 112696.0 |
| 2023-08-21 15:00:00 | ES | Futures | 4841.83 | 4854.46 | 4841.83 | 4845.4 | 212406.0 |
| 2023-08-21 16:00:00 | ES | Futures | 4845.4 | 4845.68 | 4840.19 | 4841.83 | 45966.0 |
| 2023-08-21 18:00:00 | ES | Futures | 4842.66 | 4842.66 | 4837.71 | 4838.54 | 4886.0 |
| 2023-08-21 19:00:00 | ES | Futures | 4838.54 | 4842.38 | 4836.89 | 4837.71 | 4051.0 |
| 2023-08-21 20:00:00 | ES | Futures | 4837.71 | 4840.73 | 4833.87 | 4840.19 | 8641.0 |
| 2023-08-21 21:00:00 | ES | Futures | 4839.91 | 4842.66 | 4834.97 | 4839.09 | 9977.0 |
| 2023-08-21 22:00:00 | ES | Futures | 4839.09 | 4843.48 | 4838.54 | 4841.01 | 6184.0 |
| 2023-08-21 23:00:00 | ES | Futures | 4841.28 | 4844.3 | 4840.46 | 4842.66 | 5178.0 |
| 2023-08-21 00:00:00 | NQ | Futures | 16424.76 | 16430.32 | 16409.74 | 16413.35 | 2107.0 |
| 2023-08-21 01:00:00 | NQ | Futures | 16413.07 | 16424.2 | 16384.43 | 16388.04 | 4946.0 |
| 2023-08-21 02:00:00 | NQ | Futures | 16387.76 | 16405.84 | 16376.92 | 16396.67 | 4519.0 |
| 2023-08-21 03:00:00 | NQ | Futures | 16396.94 | 16485.11 | 16395.55 | 16481.5 | 13300.0 |
| 2023-08-21 04:00:00 | NQ | Futures | 16480.94 | 16504.02 | 16475.1 | 16500.96 | 10375.0 |
| 2023-08-21 05:00:00 | NQ | Futures | 16500.13 | 16514.87 | 16495.4 | 16508.75 | 7367.0 |
| 2023-08-21 06:00:00 | NQ | Futures | 16508.47 | 16518.49 | 16488.17 | 16495.68 | 6537.0 |
| 2023-08-21 07:00:00 | NQ | Futures | 16495.12 | 16524.88 | 16490.4 | 16522.38 | 8959.0 |
| 2023-08-21 08:00:00 | NQ | Futures | 16522.38 | 16530.45 | 16480.66 | 16481.77 | 14884.0 |
| 2023-08-21 09:00:00 | NQ | Futures | 16482.05 | 16591.64 | 16459.8 | 16591.64 | 92577.0 |
| 2023-08-21 10:00:00 | NQ | Futures | 16591.36 | 16612.77 | 16487.89 | 16499.3 | 107464.0 |
| 2023-08-21 11:00:00 | NQ | Futures | 16499.02 | 16527.94 | 16452.85 | 16476.49 | 68149.0 |
| 2023-08-21 12:00:00 | NQ | Futures | 16476.21 | 16581.9 | 16472.87 | 16578.01 | 56510.0 |
| 2023-08-21 13:00:00 | NQ | Futures | 16578.28 | 16647.54 | 16560.21 | 16626.4 | 66559.0 |
| 2023-08-21 14:00:00 | NQ | Futures | 16626.4 | 16681.19 | 16620.28 | 16665.9 | 48093.0 |
| 2023-08-21 15:00:00 | NQ | Futures | 16666.17 | 16703.17 | 16661.17 | 16673.41 | 73652.0 |
| 2023-08-21 16:00:00 | NQ | Futures | 16673.13 | 16673.41 | 16646.98 | 16656.72 | 17449.0 |
| 2023-08-21 18:00:00 | NQ | Futures | 16659.5 | 16662.28 | 16638.08 | 16642.81 | 3386.0 |
| 2023-08-21 19:00:00 | NQ | Futures | 16642.81 | 16659.22 | 16633.08 | 16637.25 | 2951.0 |
| 2023-08-21 20:00:00 | NQ | Futures | 16636.97 | 16650.32 | 16624.45 | 16646.71 | 4661.0 |
| 2023-08-21 21:00:00 | NQ | Futures | 16646.98 | 16662.28 | 16629.18 | 16650.32 | 5731.0 |
| 2023-08-21 22:00:00 | NQ | Futures | 16650.04 | 16668.68 | 16645.87 | 16659.78 | 3800.0 |
| 2023-08-21 23:00:00 | NQ | Futures | 16659.22 | 16669.79 | 16655.61 | 16658.66 | 2377.0 |
| 2023-08-21 00:00:00 | YM | Futures | 37877.4 | 37882.9 | 37860.9 | 37865.3 | 391.0 |
| 2023-08-21 01:00:00 | YM | Futures | 37866.4 | 37878.5 | 37834.7 | 37846.7 | 1083.0 |
| 2023-08-21 02:00:00 | YM | Futures | 37846.7 | 37867.5 | 37822.6 | 37837.9 | 1423.0 |
| 2023-08-21 03:00:00 | YM | Futures | 37836.8 | 37962.8 | 37836.8 | 37961.7 | 3416.0 |
> showing 50 of 2,008 rows — these rows as CSV