PREVIEW / stock_30min / 2024-08-01
file: by_date/stock_30min/2024/2024-08-01.parquet size: 2.1 MB rows: 100,756 symbols: 875
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-08-01 04:00:00 | AAPL | Stock | 223.8 | 223.8 | 222.7 | 222.78 | 15553.0 |
| 2024-08-01 04:30:00 | AAPL | Stock | 223.0 | 223.17 | 222.8 | 223.05 | 5363.0 |
| 2024-08-01 05:00:00 | AAPL | Stock | 223.26 | 223.55 | 223.26 | 223.35 | 5955.0 |
| 2024-08-01 05:30:00 | AAPL | Stock | 223.35 | 223.65 | 223.35 | 223.62 | 3342.0 |
| 2024-08-01 06:00:00 | AAPL | Stock | 223.6 | 223.81 | 223.6 | 223.8 | 4447.0 |
| 2024-08-01 06:30:00 | AAPL | Stock | 223.89 | 224.08 | 223.74 | 224.0 | 6383.0 |
| 2024-08-01 07:00:00 | AAPL | Stock | 224.0 | 224.73 | 223.97 | 224.62 | 46220.0 |
| 2024-08-01 07:30:00 | AAPL | Stock | 224.5 | 224.84 | 224.1 | 224.25 | 26989.0 |
| 2024-08-01 08:00:00 | AAPL | Stock | 223.98 | 224.84 | 223.5 | 224.49 | 120710.0 |
| 2024-08-01 08:30:00 | AAPL | Stock | 224.49 | 224.88 | 224.1 | 224.44 | 106691.0 |
| 2024-08-01 09:00:00 | AAPL | Stock | 224.44 | 224.7 | 224.07 | 224.3 | 114522.0 |
| 2024-08-01 09:30:00 | AAPL | Stock | 224.37 | 224.48 | 222.56 | 224.28 | 4528436.0 |
| 2024-08-01 10:00:00 | AAPL | Stock | 224.24 | 224.31 | 221.26 | 221.28 | 3080216.0 |
| 2024-08-01 10:30:00 | AAPL | Stock | 221.27 | 221.73 | 220.3503 | 220.985 | 2835585.0 |
| 2024-08-01 11:00:00 | AAPL | Stock | 221.0 | 221.175 | 220.11 | 220.53 | 1880659.0 |
| 2024-08-01 11:30:00 | AAPL | Stock | 220.56 | 220.85 | 219.21 | 219.8 | 1698858.0 |
| 2024-08-01 12:00:00 | AAPL | Stock | 219.7901 | 220.17 | 219.02 | 219.32 | 1582962.0 |
| 2024-08-01 12:30:00 | AAPL | Stock | 219.34 | 219.5 | 218.455 | 218.74 | 1606188.0 |
| 2024-08-01 13:00:00 | AAPL | Stock | 218.72 | 218.9 | 217.63 | 218.15 | 1526690.0 |
| 2024-08-01 13:30:00 | AAPL | Stock | 218.16 | 218.66 | 217.19 | 218.63 | 2009257.0 |
| 2024-08-01 14:00:00 | AAPL | Stock | 218.62 | 218.8 | 217.21 | 217.79 | 2229162.0 |
| 2024-08-01 14:30:00 | AAPL | Stock | 217.795 | 218.045 | 217.02 | 217.495 | 2352944.0 |
| 2024-08-01 15:00:00 | AAPL | Stock | 217.48 | 218.1599 | 217.12 | 218.055 | 2182646.0 |
| 2024-08-01 15:30:00 | AAPL | Stock | 218.05 | 219.14 | 217.135 | 218.28 | 5590199.0 |
| 2024-08-01 16:00:00 | AAPL | Stock | 218.36 | 219.01 | 216.2794 | 216.5142 | 8064603.0 |
| 2024-08-01 16:30:00 | AAPL | Stock | 216.54 | 223.9 | 214.0 | 219.77 | 2345345.0 |
| 2024-08-01 17:00:00 | AAPL | Stock | 219.75 | 219.9 | 212.35 | 214.45 | 1756371.0 |
| 2024-08-01 17:30:00 | AAPL | Stock | 214.5 | 220.7999 | 214.5 | 219.0 | 979043.0 |
| 2024-08-01 18:00:00 | AAPL | Stock | 220.0 | 221.0 | 218.36 | 221.0 | 311727.0 |
| 2024-08-01 18:30:00 | AAPL | Stock | 221.03 | 221.1803 | 219.03 | 220.0 | 152071.0 |
| 2024-08-01 19:00:00 | AAPL | Stock | 220.0 | 220.05 | 219.0 | 219.88 | 117765.0 |
| 2024-08-01 19:30:00 | AAPL | Stock | 219.87 | 219.98 | 219.4 | 219.6 | 108085.0 |
| 2024-08-01 04:00:00 | MSFT | Stock | 419.96 | 419.97 | 417.86 | 418.81 | 6526.0 |
| 2024-08-01 04:30:00 | MSFT | Stock | 419.22 | 420.5 | 419.1 | 419.35 | 2602.0 |
| 2024-08-01 05:00:00 | MSFT | Stock | 420.0 | 420.47 | 419.78 | 419.78 | 607.0 |
| 2024-08-01 05:30:00 | MSFT | Stock | 420.0 | 420.7 | 420.0 | 420.7 | 1423.0 |
| 2024-08-01 06:00:00 | MSFT | Stock | 420.51 | 420.66 | 420.51 | 420.66 | 529.0 |
| 2024-08-01 06:30:00 | MSFT | Stock | 420.6 | 420.6 | 420.03 | 420.2 | 506.0 |
| 2024-08-01 07:00:00 | MSFT | Stock | 419.97 | 420.03 | 419.2 | 419.8 | 3270.0 |
| 2024-08-01 07:30:00 | MSFT | Stock | 419.34 | 420.0 | 417.55 | 417.89 | 20373.0 |
| 2024-08-01 08:00:00 | MSFT | Stock | 419.99 | 421.66 | 417.7001 | 419.61 | 46699.0 |
| 2024-08-01 08:30:00 | MSFT | Stock | 419.61 | 421.0 | 419.0 | 420.49 | 38690.0 |
| 2024-08-01 09:00:00 | MSFT | Stock | 420.65 | 421.7447 | 419.99 | 420.5 | 47992.0 |
| 2024-08-01 09:30:00 | MSFT | Stock | 420.785 | 427.29 | 418.2 | 427.04 | 3220526.0 |
| 2024-08-01 10:00:00 | MSFT | Stock | 426.94 | 427.46 | 424.13 | 424.175 | 1703520.0 |
| 2024-08-01 10:30:00 | MSFT | Stock | 424.21 | 425.79 | 422.45 | 423.71 | 1041254.0 |
| 2024-08-01 11:00:00 | MSFT | Stock | 423.73 | 424.025 | 418.85 | 418.95 | 1067686.0 |
| 2024-08-01 11:30:00 | MSFT | Stock | 418.93 | 419.33 | 416.66 | 417.61 | 941531.0 |
| 2024-08-01 12:00:00 | MSFT | Stock | 417.73 | 421.08 | 417.35 | 419.25 | 919176.0 |
| 2024-08-01 12:30:00 | MSFT | Stock | 419.26 | 419.9 | 417.6 | 417.7 | 645269.0 |
> showing 50 of 100,756 rows — these rows as CSV