PREVIEW / stock_30min / 2009-04-22
file: by_date/stock_30min/2009/2009-04-22.parquet size: 1.3 MB rows: 70,367 symbols: 3,312
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-22 05:00:00 | AAPL | Stock | 4.3171 | 4.3171 | 4.3171 | 4.3171 | 5600.0 |
| 2009-04-22 06:30:00 | AAPL | Stock | 4.3125 | 4.3214 | 4.3125 | 4.3214 | 19600.0 |
| 2009-04-22 07:00:00 | AAPL | Stock | 4.3325 | 4.3325 | 4.3196 | 4.3196 | 30520.0 |
| 2009-04-22 07:30:00 | AAPL | Stock | 4.3482 | 4.3571 | 4.3375 | 4.3482 | 116172.0 |
| 2009-04-22 08:00:00 | AAPL | Stock | 4.3429 | 4.3661 | 4.3361 | 4.3536 | 1589644.0 |
| 2009-04-22 08:30:00 | AAPL | Stock | 4.3575 | 4.3882 | 4.3571 | 4.3821 | 1502788.0 |
| 2009-04-22 09:00:00 | AAPL | Stock | 4.3789 | 4.3893 | 4.3736 | 4.3796 | 1722420.0 |
| 2009-04-22 09:30:00 | AAPL | Stock | 4.3786 | 4.4468 | 4.3668 | 4.4431 | 106526616.0 |
| 2009-04-22 10:00:00 | AAPL | Stock | 4.4429 | 4.4768 | 4.4325 | 4.4654 | 70005684.0 |
| 2009-04-22 10:30:00 | AAPL | Stock | 4.4657 | 4.4696 | 4.4393 | 4.4485 | 43478288.0 |
| 2009-04-22 11:00:00 | AAPL | Stock | 4.4489 | 4.4625 | 4.4204 | 4.4479 | 39248972.0 |
| 2009-04-22 11:30:00 | AAPL | Stock | 4.4486 | 4.4625 | 4.4481 | 4.4557 | 27857312.0 |
| 2009-04-22 12:00:00 | AAPL | Stock | 4.4557 | 4.4696 | 4.4529 | 4.4561 | 33615064.0 |
| 2009-04-22 12:30:00 | AAPL | Stock | 4.4593 | 4.4629 | 4.3957 | 4.4118 | 48975696.0 |
| 2009-04-22 13:00:00 | AAPL | Stock | 4.4114 | 4.4536 | 4.3964 | 4.4111 | 35952728.0 |
| 2009-04-22 13:30:00 | AAPL | Stock | 4.4111 | 4.4254 | 4.3736 | 4.3834 | 46090464.0 |
| 2009-04-22 14:00:00 | AAPL | Stock | 4.3834 | 4.4311 | 4.3754 | 4.4286 | 46915176.0 |
| 2009-04-22 14:30:00 | AAPL | Stock | 4.4296 | 4.4464 | 4.425 | 4.4268 | 46256868.0 |
| 2009-04-22 15:00:00 | AAPL | Stock | 4.4268 | 4.4454 | 4.4121 | 4.4179 | 58750188.0 |
| 2009-04-22 15:30:00 | AAPL | Stock | 4.4188 | 4.4261 | 4.3286 | 4.3411 | 119188132.0 |
| 2009-04-22 16:00:00 | AAPL | Stock | 4.33 | 4.4226 | 4.2857 | 4.3571 | 23704016.0 |
| 2009-04-22 16:30:00 | AAPL | Stock | 4.4393 | 4.5339 | 4.3186 | 4.4821 | 96954172.0 |
| 2009-04-22 17:00:00 | AAPL | Stock | 4.4836 | 4.5171 | 4.3779 | 4.5004 | 47903940.0 |
| 2009-04-22 17:30:00 | AAPL | Stock | 4.5018 | 4.5143 | 4.4286 | 4.4436 | 14314384.0 |
| 2009-04-22 18:00:00 | AAPL | Stock | 4.4418 | 4.4632 | 4.4321 | 4.4596 | 3438652.0 |
| 2009-04-22 18:30:00 | AAPL | Stock | 4.4571 | 4.4714 | 4.4539 | 4.4639 | 1908872.0 |
| 2009-04-22 19:00:00 | AAPL | Stock | 4.4636 | 4.4679 | 4.4554 | 4.4554 | 708680.0 |
| 2009-04-22 19:30:00 | AAPL | Stock | 4.4571 | 4.475 | 4.4557 | 4.4679 | 1474928.0 |
| 2009-04-22 08:00:00 | MSFT | Stock | 18.88 | 18.88 | 18.8 | 18.8 | 7392.0 |
| 2009-04-22 08:30:00 | MSFT | Stock | 18.8 | 18.95 | 18.76 | 18.76 | 8230.0 |
| 2009-04-22 09:00:00 | MSFT | Stock | 18.8 | 18.85 | 18.7 | 18.76 | 17053.0 |
| 2009-04-22 09:30:00 | MSFT | Stock | 18.78 | 19.0 | 18.7 | 18.97 | 5332608.0 |
| 2009-04-22 10:00:00 | MSFT | Stock | 18.97 | 19.19 | 18.96 | 19.1 | 5667869.0 |
| 2009-04-22 10:30:00 | MSFT | Stock | 19.11 | 19.14 | 18.89 | 18.908 | 4419806.0 |
| 2009-04-22 11:00:00 | MSFT | Stock | 18.91 | 19.03 | 18.849 | 18.93 | 2402536.0 |
| 2009-04-22 11:30:00 | MSFT | Stock | 18.93 | 19.1 | 18.91 | 18.96 | 3496295.0 |
| 2009-04-22 12:00:00 | MSFT | Stock | 18.96 | 18.96 | 18.8 | 18.83 | 3317108.0 |
| 2009-04-22 12:30:00 | MSFT | Stock | 18.82 | 18.87 | 18.76 | 18.81 | 2320990.0 |
| 2009-04-22 13:00:00 | MSFT | Stock | 18.8 | 18.92 | 18.8 | 18.9 | 4396084.0 |
| 2009-04-22 13:30:00 | MSFT | Stock | 18.9 | 18.96 | 18.83 | 18.84 | 4250928.0 |
| 2009-04-22 14:00:00 | MSFT | Stock | 18.83 | 19.01 | 18.83 | 18.98 | 3215671.0 |
| 2009-04-22 14:30:00 | MSFT | Stock | 18.98 | 19.08 | 18.98 | 19.03 | 3047570.0 |
| 2009-04-22 15:00:00 | MSFT | Stock | 19.03 | 19.17 | 18.97 | 19.01 | 4802665.0 |
| 2009-04-22 15:30:00 | MSFT | Stock | 19.0 | 19.06 | 18.72 | 18.77 | 8586962.0 |
| 2009-04-22 16:00:00 | MSFT | Stock | 18.77 | 19.061 | 18.52 | 18.7 | 2153891.0 |
| 2009-04-22 16:30:00 | MSFT | Stock | 18.7 | 18.8 | 18.67 | 18.8 | 223609.0 |
| 2009-04-22 17:00:00 | MSFT | Stock | 18.8 | 18.99 | 18.8 | 18.95 | 46900.0 |
| 2009-04-22 17:30:00 | MSFT | Stock | 18.94 | 19.0 | 18.94 | 19.0 | 25813.0 |
| 2009-04-22 18:00:00 | MSFT | Stock | 19.0 | 19.0 | 18.78 | 18.97 | 177695.0 |
| 2009-04-22 18:30:00 | MSFT | Stock | 18.98 | 18.98 | 18.97 | 18.97 | 4845.0 |
> showing 50 of 70,367 rows — these rows as CSV