PREVIEW / stock_5min / 2005-10-07
file: by_date/stock_5min/2005/2005-10-07.parquet size: 2.7 MB rows: 198,582 symbols: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-07 07:05:00 | AAPL | Stock | 1.8446 | 1.8446 | 1.8182 | 1.8243 | 215600.0 |
| 2005-10-07 07:10:00 | AAPL | Stock | 1.8236 | 1.8236 | 1.8143 | 1.8161 | 173600.0 |
| 2005-10-07 07:15:00 | AAPL | Stock | 1.8161 | 1.8161 | 1.8118 | 1.8118 | 52080.0 |
| 2005-10-07 07:20:00 | AAPL | Stock | 1.8146 | 1.8146 | 1.8146 | 1.8146 | 28000.0 |
| 2005-10-07 07:25:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 28000.0 |
| 2005-10-07 07:30:00 | AAPL | Stock | 1.8143 | 1.8189 | 1.8143 | 1.8189 | 70000.0 |
| 2005-10-07 07:35:00 | AAPL | Stock | 1.8171 | 1.8171 | 1.8171 | 1.8171 | 26040.0 |
| 2005-10-07 07:40:00 | AAPL | Stock | 1.8196 | 1.8196 | 1.8196 | 1.8196 | 5600.0 |
| 2005-10-07 07:45:00 | AAPL | Stock | 1.8186 | 1.8193 | 1.8143 | 1.8193 | 30800.0 |
| 2005-10-07 07:50:00 | AAPL | Stock | 1.8143 | 1.8161 | 1.8143 | 1.8143 | 86800.0 |
| 2005-10-07 08:00:00 | AAPL | Stock | 1.8129 | 1.8196 | 1.8036 | 1.8036 | 1255856.0 |
| 2005-10-07 08:05:00 | AAPL | Stock | 1.8036 | 1.8093 | 1.8018 | 1.8036 | 802508.0 |
| 2005-10-07 08:10:00 | AAPL | Stock | 1.8036 | 1.8111 | 1.8032 | 1.8075 | 420952.0 |
| 2005-10-07 08:15:00 | AAPL | Stock | 1.8075 | 1.8079 | 1.8057 | 1.8068 | 304500.0 |
| 2005-10-07 08:20:00 | AAPL | Stock | 1.8057 | 1.8061 | 1.8018 | 1.8018 | 673848.0 |
| 2005-10-07 08:25:00 | AAPL | Stock | 1.8021 | 1.8068 | 1.8018 | 1.8054 | 410004.0 |
| 2005-10-07 08:30:00 | AAPL | Stock | 1.805 | 1.81 | 1.8043 | 1.8054 | 584640.0 |
| 2005-10-07 08:35:00 | AAPL | Stock | 1.8064 | 1.8146 | 1.8061 | 1.8111 | 480564.0 |
| 2005-10-07 08:40:00 | AAPL | Stock | 1.8171 | 1.8214 | 1.8111 | 1.8179 | 498232.0 |
| 2005-10-07 08:45:00 | AAPL | Stock | 1.8193 | 1.8318 | 1.8161 | 1.8261 | 1079036.0 |
| 2005-10-07 08:50:00 | AAPL | Stock | 1.8271 | 1.8279 | 1.8257 | 1.8257 | 336420.0 |
| 2005-10-07 08:55:00 | AAPL | Stock | 1.8264 | 1.8314 | 1.8261 | 1.8314 | 879340.0 |
| 2005-10-07 09:00:00 | AAPL | Stock | 1.8314 | 1.8393 | 1.8311 | 1.8343 | 967176.0 |
| 2005-10-07 09:05:00 | AAPL | Stock | 1.8361 | 1.8411 | 1.8336 | 1.8343 | 1101380.0 |
| 2005-10-07 09:10:00 | AAPL | Stock | 1.835 | 1.8382 | 1.8332 | 1.8375 | 525644.0 |
| 2005-10-07 09:15:00 | AAPL | Stock | 1.8375 | 1.8479 | 1.8375 | 1.8432 | 1216320.0 |
| 2005-10-07 09:20:00 | AAPL | Stock | 1.8432 | 1.8461 | 1.8393 | 1.8421 | 619528.0 |
| 2005-10-07 09:25:00 | AAPL | Stock | 1.8404 | 1.8482 | 1.8393 | 1.8475 | 1708056.0 |
| 2005-10-07 09:30:00 | AAPL | Stock | 1.8471 | 1.8546 | 1.835 | 1.8364 | 29684816.0 |
| 2005-10-07 09:35:00 | AAPL | Stock | 1.8364 | 1.8399 | 1.8143 | 1.8218 | 32280472.0 |
| 2005-10-07 09:40:00 | AAPL | Stock | 1.8221 | 1.8261 | 1.8186 | 1.825 | 23892820.0 |
| 2005-10-07 09:45:00 | AAPL | Stock | 1.825 | 1.8271 | 1.8082 | 1.8136 | 29465632.0 |
| 2005-10-07 09:50:00 | AAPL | Stock | 1.8132 | 1.8261 | 1.8104 | 1.8204 | 26547780.0 |
| 2005-10-07 09:55:00 | AAPL | Stock | 1.8204 | 1.8257 | 1.8189 | 1.8204 | 13268948.0 |
| 2005-10-07 10:00:00 | AAPL | Stock | 1.8204 | 1.8243 | 1.8125 | 1.8211 | 16690660.0 |
| 2005-10-07 10:05:00 | AAPL | Stock | 1.8207 | 1.8211 | 1.8093 | 1.8171 | 15541512.0 |
| 2005-10-07 10:10:00 | AAPL | Stock | 1.8171 | 1.8189 | 1.8057 | 1.8064 | 12073236.0 |
| 2005-10-07 10:15:00 | AAPL | Stock | 1.8064 | 1.8154 | 1.8054 | 1.8143 | 14999684.0 |
| 2005-10-07 10:20:00 | AAPL | Stock | 1.8143 | 1.8154 | 1.8064 | 1.815 | 15355340.0 |
| 2005-10-07 10:25:00 | AAPL | Stock | 1.815 | 1.8161 | 1.8104 | 1.8125 | 11225368.0 |
| 2005-10-07 10:30:00 | AAPL | Stock | 1.8118 | 1.8168 | 1.8107 | 1.8154 | 13382152.0 |
| 2005-10-07 10:35:00 | AAPL | Stock | 1.8157 | 1.8239 | 1.8136 | 1.8182 | 13308400.0 |
| 2005-10-07 10:40:00 | AAPL | Stock | 1.8182 | 1.8207 | 1.8157 | 1.8164 | 10902864.0 |
| 2005-10-07 10:45:00 | AAPL | Stock | 1.8164 | 1.8171 | 1.81 | 1.8136 | 9947028.0 |
| 2005-10-07 10:50:00 | AAPL | Stock | 1.8136 | 1.8211 | 1.8129 | 1.8196 | 7483784.0 |
| 2005-10-07 10:55:00 | AAPL | Stock | 1.8196 | 1.8271 | 1.8193 | 1.8246 | 11836300.0 |
| 2005-10-07 11:00:00 | AAPL | Stock | 1.8246 | 1.83 | 1.8243 | 1.8279 | 10418352.0 |
| 2005-10-07 11:05:00 | AAPL | Stock | 1.8271 | 1.83 | 1.8236 | 1.8239 | 8272992.0 |
| 2005-10-07 11:10:00 | AAPL | Stock | 1.8239 | 1.8271 | 1.8196 | 1.8211 | 7740348.0 |
| 2005-10-07 11:15:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8168 | 1.8186 | 5841052.0 |
> showing 50 of 198,582 rows — these rows as CSV