PREVIEW / stock_5min / 2007-02-15
file: by_date/stock_5min/2007/2007-02-15.parquet size: 3.4 MB rows: 248,447 symbols: 2,518
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-02-15 07:25:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0368 | 3.0368 | 30800.0 |
| 2007-02-15 07:40:00 | AAPL | Stock | 3.0414 | 3.0414 | 3.0414 | 3.0414 | 5600.0 |
| 2007-02-15 08:00:00 | AAPL | Stock | 3.0461 | 3.0475 | 3.0371 | 3.0407 | 237300.0 |
| 2007-02-15 08:05:00 | AAPL | Stock | 3.0389 | 3.0429 | 3.0389 | 3.0429 | 36400.0 |
| 2007-02-15 08:10:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 5600.0 |
| 2007-02-15 08:15:00 | AAPL | Stock | 3.0414 | 3.0443 | 3.0414 | 3.0443 | 16800.0 |
| 2007-02-15 08:20:00 | AAPL | Stock | 3.0429 | 3.0446 | 3.0429 | 3.0446 | 93800.0 |
| 2007-02-15 08:30:00 | AAPL | Stock | 3.0432 | 3.0446 | 3.0432 | 3.0446 | 19600.0 |
| 2007-02-15 08:35:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0432 | 3.0432 | 19880.0 |
| 2007-02-15 08:40:00 | AAPL | Stock | 3.0432 | 3.0432 | 3.0414 | 3.0414 | 50680.0 |
| 2007-02-15 08:45:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0368 | 3.0368 | 434308.0 |
| 2007-02-15 08:50:00 | AAPL | Stock | 3.0407 | 3.0411 | 3.0404 | 3.0411 | 143472.0 |
| 2007-02-15 08:55:00 | AAPL | Stock | 3.0414 | 3.0429 | 3.0414 | 3.0418 | 81200.0 |
| 2007-02-15 09:00:00 | AAPL | Stock | 3.0414 | 3.0429 | 3.0414 | 3.0429 | 34580.0 |
| 2007-02-15 09:05:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0425 | 3.0425 | 43820.0 |
| 2007-02-15 09:10:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 95620.0 |
| 2007-02-15 09:15:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 14000.0 |
| 2007-02-15 09:20:00 | AAPL | Stock | 3.0457 | 3.0457 | 3.0457 | 3.0457 | 14420.0 |
| 2007-02-15 09:25:00 | AAPL | Stock | 3.0446 | 3.05 | 3.0425 | 3.05 | 187712.0 |
| 2007-02-15 09:30:00 | AAPL | Stock | 3.0514 | 3.0579 | 3.0421 | 3.0432 | 10707760.0 |
| 2007-02-15 09:35:00 | AAPL | Stock | 3.0432 | 3.0475 | 3.0368 | 3.0389 | 7646688.0 |
| 2007-02-15 09:40:00 | AAPL | Stock | 3.0386 | 3.0389 | 3.0279 | 3.0354 | 12590480.0 |
| 2007-02-15 09:45:00 | AAPL | Stock | 3.0354 | 3.0411 | 3.0329 | 3.0411 | 10756004.0 |
| 2007-02-15 09:50:00 | AAPL | Stock | 3.0407 | 3.0411 | 3.0307 | 3.0314 | 8516284.0 |
| 2007-02-15 09:55:00 | AAPL | Stock | 3.0311 | 3.0436 | 3.0307 | 3.0425 | 6553428.0 |
| 2007-02-15 10:00:00 | AAPL | Stock | 3.0429 | 3.0457 | 3.0357 | 3.0436 | 10569048.0 |
| 2007-02-15 10:05:00 | AAPL | Stock | 3.0436 | 3.0486 | 3.0418 | 3.0461 | 9968056.0 |
| 2007-02-15 10:10:00 | AAPL | Stock | 3.0461 | 3.0486 | 3.0421 | 3.0479 | 6476176.0 |
| 2007-02-15 10:15:00 | AAPL | Stock | 3.0479 | 3.0514 | 3.0464 | 3.0496 | 6266064.0 |
| 2007-02-15 10:20:00 | AAPL | Stock | 3.0496 | 3.0507 | 3.0421 | 3.0421 | 7161784.0 |
| 2007-02-15 10:25:00 | AAPL | Stock | 3.0425 | 3.0439 | 3.0393 | 3.0421 | 5960836.0 |
| 2007-02-15 10:30:00 | AAPL | Stock | 3.0425 | 3.0457 | 3.0411 | 3.0411 | 4039112.0 |
| 2007-02-15 10:35:00 | AAPL | Stock | 3.0411 | 3.0414 | 3.0368 | 3.0368 | 4690476.0 |
| 2007-02-15 10:40:00 | AAPL | Stock | 3.0371 | 3.0418 | 3.0371 | 3.0379 | 3902192.0 |
| 2007-02-15 10:45:00 | AAPL | Stock | 3.0379 | 3.0386 | 3.0318 | 3.0336 | 9905028.0 |
| 2007-02-15 10:50:00 | AAPL | Stock | 3.0339 | 3.0375 | 3.0321 | 3.0343 | 7325220.0 |
| 2007-02-15 10:55:00 | AAPL | Stock | 3.0339 | 3.0375 | 3.0329 | 3.0335 | 4575732.0 |
| 2007-02-15 11:00:00 | AAPL | Stock | 3.0336 | 3.0357 | 3.0314 | 3.0336 | 4669756.0 |
| 2007-02-15 11:05:00 | AAPL | Stock | 3.0339 | 3.0368 | 3.0311 | 3.0332 | 6680912.0 |
| 2007-02-15 11:10:00 | AAPL | Stock | 3.0332 | 3.0382 | 3.0326 | 3.0357 | 4515476.0 |
| 2007-02-15 11:15:00 | AAPL | Stock | 3.0357 | 3.0375 | 3.0357 | 3.0368 | 3928596.0 |
| 2007-02-15 11:20:00 | AAPL | Stock | 3.0368 | 3.0389 | 3.0364 | 3.0379 | 2078580.0 |
| 2007-02-15 11:25:00 | AAPL | Stock | 3.0379 | 3.0407 | 3.0368 | 3.04 | 2959852.0 |
| 2007-02-15 11:30:00 | AAPL | Stock | 3.04 | 3.0418 | 3.0364 | 3.0393 | 4623892.0 |
| 2007-02-15 11:35:00 | AAPL | Stock | 3.0396 | 3.0407 | 3.0379 | 3.0396 | 2017428.0 |
| 2007-02-15 11:40:00 | AAPL | Stock | 3.0396 | 3.0396 | 3.0379 | 3.0379 | 1686104.0 |
| 2007-02-15 11:45:00 | AAPL | Stock | 3.0379 | 3.0393 | 3.0379 | 3.0386 | 2629228.0 |
| 2007-02-15 11:50:00 | AAPL | Stock | 3.0386 | 3.0454 | 3.0382 | 3.0436 | 9879268.0 |
| 2007-02-15 11:55:00 | AAPL | Stock | 3.0436 | 3.0446 | 3.0421 | 3.0436 | 2906624.0 |
| 2007-02-15 12:00:00 | AAPL | Stock | 3.0439 | 3.0457 | 3.0411 | 3.0425 | 5495868.0 |
> showing 50 of 248,447 rows — these rows as CSV