PREVIEW / stock_30min / 2024-03-06
file: by_date/stock_30min/2024/2024-03-06.parquet size: 2.1 MB rows: 102,720 symbols: 1,120
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-06 04:00:00 | AAPL | Stock | 170.12 | 172.0 | 169.63 | 170.99 | 32129.0 |
| 2024-03-06 04:30:00 | AAPL | Stock | 170.9 | 171.14 | 170.9 | 170.99 | 11767.0 |
| 2024-03-06 05:00:00 | AAPL | Stock | 171.05 | 171.38 | 171.03 | 171.3 | 9954.0 |
| 2024-03-06 05:30:00 | AAPL | Stock | 171.26 | 171.26 | 170.89 | 171.04 | 10879.0 |
| 2024-03-06 06:00:00 | AAPL | Stock | 170.99 | 171.3 | 170.88 | 171.23 | 14957.0 |
| 2024-03-06 06:30:00 | AAPL | Stock | 171.21 | 171.27 | 170.75 | 170.81 | 7634.0 |
| 2024-03-06 07:00:00 | AAPL | Stock | 170.86 | 170.88 | 170.38 | 170.49 | 42958.0 |
| 2024-03-06 07:30:00 | AAPL | Stock | 170.51 | 170.88 | 170.51 | 170.82 | 24159.0 |
| 2024-03-06 08:00:00 | AAPL | Stock | 170.69 | 171.3 | 169.93 | 171.05 | 214551.0 |
| 2024-03-06 08:30:00 | AAPL | Stock | 171.0 | 171.6396 | 171.0 | 171.63 | 136881.0 |
| 2024-03-06 09:00:00 | AAPL | Stock | 171.64 | 171.75 | 170.9997 | 171.09 | 235923.0 |
| 2024-03-06 09:30:00 | AAPL | Stock | 171.11 | 171.24 | 168.93 | 169.8 | 10148520.0 |
| 2024-03-06 10:00:00 | AAPL | Stock | 169.805 | 169.82 | 168.98 | 169.58 | 4267444.0 |
| 2024-03-06 10:30:00 | AAPL | Stock | 169.59 | 170.05 | 169.27 | 169.545 | 3425537.0 |
| 2024-03-06 11:00:00 | AAPL | Stock | 169.55 | 170.01 | 169.315 | 169.78 | 2606494.0 |
| 2024-03-06 11:30:00 | AAPL | Stock | 169.775 | 169.8619 | 169.335 | 169.745 | 2916822.0 |
| 2024-03-06 12:00:00 | AAPL | Stock | 169.75 | 170.3 | 169.7 | 170.1799 | 2909130.0 |
| 2024-03-06 12:30:00 | AAPL | Stock | 170.175 | 170.35 | 169.91 | 170.1209 | 2272484.0 |
| 2024-03-06 13:00:00 | AAPL | Stock | 170.125 | 170.225 | 169.94 | 169.9915 | 1753124.0 |
| 2024-03-06 13:30:00 | AAPL | Stock | 169.995 | 170.045 | 169.04 | 169.38 | 2968831.0 |
| 2024-03-06 14:00:00 | AAPL | Stock | 169.38 | 169.5 | 168.68 | 169.11 | 2998937.0 |
| 2024-03-06 14:30:00 | AAPL | Stock | 169.11 | 169.24 | 168.69 | 168.84 | 2444645.0 |
| 2024-03-06 15:00:00 | AAPL | Stock | 168.83 | 169.08 | 168.75 | 169.0 | 2345526.0 |
| 2024-03-06 15:30:00 | AAPL | Stock | 169.01 | 169.4 | 168.87 | 169.12 | 4759218.0 |
| 2024-03-06 16:00:00 | AAPL | Stock | 169.12 | 169.24 | 169.01 | 169.07 | 5441177.0 |
| 2024-03-06 16:30:00 | AAPL | Stock | 169.09 | 169.09 | 168.81 | 168.87 | 39928.0 |
| 2024-03-06 17:00:00 | AAPL | Stock | 168.87 | 169.12 | 168.87 | 169.0 | 92944.0 |
| 2024-03-06 17:30:00 | AAPL | Stock | 168.97 | 169.08 | 168.97 | 169.0678 | 10995.0 |
| 2024-03-06 18:00:00 | AAPL | Stock | 169.05 | 169.12 | 168.88 | 168.96 | 51520.0 |
| 2024-03-06 18:30:00 | AAPL | Stock | 168.96 | 168.99 | 168.8011 | 168.82 | 14222.0 |
| 2024-03-06 19:00:00 | AAPL | Stock | 168.85 | 168.91 | 168.6 | 168.68 | 16218.0 |
| 2024-03-06 19:30:00 | AAPL | Stock | 168.63 | 168.67 | 168.45 | 168.45 | 29867.0 |
| 2024-03-06 04:00:00 | MSFT | Stock | 404.48 | 406.35 | 404.31 | 405.01 | 10400.0 |
| 2024-03-06 04:30:00 | MSFT | Stock | 405.0 | 405.11 | 404.75 | 405.11 | 3555.0 |
| 2024-03-06 05:00:00 | MSFT | Stock | 405.67 | 406.44 | 405.67 | 405.89 | 4636.0 |
| 2024-03-06 05:30:00 | MSFT | Stock | 405.95 | 406.16 | 405.1 | 405.5 | 5110.0 |
| 2024-03-06 06:00:00 | MSFT | Stock | 405.37 | 405.37 | 404.9 | 405.02 | 1450.0 |
| 2024-03-06 06:30:00 | MSFT | Stock | 405.0 | 405.06 | 404.3 | 404.3 | 1386.0 |
| 2024-03-06 07:00:00 | MSFT | Stock | 404.95 | 405.81 | 404.56 | 405.05 | 11971.0 |
| 2024-03-06 07:30:00 | MSFT | Stock | 405.32 | 406.1 | 405.32 | 405.8 | 5575.0 |
| 2024-03-06 08:00:00 | MSFT | Stock | 404.66 | 406.5 | 403.45 | 405.75 | 48293.0 |
| 2024-03-06 08:30:00 | MSFT | Stock | 405.6 | 406.17 | 405.09 | 405.99 | 19895.0 |
| 2024-03-06 09:00:00 | MSFT | Stock | 405.96 | 405.96 | 401.6 | 402.69 | 94996.0 |
| 2024-03-06 09:30:00 | MSFT | Stock | 402.93 | 404.46 | 401.18 | 401.535 | 2262140.0 |
| 2024-03-06 10:00:00 | MSFT | Stock | 401.495 | 401.495 | 398.39 | 399.9398 | 1984755.0 |
| 2024-03-06 10:30:00 | MSFT | Stock | 399.92 | 402.8691 | 399.82 | 402.35 | 962564.0 |
| 2024-03-06 11:00:00 | MSFT | Stock | 402.35 | 403.49 | 401.93 | 403.24 | 997245.0 |
| 2024-03-06 11:30:00 | MSFT | Stock | 403.25 | 404.8862 | 402.92 | 404.6 | 921971.0 |
| 2024-03-06 12:00:00 | MSFT | Stock | 404.57 | 405.16 | 403.94 | 404.54 | 659903.0 |
| 2024-03-06 12:30:00 | MSFT | Stock | 404.53 | 404.98 | 403.56 | 403.8735 | 506039.0 |
> showing 50 of 102,720 rows — these rows as CSV