PREVIEW / stock_1min / 2005-08-04
file: by_date/stock_1min/2005/2005-08-04.parquet size: 7.1 MB rows: 587,010 symbols: 1,682
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-04 07:32:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 2800.0 |
| 2005-08-04 07:41:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 2800.0 |
| 2005-08-04 08:00:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 4480.0 |
| 2005-08-04 08:01:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 36400.0 |
| 2005-08-04 08:03:00 | AAPL | Stock | 1.5368 | 1.5368 | 1.5368 | 1.5368 | 8400.0 |
| 2005-08-04 08:04:00 | AAPL | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 19600.0 |
| 2005-08-04 08:17:00 | AAPL | Stock | 1.5368 | 1.5393 | 1.5361 | 1.5393 | 43400.0 |
| 2005-08-04 08:25:00 | AAPL | Stock | 1.5389 | 1.5389 | 1.5375 | 1.5389 | 39200.0 |
| 2005-08-04 08:26:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 8400.0 |
| 2005-08-04 08:27:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 6720.0 |
| 2005-08-04 08:29:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.5357 | 1.5357 | 186200.0 |
| 2005-08-04 08:37:00 | AAPL | Stock | 1.5346 | 1.5346 | 1.5346 | 1.5346 | 18480.0 |
| 2005-08-04 08:38:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5339 | 1.5339 | 97440.0 |
| 2005-08-04 08:39:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5339 | 1.5339 | 2800.0 |
| 2005-08-04 08:51:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5339 | 1.5339 | 19600.0 |
| 2005-08-04 09:04:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5354 | 1.5354 | 9884.0 |
| 2005-08-04 09:07:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5336 | 1.5336 | 7000.0 |
| 2005-08-04 09:19:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5354 | 1.5354 | 5600.0 |
| 2005-08-04 09:23:00 | AAPL | Stock | 1.535 | 1.5354 | 1.535 | 1.5354 | 69300.0 |
| 2005-08-04 09:25:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5332 | 1.5354 | 155400.0 |
| 2005-08-04 09:28:00 | AAPL | Stock | 1.5339 | 1.535 | 1.5339 | 1.535 | 32592.0 |
| 2005-08-04 09:29:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5332 | 1.5332 | 89600.0 |
| 2005-08-04 09:30:00 | AAPL | Stock | 1.5318 | 1.5354 | 1.5318 | 1.5336 | 3683904.0 |
| 2005-08-04 09:31:00 | AAPL | Stock | 1.5339 | 1.535 | 1.5332 | 1.5336 | 1044064.0 |
| 2005-08-04 09:32:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5329 | 1.5336 | 216216.0 |
| 2005-08-04 09:33:00 | AAPL | Stock | 1.5329 | 1.5336 | 1.5311 | 1.5332 | 974456.0 |
| 2005-08-04 09:34:00 | AAPL | Stock | 1.5325 | 1.5332 | 1.5286 | 1.5307 | 1307908.0 |
| 2005-08-04 09:35:00 | AAPL | Stock | 1.53 | 1.5314 | 1.5293 | 1.53 | 680120.0 |
| 2005-08-04 09:36:00 | AAPL | Stock | 1.5296 | 1.5318 | 1.5293 | 1.5318 | 869848.0 |
| 2005-08-04 09:37:00 | AAPL | Stock | 1.5318 | 1.5329 | 1.5318 | 1.5321 | 1069040.0 |
| 2005-08-04 09:38:00 | AAPL | Stock | 1.5321 | 1.5354 | 1.5321 | 1.5354 | 668612.0 |
| 2005-08-04 09:39:00 | AAPL | Stock | 1.5346 | 1.5357 | 1.5325 | 1.5336 | 1254876.0 |
| 2005-08-04 09:40:00 | AAPL | Stock | 1.5332 | 1.5336 | 1.5321 | 1.5325 | 603652.0 |
| 2005-08-04 09:41:00 | AAPL | Stock | 1.5325 | 1.5329 | 1.5318 | 1.5318 | 525420.0 |
| 2005-08-04 09:42:00 | AAPL | Stock | 1.5314 | 1.5339 | 1.5304 | 1.5329 | 962164.0 |
| 2005-08-04 09:43:00 | AAPL | Stock | 1.5329 | 1.5339 | 1.5311 | 1.5311 | 704312.0 |
| 2005-08-04 09:44:00 | AAPL | Stock | 1.5307 | 1.5311 | 1.53 | 1.5304 | 267624.0 |
| 2005-08-04 09:45:00 | AAPL | Stock | 1.5304 | 1.5307 | 1.5289 | 1.5296 | 951860.0 |
| 2005-08-04 09:46:00 | AAPL | Stock | 1.5296 | 1.53 | 1.5282 | 1.53 | 815668.0 |
| 2005-08-04 09:47:00 | AAPL | Stock | 1.5296 | 1.5318 | 1.5293 | 1.5307 | 1262520.0 |
| 2005-08-04 09:48:00 | AAPL | Stock | 1.5307 | 1.5318 | 1.5296 | 1.5311 | 1122296.0 |
| 2005-08-04 09:49:00 | AAPL | Stock | 1.5307 | 1.5307 | 1.5296 | 1.53 | 563808.0 |
| 2005-08-04 09:50:00 | AAPL | Stock | 1.5296 | 1.5304 | 1.5296 | 1.53 | 363692.0 |
| 2005-08-04 09:51:00 | AAPL | Stock | 1.53 | 1.5325 | 1.53 | 1.5325 | 960792.0 |
| 2005-08-04 09:52:00 | AAPL | Stock | 1.5311 | 1.5343 | 1.5311 | 1.5332 | 1180228.0 |
| 2005-08-04 09:53:00 | AAPL | Stock | 1.5332 | 1.5336 | 1.5307 | 1.5314 | 813232.0 |
| 2005-08-04 09:54:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5307 | 1.5311 | 584052.0 |
| 2005-08-04 09:55:00 | AAPL | Stock | 1.5311 | 1.5318 | 1.5296 | 1.53 | 290836.0 |
| 2005-08-04 09:56:00 | AAPL | Stock | 1.5304 | 1.5311 | 1.5289 | 1.5307 | 936208.0 |
| 2005-08-04 09:57:00 | AAPL | Stock | 1.5307 | 1.5311 | 1.5293 | 1.5296 | 661444.0 |
> showing 50 of 587,010 rows — these rows as CSV