PREVIEW / stock_1min / 2005-01-31
file: by_date/stock_1min/2005/2005-01-31.parquet size: 6.7 MB rows: 559,460 symbols: 1,587
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-01-31 08:00:00 | AAPL | Stock | 1.3263 | 1.3313 | 1.3263 | 1.3313 | 39200.0 |
| 2005-01-31 08:01:00 | AAPL | Stock | 1.3279 | 1.3382 | 1.3279 | 1.3382 | 257040.0 |
| 2005-01-31 08:02:00 | AAPL | Stock | 1.3375 | 1.3375 | 1.3375 | 1.3375 | 168000.0 |
| 2005-01-31 08:03:00 | AAPL | Stock | 1.3379 | 1.3379 | 1.3379 | 1.3379 | 16800.0 |
| 2005-01-31 08:04:00 | AAPL | Stock | 1.3348 | 1.3395 | 1.3321 | 1.3393 | 1212400.0 |
| 2005-01-31 08:05:00 | AAPL | Stock | 1.3389 | 1.3393 | 1.3389 | 1.3393 | 72800.0 |
| 2005-01-31 08:06:00 | AAPL | Stock | 1.3375 | 1.3393 | 1.3375 | 1.3375 | 56000.0 |
| 2005-01-31 08:07:00 | AAPL | Stock | 1.3361 | 1.3361 | 1.3357 | 1.3357 | 263200.0 |
| 2005-01-31 08:08:00 | AAPL | Stock | 1.3357 | 1.3375 | 1.3357 | 1.3357 | 106400.0 |
| 2005-01-31 08:12:00 | AAPL | Stock | 1.3366 | 1.3379 | 1.3366 | 1.3379 | 30800.0 |
| 2005-01-31 08:13:00 | AAPL | Stock | 1.3373 | 1.3393 | 1.3373 | 1.3393 | 723296.0 |
| 2005-01-31 08:14:00 | AAPL | Stock | 1.3407 | 1.3411 | 1.3393 | 1.3411 | 336000.0 |
| 2005-01-31 08:15:00 | AAPL | Stock | 1.3421 | 1.3434 | 1.3393 | 1.3411 | 190680.0 |
| 2005-01-31 08:16:00 | AAPL | Stock | 1.3411 | 1.3411 | 1.3393 | 1.3393 | 158200.0 |
| 2005-01-31 08:17:00 | AAPL | Stock | 1.3395 | 1.3407 | 1.3393 | 1.3407 | 218400.0 |
| 2005-01-31 08:18:00 | AAPL | Stock | 1.3393 | 1.3402 | 1.3393 | 1.3402 | 135296.0 |
| 2005-01-31 08:20:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3391 | 1.3393 | 63280.0 |
| 2005-01-31 08:21:00 | AAPL | Stock | 1.3396 | 1.3396 | 1.3393 | 1.3393 | 185920.0 |
| 2005-01-31 08:22:00 | AAPL | Stock | 1.3391 | 1.3409 | 1.3391 | 1.3407 | 123200.0 |
| 2005-01-31 08:23:00 | AAPL | Stock | 1.3396 | 1.3396 | 1.3396 | 1.3396 | 112000.0 |
| 2005-01-31 08:24:00 | AAPL | Stock | 1.3396 | 1.3411 | 1.3396 | 1.3411 | 36400.0 |
| 2005-01-31 08:25:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3393 | 1.3393 | 5600.0 |
| 2005-01-31 08:26:00 | AAPL | Stock | 1.3411 | 1.3411 | 1.3411 | 1.3411 | 11200.0 |
| 2005-01-31 08:27:00 | AAPL | Stock | 1.3411 | 1.3411 | 1.3411 | 1.3411 | 72800.0 |
| 2005-01-31 08:28:00 | AAPL | Stock | 1.3402 | 1.3402 | 1.3393 | 1.3393 | 397600.0 |
| 2005-01-31 08:29:00 | AAPL | Stock | 1.3393 | 1.3402 | 1.3393 | 1.34 | 61600.0 |
| 2005-01-31 08:30:00 | AAPL | Stock | 1.34 | 1.3402 | 1.3393 | 1.3402 | 140000.0 |
| 2005-01-31 08:31:00 | AAPL | Stock | 1.3402 | 1.3402 | 1.3402 | 1.3402 | 50400.0 |
| 2005-01-31 08:32:00 | AAPL | Stock | 1.3396 | 1.3402 | 1.3393 | 1.3393 | 694400.0 |
| 2005-01-31 08:33:00 | AAPL | Stock | 1.3402 | 1.3411 | 1.3393 | 1.3393 | 326200.0 |
| 2005-01-31 08:34:00 | AAPL | Stock | 1.3391 | 1.3393 | 1.3384 | 1.3393 | 210000.0 |
| 2005-01-31 08:35:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3393 | 1.3393 | 61600.0 |
| 2005-01-31 08:36:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3393 | 1.3393 | 96712.0 |
| 2005-01-31 08:37:00 | AAPL | Stock | 1.3379 | 1.3395 | 1.3379 | 1.3395 | 82600.0 |
| 2005-01-31 08:38:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3375 | 1.3393 | 258328.0 |
| 2005-01-31 08:39:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3393 | 1.3393 | 72800.0 |
| 2005-01-31 08:40:00 | AAPL | Stock | 1.3377 | 1.3377 | 1.3375 | 1.3375 | 72800.0 |
| 2005-01-31 08:41:00 | AAPL | Stock | 1.3384 | 1.3384 | 1.3357 | 1.3357 | 402808.0 |
| 2005-01-31 08:43:00 | AAPL | Stock | 1.3373 | 1.3377 | 1.3373 | 1.3377 | 62048.0 |
| 2005-01-31 08:44:00 | AAPL | Stock | 1.3375 | 1.3375 | 1.3375 | 1.3375 | 6720.0 |
| 2005-01-31 08:45:00 | AAPL | Stock | 1.3366 | 1.3366 | 1.3359 | 1.3359 | 32088.0 |
| 2005-01-31 08:46:00 | AAPL | Stock | 1.3359 | 1.3366 | 1.3357 | 1.3366 | 84000.0 |
| 2005-01-31 08:47:00 | AAPL | Stock | 1.3377 | 1.3377 | 1.3375 | 1.3375 | 12712.0 |
| 2005-01-31 08:49:00 | AAPL | Stock | 1.3373 | 1.3373 | 1.3373 | 1.3373 | 28000.0 |
| 2005-01-31 08:51:00 | AAPL | Stock | 1.337 | 1.337 | 1.337 | 1.337 | 19600.0 |
| 2005-01-31 08:55:00 | AAPL | Stock | 1.3377 | 1.3377 | 1.3377 | 1.3377 | 56000.0 |
| 2005-01-31 08:56:00 | AAPL | Stock | 1.3377 | 1.3384 | 1.3377 | 1.3384 | 35392.0 |
| 2005-01-31 08:57:00 | AAPL | Stock | 1.3379 | 1.3379 | 1.3375 | 1.3375 | 20608.0 |
| 2005-01-31 08:58:00 | AAPL | Stock | 1.3373 | 1.3384 | 1.3371 | 1.3384 | 166992.0 |
| 2005-01-31 08:59:00 | AAPL | Stock | 1.3391 | 1.3393 | 1.3391 | 1.3393 | 128688.0 |
> showing 50 of 559,460 rows — these rows as CSV