PREVIEW / stock_30min / 2024-02-16
file: by_date/stock_30min/2024/2024-02-16.parquet size: 2.1 MB rows: 101,387 symbols: 1,116
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-16 04:00:00 | AAPL | Stock | 184.69 | 184.87 | 184.42 | 184.71 | 15173.0 |
| 2024-02-16 04:30:00 | AAPL | Stock | 184.7 | 184.75 | 184.7 | 184.7 | 7499.0 |
| 2024-02-16 05:00:00 | AAPL | Stock | 184.74 | 185.19 | 184.74 | 185.19 | 14116.0 |
| 2024-02-16 05:30:00 | AAPL | Stock | 185.13 | 185.4 | 185.13 | 185.25 | 8778.0 |
| 2024-02-16 06:00:00 | AAPL | Stock | 185.25 | 185.33 | 184.6 | 184.6 | 20137.0 |
| 2024-02-16 06:30:00 | AAPL | Stock | 184.6 | 184.7 | 184.41 | 184.53 | 21969.0 |
| 2024-02-16 07:00:00 | AAPL | Stock | 184.55 | 184.55 | 184.0 | 184.32 | 41892.0 |
| 2024-02-16 07:30:00 | AAPL | Stock | 184.28 | 184.3 | 184.01 | 184.01 | 19747.0 |
| 2024-02-16 08:00:00 | AAPL | Stock | 184.17 | 184.55 | 182.8219 | 183.51 | 167966.0 |
| 2024-02-16 08:30:00 | AAPL | Stock | 183.46 | 183.4663 | 182.52 | 182.99 | 321645.0 |
| 2024-02-16 09:00:00 | AAPL | Stock | 182.95 | 183.64 | 182.76 | 183.42 | 213724.0 |
| 2024-02-16 09:30:00 | AAPL | Stock | 183.42 | 184.85 | 182.27 | 182.3 | 6633009.0 |
| 2024-02-16 10:00:00 | AAPL | Stock | 182.3 | 182.69 | 181.86 | 182.545 | 4044424.0 |
| 2024-02-16 10:30:00 | AAPL | Stock | 182.55 | 183.36 | 182.42 | 183.0599 | 2909147.0 |
| 2024-02-16 11:00:00 | AAPL | Stock | 183.06 | 183.4473 | 182.84 | 183.15 | 1883167.0 |
| 2024-02-16 11:30:00 | AAPL | Stock | 183.155 | 183.29 | 182.85 | 183.1 | 1532083.0 |
| 2024-02-16 12:00:00 | AAPL | Stock | 183.09 | 183.15 | 182.72 | 182.9401 | 1305177.0 |
| 2024-02-16 12:30:00 | AAPL | Stock | 182.95 | 183.01 | 182.635 | 182.74 | 1085009.0 |
| 2024-02-16 13:00:00 | AAPL | Stock | 182.7314 | 182.82 | 182.48 | 182.65 | 1478367.0 |
| 2024-02-16 13:30:00 | AAPL | Stock | 182.657 | 182.91 | 182.485 | 182.8972 | 1566557.0 |
| 2024-02-16 14:00:00 | AAPL | Stock | 182.9 | 183.18 | 182.9 | 183.143 | 1303440.0 |
| 2024-02-16 14:30:00 | AAPL | Stock | 183.1488 | 183.1975 | 182.03 | 182.1999 | 1968298.0 |
| 2024-02-16 15:00:00 | AAPL | Stock | 182.19 | 182.42 | 182.08 | 182.256 | 1699556.0 |
| 2024-02-16 15:30:00 | AAPL | Stock | 182.26 | 182.31 | 181.665 | 182.29 | 4236993.0 |
| 2024-02-16 16:00:00 | AAPL | Stock | 182.31 | 182.31 | 181.9605 | 182.12 | 6613100.0 |
| 2024-02-16 16:30:00 | AAPL | Stock | 182.13 | 182.31 | 182.06 | 182.13 | 61253.0 |
| 2024-02-16 17:00:00 | AAPL | Stock | 182.1393 | 182.18 | 182.1014 | 182.12 | 23675.0 |
| 2024-02-16 17:30:00 | AAPL | Stock | 182.11 | 182.19 | 182.08 | 182.0817 | 7546.0 |
| 2024-02-16 18:00:00 | AAPL | Stock | 182.11 | 182.14 | 182.08 | 182.12 | 3624.0 |
| 2024-02-16 18:30:00 | AAPL | Stock | 182.12 | 182.18 | 182.0315 | 182.05 | 12409.0 |
| 2024-02-16 19:00:00 | AAPL | Stock | 182.06 | 182.09 | 182.05 | 182.06 | 7085.0 |
| 2024-02-16 19:30:00 | AAPL | Stock | 182.07 | 182.1 | 181.91 | 181.95 | 13031.0 |
| 2024-02-16 04:00:00 | MSFT | Stock | 408.8 | 408.8 | 407.56 | 408.5 | 7292.0 |
| 2024-02-16 04:30:00 | MSFT | Stock | 408.55 | 408.55 | 408.4 | 408.46 | 1638.0 |
| 2024-02-16 05:00:00 | MSFT | Stock | 408.49 | 408.52 | 408.17 | 408.44 | 3142.0 |
| 2024-02-16 05:30:00 | MSFT | Stock | 408.41 | 408.6 | 408.41 | 408.5 | 3492.0 |
| 2024-02-16 06:00:00 | MSFT | Stock | 408.47 | 408.54 | 408.4 | 408.4 | 1745.0 |
| 2024-02-16 06:30:00 | MSFT | Stock | 408.36 | 408.55 | 408.33 | 408.55 | 1737.0 |
| 2024-02-16 07:00:00 | MSFT | Stock | 408.55 | 408.6 | 407.13 | 407.82 | 29913.0 |
| 2024-02-16 07:30:00 | MSFT | Stock | 407.8 | 408.32 | 407.49 | 408.1 | 13733.0 |
| 2024-02-16 08:00:00 | MSFT | Stock | 408.46 | 408.6 | 407.35 | 407.69 | 58403.0 |
| 2024-02-16 08:30:00 | MSFT | Stock | 407.7 | 407.7 | 406.06 | 406.9 | 49896.0 |
| 2024-02-16 09:00:00 | MSFT | Stock | 406.87 | 408.35 | 406.61 | 407.87 | 55305.0 |
| 2024-02-16 09:30:00 | MSFT | Stock | 407.87 | 408.29 | 403.53 | 404.68 | 2834473.0 |
| 2024-02-16 10:00:00 | MSFT | Stock | 404.63 | 405.3 | 403.57 | 404.74 | 991024.0 |
| 2024-02-16 10:30:00 | MSFT | Stock | 404.74 | 405.76 | 404.13 | 405.66 | 675757.0 |
| 2024-02-16 11:00:00 | MSFT | Stock | 405.67 | 406.52 | 405.5074 | 405.7409 | 544934.0 |
| 2024-02-16 11:30:00 | MSFT | Stock | 405.78 | 406.35 | 405.16 | 405.99 | 439568.0 |
| 2024-02-16 12:00:00 | MSFT | Stock | 405.97 | 406.2 | 405.5796 | 406.07 | 307377.0 |
| 2024-02-16 12:30:00 | MSFT | Stock | 406.06 | 406.205 | 405.48 | 405.7295 | 344331.0 |
> showing 50 of 101,387 rows — these rows as CSV