PREVIEW / stock_5min / 2004-10-07
file: by_date/stock_5min/2004/2004-10-07.parquet size: 2.4 MB rows: 178,986 symbols: 1,834
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-07 08:00:00 | AAPL | Stock | 0.7286 | 0.7286 | 0.7248 | 0.7248 | 61600.0 |
| 2004-10-07 08:15:00 | AAPL | Stock | 0.7218 | 0.7218 | 0.7218 | 0.7218 | 11200.0 |
| 2004-10-07 08:20:00 | AAPL | Stock | 0.725 | 0.725 | 0.7248 | 0.725 | 72800.0 |
| 2004-10-07 08:25:00 | AAPL | Stock | 0.725 | 0.725 | 0.7248 | 0.725 | 112000.0 |
| 2004-10-07 08:30:00 | AAPL | Stock | 0.725 | 0.725 | 0.725 | 0.725 | 11200.0 |
| 2004-10-07 08:35:00 | AAPL | Stock | 0.725 | 0.725 | 0.725 | 0.725 | 28000.0 |
| 2004-10-07 08:45:00 | AAPL | Stock | 0.7268 | 0.7268 | 0.7252 | 0.7252 | 11200.0 |
| 2004-10-07 08:50:00 | AAPL | Stock | 0.7268 | 0.7268 | 0.7268 | 0.7268 | 16800.0 |
| 2004-10-07 09:10:00 | AAPL | Stock | 0.7261 | 0.7261 | 0.7261 | 0.7261 | 5600.0 |
| 2004-10-07 09:15:00 | AAPL | Stock | 0.7263 | 0.7263 | 0.725 | 0.725 | 1092000.0 |
| 2004-10-07 09:20:00 | AAPL | Stock | 0.725 | 0.7252 | 0.725 | 0.7252 | 33600.0 |
| 2004-10-07 09:25:00 | AAPL | Stock | 0.7241 | 0.7261 | 0.7241 | 0.725 | 440552.0 |
| 2004-10-07 09:30:00 | AAPL | Stock | 0.7239 | 0.7273 | 0.7232 | 0.7252 | 16624720.0 |
| 2004-10-07 09:35:00 | AAPL | Stock | 0.725 | 0.7266 | 0.7241 | 0.7263 | 12281808.0 |
| 2004-10-07 09:40:00 | AAPL | Stock | 0.7263 | 0.7309 | 0.7263 | 0.7295 | 12489400.0 |
| 2004-10-07 09:45:00 | AAPL | Stock | 0.7298 | 0.7302 | 0.7252 | 0.7282 | 11522224.0 |
| 2004-10-07 09:50:00 | AAPL | Stock | 0.7282 | 0.7282 | 0.7245 | 0.7257 | 6526520.0 |
| 2004-10-07 09:55:00 | AAPL | Stock | 0.7254 | 0.7263 | 0.7229 | 0.723 | 7834400.0 |
| 2004-10-07 10:00:00 | AAPL | Stock | 0.723 | 0.723 | 0.7182 | 0.7204 | 20129536.0 |
| 2004-10-07 10:05:00 | AAPL | Stock | 0.7204 | 0.7218 | 0.7193 | 0.7195 | 10258808.0 |
| 2004-10-07 10:10:00 | AAPL | Stock | 0.7198 | 0.7223 | 0.7189 | 0.7198 | 10325000.0 |
| 2004-10-07 10:15:00 | AAPL | Stock | 0.7198 | 0.7218 | 0.7196 | 0.7209 | 14791616.0 |
| 2004-10-07 10:20:00 | AAPL | Stock | 0.7207 | 0.7209 | 0.7188 | 0.7191 | 7215712.0 |
| 2004-10-07 10:25:00 | AAPL | Stock | 0.7191 | 0.7218 | 0.7191 | 0.7214 | 5296760.0 |
| 2004-10-07 10:30:00 | AAPL | Stock | 0.7214 | 0.7218 | 0.7202 | 0.7202 | 3742760.0 |
| 2004-10-07 10:35:00 | AAPL | Stock | 0.7202 | 0.7209 | 0.7193 | 0.7209 | 2244984.0 |
| 2004-10-07 10:40:00 | AAPL | Stock | 0.7209 | 0.7211 | 0.7204 | 0.7207 | 2667000.0 |
| 2004-10-07 10:45:00 | AAPL | Stock | 0.7211 | 0.722 | 0.7207 | 0.7216 | 3647168.0 |
| 2004-10-07 10:50:00 | AAPL | Stock | 0.7218 | 0.7227 | 0.7207 | 0.7211 | 3490256.0 |
| 2004-10-07 10:55:00 | AAPL | Stock | 0.7211 | 0.7218 | 0.7211 | 0.7214 | 2158520.0 |
| 2004-10-07 11:00:00 | AAPL | Stock | 0.7211 | 0.7218 | 0.7204 | 0.7216 | 2519776.0 |
| 2004-10-07 11:05:00 | AAPL | Stock | 0.7216 | 0.722 | 0.7202 | 0.7205 | 2398312.0 |
| 2004-10-07 11:10:00 | AAPL | Stock | 0.7205 | 0.7214 | 0.7204 | 0.7214 | 1713040.0 |
| 2004-10-07 11:15:00 | AAPL | Stock | 0.7214 | 0.7214 | 0.7198 | 0.72 | 4349464.0 |
| 2004-10-07 11:20:00 | AAPL | Stock | 0.72 | 0.7209 | 0.7196 | 0.7209 | 2061920.0 |
| 2004-10-07 11:25:00 | AAPL | Stock | 0.7209 | 0.7209 | 0.7188 | 0.7191 | 3475136.0 |
| 2004-10-07 11:30:00 | AAPL | Stock | 0.7198 | 0.72 | 0.7188 | 0.7191 | 2438912.0 |
| 2004-10-07 11:35:00 | AAPL | Stock | 0.7192 | 0.7192 | 0.7161 | 0.7164 | 5666248.0 |
| 2004-10-07 11:40:00 | AAPL | Stock | 0.7164 | 0.7186 | 0.7161 | 0.7164 | 5691840.0 |
| 2004-10-07 11:45:00 | AAPL | Stock | 0.7168 | 0.7171 | 0.7154 | 0.7168 | 2797536.0 |
| 2004-10-07 11:50:00 | AAPL | Stock | 0.7166 | 0.7189 | 0.7159 | 0.717 | 7312984.0 |
| 2004-10-07 11:55:00 | AAPL | Stock | 0.7171 | 0.7177 | 0.7163 | 0.7168 | 1909656.0 |
| 2004-10-07 12:00:00 | AAPL | Stock | 0.7166 | 0.717 | 0.7164 | 0.7168 | 2164680.0 |
| 2004-10-07 12:05:00 | AAPL | Stock | 0.7166 | 0.7177 | 0.7166 | 0.7175 | 2264752.0 |
| 2004-10-07 12:10:00 | AAPL | Stock | 0.7175 | 0.7175 | 0.7163 | 0.7164 | 1570632.0 |
| 2004-10-07 12:15:00 | AAPL | Stock | 0.7163 | 0.7169 | 0.7155 | 0.7157 | 1593592.0 |
| 2004-10-07 12:20:00 | AAPL | Stock | 0.7155 | 0.7155 | 0.7127 | 0.7132 | 7425488.0 |
| 2004-10-07 12:25:00 | AAPL | Stock | 0.7132 | 0.7136 | 0.7116 | 0.713 | 5465208.0 |
| 2004-10-07 12:30:00 | AAPL | Stock | 0.713 | 0.713 | 0.7111 | 0.7116 | 3325504.0 |
| 2004-10-07 12:35:00 | AAPL | Stock | 0.7116 | 0.712 | 0.7109 | 0.7111 | 3208240.0 |
> showing 50 of 178,986 rows — these rows as CSV