PREVIEW / futures_1hour / 2025-05-09
file: by_date/futures_1hour/2025/2025-05-09.parquet size: 55 KB rows: 1,656
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-09 00:00:00 | ES | Futures | 5782.71 | 5785.25 | 5779.67 | 5783.22 | 2179.0 |
| 2025-05-09 01:00:00 | ES | Futures | 5783.22 | 5785.51 | 5775.35 | 5783.98 | 4940.0 |
| 2025-05-09 02:00:00 | ES | Futures | 5783.73 | 5785.51 | 5777.63 | 5782.21 | 6622.0 |
| 2025-05-09 03:00:00 | ES | Futures | 5781.95 | 5790.33 | 5775.6 | 5780.94 | 11203.0 |
| 2025-05-09 04:00:00 | ES | Futures | 5781.19 | 5782.97 | 5774.33 | 5777.63 | 9087.0 |
| 2025-05-09 05:00:00 | ES | Futures | 5777.63 | 5785.0 | 5777.12 | 5784.75 | 5634.0 |
| 2025-05-09 06:00:00 | ES | Futures | 5784.75 | 5795.42 | 5784.24 | 5792.11 | 7798.0 |
| 2025-05-09 07:00:00 | ES | Futures | 5792.37 | 5807.61 | 5767.73 | 5788.81 | 43937.0 |
| 2025-05-09 08:00:00 | ES | Futures | 5788.56 | 5803.04 | 5786.52 | 5795.67 | 20053.0 |
| 2025-05-09 09:00:00 | ES | Futures | 5795.67 | 5802.78 | 5785.0 | 5797.19 | 90732.0 |
| 2025-05-09 10:00:00 | ES | Futures | 5796.94 | 5801.0 | 5754.01 | 5772.3 | 186034.0 |
| 2025-05-09 11:00:00 | ES | Futures | 5772.3 | 5782.97 | 5765.18 | 5782.71 | 117376.0 |
| 2025-05-09 12:00:00 | ES | Futures | 5782.71 | 5783.48 | 5757.06 | 5760.1 | 94619.0 |
| 2025-05-09 13:00:00 | ES | Futures | 5760.36 | 5780.43 | 5754.52 | 5778.9 | 82685.0 |
| 2025-05-09 14:00:00 | ES | Futures | 5778.9 | 5779.67 | 5767.22 | 5775.35 | 59342.0 |
| 2025-05-09 15:00:00 | ES | Futures | 5775.09 | 5786.02 | 5767.73 | 5769.5 | 161912.0 |
| 2025-05-09 16:00:00 | ES | Futures | 5769.76 | 5776.36 | 5765.95 | 5775.85 | 40968.0 |
| 2025-05-09 00:00:00 | NQ | Futures | 20561.18 | 20569.83 | 20545.64 | 20559.14 | 2594.0 |
| 2025-05-09 01:00:00 | NQ | Futures | 20558.12 | 20579.0 | 20531.38 | 20568.31 | 4319.0 |
| 2025-05-09 02:00:00 | NQ | Futures | 20568.81 | 20581.8 | 20548.19 | 20567.03 | 3998.0 |
| 2025-05-09 03:00:00 | NQ | Futures | 20567.03 | 20608.8 | 20543.09 | 20568.81 | 8309.0 |
| 2025-05-09 04:00:00 | NQ | Futures | 20567.54 | 20577.98 | 20540.29 | 20549.46 | 6003.0 |
| 2025-05-09 05:00:00 | NQ | Futures | 20549.46 | 20575.69 | 20547.42 | 20573.91 | 3527.0 |
| 2025-05-09 06:00:00 | NQ | Futures | 20574.67 | 20614.65 | 20571.87 | 20607.01 | 5402.0 |
| 2025-05-09 07:00:00 | NQ | Futures | 20607.27 | 20666.35 | 20514.83 | 20582.57 | 19567.0 |
| 2025-05-09 08:00:00 | NQ | Futures | 20581.55 | 20632.99 | 20570.85 | 20608.8 | 12958.0 |
| 2025-05-09 09:00:00 | NQ | Futures | 20609.3 | 20657.18 | 20580.78 | 20631.2 | 49522.0 |
| 2025-05-09 10:00:00 | NQ | Futures | 20630.95 | 20652.34 | 20431.3 | 20516.87 | 81174.0 |
| 2025-05-09 11:00:00 | NQ | Futures | 20517.63 | 20551.75 | 20477.14 | 20545.13 | 52096.0 |
| 2025-05-09 12:00:00 | NQ | Futures | 20545.64 | 20550.23 | 20445.56 | 20461.61 | 41876.0 |
| 2025-05-09 13:00:00 | NQ | Futures | 20462.12 | 20536.22 | 20434.87 | 20531.13 | 37352.0 |
| 2025-05-09 14:00:00 | NQ | Futures | 20530.36 | 20535.46 | 20484.27 | 20516.36 | 27312.0 |
| 2025-05-09 15:00:00 | NQ | Futures | 20516.1 | 20561.18 | 20502.35 | 20511.01 | 47477.0 |
| 2025-05-09 16:00:00 | NQ | Futures | 20510.75 | 20524.25 | 20494.97 | 20521.45 | 13059.0 |
| 2025-05-09 00:00:00 | YM | Futures | 42692.9 | 42710.4 | 42672.4 | 42700.2 | 352.0 |
| 2025-05-09 01:00:00 | YM | Futures | 42697.1 | 42702.2 | 42654.9 | 42695.0 | 631.0 |
| 2025-05-09 02:00:00 | YM | Futures | 42696.0 | 42704.3 | 42649.7 | 42665.2 | 928.0 |
| 2025-05-09 03:00:00 | YM | Futures | 42666.2 | 42709.4 | 42620.9 | 42646.6 | 1720.0 |
| 2025-05-09 04:00:00 | YM | Futures | 42644.6 | 42646.6 | 42584.9 | 42619.9 | 2043.0 |
| 2025-05-09 05:00:00 | YM | Futures | 42621.9 | 42667.2 | 42615.8 | 42664.1 | 683.0 |
| 2025-05-09 06:00:00 | YM | Futures | 42666.2 | 42745.4 | 42663.1 | 42717.6 | 1237.0 |
| 2025-05-09 07:00:00 | YM | Futures | 42717.6 | 42837.0 | 42564.3 | 42730.0 | 4676.0 |
| 2025-05-09 08:00:00 | YM | Futures | 42724.9 | 42833.9 | 42706.3 | 42776.3 | 2273.0 |
| 2025-05-09 09:00:00 | YM | Futures | 42780.4 | 42825.7 | 42670.3 | 42754.7 | 10617.0 |
| 2025-05-09 10:00:00 | YM | Futures | 42751.6 | 42786.6 | 42503.6 | 42576.7 | 9699.0 |
| 2025-05-09 11:00:00 | YM | Futures | 42576.7 | 42640.5 | 42519.0 | 42635.3 | 6206.0 |
| 2025-05-09 12:00:00 | YM | Futures | 42634.3 | 42637.4 | 42427.4 | 42449.0 | 5317.0 |
| 2025-05-09 13:00:00 | YM | Futures | 42450.1 | 42605.5 | 42429.5 | 42600.3 | 4241.0 |
| 2025-05-09 14:00:00 | YM | Futures | 42596.2 | 42602.4 | 42519.0 | 42577.7 | 2777.0 |
| 2025-05-09 15:00:00 | YM | Futures | 42575.6 | 42645.6 | 42507.7 | 42524.2 | 7064.0 |
> showing 50 of 1,656 rows — these rows as CSV