PREVIEW / stock_30min / 2005-07-06
file: by_date/stock_30min/2005/2005-07-06.parquet size: 815 KB rows: 44,664 symbols: 2,016
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-07-06 08:00:00 | AAPL | Stock | 1.3571 | 1.3571 | 1.35 | 1.3543 | 198408.0 |
| 2005-07-06 08:30:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3461 | 1.3464 | 542080.0 |
| 2005-07-06 09:00:00 | AAPL | Stock | 1.3464 | 1.3507 | 1.3454 | 1.3475 | 1038996.0 |
| 2005-07-06 09:30:00 | AAPL | Stock | 1.3468 | 1.3536 | 1.3429 | 1.3468 | 51291912.0 |
| 2005-07-06 10:00:00 | AAPL | Stock | 1.3464 | 1.3518 | 1.3443 | 1.3493 | 32065936.0 |
| 2005-07-06 10:30:00 | AAPL | Stock | 1.3489 | 1.3536 | 1.3479 | 1.3525 | 21375844.0 |
| 2005-07-06 11:00:00 | AAPL | Stock | 1.3521 | 1.3629 | 1.3514 | 1.3607 | 36863484.0 |
| 2005-07-06 11:30:00 | AAPL | Stock | 1.3607 | 1.3629 | 1.3571 | 1.3579 | 24104416.0 |
| 2005-07-06 12:00:00 | AAPL | Stock | 1.3579 | 1.3582 | 1.3429 | 1.3454 | 28953848.0 |
| 2005-07-06 12:30:00 | AAPL | Stock | 1.345 | 1.3454 | 1.3379 | 1.3421 | 32735360.0 |
| 2005-07-06 13:00:00 | AAPL | Stock | 1.3418 | 1.3482 | 1.3418 | 1.345 | 18589536.0 |
| 2005-07-06 13:30:00 | AAPL | Stock | 1.3446 | 1.3486 | 1.3439 | 1.3454 | 11576852.0 |
| 2005-07-06 14:00:00 | AAPL | Stock | 1.3454 | 1.3464 | 1.3393 | 1.3411 | 17454976.0 |
| 2005-07-06 14:30:00 | AAPL | Stock | 1.3411 | 1.3411 | 1.3286 | 1.3361 | 38125724.0 |
| 2005-07-06 15:00:00 | AAPL | Stock | 1.3361 | 1.3432 | 1.3339 | 1.3429 | 23066176.0 |
| 2005-07-06 15:30:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.335 | 1.3354 | 44122988.0 |
| 2005-07-06 16:00:00 | AAPL | Stock | 1.3354 | 1.3451 | 1.3325 | 1.3354 | 2963772.0 |
| 2005-07-06 16:30:00 | AAPL | Stock | 1.3354 | 1.3354 | 1.3354 | 1.3354 | 42056.0 |
| 2005-07-06 17:00:00 | AAPL | Stock | 1.3354 | 1.3354 | 1.3354 | 1.3354 | 3911600.0 |
| 2005-07-06 17:30:00 | AAPL | Stock | 1.3354 | 1.3371 | 1.3354 | 1.3371 | 60984.0 |
| 2005-07-06 18:00:00 | AAPL | Stock | 1.3357 | 1.3368 | 1.3354 | 1.3354 | 40376.0 |
| 2005-07-06 07:30:00 | MSFT | Stock | 24.98 | 25.0 | 24.98 | 24.99 | 6400.0 |
| 2005-07-06 08:00:00 | MSFT | Stock | 24.98 | 24.98 | 24.96 | 24.96 | 6000.0 |
| 2005-07-06 08:30:00 | MSFT | Stock | 24.96 | 25.0 | 24.96 | 25.0 | 6897.0 |
| 2005-07-06 09:00:00 | MSFT | Stock | 25.0 | 25.215 | 24.97 | 24.98 | 479136.0 |
| 2005-07-06 09:30:00 | MSFT | Stock | 24.97 | 25.08 | 24.92 | 25.0 | 7968766.0 |
| 2005-07-06 10:00:00 | MSFT | Stock | 25.0 | 25.03 | 24.93 | 24.99 | 7425465.0 |
| 2005-07-06 10:30:00 | MSFT | Stock | 24.99 | 25.04 | 24.95 | 24.98 | 5081728.0 |
| 2005-07-06 11:00:00 | MSFT | Stock | 24.97 | 24.98 | 24.93 | 24.94 | 3138271.0 |
| 2005-07-06 11:30:00 | MSFT | Stock | 24.941 | 24.97 | 24.9 | 24.92 | 3328863.0 |
| 2005-07-06 12:00:00 | MSFT | Stock | 24.91 | 24.92 | 24.83 | 24.85 | 3280388.0 |
| 2005-07-06 12:30:00 | MSFT | Stock | 24.84 | 24.95 | 24.829 | 24.87 | 3620851.0 |
| 2005-07-06 13:00:00 | MSFT | Stock | 24.86 | 24.92 | 24.86 | 24.87 | 2090815.0 |
| 2005-07-06 13:30:00 | MSFT | Stock | 24.88 | 24.95 | 24.85 | 24.86 | 2244439.0 |
| 2005-07-06 14:00:00 | MSFT | Stock | 24.86 | 24.88 | 24.829 | 24.84 | 3417307.0 |
| 2005-07-06 14:30:00 | MSFT | Stock | 24.84 | 24.84 | 24.74 | 24.78 | 5658583.0 |
| 2005-07-06 15:00:00 | MSFT | Stock | 24.77 | 24.831 | 24.75 | 24.79 | 5494533.0 |
| 2005-07-06 15:30:00 | MSFT | Stock | 24.79 | 24.9 | 24.69 | 24.7 | 6856727.0 |
| 2005-07-06 16:00:00 | MSFT | Stock | 24.71 | 24.891 | 24.7 | 24.72 | 2408895.0 |
| 2005-07-06 16:30:00 | MSFT | Stock | 24.72 | 24.72 | 24.7 | 24.7 | 27755.0 |
| 2005-07-06 17:00:00 | MSFT | Stock | 24.72 | 24.72 | 24.7 | 24.7 | 125810.0 |
| 2005-07-06 17:30:00 | MSFT | Stock | 24.72 | 24.73 | 24.7 | 24.73 | 6330.0 |
| 2005-07-06 18:00:00 | MSFT | Stock | 24.73 | 24.73 | 24.72 | 24.73 | 2652.0 |
| 2005-07-06 08:00:00 | NVDA | Stock | 0.2289 | 0.2329 | 0.2289 | 0.2329 | 24000.0 |
| 2005-07-06 08:30:00 | NVDA | Stock | 0.2281 | 0.2281 | 0.2279 | 0.2279 | 72000.0 |
| 2005-07-06 09:00:00 | NVDA | Stock | 0.2292 | 0.2292 | 0.2279 | 0.2281 | 457680.0 |
| 2005-07-06 09:30:00 | NVDA | Stock | 0.2279 | 0.2287 | 0.2257 | 0.226 | 67766040.0 |
| 2005-07-06 10:00:00 | NVDA | Stock | 0.226 | 0.2275 | 0.2253 | 0.2259 | 90053760.0 |
| 2005-07-06 10:30:00 | NVDA | Stock | 0.2259 | 0.228 | 0.2258 | 0.228 | 38373600.0 |
| 2005-07-06 11:00:00 | NVDA | Stock | 0.2281 | 0.2302 | 0.2271 | 0.2302 | 39066720.0 |
> showing 50 of 44,664 rows — these rows as CSV