PREVIEW / stock_30min / 2007-11-21
file: by_date/stock_30min/2007/2007-11-21.parquet size: 1.2 MB rows: 67,755 symbols: 3,193
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-11-21 05:00:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 11928.0 |
| 2007-11-21 06:00:00 | AAPL | Stock | 5.9314 | 5.9314 | 5.9314 | 5.9314 | 6328.0 |
| 2007-11-21 07:00:00 | AAPL | Stock | 5.9493 | 5.9771 | 5.9071 | 5.9071 | 239344.0 |
| 2007-11-21 07:30:00 | AAPL | Stock | 5.9286 | 5.9714 | 5.9286 | 5.9432 | 388724.0 |
| 2007-11-21 08:00:00 | AAPL | Stock | 5.9446 | 5.9643 | 5.9182 | 5.92 | 3159380.0 |
| 2007-11-21 08:30:00 | AAPL | Stock | 5.9214 | 5.94 | 5.9125 | 5.9361 | 3747772.0 |
| 2007-11-21 09:00:00 | AAPL | Stock | 5.9386 | 5.9393 | 5.9018 | 5.9214 | 5275788.0 |
| 2007-11-21 09:30:00 | AAPL | Stock | 5.9236 | 5.9946 | 5.8929 | 5.9775 | 155920520.0 |
| 2007-11-21 10:00:00 | AAPL | Stock | 5.9775 | 6.0 | 5.9404 | 5.9607 | 93732184.0 |
| 2007-11-21 10:30:00 | AAPL | Stock | 5.9618 | 5.9682 | 5.8929 | 5.915 | 97870220.0 |
| 2007-11-21 11:00:00 | AAPL | Stock | 5.915 | 5.9464 | 5.8811 | 5.9464 | 74999512.0 |
| 2007-11-21 11:30:00 | AAPL | Stock | 5.9464 | 5.9643 | 5.9221 | 5.9307 | 69615364.0 |
| 2007-11-21 12:00:00 | AAPL | Stock | 5.9314 | 5.9714 | 5.9239 | 5.96 | 75353936.0 |
| 2007-11-21 12:30:00 | AAPL | Stock | 5.96 | 6.0607 | 5.9486 | 6.0482 | 104252008.0 |
| 2007-11-21 13:00:00 | AAPL | Stock | 6.047 | 6.0675 | 6.0089 | 6.0225 | 95737376.0 |
| 2007-11-21 13:30:00 | AAPL | Stock | 6.0225 | 6.0571 | 5.9627 | 6.0482 | 55042652.0 |
| 2007-11-21 14:00:00 | AAPL | Stock | 6.0471 | 6.1036 | 6.0443 | 6.0846 | 78552012.0 |
| 2007-11-21 14:30:00 | AAPL | Stock | 6.0857 | 6.1457 | 6.0836 | 6.1386 | 84026572.0 |
| 2007-11-21 15:00:00 | AAPL | Stock | 6.1386 | 6.1554 | 6.04 | 6.06 | 101232320.0 |
| 2007-11-21 15:30:00 | AAPL | Stock | 6.0607 | 6.0889 | 5.9879 | 6.0104 | 99562624.0 |
| 2007-11-21 16:00:00 | AAPL | Stock | 6.0143 | 6.0341 | 6.0039 | 6.0204 | 15636376.0 |
| 2007-11-21 16:30:00 | AAPL | Stock | 6.0229 | 6.025 | 6.0164 | 6.0239 | 2501604.0 |
| 2007-11-21 17:00:00 | AAPL | Stock | 6.0214 | 6.0275 | 6.0164 | 6.0275 | 443912.0 |
| 2007-11-21 17:30:00 | AAPL | Stock | 6.0286 | 6.0529 | 6.025 | 6.0529 | 481264.0 |
| 2007-11-21 18:00:00 | AAPL | Stock | 6.0564 | 6.0618 | 6.0429 | 6.0446 | 224896.0 |
| 2007-11-21 18:30:00 | AAPL | Stock | 6.0589 | 6.0589 | 6.0482 | 6.0536 | 76384.0 |
| 2007-11-21 19:00:00 | AAPL | Stock | 6.0482 | 6.0571 | 6.045 | 6.0536 | 170800.0 |
| 2007-11-21 19:30:00 | AAPL | Stock | 6.0532 | 6.0643 | 6.0532 | 6.06 | 333816.0 |
| 2007-11-21 07:00:00 | MSFT | Stock | 34.17 | 34.3 | 34.17 | 34.3 | 1600.0 |
| 2007-11-21 07:30:00 | MSFT | Stock | 34.25 | 34.25 | 34.05 | 34.23 | 34800.0 |
| 2007-11-21 08:00:00 | MSFT | Stock | 34.18 | 34.24 | 34.15 | 34.18 | 29097.0 |
| 2007-11-21 08:30:00 | MSFT | Stock | 34.18 | 34.22 | 34.18 | 34.2 | 30550.0 |
| 2007-11-21 09:00:00 | MSFT | Stock | 34.21 | 34.4 | 34.2 | 34.39 | 65106.0 |
| 2007-11-21 09:30:00 | MSFT | Stock | 34.4 | 34.67 | 34.39 | 34.62 | 7763512.0 |
| 2007-11-21 10:00:00 | MSFT | Stock | 34.62 | 34.73 | 34.43 | 34.5 | 10232390.0 |
| 2007-11-21 10:30:00 | MSFT | Stock | 34.5 | 34.5 | 34.29 | 34.39 | 7317064.0 |
| 2007-11-21 11:00:00 | MSFT | Stock | 34.39 | 34.52 | 34.21 | 34.48 | 5078598.0 |
| 2007-11-21 11:30:00 | MSFT | Stock | 34.48 | 34.52 | 34.39 | 34.4 | 5243545.0 |
| 2007-11-21 12:00:00 | MSFT | Stock | 34.4 | 34.483 | 34.29 | 34.29 | 4907450.0 |
| 2007-11-21 12:30:00 | MSFT | Stock | 34.3 | 34.52 | 34.26 | 34.47 | 5554038.0 |
| 2007-11-21 13:00:00 | MSFT | Stock | 34.47 | 34.62 | 34.4 | 34.47 | 5285209.0 |
| 2007-11-21 13:30:00 | MSFT | Stock | 34.48 | 34.59 | 34.42 | 34.51 | 4362375.0 |
| 2007-11-21 14:00:00 | MSFT | Stock | 34.51 | 34.58 | 34.44 | 34.52 | 3387012.0 |
| 2007-11-21 14:30:00 | MSFT | Stock | 34.52 | 34.56 | 34.44 | 34.54 | 3798967.0 |
| 2007-11-21 15:00:00 | MSFT | Stock | 34.538 | 34.57 | 34.32 | 34.4 | 8315195.0 |
| 2007-11-21 15:30:00 | MSFT | Stock | 34.4 | 34.42 | 34.18 | 34.21 | 16459650.0 |
| 2007-11-21 16:00:00 | MSFT | Stock | 34.21 | 34.5 | 34.13 | 34.21 | 2212869.0 |
| 2007-11-21 16:30:00 | MSFT | Stock | 34.2 | 34.23 | 34.2 | 34.22 | 130050.0 |
| 2007-11-21 17:00:00 | MSFT | Stock | 34.2 | 34.444 | 34.2 | 34.2 | 43488.0 |
| 2007-11-21 17:30:00 | MSFT | Stock | 34.2 | 34.25 | 34.2 | 34.25 | 4600.0 |
> showing 50 of 67,755 rows — these rows as CSV