PREVIEW / futures_1hour / 2021-10-14
file: by_date/futures_1hour/2021/2021-10-14.parquet size: 66 KB rows: 2,009
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-10-14 00:00:00 | ES | Futures | 4932.23 | 4933.35 | 4930.82 | 4932.51 | 2839.0 |
| 2021-10-14 01:00:00 | ES | Futures | 4932.23 | 4938.15 | 4930.25 | 4937.87 | 6930.0 |
| 2021-10-14 02:00:00 | ES | Futures | 4938.15 | 4946.9 | 4933.07 | 4945.77 | 17493.0 |
| 2021-10-14 03:00:00 | ES | Futures | 4945.77 | 4945.77 | 4936.46 | 4943.8 | 23358.0 |
| 2021-10-14 04:00:00 | ES | Futures | 4943.8 | 4950.85 | 4943.8 | 4948.31 | 17810.0 |
| 2021-10-14 05:00:00 | ES | Futures | 4948.31 | 4952.26 | 4948.03 | 4950.01 | 12085.0 |
| 2021-10-14 06:00:00 | ES | Futures | 4950.01 | 4950.57 | 4945.49 | 4948.31 | 14403.0 |
| 2021-10-14 07:00:00 | ES | Futures | 4948.59 | 4960.17 | 4947.47 | 4958.75 | 20240.0 |
| 2021-10-14 08:00:00 | ES | Futures | 4959.04 | 4965.81 | 4959.04 | 4960.73 | 50192.0 |
| 2021-10-14 09:00:00 | ES | Futures | 4960.73 | 4970.04 | 4955.65 | 4966.94 | 186299.0 |
| 2021-10-14 10:00:00 | ES | Futures | 4966.94 | 4985.85 | 4966.66 | 4985.28 | 187815.0 |
| 2021-10-14 11:00:00 | ES | Futures | 4985.56 | 4992.06 | 4980.48 | 4991.77 | 107810.0 |
| 2021-10-14 12:00:00 | ES | Futures | 4991.49 | 4996.57 | 4990.93 | 4995.72 | 81094.0 |
| 2021-10-14 13:00:00 | ES | Futures | 4995.72 | 4999.39 | 4989.52 | 4997.7 | 74168.0 |
| 2021-10-14 14:00:00 | ES | Futures | 4997.7 | 5001.09 | 4994.6 | 4999.96 | 76971.0 |
| 2021-10-14 15:00:00 | ES | Futures | 4999.96 | 5001.93 | 4990.36 | 4999.67 | 237746.0 |
| 2021-10-14 16:00:00 | ES | Futures | 4999.39 | 5008.99 | 4998.26 | 5007.01 | 62610.0 |
| 2021-10-14 18:00:00 | ES | Futures | 5004.19 | 5009.27 | 5003.34 | 5007.86 | 5455.0 |
| 2021-10-14 19:00:00 | ES | Futures | 5008.14 | 5010.12 | 5007.29 | 5008.14 | 4427.0 |
| 2021-10-14 20:00:00 | ES | Futures | 5008.14 | 5008.14 | 4998.83 | 5004.19 | 10978.0 |
| 2021-10-14 21:00:00 | ES | Futures | 5004.19 | 5007.29 | 4996.57 | 5006.45 | 12317.0 |
| 2021-10-14 22:00:00 | ES | Futures | 5006.45 | 5018.3 | 5006.17 | 5016.33 | 14799.0 |
| 2021-10-14 23:00:00 | ES | Futures | 5016.61 | 5016.89 | 5013.22 | 5015.48 | 3618.0 |
| 2021-10-14 00:00:00 | NQ | Futures | 17182.39 | 17185.58 | 17176.3 | 17181.81 | 1381.0 |
| 2021-10-14 01:00:00 | NQ | Futures | 17183.55 | 17217.46 | 17176.59 | 17217.46 | 3710.0 |
| 2021-10-14 02:00:00 | NQ | Futures | 17216.3 | 17248.76 | 17195.14 | 17246.15 | 7291.0 |
| 2021-10-14 03:00:00 | NQ | Futures | 17246.15 | 17249.92 | 17213.4 | 17242.67 | 8908.0 |
| 2021-10-14 04:00:00 | NQ | Futures | 17242.38 | 17267.89 | 17239.19 | 17259.19 | 8262.0 |
| 2021-10-14 05:00:00 | NQ | Futures | 17260.06 | 17269.62 | 17251.37 | 17253.97 | 4870.0 |
| 2021-10-14 06:00:00 | NQ | Futures | 17253.68 | 17256.58 | 17237.17 | 17238.61 | 5001.0 |
| 2021-10-14 07:00:00 | NQ | Futures | 17239.19 | 17291.36 | 17238.32 | 17283.25 | 8707.0 |
| 2021-10-14 08:00:00 | NQ | Futures | 17283.83 | 17329.33 | 17281.51 | 17297.16 | 20378.0 |
| 2021-10-14 09:00:00 | NQ | Futures | 17296.58 | 17339.76 | 17262.09 | 17325.27 | 83140.0 |
| 2021-10-14 10:00:00 | NQ | Futures | 17325.27 | 17386.71 | 17317.15 | 17370.19 | 68822.0 |
| 2021-10-14 11:00:00 | NQ | Futures | 17370.19 | 17410.77 | 17358.02 | 17410.19 | 39850.0 |
| 2021-10-14 12:00:00 | NQ | Futures | 17410.19 | 17440.91 | 17406.42 | 17433.37 | 28856.0 |
| 2021-10-14 13:00:00 | NQ | Futures | 17433.66 | 17435.98 | 17408.45 | 17429.6 | 20777.0 |
| 2021-10-14 14:00:00 | NQ | Futures | 17429.31 | 17440.33 | 17416.27 | 17434.53 | 18002.0 |
| 2021-10-14 15:00:00 | NQ | Futures | 17434.82 | 17445.54 | 17402.94 | 17431.92 | 56353.0 |
| 2021-10-14 16:00:00 | NQ | Futures | 17431.92 | 17471.92 | 17428.73 | 17464.38 | 12983.0 |
| 2021-10-14 18:00:00 | NQ | Futures | 17462.93 | 17470.47 | 17453.37 | 17464.09 | 3125.0 |
| 2021-10-14 19:00:00 | NQ | Futures | 17464.67 | 17478.87 | 17462.06 | 17471.92 | 3089.0 |
| 2021-10-14 20:00:00 | NQ | Futures | 17470.47 | 17471.05 | 17424.97 | 17440.04 | 7859.0 |
| 2021-10-14 21:00:00 | NQ | Futures | 17440.62 | 17457.14 | 17413.08 | 17453.66 | 7083.0 |
| 2021-10-14 22:00:00 | NQ | Futures | 17453.95 | 17502.06 | 17451.63 | 17491.33 | 7524.0 |
| 2021-10-14 23:00:00 | NQ | Futures | 17491.91 | 17493.36 | 17477.13 | 17487.86 | 2690.0 |
| 2021-10-14 00:00:00 | YM | Futures | 38516.6 | 38524.5 | 38506.5 | 38516.6 | 398.0 |
| 2021-10-14 01:00:00 | YM | Futures | 38517.7 | 38553.6 | 38495.3 | 38553.6 | 1077.0 |
| 2021-10-14 02:00:00 | YM | Futures | 38552.5 | 38619.7 | 38509.9 | 38596.2 | 4312.0 |
| 2021-10-14 03:00:00 | YM | Futures | 38596.2 | 38597.3 | 38531.2 | 38574.9 | 4045.0 |
> showing 50 of 2,009 rows — these rows as CSV