PREVIEW / stock_30min / 2024-08-07
file: by_date/stock_30min/2024/2024-08-07.parquet size: 2.0 MB rows: 99,776 symbols: 879
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-08-07 04:00:00 | AAPL | Stock | 208.3 | 208.85 | 207.12 | 208.03 | 31224.0 |
| 2024-08-07 04:30:00 | AAPL | Stock | 208.26 | 208.4 | 207.93 | 208.33 | 7498.0 |
| 2024-08-07 05:00:00 | AAPL | Stock | 208.31 | 209.39 | 208.31 | 209.35 | 16186.0 |
| 2024-08-07 05:30:00 | AAPL | Stock | 209.31 | 209.31 | 208.38 | 208.44 | 10083.0 |
| 2024-08-07 06:00:00 | AAPL | Stock | 208.5 | 208.67 | 208.24 | 208.67 | 7289.0 |
| 2024-08-07 06:30:00 | AAPL | Stock | 208.69 | 209.27 | 208.6 | 209.27 | 11261.0 |
| 2024-08-07 07:00:00 | AAPL | Stock | 208.91 | 209.35 | 208.36 | 208.41 | 54766.0 |
| 2024-08-07 07:30:00 | AAPL | Stock | 208.42 | 208.61 | 207.8 | 207.95 | 33745.0 |
| 2024-08-07 08:00:00 | AAPL | Stock | 208.8 | 209.3 | 207.6 | 207.8238 | 89618.0 |
| 2024-08-07 08:30:00 | AAPL | Stock | 207.8005 | 208.5298 | 207.8005 | 208.0799 | 36417.0 |
| 2024-08-07 09:00:00 | AAPL | Stock | 208.03 | 208.2 | 206.32 | 206.93 | 152635.0 |
| 2024-08-07 09:30:00 | AAPL | Stock | 206.94 | 212.43 | 206.39 | 212.4 | 6334626.0 |
| 2024-08-07 10:00:00 | AAPL | Stock | 212.43 | 212.91 | 210.81 | 211.7 | 3660704.0 |
| 2024-08-07 10:30:00 | AAPL | Stock | 211.69 | 213.47 | 211.47 | 213.15 | 2842247.0 |
| 2024-08-07 11:00:00 | AAPL | Stock | 213.18 | 213.59 | 212.65 | 213.16 | 2180170.0 |
| 2024-08-07 11:30:00 | AAPL | Stock | 213.17 | 213.64 | 211.96 | 212.5799 | 2270004.0 |
| 2024-08-07 12:00:00 | AAPL | Stock | 212.5799 | 212.81 | 211.18 | 212.585 | 1805975.0 |
| 2024-08-07 12:30:00 | AAPL | Stock | 212.5997 | 212.97 | 211.4301 | 211.555 | 1539279.0 |
| 2024-08-07 13:00:00 | AAPL | Stock | 211.54 | 211.85 | 210.35 | 211.04 | 2308434.0 |
| 2024-08-07 13:30:00 | AAPL | Stock | 211.04 | 211.49 | 210.5881 | 210.93 | 1541218.0 |
| 2024-08-07 14:00:00 | AAPL | Stock | 210.9 | 211.28 | 210.01 | 211.04 | 2141872.0 |
| 2024-08-07 14:30:00 | AAPL | Stock | 211.02 | 211.02 | 208.89 | 208.94 | 2327990.0 |
| 2024-08-07 15:00:00 | AAPL | Stock | 208.945 | 210.84 | 208.48 | 210.5201 | 2431170.0 |
| 2024-08-07 15:30:00 | AAPL | Stock | 210.55 | 210.99 | 209.41 | 209.86 | 4179047.0 |
| 2024-08-07 16:00:00 | AAPL | Stock | 209.87 | 209.93 | 209.01 | 209.14 | 6449129.0 |
| 2024-08-07 16:30:00 | AAPL | Stock | 209.11 | 209.82 | 208.71 | 208.71 | 184429.0 |
| 2024-08-07 17:00:00 | AAPL | Stock | 208.63 | 209.82 | 208.09 | 208.2 | 32360.0 |
| 2024-08-07 17:30:00 | AAPL | Stock | 208.29 | 209.82 | 208.12 | 208.39 | 20077.0 |
| 2024-08-07 18:00:00 | AAPL | Stock | 208.39 | 209.34 | 208.3584 | 209.06 | 34468.0 |
| 2024-08-07 18:30:00 | AAPL | Stock | 209.06 | 209.3 | 208.49 | 208.9 | 10800.0 |
| 2024-08-07 19:00:00 | AAPL | Stock | 208.71 | 209.0 | 208.05 | 208.05 | 10383.0 |
| 2024-08-07 19:30:00 | AAPL | Stock | 208.05 | 208.46 | 207.63 | 208.25 | 36900.0 |
| 2024-08-07 04:00:00 | MSFT | Stock | 401.47 | 403.77 | 401.47 | 403.6 | 6908.0 |
| 2024-08-07 04:30:00 | MSFT | Stock | 403.69 | 404.62 | 403.3 | 404.62 | 3398.0 |
| 2024-08-07 05:00:00 | MSFT | Stock | 404.75 | 405.66 | 404.36 | 405.66 | 4599.0 |
| 2024-08-07 05:30:00 | MSFT | Stock | 406.0 | 406.6 | 405.65 | 405.65 | 6048.0 |
| 2024-08-07 06:00:00 | MSFT | Stock | 405.92 | 406.37 | 405.92 | 406.09 | 1756.0 |
| 2024-08-07 06:30:00 | MSFT | Stock | 406.37 | 407.09 | 406.36 | 407.0 | 6999.0 |
| 2024-08-07 07:00:00 | MSFT | Stock | 406.61 | 407.2 | 406.45 | 406.9 | 13092.0 |
| 2024-08-07 07:30:00 | MSFT | Stock | 406.93 | 407.0 | 406.07 | 406.15 | 10047.0 |
| 2024-08-07 08:00:00 | MSFT | Stock | 406.58 | 407.6 | 401.93 | 407.11 | 41841.0 |
| 2024-08-07 08:30:00 | MSFT | Stock | 407.2 | 409.48 | 407.2 | 408.35 | 20220.0 |
| 2024-08-07 09:00:00 | MSFT | Stock | 408.05 | 409.39 | 407.0087 | 408.87 | 21795.0 |
| 2024-08-07 09:30:00 | MSFT | Stock | 408.69 | 409.32 | 406.93 | 408.9184 | 1543408.0 |
| 2024-08-07 10:00:00 | MSFT | Stock | 408.93 | 410.08 | 407.77 | 408.44 | 878813.0 |
| 2024-08-07 10:30:00 | MSFT | Stock | 408.42 | 409.4991 | 407.43 | 408.43 | 543103.0 |
| 2024-08-07 11:00:00 | MSFT | Stock | 408.445 | 408.67 | 406.5 | 407.21 | 547667.0 |
| 2024-08-07 11:30:00 | MSFT | Stock | 407.25 | 407.66 | 404.65 | 405.71 | 567220.0 |
| 2024-08-07 12:00:00 | MSFT | Stock | 405.74 | 405.77 | 403.39 | 404.75 | 507718.0 |
| 2024-08-07 12:30:00 | MSFT | Stock | 404.745 | 404.84 | 401.31 | 401.88 | 598724.0 |
> showing 50 of 99,776 rows — these rows as CSV