PREVIEW / stock_30min / 2024-03-04
file: by_date/stock_30min/2024/2024-03-04.parquet size: 2.2 MB rows: 105,174 symbols: 1,141
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-04 04:00:00 | AAPL | Stock | 179.93 | 179.93 | 178.49 | 178.5 | 16166.0 |
| 2024-03-04 04:30:00 | AAPL | Stock | 178.49 | 178.71 | 178.49 | 178.6 | 6079.0 |
| 2024-03-04 05:00:00 | AAPL | Stock | 178.56 | 178.59 | 178.48 | 178.48 | 6810.0 |
| 2024-03-04 05:30:00 | AAPL | Stock | 178.47 | 178.62 | 178.47 | 178.62 | 6731.0 |
| 2024-03-04 06:00:00 | AAPL | Stock | 178.5 | 178.5 | 178.19 | 178.3 | 7049.0 |
| 2024-03-04 06:30:00 | AAPL | Stock | 178.26 | 178.49 | 178.26 | 178.48 | 6608.0 |
| 2024-03-04 07:00:00 | AAPL | Stock | 178.47 | 178.54 | 177.83 | 177.93 | 76565.0 |
| 2024-03-04 07:30:00 | AAPL | Stock | 177.91 | 177.99 | 176.7 | 176.7 | 118429.0 |
| 2024-03-04 08:00:00 | AAPL | Stock | 178.36 | 179.42 | 176.63 | 176.7302 | 419864.0 |
| 2024-03-04 08:30:00 | AAPL | Stock | 176.73 | 177.2 | 176.66 | 176.81 | 166300.0 |
| 2024-03-04 09:00:00 | AAPL | Stock | 176.8 | 177.59 | 175.68 | 176.04 | 460331.0 |
| 2024-03-04 09:30:00 | AAPL | Stock | 176.14 | 176.9 | 174.62 | 174.97 | 11327055.0 |
| 2024-03-04 10:00:00 | AAPL | Stock | 174.96 | 175.0 | 173.93 | 174.19 | 6823320.0 |
| 2024-03-04 10:30:00 | AAPL | Stock | 174.19 | 174.99 | 173.9 | 174.83 | 4910707.0 |
| 2024-03-04 11:00:00 | AAPL | Stock | 174.835 | 175.02 | 174.4301 | 174.815 | 3658043.0 |
| 2024-03-04 11:30:00 | AAPL | Stock | 174.82 | 175.005 | 174.1 | 174.1201 | 3409853.0 |
| 2024-03-04 12:00:00 | AAPL | Stock | 174.1112 | 174.7 | 174.01 | 174.627 | 3054548.0 |
| 2024-03-04 12:30:00 | AAPL | Stock | 174.63 | 174.68 | 174.02 | 174.05 | 2733445.0 |
| 2024-03-04 13:00:00 | AAPL | Stock | 174.05 | 174.0899 | 173.79 | 173.904 | 3638959.0 |
| 2024-03-04 13:30:00 | AAPL | Stock | 173.9 | 174.505 | 173.79 | 174.205 | 2718629.0 |
| 2024-03-04 14:00:00 | AAPL | Stock | 174.2 | 174.455 | 173.98 | 174.34 | 2597307.0 |
| 2024-03-04 14:30:00 | AAPL | Stock | 174.35 | 175.645 | 174.35 | 175.325 | 3978386.0 |
| 2024-03-04 15:00:00 | AAPL | Stock | 175.325 | 175.47 | 175.12 | 175.44 | 2748334.0 |
| 2024-03-04 15:30:00 | AAPL | Stock | 175.445 | 175.5 | 174.95 | 175.09 | 5681564.0 |
| 2024-03-04 16:00:00 | AAPL | Stock | 175.05 | 175.2 | 174.94 | 175.0302 | 5480193.0 |
| 2024-03-04 16:30:00 | AAPL | Stock | 175.04 | 175.1 | 174.9 | 174.97 | 196593.0 |
| 2024-03-04 17:00:00 | AAPL | Stock | 174.97 | 175.1 | 174.96 | 174.98 | 131442.0 |
| 2024-03-04 17:30:00 | AAPL | Stock | 174.96 | 174.99 | 174.91 | 174.92 | 10739.0 |
| 2024-03-04 18:00:00 | AAPL | Stock | 174.95 | 174.95 | 174.75 | 174.83 | 24123.0 |
| 2024-03-04 18:30:00 | AAPL | Stock | 174.78 | 174.84 | 174.61 | 174.61 | 18581.0 |
| 2024-03-04 19:00:00 | AAPL | Stock | 174.67 | 174.67 | 174.55 | 174.6 | 11553.0 |
| 2024-03-04 19:30:00 | AAPL | Stock | 174.55 | 174.61 | 174.5 | 174.6 | 21065.0 |
| 2024-03-04 04:00:00 | MSFT | Stock | 414.6 | 415.3 | 414.53 | 415.15 | 4714.0 |
| 2024-03-04 04:30:00 | MSFT | Stock | 414.95 | 414.95 | 414.61 | 414.61 | 911.0 |
| 2024-03-04 05:00:00 | MSFT | Stock | 414.66 | 414.66 | 414.55 | 414.55 | 1118.0 |
| 2024-03-04 05:30:00 | MSFT | Stock | 414.53 | 414.66 | 414.44 | 414.44 | 802.0 |
| 2024-03-04 06:00:00 | MSFT | Stock | 413.85 | 413.85 | 413.41 | 413.6 | 2193.0 |
| 2024-03-04 06:30:00 | MSFT | Stock | 413.16 | 413.78 | 413.0 | 413.78 | 1668.0 |
| 2024-03-04 07:00:00 | MSFT | Stock | 414.19 | 414.24 | 413.8 | 414.08 | 5056.0 |
| 2024-03-04 07:30:00 | MSFT | Stock | 414.0 | 414.0 | 413.5 | 413.5 | 5926.0 |
| 2024-03-04 08:00:00 | MSFT | Stock | 414.05 | 416.538 | 413.43 | 413.65 | 29763.0 |
| 2024-03-04 08:30:00 | MSFT | Stock | 413.6 | 413.9 | 413.5 | 413.6699 | 13969.0 |
| 2024-03-04 09:00:00 | MSFT | Stock | 413.6 | 413.62 | 412.0 | 413.45 | 66293.0 |
| 2024-03-04 09:30:00 | MSFT | Stock | 413.45 | 416.25 | 412.32 | 416.11 | 2205764.0 |
| 2024-03-04 10:00:00 | MSFT | Stock | 416.13 | 417.35 | 414.28 | 414.47 | 1166321.0 |
| 2024-03-04 10:30:00 | MSFT | Stock | 414.4601 | 415.93 | 414.35 | 415.89 | 626126.0 |
| 2024-03-04 11:00:00 | MSFT | Stock | 415.9 | 416.115 | 414.9 | 415.86 | 466251.0 |
| 2024-03-04 11:30:00 | MSFT | Stock | 415.87 | 416.12 | 415.43 | 416.05 | 424382.0 |
| 2024-03-04 12:00:00 | MSFT | Stock | 416.065 | 416.55 | 415.6564 | 416.36 | 421901.0 |
| 2024-03-04 12:30:00 | MSFT | Stock | 416.365 | 416.46 | 415.86 | 415.93 | 315132.0 |
> showing 50 of 105,174 rows — these rows as CSV