PREVIEW / stock_30min / 2005-09-28
file: by_date/stock_30min/2005/2005-09-28.parquet size: 841 KB rows: 45,844 symbols: 2,076
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-28 08:00:00 | AAPL | Stock | 1.9111 | 1.9125 | 1.9086 | 1.9086 | 745360.0 |
| 2005-09-28 08:30:00 | AAPL | Stock | 1.9107 | 1.9107 | 1.8911 | 1.8982 | 1668660.0 |
| 2005-09-28 09:00:00 | AAPL | Stock | 1.8982 | 1.9036 | 1.8875 | 1.8939 | 8974056.0 |
| 2005-09-28 09:30:00 | AAPL | Stock | 1.8954 | 1.8968 | 1.8679 | 1.8746 | 115828664.0 |
| 2005-09-28 10:00:00 | AAPL | Stock | 1.8743 | 1.8779 | 1.845 | 1.8546 | 139330268.0 |
| 2005-09-28 10:30:00 | AAPL | Stock | 1.8546 | 1.8575 | 1.8393 | 1.8554 | 88107012.0 |
| 2005-09-28 11:00:00 | AAPL | Stock | 1.8555 | 1.8654 | 1.8482 | 1.865 | 49970844.0 |
| 2005-09-28 11:30:00 | AAPL | Stock | 1.865 | 1.8679 | 1.8518 | 1.8586 | 49790944.0 |
| 2005-09-28 12:00:00 | AAPL | Stock | 1.8586 | 1.8589 | 1.8482 | 1.8539 | 27619200.0 |
| 2005-09-28 12:30:00 | AAPL | Stock | 1.8539 | 1.8589 | 1.8521 | 1.8564 | 17135076.0 |
| 2005-09-28 13:00:00 | AAPL | Stock | 1.8564 | 1.8639 | 1.8554 | 1.8596 | 26637184.0 |
| 2005-09-28 13:30:00 | AAPL | Stock | 1.8596 | 1.8632 | 1.8196 | 1.8243 | 104433812.0 |
| 2005-09-28 14:00:00 | AAPL | Stock | 1.825 | 1.8393 | 1.8107 | 1.8211 | 178025400.0 |
| 2005-09-28 14:30:00 | AAPL | Stock | 1.8211 | 1.8239 | 1.8118 | 1.8232 | 95755464.0 |
| 2005-09-28 15:00:00 | AAPL | Stock | 1.8232 | 1.8257 | 1.8068 | 1.8082 | 88575452.0 |
| 2005-09-28 15:30:00 | AAPL | Stock | 1.8082 | 1.8261 | 1.8082 | 1.8246 | 115562104.0 |
| 2005-09-28 16:00:00 | AAPL | Stock | 1.8239 | 1.8422 | 1.8236 | 1.8254 | 2490740.0 |
| 2005-09-28 16:30:00 | AAPL | Stock | 1.8257 | 1.8286 | 1.8239 | 1.8286 | 609756.0 |
| 2005-09-28 17:00:00 | AAPL | Stock | 1.8491 | 1.8491 | 1.8204 | 1.8243 | 721028.0 |
| 2005-09-28 17:30:00 | AAPL | Stock | 1.8243 | 1.8257 | 1.8225 | 1.8239 | 208460.0 |
| 2005-09-28 18:00:00 | AAPL | Stock | 1.8257 | 1.8371 | 1.8246 | 1.8339 | 1093568.0 |
| 2005-09-28 05:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.4 | 25.4 | 100.0 |
| 2005-09-28 08:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.39 | 25.39 | 8400.0 |
| 2005-09-28 08:30:00 | MSFT | Stock | 25.4 | 25.4 | 25.38 | 25.38 | 23916.0 |
| 2005-09-28 09:00:00 | MSFT | Stock | 25.38 | 25.41 | 25.37 | 25.38 | 28891.0 |
| 2005-09-28 09:30:00 | MSFT | Stock | 25.39 | 25.64 | 25.38 | 25.58 | 9194759.0 |
| 2005-09-28 10:00:00 | MSFT | Stock | 25.57 | 25.68 | 25.54 | 25.65 | 5245509.0 |
| 2005-09-28 10:30:00 | MSFT | Stock | 25.64 | 25.78 | 25.62 | 25.7 | 5757677.0 |
| 2005-09-28 11:00:00 | MSFT | Stock | 25.7 | 25.72 | 25.62 | 25.712 | 4588904.0 |
| 2005-09-28 11:30:00 | MSFT | Stock | 25.71 | 25.73 | 25.609 | 25.63 | 4206132.0 |
| 2005-09-28 12:00:00 | MSFT | Stock | 25.64 | 25.68 | 25.54 | 25.59 | 4666684.0 |
| 2005-09-28 12:30:00 | MSFT | Stock | 25.58 | 25.6 | 25.54 | 25.57 | 3892444.0 |
| 2005-09-28 13:00:00 | MSFT | Stock | 25.56 | 25.57 | 25.519 | 25.54 | 2450808.0 |
| 2005-09-28 13:30:00 | MSFT | Stock | 25.54 | 25.65 | 25.52 | 25.62 | 5060408.0 |
| 2005-09-28 14:00:00 | MSFT | Stock | 25.62 | 25.79 | 25.62 | 25.78 | 5106904.0 |
| 2005-09-28 14:30:00 | MSFT | Stock | 25.77 | 25.87 | 25.74 | 25.79 | 5451178.0 |
| 2005-09-28 15:00:00 | MSFT | Stock | 25.8 | 25.84 | 25.77 | 25.77 | 3813763.0 |
| 2005-09-28 15:30:00 | MSFT | Stock | 25.77 | 25.83 | 25.619 | 25.69 | 8091516.0 |
| 2005-09-28 16:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.39 | 25.62 | 512716.0 |
| 2005-09-28 16:30:00 | MSFT | Stock | 25.62 | 25.69 | 25.62 | 25.68 | 1494657.0 |
| 2005-09-28 17:00:00 | MSFT | Stock | 25.62 | 25.67 | 25.6 | 25.63 | 177600.0 |
| 2005-09-28 17:30:00 | MSFT | Stock | 25.67 | 25.67 | 25.6 | 25.62 | 1994.0 |
| 2005-09-28 18:00:00 | MSFT | Stock | 25.761 | 25.761 | 25.61 | 25.63 | 5783.0 |
| 2005-09-28 09:00:00 | NVDA | Stock | 0.2759 | 0.277 | 0.2757 | 0.277 | 132000.0 |
| 2005-09-28 09:30:00 | NVDA | Stock | 0.2766 | 0.2782 | 0.2761 | 0.2771 | 35781120.0 |
| 2005-09-28 10:00:00 | NVDA | Stock | 0.2772 | 0.2775 | 0.2767 | 0.2775 | 23677800.0 |
| 2005-09-28 10:30:00 | NVDA | Stock | 0.2775 | 0.2781 | 0.2769 | 0.2775 | 36238680.0 |
| 2005-09-28 11:00:00 | NVDA | Stock | 0.2775 | 0.278 | 0.2762 | 0.2765 | 30798840.0 |
| 2005-09-28 11:30:00 | NVDA | Stock | 0.2766 | 0.2774 | 0.2757 | 0.2765 | 29608200.0 |
| 2005-09-28 12:00:00 | NVDA | Stock | 0.2764 | 0.2765 | 0.2738 | 0.2747 | 22392960.0 |
> showing 50 of 45,844 rows — these rows as CSV