PREVIEW / stock_30min / 2024-07-31
file: by_date/stock_30min/2024/2024-07-31.parquet size: 2.1 MB rows: 101,743 symbols: 898
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-07-31 04:00:00 | AAPL | Stock | 219.67 | 219.96 | 219.29 | 219.69 | 18586.0 |
| 2024-07-31 04:30:00 | AAPL | Stock | 219.74 | 220.24 | 219.74 | 220.24 | 6280.0 |
| 2024-07-31 05:00:00 | AAPL | Stock | 220.33 | 220.49 | 220.02 | 220.2 | 6043.0 |
| 2024-07-31 05:30:00 | AAPL | Stock | 220.13 | 220.68 | 220.13 | 220.49 | 4368.0 |
| 2024-07-31 06:00:00 | AAPL | Stock | 220.26 | 220.26 | 220.0 | 220.0 | 3512.0 |
| 2024-07-31 06:30:00 | AAPL | Stock | 219.95 | 220.42 | 219.95 | 220.42 | 7328.0 |
| 2024-07-31 07:00:00 | AAPL | Stock | 220.32 | 220.6 | 220.01 | 220.18 | 19674.0 |
| 2024-07-31 07:30:00 | AAPL | Stock | 220.15 | 220.33 | 220.11 | 220.25 | 36146.0 |
| 2024-07-31 08:00:00 | AAPL | Stock | 220.0 | 220.58 | 218.7 | 220.01 | 115465.0 |
| 2024-07-31 08:30:00 | AAPL | Stock | 219.93 | 221.3 | 219.88 | 221.3 | 154899.0 |
| 2024-07-31 09:00:00 | AAPL | Stock | 221.28 | 221.9 | 220.65 | 221.7 | 167570.0 |
| 2024-07-31 09:30:00 | AAPL | Stock | 221.44 | 222.66 | 220.63 | 221.98 | 4796695.0 |
| 2024-07-31 10:00:00 | AAPL | Stock | 221.98 | 223.44 | 221.83 | 222.83 | 2985754.0 |
| 2024-07-31 10:30:00 | AAPL | Stock | 222.84 | 223.82 | 222.56 | 222.61 | 2327271.0 |
| 2024-07-31 11:00:00 | AAPL | Stock | 222.605 | 223.17 | 222.3 | 223.155 | 1499471.0 |
| 2024-07-31 11:30:00 | AAPL | Stock | 223.155 | 223.37 | 222.35 | 222.55 | 1369731.0 |
| 2024-07-31 12:00:00 | AAPL | Stock | 222.57 | 222.7 | 222.17 | 222.37 | 983755.0 |
| 2024-07-31 12:30:00 | AAPL | Stock | 222.3836 | 222.76 | 222.0801 | 222.54 | 993517.0 |
| 2024-07-31 13:00:00 | AAPL | Stock | 222.54 | 223.01 | 222.45 | 222.6 | 1754776.0 |
| 2024-07-31 13:30:00 | AAPL | Stock | 222.595 | 222.6 | 221.31 | 222.17 | 1528560.0 |
| 2024-07-31 14:00:00 | AAPL | Stock | 222.19 | 223.01 | 221.92 | 222.94 | 1271019.0 |
| 2024-07-31 14:30:00 | AAPL | Stock | 222.93 | 223.37 | 222.33 | 222.665 | 1520656.0 |
| 2024-07-31 15:00:00 | AAPL | Stock | 222.665 | 223.03 | 221.285 | 221.6101 | 2419946.0 |
| 2024-07-31 15:30:00 | AAPL | Stock | 221.64 | 223.01 | 221.37 | 221.99 | 4345858.0 |
| 2024-07-31 16:00:00 | AAPL | Stock | 222.08 | 223.39 | 221.77 | 222.5 | 10790654.0 |
| 2024-07-31 16:30:00 | AAPL | Stock | 222.54 | 222.88 | 222.08 | 222.32 | 440709.0 |
| 2024-07-31 17:00:00 | AAPL | Stock | 222.401 | 222.8976 | 222.08 | 222.35 | 72575.0 |
| 2024-07-31 17:30:00 | AAPL | Stock | 222.41 | 222.88 | 222.41 | 222.83 | 28478.0 |
| 2024-07-31 18:00:00 | AAPL | Stock | 222.85 | 223.3 | 222.08 | 223.0 | 327700.0 |
| 2024-07-31 18:30:00 | AAPL | Stock | 223.0 | 223.33 | 222.61 | 223.3 | 17845.0 |
| 2024-07-31 19:00:00 | AAPL | Stock | 223.25 | 223.75 | 223.0682 | 223.67 | 38295.0 |
| 2024-07-31 19:30:00 | AAPL | Stock | 223.61 | 223.9245 | 223.6 | 223.8 | 31421.0 |
| 2024-07-31 04:00:00 | MSFT | Stock | 412.15 | 413.5 | 409.32 | 412.5 | 33974.0 |
| 2024-07-31 04:30:00 | MSFT | Stock | 412.79 | 414.87 | 412.7 | 413.1 | 15361.0 |
| 2024-07-31 05:00:00 | MSFT | Stock | 412.59 | 412.8 | 411.0 | 411.15 | 13709.0 |
| 2024-07-31 05:30:00 | MSFT | Stock | 411.42 | 412.21 | 409.89 | 410.69 | 7249.0 |
| 2024-07-31 06:00:00 | MSFT | Stock | 411.0 | 412.19 | 411.0 | 411.83 | 7095.0 |
| 2024-07-31 06:30:00 | MSFT | Stock | 411.99 | 412.68 | 411.43 | 412.26 | 18230.0 |
| 2024-07-31 07:00:00 | MSFT | Stock | 412.13 | 412.2 | 408.88 | 409.5 | 99760.0 |
| 2024-07-31 07:30:00 | MSFT | Stock | 409.51 | 410.24 | 406.71 | 409.6 | 63038.0 |
| 2024-07-31 08:00:00 | MSFT | Stock | 409.74 | 414.49 | 406.6 | 413.5 | 235520.0 |
| 2024-07-31 08:30:00 | MSFT | Stock | 413.5 | 418.0 | 412.88 | 415.65 | 222026.0 |
| 2024-07-31 09:00:00 | MSFT | Stock | 415.63 | 423.09 | 415.42 | 420.64 | 355720.0 |
| 2024-07-31 09:30:00 | MSFT | Stock | 420.48 | 421.775 | 412.21 | 418.73 | 5620473.0 |
| 2024-07-31 10:00:00 | MSFT | Stock | 418.74 | 420.1953 | 416.3504 | 417.6 | 2158388.0 |
| 2024-07-31 10:30:00 | MSFT | Stock | 417.6 | 419.04 | 414.93 | 417.3875 | 1533557.0 |
| 2024-07-31 11:00:00 | MSFT | Stock | 417.39 | 418.31 | 416.9 | 417.87 | 844795.0 |
| 2024-07-31 11:30:00 | MSFT | Stock | 417.86 | 418.67 | 415.75 | 416.075 | 969778.0 |
| 2024-07-31 12:00:00 | MSFT | Stock | 416.11 | 416.81 | 415.49 | 415.715 | 925526.0 |
| 2024-07-31 12:30:00 | MSFT | Stock | 415.71 | 415.78 | 413.86 | 414.55 | 1061668.0 |
> showing 50 of 101,743 rows — these rows as CSV