PREVIEW / stock_30min / 2006-04-18
file: by_date/stock_30min/2006/2006-04-18.parquet size: 950 KB rows: 50,546 symbols: 2,240
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-18 06:30:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 2800.0 |
| 2006-04-18 07:00:00 | AAPL | Stock | 2.3146 | 2.3214 | 2.3079 | 2.3179 | 67648.0 |
| 2006-04-18 07:30:00 | AAPL | Stock | 2.3211 | 2.3225 | 2.3211 | 2.3225 | 22400.0 |
| 2006-04-18 08:00:00 | AAPL | Stock | 2.3232 | 2.3268 | 2.3182 | 2.3189 | 519652.0 |
| 2006-04-18 08:30:00 | AAPL | Stock | 2.3196 | 2.3246 | 2.3182 | 2.3229 | 809340.0 |
| 2006-04-18 09:00:00 | AAPL | Stock | 2.3239 | 2.3254 | 2.3146 | 2.3225 | 4673900.0 |
| 2006-04-18 09:30:00 | AAPL | Stock | 2.323 | 2.3396 | 2.3214 | 2.3304 | 94171112.0 |
| 2006-04-18 10:00:00 | AAPL | Stock | 2.3304 | 2.3343 | 2.3139 | 2.3164 | 91466368.0 |
| 2006-04-18 10:30:00 | AAPL | Stock | 2.3161 | 2.3357 | 2.3161 | 2.3246 | 56902244.0 |
| 2006-04-18 11:00:00 | AAPL | Stock | 2.3246 | 2.3346 | 2.3225 | 2.3321 | 31588956.0 |
| 2006-04-18 11:30:00 | AAPL | Stock | 2.3318 | 2.3536 | 2.325 | 2.3532 | 57718724.0 |
| 2006-04-18 12:00:00 | AAPL | Stock | 2.3532 | 2.3696 | 2.3486 | 2.3618 | 88560752.0 |
| 2006-04-18 12:30:00 | AAPL | Stock | 2.3621 | 2.3646 | 2.3554 | 2.3586 | 43646288.0 |
| 2006-04-18 13:00:00 | AAPL | Stock | 2.36 | 2.3689 | 2.3571 | 2.3589 | 32369792.0 |
| 2006-04-18 13:30:00 | AAPL | Stock | 2.3589 | 2.3639 | 2.3446 | 2.3482 | 41830096.0 |
| 2006-04-18 14:00:00 | AAPL | Stock | 2.3482 | 2.3741 | 2.3482 | 2.3618 | 83100472.0 |
| 2006-04-18 14:30:00 | AAPL | Stock | 2.3614 | 2.3621 | 2.3518 | 2.3575 | 40023200.0 |
| 2006-04-18 15:00:00 | AAPL | Stock | 2.3571 | 2.3682 | 2.3557 | 2.3607 | 52590636.0 |
| 2006-04-18 15:30:00 | AAPL | Stock | 2.3611 | 2.3707 | 2.3604 | 2.365 | 58113524.0 |
| 2006-04-18 16:00:00 | AAPL | Stock | 2.3654 | 2.3679 | 2.3629 | 2.3643 | 1547504.0 |
| 2006-04-18 16:30:00 | AAPL | Stock | 2.3661 | 2.3821 | 2.3643 | 2.3804 | 1263444.0 |
| 2006-04-18 17:00:00 | AAPL | Stock | 2.3804 | 2.3857 | 2.3804 | 2.3829 | 1090236.0 |
| 2006-04-18 17:30:00 | AAPL | Stock | 2.3829 | 2.3871 | 2.3821 | 2.3821 | 300608.0 |
| 2006-04-18 18:00:00 | AAPL | Stock | 2.3839 | 2.3854 | 2.3829 | 2.3836 | 240016.0 |
| 2006-04-18 06:30:00 | MSFT | Stock | 26.83 | 26.83 | 26.83 | 26.83 | 1000.0 |
| 2006-04-18 07:30:00 | MSFT | Stock | 26.82 | 26.87 | 26.81 | 26.84 | 15131.0 |
| 2006-04-18 08:00:00 | MSFT | Stock | 26.86 | 26.88 | 26.84 | 26.88 | 16000.0 |
| 2006-04-18 08:30:00 | MSFT | Stock | 26.89 | 26.92 | 26.88 | 26.92 | 25000.0 |
| 2006-04-18 09:00:00 | MSFT | Stock | 26.92 | 26.94 | 26.84 | 26.91 | 231650.0 |
| 2006-04-18 09:30:00 | MSFT | Stock | 26.94 | 27.5 | 26.87 | 26.94 | 3659003.0 |
| 2006-04-18 10:00:00 | MSFT | Stock | 26.94 | 26.98 | 26.93 | 26.94 | 2520300.0 |
| 2006-04-18 10:30:00 | MSFT | Stock | 26.94 | 26.98 | 26.82 | 26.85 | 4477326.0 |
| 2006-04-18 11:00:00 | MSFT | Stock | 26.85 | 26.98 | 26.84 | 26.95 | 2735821.0 |
| 2006-04-18 11:30:00 | MSFT | Stock | 26.94 | 27.05 | 26.94 | 27.03 | 5453037.0 |
| 2006-04-18 12:00:00 | MSFT | Stock | 27.03 | 27.1 | 27.02 | 27.07 | 3084352.0 |
| 2006-04-18 12:30:00 | MSFT | Stock | 27.06 | 27.15 | 27.06 | 27.13 | 2375368.0 |
| 2006-04-18 13:00:00 | MSFT | Stock | 27.13 | 27.23 | 27.09 | 27.15 | 3659423.0 |
| 2006-04-18 13:30:00 | MSFT | Stock | 27.15 | 27.18 | 27.08 | 27.1 | 1829169.0 |
| 2006-04-18 14:00:00 | MSFT | Stock | 27.111 | 27.36 | 27.1 | 27.18 | 5635986.0 |
| 2006-04-18 14:30:00 | MSFT | Stock | 27.19 | 27.24 | 27.14 | 27.19 | 3073281.0 |
| 2006-04-18 15:00:00 | MSFT | Stock | 27.19 | 27.3 | 27.18 | 27.24 | 3880996.0 |
| 2006-04-18 15:30:00 | MSFT | Stock | 27.24 | 27.27 | 27.18 | 27.19 | 10187914.0 |
| 2006-04-18 16:00:00 | MSFT | Stock | 27.22 | 27.22 | 27.19 | 27.22 | 128190.0 |
| 2006-04-18 16:30:00 | MSFT | Stock | 27.21 | 27.27 | 27.15 | 27.15 | 7600.0 |
| 2006-04-18 17:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.21 | 27.21 | 474.0 |
| 2006-04-18 17:30:00 | MSFT | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 100.0 |
| 2006-04-18 18:00:00 | MSFT | Stock | 27.21 | 27.27 | 27.21 | 27.27 | 3330.0 |
| 2006-04-18 07:00:00 | NVDA | Stock | 0.4847 | 0.485 | 0.4833 | 0.485 | 102000.0 |
| 2006-04-18 08:00:00 | NVDA | Stock | 0.4868 | 0.4887 | 0.4865 | 0.4883 | 858000.0 |
| 2006-04-18 08:30:00 | NVDA | Stock | 0.4875 | 0.4875 | 0.4835 | 0.4858 | 2253840.0 |
> showing 50 of 50,546 rows — these rows as CSV