PREVIEW / futures_1hour / 2022-11-02
file: by_date/futures_1hour/2022/2022-11-02.parquet size: 69 KB rows: 2,091
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-11-02 00:00:00 | ES | Futures | 4369.63 | 4371.61 | 4365.4 | 4370.76 | 6659.0 |
| 2022-11-02 01:00:00 | ES | Futures | 4371.04 | 4373.86 | 4369.07 | 4371.89 | 6849.0 |
| 2022-11-02 02:00:00 | ES | Futures | 4371.89 | 4372.17 | 4363.43 | 4365.97 | 6914.0 |
| 2022-11-02 03:00:00 | ES | Futures | 4366.25 | 4367.94 | 4359.77 | 4363.43 | 9683.0 |
| 2022-11-02 04:00:00 | ES | Futures | 4363.71 | 4376.68 | 4362.59 | 4371.61 | 19821.0 |
| 2022-11-02 05:00:00 | ES | Futures | 4371.32 | 4373.86 | 4358.36 | 4363.43 | 15793.0 |
| 2022-11-02 06:00:00 | ES | Futures | 4363.43 | 4364.28 | 4354.13 | 4358.64 | 12848.0 |
| 2022-11-02 07:00:00 | ES | Futures | 4358.64 | 4365.12 | 4355.54 | 4364.28 | 18553.0 |
| 2022-11-02 08:00:00 | ES | Futures | 4364.56 | 4365.69 | 4346.24 | 4354.13 | 57526.0 |
| 2022-11-02 09:00:00 | ES | Futures | 4354.13 | 4356.1 | 4333.55 | 4334.11 | 162487.0 |
| 2022-11-02 10:00:00 | ES | Futures | 4334.11 | 4341.73 | 4330.17 | 4337.5 | 179447.0 |
| 2022-11-02 11:00:00 | ES | Futures | 4337.5 | 4341.73 | 4331.86 | 4336.93 | 120802.0 |
| 2022-11-02 12:00:00 | ES | Futures | 4336.93 | 4339.19 | 4321.99 | 4334.4 | 104843.0 |
| 2022-11-02 13:00:00 | ES | Futures | 4334.4 | 4350.75 | 4328.76 | 4344.26 | 106719.0 |
| 2022-11-02 14:00:00 | ES | Futures | 4344.26 | 4405.43 | 4294.37 | 4312.13 | 657517.0 |
| 2022-11-02 15:00:00 | ES | Futures | 4312.13 | 4342.57 | 4247.29 | 4247.57 | 503457.0 |
| 2022-11-02 16:00:00 | ES | Futures | 4247.57 | 4253.77 | 4239.96 | 4248.98 | 91677.0 |
| 2022-11-02 18:00:00 | ES | Futures | 4247.29 | 4250.96 | 4235.73 | 4241.09 | 15322.0 |
| 2022-11-02 19:00:00 | ES | Futures | 4240.81 | 4241.65 | 4235.17 | 4238.83 | 10887.0 |
| 2022-11-02 20:00:00 | ES | Futures | 4238.83 | 4245.88 | 4236.3 | 4245.88 | 11963.0 |
| 2022-11-02 21:00:00 | ES | Futures | 4245.6 | 4259.98 | 4244.47 | 4254.62 | 19347.0 |
| 2022-11-02 22:00:00 | ES | Futures | 4254.62 | 4259.69 | 4252.93 | 4254.62 | 9168.0 |
| 2022-11-02 23:00:00 | ES | Futures | 4254.9 | 4262.23 | 4254.9 | 4258.85 | 8075.0 |
| 2022-11-02 00:00:00 | NQ | Futures | 13070.45 | 13077.06 | 13058.96 | 13067.87 | 2348.0 |
| 2022-11-02 01:00:00 | NQ | Futures | 13068.73 | 13082.24 | 13063.85 | 13073.9 | 3676.0 |
| 2022-11-02 02:00:00 | NQ | Futures | 13075.05 | 13075.63 | 13045.74 | 13055.8 | 3670.0 |
| 2022-11-02 03:00:00 | NQ | Futures | 13055.8 | 13063.27 | 13027.93 | 13046.61 | 6525.0 |
| 2022-11-02 04:00:00 | NQ | Futures | 13045.74 | 13090.57 | 13043.16 | 13070.17 | 9717.0 |
| 2022-11-02 05:00:00 | NQ | Futures | 13069.59 | 13079.65 | 13028.51 | 13050.63 | 7750.0 |
| 2022-11-02 06:00:00 | NQ | Futures | 13049.48 | 13057.52 | 13021.9 | 13041.72 | 6335.0 |
| 2022-11-02 07:00:00 | NQ | Futures | 13041.43 | 13055.51 | 13027.93 | 13049.77 | 6920.0 |
| 2022-11-02 08:00:00 | NQ | Futures | 13049.48 | 13056.09 | 12981.96 | 13024.2 | 25766.0 |
| 2022-11-02 09:00:00 | NQ | Futures | 13024.77 | 13034.25 | 12954.09 | 12963.86 | 66956.0 |
| 2022-11-02 10:00:00 | NQ | Futures | 12964.72 | 12998.05 | 12934.26 | 12951.79 | 65655.0 |
| 2022-11-02 11:00:00 | NQ | Futures | 12952.08 | 12961.27 | 12900.36 | 12912.14 | 51271.0 |
| 2022-11-02 12:00:00 | NQ | Futures | 12912.71 | 12923.92 | 12861.86 | 12912.71 | 40658.0 |
| 2022-11-02 13:00:00 | NQ | Futures | 12913.0 | 12956.67 | 12883.41 | 12930.24 | 33167.0 |
| 2022-11-02 14:00:00 | NQ | Futures | 12931.39 | 13171.02 | 12777.96 | 12826.23 | 232916.0 |
| 2022-11-02 15:00:00 | NQ | Futures | 12826.51 | 12922.48 | 12569.65 | 12571.66 | 145272.0 |
| 2022-11-02 16:00:00 | NQ | Futures | 12571.94 | 12592.34 | 12537.75 | 12575.39 | 32940.0 |
| 2022-11-02 18:00:00 | NQ | Futures | 12571.08 | 12580.28 | 12528.85 | 12554.7 | 6986.0 |
| 2022-11-02 19:00:00 | NQ | Futures | 12553.84 | 12555.85 | 12533.73 | 12550.11 | 4105.0 |
| 2022-11-02 20:00:00 | NQ | Futures | 12549.53 | 12578.27 | 12538.9 | 12577.98 | 5258.0 |
| 2022-11-02 21:00:00 | NQ | Futures | 12577.69 | 12625.67 | 12571.94 | 12602.4 | 7448.0 |
| 2022-11-02 22:00:00 | NQ | Futures | 12602.69 | 12621.65 | 12594.07 | 12600.96 | 4113.0 |
| 2022-11-02 23:00:00 | NQ | Futures | 12600.96 | 12627.4 | 12600.96 | 12618.2 | 3794.0 |
| 2022-11-02 00:00:00 | YM | Futures | 36733.0 | 36763.3 | 36686.9 | 36755.4 | 2329.0 |
| 2022-11-02 01:00:00 | YM | Futures | 36757.6 | 36771.1 | 36734.1 | 36741.9 | 1155.0 |
| 2022-11-02 02:00:00 | YM | Futures | 36744.2 | 36746.4 | 36695.9 | 36713.9 | 1221.0 |
| 2022-11-02 03:00:00 | YM | Futures | 36713.9 | 36721.7 | 36670.1 | 36694.8 | 1564.0 |
> showing 50 of 2,091 rows — these rows as CSV