PREVIEW / stock_5min / 2023-03-28
file: by_date/stock_5min/2023/2023-03-28.parquet size: 6.5 MB rows: 399,779 symbols: 1,748
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-28 04:00:00 | AAPL | Stock | 157.95 | 158.06 | 157.26 | 157.35 | 7175.0 |
| 2023-03-28 04:05:00 | AAPL | Stock | 157.45 | 157.56 | 157.41 | 157.47 | 2698.0 |
| 2023-03-28 04:10:00 | AAPL | Stock | 157.47 | 157.47 | 157.34 | 157.34 | 1428.0 |
| 2023-03-28 04:15:00 | AAPL | Stock | 157.37 | 157.37 | 157.3 | 157.33 | 2079.0 |
| 2023-03-28 04:20:00 | AAPL | Stock | 157.44 | 157.44 | 157.44 | 157.44 | 100.0 |
| 2023-03-28 04:25:00 | AAPL | Stock | 157.58 | 157.58 | 157.58 | 157.58 | 100.0 |
| 2023-03-28 04:30:00 | AAPL | Stock | 157.6 | 157.6 | 157.59 | 157.59 | 1000.0 |
| 2023-03-28 04:35:00 | AAPL | Stock | 157.53 | 157.53 | 157.46 | 157.46 | 343.0 |
| 2023-03-28 04:40:00 | AAPL | Stock | 157.48 | 157.48 | 157.42 | 157.42 | 1430.0 |
| 2023-03-28 04:45:00 | AAPL | Stock | 157.5 | 157.5 | 157.47 | 157.47 | 1000.0 |
| 2023-03-28 04:55:00 | AAPL | Stock | 157.57 | 157.57 | 157.57 | 157.57 | 211.0 |
| 2023-03-28 05:00:00 | AAPL | Stock | 157.55 | 157.57 | 157.55 | 157.57 | 600.0 |
| 2023-03-28 05:05:00 | AAPL | Stock | 157.64 | 157.64 | 157.64 | 157.64 | 1000.0 |
| 2023-03-28 05:10:00 | AAPL | Stock | 157.56 | 157.56 | 157.56 | 157.56 | 189.0 |
| 2023-03-28 05:20:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 991.0 |
| 2023-03-28 05:30:00 | AAPL | Stock | 157.55 | 157.55 | 157.55 | 157.55 | 260.0 |
| 2023-03-28 05:35:00 | AAPL | Stock | 157.59 | 157.6 | 157.59 | 157.6 | 675.0 |
| 2023-03-28 05:45:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 445.0 |
| 2023-03-28 05:55:00 | AAPL | Stock | 157.59 | 157.6 | 157.59 | 157.6 | 2433.0 |
| 2023-03-28 06:00:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 1500.0 |
| 2023-03-28 06:20:00 | AAPL | Stock | 157.67 | 157.67 | 157.67 | 157.67 | 245.0 |
| 2023-03-28 06:25:00 | AAPL | Stock | 157.66 | 157.67 | 157.66 | 157.67 | 299.0 |
| 2023-03-28 06:30:00 | AAPL | Stock | 157.62 | 157.62 | 157.62 | 157.62 | 188.0 |
| 2023-03-28 06:35:00 | AAPL | Stock | 157.53 | 157.53 | 157.5 | 157.5 | 6105.0 |
| 2023-03-28 06:40:00 | AAPL | Stock | 157.45 | 157.49 | 157.41 | 157.41 | 1418.0 |
| 2023-03-28 06:45:00 | AAPL | Stock | 157.45 | 157.45 | 157.38 | 157.38 | 2215.0 |
| 2023-03-28 06:50:00 | AAPL | Stock | 157.45 | 157.45 | 157.45 | 157.45 | 1000.0 |
| 2023-03-28 06:55:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 100.0 |
| 2023-03-28 07:00:00 | AAPL | Stock | 157.57 | 157.67 | 157.49 | 157.5 | 9113.0 |
| 2023-03-28 07:05:00 | AAPL | Stock | 157.48 | 157.55 | 157.4 | 157.4 | 3512.0 |
| 2023-03-28 07:10:00 | AAPL | Stock | 157.45 | 157.5 | 157.45 | 157.5 | 1679.0 |
| 2023-03-28 07:15:00 | AAPL | Stock | 157.5 | 157.55 | 157.5 | 157.55 | 23698.0 |
| 2023-03-28 07:20:00 | AAPL | Stock | 157.55 | 157.63 | 157.53 | 157.56 | 18989.0 |
| 2023-03-28 07:25:00 | AAPL | Stock | 157.56 | 157.67 | 157.56 | 157.66 | 5066.0 |
| 2023-03-28 07:30:00 | AAPL | Stock | 157.69 | 157.77 | 157.6 | 157.65 | 1148.0 |
| 2023-03-28 07:40:00 | AAPL | Stock | 157.65 | 157.65 | 157.65 | 157.65 | 100.0 |
| 2023-03-28 07:45:00 | AAPL | Stock | 157.75 | 157.78 | 157.71 | 157.78 | 1383.0 |
| 2023-03-28 07:50:00 | AAPL | Stock | 157.79 | 157.79 | 157.72 | 157.75 | 1803.0 |
| 2023-03-28 07:55:00 | AAPL | Stock | 157.75 | 157.78 | 157.66 | 157.7 | 1786.0 |
| 2023-03-28 08:00:00 | AAPL | Stock | 157.4904 | 158.13 | 157.4 | 157.66 | 42460.0 |
| 2023-03-28 08:05:00 | AAPL | Stock | 157.6441 | 157.7 | 157.64 | 157.66 | 4005.0 |
| 2023-03-28 08:10:00 | AAPL | Stock | 157.67 | 157.8 | 157.67 | 157.8 | 2322.0 |
| 2023-03-28 08:15:00 | AAPL | Stock | 157.8 | 157.8 | 157.74 | 157.74 | 2458.0 |
| 2023-03-28 08:20:00 | AAPL | Stock | 157.75 | 157.77 | 157.55 | 157.68 | 10286.0 |
| 2023-03-28 08:25:00 | AAPL | Stock | 157.62 | 157.7 | 157.61 | 157.697 | 3889.0 |
| 2023-03-28 08:30:00 | AAPL | Stock | 157.76 | 157.76 | 157.5301 | 157.59 | 8179.0 |
| 2023-03-28 08:35:00 | AAPL | Stock | 157.6 | 157.6 | 157.5 | 157.6 | 6068.0 |
| 2023-03-28 08:40:00 | AAPL | Stock | 157.6 | 157.6 | 157.42 | 157.44 | 12245.0 |
| 2023-03-28 08:45:00 | AAPL | Stock | 157.48 | 157.48 | 157.45 | 157.48 | 3766.0 |
| 2023-03-28 08:50:00 | AAPL | Stock | 157.4288 | 157.46 | 157.4288 | 157.45 | 5004.0 |
> showing 50 of 399,779 rows — these rows as CSV