PREVIEW / stock_5min / 2006-09-07
file: by_date/stock_5min/2006/2006-09-07.parquet size: 3.1 MB rows: 225,011 symbols: 2,357
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-07 04:25:00 | AAPL | Stock | 2.4964 | 2.4964 | 2.4964 | 2.4964 | 2800.0 |
| 2006-09-07 04:45:00 | AAPL | Stock | 2.4964 | 2.4964 | 2.4964 | 2.4964 | 25200.0 |
| 2006-09-07 06:35:00 | AAPL | Stock | 2.5018 | 2.5018 | 2.5018 | 2.5018 | 2800.0 |
| 2006-09-07 06:55:00 | AAPL | Stock | 2.5004 | 2.5004 | 2.5004 | 2.5004 | 5600.0 |
| 2006-09-07 07:15:00 | AAPL | Stock | 2.5089 | 2.5089 | 2.5089 | 2.5089 | 58100.0 |
| 2006-09-07 07:20:00 | AAPL | Stock | 2.5089 | 2.5089 | 2.5089 | 2.5089 | 8400.0 |
| 2006-09-07 07:25:00 | AAPL | Stock | 2.5089 | 2.5161 | 2.5089 | 2.5161 | 5600.0 |
| 2006-09-07 07:30:00 | AAPL | Stock | 2.5096 | 2.5096 | 2.5096 | 2.5096 | 26600.0 |
| 2006-09-07 07:35:00 | AAPL | Stock | 2.5107 | 2.5171 | 2.5107 | 2.5143 | 32900.0 |
| 2006-09-07 07:40:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5143 | 2.5143 | 44800.0 |
| 2006-09-07 07:45:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5143 | 2.5143 | 22400.0 |
| 2006-09-07 07:50:00 | AAPL | Stock | 2.5136 | 2.5179 | 2.5136 | 2.5179 | 44100.0 |
| 2006-09-07 07:55:00 | AAPL | Stock | 2.5136 | 2.5136 | 2.5136 | 2.5136 | 2800.0 |
| 2006-09-07 08:00:00 | AAPL | Stock | 2.5175 | 2.5175 | 2.5125 | 2.5129 | 720300.0 |
| 2006-09-07 08:05:00 | AAPL | Stock | 2.5129 | 2.5157 | 2.5107 | 2.5136 | 374080.0 |
| 2006-09-07 08:10:00 | AAPL | Stock | 2.5143 | 2.5171 | 2.5136 | 2.5161 | 182252.0 |
| 2006-09-07 08:15:00 | AAPL | Stock | 2.5168 | 2.5179 | 2.5143 | 2.5179 | 496440.0 |
| 2006-09-07 08:20:00 | AAPL | Stock | 2.5179 | 2.5193 | 2.5179 | 2.5179 | 332500.0 |
| 2006-09-07 08:25:00 | AAPL | Stock | 2.5193 | 2.5211 | 2.5179 | 2.5211 | 493500.0 |
| 2006-09-07 08:30:00 | AAPL | Stock | 2.5204 | 2.5229 | 2.5196 | 2.5229 | 746928.0 |
| 2006-09-07 08:35:00 | AAPL | Stock | 2.5214 | 2.5232 | 2.5196 | 2.5229 | 357280.0 |
| 2006-09-07 08:40:00 | AAPL | Stock | 2.5179 | 2.5232 | 2.5179 | 2.5232 | 961520.0 |
| 2006-09-07 08:45:00 | AAPL | Stock | 2.5232 | 2.5243 | 2.5196 | 2.52 | 535752.0 |
| 2006-09-07 08:50:00 | AAPL | Stock | 2.5214 | 2.5232 | 2.5214 | 2.5221 | 108080.0 |
| 2006-09-07 08:55:00 | AAPL | Stock | 2.5229 | 2.525 | 2.5229 | 2.5232 | 634760.0 |
| 2006-09-07 09:00:00 | AAPL | Stock | 2.5218 | 2.5232 | 2.5196 | 2.5196 | 573216.0 |
| 2006-09-07 09:05:00 | AAPL | Stock | 2.52 | 2.5214 | 2.5182 | 2.5207 | 267680.0 |
| 2006-09-07 09:10:00 | AAPL | Stock | 2.5204 | 2.5207 | 2.52 | 2.52 | 89600.0 |
| 2006-09-07 09:15:00 | AAPL | Stock | 2.52 | 2.5214 | 2.5182 | 2.5182 | 283360.0 |
| 2006-09-07 09:20:00 | AAPL | Stock | 2.5182 | 2.5218 | 2.5182 | 2.5218 | 274708.0 |
| 2006-09-07 09:25:00 | AAPL | Stock | 2.5211 | 2.5243 | 2.5179 | 2.5207 | 1246840.0 |
| 2006-09-07 09:30:00 | AAPL | Stock | 2.5214 | 2.5325 | 2.5089 | 2.51 | 35749336.0 |
| 2006-09-07 09:35:00 | AAPL | Stock | 2.51 | 2.5196 | 2.5096 | 2.5189 | 22153964.0 |
| 2006-09-07 09:40:00 | AAPL | Stock | 2.5186 | 2.5304 | 2.5107 | 2.5275 | 20519464.0 |
| 2006-09-07 09:45:00 | AAPL | Stock | 2.5271 | 2.5436 | 2.5254 | 2.5411 | 29454040.0 |
| 2006-09-07 09:50:00 | AAPL | Stock | 2.5411 | 2.5493 | 2.5386 | 2.5396 | 31962364.0 |
| 2006-09-07 09:55:00 | AAPL | Stock | 2.5396 | 2.5404 | 2.5339 | 2.5371 | 20184584.0 |
| 2006-09-07 10:00:00 | AAPL | Stock | 2.5375 | 2.5389 | 2.5321 | 2.5343 | 18130504.0 |
| 2006-09-07 10:05:00 | AAPL | Stock | 2.5343 | 2.5393 | 2.5296 | 2.5393 | 15013880.0 |
| 2006-09-07 10:10:00 | AAPL | Stock | 2.5393 | 2.5529 | 2.5386 | 2.55 | 23922388.0 |
| 2006-09-07 10:15:00 | AAPL | Stock | 2.5496 | 2.5557 | 2.5454 | 2.5489 | 27726552.0 |
| 2006-09-07 10:20:00 | AAPL | Stock | 2.5486 | 2.5589 | 2.5468 | 2.5564 | 26726196.0 |
| 2006-09-07 10:25:00 | AAPL | Stock | 2.5564 | 2.5571 | 2.5489 | 2.5543 | 15879584.0 |
| 2006-09-07 10:30:00 | AAPL | Stock | 2.5543 | 2.5625 | 2.5496 | 2.56 | 19779816.0 |
| 2006-09-07 10:35:00 | AAPL | Stock | 2.5604 | 2.5686 | 2.5575 | 2.5657 | 19949972.0 |
| 2006-09-07 10:40:00 | AAPL | Stock | 2.5654 | 2.5714 | 2.5596 | 2.5599 | 26928216.0 |
| 2006-09-07 10:45:00 | AAPL | Stock | 2.56 | 2.5607 | 2.5507 | 2.5546 | 24944612.0 |
| 2006-09-07 10:50:00 | AAPL | Stock | 2.5543 | 2.5607 | 2.5514 | 2.5564 | 17429636.0 |
| 2006-09-07 10:55:00 | AAPL | Stock | 2.5564 | 2.5632 | 2.5521 | 2.5586 | 13618948.0 |
| 2006-09-07 11:00:00 | AAPL | Stock | 2.5586 | 2.5664 | 2.5579 | 2.5643 | 13882540.0 |
> showing 50 of 225,011 rows — these rows as CSV