PREVIEW / stock_5min / 2009-04-01
file: by_date/stock_5min/2009/2009-04-01.parquet size: 4.5 MB rows: 310,339 symbols: 3,311
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-01 07:50:00 | AAPL | Stock | 3.7411 | 3.7411 | 3.7411 | 3.7411 | 2800.0 |
| 2009-04-01 08:00:00 | AAPL | Stock | 3.7339 | 3.7543 | 3.7321 | 3.7321 | 187740.0 |
| 2009-04-01 08:05:00 | AAPL | Stock | 3.7271 | 3.7279 | 3.7143 | 3.7193 | 156800.0 |
| 2009-04-01 08:10:00 | AAPL | Stock | 3.7193 | 3.7221 | 3.7179 | 3.7179 | 11200.0 |
| 2009-04-01 08:15:00 | AAPL | Stock | 3.7246 | 3.7246 | 3.715 | 3.7179 | 43204.0 |
| 2009-04-01 08:20:00 | AAPL | Stock | 3.7179 | 3.7179 | 3.7161 | 3.7171 | 11620.0 |
| 2009-04-01 08:25:00 | AAPL | Stock | 3.7171 | 3.7543 | 3.7143 | 3.7143 | 151200.0 |
| 2009-04-01 08:30:00 | AAPL | Stock | 3.7161 | 3.7179 | 3.7143 | 3.7179 | 27580.0 |
| 2009-04-01 08:40:00 | AAPL | Stock | 3.7254 | 3.7254 | 3.7254 | 3.7254 | 6300.0 |
| 2009-04-01 08:45:00 | AAPL | Stock | 3.725 | 3.725 | 3.7111 | 3.7111 | 242620.0 |
| 2009-04-01 08:50:00 | AAPL | Stock | 3.7146 | 3.7179 | 3.7104 | 3.7143 | 136920.0 |
| 2009-04-01 08:55:00 | AAPL | Stock | 3.7143 | 3.715 | 3.7143 | 3.7146 | 47600.0 |
| 2009-04-01 09:00:00 | AAPL | Stock | 3.7146 | 3.7543 | 3.7146 | 3.7171 | 296464.0 |
| 2009-04-01 09:05:00 | AAPL | Stock | 3.7161 | 3.7211 | 3.7143 | 3.7211 | 94164.0 |
| 2009-04-01 09:10:00 | AAPL | Stock | 3.7189 | 3.7196 | 3.7161 | 3.7196 | 28056.0 |
| 2009-04-01 09:15:00 | AAPL | Stock | 3.7157 | 3.7157 | 3.7157 | 3.7157 | 16800.0 |
| 2009-04-01 09:20:00 | AAPL | Stock | 3.7157 | 3.7157 | 3.7139 | 3.7139 | 32676.0 |
| 2009-04-01 09:25:00 | AAPL | Stock | 3.7139 | 3.7196 | 3.7136 | 3.7196 | 162596.0 |
| 2009-04-01 09:30:00 | AAPL | Stock | 3.7179 | 3.725 | 3.7104 | 3.7196 | 12945464.0 |
| 2009-04-01 09:35:00 | AAPL | Stock | 3.7196 | 3.7479 | 3.7193 | 3.7432 | 12096056.0 |
| 2009-04-01 09:40:00 | AAPL | Stock | 3.7436 | 3.7532 | 3.735 | 3.735 | 10139192.0 |
| 2009-04-01 09:45:00 | AAPL | Stock | 3.7343 | 3.7393 | 3.7211 | 3.7218 | 6498800.0 |
| 2009-04-01 09:50:00 | AAPL | Stock | 3.7221 | 3.7332 | 3.7161 | 3.7321 | 6920452.0 |
| 2009-04-01 09:55:00 | AAPL | Stock | 3.7314 | 3.7407 | 3.7304 | 3.7325 | 5867708.0 |
| 2009-04-01 10:00:00 | AAPL | Stock | 3.7325 | 3.7457 | 3.7318 | 3.7432 | 8207024.0 |
| 2009-04-01 10:05:00 | AAPL | Stock | 3.7432 | 3.7507 | 3.7389 | 3.7475 | 7246260.0 |
| 2009-04-01 10:10:00 | AAPL | Stock | 3.7482 | 3.766 | 3.7482 | 3.7618 | 7804944.0 |
| 2009-04-01 10:15:00 | AAPL | Stock | 3.7621 | 3.7704 | 3.755 | 3.7657 | 7948332.0 |
| 2009-04-01 10:20:00 | AAPL | Stock | 3.7657 | 3.7786 | 3.7643 | 3.7723 | 8901928.0 |
| 2009-04-01 10:25:00 | AAPL | Stock | 3.7704 | 3.7814 | 3.7654 | 3.775 | 8924216.0 |
| 2009-04-01 10:30:00 | AAPL | Stock | 3.7754 | 3.7779 | 3.7696 | 3.7761 | 4636380.0 |
| 2009-04-01 10:35:00 | AAPL | Stock | 3.7754 | 3.7975 | 3.7754 | 3.79 | 8853488.0 |
| 2009-04-01 10:40:00 | AAPL | Stock | 3.79 | 3.8093 | 3.7893 | 3.8064 | 10507280.0 |
| 2009-04-01 10:45:00 | AAPL | Stock | 3.8061 | 3.8175 | 3.8061 | 3.8164 | 9275840.0 |
| 2009-04-01 10:50:00 | AAPL | Stock | 3.8164 | 3.8261 | 3.8157 | 3.8157 | 10505992.0 |
| 2009-04-01 10:55:00 | AAPL | Stock | 3.8157 | 3.8371 | 3.8157 | 3.8296 | 12599216.0 |
| 2009-04-01 11:00:00 | AAPL | Stock | 3.83 | 3.8329 | 3.8093 | 3.8104 | 10367840.0 |
| 2009-04-01 11:05:00 | AAPL | Stock | 3.8104 | 3.815 | 3.8036 | 3.8061 | 7353052.0 |
| 2009-04-01 11:10:00 | AAPL | Stock | 3.8064 | 3.8164 | 3.8054 | 3.8111 | 4812136.0 |
| 2009-04-01 11:15:00 | AAPL | Stock | 3.8114 | 3.8246 | 3.8079 | 3.82 | 5439392.0 |
| 2009-04-01 11:20:00 | AAPL | Stock | 3.8196 | 3.8264 | 3.8139 | 3.819 | 4351256.0 |
| 2009-04-01 11:25:00 | AAPL | Stock | 3.8186 | 3.8311 | 3.8179 | 3.8261 | 5212368.0 |
| 2009-04-01 11:30:00 | AAPL | Stock | 3.8264 | 3.8375 | 3.8225 | 3.8232 | 6433896.0 |
| 2009-04-01 11:35:00 | AAPL | Stock | 3.8236 | 3.8346 | 3.8207 | 3.8318 | 4136244.0 |
| 2009-04-01 11:40:00 | AAPL | Stock | 3.8321 | 3.8375 | 3.8271 | 3.8296 | 4705008.0 |
| 2009-04-01 11:45:00 | AAPL | Stock | 3.8296 | 3.8371 | 3.8296 | 3.835 | 3606372.0 |
| 2009-04-01 11:50:00 | AAPL | Stock | 3.8343 | 3.8393 | 3.8289 | 3.8289 | 4482828.0 |
| 2009-04-01 11:55:00 | AAPL | Stock | 3.8291 | 3.8464 | 3.8286 | 3.8454 | 7637196.0 |
| 2009-04-01 12:00:00 | AAPL | Stock | 3.8457 | 3.8539 | 3.8454 | 3.8461 | 7330876.0 |
| 2009-04-01 12:05:00 | AAPL | Stock | 3.8461 | 3.8571 | 3.8454 | 3.855 | 6413764.0 |
> showing 50 of 310,339 rows — these rows as CSV