PREVIEW / futures_1hour / 2021-05-17
file: by_date/futures_1hour/2021/2021-05-17.parquet size: 64 KB rows: 1,965
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-05-17 00:00:00 | ES | Futures | 4672.52 | 4679.83 | 4670.55 | 4677.86 | 7124.0 |
| 2021-05-17 01:00:00 | ES | Futures | 4677.86 | 4684.32 | 4675.33 | 4676.73 | 10521.0 |
| 2021-05-17 02:00:00 | ES | Futures | 4676.73 | 4683.2 | 4675.89 | 4680.67 | 11674.0 |
| 2021-05-17 03:00:00 | ES | Futures | 4680.67 | 4686.85 | 4667.46 | 4670.83 | 25534.0 |
| 2021-05-17 04:00:00 | ES | Futures | 4670.83 | 4680.39 | 4670.55 | 4679.54 | 12319.0 |
| 2021-05-17 05:00:00 | ES | Futures | 4679.26 | 4679.83 | 4673.92 | 4674.77 | 10531.0 |
| 2021-05-17 06:00:00 | ES | Futures | 4674.77 | 4674.77 | 4666.9 | 4667.74 | 12712.0 |
| 2021-05-17 07:00:00 | ES | Futures | 4668.02 | 4672.52 | 4662.12 | 4663.53 | 22112.0 |
| 2021-05-17 08:00:00 | ES | Futures | 4663.53 | 4669.15 | 4661.0 | 4666.06 | 23980.0 |
| 2021-05-17 09:00:00 | ES | Futures | 4666.06 | 4683.2 | 4661.56 | 4666.62 | 201498.0 |
| 2021-05-17 10:00:00 | ES | Futures | 4666.62 | 4674.21 | 4655.66 | 4666.06 | 272138.0 |
| 2021-05-17 11:00:00 | ES | Futures | 4666.06 | 4668.31 | 4654.26 | 4657.91 | 152970.0 |
| 2021-05-17 12:00:00 | ES | Futures | 4657.63 | 4668.87 | 4654.26 | 4661.56 | 103509.0 |
| 2021-05-17 13:00:00 | ES | Futures | 4661.28 | 4664.37 | 4648.92 | 4656.5 | 120428.0 |
| 2021-05-17 14:00:00 | ES | Futures | 4656.5 | 4669.99 | 4654.54 | 4669.43 | 109350.0 |
| 2021-05-17 15:00:00 | ES | Futures | 4669.43 | 4675.61 | 4664.93 | 4673.64 | 223068.0 |
| 2021-05-17 16:00:00 | ES | Futures | 4673.92 | 4678.14 | 4670.27 | 4675.89 | 48865.0 |
| 2021-05-17 18:00:00 | ES | Futures | 4674.21 | 4677.3 | 4670.83 | 4671.12 | 4391.0 |
| 2021-05-17 19:00:00 | ES | Futures | 4671.12 | 4681.51 | 4670.83 | 4680.67 | 5973.0 |
| 2021-05-17 20:00:00 | ES | Futures | 4680.95 | 4683.2 | 4678.7 | 4682.92 | 10229.0 |
| 2021-05-17 21:00:00 | ES | Futures | 4682.92 | 4686.85 | 4680.39 | 4686.29 | 16255.0 |
| 2021-05-17 22:00:00 | ES | Futures | 4686.29 | 4687.13 | 4682.35 | 4684.04 | 8205.0 |
| 2021-05-17 23:00:00 | ES | Futures | 4684.04 | 4686.29 | 4683.48 | 4685.44 | 4142.0 |
| 2021-05-17 00:00:00 | NQ | Futures | 15459.92 | 15495.24 | 15449.21 | 15477.58 | 3774.0 |
| 2021-05-17 01:00:00 | NQ | Futures | 15477.87 | 15514.92 | 15469.18 | 15472.94 | 5518.0 |
| 2021-05-17 02:00:00 | NQ | Futures | 15473.23 | 15510.29 | 15465.13 | 15478.15 | 5938.0 |
| 2021-05-17 03:00:00 | NQ | Futures | 15477.0 | 15508.84 | 15438.2 | 15452.1 | 9384.0 |
| 2021-05-17 04:00:00 | NQ | Futures | 15452.97 | 15481.05 | 15446.31 | 15474.39 | 5592.0 |
| 2021-05-17 05:00:00 | NQ | Futures | 15473.81 | 15480.18 | 15449.49 | 15455.0 | 4970.0 |
| 2021-05-17 06:00:00 | NQ | Futures | 15455.0 | 15455.57 | 15430.68 | 15438.78 | 5591.0 |
| 2021-05-17 07:00:00 | NQ | Futures | 15439.07 | 15455.28 | 15409.25 | 15410.41 | 7702.0 |
| 2021-05-17 08:00:00 | NQ | Futures | 15410.99 | 15433.28 | 15402.31 | 15410.12 | 9126.0 |
| 2021-05-17 09:00:00 | NQ | Futures | 15410.12 | 15450.94 | 15358.59 | 15385.23 | 62484.0 |
| 2021-05-17 10:00:00 | NQ | Futures | 15383.78 | 15434.15 | 15328.78 | 15392.17 | 89805.0 |
| 2021-05-17 11:00:00 | NQ | Futures | 15391.6 | 15406.07 | 15318.06 | 15329.64 | 51553.0 |
| 2021-05-17 12:00:00 | NQ | Futures | 15329.35 | 15364.09 | 15307.35 | 15326.75 | 35879.0 |
| 2021-05-17 13:00:00 | NQ | Futures | 15326.46 | 15339.49 | 15265.38 | 15294.04 | 42162.0 |
| 2021-05-17 14:00:00 | NQ | Futures | 15294.33 | 15355.99 | 15285.64 | 15353.38 | 39024.0 |
| 2021-05-17 15:00:00 | NQ | Futures | 15354.25 | 15408.68 | 15339.49 | 15407.81 | 57072.0 |
| 2021-05-17 16:00:00 | NQ | Futures | 15407.52 | 15420.55 | 15393.33 | 15415.04 | 8934.0 |
| 2021-05-17 18:00:00 | NQ | Futures | 15410.99 | 15424.02 | 15392.17 | 15393.04 | 3306.0 |
| 2021-05-17 19:00:00 | NQ | Futures | 15394.2 | 15439.07 | 15389.57 | 15435.31 | 3460.0 |
| 2021-05-17 20:00:00 | NQ | Futures | 15435.6 | 15454.42 | 15432.99 | 15453.26 | 4373.0 |
| 2021-05-17 21:00:00 | NQ | Futures | 15452.68 | 15474.1 | 15447.47 | 15467.44 | 4984.0 |
| 2021-05-17 22:00:00 | NQ | Futures | 15467.15 | 15473.81 | 15446.31 | 15457.89 | 3106.0 |
| 2021-05-17 23:00:00 | NQ | Futures | 15458.76 | 15466.86 | 15450.07 | 15463.1 | 1691.0 |
| 2021-05-17 00:00:00 | YM | Futures | 38095.9 | 38152.7 | 38084.8 | 38141.6 | 1447.0 |
| 2021-05-17 01:00:00 | YM | Futures | 38141.6 | 38187.3 | 38126.0 | 38132.7 | 1970.0 |
| 2021-05-17 02:00:00 | YM | Futures | 38131.6 | 38173.9 | 38127.1 | 38172.8 | 2415.0 |
| 2021-05-17 03:00:00 | YM | Futures | 38172.8 | 38214.0 | 38043.6 | 38082.6 | 5616.0 |
> showing 50 of 1,965 rows — these rows as CSV