PREVIEW / stock_30min / 2006-11-15
file: by_date/stock_30min/2006/2006-11-15.parquet size: 965 KB rows: 52,042 symbols: 2,440
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-15 07:00:00 | AAPL | Stock | 3.0407 | 3.0429 | 3.0368 | 3.0393 | 82600.0 |
| 2006-11-15 07:30:00 | AAPL | Stock | 3.0393 | 3.0464 | 3.0393 | 3.0464 | 275800.0 |
| 2006-11-15 08:00:00 | AAPL | Stock | 3.0496 | 3.0536 | 3.0429 | 3.0464 | 1248324.0 |
| 2006-11-15 08:30:00 | AAPL | Stock | 3.0464 | 3.0521 | 3.045 | 3.0511 | 896560.0 |
| 2006-11-15 09:00:00 | AAPL | Stock | 3.0511 | 3.0529 | 3.0368 | 3.0375 | 2418836.0 |
| 2006-11-15 09:30:00 | AAPL | Stock | 3.0375 | 3.0675 | 3.0371 | 3.0621 | 81894904.0 |
| 2006-11-15 10:00:00 | AAPL | Stock | 3.0621 | 3.0679 | 3.05 | 3.0536 | 55206788.0 |
| 2006-11-15 10:30:00 | AAPL | Stock | 3.0536 | 3.0589 | 3.0393 | 3.0393 | 39368336.0 |
| 2006-11-15 11:00:00 | AAPL | Stock | 3.0393 | 3.0439 | 3.0268 | 3.035 | 59205048.0 |
| 2006-11-15 11:30:00 | AAPL | Stock | 3.0354 | 3.0433 | 3.0293 | 3.0362 | 33945520.0 |
| 2006-11-15 12:00:00 | AAPL | Stock | 3.0361 | 3.0486 | 3.0357 | 3.0396 | 36220940.0 |
| 2006-11-15 12:30:00 | AAPL | Stock | 3.0393 | 3.0393 | 3.0268 | 3.0311 | 49046312.0 |
| 2006-11-15 13:00:00 | AAPL | Stock | 3.0311 | 3.0375 | 3.0089 | 3.0157 | 50916320.0 |
| 2006-11-15 13:30:00 | AAPL | Stock | 3.0157 | 3.0282 | 3.0146 | 3.0218 | 42798280.0 |
| 2006-11-15 14:00:00 | AAPL | Stock | 3.0218 | 3.0346 | 3.0132 | 3.0229 | 48154428.0 |
| 2006-11-15 14:30:00 | AAPL | Stock | 3.0229 | 3.0279 | 3.0061 | 3.0089 | 49587916.0 |
| 2006-11-15 15:00:00 | AAPL | Stock | 3.0089 | 3.0157 | 3.005 | 3.015 | 33200160.0 |
| 2006-11-15 15:30:00 | AAPL | Stock | 3.015 | 3.0179 | 3.0 | 3.0014 | 53013856.0 |
| 2006-11-15 16:00:00 | AAPL | Stock | 3.0 | 3.0032 | 3.0 | 3.0032 | 3635856.0 |
| 2006-11-15 16:30:00 | AAPL | Stock | 3.0021 | 3.0054 | 3.0021 | 3.0054 | 241192.0 |
| 2006-11-15 17:00:00 | AAPL | Stock | 3.0036 | 3.0039 | 3.0004 | 3.0014 | 89628.0 |
| 2006-11-15 17:30:00 | AAPL | Stock | 3.0039 | 3.0064 | 3.0014 | 3.0064 | 56420.0 |
| 2006-11-15 18:00:00 | AAPL | Stock | 3.0064 | 3.0321 | 3.0064 | 3.0268 | 3488996.0 |
| 2006-11-15 18:30:00 | AAPL | Stock | 3.0257 | 3.0286 | 3.0246 | 3.0271 | 365036.0 |
| 2006-11-15 19:00:00 | AAPL | Stock | 3.0257 | 3.0275 | 3.0257 | 3.0264 | 235732.0 |
| 2006-11-15 19:30:00 | AAPL | Stock | 3.0264 | 3.0268 | 3.0243 | 3.025 | 76776.0 |
| 2006-11-15 07:00:00 | MSFT | Stock | 29.11 | 29.11 | 29.11 | 29.11 | 300.0 |
| 2006-11-15 07:30:00 | MSFT | Stock | 29.2 | 29.2 | 29.2 | 29.2 | 394.0 |
| 2006-11-15 08:00:00 | MSFT | Stock | 29.12 | 29.15 | 29.11 | 29.15 | 337711.0 |
| 2006-11-15 08:30:00 | MSFT | Stock | 29.15 | 29.15 | 29.13 | 29.13 | 7100.0 |
| 2006-11-15 09:00:00 | MSFT | Stock | 29.13 | 29.15 | 29.1 | 29.12 | 74328.0 |
| 2006-11-15 09:30:00 | MSFT | Stock | 29.125 | 29.33 | 29.11 | 29.257 | 7418703.0 |
| 2006-11-15 10:00:00 | MSFT | Stock | 29.25 | 29.36 | 29.13 | 29.35 | 5632588.0 |
| 2006-11-15 10:30:00 | MSFT | Stock | 29.345 | 29.35 | 29.27 | 29.34 | 3707859.0 |
| 2006-11-15 11:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.32 | 29.34 | 2478455.0 |
| 2006-11-15 11:30:00 | MSFT | Stock | 29.34 | 29.34 | 29.26 | 29.28 | 2886053.0 |
| 2006-11-15 12:00:00 | MSFT | Stock | 29.28 | 29.33 | 29.26 | 29.28 | 3002512.0 |
| 2006-11-15 12:30:00 | MSFT | Stock | 29.28 | 29.28 | 29.23 | 29.23 | 3231260.0 |
| 2006-11-15 13:00:00 | MSFT | Stock | 29.23 | 29.25 | 29.22 | 29.24 | 1187288.0 |
| 2006-11-15 13:30:00 | MSFT | Stock | 29.24 | 29.27 | 29.24 | 29.248 | 2912939.0 |
| 2006-11-15 14:00:00 | MSFT | Stock | 29.25 | 29.3 | 29.22 | 29.24 | 5282546.0 |
| 2006-11-15 14:30:00 | MSFT | Stock | 29.23 | 29.27 | 29.18 | 29.21 | 5526102.0 |
| 2006-11-15 15:00:00 | MSFT | Stock | 29.215 | 29.26 | 29.21 | 29.21 | 3063294.0 |
| 2006-11-15 15:30:00 | MSFT | Stock | 29.22 | 29.27 | 29.11 | 29.11 | 7760537.0 |
| 2006-11-15 16:00:00 | MSFT | Stock | 29.11 | 29.312 | 29.11 | 29.13 | 1043930.0 |
| 2006-11-15 16:30:00 | MSFT | Stock | 29.11 | 29.13 | 29.11 | 29.12 | 400.0 |
| 2006-11-15 17:00:00 | MSFT | Stock | 29.11 | 29.13 | 29.1 | 29.1 | 14820.0 |
| 2006-11-15 18:00:00 | MSFT | Stock | 29.12 | 29.12 | 29.02 | 29.06 | 33649.0 |
| 2006-11-15 18:30:00 | MSFT | Stock | 29.07 | 29.09 | 29.05 | 29.05 | 1980.0 |
| 2006-11-15 19:00:00 | MSFT | Stock | 29.03 | 29.09 | 29.03 | 29.09 | 1475.0 |
> showing 50 of 52,042 rows — these rows as CSV