PREVIEW / stock_30min / 2024-03-18
file: by_date/stock_30min/2024/2024-03-18.parquet size: 2.1 MB rows: 101,796 symbols: 1,086
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-18 04:00:00 | AAPL | Stock | 173.4 | 174.0 | 173.37 | 173.4 | 22079.0 |
| 2024-03-18 04:30:00 | AAPL | Stock | 173.27 | 173.8 | 173.27 | 173.75 | 6889.0 |
| 2024-03-18 05:00:00 | AAPL | Stock | 173.73 | 173.97 | 173.3 | 173.53 | 8604.0 |
| 2024-03-18 05:30:00 | AAPL | Stock | 173.54 | 173.54 | 173.15 | 173.51 | 9642.0 |
| 2024-03-18 06:00:00 | AAPL | Stock | 173.27 | 173.7 | 173.15 | 173.66 | 6494.0 |
| 2024-03-18 06:30:00 | AAPL | Stock | 173.66 | 173.86 | 173.03 | 173.11 | 30934.0 |
| 2024-03-18 07:00:00 | AAPL | Stock | 173.11 | 173.74 | 172.41 | 173.2 | 75940.0 |
| 2024-03-18 07:30:00 | AAPL | Stock | 173.1 | 174.8 | 173.1 | 174.64 | 138542.0 |
| 2024-03-18 08:00:00 | AAPL | Stock | 173.1 | 175.19 | 172.41 | 174.7 | 452526.0 |
| 2024-03-18 08:30:00 | AAPL | Stock | 174.8 | 174.8 | 174.21 | 174.68 | 122842.0 |
| 2024-03-18 09:00:00 | AAPL | Stock | 174.53 | 175.55 | 174.27 | 175.51 | 363937.0 |
| 2024-03-18 09:30:00 | AAPL | Stock | 175.57 | 177.58 | 174.88 | 176.758 | 12600874.0 |
| 2024-03-18 10:00:00 | AAPL | Stock | 176.77 | 177.46 | 176.585 | 177.35 | 5024657.0 |
| 2024-03-18 10:30:00 | AAPL | Stock | 177.37 | 177.71 | 176.89 | 177.18 | 4030121.0 |
| 2024-03-18 11:00:00 | AAPL | Stock | 177.18 | 177.33 | 176.56 | 176.82 | 2804878.0 |
| 2024-03-18 11:30:00 | AAPL | Stock | 176.82 | 176.9099 | 175.6115 | 175.64 | 3045124.0 |
| 2024-03-18 12:00:00 | AAPL | Stock | 175.64 | 175.65 | 175.2 | 175.2583 | 2773075.0 |
| 2024-03-18 12:30:00 | AAPL | Stock | 175.255 | 175.62 | 175.075 | 175.08 | 1957859.0 |
| 2024-03-18 13:00:00 | AAPL | Stock | 175.08 | 175.42 | 174.74 | 175.395 | 2453606.0 |
| 2024-03-18 13:30:00 | AAPL | Stock | 175.4 | 175.45 | 174.99 | 175.116 | 1587304.0 |
| 2024-03-18 14:00:00 | AAPL | Stock | 175.12 | 175.54 | 175.05 | 175.5301 | 1497679.0 |
| 2024-03-18 14:30:00 | AAPL | Stock | 175.54 | 175.54 | 174.82 | 174.975 | 1863736.0 |
| 2024-03-18 15:00:00 | AAPL | Stock | 174.975 | 175.176 | 174.91 | 175.065 | 1812152.0 |
| 2024-03-18 15:30:00 | AAPL | Stock | 175.07 | 175.175 | 173.52 | 173.7 | 6079619.0 |
| 2024-03-18 16:00:00 | AAPL | Stock | 173.79 | 173.79 | 173.21 | 173.32 | 12206565.0 |
| 2024-03-18 16:30:00 | AAPL | Stock | 173.32 | 173.72 | 173.0 | 173.26 | 89400.0 |
| 2024-03-18 17:00:00 | AAPL | Stock | 173.231 | 173.45 | 173.22 | 173.43 | 60260.0 |
| 2024-03-18 17:30:00 | AAPL | Stock | 173.32 | 174.1153 | 173.31 | 173.8 | 156847.0 |
| 2024-03-18 18:00:00 | AAPL | Stock | 173.8 | 173.9 | 173.5 | 173.6 | 29435.0 |
| 2024-03-18 18:30:00 | AAPL | Stock | 173.6 | 173.6888 | 173.4 | 173.5 | 25583.0 |
| 2024-03-18 19:00:00 | AAPL | Stock | 173.42 | 173.69 | 173.33 | 173.68 | 10471.0 |
| 2024-03-18 19:30:00 | AAPL | Stock | 173.68 | 173.69 | 173.52 | 173.59 | 15539.0 |
| 2024-03-18 04:00:00 | MSFT | Stock | 417.49 | 418.22 | 416.4 | 416.4 | 5631.0 |
| 2024-03-18 04:30:00 | MSFT | Stock | 416.19 | 416.83 | 416.09 | 416.83 | 4236.0 |
| 2024-03-18 05:00:00 | MSFT | Stock | 416.93 | 416.93 | 416.02 | 416.02 | 3082.0 |
| 2024-03-18 05:30:00 | MSFT | Stock | 415.97 | 416.0 | 415.74 | 415.74 | 2367.0 |
| 2024-03-18 06:00:00 | MSFT | Stock | 415.81 | 416.6 | 415.77 | 416.6 | 2555.0 |
| 2024-03-18 06:30:00 | MSFT | Stock | 416.87 | 417.0 | 416.87 | 417.0 | 1392.0 |
| 2024-03-18 07:00:00 | MSFT | Stock | 417.1 | 417.1 | 414.0 | 415.18 | 27957.0 |
| 2024-03-18 07:30:00 | MSFT | Stock | 415.25 | 415.6 | 415.0 | 415.14 | 31683.0 |
| 2024-03-18 08:00:00 | MSFT | Stock | 414.5239 | 418.32 | 413.77 | 414.0 | 64209.0 |
| 2024-03-18 08:30:00 | MSFT | Stock | 414.0 | 414.0 | 412.0 | 412.39 | 57735.0 |
| 2024-03-18 09:00:00 | MSFT | Stock | 412.7 | 414.25 | 412.4769 | 413.88 | 39651.0 |
| 2024-03-18 09:30:00 | MSFT | Stock | 414.25 | 419.54 | 413.78 | 417.49 | 2129784.0 |
| 2024-03-18 10:00:00 | MSFT | Stock | 417.5 | 420.73 | 417.4 | 419.77 | 1177289.0 |
| 2024-03-18 10:30:00 | MSFT | Stock | 419.83 | 420.29 | 418.19 | 419.15 | 648060.0 |
| 2024-03-18 11:00:00 | MSFT | Stock | 419.2 | 419.38 | 418.13 | 418.9 | 528448.0 |
| 2024-03-18 11:30:00 | MSFT | Stock | 418.91 | 418.9344 | 417.68 | 418.34 | 431803.0 |
| 2024-03-18 12:00:00 | MSFT | Stock | 418.38 | 419.56 | 418.04 | 419.14 | 469713.0 |
| 2024-03-18 12:30:00 | MSFT | Stock | 419.13 | 419.13 | 417.88 | 417.955 | 393270.0 |
> showing 50 of 101,796 rows — these rows as CSV