PREVIEW / futures_1hour / 2022-01-12
file: by_date/futures_1hour/2022/2022-01-12.parquet size: 66 KB rows: 2,031
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-01-12 00:00:00 | ES | Futures | 5326.29 | 5334.5 | 5326.01 | 5334.5 | 8995.0 |
| 2022-01-12 01:00:00 | ES | Futures | 5334.21 | 5337.89 | 5329.97 | 5329.97 | 7439.0 |
| 2022-01-12 02:00:00 | ES | Futures | 5330.25 | 5334.21 | 5326.86 | 5329.41 | 9184.0 |
| 2022-01-12 03:00:00 | ES | Futures | 5329.12 | 5331.1 | 5311.02 | 5313.0 | 25957.0 |
| 2022-01-12 04:00:00 | ES | Futures | 5313.29 | 5329.12 | 5312.44 | 5328.56 | 14588.0 |
| 2022-01-12 05:00:00 | ES | Futures | 5328.56 | 5331.1 | 5323.47 | 5329.97 | 13459.0 |
| 2022-01-12 06:00:00 | ES | Futures | 5330.25 | 5333.08 | 5325.73 | 5326.01 | 12141.0 |
| 2022-01-12 07:00:00 | ES | Futures | 5326.01 | 5331.95 | 5322.9 | 5327.14 | 15905.0 |
| 2022-01-12 08:00:00 | ES | Futures | 5327.43 | 5351.18 | 5326.29 | 5348.92 | 88644.0 |
| 2022-01-12 09:00:00 | ES | Futures | 5349.2 | 5355.71 | 5335.06 | 5354.86 | 221659.0 |
| 2022-01-12 10:00:00 | ES | Futures | 5354.86 | 5361.36 | 5326.58 | 5333.65 | 270891.0 |
| 2022-01-12 11:00:00 | ES | Futures | 5333.36 | 5342.41 | 5313.0 | 5336.19 | 215792.0 |
| 2022-01-12 12:00:00 | ES | Futures | 5336.48 | 5346.37 | 5327.99 | 5344.39 | 110921.0 |
| 2022-01-12 13:00:00 | ES | Futures | 5344.68 | 5345.24 | 5326.86 | 5329.12 | 100840.0 |
| 2022-01-12 14:00:00 | ES | Futures | 5329.12 | 5338.46 | 5322.62 | 5335.34 | 110171.0 |
| 2022-01-12 15:00:00 | ES | Futures | 5335.34 | 5344.11 | 5326.29 | 5337.61 | 220746.0 |
| 2022-01-12 16:00:00 | ES | Futures | 5337.61 | 5343.26 | 5336.48 | 5337.89 | 44594.0 |
| 2022-01-12 18:00:00 | ES | Futures | 5338.46 | 5340.15 | 5334.21 | 5336.48 | 6746.0 |
| 2022-01-12 19:00:00 | ES | Futures | 5336.76 | 5337.04 | 5331.39 | 5333.65 | 7425.0 |
| 2022-01-12 20:00:00 | ES | Futures | 5333.36 | 5337.89 | 5319.51 | 5321.49 | 11160.0 |
| 2022-01-12 21:00:00 | ES | Futures | 5321.49 | 5329.69 | 5321.49 | 5326.58 | 7303.0 |
| 2022-01-12 22:00:00 | ES | Futures | 5326.58 | 5326.86 | 5320.36 | 5324.88 | 5826.0 |
| 2022-01-12 23:00:00 | ES | Futures | 5325.16 | 5328.27 | 5324.88 | 5327.43 | 3626.0 |
| 2022-01-12 00:00:00 | NQ | Futures | 18354.99 | 18419.04 | 18353.54 | 18417.3 | 5909.0 |
| 2022-01-12 01:00:00 | NQ | Futures | 18417.88 | 18430.05 | 18390.93 | 18393.83 | 5739.0 |
| 2022-01-12 02:00:00 | NQ | Futures | 18393.25 | 18409.19 | 18364.55 | 18401.07 | 7625.0 |
| 2022-01-12 03:00:00 | NQ | Futures | 18400.78 | 18406.0 | 18272.97 | 18288.33 | 19517.0 |
| 2022-01-12 04:00:00 | NQ | Futures | 18288.62 | 18390.06 | 18284.56 | 18383.39 | 11826.0 |
| 2022-01-12 05:00:00 | NQ | Futures | 18383.97 | 18413.53 | 18366.29 | 18402.23 | 9267.0 |
| 2022-01-12 06:00:00 | NQ | Futures | 18402.81 | 18416.14 | 18376.44 | 18377.02 | 7491.0 |
| 2022-01-12 07:00:00 | NQ | Futures | 18377.89 | 18406.29 | 18356.15 | 18386.58 | 11041.0 |
| 2022-01-12 08:00:00 | NQ | Futures | 18387.16 | 18519.32 | 18376.73 | 18513.81 | 41182.0 |
| 2022-01-12 09:00:00 | NQ | Futures | 18514.1 | 18539.02 | 18414.4 | 18510.33 | 97158.0 |
| 2022-01-12 10:00:00 | NQ | Futures | 18510.04 | 18559.02 | 18358.18 | 18383.97 | 121449.0 |
| 2022-01-12 11:00:00 | NQ | Futures | 18383.68 | 18459.61 | 18313.26 | 18432.37 | 90375.0 |
| 2022-01-12 12:00:00 | NQ | Futures | 18433.24 | 18494.1 | 18387.16 | 18485.12 | 49963.0 |
| 2022-01-12 13:00:00 | NQ | Futures | 18485.41 | 18488.89 | 18402.23 | 18417.3 | 47319.0 |
| 2022-01-12 14:00:00 | NQ | Futures | 18417.3 | 18452.66 | 18385.13 | 18430.92 | 40735.0 |
| 2022-01-12 15:00:00 | NQ | Futures | 18431.21 | 18446.57 | 18381.65 | 18426.86 | 68207.0 |
| 2022-01-12 16:00:00 | NQ | Futures | 18427.73 | 18455.85 | 18423.97 | 18426.86 | 11449.0 |
| 2022-01-12 18:00:00 | NQ | Futures | 18433.53 | 18433.53 | 18410.34 | 18424.26 | 3493.0 |
| 2022-01-12 19:00:00 | NQ | Futures | 18423.97 | 18427.44 | 18406.0 | 18410.63 | 3291.0 |
| 2022-01-12 20:00:00 | NQ | Futures | 18411.5 | 18428.31 | 18339.63 | 18343.69 | 7079.0 |
| 2022-01-12 21:00:00 | NQ | Futures | 18343.11 | 18381.36 | 18342.82 | 18362.81 | 4735.0 |
| 2022-01-12 22:00:00 | NQ | Futures | 18362.81 | 18367.74 | 18341.08 | 18367.74 | 3481.0 |
| 2022-01-12 23:00:00 | NQ | Futures | 18367.74 | 18375.86 | 18363.97 | 18372.09 | 1867.0 |
| 2022-01-12 00:00:00 | YM | Futures | 40646.7 | 40680.4 | 40644.5 | 40680.4 | 1486.0 |
| 2022-01-12 01:00:00 | YM | Futures | 40678.2 | 40701.8 | 40654.6 | 40656.8 | 1392.0 |
| 2022-01-12 02:00:00 | YM | Futures | 40656.8 | 40693.9 | 40638.9 | 40651.2 | 1977.0 |
| 2022-01-12 03:00:00 | YM | Futures | 40650.1 | 40668.1 | 40554.6 | 40580.4 | 6376.0 |
> showing 50 of 2,031 rows — these rows as CSV