PREVIEW / stock_1min / 2007-08-14
file: by_date/stock_1min/2007/2007-08-14.parquet size: 12.1 MB rows: 976,807 symbols: 2,558
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-08-14 09:30:00 | AAPL | Stock | 4.5818 | 4.5821 | 4.5579 | 4.5632 | 7628796.0 |
| 2007-08-14 09:31:00 | AAPL | Stock | 4.5622 | 4.5786 | 4.5622 | 4.5743 | 2205924.0 |
| 2007-08-14 09:32:00 | AAPL | Stock | 4.5736 | 4.5764 | 4.5571 | 4.5582 | 3667776.0 |
| 2007-08-14 09:33:00 | AAPL | Stock | 4.5575 | 4.5761 | 4.5536 | 4.5625 | 4211788.0 |
| 2007-08-14 09:34:00 | AAPL | Stock | 4.5625 | 4.5679 | 4.5536 | 4.5554 | 4698232.0 |
| 2007-08-14 09:35:00 | AAPL | Stock | 4.555 | 4.5643 | 4.5511 | 4.5554 | 2549848.0 |
| 2007-08-14 09:36:00 | AAPL | Stock | 4.5557 | 4.5607 | 4.5529 | 4.5561 | 2104228.0 |
| 2007-08-14 09:37:00 | AAPL | Stock | 4.5554 | 4.5564 | 4.5482 | 4.5496 | 2936052.0 |
| 2007-08-14 09:38:00 | AAPL | Stock | 4.5496 | 4.55 | 4.5446 | 4.5479 | 3293248.0 |
| 2007-08-14 09:39:00 | AAPL | Stock | 4.5475 | 4.5589 | 4.5468 | 4.5564 | 2951256.0 |
| 2007-08-14 09:40:00 | AAPL | Stock | 4.5571 | 4.565 | 4.5564 | 4.5604 | 2681868.0 |
| 2007-08-14 09:41:00 | AAPL | Stock | 4.5604 | 4.5643 | 4.5586 | 4.5632 | 1594180.0 |
| 2007-08-14 09:42:00 | AAPL | Stock | 4.5629 | 4.5664 | 4.5614 | 4.5621 | 2027088.0 |
| 2007-08-14 09:43:00 | AAPL | Stock | 4.5621 | 4.5704 | 4.5621 | 4.5686 | 2378404.0 |
| 2007-08-14 09:44:00 | AAPL | Stock | 4.5686 | 4.5689 | 4.5521 | 4.5568 | 4357416.0 |
| 2007-08-14 09:45:00 | AAPL | Stock | 4.5569 | 4.5607 | 4.5464 | 4.5521 | 3059784.0 |
| 2007-08-14 09:46:00 | AAPL | Stock | 4.5518 | 4.5518 | 4.5339 | 4.5434 | 6471164.0 |
| 2007-08-14 09:47:00 | AAPL | Stock | 4.5432 | 4.5443 | 4.5339 | 4.5379 | 2813580.0 |
| 2007-08-14 09:48:00 | AAPL | Stock | 4.5379 | 4.5471 | 4.5339 | 4.5364 | 3455928.0 |
| 2007-08-14 09:49:00 | AAPL | Stock | 4.5364 | 4.5421 | 4.5304 | 4.5399 | 3182200.0 |
| 2007-08-14 09:50:00 | AAPL | Stock | 4.5404 | 4.5421 | 4.5304 | 4.5304 | 2744392.0 |
| 2007-08-14 09:51:00 | AAPL | Stock | 4.5314 | 4.5482 | 4.5268 | 4.5432 | 3272164.0 |
| 2007-08-14 09:52:00 | AAPL | Stock | 4.5439 | 4.5521 | 4.5396 | 4.55 | 1680756.0 |
| 2007-08-14 09:53:00 | AAPL | Stock | 4.5486 | 4.5507 | 4.5379 | 4.5379 | 1743476.0 |
| 2007-08-14 09:54:00 | AAPL | Stock | 4.5379 | 4.5446 | 4.5375 | 4.5396 | 968884.0 |
| 2007-08-14 09:55:00 | AAPL | Stock | 4.5393 | 4.5464 | 4.5393 | 4.5429 | 1585416.0 |
| 2007-08-14 09:56:00 | AAPL | Stock | 4.5418 | 4.5464 | 4.5414 | 4.5425 | 837508.0 |
| 2007-08-14 09:57:00 | AAPL | Stock | 4.5421 | 4.5536 | 4.5421 | 4.5504 | 1684900.0 |
| 2007-08-14 09:58:00 | AAPL | Stock | 4.55 | 4.5514 | 4.5446 | 4.5461 | 1484924.0 |
| 2007-08-14 09:59:00 | AAPL | Stock | 4.5457 | 4.5457 | 4.5318 | 4.5354 | 2576560.0 |
| 2007-08-14 10:00:00 | AAPL | Stock | 4.5357 | 4.5393 | 4.5332 | 4.5368 | 1523396.0 |
| 2007-08-14 10:01:00 | AAPL | Stock | 4.5375 | 4.5379 | 4.5321 | 4.5325 | 2538368.0 |
| 2007-08-14 10:02:00 | AAPL | Stock | 4.5329 | 4.5364 | 4.5321 | 4.5339 | 1098888.0 |
| 2007-08-14 10:03:00 | AAPL | Stock | 4.5343 | 4.54 | 4.5321 | 4.5354 | 1431864.0 |
| 2007-08-14 10:04:00 | AAPL | Stock | 4.5343 | 4.5357 | 4.5289 | 4.5321 | 1371216.0 |
| 2007-08-14 10:05:00 | AAPL | Stock | 4.5321 | 4.535 | 4.5311 | 4.5332 | 1113700.0 |
| 2007-08-14 10:06:00 | AAPL | Stock | 4.5329 | 4.5368 | 4.5221 | 4.5268 | 5307568.0 |
| 2007-08-14 10:07:00 | AAPL | Stock | 4.5268 | 4.5275 | 4.5136 | 4.5139 | 4177796.0 |
| 2007-08-14 10:08:00 | AAPL | Stock | 4.5139 | 4.5225 | 4.5121 | 4.5193 | 4679276.0 |
| 2007-08-14 10:09:00 | AAPL | Stock | 4.5193 | 4.5246 | 4.5175 | 4.5243 | 2553432.0 |
| 2007-08-14 10:10:00 | AAPL | Stock | 4.5246 | 4.5268 | 4.5143 | 4.5161 | 1860572.0 |
| 2007-08-14 10:11:00 | AAPL | Stock | 4.5161 | 4.5214 | 4.5161 | 4.52 | 1306872.0 |
| 2007-08-14 10:12:00 | AAPL | Stock | 4.5211 | 4.5257 | 4.5207 | 4.5239 | 1135596.0 |
| 2007-08-14 10:13:00 | AAPL | Stock | 4.5236 | 4.5261 | 4.5161 | 4.5207 | 1562596.0 |
| 2007-08-14 10:14:00 | AAPL | Stock | 4.5189 | 4.5214 | 4.5061 | 4.5071 | 3062752.0 |
| 2007-08-14 10:15:00 | AAPL | Stock | 4.5071 | 4.52 | 4.5054 | 4.5157 | 2639364.0 |
| 2007-08-14 10:16:00 | AAPL | Stock | 4.5159 | 4.5179 | 4.5154 | 4.5161 | 1304268.0 |
| 2007-08-14 10:17:00 | AAPL | Stock | 4.5157 | 4.5164 | 4.5082 | 4.5089 | 2389856.0 |
| 2007-08-14 10:18:00 | AAPL | Stock | 4.5089 | 4.5139 | 4.5075 | 4.5139 | 1741376.0 |
| 2007-08-14 10:19:00 | AAPL | Stock | 4.5139 | 4.5175 | 4.5129 | 4.5169 | 2026780.0 |
> showing 50 of 976,807 rows — these rows as CSV