PREVIEW / futures_1hour / 2024-07-02
file: by_date/futures_1hour/2024/2024-07-02.parquet size: 67 KB rows: 2,075
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-02 00:00:00 | ES | Futures | 5790.42 | 5792.77 | 5789.89 | 5791.46 | 3140.0 |
| 2024-07-02 01:00:00 | ES | Futures | 5791.73 | 5796.44 | 5790.42 | 5795.4 | 4551.0 |
| 2024-07-02 02:00:00 | ES | Futures | 5795.4 | 5796.71 | 5788.58 | 5790.15 | 9020.0 |
| 2024-07-02 03:00:00 | ES | Futures | 5790.15 | 5790.15 | 5776.78 | 5782.81 | 27727.0 |
| 2024-07-02 04:00:00 | ES | Futures | 5782.81 | 5784.65 | 5776.0 | 5781.5 | 16007.0 |
| 2024-07-02 05:00:00 | ES | Futures | 5781.76 | 5784.12 | 5777.04 | 5779.93 | 13856.0 |
| 2024-07-02 06:00:00 | ES | Futures | 5780.19 | 5783.34 | 5778.62 | 5781.5 | 9715.0 |
| 2024-07-02 07:00:00 | ES | Futures | 5781.5 | 5782.03 | 5770.49 | 5776.52 | 23534.0 |
| 2024-07-02 08:00:00 | ES | Futures | 5776.52 | 5781.76 | 5774.95 | 5779.67 | 29433.0 |
| 2024-07-02 09:00:00 | ES | Futures | 5779.4 | 5805.1 | 5779.14 | 5799.59 | 199647.0 |
| 2024-07-02 10:00:00 | ES | Futures | 5799.59 | 5808.5 | 5792.51 | 5806.14 | 207427.0 |
| 2024-07-02 11:00:00 | ES | Futures | 5805.88 | 5814.01 | 5802.74 | 5805.1 | 127679.0 |
| 2024-07-02 12:00:00 | ES | Futures | 5804.83 | 5808.77 | 5799.33 | 5808.24 | 87689.0 |
| 2024-07-02 13:00:00 | ES | Futures | 5808.24 | 5824.23 | 5807.46 | 5821.87 | 117971.0 |
| 2024-07-02 14:00:00 | ES | Futures | 5822.14 | 5829.74 | 5821.61 | 5825.81 | 78230.0 |
| 2024-07-02 15:00:00 | ES | Futures | 5825.81 | 5840.75 | 5824.23 | 5840.49 | 201081.0 |
| 2024-07-02 16:00:00 | ES | Futures | 5840.49 | 5840.75 | 5831.31 | 5833.41 | 53194.0 |
| 2024-07-02 18:00:00 | ES | Futures | 5834.46 | 5836.56 | 5831.57 | 5835.77 | 4144.0 |
| 2024-07-02 19:00:00 | ES | Futures | 5835.77 | 5836.56 | 5831.57 | 5832.62 | 3293.0 |
| 2024-07-02 20:00:00 | ES | Futures | 5832.89 | 5837.34 | 5832.62 | 5835.77 | 4621.0 |
| 2024-07-02 21:00:00 | ES | Futures | 5835.51 | 5835.77 | 5832.1 | 5833.67 | 5014.0 |
| 2024-07-02 22:00:00 | ES | Futures | 5833.41 | 5835.25 | 5831.84 | 5834.2 | 3777.0 |
| 2024-07-02 23:00:00 | ES | Futures | 5834.2 | 5835.77 | 5830.26 | 5831.84 | 5541.0 |
| 2024-07-02 00:00:00 | NQ | Futures | 21099.59 | 21108.83 | 21095.63 | 21099.86 | 2100.0 |
| 2024-07-02 01:00:00 | NQ | Futures | 21100.12 | 21133.38 | 21093.52 | 21129.42 | 3228.0 |
| 2024-07-02 02:00:00 | NQ | Futures | 21129.69 | 21135.76 | 21099.59 | 21107.25 | 4882.0 |
| 2024-07-02 03:00:00 | NQ | Futures | 21107.51 | 21107.51 | 21050.76 | 21082.43 | 12423.0 |
| 2024-07-02 04:00:00 | NQ | Futures | 21082.7 | 21092.47 | 21048.64 | 21075.57 | 9103.0 |
| 2024-07-02 05:00:00 | NQ | Futures | 21075.31 | 21086.66 | 21055.24 | 21072.67 | 6159.0 |
| 2024-07-02 06:00:00 | NQ | Futures | 21072.93 | 21083.23 | 21060.26 | 21079.0 | 4774.0 |
| 2024-07-02 07:00:00 | NQ | Futures | 21080.06 | 21081.11 | 21023.57 | 21048.12 | 10817.0 |
| 2024-07-02 08:00:00 | NQ | Futures | 21047.59 | 21076.89 | 21041.78 | 21061.58 | 13261.0 |
| 2024-07-02 09:00:00 | NQ | Futures | 21061.84 | 21222.08 | 21058.68 | 21184.6 | 107122.0 |
| 2024-07-02 10:00:00 | NQ | Futures | 21185.39 | 21249.8 | 21137.34 | 21235.81 | 116519.0 |
| 2024-07-02 11:00:00 | NQ | Futures | 21236.07 | 21283.59 | 21208.09 | 21218.39 | 68698.0 |
| 2024-07-02 12:00:00 | NQ | Futures | 21218.65 | 21253.5 | 21187.5 | 21252.44 | 45701.0 |
| 2024-07-02 13:00:00 | NQ | Futures | 21252.97 | 21346.68 | 21245.31 | 21339.29 | 58808.0 |
| 2024-07-02 14:00:00 | NQ | Futures | 21339.55 | 21372.02 | 21334.01 | 21354.07 | 42878.0 |
| 2024-07-02 15:00:00 | NQ | Futures | 21353.54 | 21392.35 | 21338.23 | 21389.45 | 62497.0 |
| 2024-07-02 16:00:00 | NQ | Futures | 21389.45 | 21390.24 | 21360.41 | 21372.02 | 16667.0 |
| 2024-07-02 18:00:00 | NQ | Futures | 21373.08 | 21383.9 | 21363.05 | 21379.68 | 2621.0 |
| 2024-07-02 19:00:00 | NQ | Futures | 21379.68 | 21384.69 | 21364.63 | 21369.12 | 2035.0 |
| 2024-07-02 20:00:00 | NQ | Futures | 21369.65 | 21385.75 | 21368.33 | 21376.78 | 2545.0 |
| 2024-07-02 21:00:00 | NQ | Futures | 21376.25 | 21379.41 | 21363.84 | 21370.97 | 2641.0 |
| 2024-07-02 22:00:00 | NQ | Futures | 21370.97 | 21378.62 | 21363.58 | 21372.82 | 2342.0 |
| 2024-07-02 23:00:00 | NQ | Futures | 21371.76 | 21379.41 | 21363.05 | 21367.01 | 2541.0 |
| 2024-07-02 00:00:00 | YM | Futures | 41448.1 | 41464.9 | 41447.0 | 41461.7 | 577.0 |
| 2024-07-02 01:00:00 | YM | Futures | 41461.7 | 41480.6 | 41453.3 | 41473.3 | 835.0 |
| 2024-07-02 02:00:00 | YM | Futures | 41475.4 | 41481.7 | 41431.2 | 41443.9 | 1623.0 |
| 2024-07-02 03:00:00 | YM | Futures | 41444.9 | 41444.9 | 41339.8 | 41384.0 | 3256.0 |
> showing 50 of 2,075 rows — these rows as CSV