PREVIEW / stock_1min / 2009-08-06
file: by_date/stock_1min/2009/2009-08-06.parquet size: 13.1 MB rows: 999,327 symbols: 2,708
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-06 06:49:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 16828.0 |
| 2009-08-06 06:50:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 2828.0 |
| 2009-08-06 07:01:00 | AAPL | Stock | 5.8696 | 5.8696 | 5.8693 | 5.8693 | 8400.0 |
| 2009-08-06 07:07:00 | AAPL | Stock | 5.8786 | 5.8786 | 5.8786 | 5.8786 | 2800.0 |
| 2009-08-06 07:16:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2828.0 |
| 2009-08-06 07:39:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 5600.0 |
| 2009-08-06 07:43:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 11200.0 |
| 2009-08-06 07:44:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2800.0 |
| 2009-08-06 07:45:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 8400.0 |
| 2009-08-06 07:47:00 | AAPL | Stock | 5.8793 | 5.8793 | 5.8793 | 5.8793 | 4200.0 |
| 2009-08-06 07:52:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 5600.0 |
| 2009-08-06 07:58:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 8400.0 |
| 2009-08-06 07:59:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 14000.0 |
| 2009-08-06 08:00:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8821 | 5.8821 | 75516.0 |
| 2009-08-06 08:01:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8739 | 5.8739 | 21560.0 |
| 2009-08-06 08:02:00 | AAPL | Stock | 5.8739 | 5.8739 | 5.8714 | 5.8714 | 36120.0 |
| 2009-08-06 08:04:00 | AAPL | Stock | 5.8714 | 5.8739 | 5.8696 | 5.8696 | 26180.0 |
| 2009-08-06 08:07:00 | AAPL | Stock | 5.8768 | 5.8768 | 5.8768 | 5.8768 | 2800.0 |
| 2009-08-06 08:09:00 | AAPL | Stock | 5.8764 | 5.8821 | 5.8764 | 5.8818 | 41580.0 |
| 2009-08-06 08:12:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 8400.0 |
| 2009-08-06 08:15:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8889 | 5.8893 | 11200.0 |
| 2009-08-06 08:17:00 | AAPL | Stock | 5.8879 | 5.8879 | 5.8879 | 5.8879 | 9800.0 |
| 2009-08-06 08:19:00 | AAPL | Stock | 5.8896 | 5.8911 | 5.8895 | 5.8911 | 57680.0 |
| 2009-08-06 08:23:00 | AAPL | Stock | 5.8843 | 5.8843 | 5.8843 | 5.8843 | 2800.0 |
| 2009-08-06 08:24:00 | AAPL | Stock | 5.8807 | 5.8843 | 5.8775 | 5.8843 | 14280.0 |
| 2009-08-06 08:25:00 | AAPL | Stock | 5.8907 | 5.8907 | 5.8889 | 5.8889 | 8400.0 |
| 2009-08-06 08:26:00 | AAPL | Stock | 5.8889 | 5.8889 | 5.8889 | 5.8889 | 8400.0 |
| 2009-08-06 08:27:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8929 | 5.8929 | 28000.0 |
| 2009-08-06 08:30:00 | AAPL | Stock | 5.8886 | 5.9036 | 5.8886 | 5.9036 | 43568.0 |
| 2009-08-06 08:31:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9 | 5.9036 | 73304.0 |
| 2009-08-06 08:32:00 | AAPL | Stock | 5.9089 | 5.9121 | 5.9089 | 5.9118 | 28000.0 |
| 2009-08-06 08:33:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 4200.0 |
| 2009-08-06 08:34:00 | AAPL | Stock | 5.9075 | 5.9089 | 5.9075 | 5.9089 | 5600.0 |
| 2009-08-06 08:35:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9046 | 5.9068 | 22316.0 |
| 2009-08-06 08:36:00 | AAPL | Stock | 5.9036 | 5.9071 | 5.9036 | 5.9071 | 8484.0 |
| 2009-08-06 08:37:00 | AAPL | Stock | 5.9089 | 5.9089 | 5.9089 | 5.9089 | 14000.0 |
| 2009-08-06 08:38:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 28000.0 |
| 2009-08-06 08:39:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 2800.0 |
| 2009-08-06 08:40:00 | AAPL | Stock | 5.9107 | 5.9125 | 5.9107 | 5.9125 | 40068.0 |
| 2009-08-06 08:42:00 | AAPL | Stock | 5.9154 | 5.9154 | 5.915 | 5.915 | 26320.0 |
| 2009-08-06 08:43:00 | AAPL | Stock | 5.9154 | 5.9154 | 5.9154 | 5.9154 | 14000.0 |
| 2009-08-06 08:44:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9179 | 5.9179 | 5600.0 |
| 2009-08-06 08:45:00 | AAPL | Stock | 5.9171 | 5.9186 | 5.9171 | 5.9186 | 61292.0 |
| 2009-08-06 08:46:00 | AAPL | Stock | 5.9186 | 5.9186 | 5.9175 | 5.9175 | 8400.0 |
| 2009-08-06 08:47:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.915 | 5.9161 | 58800.0 |
| 2009-08-06 08:48:00 | AAPL | Stock | 5.9171 | 5.9186 | 5.9171 | 5.9186 | 21728.0 |
| 2009-08-06 08:49:00 | AAPL | Stock | 5.9196 | 5.9196 | 5.9179 | 5.9179 | 24612.0 |
| 2009-08-06 08:50:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9179 | 5.9179 | 25200.0 |
| 2009-08-06 08:51:00 | AAPL | Stock | 5.9189 | 5.9196 | 5.9189 | 5.9196 | 6300.0 |
| 2009-08-06 08:52:00 | AAPL | Stock | 5.9196 | 5.9196 | 5.9179 | 5.9179 | 72716.0 |
> showing 50 of 999,327 rows — these rows as CSV