PREVIEW / stock_1min / 2005-02-23
file: by_date/stock_1min/2005/2005-02-23.parquet size: 6.7 MB rows: 558,644 symbols: 1,595
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-23 08:00:00 | AAPL | Stock | 1.5241 | 1.5268 | 1.5241 | 1.5268 | 80080.0 |
| 2005-02-23 08:01:00 | AAPL | Stock | 1.525 | 1.5268 | 1.5241 | 1.5245 | 135744.0 |
| 2005-02-23 08:02:00 | AAPL | Stock | 1.5241 | 1.5241 | 1.5241 | 1.5241 | 10360.0 |
| 2005-02-23 08:03:00 | AAPL | Stock | 1.5248 | 1.525 | 1.5245 | 1.5245 | 159320.0 |
| 2005-02-23 08:04:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 124600.0 |
| 2005-02-23 08:05:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 72800.0 |
| 2005-02-23 08:06:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 78400.0 |
| 2005-02-23 08:07:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 84000.0 |
| 2005-02-23 08:08:00 | AAPL | Stock | 1.525 | 1.525 | 1.5243 | 1.525 | 81816.0 |
| 2005-02-23 08:11:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5266 | 1.5268 | 173600.0 |
| 2005-02-23 08:12:00 | AAPL | Stock | 1.5243 | 1.5243 | 1.5243 | 1.5243 | 7000.0 |
| 2005-02-23 08:13:00 | AAPL | Stock | 1.5243 | 1.5243 | 1.5243 | 1.5243 | 7000.0 |
| 2005-02-23 08:15:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 16800.0 |
| 2005-02-23 08:16:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 56000.0 |
| 2005-02-23 08:18:00 | AAPL | Stock | 1.525 | 1.5268 | 1.525 | 1.5268 | 67200.0 |
| 2005-02-23 08:20:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 55048.0 |
| 2005-02-23 08:21:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 53200.0 |
| 2005-02-23 08:23:00 | AAPL | Stock | 1.5259 | 1.5259 | 1.5259 | 1.5259 | 5600.0 |
| 2005-02-23 08:24:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5259 | 1.5259 | 56000.0 |
| 2005-02-23 08:28:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 5600.0 |
| 2005-02-23 08:29:00 | AAPL | Stock | 1.5259 | 1.5259 | 1.5255 | 1.5255 | 30240.0 |
| 2005-02-23 08:30:00 | AAPL | Stock | 1.5268 | 1.5279 | 1.5255 | 1.5277 | 562800.0 |
| 2005-02-23 08:31:00 | AAPL | Stock | 1.5277 | 1.5339 | 1.5277 | 1.533 | 890400.0 |
| 2005-02-23 08:32:00 | AAPL | Stock | 1.5346 | 1.5375 | 1.5336 | 1.5375 | 612696.0 |
| 2005-02-23 08:33:00 | AAPL | Stock | 1.5375 | 1.5429 | 1.5363 | 1.5429 | 1120504.0 |
| 2005-02-23 08:34:00 | AAPL | Stock | 1.5411 | 1.542 | 1.5405 | 1.5411 | 380800.0 |
| 2005-02-23 08:35:00 | AAPL | Stock | 1.5411 | 1.5438 | 1.5386 | 1.5438 | 1369200.0 |
| 2005-02-23 08:36:00 | AAPL | Stock | 1.5443 | 1.5443 | 1.5416 | 1.5421 | 462000.0 |
| 2005-02-23 08:37:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5414 | 1.5421 | 149800.0 |
| 2005-02-23 08:38:00 | AAPL | Stock | 1.5421 | 1.5429 | 1.5393 | 1.5405 | 523600.0 |
| 2005-02-23 08:39:00 | AAPL | Stock | 1.5402 | 1.5429 | 1.5395 | 1.5411 | 296800.0 |
| 2005-02-23 08:40:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5416 | 1.5416 | 116648.0 |
| 2005-02-23 08:41:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5405 | 1.5418 | 89600.0 |
| 2005-02-23 08:42:00 | AAPL | Stock | 1.5409 | 1.5421 | 1.5409 | 1.5411 | 276136.0 |
| 2005-02-23 08:43:00 | AAPL | Stock | 1.5407 | 1.5411 | 1.5396 | 1.5404 | 173600.0 |
| 2005-02-23 08:44:00 | AAPL | Stock | 1.5396 | 1.5396 | 1.5386 | 1.5393 | 85064.0 |
| 2005-02-23 08:45:00 | AAPL | Stock | 1.5386 | 1.5402 | 1.5384 | 1.5393 | 84000.0 |
| 2005-02-23 08:46:00 | AAPL | Stock | 1.5402 | 1.5411 | 1.5402 | 1.5405 | 82320.0 |
| 2005-02-23 08:47:00 | AAPL | Stock | 1.54 | 1.54 | 1.5395 | 1.5395 | 33600.0 |
| 2005-02-23 08:48:00 | AAPL | Stock | 1.5396 | 1.5405 | 1.5395 | 1.5395 | 44800.0 |
| 2005-02-23 08:49:00 | AAPL | Stock | 1.5395 | 1.5405 | 1.5395 | 1.5398 | 56000.0 |
| 2005-02-23 08:50:00 | AAPL | Stock | 1.5402 | 1.5409 | 1.5402 | 1.5405 | 56000.0 |
| 2005-02-23 08:51:00 | AAPL | Stock | 1.5396 | 1.5396 | 1.5375 | 1.5375 | 254072.0 |
| 2005-02-23 08:52:00 | AAPL | Stock | 1.5379 | 1.5411 | 1.5379 | 1.5402 | 421848.0 |
| 2005-02-23 08:53:00 | AAPL | Stock | 1.5402 | 1.5402 | 1.5402 | 1.5402 | 34608.0 |
| 2005-02-23 08:54:00 | AAPL | Stock | 1.5402 | 1.5411 | 1.5402 | 1.5411 | 190400.0 |
| 2005-02-23 08:55:00 | AAPL | Stock | 1.5405 | 1.5411 | 1.5405 | 1.5411 | 212240.0 |
| 2005-02-23 08:56:00 | AAPL | Stock | 1.5411 | 1.5418 | 1.5405 | 1.5411 | 84000.0 |
| 2005-02-23 08:57:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5411 | 1.5411 | 22400.0 |
| 2005-02-23 08:58:00 | AAPL | Stock | 1.5404 | 1.5404 | 1.5393 | 1.5393 | 48720.0 |
> showing 50 of 558,644 rows — these rows as CSV