PREVIEW / stock_1min / 2005-02-22
file: by_date/stock_1min/2005/2005-02-22.parquet size: 7.2 MB rows: 593,530 symbols: 1,599
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-02-22 08:01:00 | AAPL | Stock | 1.5404 | 1.5404 | 1.5404 | 1.5404 | 111608.0 |
| 2005-02-22 08:02:00 | AAPL | Stock | 1.5461 | 1.5461 | 1.5461 | 1.5461 | 571200.0 |
| 2005-02-22 08:04:00 | AAPL | Stock | 1.5461 | 1.5461 | 1.5446 | 1.5446 | 84000.0 |
| 2005-02-22 08:06:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.542 | 1.542 | 44800.0 |
| 2005-02-22 08:07:00 | AAPL | Stock | 1.542 | 1.5445 | 1.542 | 1.5441 | 89600.0 |
| 2005-02-22 08:08:00 | AAPL | Stock | 1.5441 | 1.5441 | 1.5416 | 1.5441 | 117600.0 |
| 2005-02-22 08:09:00 | AAPL | Stock | 1.5441 | 1.5441 | 1.5411 | 1.5411 | 78400.0 |
| 2005-02-22 08:11:00 | AAPL | Stock | 1.5402 | 1.5402 | 1.5375 | 1.5375 | 64400.0 |
| 2005-02-22 08:12:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5375 | 1.5375 | 5600.0 |
| 2005-02-22 08:13:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5361 | 1.5361 | 49000.0 |
| 2005-02-22 08:14:00 | AAPL | Stock | 1.5359 | 1.5375 | 1.5357 | 1.5359 | 217840.0 |
| 2005-02-22 08:15:00 | AAPL | Stock | 1.5361 | 1.5361 | 1.5348 | 1.5357 | 636776.0 |
| 2005-02-22 08:16:00 | AAPL | Stock | 1.5361 | 1.5361 | 1.5357 | 1.5357 | 16800.0 |
| 2005-02-22 08:18:00 | AAPL | Stock | 1.5375 | 1.5384 | 1.5361 | 1.5384 | 171360.0 |
| 2005-02-22 08:20:00 | AAPL | Stock | 1.5393 | 1.5402 | 1.5393 | 1.5402 | 56000.0 |
| 2005-02-22 08:21:00 | AAPL | Stock | 1.5395 | 1.5395 | 1.5393 | 1.5393 | 28000.0 |
| 2005-02-22 08:22:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5375 | 1.5393 | 83104.0 |
| 2005-02-22 08:23:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 76160.0 |
| 2005-02-22 08:24:00 | AAPL | Stock | 1.5393 | 1.5396 | 1.5393 | 1.5396 | 733600.0 |
| 2005-02-22 08:25:00 | AAPL | Stock | 1.5404 | 1.5404 | 1.5404 | 1.5404 | 15288.0 |
| 2005-02-22 08:29:00 | AAPL | Stock | 1.5402 | 1.5402 | 1.5402 | 1.5402 | 5600.0 |
| 2005-02-22 08:31:00 | AAPL | Stock | 1.5393 | 1.5395 | 1.5393 | 1.5393 | 112000.0 |
| 2005-02-22 08:32:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 90048.0 |
| 2005-02-22 08:36:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 56000.0 |
| 2005-02-22 08:38:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5379 | 1.5379 | 62048.0 |
| 2005-02-22 08:39:00 | AAPL | Stock | 1.5379 | 1.5379 | 1.5379 | 1.5379 | 24528.0 |
| 2005-02-22 08:42:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 21728.0 |
| 2005-02-22 08:43:00 | AAPL | Stock | 1.5393 | 1.5416 | 1.5393 | 1.5416 | 32760.0 |
| 2005-02-22 08:44:00 | AAPL | Stock | 1.5414 | 1.5416 | 1.5414 | 1.5416 | 25984.0 |
| 2005-02-22 08:45:00 | AAPL | Stock | 1.5414 | 1.5421 | 1.5414 | 1.542 | 39200.0 |
| 2005-02-22 08:46:00 | AAPL | Stock | 1.542 | 1.542 | 1.542 | 1.542 | 11200.0 |
| 2005-02-22 08:47:00 | AAPL | Stock | 1.542 | 1.542 | 1.542 | 1.542 | 5600.0 |
| 2005-02-22 08:48:00 | AAPL | Stock | 1.542 | 1.542 | 1.5416 | 1.5416 | 33600.0 |
| 2005-02-22 08:49:00 | AAPL | Stock | 1.5416 | 1.5418 | 1.5413 | 1.5413 | 93296.0 |
| 2005-02-22 08:53:00 | AAPL | Stock | 1.5418 | 1.542 | 1.5416 | 1.5416 | 39200.0 |
| 2005-02-22 08:54:00 | AAPL | Stock | 1.5427 | 1.5427 | 1.5421 | 1.5421 | 11200.0 |
| 2005-02-22 08:55:00 | AAPL | Stock | 1.5429 | 1.5432 | 1.5429 | 1.5429 | 39200.0 |
| 2005-02-22 08:56:00 | AAPL | Stock | 1.5429 | 1.543 | 1.5425 | 1.5427 | 53200.0 |
| 2005-02-22 08:57:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5414 | 1.5414 | 173656.0 |
| 2005-02-22 08:58:00 | AAPL | Stock | 1.5413 | 1.5425 | 1.5413 | 1.5414 | 18480.0 |
| 2005-02-22 08:59:00 | AAPL | Stock | 1.5414 | 1.5414 | 1.5413 | 1.5414 | 79744.0 |
| 2005-02-22 09:01:00 | AAPL | Stock | 1.5423 | 1.5423 | 1.5411 | 1.5421 | 296352.0 |
| 2005-02-22 09:02:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5411 | 1.5411 | 54768.0 |
| 2005-02-22 09:03:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5405 | 1.5405 | 110880.0 |
| 2005-02-22 09:04:00 | AAPL | Stock | 1.5411 | 1.5414 | 1.5404 | 1.5404 | 238224.0 |
| 2005-02-22 09:05:00 | AAPL | Stock | 1.5396 | 1.54 | 1.5393 | 1.5395 | 224952.0 |
| 2005-02-22 09:06:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 53200.0 |
| 2005-02-22 09:07:00 | AAPL | Stock | 1.5393 | 1.5404 | 1.5393 | 1.5404 | 117600.0 |
| 2005-02-22 09:09:00 | AAPL | Stock | 1.5395 | 1.5395 | 1.5393 | 1.5393 | 72800.0 |
| 2005-02-22 09:10:00 | AAPL | Stock | 1.5407 | 1.5407 | 1.5407 | 1.5407 | 28000.0 |
> showing 50 of 593,530 rows — these rows as CSV