PREVIEW / stock_1min / 2008-03-14
file: by_date/stock_1min/2008/2008-03-14.parquet size: 12.8 MB rows: 1,035,494 symbols: 2,650
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-14 05:54:00 | AAPL | Stock | 4.5589 | 4.5589 | 4.5589 | 4.5589 | 2800.0 |
| 2008-03-14 06:00:00 | AAPL | Stock | 4.5589 | 4.5589 | 4.5589 | 4.5589 | 2800.0 |
| 2008-03-14 06:18:00 | AAPL | Stock | 4.56 | 4.56 | 4.56 | 4.56 | 2800.0 |
| 2008-03-14 06:20:00 | AAPL | Stock | 4.56 | 4.56 | 4.56 | 4.56 | 2800.0 |
| 2008-03-14 06:31:00 | AAPL | Stock | 4.5604 | 4.5604 | 4.56 | 4.56 | 8400.0 |
| 2008-03-14 06:42:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 2800.0 |
| 2008-03-14 07:21:00 | AAPL | Stock | 4.56 | 4.56 | 4.5557 | 4.5557 | 11200.0 |
| 2008-03-14 07:22:00 | AAPL | Stock | 4.5571 | 4.5571 | 4.5571 | 4.5571 | 14000.0 |
| 2008-03-14 07:26:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5536 | 4.5536 | 25200.0 |
| 2008-03-14 07:40:00 | AAPL | Stock | 4.5471 | 4.5471 | 4.5471 | 4.5471 | 47600.0 |
| 2008-03-14 07:53:00 | AAPL | Stock | 4.5504 | 4.5504 | 4.5504 | 4.5504 | 28000.0 |
| 2008-03-14 08:00:00 | AAPL | Stock | 4.5504 | 4.5607 | 4.55 | 4.5539 | 58940.0 |
| 2008-03-14 08:01:00 | AAPL | Stock | 4.5571 | 4.5636 | 4.5571 | 4.5636 | 14000.0 |
| 2008-03-14 08:02:00 | AAPL | Stock | 4.5632 | 4.5711 | 4.5632 | 4.5668 | 345268.0 |
| 2008-03-14 08:03:00 | AAPL | Stock | 4.5671 | 4.5675 | 4.5668 | 4.5668 | 61600.0 |
| 2008-03-14 08:04:00 | AAPL | Stock | 4.5675 | 4.5686 | 4.5607 | 4.5686 | 30800.0 |
| 2008-03-14 08:05:00 | AAPL | Stock | 4.5668 | 4.5768 | 4.5668 | 4.5761 | 266896.0 |
| 2008-03-14 08:06:00 | AAPL | Stock | 4.575 | 4.5857 | 4.575 | 4.5768 | 163912.0 |
| 2008-03-14 08:07:00 | AAPL | Stock | 4.575 | 4.5786 | 4.5725 | 4.5725 | 72800.0 |
| 2008-03-14 08:08:00 | AAPL | Stock | 4.575 | 4.575 | 4.5679 | 4.5714 | 347200.0 |
| 2008-03-14 08:09:00 | AAPL | Stock | 4.5732 | 4.5786 | 4.5732 | 4.575 | 49000.0 |
| 2008-03-14 08:10:00 | AAPL | Stock | 4.5775 | 4.5779 | 4.5664 | 4.5664 | 187600.0 |
| 2008-03-14 08:12:00 | AAPL | Stock | 4.5689 | 4.5786 | 4.5689 | 4.5786 | 200368.0 |
| 2008-03-14 08:13:00 | AAPL | Stock | 4.5793 | 4.5839 | 4.5793 | 4.5839 | 15064.0 |
| 2008-03-14 08:14:00 | AAPL | Stock | 4.5786 | 4.5839 | 4.5786 | 4.5839 | 13944.0 |
| 2008-03-14 08:15:00 | AAPL | Stock | 4.5843 | 4.5875 | 4.5843 | 4.5861 | 97972.0 |
| 2008-03-14 08:16:00 | AAPL | Stock | 4.5857 | 4.5857 | 4.5718 | 4.5854 | 159628.0 |
| 2008-03-14 08:17:00 | AAPL | Stock | 4.5843 | 4.5857 | 4.5843 | 4.5857 | 8400.0 |
| 2008-03-14 08:18:00 | AAPL | Stock | 4.5796 | 4.5796 | 4.5754 | 4.5754 | 30800.0 |
| 2008-03-14 08:19:00 | AAPL | Stock | 4.5786 | 4.5786 | 4.5786 | 4.5786 | 11200.0 |
| 2008-03-14 08:20:00 | AAPL | Stock | 4.5796 | 4.5796 | 4.5771 | 4.5771 | 23240.0 |
| 2008-03-14 08:21:00 | AAPL | Stock | 4.5768 | 4.5768 | 4.575 | 4.575 | 5600.0 |
| 2008-03-14 08:22:00 | AAPL | Stock | 4.5739 | 4.5739 | 4.5739 | 4.5739 | 2800.0 |
| 2008-03-14 08:23:00 | AAPL | Stock | 4.5768 | 4.5768 | 4.5768 | 4.5768 | 2800.0 |
| 2008-03-14 08:24:00 | AAPL | Stock | 4.575 | 4.575 | 4.575 | 4.575 | 5600.0 |
| 2008-03-14 08:25:00 | AAPL | Stock | 4.575 | 4.575 | 4.5714 | 4.5714 | 72800.0 |
| 2008-03-14 08:26:00 | AAPL | Stock | 4.5704 | 4.5714 | 4.5704 | 4.5714 | 81200.0 |
| 2008-03-14 08:27:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5689 | 4.5689 | 41496.0 |
| 2008-03-14 08:28:00 | AAPL | Stock | 4.5696 | 4.5696 | 4.5689 | 4.5689 | 40600.0 |
| 2008-03-14 08:29:00 | AAPL | Stock | 4.5696 | 4.5711 | 4.5661 | 4.5696 | 133896.0 |
| 2008-03-14 08:30:00 | AAPL | Stock | 4.5725 | 4.625 | 4.5711 | 4.6196 | 1726984.0 |
| 2008-03-14 08:31:00 | AAPL | Stock | 4.62 | 4.625 | 4.615 | 4.625 | 1055964.0 |
| 2008-03-14 08:32:00 | AAPL | Stock | 4.6218 | 4.625 | 4.6107 | 4.6143 | 293552.0 |
| 2008-03-14 08:33:00 | AAPL | Stock | 4.6161 | 4.6214 | 4.6107 | 4.6179 | 546000.0 |
| 2008-03-14 08:34:00 | AAPL | Stock | 4.6196 | 4.6354 | 4.6196 | 4.6354 | 791084.0 |
| 2008-03-14 08:35:00 | AAPL | Stock | 4.6354 | 4.6354 | 4.6193 | 4.625 | 317520.0 |
| 2008-03-14 08:36:00 | AAPL | Stock | 4.6218 | 4.6286 | 4.6218 | 4.6286 | 472500.0 |
| 2008-03-14 08:37:00 | AAPL | Stock | 4.6286 | 4.6304 | 4.6268 | 4.6296 | 254884.0 |
| 2008-03-14 08:38:00 | AAPL | Stock | 4.63 | 4.6368 | 4.63 | 4.6329 | 275884.0 |
| 2008-03-14 08:39:00 | AAPL | Stock | 4.6357 | 4.64 | 4.6357 | 4.6386 | 451192.0 |
> showing 50 of 1,035,494 rows — these rows as CSV