PREVIEW / stock_30min / 2005-04-19
file: by_date/stock_30min/2005/2005-04-19.parquet size: 837 KB rows: 45,119 symbols: 1,959
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-19 07:30:00 | AAPL | Stock | 1.2764 | 1.2821 | 1.2764 | 1.2821 | 72800.0 |
| 2005-04-19 08:00:00 | AAPL | Stock | 1.2839 | 1.2889 | 1.2786 | 1.2879 | 2579948.0 |
| 2005-04-19 08:30:00 | AAPL | Stock | 1.2864 | 1.2968 | 1.285 | 1.2957 | 4831204.0 |
| 2005-04-19 09:00:00 | AAPL | Stock | 1.2957 | 1.3089 | 1.2911 | 1.3064 | 12028436.0 |
| 2005-04-19 09:30:00 | AAPL | Stock | 1.3071 | 1.3121 | 1.2811 | 1.295 | 174093640.0 |
| 2005-04-19 10:00:00 | AAPL | Stock | 1.295 | 1.3014 | 1.2875 | 1.2968 | 94126424.0 |
| 2005-04-19 10:30:00 | AAPL | Stock | 1.2971 | 1.2993 | 1.2889 | 1.2975 | 59410400.0 |
| 2005-04-19 11:00:00 | AAPL | Stock | 1.2982 | 1.3075 | 1.2954 | 1.3061 | 60959584.0 |
| 2005-04-19 11:30:00 | AAPL | Stock | 1.3057 | 1.3143 | 1.3021 | 1.3107 | 61058816.0 |
| 2005-04-19 12:00:00 | AAPL | Stock | 1.3107 | 1.3168 | 1.3093 | 1.3165 | 59633700.0 |
| 2005-04-19 12:30:00 | AAPL | Stock | 1.3161 | 1.3282 | 1.3161 | 1.3221 | 94918124.0 |
| 2005-04-19 13:00:00 | AAPL | Stock | 1.3221 | 1.3282 | 1.3193 | 1.3271 | 62150340.0 |
| 2005-04-19 13:30:00 | AAPL | Stock | 1.3268 | 1.3371 | 1.3257 | 1.3364 | 105767760.0 |
| 2005-04-19 14:00:00 | AAPL | Stock | 1.3364 | 1.3364 | 1.3232 | 1.3243 | 66275888.0 |
| 2005-04-19 14:30:00 | AAPL | Stock | 1.3243 | 1.3286 | 1.3214 | 1.3279 | 61072676.0 |
| 2005-04-19 15:00:00 | AAPL | Stock | 1.3275 | 1.3293 | 1.3221 | 1.3271 | 54759908.0 |
| 2005-04-19 15:30:00 | AAPL | Stock | 1.3275 | 1.3296 | 1.3225 | 1.3239 | 88745300.0 |
| 2005-04-19 16:00:00 | AAPL | Stock | 1.3246 | 1.3357 | 1.3221 | 1.335 | 3563784.0 |
| 2005-04-19 16:30:00 | AAPL | Stock | 1.3346 | 1.3432 | 1.3239 | 1.3432 | 3724840.0 |
| 2005-04-19 17:00:00 | AAPL | Stock | 1.3429 | 1.3589 | 1.3246 | 1.3493 | 4132436.0 |
| 2005-04-19 17:30:00 | AAPL | Stock | 1.3464 | 1.3464 | 1.3429 | 1.3464 | 208600.0 |
| 2005-04-19 18:00:00 | AAPL | Stock | 1.3461 | 1.3475 | 1.3446 | 1.345 | 285320.0 |
| 2005-04-19 08:00:00 | MSFT | Stock | 24.75 | 24.82 | 24.75 | 24.8 | 28531.0 |
| 2005-04-19 08:30:00 | MSFT | Stock | 24.8 | 24.8 | 24.78 | 24.78 | 14745.0 |
| 2005-04-19 09:00:00 | MSFT | Stock | 24.78 | 24.79 | 24.72 | 24.73 | 161048.0 |
| 2005-04-19 09:30:00 | MSFT | Stock | 24.71 | 24.8 | 24.61 | 24.66 | 8899363.0 |
| 2005-04-19 10:00:00 | MSFT | Stock | 24.66 | 24.69 | 24.51 | 24.57 | 6011647.0 |
| 2005-04-19 10:30:00 | MSFT | Stock | 24.57 | 24.75 | 24.45 | 24.53 | 4795515.0 |
| 2005-04-19 11:00:00 | MSFT | Stock | 24.53 | 24.58 | 24.48 | 24.57 | 3927139.0 |
| 2005-04-19 11:30:00 | MSFT | Stock | 24.57 | 24.59 | 24.52 | 24.55 | 2790756.0 |
| 2005-04-19 12:00:00 | MSFT | Stock | 24.54 | 24.58 | 24.52 | 24.54 | 2557477.0 |
| 2005-04-19 12:30:00 | MSFT | Stock | 24.54 | 24.6 | 24.54 | 24.57 | 2746011.0 |
| 2005-04-19 13:00:00 | MSFT | Stock | 24.57 | 24.59 | 24.52 | 24.57 | 2011418.0 |
| 2005-04-19 13:30:00 | MSFT | Stock | 24.57 | 24.64 | 24.56 | 24.61 | 3941655.0 |
| 2005-04-19 14:00:00 | MSFT | Stock | 24.6 | 24.63 | 24.55 | 24.562 | 2770412.0 |
| 2005-04-19 14:30:00 | MSFT | Stock | 24.561 | 24.58 | 24.53 | 24.57 | 3402564.0 |
| 2005-04-19 15:00:00 | MSFT | Stock | 24.57 | 24.6 | 24.53 | 24.58 | 4587679.0 |
| 2005-04-19 15:30:00 | MSFT | Stock | 24.572 | 24.63 | 24.56 | 24.62 | 7562033.0 |
| 2005-04-19 16:00:00 | MSFT | Stock | 24.62 | 24.85 | 24.56 | 24.82 | 7351888.0 |
| 2005-04-19 16:30:00 | MSFT | Stock | 24.82 | 25.04 | 24.62 | 24.8 | 120755.0 |
| 2005-04-19 17:00:00 | MSFT | Stock | 24.79 | 24.83 | 24.62 | 24.62 | 168319.0 |
| 2005-04-19 17:30:00 | MSFT | Stock | 24.8 | 24.83 | 24.8 | 24.81 | 7300.0 |
| 2005-04-19 18:00:00 | MSFT | Stock | 24.83 | 24.83 | 24.8 | 24.8 | 4280.0 |
| 2005-04-19 08:00:00 | NVDA | Stock | 0.1783 | 0.1783 | 0.1783 | 0.1783 | 60000.0 |
| 2005-04-19 08:30:00 | NVDA | Stock | 0.1795 | 0.1802 | 0.1792 | 0.1802 | 132000.0 |
| 2005-04-19 09:00:00 | NVDA | Stock | 0.1802 | 0.1808 | 0.1791 | 0.1796 | 325200.0 |
| 2005-04-19 09:30:00 | NVDA | Stock | 0.1796 | 0.1806 | 0.1787 | 0.1803 | 38763120.0 |
| 2005-04-19 10:00:00 | NVDA | Stock | 0.1802 | 0.183 | 0.1802 | 0.1825 | 44949120.0 |
| 2005-04-19 10:30:00 | NVDA | Stock | 0.1826 | 0.1832 | 0.1805 | 0.1815 | 42254400.0 |
| 2005-04-19 11:00:00 | NVDA | Stock | 0.1815 | 0.1825 | 0.1812 | 0.1822 | 30929880.0 |
> showing 50 of 45,119 rows — these rows as CSV