PREVIEW / stock_30min / 2006-04-19
file: by_date/stock_30min/2006/2006-04-19.parquet size: 929 KB rows: 49,724 symbols: 2,241
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-19 04:00:00 | AAPL | Stock | 2.3857 | 2.3893 | 2.3857 | 2.3893 | 11200.0 |
| 2006-04-19 04:30:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3911 | 2.3911 | 2800.0 |
| 2006-04-19 05:00:00 | AAPL | Stock | 2.3893 | 2.3939 | 2.3893 | 2.3939 | 11200.0 |
| 2006-04-19 07:00:00 | AAPL | Stock | 2.3982 | 2.3982 | 2.3982 | 2.3982 | 11200.0 |
| 2006-04-19 07:30:00 | AAPL | Stock | 2.4018 | 2.4018 | 2.3932 | 2.3932 | 46760.0 |
| 2006-04-19 08:00:00 | AAPL | Stock | 2.4057 | 2.4057 | 2.3907 | 2.3936 | 2402036.0 |
| 2006-04-19 08:30:00 | AAPL | Stock | 2.3911 | 2.3964 | 2.3875 | 2.3925 | 1950452.0 |
| 2006-04-19 09:00:00 | AAPL | Stock | 2.39 | 2.3918 | 2.3814 | 2.3886 | 2616964.0 |
| 2006-04-19 09:30:00 | AAPL | Stock | 2.3864 | 2.3929 | 2.3686 | 2.3711 | 97635972.0 |
| 2006-04-19 10:00:00 | AAPL | Stock | 2.3714 | 2.3721 | 2.3432 | 2.3579 | 98302008.0 |
| 2006-04-19 10:30:00 | AAPL | Stock | 2.3579 | 2.3629 | 2.3436 | 2.3561 | 67945612.0 |
| 2006-04-19 11:00:00 | AAPL | Stock | 2.3557 | 2.3682 | 2.3536 | 2.3589 | 47502476.0 |
| 2006-04-19 11:30:00 | AAPL | Stock | 2.3589 | 2.3693 | 2.3525 | 2.3664 | 33260164.0 |
| 2006-04-19 12:00:00 | AAPL | Stock | 2.3664 | 2.3796 | 2.3636 | 2.3654 | 55634936.0 |
| 2006-04-19 12:30:00 | AAPL | Stock | 2.3657 | 2.3693 | 2.3536 | 2.3557 | 31236912.0 |
| 2006-04-19 13:00:00 | AAPL | Stock | 2.3557 | 2.3596 | 2.3468 | 2.3478 | 37340884.0 |
| 2006-04-19 13:30:00 | AAPL | Stock | 2.3475 | 2.3579 | 2.3446 | 2.3539 | 36685796.0 |
| 2006-04-19 14:00:00 | AAPL | Stock | 2.3539 | 2.355 | 2.345 | 2.3482 | 45151288.0 |
| 2006-04-19 14:30:00 | AAPL | Stock | 2.3482 | 2.3546 | 2.3436 | 2.3518 | 40497548.0 |
| 2006-04-19 15:00:00 | AAPL | Stock | 2.3518 | 2.3539 | 2.3464 | 2.3486 | 43170372.0 |
| 2006-04-19 15:30:00 | AAPL | Stock | 2.3486 | 2.3504 | 2.3382 | 2.3436 | 108187268.0 |
| 2006-04-19 16:00:00 | AAPL | Stock | 2.3443 | 2.3525 | 2.2321 | 2.2768 | 9119348.0 |
| 2006-04-19 16:30:00 | AAPL | Stock | 2.2775 | 2.4746 | 2.2346 | 2.4571 | 191281832.0 |
| 2006-04-19 17:00:00 | AAPL | Stock | 2.4571 | 2.4604 | 2.3446 | 2.4461 | 48059732.0 |
| 2006-04-19 17:30:00 | AAPL | Stock | 2.4446 | 2.4625 | 2.4396 | 2.45 | 17771040.0 |
| 2006-04-19 18:00:00 | AAPL | Stock | 2.45 | 2.4536 | 2.4446 | 2.4486 | 8709960.0 |
| 2006-04-19 07:00:00 | MSFT | Stock | 27.31 | 27.31 | 27.31 | 27.31 | 2000.0 |
| 2006-04-19 08:00:00 | MSFT | Stock | 27.27 | 27.32 | 27.27 | 27.31 | 8121.0 |
| 2006-04-19 08:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.25 | 27.27 | 27300.0 |
| 2006-04-19 09:00:00 | MSFT | Stock | 27.23 | 27.26 | 27.09 | 27.09 | 446789.0 |
| 2006-04-19 09:30:00 | MSFT | Stock | 27.11 | 27.19 | 27.08 | 27.16 | 3276606.0 |
| 2006-04-19 10:00:00 | MSFT | Stock | 27.16 | 27.18 | 27.06 | 27.1 | 2796283.0 |
| 2006-04-19 10:30:00 | MSFT | Stock | 27.09 | 27.11 | 26.96 | 27.0 | 4962072.0 |
| 2006-04-19 11:00:00 | MSFT | Stock | 27.0 | 27.09 | 26.99 | 27.08 | 2757522.0 |
| 2006-04-19 11:30:00 | MSFT | Stock | 27.08 | 27.16 | 27.07 | 27.08 | 2967215.0 |
| 2006-04-19 12:00:00 | MSFT | Stock | 27.09 | 27.13 | 27.07 | 27.081 | 1651605.0 |
| 2006-04-19 12:30:00 | MSFT | Stock | 27.08 | 27.12 | 27.07 | 27.1 | 2108043.0 |
| 2006-04-19 13:00:00 | MSFT | Stock | 27.09 | 27.13 | 27.07 | 27.1 | 2239456.0 |
| 2006-04-19 13:30:00 | MSFT | Stock | 27.07 | 27.09 | 26.98 | 27.01 | 3933497.0 |
| 2006-04-19 14:00:00 | MSFT | Stock | 27.0 | 27.08 | 26.97 | 27.06 | 2568467.0 |
| 2006-04-19 14:30:00 | MSFT | Stock | 27.05 | 27.12 | 27.02 | 27.109 | 2734156.0 |
| 2006-04-19 15:00:00 | MSFT | Stock | 27.101 | 27.14 | 27.03 | 27.07 | 2887173.0 |
| 2006-04-19 15:30:00 | MSFT | Stock | 27.08 | 27.09 | 27.02 | 27.03 | 7304550.0 |
| 2006-04-19 16:00:00 | MSFT | Stock | 27.05 | 27.11 | 27.02 | 27.06 | 314866.0 |
| 2006-04-19 16:30:00 | MSFT | Stock | 27.06 | 27.12 | 27.03 | 27.1 | 23105.0 |
| 2006-04-19 17:00:00 | MSFT | Stock | 27.03 | 27.11 | 27.03 | 27.11 | 2700.0 |
| 2006-04-19 17:30:00 | MSFT | Stock | 27.03 | 27.08 | 27.03 | 27.08 | 2100.0 |
| 2006-04-19 08:00:00 | NVDA | Stock | 0.4833 | 0.4883 | 0.4833 | 0.4882 | 62400.0 |
| 2006-04-19 08:30:00 | NVDA | Stock | 0.4867 | 0.4882 | 0.4867 | 0.4867 | 114600.0 |
| 2006-04-19 09:00:00 | NVDA | Stock | 0.4875 | 0.4878 | 0.4818 | 0.4818 | 1246260.0 |
> showing 50 of 49,724 rows — these rows as CSV