PREVIEW / stock_30min / 2004-11-01
file: by_date/stock_30min/2004/2004-11-01.parquet size: 787 KB rows: 41,830 symbols: 1,865
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-01 08:00:00 | AAPL | Stock | 0.9358 | 0.9552 | 0.9357 | 0.9518 | 11081504.0 |
| 2004-11-01 08:30:00 | AAPL | Stock | 0.9518 | 0.9518 | 0.9486 | 0.95 | 509712.0 |
| 2004-11-01 09:00:00 | AAPL | Stock | 0.9489 | 0.9489 | 0.937 | 0.9373 | 6271832.0 |
| 2004-11-01 09:30:00 | AAPL | Stock | 0.9375 | 0.9511 | 0.9341 | 0.9386 | 93166640.0 |
| 2004-11-01 10:00:00 | AAPL | Stock | 0.9388 | 0.9429 | 0.9323 | 0.9388 | 59757992.0 |
| 2004-11-01 10:30:00 | AAPL | Stock | 0.9386 | 0.9438 | 0.9352 | 0.9438 | 40287240.0 |
| 2004-11-01 11:00:00 | AAPL | Stock | 0.9432 | 0.945 | 0.9409 | 0.9432 | 39531240.0 |
| 2004-11-01 11:30:00 | AAPL | Stock | 0.9432 | 0.9434 | 0.9384 | 0.942 | 29577128.0 |
| 2004-11-01 12:00:00 | AAPL | Stock | 0.942 | 0.9432 | 0.9375 | 0.9391 | 19725384.0 |
| 2004-11-01 12:30:00 | AAPL | Stock | 0.9391 | 0.9421 | 0.9388 | 0.9389 | 24103128.0 |
| 2004-11-01 13:00:00 | AAPL | Stock | 0.9389 | 0.94 | 0.9368 | 0.9371 | 26927264.0 |
| 2004-11-01 13:30:00 | AAPL | Stock | 0.9371 | 0.9396 | 0.9368 | 0.9395 | 21593712.0 |
| 2004-11-01 14:00:00 | AAPL | Stock | 0.9393 | 0.9411 | 0.9293 | 0.9325 | 53690168.0 |
| 2004-11-01 14:30:00 | AAPL | Stock | 0.9329 | 0.9391 | 0.9307 | 0.935 | 47650848.0 |
| 2004-11-01 15:00:00 | AAPL | Stock | 0.935 | 0.9382 | 0.9325 | 0.9379 | 32955496.0 |
| 2004-11-01 15:30:00 | AAPL | Stock | 0.938 | 0.9404 | 0.9339 | 0.9348 | 68336688.0 |
| 2004-11-01 16:00:00 | AAPL | Stock | 0.9348 | 0.9368 | 0.9323 | 0.9363 | 5626320.0 |
| 2004-11-01 16:30:00 | AAPL | Stock | 0.9366 | 0.9366 | 0.9363 | 0.9366 | 168000.0 |
| 2004-11-01 17:00:00 | AAPL | Stock | 0.9357 | 0.939 | 0.9355 | 0.9355 | 925008.0 |
| 2004-11-01 17:30:00 | AAPL | Stock | 0.9407 | 0.9407 | 0.9357 | 0.9357 | 127792.0 |
| 2004-11-01 18:00:00 | AAPL | Stock | 0.9357 | 0.9357 | 0.9357 | 0.9357 | 5600.0 |
| 2004-11-01 08:00:00 | MSFT | Stock | 27.97 | 28.0 | 27.97 | 28.0 | 11776.0 |
| 2004-11-01 08:30:00 | MSFT | Stock | 28.01 | 28.07 | 28.0 | 28.03 | 6000.0 |
| 2004-11-01 09:00:00 | MSFT | Stock | 28.05 | 28.18 | 27.94 | 28.16 | 300845.0 |
| 2004-11-01 09:30:00 | MSFT | Stock | 28.15 | 28.19 | 28.08 | 28.11 | 6917568.0 |
| 2004-11-01 10:00:00 | MSFT | Stock | 28.11 | 28.15 | 28.0699 | 28.1 | 3856768.0 |
| 2004-11-01 10:30:00 | MSFT | Stock | 28.1 | 28.11 | 27.99 | 28.08 | 5674065.0 |
| 2004-11-01 11:00:00 | MSFT | Stock | 28.08 | 28.22 | 28.07 | 28.18 | 5667497.0 |
| 2004-11-01 11:30:00 | MSFT | Stock | 28.18 | 28.25 | 28.16 | 28.22 | 4242080.0 |
| 2004-11-01 12:00:00 | MSFT | Stock | 28.22 | 28.26 | 28.15 | 28.19 | 3873404.0 |
| 2004-11-01 12:30:00 | MSFT | Stock | 28.18 | 28.28 | 28.16 | 28.21 | 2254572.0 |
| 2004-11-01 13:00:00 | MSFT | Stock | 28.21 | 28.23 | 28.009 | 28.01 | 8134580.0 |
| 2004-11-01 13:30:00 | MSFT | Stock | 28.01 | 28.05 | 27.96 | 27.999 | 6217021.0 |
| 2004-11-01 14:00:00 | MSFT | Stock | 27.9998 | 28.03 | 27.9799 | 28.01 | 3322625.0 |
| 2004-11-01 14:30:00 | MSFT | Stock | 28.01 | 28.12 | 27.99 | 28.06 | 4039894.0 |
| 2004-11-01 15:00:00 | MSFT | Stock | 28.05 | 28.06 | 28.0 | 28.029 | 3583574.0 |
| 2004-11-01 15:30:00 | MSFT | Stock | 28.03 | 28.1 | 27.99 | 28.1 | 5695313.0 |
| 2004-11-01 16:00:00 | MSFT | Stock | 28.1 | 28.12 | 28.03 | 28.08 | 958017.0 |
| 2004-11-01 16:30:00 | MSFT | Stock | 28.08 | 28.09 | 28.05 | 28.06 | 2033638.0 |
| 2004-11-01 17:00:00 | MSFT | Stock | 28.07 | 28.135 | 28.07 | 28.08 | 10000.0 |
| 2004-11-01 17:30:00 | MSFT | Stock | 28.08 | 28.12 | 28.08 | 28.12 | 24514.0 |
| 2004-11-01 09:00:00 | NVDA | Stock | 0.121 | 0.1215 | 0.1205 | 0.1215 | 1741440.0 |
| 2004-11-01 09:30:00 | NVDA | Stock | 0.1222 | 0.1226 | 0.1207 | 0.1213 | 67310760.0 |
| 2004-11-01 10:00:00 | NVDA | Stock | 0.1212 | 0.1215 | 0.121 | 0.1213 | 37425360.0 |
| 2004-11-01 10:30:00 | NVDA | Stock | 0.1213 | 0.1216 | 0.121 | 0.1212 | 31884360.0 |
| 2004-11-01 11:00:00 | NVDA | Stock | 0.1212 | 0.1222 | 0.1212 | 0.1218 | 30616200.0 |
| 2004-11-01 11:30:00 | NVDA | Stock | 0.1217 | 0.1221 | 0.1207 | 0.1209 | 25589160.0 |
| 2004-11-01 12:00:00 | NVDA | Stock | 0.1209 | 0.1216 | 0.1207 | 0.1216 | 24356880.0 |
| 2004-11-01 12:30:00 | NVDA | Stock | 0.1216 | 0.1222 | 0.1214 | 0.1218 | 24017280.0 |
| 2004-11-01 13:00:00 | NVDA | Stock | 0.1217 | 0.1219 | 0.1208 | 0.1208 | 36609360.0 |
> showing 50 of 41,830 rows — these rows as CSV