PREVIEW / stock_5min / 2009-03-31
file: by_date/stock_5min/2009/2009-03-31.parquet size: 4.5 MB rows: 315,295 symbols: 3,345
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-03-31 07:30:00 | AAPL | Stock | 3.7518 | 3.7518 | 3.7518 | 3.7518 | 2800.0 |
| 2009-03-31 07:35:00 | AAPL | Stock | 3.7654 | 3.7661 | 3.7654 | 3.7661 | 5600.0 |
| 2009-03-31 07:40:00 | AAPL | Stock | 3.7664 | 3.7664 | 3.7664 | 3.7664 | 36400.0 |
| 2009-03-31 07:45:00 | AAPL | Stock | 3.7536 | 3.7536 | 3.75 | 3.75 | 173544.0 |
| 2009-03-31 07:50:00 | AAPL | Stock | 3.7518 | 3.7532 | 3.7496 | 3.7496 | 50400.0 |
| 2009-03-31 07:55:00 | AAPL | Stock | 3.7496 | 3.75 | 3.7496 | 3.75 | 44772.0 |
| 2009-03-31 08:00:00 | AAPL | Stock | 3.7639 | 3.7639 | 3.7504 | 3.7536 | 53200.0 |
| 2009-03-31 08:05:00 | AAPL | Stock | 3.7543 | 3.7625 | 3.7543 | 3.7625 | 65268.0 |
| 2009-03-31 08:10:00 | AAPL | Stock | 3.7625 | 3.7661 | 3.7589 | 3.7643 | 100800.0 |
| 2009-03-31 08:15:00 | AAPL | Stock | 3.7643 | 3.7643 | 3.7643 | 3.7643 | 37240.0 |
| 2009-03-31 08:20:00 | AAPL | Stock | 3.7643 | 3.7643 | 3.7589 | 3.7607 | 16800.0 |
| 2009-03-31 08:25:00 | AAPL | Stock | 3.7607 | 3.7607 | 3.7607 | 3.7607 | 2800.0 |
| 2009-03-31 08:30:00 | AAPL | Stock | 3.7607 | 3.7614 | 3.7589 | 3.7589 | 48860.0 |
| 2009-03-31 08:35:00 | AAPL | Stock | 3.7571 | 3.7639 | 3.7568 | 3.7639 | 43204.0 |
| 2009-03-31 08:40:00 | AAPL | Stock | 3.7629 | 3.7664 | 3.7629 | 3.7646 | 69860.0 |
| 2009-03-31 08:45:00 | AAPL | Stock | 3.7664 | 3.7664 | 3.7625 | 3.7643 | 117292.0 |
| 2009-03-31 08:50:00 | AAPL | Stock | 3.7643 | 3.765 | 3.7636 | 3.765 | 40320.0 |
| 2009-03-31 08:55:00 | AAPL | Stock | 3.7643 | 3.7643 | 3.7607 | 3.7607 | 111860.0 |
| 2009-03-31 09:00:00 | AAPL | Stock | 3.7625 | 3.7625 | 3.7607 | 3.7618 | 60620.0 |
| 2009-03-31 09:05:00 | AAPL | Stock | 3.7618 | 3.7636 | 3.7614 | 3.7636 | 80556.0 |
| 2009-03-31 09:10:00 | AAPL | Stock | 3.7661 | 3.7664 | 3.7661 | 3.7661 | 68600.0 |
| 2009-03-31 09:15:00 | AAPL | Stock | 3.7668 | 3.7711 | 3.7607 | 3.7621 | 142912.0 |
| 2009-03-31 09:20:00 | AAPL | Stock | 3.7625 | 3.7679 | 3.7621 | 3.7675 | 87080.0 |
| 2009-03-31 09:25:00 | AAPL | Stock | 3.7629 | 3.7696 | 3.7621 | 3.7696 | 521276.0 |
| 2009-03-31 09:30:00 | AAPL | Stock | 3.7661 | 3.7832 | 3.7646 | 3.7711 | 15669444.0 |
| 2009-03-31 09:35:00 | AAPL | Stock | 3.7714 | 3.7746 | 3.755 | 3.7607 | 11934748.0 |
| 2009-03-31 09:40:00 | AAPL | Stock | 3.7596 | 3.7685 | 3.7536 | 3.7668 | 12907832.0 |
| 2009-03-31 09:45:00 | AAPL | Stock | 3.7675 | 3.7768 | 3.7625 | 3.7732 | 7118468.0 |
| 2009-03-31 09:50:00 | AAPL | Stock | 3.7732 | 3.7864 | 3.7679 | 3.7836 | 11151252.0 |
| 2009-03-31 09:55:00 | AAPL | Stock | 3.7836 | 3.7864 | 3.7718 | 3.772 | 9038540.0 |
| 2009-03-31 10:00:00 | AAPL | Stock | 3.7714 | 3.785 | 3.7632 | 3.7736 | 11812612.0 |
| 2009-03-31 10:05:00 | AAPL | Stock | 3.7736 | 3.7921 | 3.7721 | 3.7896 | 10553816.0 |
| 2009-03-31 10:10:00 | AAPL | Stock | 3.7896 | 3.7918 | 3.7732 | 3.7743 | 6421940.0 |
| 2009-03-31 10:15:00 | AAPL | Stock | 3.7754 | 3.7811 | 3.7714 | 3.7763 | 3996020.0 |
| 2009-03-31 10:20:00 | AAPL | Stock | 3.7754 | 3.7832 | 3.7729 | 3.775 | 3602536.0 |
| 2009-03-31 10:25:00 | AAPL | Stock | 3.775 | 3.7807 | 3.77 | 3.7804 | 5344976.0 |
| 2009-03-31 10:30:00 | AAPL | Stock | 3.7804 | 3.7893 | 3.78 | 3.7839 | 6929804.0 |
| 2009-03-31 10:35:00 | AAPL | Stock | 3.7836 | 3.7918 | 3.7779 | 3.78 | 7171836.0 |
| 2009-03-31 10:40:00 | AAPL | Stock | 3.7804 | 3.7846 | 3.7768 | 3.7825 | 3442208.0 |
| 2009-03-31 10:45:00 | AAPL | Stock | 3.7821 | 3.7857 | 3.7711 | 3.7711 | 5840688.0 |
| 2009-03-31 10:50:00 | AAPL | Stock | 3.7714 | 3.7754 | 3.7643 | 3.7646 | 6540576.0 |
| 2009-03-31 10:55:00 | AAPL | Stock | 3.7646 | 3.7718 | 3.7643 | 3.77 | 4501084.0 |
| 2009-03-31 11:00:00 | AAPL | Stock | 3.7707 | 3.7761 | 3.7679 | 3.7714 | 4701200.0 |
| 2009-03-31 11:05:00 | AAPL | Stock | 3.7711 | 3.7754 | 3.7664 | 3.7746 | 4157020.0 |
| 2009-03-31 11:10:00 | AAPL | Stock | 3.7746 | 3.7746 | 3.7546 | 3.7575 | 8188040.0 |
| 2009-03-31 11:15:00 | AAPL | Stock | 3.7572 | 3.7682 | 3.7571 | 3.7607 | 4399500.0 |
| 2009-03-31 11:20:00 | AAPL | Stock | 3.7618 | 3.7721 | 3.7618 | 3.7657 | 5027092.0 |
| 2009-03-31 11:25:00 | AAPL | Stock | 3.7657 | 3.7768 | 3.7654 | 3.7693 | 5819912.0 |
| 2009-03-31 11:30:00 | AAPL | Stock | 3.77 | 3.77 | 3.7607 | 3.7621 | 3424484.0 |
| 2009-03-31 11:35:00 | AAPL | Stock | 3.7629 | 3.765 | 3.7571 | 3.7571 | 2933392.0 |
> showing 50 of 315,295 rows — these rows as CSV