PREVIEW / stock_5min / 2008-11-20
file: by_date/stock_5min/2008/2008-11-20.parquet size: 4.6 MB rows: 329,889 symbols: 3,397
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-11-20 04:15:00 | AAPL | Stock | 3.0739 | 3.0739 | 3.0686 | 3.0686 | 5600.0 |
| 2008-11-20 04:35:00 | AAPL | Stock | 3.0361 | 3.0361 | 3.0361 | 3.0361 | 5600.0 |
| 2008-11-20 06:35:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0161 | 3.0161 | 2800.0 |
| 2008-11-20 07:05:00 | AAPL | Stock | 3.0532 | 3.0532 | 3.0532 | 3.0532 | 2800.0 |
| 2008-11-20 07:10:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 14000.0 |
| 2008-11-20 07:15:00 | AAPL | Stock | 3.0671 | 3.075 | 3.0671 | 3.075 | 42000.0 |
| 2008-11-20 07:20:00 | AAPL | Stock | 3.0818 | 3.0921 | 3.0818 | 3.0893 | 42532.0 |
| 2008-11-20 07:30:00 | AAPL | Stock | 3.0929 | 3.0975 | 3.0929 | 3.0975 | 8400.0 |
| 2008-11-20 07:35:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0893 | 3.0893 | 29400.0 |
| 2008-11-20 07:40:00 | AAPL | Stock | 3.0893 | 3.0929 | 3.0893 | 3.09 | 245000.0 |
| 2008-11-20 07:45:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0929 | 3.0929 | 36400.0 |
| 2008-11-20 07:50:00 | AAPL | Stock | 3.1043 | 3.1054 | 3.1043 | 3.1054 | 8400.0 |
| 2008-11-20 08:00:00 | AAPL | Stock | 3.0968 | 3.1064 | 3.0911 | 3.0954 | 64316.0 |
| 2008-11-20 08:05:00 | AAPL | Stock | 3.0925 | 3.0929 | 3.0925 | 3.0929 | 50400.0 |
| 2008-11-20 08:10:00 | AAPL | Stock | 3.0893 | 3.0896 | 3.0875 | 3.0893 | 97384.0 |
| 2008-11-20 08:15:00 | AAPL | Stock | 3.0911 | 3.0911 | 3.0893 | 3.0911 | 89740.0 |
| 2008-11-20 08:20:00 | AAPL | Stock | 3.0911 | 3.0932 | 3.0893 | 3.09 | 98280.0 |
| 2008-11-20 08:25:00 | AAPL | Stock | 3.0896 | 3.0904 | 3.0886 | 3.0893 | 140364.0 |
| 2008-11-20 08:30:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0571 | 3.0607 | 512596.0 |
| 2008-11-20 08:35:00 | AAPL | Stock | 3.0586 | 3.0607 | 3.0482 | 3.06 | 447048.0 |
| 2008-11-20 08:40:00 | AAPL | Stock | 3.06 | 3.06 | 3.0554 | 3.0554 | 44380.0 |
| 2008-11-20 08:45:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.04 | 3.04 | 391720.0 |
| 2008-11-20 08:50:00 | AAPL | Stock | 3.0393 | 3.0393 | 3.0239 | 3.0246 | 418012.0 |
| 2008-11-20 08:55:00 | AAPL | Stock | 3.0214 | 3.0407 | 3.0214 | 3.0393 | 193452.0 |
| 2008-11-20 09:00:00 | AAPL | Stock | 3.0411 | 3.0425 | 3.0282 | 3.0293 | 368816.0 |
| 2008-11-20 09:05:00 | AAPL | Stock | 3.0275 | 3.0371 | 3.025 | 3.0371 | 265692.0 |
| 2008-11-20 09:10:00 | AAPL | Stock | 3.0368 | 3.04 | 3.0268 | 3.0271 | 369544.0 |
| 2008-11-20 09:15:00 | AAPL | Stock | 3.0293 | 3.0379 | 3.025 | 3.025 | 589288.0 |
| 2008-11-20 09:20:00 | AAPL | Stock | 3.0261 | 3.0307 | 3.0214 | 3.0304 | 288456.0 |
| 2008-11-20 09:25:00 | AAPL | Stock | 3.0325 | 3.0464 | 3.025 | 3.0432 | 977368.0 |
| 2008-11-20 09:30:00 | AAPL | Stock | 3.0436 | 3.0679 | 3.0357 | 3.05 | 26465376.0 |
| 2008-11-20 09:35:00 | AAPL | Stock | 3.05 | 3.0504 | 3.015 | 3.0275 | 34971188.0 |
| 2008-11-20 09:40:00 | AAPL | Stock | 3.0268 | 3.0286 | 2.9882 | 2.9896 | 33310760.0 |
| 2008-11-20 09:45:00 | AAPL | Stock | 2.99 | 3.0164 | 2.985 | 3.0154 | 24944024.0 |
| 2008-11-20 09:50:00 | AAPL | Stock | 3.0146 | 3.0354 | 3.0036 | 3.0165 | 22847160.0 |
| 2008-11-20 09:55:00 | AAPL | Stock | 3.0171 | 3.0236 | 2.995 | 3.0 | 17252956.0 |
| 2008-11-20 10:00:00 | AAPL | Stock | 3.0 | 3.015 | 2.9732 | 2.9739 | 20909924.0 |
| 2008-11-20 10:05:00 | AAPL | Stock | 2.9739 | 2.981 | 2.8571 | 2.9154 | 40517960.0 |
| 2008-11-20 10:10:00 | AAPL | Stock | 2.9154 | 2.9371 | 2.9107 | 2.9364 | 25335716.0 |
| 2008-11-20 10:15:00 | AAPL | Stock | 2.9364 | 2.9407 | 2.9107 | 2.9204 | 20492136.0 |
| 2008-11-20 10:20:00 | AAPL | Stock | 2.9207 | 2.9725 | 2.9189 | 2.9675 | 32753308.0 |
| 2008-11-20 10:25:00 | AAPL | Stock | 2.9664 | 2.995 | 2.9607 | 2.9911 | 26795720.0 |
| 2008-11-20 10:30:00 | AAPL | Stock | 2.9904 | 3.0379 | 2.9896 | 3.0154 | 36383256.0 |
| 2008-11-20 10:35:00 | AAPL | Stock | 3.0154 | 3.0257 | 2.9954 | 3.0019 | 27293476.0 |
| 2008-11-20 10:40:00 | AAPL | Stock | 3.0032 | 3.0339 | 2.985 | 3.0314 | 28061376.0 |
| 2008-11-20 10:45:00 | AAPL | Stock | 3.0318 | 3.065 | 3.0225 | 3.0389 | 33217688.0 |
| 2008-11-20 10:50:00 | AAPL | Stock | 3.0389 | 3.0536 | 3.0164 | 3.0518 | 23150148.0 |
| 2008-11-20 10:55:00 | AAPL | Stock | 3.0511 | 3.0546 | 3.0125 | 3.0375 | 23117948.0 |
| 2008-11-20 11:00:00 | AAPL | Stock | 3.0361 | 3.0557 | 3.0343 | 3.05 | 35644952.0 |
| 2008-11-20 11:05:00 | AAPL | Stock | 3.0504 | 3.0536 | 3.0171 | 3.0211 | 25084864.0 |
> showing 50 of 329,889 rows — these rows as CSV