PREVIEW / stock_30min / 2007-02-16
file: by_date/stock_30min/2007/2007-02-16.parquet size: 976 KB rows: 52,835 symbols: 2,508
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-16 07:30:00 | AAPL | Stock | 3.045 | 3.045 | 3.0357 | 3.0375 | 16800.0 |
| 2007-02-16 08:00:00 | AAPL | Stock | 3.0379 | 3.0414 | 3.0357 | 3.0364 | 321776.0 |
| 2007-02-16 08:30:00 | AAPL | Stock | 3.0361 | 3.0421 | 3.0361 | 3.0371 | 498764.0 |
| 2007-02-16 09:00:00 | AAPL | Stock | 3.0371 | 3.0446 | 3.0318 | 3.0446 | 602084.0 |
| 2007-02-16 09:30:00 | AAPL | Stock | 3.0446 | 3.0504 | 3.0236 | 3.035 | 92111572.0 |
| 2007-02-16 10:00:00 | AAPL | Stock | 3.035 | 3.0386 | 3.0304 | 3.0357 | 31115980.0 |
| 2007-02-16 10:30:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0307 | 3.0329 | 23115848.0 |
| 2007-02-16 11:00:00 | AAPL | Stock | 3.0329 | 3.0357 | 3.0286 | 3.0289 | 20852552.0 |
| 2007-02-16 11:30:00 | AAPL | Stock | 3.0289 | 3.0325 | 3.0286 | 3.0311 | 14278264.0 |
| 2007-02-16 12:00:00 | AAPL | Stock | 3.0311 | 3.0332 | 3.0293 | 3.0325 | 12106584.0 |
| 2007-02-16 12:30:00 | AAPL | Stock | 3.0325 | 3.0329 | 3.0246 | 3.0296 | 21714840.0 |
| 2007-02-16 13:00:00 | AAPL | Stock | 3.0296 | 3.0336 | 3.0279 | 3.0318 | 19592300.0 |
| 2007-02-16 13:30:00 | AAPL | Stock | 3.0321 | 3.0346 | 3.0307 | 3.0329 | 16250108.0 |
| 2007-02-16 14:00:00 | AAPL | Stock | 3.0332 | 3.0343 | 3.0321 | 3.0343 | 23270128.0 |
| 2007-02-16 14:30:00 | AAPL | Stock | 3.0343 | 3.0354 | 3.0321 | 3.0329 | 11005120.0 |
| 2007-02-16 15:00:00 | AAPL | Stock | 3.0329 | 3.0339 | 3.0314 | 3.0336 | 13330660.0 |
| 2007-02-16 15:30:00 | AAPL | Stock | 3.0336 | 3.0364 | 3.0271 | 3.0271 | 62485612.0 |
| 2007-02-16 16:00:00 | AAPL | Stock | 3.0296 | 3.0354 | 3.0289 | 3.0321 | 5520116.0 |
| 2007-02-16 16:30:00 | AAPL | Stock | 3.0321 | 3.0339 | 3.0293 | 3.0304 | 624400.0 |
| 2007-02-16 17:00:00 | AAPL | Stock | 3.0296 | 3.0304 | 3.0293 | 3.0293 | 18986856.0 |
| 2007-02-16 17:30:00 | AAPL | Stock | 3.0318 | 3.0318 | 3.0296 | 3.0296 | 185360.0 |
| 2007-02-16 18:00:00 | AAPL | Stock | 3.0314 | 3.0321 | 3.03 | 3.03 | 120204.0 |
| 2007-02-16 18:30:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 16800.0 |
| 2007-02-16 19:00:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 42000.0 |
| 2007-02-16 19:30:00 | AAPL | Stock | 3.0318 | 3.0318 | 3.0304 | 3.0304 | 21140.0 |
| 2007-02-16 06:00:00 | MSFT | Stock | 28.81 | 28.81 | 28.81 | 28.81 | 2500.0 |
| 2007-02-16 06:30:00 | MSFT | Stock | 28.84 | 28.84 | 28.84 | 28.84 | 2000.0 |
| 2007-02-16 07:00:00 | MSFT | Stock | 28.85 | 29.09 | 28.85 | 29.09 | 18800.0 |
| 2007-02-16 07:30:00 | MSFT | Stock | 29.01 | 29.01 | 28.99 | 29.0 | 123490.0 |
| 2007-02-16 08:00:00 | MSFT | Stock | 29.0 | 29.07 | 28.99 | 29.05 | 358459.0 |
| 2007-02-16 08:30:00 | MSFT | Stock | 29.06 | 29.06 | 28.98 | 29.0 | 486090.0 |
| 2007-02-16 09:00:00 | MSFT | Stock | 28.99 | 29.01 | 28.81 | 28.91 | 1084576.0 |
| 2007-02-16 09:30:00 | MSFT | Stock | 28.905 | 28.94 | 28.75 | 28.78 | 29132689.0 |
| 2007-02-16 10:00:00 | MSFT | Stock | 28.78 | 28.79 | 28.65 | 28.74 | 15549488.0 |
| 2007-02-16 10:30:00 | MSFT | Stock | 28.74 | 28.8 | 28.73 | 28.78 | 9311895.0 |
| 2007-02-16 11:00:00 | MSFT | Stock | 28.78 | 28.91 | 28.75 | 28.78 | 9308208.0 |
| 2007-02-16 11:30:00 | MSFT | Stock | 28.79 | 28.88 | 28.75 | 28.773 | 3220148.0 |
| 2007-02-16 12:00:00 | MSFT | Stock | 28.77 | 28.83 | 28.75 | 28.8 | 2875367.0 |
| 2007-02-16 12:30:00 | MSFT | Stock | 28.8 | 28.8 | 28.75 | 28.77 | 3144287.0 |
| 2007-02-16 13:00:00 | MSFT | Stock | 28.78 | 28.79 | 28.75 | 28.78 | 5306706.0 |
| 2007-02-16 13:30:00 | MSFT | Stock | 28.77 | 28.88 | 28.67 | 28.8 | 2482281.0 |
| 2007-02-16 14:00:00 | MSFT | Stock | 28.8 | 28.82 | 28.78 | 28.8 | 4013887.0 |
| 2007-02-16 14:30:00 | MSFT | Stock | 28.8 | 28.801 | 28.76 | 28.77 | 2590427.0 |
| 2007-02-16 15:00:00 | MSFT | Stock | 28.763 | 28.79 | 28.76 | 28.79 | 3333395.0 |
| 2007-02-16 15:30:00 | MSFT | Stock | 28.785 | 28.8 | 28.71 | 28.71 | 10334996.0 |
| 2007-02-16 16:00:00 | MSFT | Stock | 28.72 | 28.75 | 28.72 | 28.74 | 257988.0 |
| 2007-02-16 16:30:00 | MSFT | Stock | 28.74 | 28.75 | 28.72 | 28.72 | 6724.0 |
| 2007-02-16 17:00:00 | MSFT | Stock | 28.74 | 28.74 | 28.71 | 28.74 | 3254811.0 |
| 2007-02-16 17:30:00 | MSFT | Stock | 28.74 | 28.74 | 28.72 | 28.74 | 22059.0 |
| 2007-02-16 18:00:00 | MSFT | Stock | 28.74 | 28.74 | 28.72 | 28.72 | 13718.0 |
> showing 50 of 52,835 rows — these rows as CSV