PREVIEW / futures_1hour / 2022-04-27
file: by_date/futures_1hour/2022/2022-04-27.parquet size: 69 KB rows: 2,086
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-04-27 00:00:00 | ES | Futures | 4752.16 | 4754.71 | 4747.91 | 4752.16 | 5100.0 |
| 2022-04-27 01:00:00 | ES | Futures | 4752.16 | 4757.54 | 4747.62 | 4750.74 | 10941.0 |
| 2022-04-27 02:00:00 | ES | Futures | 4751.02 | 4758.68 | 4744.79 | 4757.54 | 16425.0 |
| 2022-04-27 03:00:00 | ES | Futures | 4757.83 | 4772.57 | 4720.98 | 4770.3 | 42253.0 |
| 2022-04-27 04:00:00 | ES | Futures | 4770.02 | 4781.35 | 4760.95 | 4766.61 | 27671.0 |
| 2022-04-27 05:00:00 | ES | Futures | 4766.61 | 4775.68 | 4764.35 | 4774.83 | 17285.0 |
| 2022-04-27 06:00:00 | ES | Futures | 4774.83 | 4778.52 | 4762.93 | 4775.4 | 19491.0 |
| 2022-04-27 07:00:00 | ES | Futures | 4775.4 | 4775.4 | 4740.82 | 4746.77 | 35409.0 |
| 2022-04-27 08:00:00 | ES | Futures | 4746.77 | 4758.68 | 4740.82 | 4745.92 | 42513.0 |
| 2022-04-27 09:00:00 | ES | Futures | 4745.92 | 4792.69 | 4733.45 | 4777.95 | 255377.0 |
| 2022-04-27 10:00:00 | ES | Futures | 4778.24 | 4790.42 | 4713.04 | 4747.06 | 354435.0 |
| 2022-04-27 11:00:00 | ES | Futures | 4747.34 | 4781.07 | 4743.66 | 4766.05 | 205181.0 |
| 2022-04-27 12:00:00 | ES | Futures | 4766.05 | 4802.89 | 4755.28 | 4793.26 | 148915.0 |
| 2022-04-27 13:00:00 | ES | Futures | 4792.97 | 4796.66 | 4765.48 | 4791.56 | 174700.0 |
| 2022-04-27 14:00:00 | ES | Futures | 4791.84 | 4791.84 | 4750.17 | 4754.99 | 144413.0 |
| 2022-04-27 15:00:00 | ES | Futures | 4754.99 | 4758.39 | 4730.05 | 4738.55 | 299796.0 |
| 2022-04-27 16:00:00 | ES | Futures | 4738.84 | 4780.5 | 4733.73 | 4774.83 | 91736.0 |
| 2022-04-27 18:00:00 | ES | Futures | 4776.53 | 4781.07 | 4772.0 | 4774.27 | 7351.0 |
| 2022-04-27 19:00:00 | ES | Futures | 4774.55 | 4780.5 | 4770.87 | 4776.25 | 5559.0 |
| 2022-04-27 20:00:00 | ES | Futures | 4776.25 | 4776.25 | 4764.63 | 4774.27 | 7739.0 |
| 2022-04-27 21:00:00 | ES | Futures | 4774.55 | 4776.53 | 4762.36 | 4768.88 | 7616.0 |
| 2022-04-27 22:00:00 | ES | Futures | 4769.16 | 4777.95 | 4767.75 | 4774.27 | 5079.0 |
| 2022-04-27 23:00:00 | ES | Futures | 4774.55 | 4778.24 | 4769.45 | 4772.57 | 5535.0 |
| 2022-04-27 00:00:00 | NQ | Futures | 15156.13 | 15167.43 | 15130.9 | 15143.37 | 2642.0 |
| 2022-04-27 01:00:00 | NQ | Futures | 15144.82 | 15158.74 | 15121.04 | 15146.85 | 4181.0 |
| 2022-04-27 02:00:00 | NQ | Futures | 15145.4 | 15199.62 | 15119.59 | 15184.25 | 9273.0 |
| 2022-04-27 03:00:00 | NQ | Futures | 15184.83 | 15241.96 | 15053.18 | 15238.19 | 22513.0 |
| 2022-04-27 04:00:00 | NQ | Futures | 15237.61 | 15291.54 | 15199.33 | 15226.01 | 18123.0 |
| 2022-04-27 05:00:00 | NQ | Futures | 15225.43 | 15255.59 | 15212.09 | 15245.73 | 8640.0 |
| 2022-04-27 06:00:00 | NQ | Futures | 15246.02 | 15264.58 | 15197.88 | 15248.63 | 11604.0 |
| 2022-04-27 07:00:00 | NQ | Futures | 15247.76 | 15248.34 | 15095.81 | 15125.1 | 19554.0 |
| 2022-04-27 08:00:00 | NQ | Futures | 15125.39 | 15175.26 | 15099.87 | 15125.39 | 22526.0 |
| 2022-04-27 09:00:00 | NQ | Futures | 15125.1 | 15374.77 | 15069.42 | 15283.42 | 111459.0 |
| 2022-04-27 10:00:00 | NQ | Futures | 15284.0 | 15337.36 | 14997.8 | 15133.22 | 136696.0 |
| 2022-04-27 11:00:00 | NQ | Futures | 15133.8 | 15270.96 | 15131.77 | 15178.74 | 82847.0 |
| 2022-04-27 12:00:00 | NQ | Futures | 15179.03 | 15347.22 | 15124.52 | 15296.76 | 60025.0 |
| 2022-04-27 13:00:00 | NQ | Futures | 15297.34 | 15317.64 | 15176.71 | 15275.31 | 70724.0 |
| 2022-04-27 14:00:00 | NQ | Futures | 15274.44 | 15283.42 | 15117.56 | 15134.67 | 52086.0 |
| 2022-04-27 15:00:00 | NQ | Futures | 15135.25 | 15152.94 | 15052.02 | 15080.73 | 79482.0 |
| 2022-04-27 16:00:00 | NQ | Futures | 15081.6 | 15299.08 | 15060.72 | 15274.15 | 38725.0 |
| 2022-04-27 18:00:00 | NQ | Futures | 15300.24 | 15306.33 | 15257.33 | 15267.77 | 5016.0 |
| 2022-04-27 19:00:00 | NQ | Futures | 15267.77 | 15290.09 | 15259.36 | 15278.5 | 3233.0 |
| 2022-04-27 20:00:00 | NQ | Futures | 15280.24 | 15280.24 | 15241.96 | 15268.06 | 3643.0 |
| 2022-04-27 21:00:00 | NQ | Futures | 15269.22 | 15279.95 | 15232.68 | 15256.46 | 3414.0 |
| 2022-04-27 22:00:00 | NQ | Futures | 15256.46 | 15302.27 | 15251.53 | 15288.64 | 3772.0 |
| 2022-04-27 23:00:00 | NQ | Futures | 15288.93 | 15300.24 | 15270.38 | 15286.61 | 2951.0 |
| 2022-04-27 00:00:00 | YM | Futures | 37637.1 | 37654.0 | 37617.9 | 37646.1 | 1006.0 |
| 2022-04-27 01:00:00 | YM | Futures | 37650.6 | 37691.2 | 37623.5 | 37642.7 | 2092.0 |
| 2022-04-27 02:00:00 | YM | Futures | 37642.7 | 37692.3 | 37602.1 | 37670.9 | 2836.0 |
| 2022-04-27 03:00:00 | YM | Futures | 37674.3 | 37779.1 | 37400.3 | 37758.8 | 11522.0 |
> showing 50 of 2,086 rows — these rows as CSV