PREVIEW / stock_5min / 2008-10-15
file: by_date/stock_5min/2008/2008-10-15.parquet size: 4.5 MB rows: 317,756 symbols: 3,327
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-10-15 05:00:00 | AAPL | Stock | 3.7393 | 3.7775 | 3.7393 | 3.7775 | 19796.0 |
| 2008-10-15 05:10:00 | AAPL | Stock | 3.7904 | 3.7904 | 3.7904 | 3.7904 | 2800.0 |
| 2008-10-15 05:40:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 2800.0 |
| 2008-10-15 06:20:00 | AAPL | Stock | 3.8018 | 3.8018 | 3.8018 | 3.8018 | 2800.0 |
| 2008-10-15 06:50:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 14000.0 |
| 2008-10-15 07:00:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 11200.0 |
| 2008-10-15 07:05:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 4200.0 |
| 2008-10-15 07:10:00 | AAPL | Stock | 3.8014 | 3.8014 | 3.8014 | 3.8014 | 5600.0 |
| 2008-10-15 07:15:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 28000.0 |
| 2008-10-15 07:20:00 | AAPL | Stock | 3.7896 | 3.7896 | 3.7679 | 3.7679 | 49000.0 |
| 2008-10-15 07:25:00 | AAPL | Stock | 3.7936 | 3.7964 | 3.7936 | 3.7961 | 29400.0 |
| 2008-10-15 07:30:00 | AAPL | Stock | 3.7929 | 3.7946 | 3.7929 | 3.7929 | 64400.0 |
| 2008-10-15 07:35:00 | AAPL | Stock | 3.7868 | 3.7868 | 3.7857 | 3.7857 | 121100.0 |
| 2008-10-15 07:40:00 | AAPL | Stock | 3.7875 | 3.7875 | 3.7768 | 3.7768 | 167300.0 |
| 2008-10-15 07:45:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7768 | 3.7768 | 19600.0 |
| 2008-10-15 07:50:00 | AAPL | Stock | 3.7846 | 3.7857 | 3.7768 | 3.7768 | 53200.0 |
| 2008-10-15 07:55:00 | AAPL | Stock | 3.7764 | 3.7768 | 3.7732 | 3.7768 | 33600.0 |
| 2008-10-15 08:00:00 | AAPL | Stock | 3.7732 | 3.7979 | 3.7732 | 3.7979 | 665700.0 |
| 2008-10-15 08:05:00 | AAPL | Stock | 3.7914 | 3.7914 | 3.7732 | 3.7732 | 265636.0 |
| 2008-10-15 08:10:00 | AAPL | Stock | 3.7732 | 3.775 | 3.7625 | 3.7675 | 211092.0 |
| 2008-10-15 08:15:00 | AAPL | Stock | 3.7668 | 3.7675 | 3.755 | 3.7554 | 138880.0 |
| 2008-10-15 08:20:00 | AAPL | Stock | 3.7543 | 3.7589 | 3.75 | 3.7536 | 592284.0 |
| 2008-10-15 08:25:00 | AAPL | Stock | 3.7536 | 3.7564 | 3.7386 | 3.7439 | 474376.0 |
| 2008-10-15 08:30:00 | AAPL | Stock | 3.7461 | 3.7482 | 3.6868 | 3.7025 | 920836.0 |
| 2008-10-15 08:35:00 | AAPL | Stock | 3.7036 | 3.7064 | 3.6521 | 3.6696 | 1184288.0 |
| 2008-10-15 08:40:00 | AAPL | Stock | 3.6679 | 3.7032 | 3.6679 | 3.6964 | 677796.0 |
| 2008-10-15 08:45:00 | AAPL | Stock | 3.6979 | 3.7168 | 3.6964 | 3.6989 | 576128.0 |
| 2008-10-15 08:50:00 | AAPL | Stock | 3.7029 | 3.7036 | 3.6861 | 3.6886 | 347172.0 |
| 2008-10-15 08:55:00 | AAPL | Stock | 3.6871 | 3.6964 | 3.6832 | 3.6964 | 630280.0 |
| 2008-10-15 09:00:00 | AAPL | Stock | 3.6964 | 3.7086 | 3.6961 | 3.7021 | 200676.0 |
| 2008-10-15 09:05:00 | AAPL | Stock | 3.7021 | 3.7214 | 3.6975 | 3.7107 | 760480.0 |
| 2008-10-15 09:10:00 | AAPL | Stock | 3.7068 | 3.7289 | 3.7 | 3.7279 | 595504.0 |
| 2008-10-15 09:15:00 | AAPL | Stock | 3.7279 | 3.7361 | 3.7143 | 3.7186 | 444276.0 |
| 2008-10-15 09:20:00 | AAPL | Stock | 3.7207 | 3.7214 | 3.7036 | 3.7057 | 348964.0 |
| 2008-10-15 09:25:00 | AAPL | Stock | 3.7111 | 3.7143 | 3.6964 | 3.7086 | 996240.0 |
| 2008-10-15 09:30:00 | AAPL | Stock | 3.7082 | 3.7618 | 3.7043 | 3.7468 | 33291468.0 |
| 2008-10-15 09:35:00 | AAPL | Stock | 3.7454 | 3.7593 | 3.6743 | 3.6775 | 34242936.0 |
| 2008-10-15 09:40:00 | AAPL | Stock | 3.6771 | 3.7068 | 3.6557 | 3.7065 | 34547996.0 |
| 2008-10-15 09:45:00 | AAPL | Stock | 3.7064 | 3.7443 | 3.6882 | 3.7014 | 33777408.0 |
| 2008-10-15 09:50:00 | AAPL | Stock | 3.7014 | 3.75 | 3.6861 | 3.7393 | 31063340.0 |
| 2008-10-15 09:55:00 | AAPL | Stock | 3.7386 | 3.8039 | 3.7382 | 3.7929 | 38556588.0 |
| 2008-10-15 10:00:00 | AAPL | Stock | 3.7914 | 3.8175 | 3.7607 | 3.8082 | 28311276.0 |
| 2008-10-15 10:05:00 | AAPL | Stock | 3.8093 | 3.8121 | 3.7604 | 3.7761 | 22943648.0 |
| 2008-10-15 10:10:00 | AAPL | Stock | 3.7757 | 3.8179 | 3.7679 | 3.8159 | 22308832.0 |
| 2008-10-15 10:15:00 | AAPL | Stock | 3.8157 | 3.8214 | 3.7611 | 3.7632 | 24654924.0 |
| 2008-10-15 10:20:00 | AAPL | Stock | 3.7618 | 3.7819 | 3.7511 | 3.7679 | 23489284.0 |
| 2008-10-15 10:25:00 | AAPL | Stock | 3.7686 | 3.7786 | 3.7411 | 3.7725 | 17926552.0 |
| 2008-10-15 10:30:00 | AAPL | Stock | 3.7725 | 3.7979 | 3.7661 | 3.7893 | 19556264.0 |
| 2008-10-15 10:35:00 | AAPL | Stock | 3.7904 | 3.8036 | 3.7832 | 3.7861 | 17440024.0 |
| 2008-10-15 10:40:00 | AAPL | Stock | 3.7875 | 3.7957 | 3.7418 | 3.7441 | 23655408.0 |
> showing 50 of 317,756 rows — these rows as CSV