PREVIEW / stock_1min / 2007-09-21
file: by_date/stock_1min/2007/2007-09-21.parquet size: 11.1 MB rows: 911,214 symbols: 2,550
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-21 09:30:00 | AAPL | Stock | 5.0407 | 5.0411 | 5.0289 | 5.0339 | 5204920.0 |
| 2007-09-21 09:31:00 | AAPL | Stock | 5.0339 | 5.0386 | 5.0243 | 5.0246 | 3492832.0 |
| 2007-09-21 09:32:00 | AAPL | Stock | 5.0257 | 5.036 | 5.0243 | 5.0252 | 4261348.0 |
| 2007-09-21 09:33:00 | AAPL | Stock | 5.025 | 5.0339 | 5.0221 | 5.0293 | 3748724.0 |
| 2007-09-21 09:34:00 | AAPL | Stock | 5.0293 | 5.0446 | 5.0258 | 5.034 | 3268524.0 |
| 2007-09-21 09:35:00 | AAPL | Stock | 5.0339 | 5.035 | 5.0275 | 5.0292 | 2686264.0 |
| 2007-09-21 09:36:00 | AAPL | Stock | 5.0289 | 5.0296 | 5.0239 | 5.0275 | 2233896.0 |
| 2007-09-21 09:37:00 | AAPL | Stock | 5.0275 | 5.0432 | 5.0271 | 5.0411 | 4135852.0 |
| 2007-09-21 09:38:00 | AAPL | Stock | 5.0421 | 5.0461 | 5.0375 | 5.0425 | 3571064.0 |
| 2007-09-21 09:39:00 | AAPL | Stock | 5.0429 | 5.0446 | 5.0343 | 5.035 | 3238732.0 |
| 2007-09-21 09:40:00 | AAPL | Stock | 5.0354 | 5.0414 | 5.0343 | 5.0371 | 3685136.0 |
| 2007-09-21 09:41:00 | AAPL | Stock | 5.0368 | 5.0382 | 5.0339 | 5.035 | 2154012.0 |
| 2007-09-21 09:42:00 | AAPL | Stock | 5.035 | 5.0382 | 5.0325 | 5.0371 | 3401748.0 |
| 2007-09-21 09:43:00 | AAPL | Stock | 5.0375 | 5.0386 | 5.035 | 5.0386 | 2839200.0 |
| 2007-09-21 09:44:00 | AAPL | Stock | 5.0382 | 5.0482 | 5.0375 | 5.0468 | 3604916.0 |
| 2007-09-21 09:45:00 | AAPL | Stock | 5.0468 | 5.05 | 5.0418 | 5.0429 | 2807392.0 |
| 2007-09-21 09:46:00 | AAPL | Stock | 5.0429 | 5.0446 | 5.0409 | 5.0439 | 2394560.0 |
| 2007-09-21 09:47:00 | AAPL | Stock | 5.0439 | 5.0464 | 5.0404 | 5.0418 | 2528876.0 |
| 2007-09-21 09:48:00 | AAPL | Stock | 5.0418 | 5.0429 | 5.0357 | 5.0361 | 1723176.0 |
| 2007-09-21 09:49:00 | AAPL | Stock | 5.0361 | 5.0404 | 5.0357 | 5.0361 | 1747704.0 |
| 2007-09-21 09:50:00 | AAPL | Stock | 5.0364 | 5.0411 | 5.0357 | 5.0396 | 1685180.0 |
| 2007-09-21 09:51:00 | AAPL | Stock | 5.0389 | 5.04 | 5.0368 | 5.0382 | 1375920.0 |
| 2007-09-21 09:52:00 | AAPL | Stock | 5.0382 | 5.0429 | 5.0369 | 5.0393 | 3373412.0 |
| 2007-09-21 09:53:00 | AAPL | Stock | 5.0393 | 5.0404 | 5.0371 | 5.0389 | 3460884.0 |
| 2007-09-21 09:54:00 | AAPL | Stock | 5.0393 | 5.0414 | 5.0379 | 5.0407 | 1662052.0 |
| 2007-09-21 09:55:00 | AAPL | Stock | 5.0407 | 5.0421 | 5.0382 | 5.0382 | 1128176.0 |
| 2007-09-21 09:56:00 | AAPL | Stock | 5.0386 | 5.0393 | 5.0357 | 5.0389 | 1579872.0 |
| 2007-09-21 09:57:00 | AAPL | Stock | 5.0386 | 5.04 | 5.0364 | 5.0386 | 1072876.0 |
| 2007-09-21 09:58:00 | AAPL | Stock | 5.0386 | 5.0418 | 5.0364 | 5.04 | 2008916.0 |
| 2007-09-21 09:59:00 | AAPL | Stock | 5.04 | 5.0439 | 5.04 | 5.0407 | 2238740.0 |
| 2007-09-21 10:00:00 | AAPL | Stock | 5.0404 | 5.0411 | 5.0371 | 5.04 | 3414852.0 |
| 2007-09-21 10:01:00 | AAPL | Stock | 5.0396 | 5.0439 | 5.0396 | 5.0429 | 2259488.0 |
| 2007-09-21 10:02:00 | AAPL | Stock | 5.0429 | 5.0464 | 5.0411 | 5.0464 | 2110388.0 |
| 2007-09-21 10:03:00 | AAPL | Stock | 5.0454 | 5.0464 | 5.0412 | 5.0439 | 1867712.0 |
| 2007-09-21 10:04:00 | AAPL | Stock | 5.0439 | 5.05 | 5.0421 | 5.05 | 1976240.0 |
| 2007-09-21 10:05:00 | AAPL | Stock | 5.0482 | 5.0571 | 5.0482 | 5.0571 | 5648888.0 |
| 2007-09-21 10:06:00 | AAPL | Stock | 5.0571 | 5.0707 | 5.0564 | 5.0675 | 5856564.0 |
| 2007-09-21 10:07:00 | AAPL | Stock | 5.0675 | 5.0682 | 5.0593 | 5.0607 | 4331572.0 |
| 2007-09-21 10:08:00 | AAPL | Stock | 5.0607 | 5.0621 | 5.0575 | 5.0575 | 2471056.0 |
| 2007-09-21 10:09:00 | AAPL | Stock | 5.0575 | 5.0596 | 5.0543 | 5.0571 | 1438668.0 |
| 2007-09-21 10:10:00 | AAPL | Stock | 5.0579 | 5.0593 | 5.0564 | 5.0579 | 1541820.0 |
| 2007-09-21 10:11:00 | AAPL | Stock | 5.0582 | 5.0586 | 5.0546 | 5.0582 | 1570268.0 |
| 2007-09-21 10:12:00 | AAPL | Stock | 5.0575 | 5.0621 | 5.0571 | 5.0618 | 1517600.0 |
| 2007-09-21 10:13:00 | AAPL | Stock | 5.0618 | 5.0657 | 5.0611 | 5.065 | 2552144.0 |
| 2007-09-21 10:14:00 | AAPL | Stock | 5.0643 | 5.0675 | 5.0636 | 5.065 | 1964004.0 |
| 2007-09-21 10:15:00 | AAPL | Stock | 5.065 | 5.0657 | 5.0607 | 5.0614 | 1233316.0 |
| 2007-09-21 10:16:00 | AAPL | Stock | 5.0607 | 5.0614 | 5.0518 | 5.0543 | 3262028.0 |
| 2007-09-21 10:17:00 | AAPL | Stock | 5.0536 | 5.0575 | 5.0525 | 5.0546 | 1845760.0 |
| 2007-09-21 10:18:00 | AAPL | Stock | 5.0546 | 5.06 | 5.0546 | 5.0571 | 1022196.0 |
| 2007-09-21 10:19:00 | AAPL | Stock | 5.0582 | 5.0582 | 5.0546 | 5.0554 | 1213688.0 |
> showing 50 of 911,214 rows — these rows as CSV