PREVIEW / futures_1hour / 2021-05-10
file: by_date/futures_1hour/2021/2021-05-10.parquet size: 64 KB rows: 1,987
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-10 00:00:00 | ES | Futures | 4757.65 | 4759.06 | 4755.69 | 4756.81 | 4450.0 |
| 2021-05-10 01:00:00 | ES | Futures | 4756.81 | 4758.5 | 4754.56 | 4757.93 | 6884.0 |
| 2021-05-10 02:00:00 | ES | Futures | 4758.22 | 4758.78 | 4749.51 | 4752.88 | 11714.0 |
| 2021-05-10 03:00:00 | ES | Futures | 4752.88 | 4753.16 | 4745.29 | 4750.07 | 21999.0 |
| 2021-05-10 04:00:00 | ES | Futures | 4750.35 | 4754.28 | 4747.26 | 4747.82 | 11748.0 |
| 2021-05-10 05:00:00 | ES | Futures | 4748.1 | 4751.19 | 4746.7 | 4748.94 | 9264.0 |
| 2021-05-10 06:00:00 | ES | Futures | 4749.22 | 4753.16 | 4747.82 | 4752.6 | 12875.0 |
| 2021-05-10 07:00:00 | ES | Futures | 4752.32 | 4754.28 | 4750.35 | 4751.75 | 16996.0 |
| 2021-05-10 08:00:00 | ES | Futures | 4751.75 | 4757.09 | 4750.91 | 4753.44 | 31344.0 |
| 2021-05-10 09:00:00 | ES | Futures | 4753.44 | 4755.12 | 4743.32 | 4748.1 | 187800.0 |
| 2021-05-10 10:00:00 | ES | Futures | 4748.38 | 4751.75 | 4736.3 | 4742.2 | 261214.0 |
| 2021-05-10 11:00:00 | ES | Futures | 4742.2 | 4752.32 | 4739.67 | 4750.91 | 151907.0 |
| 2021-05-10 12:00:00 | ES | Futures | 4751.19 | 4754.28 | 4744.17 | 4744.73 | 96460.0 |
| 2021-05-10 13:00:00 | ES | Futures | 4744.73 | 4746.98 | 4739.95 | 4740.51 | 94479.0 |
| 2021-05-10 14:00:00 | ES | Futures | 4740.51 | 4741.64 | 4710.17 | 4717.19 | 302791.0 |
| 2021-05-10 15:00:00 | ES | Futures | 4716.91 | 4722.53 | 4699.77 | 4702.02 | 291454.0 |
| 2021-05-10 16:00:00 | ES | Futures | 4702.3 | 4704.55 | 4688.82 | 4693.03 | 68557.0 |
| 2021-05-10 18:00:00 | ES | Futures | 4694.15 | 4702.86 | 4693.87 | 4702.58 | 12721.0 |
| 2021-05-10 19:00:00 | ES | Futures | 4702.86 | 4703.99 | 4698.65 | 4701.46 | 7346.0 |
| 2021-05-10 20:00:00 | ES | Futures | 4701.18 | 4703.43 | 4672.52 | 4678.7 | 31715.0 |
| 2021-05-10 21:00:00 | ES | Futures | 4678.42 | 4680.67 | 4666.62 | 4671.4 | 34558.0 |
| 2021-05-10 22:00:00 | ES | Futures | 4671.12 | 4673.92 | 4663.25 | 4670.83 | 18418.0 |
| 2021-05-10 23:00:00 | ES | Futures | 4670.83 | 4679.26 | 4667.46 | 4677.3 | 12282.0 |
| 2021-05-10 00:00:00 | NQ | Futures | 15894.16 | 15904.87 | 15883.74 | 15890.11 | 2641.0 |
| 2021-05-10 01:00:00 | NQ | Futures | 15889.53 | 15890.11 | 15871.0 | 15887.79 | 2999.0 |
| 2021-05-10 02:00:00 | NQ | Futures | 15888.37 | 15893.87 | 15810.78 | 15838.87 | 8225.0 |
| 2021-05-10 03:00:00 | NQ | Futures | 15838.29 | 15844.66 | 15790.81 | 15825.84 | 9217.0 |
| 2021-05-10 04:00:00 | NQ | Futures | 15826.42 | 15852.18 | 15812.81 | 15818.31 | 5413.0 |
| 2021-05-10 05:00:00 | NQ | Futures | 15817.15 | 15846.68 | 15813.39 | 15832.79 | 4494.0 |
| 2021-05-10 06:00:00 | NQ | Futures | 15833.08 | 15837.42 | 15806.73 | 15830.47 | 4676.0 |
| 2021-05-10 07:00:00 | NQ | Futures | 15831.05 | 15840.6 | 15797.76 | 15803.55 | 7465.0 |
| 2021-05-10 08:00:00 | NQ | Futures | 15803.84 | 15842.63 | 15796.02 | 15822.94 | 11145.0 |
| 2021-05-10 09:00:00 | NQ | Futures | 15822.36 | 15829.89 | 15648.09 | 15674.72 | 84602.0 |
| 2021-05-10 10:00:00 | NQ | Futures | 15674.72 | 15696.14 | 15584.11 | 15613.64 | 97441.0 |
| 2021-05-10 11:00:00 | NQ | Futures | 15613.35 | 15656.48 | 15578.61 | 15653.59 | 64507.0 |
| 2021-05-10 12:00:00 | NQ | Futures | 15654.17 | 15682.83 | 15626.96 | 15630.43 | 41564.0 |
| 2021-05-10 13:00:00 | NQ | Futures | 15630.43 | 15649.83 | 15588.45 | 15600.9 | 41188.0 |
| 2021-05-10 14:00:00 | NQ | Futures | 15601.19 | 15605.53 | 15472.65 | 15499.29 | 94797.0 |
| 2021-05-10 15:00:00 | NQ | Futures | 15498.71 | 15533.16 | 15461.94 | 15466.29 | 75569.0 |
| 2021-05-10 16:00:00 | NQ | Futures | 15465.71 | 15479.89 | 15407.52 | 15414.47 | 17032.0 |
| 2021-05-10 18:00:00 | NQ | Futures | 15420.26 | 15445.73 | 15409.25 | 15442.55 | 6272.0 |
| 2021-05-10 19:00:00 | NQ | Futures | 15442.55 | 15445.44 | 15426.91 | 15440.81 | 3337.0 |
| 2021-05-10 20:00:00 | NQ | Futures | 15440.52 | 15452.68 | 15250.61 | 15317.48 | 15593.0 |
| 2021-05-10 21:00:00 | NQ | Futures | 15317.2 | 15319.22 | 15257.85 | 15292.01 | 16396.0 |
| 2021-05-10 22:00:00 | NQ | Futures | 15291.43 | 15315.17 | 15261.61 | 15301.56 | 8545.0 |
| 2021-05-10 23:00:00 | NQ | Futures | 15301.27 | 15331.09 | 15293.46 | 15323.56 | 4794.0 |
| 2021-05-10 00:00:00 | YM | Futures | 38730.8 | 38743.1 | 38721.9 | 38729.7 | 786.0 |
| 2021-05-10 01:00:00 | YM | Futures | 38728.6 | 38750.9 | 38714.1 | 38747.5 | 1259.0 |
| 2021-05-10 02:00:00 | YM | Futures | 38747.5 | 38752.0 | 38718.6 | 38745.3 | 2551.0 |
| 2021-05-10 03:00:00 | YM | Futures | 38745.3 | 38745.3 | 38687.4 | 38719.7 | 4139.0 |
> showing 50 of 1,987 rows — these rows as CSV