PREVIEW / stock_30min / 2006-04-13
file: by_date/stock_30min/2006/2006-04-13.parquet size: 875 KB rows: 47,650 symbols: 2,234
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-13 05:30:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4 | 2.4 | 5600.0 |
| 2006-04-13 06:30:00 | AAPL | Stock | 2.3996 | 2.3996 | 2.3996 | 2.3996 | 2800.0 |
| 2006-04-13 07:30:00 | AAPL | Stock | 2.375 | 2.3875 | 2.3679 | 2.3807 | 50400.0 |
| 2006-04-13 08:00:00 | AAPL | Stock | 2.3846 | 2.3846 | 2.3754 | 2.3779 | 510440.0 |
| 2006-04-13 08:30:00 | AAPL | Stock | 2.3786 | 2.3911 | 2.3786 | 2.3861 | 1540980.0 |
| 2006-04-13 09:00:00 | AAPL | Stock | 2.3854 | 2.3861 | 2.3518 | 2.37 | 9441376.0 |
| 2006-04-13 09:30:00 | AAPL | Stock | 2.3693 | 2.3857 | 2.3504 | 2.3675 | 127562456.0 |
| 2006-04-13 10:00:00 | AAPL | Stock | 2.3675 | 2.3821 | 2.3621 | 2.3707 | 70334040.0 |
| 2006-04-13 10:30:00 | AAPL | Stock | 2.37 | 2.4086 | 2.3693 | 2.3925 | 115090444.0 |
| 2006-04-13 11:00:00 | AAPL | Stock | 2.3921 | 2.3936 | 2.3725 | 2.3757 | 98126448.0 |
| 2006-04-13 11:30:00 | AAPL | Stock | 2.3754 | 2.3871 | 2.3711 | 2.3775 | 44656276.0 |
| 2006-04-13 12:00:00 | AAPL | Stock | 2.3775 | 2.385 | 2.3725 | 2.3725 | 24075436.0 |
| 2006-04-13 12:30:00 | AAPL | Stock | 2.3725 | 2.3768 | 2.3686 | 2.3718 | 23790984.0 |
| 2006-04-13 13:00:00 | AAPL | Stock | 2.3718 | 2.3718 | 2.3579 | 2.3636 | 37864848.0 |
| 2006-04-13 13:30:00 | AAPL | Stock | 2.3639 | 2.3768 | 2.3636 | 2.3721 | 33067384.0 |
| 2006-04-13 14:00:00 | AAPL | Stock | 2.3725 | 2.3764 | 2.3704 | 2.3721 | 17311000.0 |
| 2006-04-13 14:30:00 | AAPL | Stock | 2.3721 | 2.3732 | 2.3639 | 2.3667 | 30867480.0 |
| 2006-04-13 15:00:00 | AAPL | Stock | 2.3664 | 2.3714 | 2.3643 | 2.3664 | 28418852.0 |
| 2006-04-13 15:30:00 | AAPL | Stock | 2.3668 | 2.3811 | 2.3668 | 2.3739 | 56267260.0 |
| 2006-04-13 16:00:00 | AAPL | Stock | 2.3739 | 2.3775 | 2.3732 | 2.3746 | 1278424.0 |
| 2006-04-13 16:30:00 | AAPL | Stock | 2.3746 | 2.3764 | 2.3746 | 2.375 | 231728.0 |
| 2006-04-13 17:00:00 | AAPL | Stock | 2.3764 | 2.3764 | 2.3746 | 2.3746 | 467992.0 |
| 2006-04-13 17:30:00 | AAPL | Stock | 2.375 | 2.3761 | 2.3746 | 2.3761 | 57540.0 |
| 2006-04-13 18:00:00 | AAPL | Stock | 2.375 | 2.3757 | 2.3746 | 2.3746 | 228760.0 |
| 2006-04-13 06:30:00 | MSFT | Stock | 27.05 | 27.05 | 27.03 | 27.03 | 1000.0 |
| 2006-04-13 07:30:00 | MSFT | Stock | 27.02 | 27.02 | 27.0 | 27.0 | 900.0 |
| 2006-04-13 08:00:00 | MSFT | Stock | 27.05 | 27.08 | 27.05 | 27.08 | 23810.0 |
| 2006-04-13 08:30:00 | MSFT | Stock | 27.06 | 27.09 | 27.06 | 27.09 | 15600.0 |
| 2006-04-13 09:00:00 | MSFT | Stock | 27.09 | 27.12 | 27.07 | 27.08 | 78478.0 |
| 2006-04-13 09:30:00 | MSFT | Stock | 27.08 | 27.2 | 27.0 | 27.081 | 4271508.0 |
| 2006-04-13 10:00:00 | MSFT | Stock | 27.09 | 27.19 | 27.06 | 27.08 | 2966077.0 |
| 2006-04-13 10:30:00 | MSFT | Stock | 27.08 | 27.18 | 27.06 | 27.17 | 2664211.0 |
| 2006-04-13 11:00:00 | MSFT | Stock | 27.17 | 27.2 | 27.14 | 27.14 | 2117619.0 |
| 2006-04-13 11:30:00 | MSFT | Stock | 27.14 | 27.15 | 27.1 | 27.11 | 1454172.0 |
| 2006-04-13 12:00:00 | MSFT | Stock | 27.11 | 27.15 | 27.08 | 27.13 | 768914.0 |
| 2006-04-13 12:30:00 | MSFT | Stock | 27.13 | 27.14 | 27.1 | 27.11 | 1803570.0 |
| 2006-04-13 13:00:00 | MSFT | Stock | 27.12 | 27.13 | 27.08 | 27.12 | 982705.0 |
| 2006-04-13 13:30:00 | MSFT | Stock | 27.12 | 27.13 | 27.07 | 27.08 | 1324766.0 |
| 2006-04-13 14:00:00 | MSFT | Stock | 27.08 | 27.09 | 27.05 | 27.08 | 996484.0 |
| 2006-04-13 14:30:00 | MSFT | Stock | 27.08 | 27.11 | 27.06 | 27.08 | 1238094.0 |
| 2006-04-13 15:00:00 | MSFT | Stock | 27.08 | 27.08 | 27.05 | 27.06 | 1006794.0 |
| 2006-04-13 15:30:00 | MSFT | Stock | 27.06 | 27.145 | 27.05 | 27.06 | 4046215.0 |
| 2006-04-13 16:00:00 | MSFT | Stock | 27.06 | 27.08 | 27.06 | 27.08 | 37497.0 |
| 2006-04-13 16:30:00 | MSFT | Stock | 27.08 | 27.09 | 27.05 | 27.07 | 3827.0 |
| 2006-04-13 18:00:00 | MSFT | Stock | 27.09 | 27.09 | 27.09 | 27.09 | 200.0 |
| 2006-04-13 07:00:00 | NVDA | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 24000.0 |
| 2006-04-13 07:30:00 | NVDA | Stock | 0.5 | 0.5 | 0.4967 | 0.4967 | 1338000.0 |
| 2006-04-13 08:00:00 | NVDA | Stock | 0.4998 | 0.5017 | 0.4982 | 0.5 | 2994000.0 |
| 2006-04-13 08:30:00 | NVDA | Stock | 0.5008 | 0.5025 | 0.4978 | 0.4978 | 3815400.0 |
| 2006-04-13 09:00:00 | NVDA | Stock | 0.4975 | 0.4975 | 0.4918 | 0.4967 | 7660200.0 |
> showing 50 of 47,650 rows — these rows as CSV