PREVIEW / stock_1min / 2005-06-09
file: by_date/stock_1min/2005/2005-06-09.parquet size: 6.7 MB rows: 550,606 symbols: 1,630
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-06-09 08:17:00 | AAPL | Stock | 1.3143 | 1.3143 | 1.3143 | 1.3143 | 11900.0 |
| 2005-06-09 08:23:00 | AAPL | Stock | 1.3157 | 1.3157 | 1.3157 | 1.3157 | 14000.0 |
| 2005-06-09 08:38:00 | AAPL | Stock | 1.3157 | 1.3157 | 1.3157 | 1.3157 | 25200.0 |
| 2005-06-09 09:08:00 | AAPL | Stock | 1.3168 | 1.3168 | 1.3168 | 1.3168 | 7280.0 |
| 2005-06-09 09:09:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3164 | 1.3164 | 28000.0 |
| 2005-06-09 09:11:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3164 | 1.3164 | 28000.0 |
| 2005-06-09 09:13:00 | AAPL | Stock | 1.3168 | 1.3168 | 1.3168 | 1.3168 | 5600.0 |
| 2005-06-09 09:18:00 | AAPL | Stock | 1.3211 | 1.3214 | 1.3207 | 1.3207 | 98000.0 |
| 2005-06-09 09:19:00 | AAPL | Stock | 1.3214 | 1.3214 | 1.3214 | 1.3214 | 14000.0 |
| 2005-06-09 09:21:00 | AAPL | Stock | 1.3218 | 1.3218 | 1.3218 | 1.3218 | 5600.0 |
| 2005-06-09 09:25:00 | AAPL | Stock | 1.3218 | 1.3218 | 1.3214 | 1.3214 | 165200.0 |
| 2005-06-09 09:26:00 | AAPL | Stock | 1.3214 | 1.3214 | 1.3214 | 1.3214 | 280000.0 |
| 2005-06-09 09:27:00 | AAPL | Stock | 1.3214 | 1.3214 | 1.3214 | 1.3214 | 112000.0 |
| 2005-06-09 09:28:00 | AAPL | Stock | 1.3214 | 1.3214 | 1.3214 | 1.3214 | 2800.0 |
| 2005-06-09 09:29:00 | AAPL | Stock | 1.3214 | 1.3214 | 1.3196 | 1.3196 | 259952.0 |
| 2005-06-09 09:30:00 | AAPL | Stock | 1.3214 | 1.325 | 1.3189 | 1.3246 | 4077612.0 |
| 2005-06-09 09:31:00 | AAPL | Stock | 1.3246 | 1.325 | 1.3211 | 1.3214 | 636160.0 |
| 2005-06-09 09:32:00 | AAPL | Stock | 1.3214 | 1.3268 | 1.3214 | 1.3268 | 1602244.0 |
| 2005-06-09 09:33:00 | AAPL | Stock | 1.3264 | 1.3275 | 1.3243 | 1.3275 | 1898876.0 |
| 2005-06-09 09:34:00 | AAPL | Stock | 1.3275 | 1.3296 | 1.3275 | 1.3286 | 2089164.0 |
| 2005-06-09 09:35:00 | AAPL | Stock | 1.3286 | 1.3289 | 1.3254 | 1.3279 | 1347640.0 |
| 2005-06-09 09:36:00 | AAPL | Stock | 1.3279 | 1.3286 | 1.3264 | 1.3271 | 1008980.0 |
| 2005-06-09 09:37:00 | AAPL | Stock | 1.3268 | 1.3289 | 1.3268 | 1.3279 | 1812328.0 |
| 2005-06-09 09:38:00 | AAPL | Stock | 1.3275 | 1.3279 | 1.325 | 1.3264 | 1219708.0 |
| 2005-06-09 09:39:00 | AAPL | Stock | 1.3264 | 1.3271 | 1.325 | 1.3268 | 925876.0 |
| 2005-06-09 09:40:00 | AAPL | Stock | 1.3268 | 1.3275 | 1.3268 | 1.3268 | 722932.0 |
| 2005-06-09 09:41:00 | AAPL | Stock | 1.3268 | 1.3268 | 1.325 | 1.3268 | 809984.0 |
| 2005-06-09 09:42:00 | AAPL | Stock | 1.3268 | 1.3289 | 1.3261 | 1.3286 | 1650012.0 |
| 2005-06-09 09:43:00 | AAPL | Stock | 1.3286 | 1.3296 | 1.3275 | 1.3289 | 2408784.0 |
| 2005-06-09 09:44:00 | AAPL | Stock | 1.3293 | 1.33 | 1.3286 | 1.3296 | 868896.0 |
| 2005-06-09 09:45:00 | AAPL | Stock | 1.3296 | 1.3339 | 1.3296 | 1.3325 | 3906112.0 |
| 2005-06-09 09:46:00 | AAPL | Stock | 1.3321 | 1.3336 | 1.3307 | 1.3329 | 1267112.0 |
| 2005-06-09 09:47:00 | AAPL | Stock | 1.3325 | 1.3329 | 1.3296 | 1.33 | 1426432.0 |
| 2005-06-09 09:48:00 | AAPL | Stock | 1.33 | 1.3304 | 1.3289 | 1.33 | 917364.0 |
| 2005-06-09 09:49:00 | AAPL | Stock | 1.3296 | 1.3304 | 1.3296 | 1.3304 | 750820.0 |
| 2005-06-09 09:50:00 | AAPL | Stock | 1.3304 | 1.3311 | 1.33 | 1.3307 | 1230320.0 |
| 2005-06-09 09:51:00 | AAPL | Stock | 1.3307 | 1.3321 | 1.3304 | 1.3321 | 1493464.0 |
| 2005-06-09 09:52:00 | AAPL | Stock | 1.3321 | 1.3332 | 1.3318 | 1.3318 | 1417920.0 |
| 2005-06-09 09:53:00 | AAPL | Stock | 1.3318 | 1.3321 | 1.3311 | 1.3318 | 318192.0 |
| 2005-06-09 09:54:00 | AAPL | Stock | 1.3318 | 1.3318 | 1.3307 | 1.3318 | 837312.0 |
| 2005-06-09 09:55:00 | AAPL | Stock | 1.3318 | 1.3339 | 1.3311 | 1.3336 | 1223768.0 |
| 2005-06-09 09:56:00 | AAPL | Stock | 1.3336 | 1.3336 | 1.3314 | 1.3318 | 539420.0 |
| 2005-06-09 09:57:00 | AAPL | Stock | 1.3318 | 1.3318 | 1.3307 | 1.3311 | 786744.0 |
| 2005-06-09 09:58:00 | AAPL | Stock | 1.3307 | 1.3307 | 1.3289 | 1.3289 | 976192.0 |
| 2005-06-09 09:59:00 | AAPL | Stock | 1.3289 | 1.3311 | 1.3286 | 1.3311 | 1354808.0 |
| 2005-06-09 10:00:00 | AAPL | Stock | 1.3307 | 1.3325 | 1.3293 | 1.3293 | 1113084.0 |
| 2005-06-09 10:01:00 | AAPL | Stock | 1.3296 | 1.3311 | 1.3264 | 1.3307 | 2284996.0 |
| 2005-06-09 10:02:00 | AAPL | Stock | 1.3311 | 1.3314 | 1.3275 | 1.3289 | 2048200.0 |
| 2005-06-09 10:03:00 | AAPL | Stock | 1.3289 | 1.3304 | 1.3275 | 1.3279 | 1470308.0 |
| 2005-06-09 10:04:00 | AAPL | Stock | 1.3282 | 1.33 | 1.3279 | 1.33 | 1332772.0 |
> showing 50 of 550,606 rows — these rows as CSV