PREVIEW / stock_5min / 2000-07-14
file: by_date/stock_5min/2000/2000-07-14.parquet size: 1.2 MB rows: 87,557 symbols: 1,190
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-14 08:00:00 | AAPL | Stock | 1.0095 | 1.0095 | 1.0089 | 1.0089 | 515200.0 |
| 2000-07-14 08:30:00 | AAPL | Stock | 1.0251 | 1.0251 | 1.0251 | 1.0251 | 5600.0 |
| 2000-07-14 08:40:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.0268 | 1.0268 | 5600.0 |
| 2000-07-14 08:45:00 | AAPL | Stock | 1.0089 | 1.0279 | 1.0089 | 1.0279 | 16800.0 |
| 2000-07-14 08:55:00 | AAPL | Stock | 1.0324 | 1.0324 | 1.0324 | 1.0324 | 28000.0 |
| 2000-07-14 09:05:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.0313 | 1.0313 | 134400.0 |
| 2000-07-14 09:15:00 | AAPL | Stock | 1.0279 | 1.0279 | 1.0251 | 1.0251 | 95200.0 |
| 2000-07-14 09:20:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0179 | 1.0179 | 78400.0 |
| 2000-07-14 09:25:00 | AAPL | Stock | 1.0201 | 1.0212 | 1.0201 | 1.0201 | 571200.0 |
| 2000-07-14 09:30:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0179 | 1.019 | 5952800.0 |
| 2000-07-14 09:35:00 | AAPL | Stock | 1.019 | 1.0246 | 1.0156 | 1.0212 | 5566400.0 |
| 2000-07-14 09:40:00 | AAPL | Stock | 1.0212 | 1.0324 | 1.0179 | 1.0313 | 3500000.0 |
| 2000-07-14 09:45:00 | AAPL | Stock | 1.0313 | 1.0379 | 1.0301 | 1.0357 | 3987200.0 |
| 2000-07-14 09:50:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0268 | 1.0279 | 2637600.0 |
| 2000-07-14 09:55:00 | AAPL | Stock | 1.0268 | 1.0313 | 1.0201 | 1.0279 | 3192000.0 |
| 2000-07-14 10:00:00 | AAPL | Stock | 1.0279 | 1.0279 | 1.0246 | 1.0257 | 1943200.0 |
| 2000-07-14 10:05:00 | AAPL | Stock | 1.0257 | 1.0279 | 1.0223 | 1.0257 | 4222400.0 |
| 2000-07-14 10:10:00 | AAPL | Stock | 1.0246 | 1.0313 | 1.0246 | 1.029 | 1220800.0 |
| 2000-07-14 10:15:00 | AAPL | Stock | 1.029 | 1.029 | 1.0234 | 1.0257 | 1148000.0 |
| 2000-07-14 10:20:00 | AAPL | Stock | 1.0246 | 1.029 | 1.0179 | 1.0201 | 3264800.0 |
| 2000-07-14 10:25:00 | AAPL | Stock | 1.0234 | 1.0313 | 1.0179 | 1.0301 | 2038400.0 |
| 2000-07-14 10:30:00 | AAPL | Stock | 1.029 | 1.0313 | 1.0268 | 1.0301 | 901600.0 |
| 2000-07-14 10:35:00 | AAPL | Stock | 1.0296 | 1.0324 | 1.029 | 1.0313 | 1764000.0 |
| 2000-07-14 10:40:00 | AAPL | Stock | 1.0301 | 1.0346 | 1.029 | 1.0346 | 1971200.0 |
| 2000-07-14 10:45:00 | AAPL | Stock | 1.0346 | 1.0368 | 1.0324 | 1.0324 | 2564800.0 |
| 2000-07-14 10:50:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0313 | 1.0324 | 1383200.0 |
| 2000-07-14 10:55:00 | AAPL | Stock | 1.0313 | 1.0324 | 1.029 | 1.0301 | 767200.0 |
| 2000-07-14 11:00:00 | AAPL | Stock | 1.0301 | 1.0313 | 1.0268 | 1.0301 | 1456000.0 |
| 2000-07-14 11:05:00 | AAPL | Stock | 1.0313 | 1.0379 | 1.0268 | 1.0368 | 6608000.0 |
| 2000-07-14 11:10:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0335 | 1.0357 | 3589600.0 |
| 2000-07-14 11:15:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0335 | 1.0357 | 1338400.0 |
| 2000-07-14 11:20:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0346 | 1.0357 | 1646400.0 |
| 2000-07-14 11:25:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0357 | 1.0368 | 1584800.0 |
| 2000-07-14 11:30:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0357 | 851200.0 |
| 2000-07-14 11:35:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0335 | 1.0335 | 812000.0 |
| 2000-07-14 11:40:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.0335 | 1.0335 | 918400.0 |
| 2000-07-14 11:45:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.029 | 1.0346 | 1545600.0 |
| 2000-07-14 11:50:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0324 | 1.0324 | 784000.0 |
| 2000-07-14 11:55:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.0268 | 1.0335 | 1612800.0 |
| 2000-07-14 12:00:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.0279 | 1.0335 | 1590400.0 |
| 2000-07-14 12:05:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.0301 | 1.0335 | 722400.0 |
| 2000-07-14 12:10:00 | AAPL | Stock | 1.0335 | 1.0379 | 1.0313 | 1.0357 | 4821600.0 |
| 2000-07-14 12:15:00 | AAPL | Stock | 1.0368 | 1.0368 | 1.0346 | 1.0357 | 683200.0 |
| 2000-07-14 12:20:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0346 | 1.0346 | 296800.0 |
| 2000-07-14 12:25:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0313 | 1.0313 | 2805600.0 |
| 2000-07-14 12:30:00 | AAPL | Stock | 1.0301 | 1.0324 | 1.0268 | 1.0313 | 3096800.0 |
| 2000-07-14 12:35:00 | AAPL | Stock | 1.029 | 1.029 | 1.0246 | 1.0257 | 2576000.0 |
| 2000-07-14 12:40:00 | AAPL | Stock | 1.0246 | 1.0279 | 1.019 | 1.0223 | 2665600.0 |
| 2000-07-14 12:45:00 | AAPL | Stock | 1.0223 | 1.0246 | 1.0201 | 1.0246 | 1254400.0 |
| 2000-07-14 12:50:00 | AAPL | Stock | 1.0246 | 1.0279 | 1.0234 | 1.0246 | 1075200.0 |
> showing 50 of 87,557 rows — these rows as CSV