PREVIEW / stock_30min / 2024-03-01
file: by_date/stock_30min/2024/2024-03-01.parquet size: 2.1 MB rows: 102,514 symbols: 1,121
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-01 04:00:00 | AAPL | Stock | 180.6 | 181.21 | 180.6 | 180.64 | 8243.0 |
| 2024-03-01 04:30:00 | AAPL | Stock | 180.69 | 180.88 | 180.69 | 180.84 | 1598.0 |
| 2024-03-01 05:00:00 | AAPL | Stock | 180.78 | 180.78 | 178.66 | 179.03 | 117629.0 |
| 2024-03-01 05:30:00 | AAPL | Stock | 179.08 | 179.38 | 178.86 | 178.86 | 21520.0 |
| 2024-03-01 06:00:00 | AAPL | Stock | 178.85 | 179.05 | 178.71 | 178.93 | 41822.0 |
| 2024-03-01 06:30:00 | AAPL | Stock | 178.93 | 179.45 | 178.93 | 179.12 | 35299.0 |
| 2024-03-01 07:00:00 | AAPL | Stock | 179.2 | 179.93 | 179.2 | 179.84 | 108207.0 |
| 2024-03-01 07:30:00 | AAPL | Stock | 179.85 | 180.12 | 179.55 | 180.06 | 50170.0 |
| 2024-03-01 08:00:00 | AAPL | Stock | 179.37 | 181.3 | 179.3 | 179.7 | 163445.0 |
| 2024-03-01 08:30:00 | AAPL | Stock | 179.7204 | 179.84 | 179.51 | 179.6 | 73561.0 |
| 2024-03-01 09:00:00 | AAPL | Stock | 179.6 | 179.65 | 179.17 | 179.54 | 166704.0 |
| 2024-03-01 09:30:00 | AAPL | Stock | 179.57 | 180.53 | 179.06 | 179.245 | 7663209.0 |
| 2024-03-01 10:00:00 | AAPL | Stock | 179.24 | 180.4 | 178.296 | 178.3085 | 5776537.0 |
| 2024-03-01 10:30:00 | AAPL | Stock | 178.31 | 178.47 | 177.67 | 178.295 | 6040310.0 |
| 2024-03-01 11:00:00 | AAPL | Stock | 178.295 | 178.47 | 177.93 | 178.23 | 3597141.0 |
| 2024-03-01 11:30:00 | AAPL | Stock | 178.23 | 178.25 | 177.72 | 177.935 | 3188676.0 |
| 2024-03-01 12:00:00 | AAPL | Stock | 177.935 | 178.07 | 177.38 | 178.04 | 3649014.0 |
| 2024-03-01 12:30:00 | AAPL | Stock | 178.0422 | 178.66 | 177.95 | 178.524 | 3050534.0 |
| 2024-03-01 13:00:00 | AAPL | Stock | 178.53 | 178.8 | 178.33 | 178.7001 | 2772608.0 |
| 2024-03-01 13:30:00 | AAPL | Stock | 178.705 | 179.39 | 178.56 | 179.32 | 2966295.0 |
| 2024-03-01 14:00:00 | AAPL | Stock | 179.315 | 180.22 | 179.3 | 180.2 | 3638431.0 |
| 2024-03-01 14:30:00 | AAPL | Stock | 180.2 | 180.205 | 179.75 | 180.005 | 2544700.0 |
| 2024-03-01 15:00:00 | AAPL | Stock | 180.005 | 180.01 | 179.55 | 179.68 | 2783655.0 |
| 2024-03-01 15:30:00 | AAPL | Stock | 179.68 | 179.8 | 179.415 | 179.63 | 4886232.0 |
| 2024-03-01 16:00:00 | AAPL | Stock | 179.64 | 179.66 | 179.32 | 179.32 | 5858052.0 |
| 2024-03-01 16:30:00 | AAPL | Stock | 179.335 | 179.66 | 179.02 | 179.03 | 89514.0 |
| 2024-03-01 17:00:00 | AAPL | Stock | 179.04 | 179.1 | 179.04 | 179.0899 | 18737.0 |
| 2024-03-01 17:30:00 | AAPL | Stock | 179.06 | 179.07 | 179.04 | 179.06 | 20950.0 |
| 2024-03-01 18:00:00 | AAPL | Stock | 179.06 | 179.15 | 179.06 | 179.14 | 13209.0 |
| 2024-03-01 18:30:00 | AAPL | Stock | 179.1101 | 179.13 | 179.0307 | 179.0307 | 15571.0 |
| 2024-03-01 19:00:00 | AAPL | Stock | 179.02 | 179.04 | 179.0 | 179.0 | 8082.0 |
| 2024-03-01 19:30:00 | AAPL | Stock | 178.99 | 179.12 | 178.95 | 179.0 | 19591.0 |
| 2024-03-01 04:00:00 | MSFT | Stock | 413.65 | 414.14 | 413.65 | 414.14 | 1560.0 |
| 2024-03-01 04:30:00 | MSFT | Stock | 414.24 | 414.24 | 414.0 | 414.0 | 580.0 |
| 2024-03-01 05:00:00 | MSFT | Stock | 413.85 | 413.91 | 411.83 | 411.84 | 6744.0 |
| 2024-03-01 05:30:00 | MSFT | Stock | 412.21 | 412.6 | 411.99 | 412.21 | 1700.0 |
| 2024-03-01 06:00:00 | MSFT | Stock | 412.45 | 412.71 | 412.45 | 412.71 | 1100.0 |
| 2024-03-01 06:30:00 | MSFT | Stock | 412.79 | 412.8 | 412.03 | 412.73 | 2970.0 |
| 2024-03-01 07:00:00 | MSFT | Stock | 412.68 | 413.19 | 412.0 | 412.4 | 7531.0 |
| 2024-03-01 07:30:00 | MSFT | Stock | 412.45 | 412.86 | 412.26 | 412.5 | 5525.0 |
| 2024-03-01 08:00:00 | MSFT | Stock | 412.98 | 414.64 | 412.34 | 413.0 | 29829.0 |
| 2024-03-01 08:30:00 | MSFT | Stock | 413.1 | 413.31 | 412.52 | 412.76 | 7259.0 |
| 2024-03-01 09:00:00 | MSFT | Stock | 412.92 | 412.92 | 410.91 | 411.2 | 31080.0 |
| 2024-03-01 09:30:00 | MSFT | Stock | 411.21 | 414.9682 | 410.88 | 412.315 | 1886745.0 |
| 2024-03-01 10:00:00 | MSFT | Stock | 412.3 | 413.2 | 411.95 | 412.6 | 778237.0 |
| 2024-03-01 10:30:00 | MSFT | Stock | 412.61 | 412.74 | 411.6 | 412.215 | 828242.0 |
| 2024-03-01 11:00:00 | MSFT | Stock | 412.23 | 413.5 | 412.01 | 413.11 | 682961.0 |
| 2024-03-01 11:30:00 | MSFT | Stock | 413.13 | 413.22 | 411.93 | 412.72 | 454239.0 |
| 2024-03-01 12:00:00 | MSFT | Stock | 412.75 | 413.685 | 412.45 | 413.53 | 363433.0 |
| 2024-03-01 12:30:00 | MSFT | Stock | 413.54 | 414.15 | 413.165 | 414.09 | 405845.0 |
> showing 50 of 102,514 rows — these rows as CSV