PREVIEW / futures_1hour / 2022-01-13
file: by_date/futures_1hour/2022/2022-01-13.parquet size: 67 KB rows: 2,039
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-13 00:00:00 | ES | Futures | 5327.14 | 5328.84 | 5321.49 | 5322.62 | 5442.0 |
| 2022-01-13 01:00:00 | ES | Futures | 5322.62 | 5331.39 | 5321.49 | 5325.73 | 6329.0 |
| 2022-01-13 02:00:00 | ES | Futures | 5325.73 | 5326.29 | 5320.92 | 5325.45 | 7803.0 |
| 2022-01-13 03:00:00 | ES | Futures | 5325.45 | 5341.0 | 5323.47 | 5333.36 | 19650.0 |
| 2022-01-13 04:00:00 | ES | Futures | 5333.65 | 5336.19 | 5329.12 | 5335.91 | 9758.0 |
| 2022-01-13 05:00:00 | ES | Futures | 5335.63 | 5341.85 | 5335.06 | 5339.3 | 8667.0 |
| 2022-01-13 06:00:00 | ES | Futures | 5339.3 | 5342.98 | 5333.36 | 5333.93 | 9857.0 |
| 2022-01-13 07:00:00 | ES | Futures | 5333.93 | 5341.28 | 5333.36 | 5339.59 | 10506.0 |
| 2022-01-13 08:00:00 | ES | Futures | 5339.59 | 5349.77 | 5336.19 | 5347.79 | 35677.0 |
| 2022-01-13 09:00:00 | ES | Futures | 5348.07 | 5357.69 | 5344.68 | 5351.46 | 168216.0 |
| 2022-01-13 10:00:00 | ES | Futures | 5351.46 | 5353.44 | 5315.83 | 5324.6 | 262520.0 |
| 2022-01-13 11:00:00 | ES | Futures | 5324.32 | 5340.43 | 5318.66 | 5335.06 | 173035.0 |
| 2022-01-13 12:00:00 | ES | Futures | 5335.34 | 5335.34 | 5290.1 | 5298.3 | 252685.0 |
| 2022-01-13 13:00:00 | ES | Futures | 5298.01 | 5312.15 | 5290.66 | 5309.61 | 170499.0 |
| 2022-01-13 14:00:00 | ES | Futures | 5309.61 | 5316.11 | 5288.68 | 5294.9 | 140714.0 |
| 2022-01-13 15:00:00 | ES | Futures | 5294.9 | 5295.47 | 5251.63 | 5263.51 | 371156.0 |
| 2022-01-13 16:00:00 | ES | Futures | 5263.8 | 5268.89 | 5255.88 | 5262.95 | 76452.0 |
| 2022-01-13 18:00:00 | ES | Futures | 5265.78 | 5268.89 | 5263.23 | 5266.62 | 10833.0 |
| 2022-01-13 19:00:00 | ES | Futures | 5266.34 | 5268.32 | 5253.61 | 5265.21 | 17927.0 |
| 2022-01-13 20:00:00 | ES | Futures | 5265.49 | 5269.45 | 5254.18 | 5257.29 | 13247.0 |
| 2022-01-13 21:00:00 | ES | Futures | 5257.01 | 5260.12 | 5246.54 | 5259.55 | 14997.0 |
| 2022-01-13 22:00:00 | ES | Futures | 5259.55 | 5262.95 | 5252.77 | 5256.16 | 7980.0 |
| 2022-01-13 23:00:00 | ES | Futures | 5256.16 | 5268.32 | 5256.16 | 5264.64 | 8171.0 |
| 2022-01-13 00:00:00 | NQ | Futures | 18372.09 | 18379.04 | 18352.67 | 18355.57 | 3821.0 |
| 2022-01-13 01:00:00 | NQ | Futures | 18355.86 | 18397.59 | 18352.38 | 18379.04 | 4372.0 |
| 2022-01-13 02:00:00 | NQ | Futures | 18377.89 | 18390.64 | 18357.02 | 18389.77 | 4795.0 |
| 2022-01-13 03:00:00 | NQ | Futures | 18390.35 | 18454.11 | 18382.52 | 18418.17 | 11126.0 |
| 2022-01-13 04:00:00 | NQ | Futures | 18418.46 | 18424.84 | 18390.93 | 18424.84 | 4787.0 |
| 2022-01-13 05:00:00 | NQ | Futures | 18424.26 | 18459.9 | 18420.78 | 18434.69 | 7070.0 |
| 2022-01-13 06:00:00 | NQ | Futures | 18435.27 | 18450.92 | 18403.39 | 18408.03 | 5139.0 |
| 2022-01-13 07:00:00 | NQ | Futures | 18407.16 | 18448.6 | 18405.71 | 18437.3 | 5534.0 |
| 2022-01-13 08:00:00 | NQ | Futures | 18436.72 | 18494.97 | 18421.36 | 18479.32 | 20616.0 |
| 2022-01-13 09:00:00 | NQ | Futures | 18480.19 | 18524.82 | 18448.6 | 18477.58 | 84086.0 |
| 2022-01-13 10:00:00 | NQ | Futures | 18476.13 | 18486.57 | 18230.37 | 18274.42 | 140575.0 |
| 2022-01-13 11:00:00 | NQ | Futures | 18274.13 | 18352.09 | 18235.01 | 18316.73 | 83070.0 |
| 2022-01-13 12:00:00 | NQ | Futures | 18316.44 | 18316.44 | 18077.92 | 18127.19 | 104206.0 |
| 2022-01-13 13:00:00 | NQ | Futures | 18126.9 | 18195.59 | 18092.71 | 18174.72 | 70746.0 |
| 2022-01-13 14:00:00 | NQ | Futures | 18174.72 | 18216.46 | 18078.21 | 18114.44 | 59642.0 |
| 2022-01-13 15:00:00 | NQ | Futures | 18114.15 | 18116.18 | 17920.26 | 17966.34 | 103520.0 |
| 2022-01-13 16:00:00 | NQ | Futures | 17967.79 | 17987.21 | 17933.89 | 17970.69 | 18529.0 |
| 2022-01-13 18:00:00 | NQ | Futures | 17974.46 | 17987.21 | 17956.49 | 17966.63 | 6179.0 |
| 2022-01-13 19:00:00 | NQ | Futures | 17965.77 | 17977.65 | 17912.15 | 17963.45 | 10733.0 |
| 2022-01-13 20:00:00 | NQ | Futures | 17964.03 | 17982.0 | 17912.73 | 17929.25 | 8237.0 |
| 2022-01-13 21:00:00 | NQ | Futures | 17930.12 | 17937.94 | 17868.97 | 17915.34 | 8980.0 |
| 2022-01-13 22:00:00 | NQ | Futures | 17915.92 | 17935.04 | 17898.82 | 17920.55 | 5927.0 |
| 2022-01-13 23:00:00 | NQ | Futures | 17921.13 | 17979.39 | 17921.13 | 17960.26 | 5691.0 |
| 2022-01-13 00:00:00 | YM | Futures | 40596.2 | 40606.3 | 40546.7 | 40564.7 | 1272.0 |
| 2022-01-13 01:00:00 | YM | Futures | 40568.1 | 40619.8 | 40553.5 | 40577.1 | 1198.0 |
| 2022-01-13 02:00:00 | YM | Futures | 40574.8 | 40578.2 | 40537.7 | 40553.5 | 2310.0 |
| 2022-01-13 03:00:00 | YM | Futures | 40554.6 | 40659.1 | 40538.8 | 40607.4 | 4564.0 |
> showing 50 of 2,039 rows — these rows as CSV