PREVIEW / stock_30min / 2024-03-12
file: by_date/stock_30min/2024/2024-03-12.parquet size: 2.1 MB rows: 100,719 symbols: 1,104
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-12 04:00:00 | AAPL | Stock | 173.5 | 173.86 | 173.41 | 173.41 | 5859.0 |
| 2024-03-12 04:30:00 | AAPL | Stock | 173.37 | 173.46 | 173.29 | 173.3 | 5410.0 |
| 2024-03-12 05:00:00 | AAPL | Stock | 173.3 | 173.33 | 172.91 | 173.07 | 14871.0 |
| 2024-03-12 05:30:00 | AAPL | Stock | 173.24 | 173.49 | 173.19 | 173.36 | 4786.0 |
| 2024-03-12 06:00:00 | AAPL | Stock | 173.3 | 173.48 | 173.3 | 173.47 | 3578.0 |
| 2024-03-12 06:30:00 | AAPL | Stock | 173.45 | 173.5 | 173.35 | 173.49 | 6498.0 |
| 2024-03-12 07:00:00 | AAPL | Stock | 173.5 | 173.57 | 173.3 | 173.47 | 23764.0 |
| 2024-03-12 07:30:00 | AAPL | Stock | 173.45 | 173.45 | 173.36 | 173.37 | 3241.0 |
| 2024-03-12 08:00:00 | AAPL | Stock | 173.43 | 173.95 | 173.17 | 173.47 | 78466.0 |
| 2024-03-12 08:30:00 | AAPL | Stock | 173.33 | 174.32 | 172.75 | 173.25 | 213621.0 |
| 2024-03-12 09:00:00 | AAPL | Stock | 173.37 | 173.4899 | 172.65 | 173.1995 | 194829.0 |
| 2024-03-12 09:30:00 | AAPL | Stock | 173.19 | 173.47 | 171.01 | 171.455 | 6406109.0 |
| 2024-03-12 10:00:00 | AAPL | Stock | 171.48 | 172.705 | 171.45 | 172.635 | 4245137.0 |
| 2024-03-12 10:30:00 | AAPL | Stock | 172.64 | 172.9 | 172.48 | 172.61 | 2819573.0 |
| 2024-03-12 11:00:00 | AAPL | Stock | 172.62 | 172.91 | 172.3201 | 172.675 | 2478998.0 |
| 2024-03-12 11:30:00 | AAPL | Stock | 172.67 | 172.89 | 172.44 | 172.585 | 1891296.0 |
| 2024-03-12 12:00:00 | AAPL | Stock | 172.5854 | 173.1 | 172.215 | 172.52 | 2829185.0 |
| 2024-03-12 12:30:00 | AAPL | Stock | 172.53 | 172.605 | 171.94 | 172.5274 | 2571673.0 |
| 2024-03-12 13:00:00 | AAPL | Stock | 172.5236 | 173.26 | 172.38 | 173.04 | 2213223.0 |
| 2024-03-12 13:30:00 | AAPL | Stock | 173.045 | 173.49 | 173.01 | 173.2637 | 2128628.0 |
| 2024-03-12 14:00:00 | AAPL | Stock | 173.27 | 173.84 | 173.19 | 173.7999 | 2123313.0 |
| 2024-03-12 14:30:00 | AAPL | Stock | 173.795 | 173.97 | 173.35 | 173.7344 | 1934680.0 |
| 2024-03-12 15:00:00 | AAPL | Stock | 173.73 | 174.01 | 173.53 | 173.845 | 2258710.0 |
| 2024-03-12 15:30:00 | AAPL | Stock | 173.855 | 174.03 | 173.15 | 173.22 | 4905316.0 |
| 2024-03-12 16:00:00 | AAPL | Stock | 173.22 | 173.26 | 172.85 | 173.13 | 7133923.0 |
| 2024-03-12 16:30:00 | AAPL | Stock | 173.15 | 173.23 | 173.09 | 173.09 | 33240.0 |
| 2024-03-12 17:00:00 | AAPL | Stock | 173.09 | 173.23 | 173.05 | 173.1 | 24927.0 |
| 2024-03-12 17:30:00 | AAPL | Stock | 173.1 | 173.149 | 173.05 | 173.0799 | 11919.0 |
| 2024-03-12 18:00:00 | AAPL | Stock | 173.06 | 173.08 | 172.85 | 172.89 | 22695.0 |
| 2024-03-12 18:30:00 | AAPL | Stock | 172.92 | 173.1 | 172.9 | 173.0118 | 20240.0 |
| 2024-03-12 19:00:00 | AAPL | Stock | 173.01 | 173.17 | 172.99 | 173.17 | 6551.0 |
| 2024-03-12 19:30:00 | AAPL | Stock | 173.18 | 173.18 | 172.92 | 173.0 | 24052.0 |
| 2024-03-12 04:00:00 | MSFT | Stock | 406.55 | 406.55 | 406.5 | 406.5 | 2108.0 |
| 2024-03-12 04:30:00 | MSFT | Stock | 406.15 | 406.22 | 406.15 | 406.22 | 325.0 |
| 2024-03-12 05:30:00 | MSFT | Stock | 406.61 | 406.61 | 406.61 | 406.61 | 100.0 |
| 2024-03-12 06:00:00 | MSFT | Stock | 406.39 | 406.39 | 406.3 | 406.3 | 522.0 |
| 2024-03-12 07:00:00 | MSFT | Stock | 406.6 | 406.75 | 406.6 | 406.75 | 3243.0 |
| 2024-03-12 07:30:00 | MSFT | Stock | 406.64 | 406.7 | 406.54 | 406.7 | 907.0 |
| 2024-03-12 08:00:00 | MSFT | Stock | 406.6 | 406.8 | 405.89 | 406.3 | 12959.0 |
| 2024-03-12 08:30:00 | MSFT | Stock | 406.0 | 407.7563 | 404.4 | 407.15 | 44248.0 |
| 2024-03-12 09:00:00 | MSFT | Stock | 407.15 | 407.67 | 405.5 | 407.67 | 26942.0 |
| 2024-03-12 09:30:00 | MSFT | Stock | 407.62 | 409.677 | 406.79 | 409.61 | 1493012.0 |
| 2024-03-12 10:00:00 | MSFT | Stock | 409.625 | 413.43 | 409.51 | 413.2 | 1212239.0 |
| 2024-03-12 10:30:00 | MSFT | Stock | 413.22 | 414.45 | 412.94 | 413.3 | 1061858.0 |
| 2024-03-12 11:00:00 | MSFT | Stock | 413.3 | 413.76 | 412.62 | 413.6 | 604741.0 |
| 2024-03-12 11:30:00 | MSFT | Stock | 413.63 | 414.21 | 413.11 | 413.22 | 670783.0 |
| 2024-03-12 12:00:00 | MSFT | Stock | 413.225 | 413.7 | 412.56 | 413.24 | 697871.0 |
| 2024-03-12 12:30:00 | MSFT | Stock | 413.25 | 413.44 | 411.8 | 412.4923 | 616247.0 |
| 2024-03-12 13:00:00 | MSFT | Stock | 412.4604 | 414.02 | 411.6 | 413.6316 | 739332.0 |
| 2024-03-12 13:30:00 | MSFT | Stock | 413.61 | 414.89 | 413.59 | 414.1 | 698453.0 |
> showing 50 of 100,719 rows — these rows as CSV