PREVIEW / stock_30min / 2008-09-19
file: by_date/stock_30min/2008/2008-09-19.parquet size: 1.4 MB rows: 78,437 symbols: 3,379
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-19 07:00:00 | AAPL | Stock | 4.9464 | 5.0357 | 4.9289 | 4.9989 | 773472.0 |
| 2008-09-19 07:30:00 | AAPL | Stock | 4.9761 | 5.0536 | 4.9643 | 5.0139 | 770140.0 |
| 2008-09-19 08:00:00 | AAPL | Stock | 5.0139 | 5.1143 | 4.9821 | 5.1068 | 6979952.0 |
| 2008-09-19 08:30:00 | AAPL | Stock | 5.1068 | 5.1411 | 5.0893 | 5.1125 | 5997544.0 |
| 2008-09-19 09:00:00 | AAPL | Stock | 5.1143 | 5.2143 | 5.0779 | 5.0979 | 15252524.0 |
| 2008-09-19 09:30:00 | AAPL | Stock | 5.0979 | 5.1136 | 4.8929 | 5.0157 | 360528980.0 |
| 2008-09-19 10:00:00 | AAPL | Stock | 5.015 | 5.0439 | 4.9425 | 5.0221 | 126804244.0 |
| 2008-09-19 10:30:00 | AAPL | Stock | 5.0218 | 5.0439 | 4.9679 | 4.9887 | 82494412.0 |
| 2008-09-19 11:00:00 | AAPL | Stock | 4.9889 | 5.0671 | 4.9843 | 5.0518 | 86194500.0 |
| 2008-09-19 11:30:00 | AAPL | Stock | 5.0507 | 5.0982 | 5.0229 | 5.0893 | 68629876.0 |
| 2008-09-19 12:00:00 | AAPL | Stock | 5.0893 | 5.1218 | 5.075 | 5.1214 | 60993772.0 |
| 2008-09-19 12:30:00 | AAPL | Stock | 5.12 | 5.15 | 5.0875 | 5.0891 | 70186340.0 |
| 2008-09-19 13:00:00 | AAPL | Stock | 5.0903 | 5.0954 | 5.0357 | 5.058 | 57651916.0 |
| 2008-09-19 13:30:00 | AAPL | Stock | 5.0579 | 5.0607 | 5.0121 | 5.0257 | 53290860.0 |
| 2008-09-19 14:00:00 | AAPL | Stock | 5.0264 | 5.0446 | 5.0004 | 5.0414 | 58750104.0 |
| 2008-09-19 14:30:00 | AAPL | Stock | 5.0414 | 5.0482 | 5.0054 | 5.025 | 54012952.0 |
| 2008-09-19 15:00:00 | AAPL | Stock | 5.0246 | 5.0343 | 4.9496 | 5.0082 | 110296060.0 |
| 2008-09-19 15:30:00 | AAPL | Stock | 5.007 | 5.0279 | 4.9821 | 5.0279 | 132079304.0 |
| 2008-09-19 16:00:00 | AAPL | Stock | 5.0266 | 5.0445 | 5.0027 | 5.0411 | 44585100.0 |
| 2008-09-19 16:30:00 | AAPL | Stock | 5.0411 | 5.0446 | 5.0324 | 5.0361 | 3153192.0 |
| 2008-09-19 17:00:00 | AAPL | Stock | 5.0364 | 5.0464 | 5.0325 | 5.0325 | 5105520.0 |
| 2008-09-19 17:30:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0325 | 5.0357 | 71764.0 |
| 2008-09-19 18:00:00 | AAPL | Stock | 5.0325 | 5.0361 | 5.0268 | 5.0321 | 199136.0 |
| 2008-09-19 18:30:00 | AAPL | Stock | 5.0271 | 5.0282 | 5.0268 | 5.0282 | 93744.0 |
| 2008-09-19 19:00:00 | AAPL | Stock | 5.0268 | 5.0361 | 5.0221 | 5.0321 | 229768.0 |
| 2008-09-19 19:30:00 | AAPL | Stock | 5.0268 | 5.0393 | 5.0232 | 5.0232 | 472500.0 |
| 2008-09-19 07:00:00 | MSFT | Stock | 25.75 | 25.98 | 25.75 | 25.98 | 5200.0 |
| 2008-09-19 07:30:00 | MSFT | Stock | 25.97 | 26.15 | 25.9 | 26.1 | 36106.0 |
| 2008-09-19 08:00:00 | MSFT | Stock | 26.1 | 26.26 | 25.8 | 26.25 | 90212.0 |
| 2008-09-19 08:30:00 | MSFT | Stock | 26.26 | 26.36 | 26.19 | 26.28 | 160063.0 |
| 2008-09-19 09:00:00 | MSFT | Stock | 26.25 | 26.43 | 26.15 | 26.34 | 463709.0 |
| 2008-09-19 09:30:00 | MSFT | Stock | 26.34 | 26.4 | 23.5 | 25.51 | 12854336.0 |
| 2008-09-19 10:00:00 | MSFT | Stock | 25.52 | 25.6 | 25.25 | 25.262 | 8629700.0 |
| 2008-09-19 10:30:00 | MSFT | Stock | 25.26 | 25.4 | 24.82 | 24.97 | 7090326.0 |
| 2008-09-19 11:00:00 | MSFT | Stock | 24.97 | 25.33 | 24.94 | 25.28 | 9706172.0 |
| 2008-09-19 11:30:00 | MSFT | Stock | 25.28 | 25.53 | 25.21 | 25.49 | 5903888.0 |
| 2008-09-19 12:00:00 | MSFT | Stock | 25.49 | 25.51 | 25.32 | 25.43 | 3549204.0 |
| 2008-09-19 12:30:00 | MSFT | Stock | 25.43 | 25.57 | 25.28 | 25.4 | 4290130.0 |
| 2008-09-19 13:00:00 | MSFT | Stock | 25.4 | 25.42 | 25.31 | 25.33 | 3167849.0 |
| 2008-09-19 13:30:00 | MSFT | Stock | 25.32 | 25.325 | 25.03 | 25.064 | 4444886.0 |
| 2008-09-19 14:00:00 | MSFT | Stock | 25.062 | 25.09 | 24.96 | 25.075 | 5167070.0 |
| 2008-09-19 14:30:00 | MSFT | Stock | 25.061 | 25.19 | 25.01 | 25.07 | 5782178.0 |
| 2008-09-19 15:00:00 | MSFT | Stock | 25.07 | 25.23 | 24.96 | 25.14 | 7763076.0 |
| 2008-09-19 15:30:00 | MSFT | Stock | 25.14 | 25.47 | 25.04 | 25.16 | 14682421.0 |
| 2008-09-19 16:00:00 | MSFT | Stock | 25.15 | 26.25 | 25.023 | 25.15 | 13554819.0 |
| 2008-09-19 16:30:00 | MSFT | Stock | 25.158 | 25.18 | 25.06 | 25.15 | 845318.0 |
| 2008-09-19 17:00:00 | MSFT | Stock | 25.16 | 25.25 | 25.16 | 25.16 | 684631.0 |
| 2008-09-19 18:00:00 | MSFT | Stock | 25.19 | 25.29 | 25.16 | 25.2 | 7442.0 |
| 2008-09-19 18:30:00 | MSFT | Stock | 25.18 | 25.28 | 25.18 | 25.28 | 2721.0 |
| 2008-09-19 19:00:00 | MSFT | Stock | 25.27 | 25.29 | 25.2 | 25.2 | 7600.0 |
> showing 50 of 78,437 rows — these rows as CSV