PREVIEW / stock_5min / 2010-06-18
file: by_date/stock_5min/2010/2010-06-18.parquet size: 4.7 MB rows: 325,727 symbols: 3,481
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-18 04:30:00 | AAPL | Stock | 9.68 | 9.68 | 9.68 | 9.68 | 2800.0 |
| 2010-06-18 04:35:00 | AAPL | Stock | 9.6807 | 9.6807 | 9.6786 | 9.6786 | 16800.0 |
| 2010-06-18 04:40:00 | AAPL | Stock | 9.6732 | 9.6732 | 9.6611 | 9.6682 | 8512.0 |
| 2010-06-18 05:15:00 | AAPL | Stock | 9.6732 | 9.6732 | 9.6682 | 9.6682 | 8008.0 |
| 2010-06-18 05:20:00 | AAPL | Stock | 9.6939 | 9.6943 | 9.6939 | 9.6943 | 22400.0 |
| 2010-06-18 06:30:00 | AAPL | Stock | 9.7086 | 9.7086 | 9.7086 | 9.7086 | 2800.0 |
| 2010-06-18 06:35:00 | AAPL | Stock | 9.7086 | 9.7086 | 9.7086 | 9.7086 | 5600.0 |
| 2010-06-18 07:00:00 | AAPL | Stock | 9.7146 | 9.7314 | 9.7146 | 9.7311 | 75600.0 |
| 2010-06-18 07:05:00 | AAPL | Stock | 9.7393 | 9.7464 | 9.72 | 9.7418 | 161140.0 |
| 2010-06-18 07:10:00 | AAPL | Stock | 9.7375 | 9.7375 | 9.7204 | 9.7318 | 91336.0 |
| 2010-06-18 07:15:00 | AAPL | Stock | 9.7336 | 9.7336 | 9.7225 | 9.725 | 39200.0 |
| 2010-06-18 07:20:00 | AAPL | Stock | 9.7286 | 9.7436 | 9.7232 | 9.7379 | 240800.0 |
| 2010-06-18 07:25:00 | AAPL | Stock | 9.7411 | 9.7418 | 9.7321 | 9.7414 | 229600.0 |
| 2010-06-18 07:30:00 | AAPL | Stock | 9.7393 | 9.7418 | 9.7379 | 9.7418 | 44380.0 |
| 2010-06-18 07:35:00 | AAPL | Stock | 9.7411 | 9.7629 | 9.7411 | 9.7629 | 397712.0 |
| 2010-06-18 07:40:00 | AAPL | Stock | 9.7646 | 9.7679 | 9.7589 | 9.7643 | 172648.0 |
| 2010-06-18 07:45:00 | AAPL | Stock | 9.7607 | 9.7768 | 9.7589 | 9.7664 | 164500.0 |
| 2010-06-18 07:50:00 | AAPL | Stock | 9.7679 | 9.7761 | 9.7536 | 9.7761 | 126840.0 |
| 2010-06-18 07:55:00 | AAPL | Stock | 9.7643 | 9.7643 | 9.7589 | 9.7589 | 96600.0 |
| 2010-06-18 08:00:00 | AAPL | Stock | 9.7546 | 9.7607 | 9.7411 | 9.7411 | 659176.0 |
| 2010-06-18 08:05:00 | AAPL | Stock | 9.7429 | 9.7454 | 9.7318 | 9.7446 | 476112.0 |
| 2010-06-18 08:10:00 | AAPL | Stock | 9.7429 | 9.7446 | 9.7393 | 9.7404 | 164080.0 |
| 2010-06-18 08:15:00 | AAPL | Stock | 9.7425 | 9.7436 | 9.7361 | 9.7375 | 159544.0 |
| 2010-06-18 08:20:00 | AAPL | Stock | 9.7375 | 9.7393 | 9.73 | 9.7375 | 190316.0 |
| 2010-06-18 08:25:00 | AAPL | Stock | 9.7361 | 9.7375 | 9.7175 | 9.7286 | 261380.0 |
| 2010-06-18 08:30:00 | AAPL | Stock | 9.7286 | 9.7286 | 9.7179 | 9.7179 | 275100.0 |
| 2010-06-18 08:35:00 | AAPL | Stock | 9.7214 | 9.7268 | 9.7196 | 9.725 | 69944.0 |
| 2010-06-18 08:40:00 | AAPL | Stock | 9.7264 | 9.7321 | 9.7214 | 9.7214 | 142940.0 |
| 2010-06-18 08:45:00 | AAPL | Stock | 9.7214 | 9.7393 | 9.7214 | 9.7379 | 501256.0 |
| 2010-06-18 08:50:00 | AAPL | Stock | 9.7382 | 9.7393 | 9.7268 | 9.7286 | 92652.0 |
| 2010-06-18 08:55:00 | AAPL | Stock | 9.7271 | 9.7321 | 9.7261 | 9.7304 | 134400.0 |
| 2010-06-18 09:00:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7179 | 9.7211 | 306432.0 |
| 2010-06-18 09:05:00 | AAPL | Stock | 9.7232 | 9.7286 | 9.7207 | 9.7239 | 350280.0 |
| 2010-06-18 09:10:00 | AAPL | Stock | 9.7246 | 9.7304 | 9.7239 | 9.7286 | 312984.0 |
| 2010-06-18 09:15:00 | AAPL | Stock | 9.73 | 9.73 | 9.7232 | 9.725 | 91700.0 |
| 2010-06-18 09:20:00 | AAPL | Stock | 9.7268 | 9.7286 | 9.7246 | 9.7268 | 101640.0 |
| 2010-06-18 09:25:00 | AAPL | Stock | 9.7261 | 9.7286 | 9.72 | 9.7214 | 484400.0 |
| 2010-06-18 09:30:00 | AAPL | Stock | 9.7204 | 9.7396 | 9.7064 | 9.7191 | 103616968.0 |
| 2010-06-18 09:35:00 | AAPL | Stock | 9.7172 | 9.7318 | 9.6936 | 9.7039 | 22364692.0 |
| 2010-06-18 09:40:00 | AAPL | Stock | 9.7054 | 9.7304 | 9.6964 | 9.7296 | 21749196.0 |
| 2010-06-18 09:45:00 | AAPL | Stock | 9.7293 | 9.7468 | 9.7189 | 9.7293 | 16976652.0 |
| 2010-06-18 09:50:00 | AAPL | Stock | 9.7304 | 9.7349 | 9.7189 | 9.7202 | 12448996.0 |
| 2010-06-18 09:55:00 | AAPL | Stock | 9.7196 | 9.7196 | 9.7057 | 9.7125 | 11109420.0 |
| 2010-06-18 10:00:00 | AAPL | Stock | 9.7132 | 9.7268 | 9.7114 | 9.7221 | 11351760.0 |
| 2010-06-18 10:05:00 | AAPL | Stock | 9.7221 | 9.75 | 9.7214 | 9.75 | 17631712.0 |
| 2010-06-18 10:10:00 | AAPL | Stock | 9.75 | 9.7568 | 9.7393 | 9.74 | 18836944.0 |
| 2010-06-18 10:15:00 | AAPL | Stock | 9.74 | 9.7614 | 9.7393 | 9.7596 | 13914600.0 |
| 2010-06-18 10:20:00 | AAPL | Stock | 9.7593 | 9.7675 | 9.75 | 9.7568 | 12950448.0 |
| 2010-06-18 10:25:00 | AAPL | Stock | 9.7571 | 9.7743 | 9.7539 | 9.7732 | 14423360.0 |
| 2010-06-18 10:30:00 | AAPL | Stock | 9.7732 | 9.7918 | 9.7679 | 9.7868 | 20345640.0 |
> showing 50 of 325,727 rows — these rows as CSV