PREVIEW / futures_1hour / 2021-02-18
file: by_date/futures_1hour/2021/2021-02-18.parquet size: 63 KB rows: 1,948
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-02-18 00:00:00 | ES | Futures | 4399.73 | 4405.62 | 4397.76 | 4400.85 | 8835.0 |
| 2021-02-18 01:00:00 | ES | Futures | 4401.13 | 4405.34 | 4398.88 | 4399.45 | 6757.0 |
| 2021-02-18 02:00:00 | ES | Futures | 4399.45 | 4399.45 | 4392.99 | 4394.67 | 10675.0 |
| 2021-02-18 03:00:00 | ES | Futures | 4394.67 | 4406.18 | 4389.9 | 4406.18 | 25469.0 |
| 2021-02-18 04:00:00 | ES | Futures | 4405.9 | 4406.18 | 4394.11 | 4398.88 | 15328.0 |
| 2021-02-18 05:00:00 | ES | Futures | 4398.88 | 4400.29 | 4391.87 | 4393.55 | 22085.0 |
| 2021-02-18 06:00:00 | ES | Futures | 4393.27 | 4393.83 | 4383.45 | 4392.99 | 25609.0 |
| 2021-02-18 07:00:00 | ES | Futures | 4392.99 | 4396.64 | 4391.31 | 4393.83 | 25801.0 |
| 2021-02-18 08:00:00 | ES | Futures | 4394.11 | 4394.67 | 4376.99 | 4380.08 | 56213.0 |
| 2021-02-18 09:00:00 | ES | Futures | 4380.08 | 4385.41 | 4369.69 | 4379.8 | 234268.0 |
| 2021-02-18 10:00:00 | ES | Futures | 4379.8 | 4380.36 | 4356.5 | 4370.54 | 301593.0 |
| 2021-02-18 11:00:00 | ES | Futures | 4370.26 | 4380.08 | 4367.17 | 4369.98 | 144768.0 |
| 2021-02-18 12:00:00 | ES | Futures | 4369.98 | 4375.59 | 4361.56 | 4372.5 | 110005.0 |
| 2021-02-18 13:00:00 | ES | Futures | 4372.5 | 4387.94 | 4368.57 | 4384.57 | 117131.0 |
| 2021-02-18 14:00:00 | ES | Futures | 4384.85 | 4394.67 | 4384.29 | 4393.55 | 104900.0 |
| 2021-02-18 15:00:00 | ES | Futures | 4393.55 | 4399.16 | 4386.53 | 4391.03 | 172861.0 |
| 2021-02-18 16:00:00 | ES | Futures | 4391.03 | 4394.11 | 4388.5 | 4390.46 | 37638.0 |
| 2021-02-18 18:00:00 | ES | Futures | 4390.18 | 4393.83 | 4382.32 | 4384.85 | 9597.0 |
| 2021-02-18 19:00:00 | ES | Futures | 4384.85 | 4387.94 | 4383.45 | 4387.38 | 8642.0 |
| 2021-02-18 20:00:00 | ES | Futures | 4387.38 | 4393.83 | 4370.26 | 4376.71 | 26612.0 |
| 2021-02-18 21:00:00 | ES | Futures | 4376.71 | 4377.55 | 4367.45 | 4369.69 | 16579.0 |
| 2021-02-18 22:00:00 | ES | Futures | 4369.69 | 4374.75 | 4368.85 | 4371.38 | 7817.0 |
| 2021-02-18 23:00:00 | ES | Futures | 4371.38 | 4377.27 | 4370.26 | 4375.31 | 5915.0 |
| 2021-02-18 00:00:00 | NQ | Futures | 15777.03 | 15798.16 | 15770.67 | 15778.48 | 5188.0 |
| 2021-02-18 01:00:00 | NQ | Futures | 15778.19 | 15802.79 | 15775.59 | 15783.69 | 3483.0 |
| 2021-02-18 02:00:00 | NQ | Futures | 15782.82 | 15783.69 | 15760.54 | 15772.11 | 4369.0 |
| 2021-02-18 03:00:00 | NQ | Futures | 15772.98 | 15808.29 | 15752.43 | 15807.13 | 8480.0 |
| 2021-02-18 04:00:00 | NQ | Futures | 15806.84 | 15808.29 | 15764.3 | 15776.45 | 5683.0 |
| 2021-02-18 05:00:00 | NQ | Futures | 15776.45 | 15786.01 | 15745.2 | 15750.98 | 7237.0 |
| 2021-02-18 06:00:00 | NQ | Futures | 15750.69 | 15753.01 | 15711.04 | 15744.91 | 8923.0 |
| 2021-02-18 07:00:00 | NQ | Futures | 15744.91 | 15762.56 | 15736.22 | 15746.93 | 7800.0 |
| 2021-02-18 08:00:00 | NQ | Futures | 15746.64 | 15749.54 | 15689.91 | 15700.04 | 16629.0 |
| 2021-02-18 09:00:00 | NQ | Futures | 15700.33 | 15726.09 | 15655.47 | 15707.57 | 83951.0 |
| 2021-02-18 10:00:00 | NQ | Futures | 15707.57 | 15710.46 | 15592.37 | 15662.71 | 106693.0 |
| 2021-02-18 11:00:00 | NQ | Futures | 15662.13 | 15712.49 | 15646.21 | 15666.76 | 63236.0 |
| 2021-02-18 12:00:00 | NQ | Futures | 15667.05 | 15708.73 | 15625.08 | 15695.41 | 45009.0 |
| 2021-02-18 13:00:00 | NQ | Futures | 15695.12 | 15761.4 | 15673.71 | 15745.48 | 46002.0 |
| 2021-02-18 14:00:00 | NQ | Futures | 15745.48 | 15801.06 | 15743.75 | 15794.98 | 40032.0 |
| 2021-02-18 15:00:00 | NQ | Futures | 15794.98 | 15825.66 | 15777.32 | 15789.48 | 59188.0 |
| 2021-02-18 16:00:00 | NQ | Futures | 15789.77 | 15802.79 | 15781.95 | 15791.5 | 8126.0 |
| 2021-02-18 18:00:00 | NQ | Futures | 15789.48 | 15810.32 | 15752.43 | 15764.3 | 4727.0 |
| 2021-02-18 19:00:00 | NQ | Futures | 15762.85 | 15772.69 | 15754.17 | 15771.53 | 5010.0 |
| 2021-02-18 20:00:00 | NQ | Futures | 15771.53 | 15794.11 | 15694.54 | 15728.41 | 11599.0 |
| 2021-02-18 21:00:00 | NQ | Futures | 15728.7 | 15730.72 | 15687.31 | 15692.52 | 6790.0 |
| 2021-02-18 22:00:00 | NQ | Futures | 15691.94 | 15717.41 | 15687.31 | 15708.44 | 3248.0 |
| 2021-02-18 23:00:00 | NQ | Futures | 15708.73 | 15729.57 | 15701.2 | 15720.59 | 2621.0 |
| 2021-02-18 00:00:00 | YM | Futures | 34966.3 | 35010.6 | 34955.2 | 34979.6 | 1855.0 |
| 2021-02-18 01:00:00 | YM | Futures | 34977.4 | 35001.8 | 34960.7 | 34962.9 | 1306.0 |
| 2021-02-18 02:00:00 | YM | Futures | 34961.8 | 34961.8 | 34910.8 | 34917.5 | 2282.0 |
| 2021-02-18 03:00:00 | YM | Futures | 34920.8 | 35002.9 | 34879.8 | 35000.7 | 5758.0 |
> showing 50 of 1,948 rows — these rows as CSV