PREVIEW / stock_30min / 2007-08-10
file: by_date/stock_30min/2007/2007-08-10.parquet size: 1.2 MB rows: 66,816 symbols: 3,126
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-10 09:30:00 | AAPL | Stock | 4.3971 | 4.4236 | 4.3393 | 4.3889 | 214043788.0 |
| 2007-08-10 10:00:00 | AAPL | Stock | 4.3889 | 4.4036 | 4.35 | 4.3507 | 108425856.0 |
| 2007-08-10 10:30:00 | AAPL | Stock | 4.3504 | 4.3621 | 4.2964 | 4.35 | 131665240.0 |
| 2007-08-10 11:00:00 | AAPL | Stock | 4.3493 | 4.445 | 4.3489 | 4.4168 | 122442236.0 |
| 2007-08-10 11:30:00 | AAPL | Stock | 4.4157 | 4.4821 | 4.4 | 4.4746 | 113388380.0 |
| 2007-08-10 12:00:00 | AAPL | Stock | 4.4746 | 4.5625 | 4.4557 | 4.5318 | 140529284.0 |
| 2007-08-10 12:30:00 | AAPL | Stock | 4.5318 | 4.5393 | 4.4018 | 4.4611 | 85634248.0 |
| 2007-08-10 13:00:00 | AAPL | Stock | 4.4611 | 4.5307 | 4.4375 | 4.4818 | 60672052.0 |
| 2007-08-10 13:30:00 | AAPL | Stock | 4.4807 | 4.4925 | 4.4232 | 4.4636 | 71083488.0 |
| 2007-08-10 14:00:00 | AAPL | Stock | 4.4625 | 4.5 | 4.4457 | 4.4643 | 61406632.0 |
| 2007-08-10 14:30:00 | AAPL | Stock | 4.4643 | 4.4836 | 4.44 | 4.4425 | 51806608.0 |
| 2007-08-10 15:00:00 | AAPL | Stock | 4.4429 | 4.4929 | 4.4339 | 4.4846 | 69718796.0 |
| 2007-08-10 15:30:00 | AAPL | Stock | 4.4854 | 4.4989 | 4.4554 | 4.4643 | 85372476.0 |
| 2007-08-10 16:00:00 | AAPL | Stock | 4.4643 | 4.4707 | 4.4636 | 4.4643 | 7353136.0 |
| 2007-08-10 09:30:00 | MSFT | Stock | 28.9 | 29.05 | 28.67 | 28.9 | 8513615.0 |
| 2007-08-10 10:00:00 | MSFT | Stock | 28.9 | 28.9 | 28.33 | 28.35 | 7025789.0 |
| 2007-08-10 10:30:00 | MSFT | Stock | 28.34 | 28.55 | 28.26 | 28.44 | 5802438.0 |
| 2007-08-10 11:00:00 | MSFT | Stock | 28.44 | 28.8 | 28.42 | 28.53 | 6420096.0 |
| 2007-08-10 11:30:00 | MSFT | Stock | 28.52 | 28.76 | 28.48 | 28.75 | 4966080.0 |
| 2007-08-10 12:00:00 | MSFT | Stock | 28.75 | 28.91 | 28.58 | 28.79 | 5501013.0 |
| 2007-08-10 12:30:00 | MSFT | Stock | 28.8 | 28.85 | 28.52 | 28.54 | 3821956.0 |
| 2007-08-10 13:00:00 | MSFT | Stock | 28.54 | 28.77 | 28.52 | 28.67 | 3686811.0 |
| 2007-08-10 13:30:00 | MSFT | Stock | 28.68 | 28.71 | 28.56 | 28.6 | 4565919.0 |
| 2007-08-10 14:00:00 | MSFT | Stock | 28.6 | 28.69 | 28.56 | 28.57 | 3871032.0 |
| 2007-08-10 14:30:00 | MSFT | Stock | 28.57 | 28.62 | 28.48 | 28.57 | 3514117.0 |
| 2007-08-10 15:00:00 | MSFT | Stock | 28.58 | 28.71 | 28.49 | 28.65 | 5868555.0 |
| 2007-08-10 15:30:00 | MSFT | Stock | 28.65 | 28.8 | 28.55 | 28.7 | 7154273.0 |
| 2007-08-10 16:00:00 | MSFT | Stock | 28.7 | 28.73 | 28.68 | 28.71 | 1138819.0 |
| 2007-08-10 05:00:00 | NVDA | Stock | 0.7533 | 0.7533 | 0.7533 | 0.7533 | 24000.0 |
| 2007-08-10 07:00:00 | NVDA | Stock | 0.7443 | 0.7443 | 0.7167 | 0.7217 | 497940.0 |
| 2007-08-10 07:30:00 | NVDA | Stock | 0.7242 | 0.725 | 0.7118 | 0.7118 | 353100.0 |
| 2007-08-10 08:00:00 | NVDA | Stock | 0.7185 | 0.7233 | 0.7025 | 0.7058 | 10227240.0 |
| 2007-08-10 08:30:00 | NVDA | Stock | 0.7042 | 0.708 | 0.7025 | 0.7058 | 6010620.0 |
| 2007-08-10 09:00:00 | NVDA | Stock | 0.7083 | 0.7158 | 0.7042 | 0.7058 | 5795820.0 |
| 2007-08-10 09:30:00 | NVDA | Stock | 0.7058 | 0.7382 | 0.6898 | 0.7322 | 247695720.0 |
| 2007-08-10 10:00:00 | NVDA | Stock | 0.732 | 0.735 | 0.7083 | 0.7132 | 145616880.0 |
| 2007-08-10 10:30:00 | NVDA | Stock | 0.7125 | 0.7193 | 0.7075 | 0.7137 | 64269180.0 |
| 2007-08-10 11:00:00 | NVDA | Stock | 0.713 | 0.7292 | 0.7125 | 0.7197 | 65853600.0 |
| 2007-08-10 11:30:00 | NVDA | Stock | 0.7195 | 0.73 | 0.7142 | 0.73 | 57469680.0 |
| 2007-08-10 12:00:00 | NVDA | Stock | 0.73 | 0.7342 | 0.7253 | 0.728 | 72736140.0 |
| 2007-08-10 12:30:00 | NVDA | Stock | 0.7282 | 0.7312 | 0.7108 | 0.7132 | 55515600.0 |
| 2007-08-10 13:00:00 | NVDA | Stock | 0.7132 | 0.7325 | 0.7093 | 0.7293 | 74195640.0 |
| 2007-08-10 13:30:00 | NVDA | Stock | 0.729 | 0.7293 | 0.7173 | 0.7223 | 47638320.0 |
| 2007-08-10 14:00:00 | NVDA | Stock | 0.722 | 0.7303 | 0.7197 | 0.7198 | 39659220.0 |
| 2007-08-10 14:30:00 | NVDA | Stock | 0.7198 | 0.7262 | 0.7178 | 0.7211 | 40151460.0 |
| 2007-08-10 15:00:00 | NVDA | Stock | 0.721 | 0.7278 | 0.7203 | 0.725 | 49973520.0 |
| 2007-08-10 15:30:00 | NVDA | Stock | 0.7252 | 0.735 | 0.7208 | 0.7343 | 90458220.0 |
| 2007-08-10 16:00:00 | NVDA | Stock | 0.7343 | 0.7343 | 0.7317 | 0.7333 | 6738960.0 |
| 2007-08-10 16:30:00 | NVDA | Stock | 0.7333 | 0.7333 | 0.73 | 0.7317 | 219000.0 |
| 2007-08-10 17:00:00 | NVDA | Stock | 0.732 | 0.732 | 0.7292 | 0.7292 | 18000.0 |
> showing 50 of 66,816 rows — these rows as CSV