PREVIEW / stock_30min / 2024-05-07
file: by_date/stock_30min/2024/2024-05-07.parquet size: 2.1 MB rows: 98,538 symbols: 987
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-05-07 04:00:00 | AAPL | Stock | 183.02 | 183.62 | 182.47 | 183.29 | 27351.0 |
| 2024-05-07 04:30:00 | AAPL | Stock | 183.36 | 183.39 | 182.91 | 183.29 | 10839.0 |
| 2024-05-07 05:00:00 | AAPL | Stock | 183.13 | 183.15 | 183.0 | 183.14 | 7557.0 |
| 2024-05-07 05:30:00 | AAPL | Stock | 183.1 | 183.4 | 183.09 | 183.34 | 11955.0 |
| 2024-05-07 06:00:00 | AAPL | Stock | 183.33 | 183.68 | 183.31 | 183.36 | 15429.0 |
| 2024-05-07 06:30:00 | AAPL | Stock | 183.31 | 183.49 | 183.3 | 183.43 | 3696.0 |
| 2024-05-07 07:00:00 | AAPL | Stock | 183.32 | 183.53 | 182.75 | 182.9 | 19729.0 |
| 2024-05-07 07:30:00 | AAPL | Stock | 182.93 | 183.33 | 182.85 | 183.28 | 19019.0 |
| 2024-05-07 08:00:00 | AAPL | Stock | 183.15 | 183.61 | 182.73 | 183.34 | 190613.0 |
| 2024-05-07 08:30:00 | AAPL | Stock | 183.32 | 183.94 | 183.21 | 183.92 | 123509.0 |
| 2024-05-07 09:00:00 | AAPL | Stock | 183.92 | 183.99 | 182.92 | 183.48 | 207287.0 |
| 2024-05-07 09:30:00 | AAPL | Stock | 183.48 | 184.9 | 183.3351 | 183.92 | 11270691.0 |
| 2024-05-07 10:00:00 | AAPL | Stock | 183.93 | 184.47 | 182.71 | 182.8399 | 6783300.0 |
| 2024-05-07 10:30:00 | AAPL | Stock | 182.825 | 183.11 | 182.3 | 182.6101 | 4959287.0 |
| 2024-05-07 11:00:00 | AAPL | Stock | 182.62 | 182.97 | 182.16 | 182.18 | 3842537.0 |
| 2024-05-07 11:30:00 | AAPL | Stock | 182.16 | 182.3562 | 181.43 | 181.57 | 3575352.0 |
| 2024-05-07 12:00:00 | AAPL | Stock | 181.5699 | 181.92 | 181.41 | 181.52 | 2746894.0 |
| 2024-05-07 12:30:00 | AAPL | Stock | 181.52 | 182.02 | 181.32 | 181.865 | 2697501.0 |
| 2024-05-07 13:00:00 | AAPL | Stock | 181.87 | 182.72 | 181.87 | 182.56 | 2444441.0 |
| 2024-05-07 13:30:00 | AAPL | Stock | 182.56 | 182.8 | 182.09 | 182.6875 | 2608296.0 |
| 2024-05-07 14:00:00 | AAPL | Stock | 182.6801 | 182.92 | 182.35 | 182.376 | 1977234.0 |
| 2024-05-07 14:30:00 | AAPL | Stock | 182.37 | 182.78 | 182.3 | 182.4983 | 1684490.0 |
| 2024-05-07 15:00:00 | AAPL | Stock | 182.49 | 182.67 | 182.17 | 182.635 | 2177812.0 |
| 2024-05-07 15:30:00 | AAPL | Stock | 182.63 | 182.68 | 182.22 | 182.37 | 4117064.0 |
| 2024-05-07 16:00:00 | AAPL | Stock | 182.37 | 182.75 | 182.37 | 182.43 | 6177472.0 |
| 2024-05-07 16:30:00 | AAPL | Stock | 182.4304 | 182.5 | 182.38 | 182.3948 | 52563.0 |
| 2024-05-07 17:00:00 | AAPL | Stock | 182.37 | 182.5 | 182.26 | 182.27 | 21464.0 |
| 2024-05-07 17:30:00 | AAPL | Stock | 182.26 | 182.49 | 182.26 | 182.35 | 13416.0 |
| 2024-05-07 18:00:00 | AAPL | Stock | 182.33 | 182.5 | 182.212 | 182.4 | 18318.0 |
| 2024-05-07 18:30:00 | AAPL | Stock | 182.38 | 182.4 | 182.35 | 182.36 | 20527.0 |
| 2024-05-07 19:00:00 | AAPL | Stock | 182.35 | 182.4 | 182.3 | 182.37 | 8271.0 |
| 2024-05-07 19:30:00 | AAPL | Stock | 182.36 | 182.37 | 182.23 | 182.23 | 11356.0 |
| 2024-05-07 04:00:00 | MSFT | Stock | 413.83 | 413.83 | 412.77 | 413.77 | 1550.0 |
| 2024-05-07 04:30:00 | MSFT | Stock | 413.77 | 414.0 | 413.7 | 414.0 | 456.0 |
| 2024-05-07 05:00:00 | MSFT | Stock | 413.8 | 413.9 | 413.8 | 413.9 | 340.0 |
| 2024-05-07 05:30:00 | MSFT | Stock | 413.8 | 413.84 | 413.42 | 413.45 | 1401.0 |
| 2024-05-07 06:00:00 | MSFT | Stock | 413.29 | 413.29 | 413.0 | 413.0 | 2295.0 |
| 2024-05-07 06:30:00 | MSFT | Stock | 413.0 | 413.37 | 413.0 | 413.37 | 702.0 |
| 2024-05-07 07:00:00 | MSFT | Stock | 413.3 | 413.3 | 412.09 | 412.45 | 6795.0 |
| 2024-05-07 07:30:00 | MSFT | Stock | 412.6 | 412.75 | 411.99 | 412.33 | 4987.0 |
| 2024-05-07 08:00:00 | MSFT | Stock | 412.5 | 414.0 | 411.9 | 412.05 | 20302.0 |
| 2024-05-07 08:30:00 | MSFT | Stock | 412.02 | 412.15 | 411.74 | 412.15 | 10107.0 |
| 2024-05-07 09:00:00 | MSFT | Stock | 412.2 | 414.94 | 412.2 | 414.78 | 23758.0 |
| 2024-05-07 09:30:00 | MSFT | Stock | 414.94 | 414.94 | 411.51 | 412.29 | 1569992.0 |
| 2024-05-07 10:00:00 | MSFT | Stock | 412.37 | 413.7 | 411.7 | 411.73 | 730974.0 |
| 2024-05-07 10:30:00 | MSFT | Stock | 411.71 | 413.17 | 411.7 | 412.72 | 578162.0 |
| 2024-05-07 11:00:00 | MSFT | Stock | 412.71 | 412.85 | 412.12 | 412.49 | 450456.0 |
| 2024-05-07 11:30:00 | MSFT | Stock | 412.5302 | 413.1599 | 412.44 | 412.81 | 321039.0 |
| 2024-05-07 12:00:00 | MSFT | Stock | 412.82 | 412.92 | 412.16 | 412.35 | 274095.0 |
| 2024-05-07 12:30:00 | MSFT | Stock | 412.3842 | 412.42 | 411.422 | 411.8422 | 329290.0 |
> showing 50 of 98,538 rows — these rows as CSV