PREVIEW / stock_5min / 2007-12-19
file: by_date/stock_5min/2007/2007-12-19.parquet size: 4.4 MB rows: 323,551 symbols: 3,230
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-12-19 05:35:00 | AAPL | Stock | 6.5286 | 6.5286 | 6.5286 | 6.5286 | 8400.0 |
| 2007-12-19 05:40:00 | AAPL | Stock | 6.5271 | 6.5271 | 6.5271 | 6.5271 | 22400.0 |
| 2007-12-19 06:00:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5 | 6.5 | 8400.0 |
| 2007-12-19 06:05:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 2800.0 |
| 2007-12-19 06:15:00 | AAPL | Stock | 6.5254 | 6.5264 | 6.525 | 6.5264 | 19600.0 |
| 2007-12-19 06:20:00 | AAPL | Stock | 6.5236 | 6.5236 | 6.5236 | 6.5236 | 2800.0 |
| 2007-12-19 06:35:00 | AAPL | Stock | 6.5286 | 6.5286 | 6.5286 | 6.5286 | 14000.0 |
| 2007-12-19 07:20:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 2800.0 |
| 2007-12-19 07:30:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5107 | 6.5107 | 11200.0 |
| 2007-12-19 07:35:00 | AAPL | Stock | 6.5264 | 6.5264 | 6.5264 | 6.5264 | 2800.0 |
| 2007-12-19 07:40:00 | AAPL | Stock | 6.5275 | 6.5286 | 6.5186 | 6.5264 | 28000.0 |
| 2007-12-19 07:50:00 | AAPL | Stock | 6.5286 | 6.5286 | 6.5179 | 6.5179 | 8400.0 |
| 2007-12-19 07:55:00 | AAPL | Stock | 6.5179 | 6.5325 | 6.5179 | 6.5325 | 7756.0 |
| 2007-12-19 08:00:00 | AAPL | Stock | 6.5318 | 6.5343 | 6.5204 | 6.5286 | 115808.0 |
| 2007-12-19 08:05:00 | AAPL | Stock | 6.5286 | 6.5286 | 6.5196 | 6.525 | 150220.0 |
| 2007-12-19 08:10:00 | AAPL | Stock | 6.5264 | 6.5311 | 6.5232 | 6.5232 | 22400.0 |
| 2007-12-19 08:15:00 | AAPL | Stock | 6.525 | 6.5286 | 6.525 | 6.5286 | 200508.0 |
| 2007-12-19 08:20:00 | AAPL | Stock | 6.5286 | 6.5389 | 6.5268 | 6.5389 | 499800.0 |
| 2007-12-19 08:25:00 | AAPL | Stock | 6.5375 | 6.5446 | 6.5371 | 6.5411 | 226100.0 |
| 2007-12-19 08:30:00 | AAPL | Stock | 6.5393 | 6.5411 | 6.5357 | 6.5389 | 170800.0 |
| 2007-12-19 08:35:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5286 | 6.5286 | 41440.0 |
| 2007-12-19 08:40:00 | AAPL | Stock | 6.5286 | 6.5318 | 6.5268 | 6.5275 | 54740.0 |
| 2007-12-19 08:45:00 | AAPL | Stock | 6.5318 | 6.5321 | 6.5318 | 6.5321 | 72800.0 |
| 2007-12-19 08:50:00 | AAPL | Stock | 6.5329 | 6.535 | 6.5275 | 6.5307 | 316736.0 |
| 2007-12-19 08:55:00 | AAPL | Stock | 6.5286 | 6.5286 | 6.52 | 6.525 | 77700.0 |
| 2007-12-19 09:00:00 | AAPL | Stock | 6.525 | 6.5321 | 6.5204 | 6.5318 | 118440.0 |
| 2007-12-19 09:05:00 | AAPL | Stock | 6.5311 | 6.5496 | 6.5311 | 6.5375 | 393512.0 |
| 2007-12-19 09:10:00 | AAPL | Stock | 6.5379 | 6.5429 | 6.5375 | 6.5429 | 146272.0 |
| 2007-12-19 09:15:00 | AAPL | Stock | 6.5393 | 6.5429 | 6.5375 | 6.5393 | 312956.0 |
| 2007-12-19 09:20:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5268 | 6.5271 | 98700.0 |
| 2007-12-19 09:25:00 | AAPL | Stock | 6.53 | 6.5375 | 6.5279 | 6.5357 | 470596.0 |
| 2007-12-19 09:30:00 | AAPL | Stock | 6.535 | 6.5693 | 6.5193 | 6.5207 | 23192064.0 |
| 2007-12-19 09:35:00 | AAPL | Stock | 6.5211 | 6.5546 | 6.4971 | 6.5464 | 25428788.0 |
| 2007-12-19 09:40:00 | AAPL | Stock | 6.5464 | 6.5525 | 6.5179 | 6.5371 | 15813224.0 |
| 2007-12-19 09:45:00 | AAPL | Stock | 6.5361 | 6.5746 | 6.5232 | 6.5625 | 21967820.0 |
| 2007-12-19 09:50:00 | AAPL | Stock | 6.5614 | 6.565 | 6.5436 | 6.547 | 14286216.0 |
| 2007-12-19 09:55:00 | AAPL | Stock | 6.5486 | 6.5625 | 6.5446 | 6.56 | 13264104.0 |
| 2007-12-19 10:00:00 | AAPL | Stock | 6.5604 | 6.5814 | 6.5568 | 6.5736 | 21147560.0 |
| 2007-12-19 10:05:00 | AAPL | Stock | 6.5743 | 6.5942 | 6.5725 | 6.575 | 17547712.0 |
| 2007-12-19 10:10:00 | AAPL | Stock | 6.5746 | 6.5768 | 6.55 | 6.5579 | 14657692.0 |
| 2007-12-19 10:15:00 | AAPL | Stock | 6.5575 | 6.5675 | 6.5429 | 6.5482 | 12649504.0 |
| 2007-12-19 10:20:00 | AAPL | Stock | 6.5482 | 6.5725 | 6.5389 | 6.5707 | 15574076.0 |
| 2007-12-19 10:25:00 | AAPL | Stock | 6.5707 | 6.5757 | 6.5593 | 6.57 | 11382672.0 |
| 2007-12-19 10:30:00 | AAPL | Stock | 6.57 | 6.5714 | 6.5582 | 6.5596 | 6519856.0 |
| 2007-12-19 10:35:00 | AAPL | Stock | 6.5596 | 6.5625 | 6.5325 | 6.5339 | 14169764.0 |
| 2007-12-19 10:40:00 | AAPL | Stock | 6.5339 | 6.5532 | 6.525 | 6.5425 | 17568684.0 |
| 2007-12-19 10:45:00 | AAPL | Stock | 6.5425 | 6.5546 | 6.5364 | 6.5382 | 10697456.0 |
| 2007-12-19 10:50:00 | AAPL | Stock | 6.5389 | 6.5468 | 6.5161 | 6.53 | 12310228.0 |
| 2007-12-19 10:55:00 | AAPL | Stock | 6.5296 | 6.5329 | 6.5179 | 6.5279 | 8014412.0 |
| 2007-12-19 11:00:00 | AAPL | Stock | 6.5271 | 6.5282 | 6.5196 | 6.5207 | 7878528.0 |
> showing 50 of 323,551 rows — these rows as CSV