PREVIEW / stock_1min / 2009-08-03
file: by_date/stock_1min/2009/2009-08-03.parquet size: 13.5 MB rows: 1,022,544 symbols: 2,734
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-03 05:54:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 5600.0 |
| 2009-08-03 07:13:00 | AAPL | Stock | 5.9 | 5.9 | 5.9 | 5.9 | 5600.0 |
| 2009-08-03 07:27:00 | AAPL | Stock | 5.8907 | 5.8907 | 5.8907 | 5.8907 | 5040.0 |
| 2009-08-03 07:28:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 11200.0 |
| 2009-08-03 07:31:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8929 | 5.8929 | 26600.0 |
| 2009-08-03 07:37:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8982 | 5.8982 | 12152.0 |
| 2009-08-03 07:44:00 | AAPL | Stock | 5.895 | 5.895 | 5.895 | 5.895 | 2800.0 |
| 2009-08-03 07:48:00 | AAPL | Stock | 5.895 | 5.895 | 5.895 | 5.895 | 5600.0 |
| 2009-08-03 07:49:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 14000.0 |
| 2009-08-03 07:51:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 7980.0 |
| 2009-08-03 07:55:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 7112.0 |
| 2009-08-03 07:56:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 5600.0 |
| 2009-08-03 07:57:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 57036.0 |
| 2009-08-03 08:00:00 | AAPL | Stock | 5.9071 | 5.9121 | 5.8354 | 5.9 | 271152.0 |
| 2009-08-03 08:01:00 | AAPL | Stock | 5.8979 | 5.9007 | 5.8979 | 5.8979 | 22120.0 |
| 2009-08-03 08:02:00 | AAPL | Stock | 5.8979 | 5.8979 | 5.8936 | 5.8936 | 17080.0 |
| 2009-08-03 08:03:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8982 | 5.8982 | 5600.0 |
| 2009-08-03 08:04:00 | AAPL | Stock | 5.8979 | 5.8982 | 5.8964 | 5.8964 | 37800.0 |
| 2009-08-03 08:05:00 | AAPL | Stock | 5.9 | 5.9 | 5.8964 | 5.8964 | 40600.0 |
| 2009-08-03 08:06:00 | AAPL | Stock | 5.9 | 5.9036 | 5.8986 | 5.9018 | 104580.0 |
| 2009-08-03 08:07:00 | AAPL | Stock | 5.9032 | 5.9036 | 5.9018 | 5.9018 | 35112.0 |
| 2009-08-03 08:09:00 | AAPL | Stock | 5.9021 | 5.9043 | 5.9021 | 5.9043 | 19600.0 |
| 2009-08-03 08:10:00 | AAPL | Stock | 5.9 | 5.9018 | 5.9 | 5.9018 | 33600.0 |
| 2009-08-03 08:11:00 | AAPL | Stock | 5.9018 | 5.9021 | 5.9018 | 5.9018 | 37800.0 |
| 2009-08-03 08:12:00 | AAPL | Stock | 5.9021 | 5.9021 | 5.9021 | 5.9021 | 5600.0 |
| 2009-08-03 08:13:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9036 | 5.9036 | 8400.0 |
| 2009-08-03 08:14:00 | AAPL | Stock | 5.905 | 5.905 | 5.905 | 5.905 | 13916.0 |
| 2009-08-03 08:16:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9036 | 5.9036 | 25200.0 |
| 2009-08-03 08:17:00 | AAPL | Stock | 5.9021 | 5.9025 | 5.9021 | 5.9021 | 21504.0 |
| 2009-08-03 08:18:00 | AAPL | Stock | 5.9018 | 5.9021 | 5.9 | 5.9014 | 38388.0 |
| 2009-08-03 08:19:00 | AAPL | Stock | 5.9014 | 5.905 | 5.8989 | 5.9007 | 51856.0 |
| 2009-08-03 08:20:00 | AAPL | Stock | 5.9029 | 5.9029 | 5.9018 | 5.9018 | 33600.0 |
| 2009-08-03 08:21:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9036 | 5.9036 | 30800.0 |
| 2009-08-03 08:24:00 | AAPL | Stock | 5.9036 | 5.9071 | 5.9036 | 5.9071 | 53816.0 |
| 2009-08-03 08:25:00 | AAPL | Stock | 5.9093 | 5.9107 | 5.9071 | 5.9071 | 30184.0 |
| 2009-08-03 08:26:00 | AAPL | Stock | 5.9107 | 5.9121 | 5.9096 | 5.9121 | 42616.0 |
| 2009-08-03 08:27:00 | AAPL | Stock | 5.9132 | 5.9132 | 5.9132 | 5.9132 | 22400.0 |
| 2009-08-03 08:28:00 | AAPL | Stock | 5.9139 | 5.9143 | 5.9107 | 5.9143 | 99260.0 |
| 2009-08-03 08:29:00 | AAPL | Stock | 5.9171 | 5.9193 | 5.9171 | 5.9193 | 33600.0 |
| 2009-08-03 08:30:00 | AAPL | Stock | 5.9193 | 5.92 | 5.9171 | 5.9171 | 127624.0 |
| 2009-08-03 08:31:00 | AAPL | Stock | 5.9146 | 5.9146 | 5.9139 | 5.9139 | 63476.0 |
| 2009-08-03 08:32:00 | AAPL | Stock | 5.9168 | 5.9168 | 5.9096 | 5.9107 | 125440.0 |
| 2009-08-03 08:33:00 | AAPL | Stock | 5.9118 | 5.915 | 5.9107 | 5.915 | 35560.0 |
| 2009-08-03 08:34:00 | AAPL | Stock | 5.9164 | 5.9214 | 5.9164 | 5.9214 | 19600.0 |
| 2009-08-03 08:35:00 | AAPL | Stock | 5.9218 | 5.9268 | 5.9171 | 5.9214 | 116564.0 |
| 2009-08-03 08:36:00 | AAPL | Stock | 5.92 | 5.92 | 5.9171 | 5.9179 | 19600.0 |
| 2009-08-03 08:37:00 | AAPL | Stock | 5.9146 | 5.9146 | 5.9107 | 5.9107 | 69720.0 |
| 2009-08-03 08:38:00 | AAPL | Stock | 5.9143 | 5.9157 | 5.9143 | 5.9143 | 12124.0 |
| 2009-08-03 08:39:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9107 | 5.9125 | 38920.0 |
| 2009-08-03 08:40:00 | AAPL | Stock | 5.9125 | 5.9129 | 5.9107 | 5.9129 | 60340.0 |
> showing 50 of 1,022,544 rows — these rows as CSV