PREVIEW / stock_30min / 2024-02-15
file: by_date/stock_30min/2024/2024-02-15.parquet size: 2.1 MB rows: 101,805 symbols: 1,127
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-02-15 04:00:00 | AAPL | Stock | 182.7 | 183.18 | 182.6 | 182.74 | 12635.0 |
| 2024-02-15 04:30:00 | AAPL | Stock | 182.69 | 182.92 | 182.69 | 182.88 | 8161.0 |
| 2024-02-15 05:00:00 | AAPL | Stock | 182.82 | 182.82 | 182.33 | 182.45 | 4159.0 |
| 2024-02-15 05:30:00 | AAPL | Stock | 182.48 | 182.74 | 182.3 | 182.74 | 5687.0 |
| 2024-02-15 06:00:00 | AAPL | Stock | 182.68 | 183.0 | 182.64 | 182.75 | 4512.0 |
| 2024-02-15 06:30:00 | AAPL | Stock | 182.66 | 182.66 | 182.31 | 182.6 | 7001.0 |
| 2024-02-15 07:00:00 | AAPL | Stock | 182.55 | 182.97 | 182.55 | 182.95 | 16780.0 |
| 2024-02-15 07:30:00 | AAPL | Stock | 182.95 | 183.15 | 182.82 | 183.1 | 19996.0 |
| 2024-02-15 08:00:00 | AAPL | Stock | 182.55 | 183.65 | 182.55 | 183.34 | 144003.0 |
| 2024-02-15 08:30:00 | AAPL | Stock | 183.32 | 183.8 | 182.8 | 183.06 | 114146.0 |
| 2024-02-15 09:00:00 | AAPL | Stock | 183.04 | 183.6 | 182.88 | 183.48 | 131937.0 |
| 2024-02-15 09:30:00 | AAPL | Stock | 183.5 | 184.0894 | 181.91 | 182.08 | 6310933.0 |
| 2024-02-15 10:00:00 | AAPL | Stock | 182.08 | 182.67 | 181.35 | 181.88 | 4435208.0 |
| 2024-02-15 10:30:00 | AAPL | Stock | 181.9 | 182.12 | 181.44 | 182.035 | 3373568.0 |
| 2024-02-15 11:00:00 | AAPL | Stock | 182.035 | 182.04 | 181.55 | 181.99 | 2276213.0 |
| 2024-02-15 11:30:00 | AAPL | Stock | 182.0 | 182.16 | 181.56 | 181.74 | 1934474.0 |
| 2024-02-15 12:00:00 | AAPL | Stock | 181.7324 | 182.2499 | 181.64 | 182.025 | 1598652.0 |
| 2024-02-15 12:30:00 | AAPL | Stock | 182.03 | 182.04 | 181.71 | 181.79 | 1800277.0 |
| 2024-02-15 13:00:00 | AAPL | Stock | 181.79 | 182.195 | 181.665 | 182.05 | 1826160.0 |
| 2024-02-15 13:30:00 | AAPL | Stock | 182.0459 | 182.46 | 182.04 | 182.12 | 1944332.0 |
| 2024-02-15 14:00:00 | AAPL | Stock | 182.12 | 182.1996 | 181.86 | 181.9789 | 1850404.0 |
| 2024-02-15 14:30:00 | AAPL | Stock | 181.97 | 182.365 | 181.74 | 182.3509 | 2093873.0 |
| 2024-02-15 15:00:00 | AAPL | Stock | 182.3572 | 182.65 | 182.1 | 182.3801 | 2421238.0 |
| 2024-02-15 15:30:00 | AAPL | Stock | 182.3869 | 184.49 | 182.21 | 183.95 | 10143592.0 |
| 2024-02-15 16:00:00 | AAPL | Stock | 183.94 | 185.94 | 183.76 | 185.27 | 6732651.0 |
| 2024-02-15 16:30:00 | AAPL | Stock | 185.23 | 185.6 | 183.86 | 185.21 | 215877.0 |
| 2024-02-15 17:00:00 | AAPL | Stock | 185.21 | 185.38 | 184.46 | 184.5 | 164404.0 |
| 2024-02-15 17:30:00 | AAPL | Stock | 184.5 | 184.61 | 184.3 | 184.34 | 66903.0 |
| 2024-02-15 18:00:00 | AAPL | Stock | 184.34 | 184.45 | 184.22 | 184.25 | 32390.0 |
| 2024-02-15 18:30:00 | AAPL | Stock | 184.3399 | 184.72 | 184.2518 | 184.58 | 39271.0 |
| 2024-02-15 19:00:00 | AAPL | Stock | 184.62 | 184.7 | 184.52 | 184.52 | 19807.0 |
| 2024-02-15 19:30:00 | AAPL | Stock | 184.5 | 184.88 | 184.4 | 184.63 | 30973.0 |
| 2024-02-15 04:00:00 | MSFT | Stock | 410.46 | 410.99 | 410.21 | 410.98 | 2006.0 |
| 2024-02-15 04:30:00 | MSFT | Stock | 410.99 | 411.09 | 410.74 | 411.08 | 1315.0 |
| 2024-02-15 05:00:00 | MSFT | Stock | 411.09 | 411.13 | 411.0 | 411.0 | 789.0 |
| 2024-02-15 05:30:00 | MSFT | Stock | 410.93 | 410.95 | 410.85 | 410.85 | 761.0 |
| 2024-02-15 06:00:00 | MSFT | Stock | 410.85 | 411.24 | 410.85 | 411.24 | 678.0 |
| 2024-02-15 06:30:00 | MSFT | Stock | 411.18 | 411.33 | 411.18 | 411.33 | 1880.0 |
| 2024-02-15 07:00:00 | MSFT | Stock | 411.33 | 411.33 | 410.62 | 410.9 | 5634.0 |
| 2024-02-15 07:30:00 | MSFT | Stock | 410.8 | 411.05 | 410.8 | 410.98 | 2557.0 |
| 2024-02-15 08:00:00 | MSFT | Stock | 411.3 | 411.52 | 409.83 | 410.7 | 17669.0 |
| 2024-02-15 08:30:00 | MSFT | Stock | 410.82 | 411.45 | 410.19 | 410.4 | 18399.0 |
| 2024-02-15 09:00:00 | MSFT | Stock | 410.34 | 410.82 | 407.51 | 408.14 | 41776.0 |
| 2024-02-15 09:30:00 | MSFT | Stock | 408.14 | 409.13 | 405.5 | 405.73 | 2268578.0 |
| 2024-02-15 10:00:00 | MSFT | Stock | 405.75 | 406.325 | 404.7 | 404.8298 | 1320423.0 |
| 2024-02-15 10:30:00 | MSFT | Stock | 404.87 | 406.355 | 404.83 | 406.04 | 906437.0 |
| 2024-02-15 11:00:00 | MSFT | Stock | 406.08 | 406.16 | 404.29 | 404.96 | 936758.0 |
| 2024-02-15 11:30:00 | MSFT | Stock | 404.98 | 405.14 | 404.32 | 404.65 | 800760.0 |
| 2024-02-15 12:00:00 | MSFT | Stock | 404.65 | 405.84 | 404.429 | 405.81 | 545207.0 |
| 2024-02-15 12:30:00 | MSFT | Stock | 405.83 | 405.95 | 405.34 | 405.37 | 463781.0 |
> showing 50 of 101,805 rows — these rows as CSV