PREVIEW / stock_5min / 2009-07-30
file: by_date/stock_5min/2009/2009-07-30.parquet size: 4.7 MB rows: 326,881 symbols: 3,367
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-30 04:25:00 | AAPL | Stock | 5.7261 | 5.7261 | 5.7261 | 5.7261 | 2800.0 |
| 2009-07-30 04:40:00 | AAPL | Stock | 5.7264 | 5.7264 | 5.7264 | 5.7264 | 2800.0 |
| 2009-07-30 07:00:00 | AAPL | Stock | 5.75 | 5.75 | 5.7457 | 5.75 | 16800.0 |
| 2009-07-30 07:05:00 | AAPL | Stock | 5.7393 | 5.7489 | 5.7393 | 5.7489 | 16800.0 |
| 2009-07-30 07:10:00 | AAPL | Stock | 5.7496 | 5.7589 | 5.7489 | 5.7589 | 36876.0 |
| 2009-07-30 07:15:00 | AAPL | Stock | 5.7571 | 5.77 | 5.7571 | 5.77 | 35000.0 |
| 2009-07-30 07:20:00 | AAPL | Stock | 5.7704 | 5.7704 | 5.7704 | 5.7704 | 2800.0 |
| 2009-07-30 07:25:00 | AAPL | Stock | 5.7618 | 5.7618 | 5.7589 | 5.7614 | 16800.0 |
| 2009-07-30 07:30:00 | AAPL | Stock | 5.7589 | 5.7614 | 5.7536 | 5.7536 | 42000.0 |
| 2009-07-30 07:35:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.7507 | 5.7507 | 16800.0 |
| 2009-07-30 07:40:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.75 | 5.7536 | 50400.0 |
| 2009-07-30 07:45:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.7536 | 5.7536 | 11200.0 |
| 2009-07-30 07:50:00 | AAPL | Stock | 5.7571 | 5.7571 | 5.7536 | 5.7571 | 50624.0 |
| 2009-07-30 07:55:00 | AAPL | Stock | 5.7571 | 5.7586 | 5.7571 | 5.7586 | 16800.0 |
| 2009-07-30 08:00:00 | AAPL | Stock | 5.7536 | 5.7582 | 5.75 | 5.7529 | 265860.0 |
| 2009-07-30 08:05:00 | AAPL | Stock | 5.75 | 5.7568 | 5.75 | 5.7564 | 167104.0 |
| 2009-07-30 08:10:00 | AAPL | Stock | 5.7564 | 5.7614 | 5.7564 | 5.7614 | 113008.0 |
| 2009-07-30 08:15:00 | AAPL | Stock | 5.7625 | 5.7679 | 5.7607 | 5.7607 | 136220.0 |
| 2009-07-30 08:20:00 | AAPL | Stock | 5.7625 | 5.7696 | 5.7607 | 5.7696 | 205520.0 |
| 2009-07-30 08:25:00 | AAPL | Stock | 5.7682 | 5.7696 | 5.7654 | 5.7654 | 130396.0 |
| 2009-07-30 08:30:00 | AAPL | Stock | 5.7643 | 5.7764 | 5.7611 | 5.7711 | 414372.0 |
| 2009-07-30 08:35:00 | AAPL | Stock | 5.7711 | 5.7711 | 5.7671 | 5.7675 | 124096.0 |
| 2009-07-30 08:40:00 | AAPL | Stock | 5.7671 | 5.7679 | 5.7643 | 5.7675 | 154000.0 |
| 2009-07-30 08:45:00 | AAPL | Stock | 5.7682 | 5.7736 | 5.7682 | 5.7736 | 370580.0 |
| 2009-07-30 08:50:00 | AAPL | Stock | 5.7739 | 5.7764 | 5.7732 | 5.7754 | 174160.0 |
| 2009-07-30 08:55:00 | AAPL | Stock | 5.7754 | 5.7754 | 5.7714 | 5.775 | 124180.0 |
| 2009-07-30 09:00:00 | AAPL | Stock | 5.7746 | 5.775 | 5.7739 | 5.775 | 182420.0 |
| 2009-07-30 09:05:00 | AAPL | Stock | 5.7718 | 5.7764 | 5.7714 | 5.7757 | 308952.0 |
| 2009-07-30 09:10:00 | AAPL | Stock | 5.7764 | 5.7768 | 5.7721 | 5.775 | 92316.0 |
| 2009-07-30 09:15:00 | AAPL | Stock | 5.7761 | 5.7764 | 5.7686 | 5.7686 | 123424.0 |
| 2009-07-30 09:20:00 | AAPL | Stock | 5.7714 | 5.7746 | 5.7707 | 5.7707 | 56000.0 |
| 2009-07-30 09:25:00 | AAPL | Stock | 5.7711 | 5.7732 | 5.7682 | 5.7729 | 125132.0 |
| 2009-07-30 09:30:00 | AAPL | Stock | 5.7746 | 5.8 | 5.7679 | 5.7986 | 22194424.0 |
| 2009-07-30 09:35:00 | AAPL | Stock | 5.7989 | 5.8139 | 5.7986 | 5.8125 | 15362116.0 |
| 2009-07-30 09:40:00 | AAPL | Stock | 5.8121 | 5.8282 | 5.8071 | 5.8282 | 13343484.0 |
| 2009-07-30 09:45:00 | AAPL | Stock | 5.8282 | 5.8307 | 5.8143 | 5.8229 | 11163936.0 |
| 2009-07-30 09:50:00 | AAPL | Stock | 5.8221 | 5.85 | 5.8214 | 5.8479 | 16027452.0 |
| 2009-07-30 09:55:00 | AAPL | Stock | 5.8468 | 5.8743 | 5.8468 | 5.8725 | 16971108.0 |
| 2009-07-30 10:00:00 | AAPL | Stock | 5.8725 | 5.8782 | 5.85 | 5.85 | 15650572.0 |
| 2009-07-30 10:05:00 | AAPL | Stock | 5.8511 | 5.8693 | 5.8471 | 5.8611 | 12011300.0 |
| 2009-07-30 10:10:00 | AAPL | Stock | 5.8611 | 5.8661 | 5.8539 | 5.855 | 6991740.0 |
| 2009-07-30 10:15:00 | AAPL | Stock | 5.8546 | 5.8611 | 5.8539 | 5.8582 | 4444244.0 |
| 2009-07-30 10:20:00 | AAPL | Stock | 5.8571 | 5.8593 | 5.8446 | 5.8514 | 7916552.0 |
| 2009-07-30 10:25:00 | AAPL | Stock | 5.8511 | 5.8661 | 5.8511 | 5.8646 | 6183128.0 |
| 2009-07-30 10:30:00 | AAPL | Stock | 5.865 | 5.8661 | 5.855 | 5.8639 | 4340868.0 |
| 2009-07-30 10:35:00 | AAPL | Stock | 5.8639 | 5.875 | 5.8618 | 5.875 | 8044428.0 |
| 2009-07-30 10:40:00 | AAPL | Stock | 5.875 | 5.875 | 5.8607 | 5.8636 | 6075748.0 |
| 2009-07-30 10:45:00 | AAPL | Stock | 5.8644 | 5.8679 | 5.8585 | 5.8646 | 3774120.0 |
| 2009-07-30 10:50:00 | AAPL | Stock | 5.8646 | 5.8679 | 5.8579 | 5.8636 | 2947448.0 |
| 2009-07-30 10:55:00 | AAPL | Stock | 5.864 | 5.8679 | 5.8596 | 5.8636 | 2920344.0 |
> showing 50 of 326,881 rows — these rows as CSV