PREVIEW / stock_30min / 2024-04-16
file: by_date/stock_30min/2024/2024-04-16.parquet size: 2.0 MB rows: 98,655 symbols: 999
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-04-16 04:00:00 | AAPL | Stock | 172.4 | 172.61 | 172.21 | 172.4 | 6074.0 |
| 2024-04-16 04:30:00 | AAPL | Stock | 172.37 | 172.47 | 172.3 | 172.31 | 5237.0 |
| 2024-04-16 05:00:00 | AAPL | Stock | 172.24 | 172.25 | 172.12 | 172.24 | 2178.0 |
| 2024-04-16 05:30:00 | AAPL | Stock | 172.15 | 172.18 | 171.57 | 171.76 | 14122.0 |
| 2024-04-16 06:00:00 | AAPL | Stock | 171.76 | 171.87 | 171.64 | 171.84 | 10471.0 |
| 2024-04-16 06:30:00 | AAPL | Stock | 171.83 | 172.2 | 171.83 | 172.12 | 11357.0 |
| 2024-04-16 07:00:00 | AAPL | Stock | 172.14 | 172.58 | 172.14 | 172.27 | 13020.0 |
| 2024-04-16 07:30:00 | AAPL | Stock | 172.49 | 172.7 | 172.48 | 172.55 | 9128.0 |
| 2024-04-16 08:00:00 | AAPL | Stock | 172.2393 | 172.69 | 171.9667 | 172.33 | 60434.0 |
| 2024-04-16 08:30:00 | AAPL | Stock | 172.43 | 173.0 | 172.3962 | 172.82 | 31545.0 |
| 2024-04-16 09:00:00 | AAPL | Stock | 172.75 | 172.75 | 171.33 | 171.75 | 180307.0 |
| 2024-04-16 09:30:00 | AAPL | Stock | 171.75 | 173.7599 | 171.46 | 172.82 | 7471124.0 |
| 2024-04-16 10:00:00 | AAPL | Stock | 172.83 | 172.975 | 171.182 | 171.21 | 4252423.0 |
| 2024-04-16 10:30:00 | AAPL | Stock | 171.2 | 171.45 | 169.12 | 169.1452 | 6286712.0 |
| 2024-04-16 11:00:00 | AAPL | Stock | 169.14 | 169.67 | 169.02 | 169.445 | 4736820.0 |
| 2024-04-16 11:30:00 | AAPL | Stock | 169.45 | 169.45 | 168.405 | 169.035 | 4889906.0 |
| 2024-04-16 12:00:00 | AAPL | Stock | 169.03 | 169.85 | 168.27 | 169.415 | 4239539.0 |
| 2024-04-16 12:30:00 | AAPL | Stock | 169.41 | 169.5815 | 168.93 | 169.06 | 2165107.0 |
| 2024-04-16 13:00:00 | AAPL | Stock | 169.07 | 169.73 | 168.99 | 169.39 | 1950929.0 |
| 2024-04-16 13:30:00 | AAPL | Stock | 169.4 | 169.5 | 168.4 | 169.445 | 3333531.0 |
| 2024-04-16 14:00:00 | AAPL | Stock | 169.45 | 170.4 | 168.825 | 168.925 | 3506819.0 |
| 2024-04-16 14:30:00 | AAPL | Stock | 168.925 | 170.08 | 168.88 | 170.07 | 2097767.0 |
| 2024-04-16 15:00:00 | AAPL | Stock | 170.08 | 170.09 | 169.63 | 169.995 | 2204524.0 |
| 2024-04-16 15:30:00 | AAPL | Stock | 169.99 | 170.02 | 169.28 | 169.34 | 4797732.0 |
| 2024-04-16 16:00:00 | AAPL | Stock | 169.38 | 169.55 | 169.22 | 169.44 | 6774217.0 |
| 2024-04-16 16:30:00 | AAPL | Stock | 169.45 | 169.5401 | 169.38 | 169.5 | 137760.0 |
| 2024-04-16 17:00:00 | AAPL | Stock | 169.45 | 169.6885 | 169.38 | 169.6885 | 26012.0 |
| 2024-04-16 17:30:00 | AAPL | Stock | 169.6754 | 169.6781 | 169.45 | 169.49 | 16090.0 |
| 2024-04-16 18:00:00 | AAPL | Stock | 169.5 | 169.6001 | 169.4729 | 169.5 | 26076.0 |
| 2024-04-16 18:30:00 | AAPL | Stock | 169.55 | 169.68 | 169.5412 | 169.62 | 5132.0 |
| 2024-04-16 19:00:00 | AAPL | Stock | 169.63 | 169.69 | 169.61 | 169.69 | 11061.0 |
| 2024-04-16 19:30:00 | AAPL | Stock | 169.65 | 169.85 | 169.61 | 169.8 | 23611.0 |
| 2024-04-16 04:00:00 | MSFT | Stock | 413.57 | 413.78 | 413.52 | 413.7 | 2303.0 |
| 2024-04-16 04:30:00 | MSFT | Stock | 414.28 | 414.47 | 414.27 | 414.47 | 2355.0 |
| 2024-04-16 05:00:00 | MSFT | Stock | 414.78 | 414.79 | 414.65 | 414.65 | 427.0 |
| 2024-04-16 05:30:00 | MSFT | Stock | 414.58 | 414.58 | 414.01 | 414.01 | 1813.0 |
| 2024-04-16 06:00:00 | MSFT | Stock | 413.97 | 413.97 | 412.35 | 412.35 | 1386.0 |
| 2024-04-16 06:30:00 | MSFT | Stock | 412.22 | 413.48 | 412.22 | 413.48 | 1486.0 |
| 2024-04-16 07:00:00 | MSFT | Stock | 413.38 | 414.8 | 413.38 | 414.74 | 5031.0 |
| 2024-04-16 07:30:00 | MSFT | Stock | 414.8 | 415.57 | 414.8 | 415.41 | 3492.0 |
| 2024-04-16 08:00:00 | MSFT | Stock | 414.31 | 415.6969 | 411.72 | 414.496 | 26655.0 |
| 2024-04-16 08:30:00 | MSFT | Stock | 414.5 | 415.21 | 414.5 | 414.88 | 6480.0 |
| 2024-04-16 09:00:00 | MSFT | Stock | 414.8 | 414.95 | 413.66 | 414.68 | 25687.0 |
| 2024-04-16 09:30:00 | MSFT | Stock | 414.57 | 416.65 | 413.7301 | 416.36 | 1452159.0 |
| 2024-04-16 10:00:00 | MSFT | Stock | 416.36 | 417.6443 | 415.51 | 415.52 | 828008.0 |
| 2024-04-16 10:30:00 | MSFT | Stock | 415.4 | 416.52 | 415.0 | 415.79 | 532000.0 |
| 2024-04-16 11:00:00 | MSFT | Stock | 415.79 | 417.075 | 415.68 | 416.73 | 499033.0 |
| 2024-04-16 11:30:00 | MSFT | Stock | 416.7 | 417.2799 | 415.95 | 415.99 | 378257.0 |
| 2024-04-16 12:00:00 | MSFT | Stock | 416.0 | 416.79 | 415.48 | 416.06 | 343407.0 |
| 2024-04-16 12:30:00 | MSFT | Stock | 416.025 | 416.57 | 415.58 | 416.16 | 286978.0 |
> showing 50 of 98,655 rows — these rows as CSV