PREVIEW / stock_30min / 2005-09-12
file: by_date/stock_30min/2005/2005-09-12.parquet size: 840 KB rows: 45,947 symbols: 2,070
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-09-12 08:00:00 | AAPL | Stock | 1.8339 | 1.8339 | 1.8257 | 1.8286 | 272972.0 |
| 2005-09-12 08:30:00 | AAPL | Stock | 1.825 | 1.8318 | 1.8221 | 1.8293 | 1045240.0 |
| 2005-09-12 09:00:00 | AAPL | Stock | 1.8296 | 1.8296 | 1.8232 | 1.8232 | 3195640.0 |
| 2005-09-12 09:30:00 | AAPL | Stock | 1.825 | 1.8375 | 1.8161 | 1.8225 | 99132068.0 |
| 2005-09-12 10:00:00 | AAPL | Stock | 1.8225 | 1.8314 | 1.8175 | 1.8279 | 46133304.0 |
| 2005-09-12 10:30:00 | AAPL | Stock | 1.8275 | 1.8307 | 1.8193 | 1.8207 | 30593332.0 |
| 2005-09-12 11:00:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8111 | 1.8193 | 35949312.0 |
| 2005-09-12 11:30:00 | AAPL | Stock | 1.8193 | 1.82 | 1.8064 | 1.8154 | 34395396.0 |
| 2005-09-12 12:00:00 | AAPL | Stock | 1.8157 | 1.8304 | 1.8143 | 1.8293 | 23774268.0 |
| 2005-09-12 12:30:00 | AAPL | Stock | 1.8293 | 1.8354 | 1.8271 | 1.8271 | 22719676.0 |
| 2005-09-12 13:00:00 | AAPL | Stock | 1.8275 | 1.8304 | 1.8236 | 1.8236 | 9786308.0 |
| 2005-09-12 13:30:00 | AAPL | Stock | 1.8236 | 1.8296 | 1.8218 | 1.8221 | 11956196.0 |
| 2005-09-12 14:00:00 | AAPL | Stock | 1.8221 | 1.8264 | 1.8196 | 1.825 | 13799912.0 |
| 2005-09-12 14:30:00 | AAPL | Stock | 1.825 | 1.8332 | 1.825 | 1.8329 | 21588196.0 |
| 2005-09-12 15:00:00 | AAPL | Stock | 1.8329 | 1.8411 | 1.8293 | 1.8382 | 38416308.0 |
| 2005-09-12 15:30:00 | AAPL | Stock | 1.8382 | 1.8439 | 1.835 | 1.8357 | 49937748.0 |
| 2005-09-12 16:00:00 | AAPL | Stock | 1.8357 | 1.8364 | 1.8339 | 1.8361 | 674408.0 |
| 2005-09-12 16:30:00 | AAPL | Stock | 1.8368 | 1.8375 | 1.8354 | 1.8361 | 140700.0 |
| 2005-09-12 17:30:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 2800.0 |
| 2005-09-12 18:00:00 | AAPL | Stock | 1.8354 | 1.8375 | 1.8354 | 1.8375 | 420308.0 |
| 2005-09-12 08:00:00 | MSFT | Stock | 26.5 | 26.63 | 26.5 | 26.62 | 6900.0 |
| 2005-09-12 08:30:00 | MSFT | Stock | 26.6 | 26.62 | 26.6 | 26.6 | 28144.0 |
| 2005-09-12 09:00:00 | MSFT | Stock | 26.59 | 26.61 | 26.55 | 26.58 | 74740.0 |
| 2005-09-12 09:30:00 | MSFT | Stock | 26.62 | 26.73 | 26.58 | 26.63 | 4852344.0 |
| 2005-09-12 10:00:00 | MSFT | Stock | 26.64 | 26.68 | 26.62 | 26.66 | 1902780.0 |
| 2005-09-12 10:30:00 | MSFT | Stock | 26.669 | 26.7 | 26.63 | 26.7 | 2263324.0 |
| 2005-09-12 11:00:00 | MSFT | Stock | 26.7 | 26.75 | 26.65 | 26.68 | 2057651.0 |
| 2005-09-12 11:30:00 | MSFT | Stock | 26.67 | 26.68 | 26.55 | 26.56 | 2599257.0 |
| 2005-09-12 12:00:00 | MSFT | Stock | 26.56 | 26.66 | 26.53 | 26.65 | 4035511.0 |
| 2005-09-12 12:30:00 | MSFT | Stock | 26.64 | 26.66 | 26.57 | 26.58 | 2730520.0 |
| 2005-09-12 13:00:00 | MSFT | Stock | 26.57 | 26.61 | 26.549 | 26.58 | 2299707.0 |
| 2005-09-12 13:30:00 | MSFT | Stock | 26.58 | 26.59 | 26.52 | 26.52 | 2035501.0 |
| 2005-09-12 14:00:00 | MSFT | Stock | 26.53 | 26.58 | 26.519 | 26.56 | 2305932.0 |
| 2005-09-12 14:30:00 | MSFT | Stock | 26.56 | 26.66 | 26.55 | 26.65 | 3845565.0 |
| 2005-09-12 15:00:00 | MSFT | Stock | 26.65 | 26.66 | 26.6 | 26.61 | 3924144.0 |
| 2005-09-12 15:30:00 | MSFT | Stock | 26.61 | 26.63 | 26.6 | 26.61 | 3940561.0 |
| 2005-09-12 16:00:00 | MSFT | Stock | 26.6 | 26.62 | 26.56 | 26.61 | 278664.0 |
| 2005-09-12 16:30:00 | MSFT | Stock | 26.62 | 26.62 | 26.55 | 26.57 | 33100.0 |
| 2005-09-12 17:00:00 | MSFT | Stock | 26.57 | 26.59 | 26.57 | 26.59 | 1511.0 |
| 2005-09-12 17:30:00 | MSFT | Stock | 26.6 | 26.62 | 26.6 | 26.61 | 7840.0 |
| 2005-09-12 18:00:00 | MSFT | Stock | 26.61 | 26.62 | 26.61 | 26.62 | 157016.0 |
| 2005-09-12 09:30:00 | NVDA | Stock | 0.2685 | 0.2693 | 0.2663 | 0.2687 | 52665240.0 |
| 2005-09-12 10:00:00 | NVDA | Stock | 0.2688 | 0.269 | 0.2667 | 0.2675 | 60335400.0 |
| 2005-09-12 10:30:00 | NVDA | Stock | 0.2675 | 0.2687 | 0.2667 | 0.2678 | 80043360.0 |
| 2005-09-12 11:00:00 | NVDA | Stock | 0.2678 | 0.268 | 0.2662 | 0.2672 | 34865280.0 |
| 2005-09-12 11:30:00 | NVDA | Stock | 0.2672 | 0.2677 | 0.2652 | 0.2654 | 34031520.0 |
| 2005-09-12 12:00:00 | NVDA | Stock | 0.2654 | 0.2687 | 0.2654 | 0.2662 | 32996760.0 |
| 2005-09-12 12:30:00 | NVDA | Stock | 0.2662 | 0.2663 | 0.2652 | 0.2659 | 24557040.0 |
| 2005-09-12 13:00:00 | NVDA | Stock | 0.266 | 0.2661 | 0.2652 | 0.2654 | 17556840.0 |
| 2005-09-12 13:30:00 | NVDA | Stock | 0.2654 | 0.2657 | 0.2652 | 0.2652 | 18018840.0 |
> showing 50 of 45,947 rows — these rows as CSV