PREVIEW / stock_5min / 2005-08-02
file: by_date/stock_5min/2005/2005-08-02.parquet size: 2.8 MB rows: 206,025 symbols: 2,051
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-02 08:15:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 13664.0 |
| 2005-08-02 08:25:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 15120.0 |
| 2005-08-02 08:30:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5282 | 1.5282 | 8400.0 |
| 2005-08-02 08:35:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 2800.0 |
| 2005-08-02 08:40:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 53200.0 |
| 2005-08-02 08:45:00 | AAPL | Stock | 1.5264 | 1.5264 | 1.5264 | 1.5264 | 2800.0 |
| 2005-08-02 08:50:00 | AAPL | Stock | 1.5261 | 1.5261 | 1.5261 | 1.5261 | 2800.0 |
| 2005-08-02 09:00:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 44996.0 |
| 2005-08-02 09:05:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5268 | 1.5282 | 232596.0 |
| 2005-08-02 09:10:00 | AAPL | Stock | 1.5314 | 1.5314 | 1.5304 | 1.5304 | 23884.0 |
| 2005-08-02 09:20:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 10080.0 |
| 2005-08-02 09:25:00 | AAPL | Stock | 1.53 | 1.5336 | 1.5268 | 1.5271 | 303268.0 |
| 2005-08-02 09:30:00 | AAPL | Stock | 1.5318 | 1.5332 | 1.5254 | 1.5304 | 7988288.0 |
| 2005-08-02 09:35:00 | AAPL | Stock | 1.53 | 1.5325 | 1.5218 | 1.5264 | 4277224.0 |
| 2005-08-02 09:40:00 | AAPL | Stock | 1.5264 | 1.5339 | 1.5236 | 1.5336 | 5268004.0 |
| 2005-08-02 09:45:00 | AAPL | Stock | 1.5336 | 1.5354 | 1.5311 | 1.5325 | 3467520.0 |
| 2005-08-02 09:50:00 | AAPL | Stock | 1.5325 | 1.5368 | 1.5307 | 1.5329 | 4386032.0 |
| 2005-08-02 09:55:00 | AAPL | Stock | 1.5332 | 1.5346 | 1.5304 | 1.5307 | 942508.0 |
| 2005-08-02 10:00:00 | AAPL | Stock | 1.5304 | 1.5339 | 1.5286 | 1.5332 | 3091144.0 |
| 2005-08-02 10:05:00 | AAPL | Stock | 1.5336 | 1.5364 | 1.5318 | 1.5357 | 5802748.0 |
| 2005-08-02 10:10:00 | AAPL | Stock | 1.5357 | 1.5429 | 1.5357 | 1.5389 | 7043288.0 |
| 2005-08-02 10:15:00 | AAPL | Stock | 1.5386 | 1.54 | 1.5371 | 1.5389 | 3861900.0 |
| 2005-08-02 10:20:00 | AAPL | Stock | 1.5393 | 1.5439 | 1.5393 | 1.5429 | 6670300.0 |
| 2005-08-02 10:25:00 | AAPL | Stock | 1.5425 | 1.5446 | 1.5404 | 1.5425 | 3560088.0 |
| 2005-08-02 10:30:00 | AAPL | Stock | 1.5425 | 1.5432 | 1.5411 | 1.5429 | 3020892.0 |
| 2005-08-02 10:35:00 | AAPL | Stock | 1.5429 | 1.5482 | 1.5425 | 1.5454 | 9169916.0 |
| 2005-08-02 10:40:00 | AAPL | Stock | 1.5454 | 1.5532 | 1.5454 | 1.5507 | 7132412.0 |
| 2005-08-02 10:45:00 | AAPL | Stock | 1.5507 | 1.5536 | 1.5475 | 1.5479 | 9702168.0 |
| 2005-08-02 10:50:00 | AAPL | Stock | 1.5475 | 1.5475 | 1.5446 | 1.5461 | 4516988.0 |
| 2005-08-02 10:55:00 | AAPL | Stock | 1.5461 | 1.5468 | 1.5454 | 1.5461 | 1805720.0 |
| 2005-08-02 11:00:00 | AAPL | Stock | 1.5461 | 1.5464 | 1.5443 | 1.545 | 4477284.0 |
| 2005-08-02 11:05:00 | AAPL | Stock | 1.545 | 1.5457 | 1.5439 | 1.5439 | 1774192.0 |
| 2005-08-02 11:10:00 | AAPL | Stock | 1.5439 | 1.5457 | 1.5425 | 1.5454 | 7066472.0 |
| 2005-08-02 11:15:00 | AAPL | Stock | 1.545 | 1.5464 | 1.5443 | 1.5457 | 4046000.0 |
| 2005-08-02 11:20:00 | AAPL | Stock | 1.5454 | 1.5461 | 1.5439 | 1.545 | 6281128.0 |
| 2005-08-02 11:25:00 | AAPL | Stock | 1.5449 | 1.545 | 1.5425 | 1.5443 | 4435144.0 |
| 2005-08-02 11:30:00 | AAPL | Stock | 1.5443 | 1.5454 | 1.5432 | 1.5436 | 2078468.0 |
| 2005-08-02 11:35:00 | AAPL | Stock | 1.5436 | 1.5446 | 1.5425 | 1.5425 | 1163036.0 |
| 2005-08-02 11:40:00 | AAPL | Stock | 1.5425 | 1.5429 | 1.5393 | 1.5396 | 3583804.0 |
| 2005-08-02 11:45:00 | AAPL | Stock | 1.5396 | 1.5432 | 1.5382 | 1.5429 | 3629724.0 |
| 2005-08-02 11:50:00 | AAPL | Stock | 1.5429 | 1.5464 | 1.5418 | 1.5461 | 4183088.0 |
| 2005-08-02 11:55:00 | AAPL | Stock | 1.5461 | 1.5471 | 1.5446 | 1.5457 | 2078188.0 |
| 2005-08-02 12:00:00 | AAPL | Stock | 1.5461 | 1.5468 | 1.545 | 1.5467 | 1378692.0 |
| 2005-08-02 12:05:00 | AAPL | Stock | 1.5468 | 1.5471 | 1.545 | 1.5454 | 1835540.0 |
| 2005-08-02 12:10:00 | AAPL | Stock | 1.5457 | 1.5464 | 1.545 | 1.5464 | 583492.0 |
| 2005-08-02 12:15:00 | AAPL | Stock | 1.5461 | 1.5482 | 1.5461 | 1.5482 | 1670144.0 |
| 2005-08-02 12:20:00 | AAPL | Stock | 1.5486 | 1.5525 | 1.5486 | 1.5518 | 3393880.0 |
| 2005-08-02 12:25:00 | AAPL | Stock | 1.5521 | 1.5529 | 1.5507 | 1.5521 | 2192596.0 |
| 2005-08-02 12:30:00 | AAPL | Stock | 1.5521 | 1.5525 | 1.5507 | 1.5521 | 1693860.0 |
| 2005-08-02 12:35:00 | AAPL | Stock | 1.5521 | 1.5525 | 1.5511 | 1.5521 | 1043308.0 |
> showing 50 of 206,025 rows — these rows as CSV