PREVIEW / stock_5min / 2022-04-28
file: by_date/stock_5min/2022/2022-04-28.parquet size: 7.4 MB rows: 456,223 symbols: 2,498
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-28 04:00:00 | AAPL | Stock | 159.31 | 160.43 | 159.12 | 160.43 | 29146.0 |
| 2022-04-28 04:05:00 | AAPL | Stock | 160.42 | 160.87 | 160.42 | 160.58 | 15410.0 |
| 2022-04-28 04:10:00 | AAPL | Stock | 160.49 | 160.73 | 160.3 | 160.73 | 5489.0 |
| 2022-04-28 04:15:00 | AAPL | Stock | 160.77 | 160.81 | 160.64 | 160.68 | 3477.0 |
| 2022-04-28 04:20:00 | AAPL | Stock | 160.6 | 160.67 | 160.5 | 160.67 | 8202.0 |
| 2022-04-28 04:25:00 | AAPL | Stock | 160.65 | 160.67 | 160.5 | 160.5 | 20516.0 |
| 2022-04-28 04:30:00 | AAPL | Stock | 160.5 | 160.5 | 160.33 | 160.43 | 2483.0 |
| 2022-04-28 04:35:00 | AAPL | Stock | 160.44 | 160.53 | 160.38 | 160.53 | 779.0 |
| 2022-04-28 04:40:00 | AAPL | Stock | 160.38 | 160.7 | 160.38 | 160.7 | 1267.0 |
| 2022-04-28 04:45:00 | AAPL | Stock | 160.55 | 160.68 | 160.55 | 160.68 | 500.0 |
| 2022-04-28 04:50:00 | AAPL | Stock | 160.55 | 160.58 | 160.5 | 160.53 | 765.0 |
| 2022-04-28 04:55:00 | AAPL | Stock | 160.52 | 160.8 | 160.47 | 160.8 | 1619.0 |
| 2022-04-28 05:00:00 | AAPL | Stock | 160.8 | 160.89 | 160.75 | 160.81 | 1212.0 |
| 2022-04-28 05:05:00 | AAPL | Stock | 160.8 | 160.8 | 160.51 | 160.51 | 930.0 |
| 2022-04-28 05:10:00 | AAPL | Stock | 160.39 | 160.51 | 160.35 | 160.42 | 822.0 |
| 2022-04-28 05:15:00 | AAPL | Stock | 160.34 | 160.54 | 160.34 | 160.54 | 2515.0 |
| 2022-04-28 05:20:00 | AAPL | Stock | 160.47 | 160.52 | 160.4 | 160.43 | 1234.0 |
| 2022-04-28 05:25:00 | AAPL | Stock | 160.37 | 160.37 | 160.1 | 160.13 | 2118.0 |
| 2022-04-28 05:30:00 | AAPL | Stock | 160.17 | 160.19 | 160.08 | 160.19 | 1826.0 |
| 2022-04-28 05:35:00 | AAPL | Stock | 160.3 | 160.3 | 160.16 | 160.16 | 1412.0 |
| 2022-04-28 05:40:00 | AAPL | Stock | 160.29 | 160.29 | 160.1 | 160.1 | 726.0 |
| 2022-04-28 05:45:00 | AAPL | Stock | 160.01 | 160.15 | 160.01 | 160.15 | 1998.0 |
| 2022-04-28 05:50:00 | AAPL | Stock | 160.12 | 160.15 | 160.0 | 160.03 | 4740.0 |
| 2022-04-28 05:55:00 | AAPL | Stock | 160.1 | 160.11 | 159.95 | 160.05 | 4265.0 |
| 2022-04-28 06:00:00 | AAPL | Stock | 160.05 | 160.25 | 160.03 | 160.25 | 5362.0 |
| 2022-04-28 06:05:00 | AAPL | Stock | 160.25 | 160.25 | 160.25 | 160.25 | 100.0 |
| 2022-04-28 06:10:00 | AAPL | Stock | 160.25 | 160.37 | 160.25 | 160.37 | 1455.0 |
| 2022-04-28 06:15:00 | AAPL | Stock | 160.37 | 160.5 | 159.72 | 159.76 | 12778.0 |
| 2022-04-28 06:20:00 | AAPL | Stock | 159.75 | 159.9 | 159.75 | 159.9 | 499.0 |
| 2022-04-28 06:25:00 | AAPL | Stock | 159.9 | 160.01 | 159.9 | 160.01 | 699.0 |
| 2022-04-28 06:30:00 | AAPL | Stock | 160.05 | 160.08 | 160.05 | 160.08 | 369.0 |
| 2022-04-28 06:35:00 | AAPL | Stock | 160.09 | 160.19 | 160.0 | 160.19 | 6408.0 |
| 2022-04-28 06:40:00 | AAPL | Stock | 160.04 | 160.28 | 160.04 | 160.28 | 1001.0 |
| 2022-04-28 06:45:00 | AAPL | Stock | 160.1 | 160.13 | 159.99 | 159.99 | 2264.0 |
| 2022-04-28 06:50:00 | AAPL | Stock | 160.0 | 160.0 | 159.95 | 159.95 | 678.0 |
| 2022-04-28 06:55:00 | AAPL | Stock | 159.96 | 159.96 | 159.96 | 159.96 | 413.0 |
| 2022-04-28 07:00:00 | AAPL | Stock | 160.12 | 160.53 | 160.0 | 160.51 | 16414.0 |
| 2022-04-28 07:05:00 | AAPL | Stock | 160.59 | 160.86 | 160.53 | 160.79 | 20649.0 |
| 2022-04-28 07:10:00 | AAPL | Stock | 160.8 | 160.9 | 160.52 | 160.52 | 28683.0 |
| 2022-04-28 07:15:00 | AAPL | Stock | 160.52 | 160.76 | 160.47 | 160.71 | 19451.0 |
| 2022-04-28 07:20:00 | AAPL | Stock | 160.69 | 160.7 | 160.47 | 160.6 | 6856.0 |
| 2022-04-28 07:25:00 | AAPL | Stock | 160.58 | 160.58 | 160.48 | 160.5 | 11280.0 |
| 2022-04-28 07:30:00 | AAPL | Stock | 160.54 | 160.54 | 160.3 | 160.31 | 7418.0 |
| 2022-04-28 07:35:00 | AAPL | Stock | 160.3 | 160.4 | 160.0 | 160.2 | 13318.0 |
| 2022-04-28 07:40:00 | AAPL | Stock | 160.2 | 160.36 | 160.1 | 160.36 | 8806.0 |
| 2022-04-28 07:45:00 | AAPL | Stock | 160.35 | 160.49 | 160.33 | 160.36 | 4955.0 |
| 2022-04-28 07:50:00 | AAPL | Stock | 160.36 | 160.41 | 160.1 | 160.1 | 10004.0 |
| 2022-04-28 07:55:00 | AAPL | Stock | 160.1 | 160.23 | 160.07 | 160.2 | 13260.0 |
| 2022-04-28 08:00:00 | AAPL | Stock | 160.1999 | 160.9 | 159.31 | 159.9 | 375347.0 |
| 2022-04-28 08:05:00 | AAPL | Stock | 159.92 | 159.92 | 159.7 | 159.86 | 73000.0 |
> showing 50 of 456,223 rows — these rows as CSV