PREVIEW / stock_30min / 2024-04-10
file: by_date/stock_30min/2024/2024-04-10.parquet size: 2.0 MB rows: 100,300 symbols: 1,012
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-10 04:00:00 | AAPL | Stock | 169.86 | 169.92 | 169.81 | 169.85 | 5192.0 |
| 2024-04-10 04:30:00 | AAPL | Stock | 169.94 | 170.03 | 169.86 | 170.03 | 3024.0 |
| 2024-04-10 05:00:00 | AAPL | Stock | 170.0 | 170.0 | 169.83 | 169.95 | 3333.0 |
| 2024-04-10 05:30:00 | AAPL | Stock | 169.95 | 169.99 | 169.9 | 169.95 | 14554.0 |
| 2024-04-10 06:00:00 | AAPL | Stock | 169.95 | 170.2 | 169.95 | 170.07 | 11910.0 |
| 2024-04-10 06:30:00 | AAPL | Stock | 170.05 | 170.35 | 170.05 | 170.3 | 10001.0 |
| 2024-04-10 07:00:00 | AAPL | Stock | 170.28 | 170.38 | 170.1 | 170.36 | 12410.0 |
| 2024-04-10 07:30:00 | AAPL | Stock | 170.34 | 170.4 | 170.29 | 170.38 | 9711.0 |
| 2024-04-10 08:00:00 | AAPL | Stock | 170.18 | 170.91 | 169.77 | 170.9 | 97698.0 |
| 2024-04-10 08:30:00 | AAPL | Stock | 170.58 | 170.7038 | 168.6 | 168.72 | 261457.0 |
| 2024-04-10 09:00:00 | AAPL | Stock | 168.7999 | 169.25 | 168.53 | 168.7886 | 142769.0 |
| 2024-04-10 09:30:00 | AAPL | Stock | 168.8 | 169.09 | 167.31 | 167.47 | 6819579.0 |
| 2024-04-10 10:00:00 | AAPL | Stock | 167.47 | 168.14 | 167.11 | 168.03 | 4050166.0 |
| 2024-04-10 10:30:00 | AAPL | Stock | 168.044 | 168.7 | 167.94 | 168.03 | 2657642.0 |
| 2024-04-10 11:00:00 | AAPL | Stock | 168.025 | 168.09 | 167.61 | 167.915 | 1703122.0 |
| 2024-04-10 11:30:00 | AAPL | Stock | 167.94 | 167.965 | 167.54 | 167.6401 | 1389009.0 |
| 2024-04-10 12:00:00 | AAPL | Stock | 167.645 | 168.11 | 167.585 | 168.015 | 1590558.0 |
| 2024-04-10 12:30:00 | AAPL | Stock | 168.02 | 168.44 | 167.99 | 168.4199 | 1278792.0 |
| 2024-04-10 13:00:00 | AAPL | Stock | 168.42 | 168.6 | 167.68 | 168.14 | 2305933.0 |
| 2024-04-10 13:30:00 | AAPL | Stock | 168.121 | 168.58 | 167.63 | 168.22 | 1994860.0 |
| 2024-04-10 14:00:00 | AAPL | Stock | 168.215 | 168.42 | 167.71 | 167.76 | 1684301.0 |
| 2024-04-10 14:30:00 | AAPL | Stock | 167.765 | 168.18 | 167.69 | 167.7299 | 1525782.0 |
| 2024-04-10 15:00:00 | AAPL | Stock | 167.73 | 168.5 | 167.69 | 168.26 | 1976620.0 |
| 2024-04-10 15:30:00 | AAPL | Stock | 168.26 | 168.685 | 167.7 | 167.75 | 4063745.0 |
| 2024-04-10 16:00:00 | AAPL | Stock | 167.76 | 167.98 | 167.72 | 167.92 | 6449453.0 |
| 2024-04-10 16:30:00 | AAPL | Stock | 167.91 | 168.02 | 167.9 | 168.02 | 54857.0 |
| 2024-04-10 17:00:00 | AAPL | Stock | 168.0 | 168.05 | 167.91 | 168.04 | 28355.0 |
| 2024-04-10 17:30:00 | AAPL | Stock | 168.0 | 168.01 | 167.9 | 167.99 | 15776.0 |
| 2024-04-10 18:00:00 | AAPL | Stock | 167.92 | 167.92 | 167.78 | 167.9 | 78073.0 |
| 2024-04-10 18:30:00 | AAPL | Stock | 167.9 | 167.9 | 167.81 | 167.82 | 7042.0 |
| 2024-04-10 19:00:00 | AAPL | Stock | 167.82 | 167.86 | 167.75 | 167.8 | 11162.0 |
| 2024-04-10 19:30:00 | AAPL | Stock | 167.85 | 167.9 | 167.82 | 167.85 | 10601.0 |
| 2024-04-10 04:00:00 | MSFT | Stock | 426.77 | 426.77 | 426.45 | 426.45 | 300.0 |
| 2024-04-10 04:30:00 | MSFT | Stock | 426.84 | 426.84 | 426.75 | 426.75 | 250.0 |
| 2024-04-10 05:00:00 | MSFT | Stock | 426.49 | 426.49 | 426.43 | 426.43 | 200.0 |
| 2024-04-10 06:00:00 | MSFT | Stock | 425.53 | 425.53 | 425.25 | 425.25 | 2221.0 |
| 2024-04-10 06:30:00 | MSFT | Stock | 425.3 | 425.8 | 425.3 | 425.8 | 1051.0 |
| 2024-04-10 07:00:00 | MSFT | Stock | 425.65 | 425.86 | 425.43 | 425.86 | 13884.0 |
| 2024-04-10 07:30:00 | MSFT | Stock | 425.85 | 425.87 | 425.84 | 425.84 | 608.0 |
| 2024-04-10 08:00:00 | MSFT | Stock | 425.75 | 427.03 | 425.2703 | 427.0 | 18228.0 |
| 2024-04-10 08:30:00 | MSFT | Stock | 426.01 | 426.01 | 420.35 | 422.48 | 77745.0 |
| 2024-04-10 09:00:00 | MSFT | Stock | 422.2026 | 423.5 | 421.5 | 422.19 | 25331.0 |
| 2024-04-10 09:30:00 | MSFT | Stock | 422.19 | 424.03 | 420.3 | 421.47 | 1659770.0 |
| 2024-04-10 10:00:00 | MSFT | Stock | 421.5 | 422.04 | 420.34 | 420.55 | 643468.0 |
| 2024-04-10 10:30:00 | MSFT | Stock | 420.59 | 422.48 | 420.09 | 420.59 | 666449.0 |
| 2024-04-10 11:00:00 | MSFT | Stock | 420.57 | 421.12 | 419.7 | 421.0 | 649594.0 |
| 2024-04-10 11:30:00 | MSFT | Stock | 421.04 | 421.13 | 419.76 | 420.42 | 535029.0 |
| 2024-04-10 12:00:00 | MSFT | Stock | 420.44 | 421.03 | 419.91 | 420.56 | 333855.0 |
| 2024-04-10 12:30:00 | MSFT | Stock | 420.6 | 421.92 | 420.42 | 421.77 | 326543.0 |
| 2024-04-10 13:00:00 | MSFT | Stock | 421.76 | 422.87 | 419.995 | 421.81 | 593934.0 |
> showing 50 of 100,300 rows — these rows as CSV