PREVIEW / futures_1hour / 2021-03-05
file: by_date/futures_1hour/2021/2021-03-05.parquet size: 53 KB rows: 1,530
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-05 00:00:00 | ES | Futures | 4213.64 | 4232.17 | 4212.24 | 4231.33 | 13681.0 |
| 2021-03-05 01:00:00 | ES | Futures | 4231.61 | 4232.45 | 4218.98 | 4226.27 | 9899.0 |
| 2021-03-05 02:00:00 | ES | Futures | 4226.27 | 4230.48 | 4208.87 | 4218.98 | 20345.0 |
| 2021-03-05 03:00:00 | ES | Futures | 4218.98 | 4219.82 | 4197.65 | 4214.49 | 43734.0 |
| 2021-03-05 04:00:00 | ES | Futures | 4214.77 | 4219.82 | 4204.38 | 4213.08 | 22620.0 |
| 2021-03-05 05:00:00 | ES | Futures | 4213.08 | 4225.43 | 4209.43 | 4220.94 | 20542.0 |
| 2021-03-05 06:00:00 | ES | Futures | 4220.94 | 4239.47 | 4220.1 | 4231.89 | 30045.0 |
| 2021-03-05 07:00:00 | ES | Futures | 4231.89 | 4244.24 | 4228.52 | 4241.43 | 34383.0 |
| 2021-03-05 08:00:00 | ES | Futures | 4241.43 | 4262.76 | 4216.45 | 4256.87 | 171583.0 |
| 2021-03-05 09:00:00 | ES | Futures | 4256.87 | 4282.41 | 4220.94 | 4238.34 | 393969.0 |
| 2021-03-05 10:00:00 | ES | Futures | 4238.34 | 4259.95 | 4211.12 | 4216.73 | 461726.0 |
| 2021-03-05 11:00:00 | ES | Futures | 4216.73 | 4224.03 | 4185.86 | 4221.78 | 353999.0 |
| 2021-03-05 12:00:00 | ES | Futures | 4221.78 | 4263.04 | 4217.01 | 4258.55 | 269263.0 |
| 2021-03-05 13:00:00 | ES | Futures | 4258.55 | 4289.42 | 4244.8 | 4283.53 | 257847.0 |
| 2021-03-05 14:00:00 | ES | Futures | 4283.81 | 4305.14 | 4267.53 | 4303.18 | 192835.0 |
| 2021-03-05 15:00:00 | ES | Futures | 4303.46 | 4322.26 | 4296.72 | 4308.79 | 343187.0 |
| 2021-03-05 16:00:00 | ES | Futures | 4309.07 | 4314.4 | 4306.26 | 4311.6 | 68855.0 |
| 2021-03-05 00:00:00 | NQ | Futures | 14353.02 | 14441.88 | 14340.86 | 14436.95 | 9105.0 |
| 2021-03-05 01:00:00 | NQ | Futures | 14436.95 | 14441.59 | 14375.02 | 14401.93 | 6928.0 |
| 2021-03-05 02:00:00 | NQ | Futures | 14402.8 | 14416.98 | 14312.21 | 14371.83 | 12991.0 |
| 2021-03-05 03:00:00 | NQ | Futures | 14372.12 | 14395.86 | 14300.34 | 14369.81 | 20051.0 |
| 2021-03-05 04:00:00 | NQ | Futures | 14370.96 | 14404.54 | 14329.29 | 14338.26 | 12914.0 |
| 2021-03-05 05:00:00 | NQ | Futures | 14337.68 | 14388.62 | 14320.31 | 14370.39 | 9255.0 |
| 2021-03-05 06:00:00 | NQ | Futures | 14370.67 | 14450.27 | 14366.91 | 14411.2 | 12435.0 |
| 2021-03-05 07:00:00 | NQ | Futures | 14410.62 | 14480.37 | 14393.25 | 14465.61 | 15557.0 |
| 2021-03-05 08:00:00 | NQ | Futures | 14464.74 | 14509.89 | 14322.63 | 14471.69 | 54410.0 |
| 2021-03-05 09:00:00 | NQ | Futures | 14472.27 | 14625.09 | 14307.87 | 14383.41 | 139586.0 |
| 2021-03-05 10:00:00 | NQ | Futures | 14382.83 | 14463.29 | 14259.82 | 14285.29 | 163294.0 |
| 2021-03-05 11:00:00 | NQ | Futures | 14286.74 | 14320.02 | 14132.76 | 14307.0 | 141354.0 |
| 2021-03-05 12:00:00 | NQ | Futures | 14307.0 | 14508.73 | 14256.93 | 14498.6 | 96438.0 |
| 2021-03-05 13:00:00 | NQ | Futures | 14497.74 | 14617.27 | 14411.2 | 14572.99 | 86955.0 |
| 2021-03-05 14:00:00 | NQ | Futures | 14573.28 | 14676.03 | 14483.55 | 14666.48 | 67143.0 |
| 2021-03-05 15:00:00 | NQ | Futures | 14666.77 | 14700.63 | 14620.75 | 14658.66 | 80652.0 |
| 2021-03-05 16:00:00 | NQ | Futures | 14658.66 | 14668.79 | 14640.72 | 14648.24 | 11237.0 |
| 2021-03-05 00:00:00 | YM | Futures | 34155.4 | 34283.0 | 34133.3 | 34277.5 | 3425.0 |
| 2021-03-05 01:00:00 | YM | Futures | 34278.6 | 34286.3 | 34187.6 | 34246.4 | 2198.0 |
| 2021-03-05 02:00:00 | YM | Futures | 34247.5 | 34274.1 | 34136.6 | 34190.9 | 4443.0 |
| 2021-03-05 03:00:00 | YM | Futures | 34189.8 | 34198.7 | 34027.9 | 34147.7 | 9772.0 |
| 2021-03-05 04:00:00 | YM | Futures | 34147.7 | 34173.2 | 34062.3 | 34158.8 | 6456.0 |
| 2021-03-05 05:00:00 | YM | Futures | 34158.8 | 34239.7 | 34126.6 | 34212.0 | 4424.0 |
| 2021-03-05 06:00:00 | YM | Futures | 34210.9 | 34351.8 | 34205.4 | 34296.3 | 6445.0 |
| 2021-03-05 07:00:00 | YM | Futures | 34295.2 | 34366.2 | 34265.3 | 34341.8 | 6846.0 |
| 2021-03-05 08:00:00 | YM | Futures | 34341.8 | 34554.8 | 34186.5 | 34498.2 | 23217.0 |
| 2021-03-05 09:00:00 | YM | Futures | 34499.3 | 34645.7 | 34281.9 | 34408.3 | 46170.0 |
| 2021-03-05 10:00:00 | YM | Futures | 34408.3 | 34583.6 | 34257.5 | 34287.4 | 51490.0 |
| 2021-03-05 11:00:00 | YM | Futures | 34289.7 | 34325.2 | 34086.7 | 34309.6 | 42670.0 |
| 2021-03-05 12:00:00 | YM | Futures | 34308.5 | 34559.2 | 34280.8 | 34525.9 | 27562.0 |
| 2021-03-05 13:00:00 | YM | Futures | 34525.9 | 34753.3 | 34446.1 | 34721.1 | 27244.0 |
| 2021-03-05 14:00:00 | YM | Futures | 34721.1 | 34840.9 | 34609.1 | 34825.4 | 20275.0 |
| 2021-03-05 15:00:00 | YM | Futures | 34826.5 | 34989.6 | 34795.5 | 34892.0 | 29890.0 |
> showing 50 of 1,530 rows — these rows as CSV