PREVIEW / stock_30min / 2009-03-13
file: by_date/stock_30min/2009/2009-03-13.parquet size: 1.2 MB rows: 67,276 symbols: 3,325
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-03-13 04:30:00 | AAPL | Stock | 3.4621 | 3.4621 | 3.4621 | 3.4621 | 5600.0 |
| 2009-03-13 05:30:00 | AAPL | Stock | 3.4336 | 3.4336 | 3.4336 | 3.4336 | 12600.0 |
| 2009-03-13 06:00:00 | AAPL | Stock | 3.4307 | 3.4307 | 3.4307 | 3.4307 | 2800.0 |
| 2009-03-13 07:00:00 | AAPL | Stock | 3.4554 | 3.4732 | 3.4554 | 3.4732 | 19600.0 |
| 2009-03-13 07:30:00 | AAPL | Stock | 3.4632 | 3.4707 | 3.4411 | 3.4411 | 275016.0 |
| 2009-03-13 08:00:00 | AAPL | Stock | 3.4625 | 3.4686 | 3.4464 | 3.4571 | 734804.0 |
| 2009-03-13 08:30:00 | AAPL | Stock | 3.4571 | 3.4707 | 3.4286 | 3.4304 | 997500.0 |
| 2009-03-13 09:00:00 | AAPL | Stock | 3.4304 | 3.4393 | 3.4214 | 3.4393 | 3363052.0 |
| 2009-03-13 09:30:00 | AAPL | Stock | 3.4393 | 3.4714 | 3.4111 | 3.4661 | 103529468.0 |
| 2009-03-13 10:00:00 | AAPL | Stock | 3.4661 | 3.4686 | 3.4196 | 3.4296 | 62591312.0 |
| 2009-03-13 10:30:00 | AAPL | Stock | 3.4293 | 3.4429 | 3.4036 | 3.4089 | 55554296.0 |
| 2009-03-13 11:00:00 | AAPL | Stock | 3.4096 | 3.4221 | 3.3932 | 3.4211 | 44858996.0 |
| 2009-03-13 11:30:00 | AAPL | Stock | 3.4211 | 3.4214 | 3.4004 | 3.4129 | 30073904.0 |
| 2009-03-13 12:00:00 | AAPL | Stock | 3.4132 | 3.4211 | 3.3986 | 3.4129 | 31269336.0 |
| 2009-03-13 12:30:00 | AAPL | Stock | 3.4121 | 3.4236 | 3.4039 | 3.4211 | 23593612.0 |
| 2009-03-13 13:00:00 | AAPL | Stock | 3.4211 | 3.4286 | 3.4182 | 3.4243 | 20185732.0 |
| 2009-03-13 13:30:00 | AAPL | Stock | 3.4243 | 3.4279 | 3.4125 | 3.4186 | 22619296.0 |
| 2009-03-13 14:00:00 | AAPL | Stock | 3.4182 | 3.4286 | 3.4018 | 3.4121 | 31745476.0 |
| 2009-03-13 14:30:00 | AAPL | Stock | 3.4118 | 3.4268 | 3.4071 | 3.4107 | 45764712.0 |
| 2009-03-13 15:00:00 | AAPL | Stock | 3.4107 | 3.425 | 3.4086 | 3.4214 | 37230788.0 |
| 2009-03-13 15:30:00 | AAPL | Stock | 3.4212 | 3.4261 | 3.4057 | 3.4261 | 62366528.0 |
| 2009-03-13 16:00:00 | AAPL | Stock | 3.42 | 3.4286 | 3.4172 | 3.4261 | 14231028.0 |
| 2009-03-13 16:30:00 | AAPL | Stock | 3.4411 | 3.4411 | 3.4149 | 3.4275 | 1046388.0 |
| 2009-03-13 17:00:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4243 | 3.4243 | 41440.0 |
| 2009-03-13 17:30:00 | AAPL | Stock | 3.4246 | 3.4246 | 3.4246 | 3.4246 | 2800.0 |
| 2009-03-13 18:00:00 | AAPL | Stock | 3.425 | 3.4275 | 3.425 | 3.425 | 404404.0 |
| 2009-03-13 18:30:00 | AAPL | Stock | 3.4275 | 3.4286 | 3.4275 | 3.4286 | 8540.0 |
| 2009-03-13 19:00:00 | AAPL | Stock | 3.4254 | 3.4261 | 3.4254 | 3.4254 | 11200.0 |
| 2009-03-13 19:30:00 | AAPL | Stock | 3.4268 | 3.4286 | 3.4254 | 3.4254 | 69328.0 |
| 2009-03-13 06:30:00 | MSFT | Stock | 17.24 | 17.24 | 17.24 | 17.24 | 250.0 |
| 2009-03-13 07:30:00 | MSFT | Stock | 17.15 | 17.15 | 17.14 | 17.15 | 1925.0 |
| 2009-03-13 08:00:00 | MSFT | Stock | 17.16 | 17.16 | 17.01 | 17.13 | 9767.0 |
| 2009-03-13 08:30:00 | MSFT | Stock | 17.13 | 17.17 | 16.98 | 16.98 | 18812.0 |
| 2009-03-13 09:00:00 | MSFT | Stock | 16.95 | 17.04 | 16.92 | 16.99 | 100044.0 |
| 2009-03-13 09:30:00 | MSFT | Stock | 16.99 | 17.05 | 16.632 | 16.725 | 7918589.0 |
| 2009-03-13 10:00:00 | MSFT | Stock | 16.73 | 16.84 | 16.52 | 16.54 | 10292553.0 |
| 2009-03-13 10:30:00 | MSFT | Stock | 16.54 | 16.89 | 16.48 | 16.52 | 7550130.0 |
| 2009-03-13 11:00:00 | MSFT | Stock | 16.52 | 16.58 | 16.41 | 16.48 | 5142678.0 |
| 2009-03-13 11:30:00 | MSFT | Stock | 16.48 | 16.49 | 16.21 | 16.27 | 7787608.0 |
| 2009-03-13 12:00:00 | MSFT | Stock | 16.26 | 16.34 | 16.18 | 16.27 | 4156851.0 |
| 2009-03-13 12:30:00 | MSFT | Stock | 16.268 | 16.32 | 16.23 | 16.3 | 3738422.0 |
| 2009-03-13 13:00:00 | MSFT | Stock | 16.3 | 16.47 | 16.28 | 16.442 | 2945412.0 |
| 2009-03-13 13:30:00 | MSFT | Stock | 16.45 | 16.45 | 16.31 | 16.36 | 3181381.0 |
| 2009-03-13 14:00:00 | MSFT | Stock | 16.369 | 16.42 | 16.27 | 16.36 | 3658744.0 |
| 2009-03-13 14:30:00 | MSFT | Stock | 16.36 | 16.5 | 16.34 | 16.47 | 5536238.0 |
| 2009-03-13 15:00:00 | MSFT | Stock | 16.46 | 16.61 | 16.46 | 16.528 | 5359089.0 |
| 2009-03-13 15:30:00 | MSFT | Stock | 16.52 | 16.68 | 16.41 | 16.63 | 10096526.0 |
| 2009-03-13 16:00:00 | MSFT | Stock | 16.65 | 16.68 | 16.453 | 16.61 | 3748595.0 |
| 2009-03-13 16:30:00 | MSFT | Stock | 16.6 | 16.65 | 16.428 | 16.65 | 248020.0 |
| 2009-03-13 17:00:00 | MSFT | Stock | 16.64 | 16.65 | 16.62 | 16.62 | 6626.0 |
> showing 50 of 67,276 rows — these rows as CSV