PREVIEW / stock_1min / 2007-11-15
file: by_date/stock_1min/2007/2007-11-15.parquet size: 12.2 MB rows: 990,686 symbols: 2,611
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-15 04:15:00 | AAPL | Stock | 5.8946 | 5.8946 | 5.8946 | 5.8946 | 2800.0 |
| 2007-11-15 05:42:00 | AAPL | Stock | 5.8575 | 5.8575 | 5.8575 | 5.8575 | 2800.0 |
| 2007-11-15 05:43:00 | AAPL | Stock | 5.8529 | 5.8529 | 5.8529 | 5.8529 | 5600.0 |
| 2007-11-15 05:49:00 | AAPL | Stock | 5.8536 | 5.8536 | 5.8536 | 5.8536 | 2800.0 |
| 2007-11-15 05:53:00 | AAPL | Stock | 5.8471 | 5.8471 | 5.8471 | 5.8471 | 5600.0 |
| 2007-11-15 05:55:00 | AAPL | Stock | 5.8489 | 5.8489 | 5.8489 | 5.8489 | 2800.0 |
| 2007-11-15 06:04:00 | AAPL | Stock | 5.8746 | 5.8746 | 5.8746 | 5.8746 | 11200.0 |
| 2007-11-15 06:06:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 2800.0 |
| 2007-11-15 06:37:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 28000.0 |
| 2007-11-15 07:00:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 42000.0 |
| 2007-11-15 07:01:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 12236.0 |
| 2007-11-15 07:03:00 | AAPL | Stock | 5.8768 | 5.8768 | 5.8768 | 5.8768 | 19432.0 |
| 2007-11-15 07:04:00 | AAPL | Stock | 5.8582 | 5.93 | 5.8582 | 5.93 | 8400.0 |
| 2007-11-15 07:10:00 | AAPL | Stock | 5.8825 | 5.8825 | 5.8825 | 5.8825 | 2800.0 |
| 2007-11-15 07:14:00 | AAPL | Stock | 5.8825 | 5.8825 | 5.8825 | 5.8825 | 6972.0 |
| 2007-11-15 07:18:00 | AAPL | Stock | 5.8818 | 5.8825 | 5.8818 | 5.8825 | 7392.0 |
| 2007-11-15 07:20:00 | AAPL | Stock | 5.8796 | 5.8796 | 5.8796 | 5.8796 | 14000.0 |
| 2007-11-15 07:22:00 | AAPL | Stock | 5.8829 | 5.8829 | 5.8796 | 5.8796 | 28000.0 |
| 2007-11-15 07:23:00 | AAPL | Stock | 5.8682 | 5.8682 | 5.8682 | 5.8682 | 2800.0 |
| 2007-11-15 07:26:00 | AAPL | Stock | 5.8614 | 5.8614 | 5.8614 | 5.8614 | 8400.0 |
| 2007-11-15 07:27:00 | AAPL | Stock | 5.8746 | 5.8746 | 5.8746 | 5.8746 | 11200.0 |
| 2007-11-15 07:30:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 2800.0 |
| 2007-11-15 07:34:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.8875 | 5.8875 | 8400.0 |
| 2007-11-15 07:37:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8968 | 5.8968 | 8400.0 |
| 2007-11-15 07:38:00 | AAPL | Stock | 5.8968 | 5.9046 | 5.8968 | 5.9046 | 36092.0 |
| 2007-11-15 07:41:00 | AAPL | Stock | 5.9 | 5.9046 | 5.9 | 5.9046 | 73584.0 |
| 2007-11-15 07:43:00 | AAPL | Stock | 5.9207 | 5.9214 | 5.9207 | 5.9214 | 56000.0 |
| 2007-11-15 07:52:00 | AAPL | Stock | 5.9193 | 5.9211 | 5.9171 | 5.9211 | 67760.0 |
| 2007-11-15 07:55:00 | AAPL | Stock | 5.9004 | 5.9004 | 5.9004 | 5.9004 | 5600.0 |
| 2007-11-15 07:56:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.895 | 5.895 | 42000.0 |
| 2007-11-15 07:58:00 | AAPL | Stock | 5.8986 | 5.9 | 5.8929 | 5.8932 | 21000.0 |
| 2007-11-15 08:00:00 | AAPL | Stock | 5.8932 | 5.9125 | 5.8929 | 5.9071 | 297724.0 |
| 2007-11-15 08:01:00 | AAPL | Stock | 5.9071 | 5.9339 | 5.9071 | 5.92 | 364448.0 |
| 2007-11-15 08:02:00 | AAPL | Stock | 5.9232 | 5.9336 | 5.9089 | 5.9336 | 299908.0 |
| 2007-11-15 08:03:00 | AAPL | Stock | 5.9289 | 5.9525 | 5.9289 | 5.9525 | 74480.0 |
| 2007-11-15 08:04:00 | AAPL | Stock | 5.9532 | 5.9643 | 5.9468 | 5.9643 | 136360.0 |
| 2007-11-15 08:05:00 | AAPL | Stock | 5.9636 | 5.9639 | 5.9479 | 5.9554 | 231056.0 |
| 2007-11-15 08:06:00 | AAPL | Stock | 5.9554 | 5.9618 | 5.9536 | 5.9536 | 57960.0 |
| 2007-11-15 08:07:00 | AAPL | Stock | 5.9604 | 5.9714 | 5.9518 | 5.9625 | 545188.0 |
| 2007-11-15 08:08:00 | AAPL | Stock | 5.9639 | 6.0 | 5.9639 | 6.0 | 359520.0 |
| 2007-11-15 08:09:00 | AAPL | Stock | 5.9964 | 6.0175 | 5.9964 | 6.0107 | 330260.0 |
| 2007-11-15 08:10:00 | AAPL | Stock | 6.0071 | 6.015 | 6.0036 | 6.0036 | 92708.0 |
| 2007-11-15 08:11:00 | AAPL | Stock | 6.0021 | 6.0036 | 5.9932 | 6.0 | 286132.0 |
| 2007-11-15 08:12:00 | AAPL | Stock | 6.0004 | 6.0175 | 6.0 | 6.0143 | 368676.0 |
| 2007-11-15 08:13:00 | AAPL | Stock | 6.0143 | 6.0204 | 6.0054 | 6.0154 | 218428.0 |
| 2007-11-15 08:14:00 | AAPL | Stock | 6.0154 | 6.02 | 6.0071 | 6.0071 | 68348.0 |
| 2007-11-15 08:15:00 | AAPL | Stock | 6.0071 | 6.0071 | 5.9982 | 6.005 | 260960.0 |
| 2007-11-15 08:16:00 | AAPL | Stock | 6.005 | 6.005 | 6.0 | 6.0032 | 195888.0 |
| 2007-11-15 08:17:00 | AAPL | Stock | 6.0032 | 6.0089 | 6.0021 | 6.0086 | 329672.0 |
| 2007-11-15 08:18:00 | AAPL | Stock | 6.0086 | 6.0157 | 6.0086 | 6.015 | 87752.0 |
> showing 50 of 990,686 rows — these rows as CSV