PREVIEW / futures_1hour / 2010-02-12
file: by_date/futures_1hour/2010/2010-02-12.parquet size: 38 KB rows: 1,104
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-12 00:00:00 | ES | Futures | 1046.5 | 1048.69 | 1046.5 | 1048.2 | 4864.0 |
| 2010-02-12 01:00:00 | ES | Futures | 1048.2 | 1049.42 | 1047.72 | 1048.69 | 2980.0 |
| 2010-02-12 02:00:00 | ES | Futures | 1048.69 | 1048.93 | 1046.26 | 1046.5 | 9757.0 |
| 2010-02-12 03:00:00 | ES | Futures | 1046.26 | 1049.18 | 1045.28 | 1046.26 | 35388.0 |
| 2010-02-12 04:00:00 | ES | Futures | 1046.01 | 1047.47 | 1042.85 | 1042.85 | 28014.0 |
| 2010-02-12 05:00:00 | ES | Futures | 1043.09 | 1043.09 | 1037.5 | 1039.93 | 72344.0 |
| 2010-02-12 06:00:00 | ES | Futures | 1039.93 | 1041.63 | 1037.5 | 1040.42 | 32228.0 |
| 2010-02-12 07:00:00 | ES | Futures | 1040.42 | 1041.39 | 1039.2 | 1039.69 | 28462.0 |
| 2010-02-12 08:00:00 | ES | Futures | 1039.93 | 1043.09 | 1038.47 | 1040.9 | 96319.0 |
| 2010-02-12 09:00:00 | ES | Futures | 1041.15 | 1041.63 | 1031.42 | 1035.55 | 375732.0 |
| 2010-02-12 10:00:00 | ES | Futures | 1035.31 | 1038.47 | 1031.42 | 1035.55 | 371488.0 |
| 2010-02-12 11:00:00 | ES | Futures | 1035.55 | 1038.96 | 1033.85 | 1037.5 | 176404.0 |
| 2010-02-12 12:00:00 | ES | Futures | 1037.5 | 1046.01 | 1037.5 | 1043.34 | 332961.0 |
| 2010-02-12 13:00:00 | ES | Futures | 1043.34 | 1043.34 | 1036.77 | 1039.69 | 253359.0 |
| 2010-02-12 14:00:00 | ES | Futures | 1039.69 | 1046.99 | 1038.96 | 1042.36 | 304669.0 |
| 2010-02-12 15:00:00 | ES | Futures | 1042.61 | 1046.99 | 1039.2 | 1046.26 | 425775.0 |
| 2010-02-12 16:00:00 | ES | Futures | 1046.26 | 1050.39 | 1045.77 | 1050.39 | 158514.0 |
| 2010-02-12 00:00:00 | NQ | Futures | 2024.82 | 2028.54 | 2024.54 | 2027.97 | 386.0 |
| 2010-02-12 01:00:00 | NQ | Futures | 2027.97 | 2029.11 | 2027.11 | 2028.54 | 134.0 |
| 2010-02-12 02:00:00 | NQ | Futures | 2028.82 | 2028.82 | 2024.82 | 2024.82 | 725.0 |
| 2010-02-12 03:00:00 | NQ | Futures | 2025.11 | 2028.54 | 2022.54 | 2023.68 | 2575.0 |
| 2010-02-12 04:00:00 | NQ | Futures | 2024.25 | 2026.54 | 2017.97 | 2018.54 | 1645.0 |
| 2010-02-12 05:00:00 | NQ | Futures | 2018.54 | 2019.4 | 2009.97 | 2011.97 | 5436.0 |
| 2010-02-12 06:00:00 | NQ | Futures | 2012.26 | 2013.97 | 2008.83 | 2012.26 | 2327.0 |
| 2010-02-12 07:00:00 | NQ | Futures | 2012.83 | 2015.4 | 2011.69 | 2013.69 | 1899.0 |
| 2010-02-12 08:00:00 | NQ | Futures | 2013.69 | 2018.83 | 2012.26 | 2015.97 | 5992.0 |
| 2010-02-12 09:00:00 | NQ | Futures | 2016.26 | 2016.83 | 2003.97 | 2011.97 | 52710.0 |
| 2010-02-12 10:00:00 | NQ | Futures | 2011.97 | 2017.4 | 2004.55 | 2010.54 | 58620.0 |
| 2010-02-12 11:00:00 | NQ | Futures | 2010.54 | 2019.68 | 2008.26 | 2018.83 | 28483.0 |
| 2010-02-12 12:00:00 | NQ | Futures | 2018.83 | 2034.54 | 2018.83 | 2030.54 | 44472.0 |
| 2010-02-12 13:00:00 | NQ | Futures | 2030.54 | 2030.54 | 2018.54 | 2024.54 | 32217.0 |
| 2010-02-12 14:00:00 | NQ | Futures | 2024.25 | 2036.25 | 2023.11 | 2029.97 | 33978.0 |
| 2010-02-12 15:00:00 | NQ | Futures | 2029.97 | 2033.11 | 2024.25 | 2031.11 | 43678.0 |
| 2010-02-12 16:00:00 | NQ | Futures | 2031.11 | 2037.68 | 2030.25 | 2037.39 | 10593.0 |
| 2010-02-12 00:00:00 | YM | Futures | 9451.7 | 9467.6 | 9449.8 | 9465.7 | 313.0 |
| 2010-02-12 01:00:00 | YM | Futures | 9466.7 | 9472.3 | 9459.2 | 9470.4 | 330.0 |
| 2010-02-12 02:00:00 | YM | Futures | 9470.4 | 9470.4 | 9450.8 | 9450.8 | 831.0 |
| 2010-02-12 03:00:00 | YM | Futures | 9450.8 | 9472.3 | 9443.3 | 9450.8 | 1767.0 |
| 2010-02-12 04:00:00 | YM | Futures | 9451.7 | 9461.1 | 9427.4 | 9427.4 | 960.0 |
| 2010-02-12 05:00:00 | YM | Futures | 9426.4 | 9426.4 | 9383.4 | 9401.2 | 3401.0 |
| 2010-02-12 06:00:00 | YM | Futures | 9401.2 | 9412.4 | 9386.2 | 9404.0 | 1036.0 |
| 2010-02-12 07:00:00 | YM | Futures | 9405.8 | 9412.4 | 9394.6 | 9402.1 | 773.0 |
| 2010-02-12 08:00:00 | YM | Futures | 9402.1 | 9418.9 | 9389.9 | 9404.9 | 4922.0 |
| 2010-02-12 09:00:00 | YM | Futures | 9404.9 | 9410.5 | 9321.6 | 9346.9 | 25298.0 |
| 2010-02-12 10:00:00 | YM | Futures | 9346.9 | 9365.6 | 9312.3 | 9346.9 | 25742.0 |
| 2010-02-12 11:00:00 | YM | Futures | 9346.0 | 9372.2 | 9332.8 | 9363.7 | 11318.0 |
| 2010-02-12 12:00:00 | YM | Futures | 9364.7 | 9439.5 | 9364.7 | 9417.1 | 19718.0 |
| 2010-02-12 13:00:00 | YM | Futures | 9417.1 | 9418.9 | 9357.2 | 9381.5 | 16453.0 |
| 2010-02-12 14:00:00 | YM | Futures | 9381.5 | 9444.2 | 9375.9 | 9407.7 | 17767.0 |
| 2010-02-12 15:00:00 | YM | Futures | 9406.8 | 9437.7 | 9373.1 | 9437.7 | 21016.0 |
> showing 50 of 1,104 rows — these rows as CSV