PREVIEW / stock_5min / 2006-11-01
file: by_date/stock_5min/2006/2006-11-01.parquet size: 3.3 MB rows: 241,308 symbols: 2,434
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-01 07:40:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8946 | 2.8946 | 2800.0 |
| 2006-11-01 08:00:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8929 | 2.8929 | 305508.0 |
| 2006-11-01 08:10:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8932 | 2.8932 | 77000.0 |
| 2006-11-01 08:15:00 | AAPL | Stock | 2.8946 | 2.8957 | 2.8932 | 2.8932 | 170800.0 |
| 2006-11-01 08:20:00 | AAPL | Stock | 2.8932 | 2.8946 | 2.8925 | 2.8946 | 137368.0 |
| 2006-11-01 08:25:00 | AAPL | Stock | 2.8943 | 2.8946 | 2.8943 | 2.8946 | 28000.0 |
| 2006-11-01 08:30:00 | AAPL | Stock | 2.8925 | 2.8925 | 2.8768 | 2.8825 | 146020.0 |
| 2006-11-01 08:35:00 | AAPL | Stock | 2.8929 | 2.8943 | 2.8929 | 2.8943 | 156100.0 |
| 2006-11-01 08:40:00 | AAPL | Stock | 2.8943 | 2.8946 | 2.8929 | 2.8929 | 109200.0 |
| 2006-11-01 08:45:00 | AAPL | Stock | 2.8893 | 2.8893 | 2.8893 | 2.8893 | 2800.0 |
| 2006-11-01 08:50:00 | AAPL | Stock | 2.8929 | 2.8929 | 2.8904 | 2.8904 | 28000.0 |
| 2006-11-01 08:55:00 | AAPL | Stock | 2.8925 | 2.8946 | 2.8925 | 2.8925 | 94360.0 |
| 2006-11-01 09:00:00 | AAPL | Stock | 2.8925 | 2.8946 | 2.8925 | 2.8946 | 65100.0 |
| 2006-11-01 09:05:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8936 | 2.8936 | 208320.0 |
| 2006-11-01 09:10:00 | AAPL | Stock | 2.8936 | 2.8946 | 2.8936 | 2.8946 | 47600.0 |
| 2006-11-01 09:15:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8929 | 2.8929 | 84700.0 |
| 2006-11-01 09:20:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8929 | 2.8946 | 82320.0 |
| 2006-11-01 09:25:00 | AAPL | Stock | 2.8946 | 2.8964 | 2.8936 | 2.8964 | 221368.0 |
| 2006-11-01 09:30:00 | AAPL | Stock | 2.8964 | 2.9 | 2.8929 | 2.8982 | 9989308.0 |
| 2006-11-01 09:35:00 | AAPL | Stock | 2.8982 | 2.9036 | 2.8971 | 2.9025 | 9777488.0 |
| 2006-11-01 09:40:00 | AAPL | Stock | 2.9029 | 2.9064 | 2.8996 | 2.8996 | 6365912.0 |
| 2006-11-01 09:45:00 | AAPL | Stock | 2.8996 | 2.9021 | 2.8971 | 2.9004 | 4886392.0 |
| 2006-11-01 09:50:00 | AAPL | Stock | 2.9004 | 2.9011 | 2.8961 | 2.8979 | 7618660.0 |
| 2006-11-01 09:55:00 | AAPL | Stock | 2.8975 | 2.9004 | 2.8971 | 2.8986 | 3249176.0 |
| 2006-11-01 10:00:00 | AAPL | Stock | 2.8982 | 2.8986 | 2.8668 | 2.8796 | 28563304.0 |
| 2006-11-01 10:05:00 | AAPL | Stock | 2.8796 | 2.8982 | 2.8789 | 2.8864 | 16104760.0 |
| 2006-11-01 10:10:00 | AAPL | Stock | 2.8864 | 2.8882 | 2.8775 | 2.8818 | 9643088.0 |
| 2006-11-01 10:15:00 | AAPL | Stock | 2.8821 | 2.8821 | 2.8629 | 2.8661 | 15407420.0 |
| 2006-11-01 10:20:00 | AAPL | Stock | 2.8661 | 2.87 | 2.8629 | 2.8636 | 12908588.0 |
| 2006-11-01 10:25:00 | AAPL | Stock | 2.8632 | 2.867 | 2.8557 | 2.8668 | 20121332.0 |
| 2006-11-01 10:30:00 | AAPL | Stock | 2.8664 | 2.8693 | 2.8621 | 2.8664 | 8583232.0 |
| 2006-11-01 10:35:00 | AAPL | Stock | 2.8668 | 2.8693 | 2.8632 | 2.8671 | 4495232.0 |
| 2006-11-01 10:40:00 | AAPL | Stock | 2.8671 | 2.8725 | 2.8621 | 2.865 | 9899260.0 |
| 2006-11-01 10:45:00 | AAPL | Stock | 2.8653 | 2.8671 | 2.86 | 2.8643 | 5861912.0 |
| 2006-11-01 10:50:00 | AAPL | Stock | 2.8646 | 2.8711 | 2.8632 | 2.867 | 5373620.0 |
| 2006-11-01 10:55:00 | AAPL | Stock | 2.8668 | 2.8686 | 2.8632 | 2.8657 | 3941588.0 |
| 2006-11-01 11:00:00 | AAPL | Stock | 2.8661 | 2.8711 | 2.8657 | 2.8689 | 6713112.0 |
| 2006-11-01 11:05:00 | AAPL | Stock | 2.8686 | 2.8696 | 2.8625 | 2.8632 | 4838708.0 |
| 2006-11-01 11:10:00 | AAPL | Stock | 2.8632 | 2.8639 | 2.8586 | 2.8621 | 5119408.0 |
| 2006-11-01 11:15:00 | AAPL | Stock | 2.8618 | 2.8643 | 2.8604 | 2.8636 | 6244140.0 |
| 2006-11-01 11:20:00 | AAPL | Stock | 2.8632 | 2.8643 | 2.8596 | 2.8611 | 3521112.0 |
| 2006-11-01 11:25:00 | AAPL | Stock | 2.8614 | 2.8618 | 2.8575 | 2.8593 | 5180028.0 |
| 2006-11-01 11:30:00 | AAPL | Stock | 2.8589 | 2.86 | 2.8536 | 2.8543 | 6851292.0 |
| 2006-11-01 11:35:00 | AAPL | Stock | 2.8543 | 2.8546 | 2.85 | 2.85 | 9761612.0 |
| 2006-11-01 11:40:00 | AAPL | Stock | 2.8507 | 2.8518 | 2.8409 | 2.8425 | 18545520.0 |
| 2006-11-01 11:45:00 | AAPL | Stock | 2.8425 | 2.8464 | 2.8396 | 2.8439 | 12849256.0 |
| 2006-11-01 11:50:00 | AAPL | Stock | 2.8439 | 2.8446 | 2.8332 | 2.8354 | 14676508.0 |
| 2006-11-01 11:55:00 | AAPL | Stock | 2.8354 | 2.8382 | 2.8332 | 2.8371 | 8029000.0 |
| 2006-11-01 12:00:00 | AAPL | Stock | 2.8375 | 2.8464 | 2.8357 | 2.8443 | 7814016.0 |
| 2006-11-01 12:05:00 | AAPL | Stock | 2.8443 | 2.845 | 2.8407 | 2.8425 | 4434080.0 |
> showing 50 of 241,308 rows — these rows as CSV