PREVIEW / stock_30min / 2006-03-07
file: by_date/stock_30min/2006/2006-03-07.parquet size: 900 KB rows: 48,427 symbols: 2,181
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-03-07 05:30:00 | AAPL | Stock | 2.3232 | 2.3232 | 2.3232 | 2.3232 | 2800.0 |
| 2006-03-07 06:00:00 | AAPL | Stock | 2.325 | 2.3336 | 2.325 | 2.3336 | 16800.0 |
| 2006-03-07 06:30:00 | AAPL | Stock | 2.3357 | 2.3357 | 2.3357 | 2.3357 | 27580.0 |
| 2006-03-07 07:30:00 | AAPL | Stock | 2.3343 | 2.3343 | 2.3343 | 2.3343 | 13860.0 |
| 2006-03-07 08:00:00 | AAPL | Stock | 2.3343 | 2.3525 | 2.3343 | 2.3507 | 2456608.0 |
| 2006-03-07 08:30:00 | AAPL | Stock | 2.35 | 2.35 | 2.34 | 2.3411 | 1387288.0 |
| 2006-03-07 09:00:00 | AAPL | Stock | 2.3429 | 2.3511 | 2.3407 | 2.3482 | 2787596.0 |
| 2006-03-07 09:30:00 | AAPL | Stock | 2.3486 | 2.3621 | 2.3304 | 2.3364 | 130749948.0 |
| 2006-03-07 10:00:00 | AAPL | Stock | 2.3368 | 2.3646 | 2.3364 | 2.3646 | 95902660.0 |
| 2006-03-07 10:30:00 | AAPL | Stock | 2.3643 | 2.3757 | 2.36 | 2.3654 | 84545580.0 |
| 2006-03-07 11:00:00 | AAPL | Stock | 2.3654 | 2.3893 | 2.3636 | 2.3846 | 81598972.0 |
| 2006-03-07 11:30:00 | AAPL | Stock | 2.3846 | 2.3846 | 2.3554 | 2.3625 | 60537008.0 |
| 2006-03-07 12:00:00 | AAPL | Stock | 2.3621 | 2.3693 | 2.3486 | 2.3517 | 45019520.0 |
| 2006-03-07 12:30:00 | AAPL | Stock | 2.3521 | 2.3596 | 2.3411 | 2.3454 | 44076144.0 |
| 2006-03-07 13:00:00 | AAPL | Stock | 2.3454 | 2.3471 | 2.3243 | 2.3446 | 66610180.0 |
| 2006-03-07 13:30:00 | AAPL | Stock | 2.3446 | 2.3625 | 2.3443 | 2.355 | 54892712.0 |
| 2006-03-07 14:00:00 | AAPL | Stock | 2.355 | 2.3589 | 2.3432 | 2.3471 | 36821148.0 |
| 2006-03-07 14:30:00 | AAPL | Stock | 2.3471 | 2.3671 | 2.3418 | 2.3593 | 48500088.0 |
| 2006-03-07 15:00:00 | AAPL | Stock | 2.3593 | 2.365 | 2.3546 | 2.3589 | 38236940.0 |
| 2006-03-07 15:30:00 | AAPL | Stock | 2.3593 | 2.3743 | 2.3589 | 2.3693 | 66515260.0 |
| 2006-03-07 16:00:00 | AAPL | Stock | 2.3693 | 2.3729 | 2.3679 | 2.3707 | 1373288.0 |
| 2006-03-07 16:30:00 | AAPL | Stock | 2.3707 | 2.3768 | 2.3696 | 2.3768 | 844200.0 |
| 2006-03-07 17:00:00 | AAPL | Stock | 2.3696 | 2.3768 | 2.3696 | 2.3711 | 139916.0 |
| 2006-03-07 17:30:00 | AAPL | Stock | 2.3711 | 2.3732 | 2.3679 | 2.3732 | 480256.0 |
| 2006-03-07 18:00:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3679 | 2.3696 | 165060.0 |
| 2006-03-07 07:00:00 | MSFT | Stock | 26.89 | 26.89 | 26.89 | 26.89 | 1000.0 |
| 2006-03-07 08:00:00 | MSFT | Stock | 26.82 | 26.87 | 26.82 | 26.82 | 6680.0 |
| 2006-03-07 08:30:00 | MSFT | Stock | 26.83 | 26.86 | 26.83 | 26.86 | 4790.0 |
| 2006-03-07 09:00:00 | MSFT | Stock | 26.85 | 27.25 | 26.83 | 26.9 | 221001.0 |
| 2006-03-07 09:30:00 | MSFT | Stock | 26.9 | 26.92 | 26.81 | 26.898 | 5224533.0 |
| 2006-03-07 10:00:00 | MSFT | Stock | 26.89 | 27.0 | 26.89 | 26.96 | 3139789.0 |
| 2006-03-07 10:30:00 | MSFT | Stock | 26.96 | 26.99 | 26.93 | 26.95 | 2290956.0 |
| 2006-03-07 11:00:00 | MSFT | Stock | 26.96 | 26.98 | 26.85 | 26.962 | 3157823.0 |
| 2006-03-07 11:30:00 | MSFT | Stock | 26.96 | 26.98 | 26.93 | 26.95 | 1784583.0 |
| 2006-03-07 12:00:00 | MSFT | Stock | 26.95 | 27.09 | 26.85 | 27.02 | 3762841.0 |
| 2006-03-07 12:30:00 | MSFT | Stock | 27.02 | 27.07 | 26.88 | 26.91 | 3879378.0 |
| 2006-03-07 13:00:00 | MSFT | Stock | 26.9 | 26.96 | 26.89 | 26.94 | 2353510.0 |
| 2006-03-07 13:30:00 | MSFT | Stock | 26.94 | 26.97 | 26.92 | 26.95 | 1866726.0 |
| 2006-03-07 14:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.91 | 26.94 | 3759740.0 |
| 2006-03-07 14:30:00 | MSFT | Stock | 26.94 | 27.01 | 26.9 | 26.99 | 3947680.0 |
| 2006-03-07 15:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.93 | 26.952 | 1579049.0 |
| 2006-03-07 15:30:00 | MSFT | Stock | 26.96 | 27.1 | 26.95 | 27.04 | 6409553.0 |
| 2006-03-07 16:00:00 | MSFT | Stock | 27.04 | 27.09 | 27.03 | 27.07 | 87402.0 |
| 2006-03-07 16:30:00 | MSFT | Stock | 27.05 | 27.08 | 27.05 | 27.08 | 3600.0 |
| 2006-03-07 17:00:00 | MSFT | Stock | 27.06 | 27.08 | 27.06 | 27.08 | 5668300.0 |
| 2006-03-07 17:30:00 | MSFT | Stock | 27.08 | 27.08 | 27.05 | 27.06 | 7015.0 |
| 2006-03-07 18:00:00 | MSFT | Stock | 27.08 | 27.08 | 27.06 | 27.08 | 18100.0 |
| 2006-03-07 08:00:00 | NVDA | Stock | 0.4091 | 0.4124 | 0.4091 | 0.4092 | 276000.0 |
| 2006-03-07 08:30:00 | NVDA | Stock | 0.4089 | 0.4089 | 0.4089 | 0.4089 | 12000.0 |
| 2006-03-07 09:00:00 | NVDA | Stock | 0.4087 | 0.4111 | 0.4087 | 0.4111 | 752040.0 |
> showing 50 of 48,427 rows — these rows as CSV