PREVIEW / stock_30min / 2024-05-03
file: by_date/stock_30min/2024/2024-05-03.parquet size: 2.0 MB rows: 96,884 symbols: 979
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-05-03 04:00:00 | AAPL | Stock | 183.1 | 183.33 | 182.41 | 183.2 | 140777.0 |
| 2024-05-03 04:30:00 | AAPL | Stock | 183.2 | 183.3 | 182.81 | 183.2 | 24960.0 |
| 2024-05-03 05:00:00 | AAPL | Stock | 183.2 | 183.46 | 183.11 | 183.19 | 30404.0 |
| 2024-05-03 05:30:00 | AAPL | Stock | 183.2 | 183.46 | 183.12 | 183.13 | 14352.0 |
| 2024-05-03 06:00:00 | AAPL | Stock | 183.14 | 183.35 | 183.09 | 183.35 | 29286.0 |
| 2024-05-03 06:30:00 | AAPL | Stock | 183.21 | 183.98 | 183.2 | 183.71 | 106707.0 |
| 2024-05-03 07:00:00 | AAPL | Stock | 183.71 | 184.0 | 183.55 | 183.86 | 155727.0 |
| 2024-05-03 07:30:00 | AAPL | Stock | 183.88 | 184.06 | 183.16 | 183.59 | 153001.0 |
| 2024-05-03 08:00:00 | AAPL | Stock | 183.6 | 184.68 | 181.71 | 184.4 | 699496.0 |
| 2024-05-03 08:30:00 | AAPL | Stock | 184.32 | 186.3 | 184.2 | 185.3 | 1869508.0 |
| 2024-05-03 09:00:00 | AAPL | Stock | 185.3 | 187.04 | 183.5 | 186.64 | 1853943.0 |
| 2024-05-03 09:30:00 | AAPL | Stock | 186.645 | 187.0 | 183.6 | 184.115 | 28373983.0 |
| 2024-05-03 10:00:00 | AAPL | Stock | 184.15 | 184.47 | 182.66 | 184.18 | 13131302.0 |
| 2024-05-03 10:30:00 | AAPL | Stock | 184.199 | 184.99 | 183.54 | 184.79 | 7922714.0 |
| 2024-05-03 11:00:00 | AAPL | Stock | 184.78 | 184.99 | 183.92 | 184.65 | 7054037.0 |
| 2024-05-03 11:30:00 | AAPL | Stock | 184.66 | 184.94 | 184.41 | 184.595 | 5147088.0 |
| 2024-05-03 12:00:00 | AAPL | Stock | 184.59 | 184.79 | 184.13 | 184.36 | 3590810.0 |
| 2024-05-03 12:30:00 | AAPL | Stock | 184.3599 | 184.9415 | 184.3 | 184.755 | 4401113.0 |
| 2024-05-03 13:00:00 | AAPL | Stock | 184.76 | 185.5 | 184.59 | 185.3601 | 6530025.0 |
| 2024-05-03 13:30:00 | AAPL | Stock | 185.36 | 185.4 | 184.81 | 185.055 | 4676430.0 |
| 2024-05-03 14:00:00 | AAPL | Stock | 185.045 | 185.86 | 185.04 | 185.755 | 4854499.0 |
| 2024-05-03 14:30:00 | AAPL | Stock | 185.755 | 185.99 | 185.15 | 185.355 | 5303032.0 |
| 2024-05-03 15:00:00 | AAPL | Stock | 185.355 | 185.36 | 184.26 | 184.995 | 6886399.0 |
| 2024-05-03 15:30:00 | AAPL | Stock | 185.0 | 185.01 | 183.05 | 183.39 | 12233157.0 |
| 2024-05-03 16:00:00 | AAPL | Stock | 183.36 | 184.0 | 183.08 | 183.66 | 10786745.0 |
| 2024-05-03 16:30:00 | AAPL | Stock | 183.6499 | 183.86 | 183.38 | 183.82 | 357469.0 |
| 2024-05-03 17:00:00 | AAPL | Stock | 183.82 | 183.97 | 183.73 | 183.91 | 50658.0 |
| 2024-05-03 17:30:00 | AAPL | Stock | 183.89 | 183.99 | 183.38 | 183.85 | 125163.0 |
| 2024-05-03 18:00:00 | AAPL | Stock | 183.9 | 183.917 | 183.81 | 183.8505 | 13016.0 |
| 2024-05-03 18:30:00 | AAPL | Stock | 183.8505 | 183.92 | 183.85 | 183.91 | 17645.0 |
| 2024-05-03 19:00:00 | AAPL | Stock | 183.9 | 183.92 | 183.7 | 183.79 | 22927.0 |
| 2024-05-03 19:30:00 | AAPL | Stock | 183.79 | 183.89 | 183.49 | 183.78 | 35230.0 |
| 2024-05-03 04:00:00 | MSFT | Stock | 398.99 | 399.1 | 398.76 | 398.91 | 1890.0 |
| 2024-05-03 04:30:00 | MSFT | Stock | 398.99 | 399.0 | 398.67 | 398.67 | 1056.0 |
| 2024-05-03 05:00:00 | MSFT | Stock | 398.89 | 399.2 | 398.79 | 398.79 | 807.0 |
| 2024-05-03 05:30:00 | MSFT | Stock | 399.18 | 399.2 | 399.01 | 399.1 | 669.0 |
| 2024-05-03 06:00:00 | MSFT | Stock | 399.45 | 399.7 | 399.45 | 399.7 | 542.0 |
| 2024-05-03 06:30:00 | MSFT | Stock | 399.6 | 399.65 | 399.15 | 399.5 | 2541.0 |
| 2024-05-03 07:00:00 | MSFT | Stock | 399.35 | 399.37 | 398.56 | 399.0 | 5922.0 |
| 2024-05-03 07:30:00 | MSFT | Stock | 399.15 | 399.15 | 398.6 | 398.6 | 5460.0 |
| 2024-05-03 08:00:00 | MSFT | Stock | 399.05 | 400.52 | 398.56 | 399.78 | 13981.0 |
| 2024-05-03 08:30:00 | MSFT | Stock | 399.98 | 403.45 | 399.68 | 402.0 | 48262.0 |
| 2024-05-03 09:00:00 | MSFT | Stock | 402.05 | 403.5 | 402.02 | 402.1 | 59044.0 |
| 2024-05-03 09:30:00 | MSFT | Stock | 402.56 | 406.16 | 401.86 | 405.7 | 2071763.0 |
| 2024-05-03 10:00:00 | MSFT | Stock | 405.72 | 406.58 | 403.68 | 405.7 | 1092516.0 |
| 2024-05-03 10:30:00 | MSFT | Stock | 405.71 | 406.44 | 405.23 | 405.44 | 736659.0 |
| 2024-05-03 11:00:00 | MSFT | Stock | 405.46 | 405.79 | 404.74 | 405.41 | 411465.0 |
| 2024-05-03 11:30:00 | MSFT | Stock | 405.46 | 406.68 | 405.41 | 406.03 | 568608.0 |
| 2024-05-03 12:00:00 | MSFT | Stock | 406.08 | 406.61 | 405.92 | 406.1124 | 318044.0 |
| 2024-05-03 12:30:00 | MSFT | Stock | 406.08 | 406.53 | 405.54 | 405.85 | 274762.0 |
> showing 50 of 96,884 rows — these rows as CSV