PREVIEW / futures_1hour / 2022-03-14
file: by_date/futures_1hour/2022/2022-03-14.parquet size: 68 KB rows: 2,015
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-03-14 00:00:00 | ES | Futures | 4773.42 | 4781.92 | 4773.42 | 4779.65 | 3829.0 |
| 2022-03-14 01:00:00 | ES | Futures | 4779.65 | 4789.86 | 4775.12 | 4781.92 | 6174.0 |
| 2022-03-14 02:00:00 | ES | Futures | 4781.64 | 4800.91 | 4775.68 | 4792.12 | 11813.0 |
| 2022-03-14 03:00:00 | ES | Futures | 4791.84 | 4799.49 | 4780.5 | 4786.45 | 16367.0 |
| 2022-03-14 04:00:00 | ES | Futures | 4786.17 | 4799.78 | 4775.12 | 4783.34 | 24811.0 |
| 2022-03-14 05:00:00 | ES | Futures | 4783.62 | 4812.53 | 4779.94 | 4806.86 | 20589.0 |
| 2022-03-14 06:00:00 | ES | Futures | 4807.15 | 4808.0 | 4790.99 | 4801.48 | 15735.0 |
| 2022-03-14 07:00:00 | ES | Futures | 4801.19 | 4801.48 | 4762.36 | 4764.06 | 27492.0 |
| 2022-03-14 08:00:00 | ES | Futures | 4763.78 | 4782.77 | 4761.23 | 4780.79 | 31928.0 |
| 2022-03-14 09:00:00 | ES | Futures | 4780.79 | 4780.79 | 4745.36 | 4770.58 | 139807.0 |
| 2022-03-14 10:00:00 | ES | Futures | 4770.3 | 4804.59 | 4760.95 | 4804.31 | 147005.0 |
| 2022-03-14 11:00:00 | ES | Futures | 4804.31 | 4806.86 | 4754.99 | 4760.66 | 112515.0 |
| 2022-03-14 12:00:00 | ES | Futures | 4760.66 | 4760.66 | 4730.62 | 4731.47 | 122791.0 |
| 2022-03-14 13:00:00 | ES | Futures | 4731.18 | 4734.02 | 4711.06 | 4717.86 | 130001.0 |
| 2022-03-14 14:00:00 | ES | Futures | 4717.86 | 4724.66 | 4707.66 | 4722.68 | 84032.0 |
| 2022-03-14 15:00:00 | ES | Futures | 4722.68 | 4735.15 | 4710.21 | 4722.11 | 200722.0 |
| 2022-03-14 16:00:00 | ES | Futures | 4722.11 | 4734.59 | 4719.56 | 4729.2 | 39490.0 |
| 2022-03-14 18:00:00 | ES | Futures | 4729.2 | 4739.12 | 4724.38 | 4734.87 | 5654.0 |
| 2022-03-14 19:00:00 | ES | Futures | 4734.87 | 4736.57 | 4729.2 | 4731.47 | 5036.0 |
| 2022-03-14 20:00:00 | ES | Futures | 4731.47 | 4734.87 | 4722.68 | 4727.22 | 8214.0 |
| 2022-03-14 21:00:00 | ES | Futures | 4727.22 | 4733.17 | 4715.59 | 4721.26 | 15293.0 |
| 2022-03-14 22:00:00 | ES | Futures | 4720.98 | 4742.24 | 4720.98 | 4735.15 | 13196.0 |
| 2022-03-14 23:00:00 | ES | Futures | 4735.44 | 4739.4 | 4728.92 | 4732.32 | 5758.0 |
| 2022-03-14 00:00:00 | NQ | Futures | 15435.95 | 15475.1 | 15435.08 | 15466.69 | 2448.0 |
| 2022-03-14 01:00:00 | NQ | Futures | 15466.4 | 15495.98 | 15438.85 | 15463.21 | 3518.0 |
| 2022-03-14 02:00:00 | NQ | Futures | 15462.63 | 15539.18 | 15438.56 | 15505.26 | 5342.0 |
| 2022-03-14 03:00:00 | NQ | Futures | 15504.97 | 15540.34 | 15458.57 | 15491.34 | 5462.0 |
| 2022-03-14 04:00:00 | NQ | Futures | 15491.05 | 15526.71 | 15424.35 | 15465.53 | 8616.0 |
| 2022-03-14 05:00:00 | NQ | Futures | 15464.95 | 15590.8 | 15450.74 | 15552.23 | 7231.0 |
| 2022-03-14 06:00:00 | NQ | Futures | 15552.52 | 15554.26 | 15491.05 | 15522.94 | 5702.0 |
| 2022-03-14 07:00:00 | NQ | Futures | 15522.07 | 15522.94 | 15336.2 | 15349.25 | 9071.0 |
| 2022-03-14 08:00:00 | NQ | Futures | 15345.77 | 15448.71 | 15337.65 | 15438.85 | 11453.0 |
| 2022-03-14 09:00:00 | NQ | Futures | 15440.01 | 15469.88 | 15310.68 | 15394.2 | 62630.0 |
| 2022-03-14 10:00:00 | NQ | Futures | 15393.62 | 15530.19 | 15349.25 | 15504.1 | 74524.0 |
| 2022-03-14 11:00:00 | NQ | Futures | 15502.94 | 15512.51 | 15277.63 | 15297.05 | 44350.0 |
| 2022-03-14 12:00:00 | NQ | Futures | 15295.02 | 15295.6 | 15165.98 | 15168.01 | 40496.0 |
| 2022-03-14 13:00:00 | NQ | Futures | 15167.72 | 15204.55 | 15104.22 | 15158.74 | 41233.0 |
| 2022-03-14 14:00:00 | NQ | Futures | 15157.58 | 15186.86 | 15111.76 | 15171.78 | 36225.0 |
| 2022-03-14 15:00:00 | NQ | Futures | 15170.62 | 15217.6 | 15096.68 | 15134.96 | 65776.0 |
| 2022-03-14 16:00:00 | NQ | Futures | 15136.12 | 15182.22 | 15126.84 | 15170.04 | 9470.0 |
| 2022-03-14 18:00:00 | NQ | Futures | 15170.91 | 15210.64 | 15155.55 | 15197.59 | 2818.0 |
| 2022-03-14 19:00:00 | NQ | Futures | 15196.43 | 15213.25 | 15176.42 | 15200.78 | 2848.0 |
| 2022-03-14 20:00:00 | NQ | Futures | 15201.65 | 15207.45 | 15163.38 | 15185.12 | 4061.0 |
| 2022-03-14 21:00:00 | NQ | Futures | 15185.41 | 15204.55 | 15135.25 | 15154.68 | 5082.0 |
| 2022-03-14 22:00:00 | NQ | Futures | 15152.94 | 15241.38 | 15149.46 | 15210.93 | 4599.0 |
| 2022-03-14 23:00:00 | NQ | Futures | 15210.93 | 15229.49 | 15195.85 | 15203.1 | 2446.0 |
| 2022-03-14 00:00:00 | YM | Futures | 37188.4 | 37230.1 | 37183.9 | 37208.7 | 976.0 |
| 2022-03-14 01:00:00 | YM | Futures | 37210.9 | 37285.3 | 37190.6 | 37233.5 | 1416.0 |
| 2022-03-14 02:00:00 | YM | Futures | 37232.4 | 37362.0 | 37190.6 | 37307.9 | 2649.0 |
| 2022-03-14 03:00:00 | YM | Futures | 37305.6 | 37367.6 | 37239.1 | 37272.9 | 4974.0 |
> showing 50 of 2,015 rows — these rows as CSV