PREVIEW / stock_5min / 2000-07-12
file: by_date/stock_5min/2000/2000-07-12.parquet size: 1.2 MB rows: 91,178 symbols: 1,197
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-12 08:00:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.0167 | 1.0167 | 173600.0 |
| 2000-07-12 08:15:00 | AAPL | Stock | 1.0313 | 1.0346 | 1.0313 | 1.0346 | 61600.0 |
| 2000-07-12 08:30:00 | AAPL | Stock | 1.0335 | 1.0357 | 1.0335 | 1.0357 | 56000.0 |
| 2000-07-12 08:35:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0324 | 1.0324 | 56000.0 |
| 2000-07-12 08:45:00 | AAPL | Stock | 1.0335 | 1.0335 | 1.0335 | 1.0335 | 112000.0 |
| 2000-07-12 08:50:00 | AAPL | Stock | 1.0335 | 1.0335 | 1.0335 | 1.0335 | 28000.0 |
| 2000-07-12 08:55:00 | AAPL | Stock | 1.0335 | 1.0335 | 1.0335 | 1.0335 | 84000.0 |
| 2000-07-12 09:15:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.0313 | 1.0324 | 179200.0 |
| 2000-07-12 09:20:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.0324 | 1.0335 | 352800.0 |
| 2000-07-12 09:25:00 | AAPL | Stock | 1.0335 | 1.0379 | 1.0335 | 1.0379 | 548800.0 |
| 2000-07-12 09:30:00 | AAPL | Stock | 1.0379 | 1.0391 | 1.0268 | 1.029 | 6708800.0 |
| 2000-07-12 09:35:00 | AAPL | Stock | 1.029 | 1.0352 | 1.0279 | 1.0296 | 4429600.0 |
| 2000-07-12 09:40:00 | AAPL | Stock | 1.0301 | 1.0313 | 1.0134 | 1.0134 | 4569600.0 |
| 2000-07-12 09:45:00 | AAPL | Stock | 1.0134 | 1.0301 | 1.0112 | 1.0212 | 3852800.0 |
| 2000-07-12 09:50:00 | AAPL | Stock | 1.0212 | 1.0301 | 1.0212 | 1.029 | 3606400.0 |
| 2000-07-12 09:55:00 | AAPL | Stock | 1.0296 | 1.0346 | 1.0268 | 1.0296 | 4513600.0 |
| 2000-07-12 10:00:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0268 | 1.029 | 2828000.0 |
| 2000-07-12 10:05:00 | AAPL | Stock | 1.0301 | 1.0357 | 1.0285 | 1.0335 | 3248000.0 |
| 2000-07-12 10:10:00 | AAPL | Stock | 1.0335 | 1.0357 | 1.0313 | 1.0357 | 4771200.0 |
| 2000-07-12 10:15:00 | AAPL | Stock | 1.0357 | 1.0424 | 1.0346 | 1.0424 | 4407200.0 |
| 2000-07-12 10:20:00 | AAPL | Stock | 1.0424 | 1.0435 | 1.029 | 1.0301 | 2105600.0 |
| 2000-07-12 10:25:00 | AAPL | Stock | 1.0301 | 1.0301 | 1.0268 | 1.0268 | 2284800.0 |
| 2000-07-12 10:30:00 | AAPL | Stock | 1.0279 | 1.0324 | 1.0268 | 1.0268 | 3012800.0 |
| 2000-07-12 10:35:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0246 | 1.0268 | 1680000.0 |
| 2000-07-12 10:40:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.0134 | 1.0167 | 2100000.0 |
| 2000-07-12 10:45:00 | AAPL | Stock | 1.0162 | 1.0201 | 1.0134 | 1.0167 | 2206400.0 |
| 2000-07-12 10:50:00 | AAPL | Stock | 1.0156 | 1.0173 | 1.0145 | 1.0145 | 1428000.0 |
| 2000-07-12 10:55:00 | AAPL | Stock | 1.0134 | 1.0167 | 1.0134 | 1.0156 | 2682400.0 |
| 2000-07-12 11:00:00 | AAPL | Stock | 1.0156 | 1.0201 | 1.0145 | 1.0179 | 2178400.0 |
| 2000-07-12 11:05:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0145 | 1.019 | 2503200.0 |
| 2000-07-12 11:10:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0167 | 1.0201 | 1159200.0 |
| 2000-07-12 11:15:00 | AAPL | Stock | 1.019 | 1.0201 | 1.0179 | 1.019 | 3085600.0 |
| 2000-07-12 11:20:00 | AAPL | Stock | 1.019 | 1.0257 | 1.0179 | 1.0257 | 3281600.0 |
| 2000-07-12 11:25:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0246 | 1.0279 | 3119200.0 |
| 2000-07-12 11:30:00 | AAPL | Stock | 1.0279 | 1.0313 | 1.0246 | 1.029 | 2973600.0 |
| 2000-07-12 11:35:00 | AAPL | Stock | 1.0301 | 1.0313 | 1.0246 | 1.0257 | 1629600.0 |
| 2000-07-12 11:40:00 | AAPL | Stock | 1.0234 | 1.0313 | 1.0234 | 1.029 | 2189600.0 |
| 2000-07-12 11:45:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0268 | 1.0268 | 1456000.0 |
| 2000-07-12 11:50:00 | AAPL | Stock | 1.0257 | 1.0257 | 1.0179 | 1.0179 | 2072000.0 |
| 2000-07-12 11:55:00 | AAPL | Stock | 1.0184 | 1.019 | 1.0156 | 1.0167 | 4407200.0 |
| 2000-07-12 12:00:00 | AAPL | Stock | 1.019 | 1.019 | 1.0112 | 1.0112 | 3304000.0 |
| 2000-07-12 12:05:00 | AAPL | Stock | 1.01 | 1.0128 | 1.01 | 1.0112 | 3623200.0 |
| 2000-07-12 12:10:00 | AAPL | Stock | 1.0112 | 1.0156 | 1.01 | 1.0145 | 2699200.0 |
| 2000-07-12 12:15:00 | AAPL | Stock | 1.0145 | 1.0145 | 1.0123 | 1.0134 | 2564800.0 |
| 2000-07-12 12:20:00 | AAPL | Stock | 1.0123 | 1.0134 | 1.0089 | 1.01 | 5908000.0 |
| 2000-07-12 12:25:00 | AAPL | Stock | 1.01 | 1.01 | 1.0067 | 1.0089 | 4446400.0 |
| 2000-07-12 12:30:00 | AAPL | Stock | 1.0078 | 1.0123 | 1.0078 | 1.0112 | 3220000.0 |
| 2000-07-12 12:35:00 | AAPL | Stock | 1.0112 | 1.019 | 1.0112 | 1.019 | 5768000.0 |
| 2000-07-12 12:40:00 | AAPL | Stock | 1.0179 | 1.0223 | 1.0167 | 1.0167 | 1075200.0 |
| 2000-07-12 12:45:00 | AAPL | Stock | 1.0167 | 1.0212 | 1.0167 | 1.0179 | 929600.0 |
> showing 50 of 91,178 rows — these rows as CSV