PREVIEW / stock_5min / 2008-09-08
file: by_date/stock_5min/2008/2008-09-08.parquet size: 4.6 MB rows: 322,746 symbols: 3,320
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-09-08 04:15:00 | AAPL | Stock | 5.78 | 5.78 | 5.78 | 5.78 | 2800.0 |
| 2008-09-08 06:50:00 | AAPL | Stock | 5.8571 | 5.8643 | 5.8571 | 5.8643 | 35000.0 |
| 2008-09-08 06:55:00 | AAPL | Stock | 5.8643 | 5.875 | 5.8643 | 5.875 | 29484.0 |
| 2008-09-08 07:00:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.875 | 5.875 | 67116.0 |
| 2008-09-08 07:05:00 | AAPL | Stock | 5.8732 | 5.8732 | 5.8661 | 5.8661 | 12600.0 |
| 2008-09-08 07:10:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 82600.0 |
| 2008-09-08 07:15:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8429 | 5.8571 | 60060.0 |
| 2008-09-08 07:20:00 | AAPL | Stock | 5.8571 | 5.8839 | 5.8571 | 5.8571 | 76580.0 |
| 2008-09-08 07:25:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8482 | 5.8482 | 50400.0 |
| 2008-09-08 07:30:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.855 | 5.8554 | 117320.0 |
| 2008-09-08 07:35:00 | AAPL | Stock | 5.8429 | 5.8429 | 5.8429 | 5.8429 | 12404.0 |
| 2008-09-08 07:40:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8446 | 5.8446 | 53200.0 |
| 2008-09-08 07:45:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8464 | 5.8464 | 2800.0 |
| 2008-09-08 07:50:00 | AAPL | Stock | 5.8568 | 5.8571 | 5.8454 | 5.8571 | 86744.0 |
| 2008-09-08 07:55:00 | AAPL | Stock | 5.8571 | 5.8643 | 5.85 | 5.8571 | 91952.0 |
| 2008-09-08 08:00:00 | AAPL | Stock | 5.8571 | 5.8714 | 5.845 | 5.8625 | 533932.0 |
| 2008-09-08 08:05:00 | AAPL | Stock | 5.8575 | 5.8614 | 5.8529 | 5.8536 | 345576.0 |
| 2008-09-08 08:10:00 | AAPL | Stock | 5.8504 | 5.8607 | 5.8429 | 5.8571 | 911008.0 |
| 2008-09-08 08:15:00 | AAPL | Stock | 5.8571 | 5.8714 | 5.8554 | 5.8696 | 394436.0 |
| 2008-09-08 08:20:00 | AAPL | Stock | 5.8696 | 5.87 | 5.8625 | 5.8693 | 189420.0 |
| 2008-09-08 08:25:00 | AAPL | Stock | 5.87 | 5.875 | 5.8679 | 5.8696 | 772156.0 |
| 2008-09-08 08:30:00 | AAPL | Stock | 5.8696 | 5.8696 | 5.8571 | 5.8582 | 256200.0 |
| 2008-09-08 08:35:00 | AAPL | Stock | 5.8618 | 5.8643 | 5.8571 | 5.8629 | 260148.0 |
| 2008-09-08 08:40:00 | AAPL | Stock | 5.8632 | 5.8639 | 5.8589 | 5.8611 | 156660.0 |
| 2008-09-08 08:45:00 | AAPL | Stock | 5.8607 | 5.8646 | 5.8596 | 5.8629 | 284676.0 |
| 2008-09-08 08:50:00 | AAPL | Stock | 5.8629 | 5.8696 | 5.8625 | 5.8643 | 223664.0 |
| 2008-09-08 08:55:00 | AAPL | Stock | 5.8643 | 5.8696 | 5.8607 | 5.8643 | 258216.0 |
| 2008-09-08 09:00:00 | AAPL | Stock | 5.8646 | 5.8714 | 5.8629 | 5.8654 | 305900.0 |
| 2008-09-08 09:05:00 | AAPL | Stock | 5.8643 | 5.8714 | 5.8643 | 5.8707 | 786520.0 |
| 2008-09-08 09:10:00 | AAPL | Stock | 5.8714 | 5.8868 | 5.8679 | 5.8843 | 768012.0 |
| 2008-09-08 09:15:00 | AAPL | Stock | 5.8832 | 5.8929 | 5.8832 | 5.8889 | 588448.0 |
| 2008-09-08 09:20:00 | AAPL | Stock | 5.8832 | 5.8875 | 5.8789 | 5.8857 | 205800.0 |
| 2008-09-08 09:25:00 | AAPL | Stock | 5.8839 | 5.8946 | 5.875 | 5.875 | 1409016.0 |
| 2008-09-08 09:30:00 | AAPL | Stock | 5.8771 | 5.8889 | 5.7936 | 5.8 | 36223516.0 |
| 2008-09-08 09:35:00 | AAPL | Stock | 5.8004 | 5.8182 | 5.78 | 5.8004 | 24137484.0 |
| 2008-09-08 09:40:00 | AAPL | Stock | 5.7989 | 5.8114 | 5.7568 | 5.7661 | 16116100.0 |
| 2008-09-08 09:45:00 | AAPL | Stock | 5.765 | 5.8125 | 5.7636 | 5.7907 | 17455704.0 |
| 2008-09-08 09:50:00 | AAPL | Stock | 5.7907 | 5.7907 | 5.7143 | 5.7168 | 24433444.0 |
| 2008-09-08 09:55:00 | AAPL | Stock | 5.7168 | 5.7579 | 5.6786 | 5.6846 | 19580624.0 |
| 2008-09-08 10:00:00 | AAPL | Stock | 5.6836 | 5.6946 | 5.6429 | 5.6909 | 25614764.0 |
| 2008-09-08 10:05:00 | AAPL | Stock | 5.6918 | 5.7225 | 5.6775 | 5.7032 | 19563208.0 |
| 2008-09-08 10:10:00 | AAPL | Stock | 5.7043 | 5.7193 | 5.6489 | 5.6686 | 14093744.0 |
| 2008-09-08 10:15:00 | AAPL | Stock | 5.6675 | 5.6804 | 5.6114 | 5.6279 | 19724320.0 |
| 2008-09-08 10:20:00 | AAPL | Stock | 5.6282 | 5.6743 | 5.6229 | 5.6425 | 16432892.0 |
| 2008-09-08 10:25:00 | AAPL | Stock | 5.6425 | 5.6743 | 5.6214 | 5.67 | 14279496.0 |
| 2008-09-08 10:30:00 | AAPL | Stock | 5.6714 | 5.6907 | 5.6604 | 5.6761 | 11955608.0 |
| 2008-09-08 10:35:00 | AAPL | Stock | 5.6761 | 5.7304 | 5.6661 | 5.7254 | 14685692.0 |
| 2008-09-08 10:40:00 | AAPL | Stock | 5.7243 | 5.7375 | 5.7182 | 5.7214 | 11354896.0 |
| 2008-09-08 10:45:00 | AAPL | Stock | 5.7218 | 5.7232 | 5.6832 | 5.7021 | 12489624.0 |
| 2008-09-08 10:50:00 | AAPL | Stock | 5.7021 | 5.7033 | 5.6275 | 5.6307 | 13272840.0 |
> showing 50 of 322,746 rows — these rows as CSV