PREVIEW / stock_1min / 2008-07-23
file: by_date/stock_1min/2008/2008-07-23.parquet size: 13.2 MB rows: 1,045,453 symbols: 2,721
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-07-23 07:03:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7893 | 5.7893 | 28000.0 |
| 2008-07-23 07:04:00 | AAPL | Stock | 5.7896 | 5.7896 | 5.7896 | 5.7896 | 14000.0 |
| 2008-07-23 07:05:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7889 | 5.7893 | 35000.0 |
| 2008-07-23 07:19:00 | AAPL | Stock | 5.84 | 5.84 | 5.84 | 5.84 | 66360.0 |
| 2008-07-23 07:21:00 | AAPL | Stock | 5.8396 | 5.84 | 5.8396 | 5.84 | 11200.0 |
| 2008-07-23 07:23:00 | AAPL | Stock | 5.8554 | 5.8604 | 5.8232 | 5.8604 | 416080.0 |
| 2008-07-23 07:24:00 | AAPL | Stock | 5.8564 | 5.8714 | 5.8564 | 5.8714 | 210000.0 |
| 2008-07-23 07:25:00 | AAPL | Stock | 5.8843 | 5.9086 | 5.8821 | 5.9086 | 400036.0 |
| 2008-07-23 07:26:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8911 | 5.8929 | 224000.0 |
| 2008-07-23 07:27:00 | AAPL | Stock | 5.8929 | 5.9068 | 5.8839 | 5.8839 | 43400.0 |
| 2008-07-23 07:28:00 | AAPL | Stock | 5.8786 | 5.8796 | 5.8768 | 5.8796 | 58800.0 |
| 2008-07-23 07:29:00 | AAPL | Stock | 5.8796 | 5.8929 | 5.8796 | 5.8929 | 30800.0 |
| 2008-07-23 07:30:00 | AAPL | Stock | 5.9064 | 5.9068 | 5.9064 | 5.9068 | 25200.0 |
| 2008-07-23 07:31:00 | AAPL | Stock | 5.91 | 5.9189 | 5.9036 | 5.9189 | 36400.0 |
| 2008-07-23 07:32:00 | AAPL | Stock | 5.9268 | 5.9411 | 5.9143 | 5.9189 | 501228.0 |
| 2008-07-23 07:33:00 | AAPL | Stock | 5.9282 | 5.9429 | 5.9275 | 5.9421 | 279160.0 |
| 2008-07-23 07:34:00 | AAPL | Stock | 5.9289 | 5.9357 | 5.9186 | 5.9286 | 115360.0 |
| 2008-07-23 07:35:00 | AAPL | Stock | 5.92 | 5.9286 | 5.9179 | 5.9179 | 130396.0 |
| 2008-07-23 07:36:00 | AAPL | Stock | 5.9114 | 5.9179 | 5.9107 | 5.9125 | 273196.0 |
| 2008-07-23 07:37:00 | AAPL | Stock | 5.9114 | 5.9114 | 5.9114 | 5.9114 | 81200.0 |
| 2008-07-23 07:38:00 | AAPL | Stock | 5.9118 | 5.9143 | 5.9018 | 5.9018 | 241220.0 |
| 2008-07-23 07:39:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9036 | 5.9036 | 19600.0 |
| 2008-07-23 07:40:00 | AAPL | Stock | 5.9032 | 5.9121 | 5.8986 | 5.9121 | 126000.0 |
| 2008-07-23 07:41:00 | AAPL | Stock | 5.9161 | 5.9229 | 5.9161 | 5.9179 | 40712.0 |
| 2008-07-23 07:42:00 | AAPL | Stock | 5.9196 | 5.9196 | 5.9196 | 5.9196 | 54740.0 |
| 2008-07-23 07:43:00 | AAPL | Stock | 5.9075 | 5.9107 | 5.9071 | 5.9071 | 50400.0 |
| 2008-07-23 07:46:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9018 | 5.9036 | 36400.0 |
| 2008-07-23 07:47:00 | AAPL | Stock | 5.9018 | 5.9018 | 5.8929 | 5.8929 | 299600.0 |
| 2008-07-23 07:48:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8911 | 5.8911 | 77476.0 |
| 2008-07-23 07:49:00 | AAPL | Stock | 5.8861 | 5.8875 | 5.8861 | 5.8861 | 8400.0 |
| 2008-07-23 07:50:00 | AAPL | Stock | 5.8861 | 5.8861 | 5.8782 | 5.8793 | 56000.0 |
| 2008-07-23 07:51:00 | AAPL | Stock | 5.8789 | 5.8857 | 5.8789 | 5.8857 | 11200.0 |
| 2008-07-23 07:52:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 54600.0 |
| 2008-07-23 07:53:00 | AAPL | Stock | 5.8861 | 5.8861 | 5.875 | 5.8857 | 53200.0 |
| 2008-07-23 07:54:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 36400.0 |
| 2008-07-23 07:55:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 28000.0 |
| 2008-07-23 07:56:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8886 | 5.8929 | 49280.0 |
| 2008-07-23 07:57:00 | AAPL | Stock | 5.8857 | 5.9036 | 5.8857 | 5.9036 | 125636.0 |
| 2008-07-23 07:58:00 | AAPL | Stock | 5.9036 | 5.9089 | 5.9036 | 5.9036 | 53200.0 |
| 2008-07-23 07:59:00 | AAPL | Stock | 5.9036 | 5.9107 | 5.9036 | 5.9036 | 114800.0 |
| 2008-07-23 08:00:00 | AAPL | Stock | 5.8929 | 5.9036 | 5.8786 | 5.8839 | 234976.0 |
| 2008-07-23 08:01:00 | AAPL | Stock | 5.8839 | 5.8839 | 5.8754 | 5.8754 | 187824.0 |
| 2008-07-23 08:02:00 | AAPL | Stock | 5.875 | 5.875 | 5.8571 | 5.8571 | 304444.0 |
| 2008-07-23 08:03:00 | AAPL | Stock | 5.8571 | 5.8679 | 5.8571 | 5.8596 | 67200.0 |
| 2008-07-23 08:04:00 | AAPL | Stock | 5.8661 | 5.8661 | 5.8575 | 5.8589 | 58632.0 |
| 2008-07-23 08:05:00 | AAPL | Stock | 5.8582 | 5.8689 | 5.8571 | 5.8646 | 139076.0 |
| 2008-07-23 08:06:00 | AAPL | Stock | 5.8643 | 5.875 | 5.8643 | 5.8714 | 78400.0 |
| 2008-07-23 08:07:00 | AAPL | Stock | 5.8682 | 5.8757 | 5.8593 | 5.875 | 383320.0 |
| 2008-07-23 08:08:00 | AAPL | Stock | 5.8786 | 5.8821 | 5.8686 | 5.8779 | 130704.0 |
| 2008-07-23 08:09:00 | AAPL | Stock | 5.8764 | 5.8786 | 5.875 | 5.875 | 114940.0 |
> showing 50 of 1,045,453 rows — these rows as CSV