PREVIEW / stock_1min / 2005-08-26
file: by_date/stock_1min/2005/2005-08-26.parquet size: 6.6 MB rows: 550,435 symbols: 1,684
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-08-26 08:41:00 | AAPL | Stock | 1.6493 | 1.6518 | 1.6493 | 1.6514 | 103124.0 |
| 2005-08-26 08:42:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 14000.0 |
| 2005-08-26 08:45:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6521 | 1.6521 | 33600.0 |
| 2005-08-26 08:47:00 | AAPL | Stock | 1.6525 | 1.6525 | 1.6525 | 1.6525 | 2800.0 |
| 2005-08-26 08:50:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6532 | 1.6532 | 2800.0 |
| 2005-08-26 08:51:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6532 | 1.6532 | 14000.0 |
| 2005-08-26 08:52:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6518 | 1.6518 | 84000.0 |
| 2005-08-26 08:53:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 56000.0 |
| 2005-08-26 08:54:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 28000.0 |
| 2005-08-26 08:55:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 515200.0 |
| 2005-08-26 08:58:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 28000.0 |
| 2005-08-26 09:05:00 | AAPL | Stock | 1.6514 | 1.6521 | 1.6514 | 1.6518 | 79800.0 |
| 2005-08-26 09:06:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 9800.0 |
| 2005-08-26 09:10:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6532 | 1.6532 | 5600.0 |
| 2005-08-26 09:11:00 | AAPL | Stock | 1.6532 | 1.6536 | 1.6521 | 1.6536 | 47600.0 |
| 2005-08-26 09:15:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6521 | 1.6521 | 2800.0 |
| 2005-08-26 09:21:00 | AAPL | Stock | 1.6511 | 1.6511 | 1.6511 | 1.6511 | 19600.0 |
| 2005-08-26 09:23:00 | AAPL | Stock | 1.6514 | 1.6514 | 1.6514 | 1.6514 | 8400.0 |
| 2005-08-26 09:25:00 | AAPL | Stock | 1.65 | 1.6518 | 1.65 | 1.6518 | 36400.0 |
| 2005-08-26 09:26:00 | AAPL | Stock | 1.6525 | 1.6536 | 1.6525 | 1.6536 | 28000.0 |
| 2005-08-26 09:27:00 | AAPL | Stock | 1.6543 | 1.655 | 1.6536 | 1.6536 | 14000.0 |
| 2005-08-26 09:28:00 | AAPL | Stock | 1.6543 | 1.6543 | 1.6543 | 1.6543 | 2800.0 |
| 2005-08-26 09:29:00 | AAPL | Stock | 1.6543 | 1.6568 | 1.6446 | 1.6446 | 1587600.0 |
| 2005-08-26 09:30:00 | AAPL | Stock | 1.6471 | 1.6507 | 1.6464 | 1.6496 | 3080140.0 |
| 2005-08-26 09:31:00 | AAPL | Stock | 1.6496 | 1.655 | 1.6496 | 1.6543 | 4609444.0 |
| 2005-08-26 09:32:00 | AAPL | Stock | 1.6543 | 1.6543 | 1.6496 | 1.6511 | 565320.0 |
| 2005-08-26 09:33:00 | AAPL | Stock | 1.6507 | 1.6511 | 1.6482 | 1.65 | 822500.0 |
| 2005-08-26 09:34:00 | AAPL | Stock | 1.6496 | 1.6504 | 1.6482 | 1.6482 | 551600.0 |
| 2005-08-26 09:35:00 | AAPL | Stock | 1.6479 | 1.6482 | 1.6471 | 1.6472 | 763504.0 |
| 2005-08-26 09:36:00 | AAPL | Stock | 1.6475 | 1.6475 | 1.6457 | 1.6457 | 1551816.0 |
| 2005-08-26 09:37:00 | AAPL | Stock | 1.6461 | 1.65 | 1.6461 | 1.6486 | 1137780.0 |
| 2005-08-26 09:38:00 | AAPL | Stock | 1.6486 | 1.6489 | 1.6461 | 1.6461 | 536480.0 |
| 2005-08-26 09:39:00 | AAPL | Stock | 1.6464 | 1.6464 | 1.6436 | 1.6439 | 1285592.0 |
| 2005-08-26 09:40:00 | AAPL | Stock | 1.6439 | 1.645 | 1.6407 | 1.6411 | 1896216.0 |
| 2005-08-26 09:41:00 | AAPL | Stock | 1.6414 | 1.6414 | 1.6379 | 1.6393 | 2015076.0 |
| 2005-08-26 09:42:00 | AAPL | Stock | 1.6393 | 1.6414 | 1.6386 | 1.6396 | 1423576.0 |
| 2005-08-26 09:43:00 | AAPL | Stock | 1.6393 | 1.6396 | 1.6379 | 1.6379 | 622664.0 |
| 2005-08-26 09:44:00 | AAPL | Stock | 1.6382 | 1.64 | 1.6379 | 1.64 | 1345400.0 |
| 2005-08-26 09:45:00 | AAPL | Stock | 1.6404 | 1.6404 | 1.6382 | 1.6382 | 778400.0 |
| 2005-08-26 09:46:00 | AAPL | Stock | 1.6386 | 1.6389 | 1.6339 | 1.6361 | 2693516.0 |
| 2005-08-26 09:47:00 | AAPL | Stock | 1.635 | 1.6364 | 1.6325 | 1.6332 | 2171988.0 |
| 2005-08-26 09:48:00 | AAPL | Stock | 1.635 | 1.635 | 1.6286 | 1.63 | 3074624.0 |
| 2005-08-26 09:49:00 | AAPL | Stock | 1.6296 | 1.6303 | 1.6261 | 1.6261 | 1973272.0 |
| 2005-08-26 09:50:00 | AAPL | Stock | 1.6261 | 1.6311 | 1.6261 | 1.6307 | 3034640.0 |
| 2005-08-26 09:51:00 | AAPL | Stock | 1.6307 | 1.6346 | 1.6304 | 1.6335 | 1755432.0 |
| 2005-08-26 09:52:00 | AAPL | Stock | 1.6336 | 1.6339 | 1.6311 | 1.6318 | 1667624.0 |
| 2005-08-26 09:53:00 | AAPL | Stock | 1.6314 | 1.6321 | 1.6289 | 1.6289 | 1561196.0 |
| 2005-08-26 09:54:00 | AAPL | Stock | 1.6289 | 1.6311 | 1.6275 | 1.6275 | 758772.0 |
| 2005-08-26 09:55:00 | AAPL | Stock | 1.6282 | 1.63 | 1.6264 | 1.6296 | 2049348.0 |
| 2005-08-26 09:56:00 | AAPL | Stock | 1.6293 | 1.6307 | 1.6268 | 1.6304 | 2791488.0 |
> showing 50 of 550,435 rows — these rows as CSV