PREVIEW / stock_30min / 2024-03-07
file: by_date/stock_30min/2024/2024-03-07.parquet size: 2.1 MB rows: 101,998 symbols: 1,108
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-03-07 04:00:00 | AAPL | Stock | 168.19 | 168.76 | 167.9 | 168.5 | 21091.0 |
| 2024-03-07 04:30:00 | AAPL | Stock | 168.5 | 168.69 | 168.22 | 168.49 | 8661.0 |
| 2024-03-07 05:00:00 | AAPL | Stock | 168.65 | 169.0 | 168.65 | 168.97 | 34980.0 |
| 2024-03-07 05:30:00 | AAPL | Stock | 168.98 | 169.1 | 168.96 | 169.03 | 18364.0 |
| 2024-03-07 06:00:00 | AAPL | Stock | 169.0 | 169.0 | 168.7 | 168.87 | 6032.0 |
| 2024-03-07 06:30:00 | AAPL | Stock | 168.83 | 168.9 | 168.8 | 168.83 | 14001.0 |
| 2024-03-07 07:00:00 | AAPL | Stock | 168.83 | 169.92 | 168.75 | 169.75 | 68610.0 |
| 2024-03-07 07:30:00 | AAPL | Stock | 169.73 | 169.89 | 169.61 | 169.79 | 59442.0 |
| 2024-03-07 08:00:00 | AAPL | Stock | 168.83 | 169.91 | 167.35 | 169.83 | 177091.0 |
| 2024-03-07 08:30:00 | AAPL | Stock | 169.8 | 170.0 | 169.68 | 169.855 | 84074.0 |
| 2024-03-07 09:00:00 | AAPL | Stock | 169.9 | 169.99 | 168.78 | 169.09 | 239568.0 |
| 2024-03-07 09:30:00 | AAPL | Stock | 169.12 | 169.78 | 168.49 | 169.7225 | 8384499.0 |
| 2024-03-07 10:00:00 | AAPL | Stock | 169.727 | 169.73 | 168.9 | 168.97 | 3247272.0 |
| 2024-03-07 10:30:00 | AAPL | Stock | 168.98 | 169.08 | 168.61 | 168.78 | 3400835.0 |
| 2024-03-07 11:00:00 | AAPL | Stock | 168.775 | 169.53 | 168.62 | 169.28 | 3497707.0 |
| 2024-03-07 11:30:00 | AAPL | Stock | 169.29 | 169.39 | 168.92 | 169.22 | 2417737.0 |
| 2024-03-07 12:00:00 | AAPL | Stock | 169.225 | 169.6 | 168.9917 | 169.16 | 3016264.0 |
| 2024-03-07 12:30:00 | AAPL | Stock | 169.17 | 169.38 | 169.01 | 169.115 | 2214005.0 |
| 2024-03-07 13:00:00 | AAPL | Stock | 169.11 | 169.65 | 168.99 | 169.625 | 2655993.0 |
| 2024-03-07 13:30:00 | AAPL | Stock | 169.63 | 170.6 | 169.55 | 170.56 | 4553359.0 |
| 2024-03-07 14:00:00 | AAPL | Stock | 170.57 | 170.73 | 169.77 | 170.1 | 3566734.0 |
| 2024-03-07 14:30:00 | AAPL | Stock | 170.09 | 170.44 | 170.065 | 170.2399 | 2342419.0 |
| 2024-03-07 15:00:00 | AAPL | Stock | 170.235 | 170.235 | 169.6005 | 169.6101 | 2985196.0 |
| 2024-03-07 15:30:00 | AAPL | Stock | 169.615 | 169.66 | 168.9 | 168.98 | 6238634.0 |
| 2024-03-07 16:00:00 | AAPL | Stock | 168.985 | 169.02 | 168.5 | 168.81 | 6370233.0 |
| 2024-03-07 16:30:00 | AAPL | Stock | 168.81 | 169.0 | 168.73 | 168.78 | 88990.0 |
| 2024-03-07 17:00:00 | AAPL | Stock | 168.78 | 168.8432 | 168.7 | 168.79 | 53404.0 |
| 2024-03-07 17:30:00 | AAPL | Stock | 168.8 | 169.0 | 168.66 | 168.76 | 42159.0 |
| 2024-03-07 18:00:00 | AAPL | Stock | 168.75 | 168.84 | 168.5322 | 168.68 | 29321.0 |
| 2024-03-07 18:30:00 | AAPL | Stock | 168.7 | 169.0 | 168.62 | 168.7 | 212533.0 |
| 2024-03-07 19:00:00 | AAPL | Stock | 168.73 | 168.95 | 168.6997 | 168.8 | 19111.0 |
| 2024-03-07 19:30:00 | AAPL | Stock | 168.83 | 168.96 | 168.67 | 168.96 | 44315.0 |
| 2024-03-07 04:00:00 | MSFT | Stock | 401.4 | 403.76 | 401.22 | 403.59 | 3971.0 |
| 2024-03-07 04:30:00 | MSFT | Stock | 403.77 | 404.55 | 403.77 | 404.36 | 6889.0 |
| 2024-03-07 05:00:00 | MSFT | Stock | 404.37 | 405.0 | 404.36 | 405.0 | 5247.0 |
| 2024-03-07 05:30:00 | MSFT | Stock | 405.09 | 405.69 | 404.61 | 405.69 | 3822.0 |
| 2024-03-07 06:00:00 | MSFT | Stock | 405.85 | 406.5 | 405.44 | 405.5 | 8408.0 |
| 2024-03-07 06:30:00 | MSFT | Stock | 405.51 | 405.82 | 405.5 | 405.59 | 2648.0 |
| 2024-03-07 07:00:00 | MSFT | Stock | 405.59 | 405.68 | 404.3 | 405.1 | 13596.0 |
| 2024-03-07 07:30:00 | MSFT | Stock | 405.1 | 405.2 | 404.81 | 404.9 | 10381.0 |
| 2024-03-07 08:00:00 | MSFT | Stock | 405.2 | 405.5 | 399.6 | 404.9477 | 35933.0 |
| 2024-03-07 08:30:00 | MSFT | Stock | 405.0 | 406.15 | 405.0 | 405.75 | 26815.0 |
| 2024-03-07 09:00:00 | MSFT | Stock | 405.78 | 406.48 | 404.5 | 406.23 | 36022.0 |
| 2024-03-07 09:30:00 | MSFT | Stock | 406.34 | 406.76 | 402.24 | 404.3199 | 1959423.0 |
| 2024-03-07 10:00:00 | MSFT | Stock | 404.32 | 406.43 | 403.9 | 406.43 | 1147430.0 |
| 2024-03-07 10:30:00 | MSFT | Stock | 406.49 | 408.21 | 405.7294 | 407.57 | 966838.0 |
| 2024-03-07 11:00:00 | MSFT | Stock | 407.54 | 408.33 | 406.87 | 408.0129 | 542588.0 |
| 2024-03-07 11:30:00 | MSFT | Stock | 408.01 | 408.56 | 407.5 | 408.02 | 502374.0 |
| 2024-03-07 12:00:00 | MSFT | Stock | 408.03 | 408.81 | 407.76 | 408.15 | 421963.0 |
| 2024-03-07 12:30:00 | MSFT | Stock | 408.13 | 408.81 | 407.92 | 408.21 | 434415.0 |
> showing 50 of 101,998 rows — these rows as CSV