PREVIEW / stock_1min / 2005-08-08
file: by_date/stock_1min/2005/2005-08-08.parquet size: 7.1 MB rows: 586,919 symbols: 1,678
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-08 08:00:00 | AAPL | Stock | 1.5346 | 1.5346 | 1.5346 | 1.5346 | 2800.0 |
| 2005-08-08 08:01:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 8400.0 |
| 2005-08-08 08:07:00 | AAPL | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 8400.0 |
| 2005-08-08 08:08:00 | AAPL | Stock | 1.5454 | 1.5454 | 1.5443 | 1.5443 | 9268.0 |
| 2005-08-08 08:09:00 | AAPL | Stock | 1.5454 | 1.5454 | 1.5454 | 1.5454 | 30800.0 |
| 2005-08-08 08:10:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5464 | 1.5464 | 140000.0 |
| 2005-08-08 08:13:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 99932.0 |
| 2005-08-08 08:18:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5411 | 1.5411 | 5600.0 |
| 2005-08-08 08:20:00 | AAPL | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 14000.0 |
| 2005-08-08 08:21:00 | AAPL | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 2800.0 |
| 2005-08-08 08:24:00 | AAPL | Stock | 1.5368 | 1.5368 | 1.5357 | 1.5357 | 47880.0 |
| 2005-08-08 08:25:00 | AAPL | Stock | 1.5346 | 1.5354 | 1.5346 | 1.5354 | 8400.0 |
| 2005-08-08 08:30:00 | AAPL | Stock | 1.5332 | 1.5357 | 1.5332 | 1.5357 | 11200.0 |
| 2005-08-08 08:36:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 28000.0 |
| 2005-08-08 08:48:00 | AAPL | Stock | 1.5361 | 1.5361 | 1.5361 | 1.5361 | 2800.0 |
| 2005-08-08 08:58:00 | AAPL | Stock | 1.5418 | 1.5421 | 1.5418 | 1.5421 | 5600.0 |
| 2005-08-08 08:59:00 | AAPL | Stock | 1.5421 | 1.5425 | 1.5421 | 1.5425 | 28000.0 |
| 2005-08-08 09:07:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5421 | 1.5421 | 28000.0 |
| 2005-08-08 09:10:00 | AAPL | Stock | 1.5421 | 1.5425 | 1.5418 | 1.5425 | 15820.0 |
| 2005-08-08 09:14:00 | AAPL | Stock | 1.5379 | 1.5379 | 1.5379 | 1.5379 | 14000.0 |
| 2005-08-08 09:15:00 | AAPL | Stock | 1.5379 | 1.5379 | 1.5368 | 1.5368 | 16800.0 |
| 2005-08-08 09:16:00 | AAPL | Stock | 1.5379 | 1.5379 | 1.5379 | 1.5379 | 16800.0 |
| 2005-08-08 09:17:00 | AAPL | Stock | 1.5379 | 1.5379 | 1.5375 | 1.5375 | 16072.0 |
| 2005-08-08 09:18:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5375 | 1.5375 | 16800.0 |
| 2005-08-08 09:19:00 | AAPL | Stock | 1.5382 | 1.5382 | 1.5382 | 1.5382 | 14000.0 |
| 2005-08-08 09:20:00 | AAPL | Stock | 1.5386 | 1.5393 | 1.5386 | 1.5393 | 8400.0 |
| 2005-08-08 09:21:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 28000.0 |
| 2005-08-08 09:22:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 2800.0 |
| 2005-08-08 09:24:00 | AAPL | Stock | 1.5386 | 1.5386 | 1.5386 | 1.5386 | 2800.0 |
| 2005-08-08 09:25:00 | AAPL | Stock | 1.5386 | 1.5393 | 1.5386 | 1.5393 | 14000.0 |
| 2005-08-08 09:26:00 | AAPL | Stock | 1.5386 | 1.5386 | 1.5386 | 1.5386 | 2800.0 |
| 2005-08-08 09:29:00 | AAPL | Stock | 1.5386 | 1.5393 | 1.5357 | 1.5357 | 162400.0 |
| 2005-08-08 09:30:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.5307 | 1.5325 | 3492244.0 |
| 2005-08-08 09:31:00 | AAPL | Stock | 1.5325 | 1.5357 | 1.5314 | 1.5314 | 1162448.0 |
| 2005-08-08 09:32:00 | AAPL | Stock | 1.5318 | 1.5325 | 1.5232 | 1.5261 | 1806616.0 |
| 2005-08-08 09:33:00 | AAPL | Stock | 1.5261 | 1.5282 | 1.5246 | 1.5264 | 1376312.0 |
| 2005-08-08 09:34:00 | AAPL | Stock | 1.5264 | 1.5311 | 1.5264 | 1.5286 | 911344.0 |
| 2005-08-08 09:35:00 | AAPL | Stock | 1.5275 | 1.5332 | 1.5275 | 1.5321 | 1797432.0 |
| 2005-08-08 09:36:00 | AAPL | Stock | 1.5329 | 1.54 | 1.5318 | 1.5375 | 1939028.0 |
| 2005-08-08 09:37:00 | AAPL | Stock | 1.5382 | 1.5382 | 1.5307 | 1.5354 | 2019444.0 |
| 2005-08-08 09:38:00 | AAPL | Stock | 1.5357 | 1.5364 | 1.5329 | 1.5357 | 1229788.0 |
| 2005-08-08 09:39:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5293 | 1.5336 | 1204420.0 |
| 2005-08-08 09:40:00 | AAPL | Stock | 1.5336 | 1.5357 | 1.5321 | 1.5351 | 530292.0 |
| 2005-08-08 09:41:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5332 | 1.5336 | 409108.0 |
| 2005-08-08 09:42:00 | AAPL | Stock | 1.5339 | 1.5354 | 1.5336 | 1.5346 | 1452500.0 |
| 2005-08-08 09:43:00 | AAPL | Stock | 1.5339 | 1.5346 | 1.5325 | 1.5339 | 1013796.0 |
| 2005-08-08 09:44:00 | AAPL | Stock | 1.5343 | 1.5343 | 1.5329 | 1.5332 | 653380.0 |
| 2005-08-08 09:45:00 | AAPL | Stock | 1.5329 | 1.5332 | 1.5329 | 1.5329 | 246624.0 |
| 2005-08-08 09:46:00 | AAPL | Stock | 1.5329 | 1.5346 | 1.5329 | 1.5339 | 888916.0 |
| 2005-08-08 09:47:00 | AAPL | Stock | 1.5339 | 1.5375 | 1.5339 | 1.5364 | 1144472.0 |
> showing 50 of 586,919 rows — these rows as CSV