PREVIEW / stock_1min / 2007-05-18
file: by_date/stock_1min/2007/2007-05-18.parquet size: 10.9 MB rows: 901,300 symbols: 2,460
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-18 09:30:00 | AAPL | Stock | 3.9368 | 3.9393 | 3.9239 | 3.9311 | 56262584.0 |
| 2007-05-18 09:31:00 | AAPL | Stock | 3.9304 | 3.9354 | 3.9279 | 3.9339 | 4146436.0 |
| 2007-05-18 09:32:00 | AAPL | Stock | 3.9346 | 3.9375 | 3.9286 | 3.9357 | 3631124.0 |
| 2007-05-18 09:33:00 | AAPL | Stock | 3.9361 | 3.9461 | 3.9357 | 3.9461 | 7160860.0 |
| 2007-05-18 09:34:00 | AAPL | Stock | 3.9461 | 3.9482 | 3.94 | 3.9475 | 6625052.0 |
| 2007-05-18 09:35:00 | AAPL | Stock | 3.9475 | 3.9482 | 3.94 | 3.9429 | 6789832.0 |
| 2007-05-18 09:36:00 | AAPL | Stock | 3.9425 | 3.9482 | 3.9382 | 3.9446 | 4938556.0 |
| 2007-05-18 09:37:00 | AAPL | Stock | 3.9443 | 3.9481 | 3.9414 | 3.9436 | 2948568.0 |
| 2007-05-18 09:38:00 | AAPL | Stock | 3.9436 | 3.9454 | 3.9418 | 3.9425 | 2820132.0 |
| 2007-05-18 09:39:00 | AAPL | Stock | 3.9425 | 3.9432 | 3.9382 | 3.9429 | 4277364.0 |
| 2007-05-18 09:40:00 | AAPL | Stock | 3.9429 | 3.9431 | 3.9396 | 3.9418 | 2005164.0 |
| 2007-05-18 09:41:00 | AAPL | Stock | 3.9414 | 3.9421 | 3.9404 | 3.9408 | 1767976.0 |
| 2007-05-18 09:42:00 | AAPL | Stock | 3.9414 | 3.945 | 3.9407 | 3.945 | 3005912.0 |
| 2007-05-18 09:43:00 | AAPL | Stock | 3.9446 | 3.9468 | 3.9411 | 3.9432 | 3853780.0 |
| 2007-05-18 09:44:00 | AAPL | Stock | 3.9432 | 3.9464 | 3.9429 | 3.9432 | 2125732.0 |
| 2007-05-18 09:45:00 | AAPL | Stock | 3.9432 | 3.9443 | 3.9375 | 3.9386 | 3276476.0 |
| 2007-05-18 09:46:00 | AAPL | Stock | 3.9386 | 3.9389 | 3.9279 | 3.9339 | 6223476.0 |
| 2007-05-18 09:47:00 | AAPL | Stock | 3.9339 | 3.935 | 3.925 | 3.9307 | 4748016.0 |
| 2007-05-18 09:48:00 | AAPL | Stock | 3.931 | 3.9314 | 3.9286 | 3.9307 | 2654792.0 |
| 2007-05-18 09:49:00 | AAPL | Stock | 3.9307 | 3.9339 | 3.93 | 3.9332 | 2409120.0 |
| 2007-05-18 09:50:00 | AAPL | Stock | 3.9329 | 3.9368 | 3.9329 | 3.9354 | 2315292.0 |
| 2007-05-18 09:51:00 | AAPL | Stock | 3.9354 | 3.9364 | 3.935 | 3.935 | 1821876.0 |
| 2007-05-18 09:52:00 | AAPL | Stock | 3.9354 | 3.9379 | 3.935 | 3.9375 | 1891960.0 |
| 2007-05-18 09:53:00 | AAPL | Stock | 3.9375 | 3.9425 | 3.9375 | 3.9421 | 2856644.0 |
| 2007-05-18 09:54:00 | AAPL | Stock | 3.9421 | 3.9464 | 3.9404 | 3.9429 | 3910340.0 |
| 2007-05-18 09:55:00 | AAPL | Stock | 3.9432 | 3.9446 | 3.9411 | 3.9439 | 1634220.0 |
| 2007-05-18 09:56:00 | AAPL | Stock | 3.9436 | 3.9446 | 3.9396 | 3.9404 | 1913856.0 |
| 2007-05-18 09:57:00 | AAPL | Stock | 3.94 | 3.9404 | 3.9386 | 3.9393 | 1683640.0 |
| 2007-05-18 09:58:00 | AAPL | Stock | 3.9396 | 3.9418 | 3.9393 | 3.9407 | 950432.0 |
| 2007-05-18 09:59:00 | AAPL | Stock | 3.9407 | 3.9407 | 3.9364 | 3.9389 | 2277716.0 |
| 2007-05-18 10:00:00 | AAPL | Stock | 3.9393 | 3.9425 | 3.9386 | 3.9421 | 2223088.0 |
| 2007-05-18 10:01:00 | AAPL | Stock | 3.9418 | 3.9425 | 3.9368 | 3.9375 | 2303336.0 |
| 2007-05-18 10:02:00 | AAPL | Stock | 3.9382 | 3.9396 | 3.9339 | 3.9393 | 2540804.0 |
| 2007-05-18 10:03:00 | AAPL | Stock | 3.9393 | 3.9396 | 3.9343 | 3.9346 | 1460088.0 |
| 2007-05-18 10:04:00 | AAPL | Stock | 3.935 | 3.9366 | 3.9325 | 3.9346 | 2144828.0 |
| 2007-05-18 10:05:00 | AAPL | Stock | 3.935 | 3.9393 | 3.935 | 3.9382 | 1824564.0 |
| 2007-05-18 10:06:00 | AAPL | Stock | 3.9382 | 3.9393 | 3.9357 | 3.9375 | 2369864.0 |
| 2007-05-18 10:07:00 | AAPL | Stock | 3.9375 | 3.9386 | 3.9343 | 3.9364 | 2780204.0 |
| 2007-05-18 10:08:00 | AAPL | Stock | 3.9369 | 3.9411 | 3.9368 | 3.9386 | 3149944.0 |
| 2007-05-18 10:09:00 | AAPL | Stock | 3.9386 | 3.9429 | 3.9386 | 3.9414 | 2207464.0 |
| 2007-05-18 10:10:00 | AAPL | Stock | 3.9414 | 3.9418 | 3.9371 | 3.9418 | 1818264.0 |
| 2007-05-18 10:11:00 | AAPL | Stock | 3.9418 | 3.9457 | 3.9414 | 3.9457 | 3598252.0 |
| 2007-05-18 10:12:00 | AAPL | Stock | 3.9457 | 3.9475 | 3.9439 | 3.9454 | 6397076.0 |
| 2007-05-18 10:13:00 | AAPL | Stock | 3.9454 | 3.9514 | 3.9446 | 3.9493 | 6660752.0 |
| 2007-05-18 10:14:00 | AAPL | Stock | 3.9489 | 3.9514 | 3.9482 | 3.9511 | 4005624.0 |
| 2007-05-18 10:15:00 | AAPL | Stock | 3.9511 | 3.9511 | 3.9446 | 3.9479 | 3331888.0 |
| 2007-05-18 10:16:00 | AAPL | Stock | 3.9471 | 3.9482 | 3.9454 | 3.9479 | 1538516.0 |
| 2007-05-18 10:17:00 | AAPL | Stock | 3.9475 | 3.9486 | 3.9414 | 3.9422 | 3407124.0 |
| 2007-05-18 10:18:00 | AAPL | Stock | 3.9421 | 3.9425 | 3.9389 | 3.9414 | 2367540.0 |
| 2007-05-18 10:19:00 | AAPL | Stock | 3.9414 | 3.9418 | 3.9393 | 3.9396 | 1423408.0 |
> showing 50 of 901,300 rows — these rows as CSV