PREVIEW / stock_1min / 2004-09-29
file: by_date/stock_1min/2004/2004-09-29.parquet size: 5.9 MB rows: 494,583 symbols: 1,507
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-29 08:01:00 | AAPL | Stock | 0.6848 | 0.6848 | 0.6848 | 0.6848 | 5600.0 |
| 2004-09-29 09:28:00 | AAPL | Stock | 0.6786 | 0.6786 | 0.6786 | 0.6786 | 56000.0 |
| 2004-09-29 09:29:00 | AAPL | Stock | 0.6779 | 0.6795 | 0.6768 | 0.6775 | 264992.0 |
| 2004-09-29 09:30:00 | AAPL | Stock | 0.6773 | 0.6786 | 0.6757 | 0.6768 | 3885672.0 |
| 2004-09-29 09:31:00 | AAPL | Stock | 0.6784 | 0.6789 | 0.6768 | 0.6789 | 909888.0 |
| 2004-09-29 09:32:00 | AAPL | Stock | 0.6791 | 0.6813 | 0.6789 | 0.6813 | 539504.0 |
| 2004-09-29 09:33:00 | AAPL | Stock | 0.6814 | 0.6823 | 0.6804 | 0.6818 | 843584.0 |
| 2004-09-29 09:34:00 | AAPL | Stock | 0.6818 | 0.6821 | 0.6802 | 0.682 | 556864.0 |
| 2004-09-29 09:35:00 | AAPL | Stock | 0.6818 | 0.6818 | 0.6804 | 0.6811 | 408912.0 |
| 2004-09-29 09:36:00 | AAPL | Stock | 0.6811 | 0.6814 | 0.6804 | 0.6807 | 346864.0 |
| 2004-09-29 09:37:00 | AAPL | Stock | 0.6807 | 0.6816 | 0.6805 | 0.6814 | 308000.0 |
| 2004-09-29 09:38:00 | AAPL | Stock | 0.6814 | 0.6814 | 0.6807 | 0.6814 | 433048.0 |
| 2004-09-29 09:39:00 | AAPL | Stock | 0.6809 | 0.6814 | 0.6805 | 0.6809 | 459704.0 |
| 2004-09-29 09:40:00 | AAPL | Stock | 0.6809 | 0.6813 | 0.6807 | 0.6813 | 156800.0 |
| 2004-09-29 09:41:00 | AAPL | Stock | 0.6813 | 0.6813 | 0.6809 | 0.6813 | 414456.0 |
| 2004-09-29 09:42:00 | AAPL | Stock | 0.6813 | 0.6829 | 0.6813 | 0.6825 | 924392.0 |
| 2004-09-29 09:43:00 | AAPL | Stock | 0.6823 | 0.6829 | 0.6821 | 0.6823 | 739368.0 |
| 2004-09-29 09:44:00 | AAPL | Stock | 0.6823 | 0.6825 | 0.6823 | 0.6825 | 711200.0 |
| 2004-09-29 09:45:00 | AAPL | Stock | 0.6825 | 0.6825 | 0.6816 | 0.6818 | 631400.0 |
| 2004-09-29 09:46:00 | AAPL | Stock | 0.6816 | 0.6829 | 0.6816 | 0.6829 | 275408.0 |
| 2004-09-29 09:47:00 | AAPL | Stock | 0.6829 | 0.6829 | 0.6816 | 0.6816 | 321216.0 |
| 2004-09-29 09:48:00 | AAPL | Stock | 0.682 | 0.6823 | 0.682 | 0.6821 | 76888.0 |
| 2004-09-29 09:49:00 | AAPL | Stock | 0.6821 | 0.6825 | 0.6818 | 0.6825 | 603288.0 |
| 2004-09-29 09:50:00 | AAPL | Stock | 0.6827 | 0.683 | 0.6825 | 0.6829 | 836080.0 |
| 2004-09-29 09:51:00 | AAPL | Stock | 0.6829 | 0.6829 | 0.6827 | 0.6829 | 145600.0 |
| 2004-09-29 09:52:00 | AAPL | Stock | 0.6827 | 0.6829 | 0.6823 | 0.6827 | 229600.0 |
| 2004-09-29 09:53:00 | AAPL | Stock | 0.6827 | 0.6829 | 0.6825 | 0.6827 | 452648.0 |
| 2004-09-29 09:54:00 | AAPL | Stock | 0.6827 | 0.6829 | 0.6825 | 0.6827 | 295232.0 |
| 2004-09-29 09:55:00 | AAPL | Stock | 0.6827 | 0.6852 | 0.6827 | 0.6852 | 1529304.0 |
| 2004-09-29 09:56:00 | AAPL | Stock | 0.6848 | 0.6866 | 0.6848 | 0.6859 | 1998360.0 |
| 2004-09-29 09:57:00 | AAPL | Stock | 0.6861 | 0.6871 | 0.6854 | 0.6866 | 2329376.0 |
| 2004-09-29 09:58:00 | AAPL | Stock | 0.6866 | 0.6866 | 0.6857 | 0.6861 | 491232.0 |
| 2004-09-29 09:59:00 | AAPL | Stock | 0.6861 | 0.6864 | 0.6859 | 0.6861 | 953904.0 |
| 2004-09-29 10:00:00 | AAPL | Stock | 0.6859 | 0.6859 | 0.6843 | 0.6843 | 2841384.0 |
| 2004-09-29 10:01:00 | AAPL | Stock | 0.6843 | 0.6845 | 0.6843 | 0.6843 | 1198176.0 |
| 2004-09-29 10:02:00 | AAPL | Stock | 0.6843 | 0.6848 | 0.6841 | 0.6848 | 3294816.0 |
| 2004-09-29 10:03:00 | AAPL | Stock | 0.6846 | 0.6852 | 0.6845 | 0.6848 | 1798496.0 |
| 2004-09-29 10:04:00 | AAPL | Stock | 0.6845 | 0.6846 | 0.6843 | 0.6843 | 268800.0 |
| 2004-09-29 10:05:00 | AAPL | Stock | 0.6843 | 0.6843 | 0.6839 | 0.6839 | 1008000.0 |
| 2004-09-29 10:06:00 | AAPL | Stock | 0.6839 | 0.6845 | 0.6839 | 0.6845 | 974400.0 |
| 2004-09-29 10:07:00 | AAPL | Stock | 0.6846 | 0.6848 | 0.6843 | 0.6843 | 1086512.0 |
| 2004-09-29 10:08:00 | AAPL | Stock | 0.6843 | 0.6843 | 0.683 | 0.6836 | 576352.0 |
| 2004-09-29 10:09:00 | AAPL | Stock | 0.6834 | 0.6843 | 0.6834 | 0.6841 | 571312.0 |
| 2004-09-29 10:10:00 | AAPL | Stock | 0.6841 | 0.6845 | 0.6834 | 0.6834 | 774704.0 |
| 2004-09-29 10:11:00 | AAPL | Stock | 0.6834 | 0.6841 | 0.6834 | 0.6838 | 232400.0 |
| 2004-09-29 10:12:00 | AAPL | Stock | 0.6838 | 0.6841 | 0.6834 | 0.6834 | 506408.0 |
| 2004-09-29 10:13:00 | AAPL | Stock | 0.6834 | 0.6836 | 0.6829 | 0.6836 | 722400.0 |
| 2004-09-29 10:14:00 | AAPL | Stock | 0.6834 | 0.6838 | 0.6829 | 0.6832 | 338520.0 |
| 2004-09-29 10:15:00 | AAPL | Stock | 0.6832 | 0.6832 | 0.6825 | 0.6829 | 1204112.0 |
| 2004-09-29 10:16:00 | AAPL | Stock | 0.6829 | 0.6838 | 0.6827 | 0.6834 | 201600.0 |
> showing 50 of 494,583 rows — these rows as CSV