PREVIEW / stock_5min / 2012-10-09
file: by_date/stock_5min/2012/2012-10-09.parquet size: 4.7 MB rows: 315,492 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-09 04:00:00 | AAPL | Stock | 22.5711 | 22.5711 | 22.5432 | 22.5711 | 11200.0 |
| 2012-10-09 04:05:00 | AAPL | Stock | 22.5743 | 22.5743 | 22.5714 | 22.5714 | 26096.0 |
| 2012-10-09 04:30:00 | AAPL | Stock | 22.5232 | 22.5286 | 22.5232 | 22.5286 | 5600.0 |
| 2012-10-09 04:35:00 | AAPL | Stock | 22.5179 | 22.5189 | 22.5179 | 22.5189 | 5600.0 |
| 2012-10-09 04:40:00 | AAPL | Stock | 22.5089 | 22.5282 | 22.5089 | 22.5282 | 30800.0 |
| 2012-10-09 04:45:00 | AAPL | Stock | 22.5179 | 22.5282 | 22.5179 | 22.5282 | 22120.0 |
| 2012-10-09 04:50:00 | AAPL | Stock | 22.5268 | 22.5357 | 22.5268 | 22.5271 | 50400.0 |
| 2012-10-09 04:55:00 | AAPL | Stock | 22.5286 | 22.5357 | 22.5271 | 22.5321 | 44716.0 |
| 2012-10-09 05:00:00 | AAPL | Stock | 22.5354 | 22.5493 | 22.5321 | 22.5493 | 42000.0 |
| 2012-10-09 05:15:00 | AAPL | Stock | 22.5425 | 22.5429 | 22.5393 | 22.5393 | 18200.0 |
| 2012-10-09 05:20:00 | AAPL | Stock | 22.5411 | 22.5429 | 22.5411 | 22.5429 | 19600.0 |
| 2012-10-09 05:30:00 | AAPL | Stock | 22.5411 | 22.5446 | 22.5357 | 22.5446 | 42000.0 |
| 2012-10-09 05:45:00 | AAPL | Stock | 22.5571 | 22.5714 | 22.5536 | 22.5714 | 121240.0 |
| 2012-10-09 05:50:00 | AAPL | Stock | 22.5714 | 22.5857 | 22.5714 | 22.5857 | 25900.0 |
| 2012-10-09 05:55:00 | AAPL | Stock | 22.5825 | 22.5825 | 22.575 | 22.575 | 37856.0 |
| 2012-10-09 06:00:00 | AAPL | Stock | 22.5893 | 22.5964 | 22.5893 | 22.5964 | 17920.0 |
| 2012-10-09 06:05:00 | AAPL | Stock | 22.5979 | 22.5982 | 22.5979 | 22.5982 | 13300.0 |
| 2012-10-09 06:10:00 | AAPL | Stock | 22.6029 | 22.6036 | 22.6029 | 22.6036 | 28700.0 |
| 2012-10-09 06:15:00 | AAPL | Stock | 22.62 | 22.62 | 22.6071 | 22.6071 | 23800.0 |
| 2012-10-09 06:20:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 2800.0 |
| 2012-10-09 06:40:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 9800.0 |
| 2012-10-09 06:45:00 | AAPL | Stock | 22.6196 | 22.6196 | 22.6196 | 22.6196 | 2800.0 |
| 2012-10-09 06:50:00 | AAPL | Stock | 22.6257 | 22.6393 | 22.6257 | 22.6336 | 100660.0 |
| 2012-10-09 06:55:00 | AAPL | Stock | 22.6336 | 22.6429 | 22.6336 | 22.6429 | 23436.0 |
| 2012-10-09 07:00:00 | AAPL | Stock | 22.65 | 22.6536 | 22.6364 | 22.6454 | 43960.0 |
| 2012-10-09 07:05:00 | AAPL | Stock | 22.6525 | 22.6696 | 22.6518 | 22.6679 | 40936.0 |
| 2012-10-09 07:10:00 | AAPL | Stock | 22.675 | 22.7354 | 22.6696 | 22.7139 | 289100.0 |
| 2012-10-09 07:15:00 | AAPL | Stock | 22.7143 | 22.7289 | 22.7143 | 22.7179 | 220248.0 |
| 2012-10-09 07:20:00 | AAPL | Stock | 22.7179 | 22.7679 | 22.7179 | 22.7679 | 217112.0 |
| 2012-10-09 07:25:00 | AAPL | Stock | 22.7657 | 22.7764 | 22.7361 | 22.7361 | 167776.0 |
| 2012-10-09 07:30:00 | AAPL | Stock | 22.7264 | 22.7286 | 22.7143 | 22.7286 | 208264.0 |
| 2012-10-09 07:35:00 | AAPL | Stock | 22.7432 | 22.7432 | 22.7054 | 22.7054 | 73864.0 |
| 2012-10-09 07:40:00 | AAPL | Stock | 22.7146 | 22.7304 | 22.7146 | 22.7232 | 11200.0 |
| 2012-10-09 07:45:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7143 | 22.7143 | 47908.0 |
| 2012-10-09 07:50:00 | AAPL | Stock | 22.7225 | 22.7461 | 22.7225 | 22.7461 | 11200.0 |
| 2012-10-09 07:55:00 | AAPL | Stock | 22.7439 | 22.75 | 22.7371 | 22.7429 | 139160.0 |
| 2012-10-09 08:00:00 | AAPL | Stock | 22.7357 | 22.7429 | 22.6786 | 22.6786 | 282968.0 |
| 2012-10-09 08:05:00 | AAPL | Stock | 22.6825 | 22.7025 | 22.6704 | 22.7014 | 333340.0 |
| 2012-10-09 08:10:00 | AAPL | Stock | 22.6879 | 22.7089 | 22.6879 | 22.7036 | 95116.0 |
| 2012-10-09 08:15:00 | AAPL | Stock | 22.7054 | 22.7218 | 22.7036 | 22.7036 | 221732.0 |
| 2012-10-09 08:20:00 | AAPL | Stock | 22.7118 | 22.7189 | 22.7018 | 22.7036 | 236488.0 |
| 2012-10-09 08:25:00 | AAPL | Stock | 22.7082 | 22.7286 | 22.7071 | 22.7171 | 252280.0 |
| 2012-10-09 08:30:00 | AAPL | Stock | 22.715 | 22.7457 | 22.7143 | 22.7357 | 197596.0 |
| 2012-10-09 08:35:00 | AAPL | Stock | 22.735 | 22.7675 | 22.7321 | 22.7675 | 348600.0 |
| 2012-10-09 08:40:00 | AAPL | Stock | 22.7607 | 22.7732 | 22.755 | 22.76 | 221872.0 |
| 2012-10-09 08:45:00 | AAPL | Stock | 22.7539 | 22.775 | 22.7539 | 22.7743 | 132300.0 |
| 2012-10-09 08:50:00 | AAPL | Stock | 22.7732 | 22.7732 | 22.7393 | 22.7393 | 249704.0 |
| 2012-10-09 08:55:00 | AAPL | Stock | 22.7379 | 22.7446 | 22.7214 | 22.7214 | 373408.0 |
| 2012-10-09 09:00:00 | AAPL | Stock | 22.7214 | 22.7357 | 22.7214 | 22.7304 | 133980.0 |
| 2012-10-09 09:05:00 | AAPL | Stock | 22.7386 | 22.7386 | 22.7071 | 22.7071 | 245056.0 |
> showing 50 of 315,492 rows — these rows as CSV