PREVIEW / stock_30min / 2005-09-26
file: by_date/stock_30min/2005/2005-09-26.parquet size: 858 KB rows: 46,690 symbols: 2,074
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-26 08:00:00 | AAPL | Stock | 1.9179 | 1.9354 | 1.9139 | 1.9346 | 2219980.0 |
| 2005-09-26 08:30:00 | AAPL | Stock | 1.9346 | 1.9357 | 1.9286 | 1.9325 | 1609160.0 |
| 2005-09-26 09:00:00 | AAPL | Stock | 1.9332 | 1.9361 | 1.925 | 1.93 | 3652796.0 |
| 2005-09-26 09:30:00 | AAPL | Stock | 1.9296 | 1.9393 | 1.9179 | 1.9279 | 94975580.0 |
| 2005-09-26 10:00:00 | AAPL | Stock | 1.9279 | 1.9443 | 1.9175 | 1.9393 | 81601436.0 |
| 2005-09-26 10:30:00 | AAPL | Stock | 1.9393 | 1.9486 | 1.9343 | 1.9361 | 62583752.0 |
| 2005-09-26 11:00:00 | AAPL | Stock | 1.9364 | 1.9414 | 1.9343 | 1.9396 | 23413852.0 |
| 2005-09-26 11:30:00 | AAPL | Stock | 1.9396 | 1.9407 | 1.9286 | 1.9343 | 31224004.0 |
| 2005-09-26 12:00:00 | AAPL | Stock | 1.9343 | 1.9436 | 1.9336 | 1.9357 | 21337148.0 |
| 2005-09-26 12:30:00 | AAPL | Stock | 1.9357 | 1.9364 | 1.9264 | 1.9304 | 24175648.0 |
| 2005-09-26 13:00:00 | AAPL | Stock | 1.93 | 1.9418 | 1.9154 | 1.9229 | 30337748.0 |
| 2005-09-26 13:30:00 | AAPL | Stock | 1.9229 | 1.9282 | 1.9171 | 1.9246 | 22944544.0 |
| 2005-09-26 14:00:00 | AAPL | Stock | 1.9246 | 1.9257 | 1.9143 | 1.9181 | 21562940.0 |
| 2005-09-26 14:30:00 | AAPL | Stock | 1.9182 | 1.9182 | 1.9043 | 1.9125 | 42887992.0 |
| 2005-09-26 15:00:00 | AAPL | Stock | 1.9121 | 1.9207 | 1.9107 | 1.9179 | 30576280.0 |
| 2005-09-26 15:30:00 | AAPL | Stock | 1.9175 | 1.9282 | 1.9175 | 1.9225 | 36410136.0 |
| 2005-09-26 16:00:00 | AAPL | Stock | 1.9229 | 1.9317 | 1.9218 | 1.925 | 1909068.0 |
| 2005-09-26 16:30:00 | AAPL | Stock | 1.9229 | 1.9261 | 1.9229 | 1.9261 | 184324.0 |
| 2005-09-26 17:30:00 | AAPL | Stock | 1.9209 | 1.9232 | 1.9209 | 1.9232 | 9800.0 |
| 2005-09-26 18:00:00 | AAPL | Stock | 1.9257 | 1.935 | 1.9236 | 1.9236 | 56000.0 |
| 2005-09-26 07:30:00 | MSFT | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 4700.0 |
| 2005-09-26 08:00:00 | MSFT | Stock | 25.4 | 25.42 | 25.37 | 25.4 | 83953.0 |
| 2005-09-26 08:30:00 | MSFT | Stock | 25.42 | 25.46 | 25.42 | 25.43 | 1124808.0 |
| 2005-09-26 09:00:00 | MSFT | Stock | 25.42 | 25.42 | 25.37 | 25.41 | 252840.0 |
| 2005-09-26 09:30:00 | MSFT | Stock | 25.4 | 25.4 | 25.31 | 25.34 | 7025561.0 |
| 2005-09-26 10:00:00 | MSFT | Stock | 25.34 | 25.49 | 25.34 | 25.39 | 4845245.0 |
| 2005-09-26 10:30:00 | MSFT | Stock | 25.38 | 25.4 | 25.27 | 25.341 | 3275507.0 |
| 2005-09-26 11:00:00 | MSFT | Stock | 25.349 | 25.42 | 25.32 | 25.39 | 2284408.0 |
| 2005-09-26 11:30:00 | MSFT | Stock | 25.39 | 25.44 | 25.36 | 25.37 | 2154358.0 |
| 2005-09-26 12:00:00 | MSFT | Stock | 25.38 | 25.45 | 25.36 | 25.43 | 2463148.0 |
| 2005-09-26 12:30:00 | MSFT | Stock | 25.43 | 25.451 | 25.41 | 25.44 | 2935402.0 |
| 2005-09-26 13:00:00 | MSFT | Stock | 25.43 | 25.44 | 25.35 | 25.39 | 4246663.0 |
| 2005-09-26 13:30:00 | MSFT | Stock | 25.39 | 25.43 | 25.33 | 25.4 | 1884724.0 |
| 2005-09-26 14:00:00 | MSFT | Stock | 25.4 | 25.411 | 25.28 | 25.29 | 3607616.0 |
| 2005-09-26 14:30:00 | MSFT | Stock | 25.28 | 25.31 | 25.21 | 25.23 | 3863815.0 |
| 2005-09-26 15:00:00 | MSFT | Stock | 25.23 | 25.28 | 25.22 | 25.24 | 5129811.0 |
| 2005-09-26 15:30:00 | MSFT | Stock | 25.24 | 25.29 | 25.22 | 25.24 | 6271522.0 |
| 2005-09-26 16:00:00 | MSFT | Stock | 25.26 | 25.27 | 25.24 | 25.27 | 554418.0 |
| 2005-09-26 16:30:00 | MSFT | Stock | 25.28 | 25.29 | 25.26 | 25.26 | 46669.0 |
| 2005-09-26 17:00:00 | MSFT | Stock | 25.25 | 25.26 | 25.24 | 25.26 | 1610.0 |
| 2005-09-26 17:30:00 | MSFT | Stock | 25.27 | 25.29 | 25.27 | 25.29 | 900.0 |
| 2005-09-26 18:00:00 | MSFT | Stock | 25.29 | 25.37 | 25.26 | 25.26 | 4796.0 |
| 2005-09-26 09:00:00 | NVDA | Stock | 0.2747 | 0.2749 | 0.2739 | 0.2739 | 72000.0 |
| 2005-09-26 09:30:00 | NVDA | Stock | 0.2747 | 0.2767 | 0.2697 | 0.2707 | 93608760.0 |
| 2005-09-26 10:00:00 | NVDA | Stock | 0.2704 | 0.2737 | 0.2702 | 0.2726 | 48069240.0 |
| 2005-09-26 10:30:00 | NVDA | Stock | 0.2726 | 0.2733 | 0.2707 | 0.2726 | 42981120.0 |
| 2005-09-26 11:00:00 | NVDA | Stock | 0.2727 | 0.2728 | 0.2712 | 0.2715 | 35391600.0 |
| 2005-09-26 11:30:00 | NVDA | Stock | 0.2716 | 0.2725 | 0.2715 | 0.2724 | 14828160.0 |
| 2005-09-26 12:00:00 | NVDA | Stock | 0.2724 | 0.2737 | 0.2724 | 0.2728 | 10964160.0 |
| 2005-09-26 12:30:00 | NVDA | Stock | 0.2727 | 0.2734 | 0.2723 | 0.2731 | 6254760.0 |
> showing 50 of 46,690 rows — these rows as CSV