PREVIEW / stock_30min / 2024-09-03
file: by_date/stock_30min/2024/2024-09-03.parquet size: 2.0 MB rows: 100,660 symbols: 843
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-09-03 04:00:00 | AAPL | Stock | 229.27 | 229.84 | 229.14 | 229.31 | 17439.0 |
| 2024-09-03 04:30:00 | AAPL | Stock | 229.36 | 229.36 | 228.59 | 228.59 | 4368.0 |
| 2024-09-03 05:00:00 | AAPL | Stock | 228.57 | 228.68 | 227.8 | 228.16 | 12661.0 |
| 2024-09-03 05:30:00 | AAPL | Stock | 228.0 | 228.47 | 227.82 | 228.47 | 3622.0 |
| 2024-09-03 06:00:00 | AAPL | Stock | 228.29 | 228.36 | 228.02 | 228.36 | 3384.0 |
| 2024-09-03 06:30:00 | AAPL | Stock | 228.32 | 228.32 | 228.19 | 228.21 | 1348.0 |
| 2024-09-03 07:00:00 | AAPL | Stock | 228.14 | 228.48 | 227.57 | 227.98 | 21043.0 |
| 2024-09-03 07:30:00 | AAPL | Stock | 228.02 | 228.14 | 227.61 | 227.84 | 15942.0 |
| 2024-09-03 08:00:00 | AAPL | Stock | 227.85 | 229.7 | 227.4297 | 228.05 | 81117.0 |
| 2024-09-03 08:30:00 | AAPL | Stock | 228.05 | 228.5158 | 227.96 | 228.06 | 26243.0 |
| 2024-09-03 09:00:00 | AAPL | Stock | 227.9207 | 228.85 | 227.92 | 228.62 | 67234.0 |
| 2024-09-03 09:30:00 | AAPL | Stock | 228.55 | 229.0 | 225.3 | 226.16 | 5178765.0 |
| 2024-09-03 10:00:00 | AAPL | Stock | 226.19 | 226.48 | 224.73 | 225.31 | 2308154.0 |
| 2024-09-03 10:30:00 | AAPL | Stock | 225.305 | 225.305 | 223.51 | 223.645 | 2597292.0 |
| 2024-09-03 11:00:00 | AAPL | Stock | 223.65 | 224.67 | 223.65 | 223.855 | 1688675.0 |
| 2024-09-03 11:30:00 | AAPL | Stock | 223.86 | 224.43 | 223.27 | 223.54 | 1405672.0 |
| 2024-09-03 12:00:00 | AAPL | Stock | 223.55 | 224.32 | 223.34 | 223.89 | 1300927.0 |
| 2024-09-03 12:30:00 | AAPL | Stock | 223.88 | 224.03 | 223.44 | 223.71 | 944360.0 |
| 2024-09-03 13:00:00 | AAPL | Stock | 223.72 | 224.15 | 223.515 | 223.8315 | 937973.0 |
| 2024-09-03 13:30:00 | AAPL | Stock | 223.8252 | 223.93 | 223.18 | 223.21 | 1029747.0 |
| 2024-09-03 14:00:00 | AAPL | Stock | 223.24 | 223.3 | 221.84 | 222.13 | 2203852.0 |
| 2024-09-03 14:30:00 | AAPL | Stock | 222.13 | 222.73 | 221.82 | 221.935 | 1333332.0 |
| 2024-09-03 15:00:00 | AAPL | Stock | 221.945 | 222.715 | 221.77 | 222.45 | 1832651.0 |
| 2024-09-03 15:30:00 | AAPL | Stock | 222.44 | 222.8 | 221.17 | 222.76 | 5138188.0 |
| 2024-09-03 16:00:00 | AAPL | Stock | 222.77 | 222.77 | 221.71 | 221.74 | 8540901.0 |
| 2024-09-03 16:30:00 | AAPL | Stock | 221.76 | 222.77 | 221.72 | 222.0 | 684748.0 |
| 2024-09-03 17:00:00 | AAPL | Stock | 222.0 | 222.77 | 221.09 | 221.0925 | 281400.0 |
| 2024-09-03 17:30:00 | AAPL | Stock | 221.14 | 221.45 | 221.03 | 221.21 | 28198.0 |
| 2024-09-03 18:00:00 | AAPL | Stock | 221.47 | 221.55 | 220.86 | 221.23 | 53947.0 |
| 2024-09-03 18:30:00 | AAPL | Stock | 221.2 | 221.27 | 220.75 | 220.89 | 18561.0 |
| 2024-09-03 19:00:00 | AAPL | Stock | 220.9 | 220.9 | 220.23 | 220.51 | 41488.0 |
| 2024-09-03 19:30:00 | AAPL | Stock | 220.5005 | 220.9545 | 220.39 | 220.8519 | 31978.0 |
| 2024-09-03 04:00:00 | MSFT | Stock | 418.0 | 418.13 | 417.0 | 417.0 | 2576.0 |
| 2024-09-03 04:30:00 | MSFT | Stock | 417.01 | 417.32 | 416.33 | 416.34 | 1627.0 |
| 2024-09-03 05:00:00 | MSFT | Stock | 415.8 | 416.84 | 414.21 | 416.13 | 8019.0 |
| 2024-09-03 05:30:00 | MSFT | Stock | 415.54 | 415.95 | 415.54 | 415.79 | 1012.0 |
| 2024-09-03 06:00:00 | MSFT | Stock | 415.2 | 415.6 | 415.02 | 415.6 | 2102.0 |
| 2024-09-03 06:30:00 | MSFT | Stock | 415.61 | 415.85 | 415.6 | 415.7 | 1420.0 |
| 2024-09-03 07:00:00 | MSFT | Stock | 415.83 | 415.83 | 415.39 | 415.45 | 2290.0 |
| 2024-09-03 07:30:00 | MSFT | Stock | 415.6 | 416.58 | 415.6 | 416.5 | 4145.0 |
| 2024-09-03 08:00:00 | MSFT | Stock | 415.45 | 418.182 | 415.11 | 416.7 | 16399.0 |
| 2024-09-03 08:30:00 | MSFT | Stock | 416.62 | 417.0 | 416.0725 | 416.0725 | 3394.0 |
| 2024-09-03 09:00:00 | MSFT | Stock | 416.27 | 418.0 | 416.1 | 417.93 | 16192.0 |
| 2024-09-03 09:30:00 | MSFT | Stock | 417.95 | 419.88 | 415.34 | 418.21 | 1426674.0 |
| 2024-09-03 10:00:00 | MSFT | Stock | 418.15 | 418.5 | 415.8 | 417.6 | 653407.0 |
| 2024-09-03 10:30:00 | MSFT | Stock | 417.53 | 417.53 | 413.05 | 413.4 | 794036.0 |
| 2024-09-03 11:00:00 | MSFT | Stock | 413.505 | 414.11 | 412.53 | 413.36 | 562854.0 |
| 2024-09-03 11:30:00 | MSFT | Stock | 413.37 | 413.71 | 411.5101 | 411.6 | 295469.0 |
| 2024-09-03 12:00:00 | MSFT | Stock | 411.63 | 413.21 | 411.27 | 411.55 | 361093.0 |
| 2024-09-03 12:30:00 | MSFT | Stock | 411.535 | 411.86 | 410.88 | 411.21 | 318344.0 |
> showing 50 of 100,660 rows — these rows as CSV