PREVIEW / stock_30min / 2003-06-23
file: by_date/stock_30min/2003/2003-06-23.parquet size: 677 KB rows: 37,390 symbols: 1,581
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-23 08:00:00 | AAPL | Stock | 0.3455 | 0.3504 | 0.343 | 0.343 | 3007200.0 |
| 2003-06-23 08:30:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 22400.0 |
| 2003-06-23 09:00:00 | AAPL | Stock | 0.3452 | 0.3473 | 0.343 | 0.3446 | 8190000.0 |
| 2003-06-23 09:30:00 | AAPL | Stock | 0.3447 | 0.3516 | 0.3429 | 0.3502 | 39206104.0 |
| 2003-06-23 10:00:00 | AAPL | Stock | 0.3502 | 0.3504 | 0.3436 | 0.3438 | 36710184.0 |
| 2003-06-23 10:30:00 | AAPL | Stock | 0.3438 | 0.3441 | 0.3379 | 0.3398 | 34097224.0 |
| 2003-06-23 11:00:00 | AAPL | Stock | 0.3398 | 0.343 | 0.3386 | 0.343 | 17739120.0 |
| 2003-06-23 11:30:00 | AAPL | Stock | 0.343 | 0.3436 | 0.3402 | 0.3411 | 14713496.0 |
| 2003-06-23 12:00:00 | AAPL | Stock | 0.3413 | 0.3427 | 0.3386 | 0.3421 | 13062056.0 |
| 2003-06-23 12:30:00 | AAPL | Stock | 0.342 | 0.3421 | 0.3398 | 0.3402 | 7030576.0 |
| 2003-06-23 13:00:00 | AAPL | Stock | 0.34 | 0.3429 | 0.3395 | 0.3421 | 8756496.0 |
| 2003-06-23 13:30:00 | AAPL | Stock | 0.3423 | 0.3438 | 0.3395 | 0.3396 | 15203272.0 |
| 2003-06-23 14:00:00 | AAPL | Stock | 0.3398 | 0.3414 | 0.3375 | 0.3375 | 19108656.0 |
| 2003-06-23 14:30:00 | AAPL | Stock | 0.3375 | 0.3375 | 0.3348 | 0.3355 | 15656368.0 |
| 2003-06-23 15:00:00 | AAPL | Stock | 0.3354 | 0.3379 | 0.3354 | 0.337 | 20503560.0 |
| 2003-06-23 15:30:00 | AAPL | Stock | 0.337 | 0.3393 | 0.3359 | 0.3386 | 17012912.0 |
| 2003-06-23 16:00:00 | AAPL | Stock | 0.3391 | 0.3404 | 0.3382 | 0.34 | 2514400.0 |
| 2003-06-23 17:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3404 | 0.3404 | 67200.0 |
| 2003-06-23 17:30:00 | AAPL | Stock | 0.34 | 0.34 | 0.34 | 0.34 | 56000.0 |
| 2003-06-23 18:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3399 | 0.3404 | 1635200.0 |
| 2003-06-23 08:00:00 | MSFT | Stock | 26.22 | 26.22 | 26.1 | 26.16 | 28100.0 |
| 2003-06-23 08:30:00 | MSFT | Stock | 26.16 | 26.19 | 26.15 | 26.15 | 18975.0 |
| 2003-06-23 09:00:00 | MSFT | Stock | 26.15 | 26.2 | 25.05 | 26.15 | 105303.0 |
| 2003-06-23 09:30:00 | MSFT | Stock | 26.14 | 26.24 | 26.04 | 26.18 | 6806549.0 |
| 2003-06-23 10:00:00 | MSFT | Stock | 26.18 | 26.22 | 26.0 | 26.04 | 5328023.0 |
| 2003-06-23 10:30:00 | MSFT | Stock | 26.045 | 26.13 | 25.9 | 25.96 | 3991062.0 |
| 2003-06-23 11:00:00 | MSFT | Stock | 25.96 | 25.97 | 25.73 | 25.8 | 4445202.0 |
| 2003-06-23 11:30:00 | MSFT | Stock | 25.8 | 25.82 | 25.51 | 25.59 | 4168146.0 |
| 2003-06-23 12:00:00 | MSFT | Stock | 25.59 | 25.7 | 25.5 | 25.66 | 3002312.0 |
| 2003-06-23 12:30:00 | MSFT | Stock | 25.661 | 25.7 | 25.6 | 25.61 | 1605150.0 |
| 2003-06-23 13:00:00 | MSFT | Stock | 25.61 | 25.74 | 25.585 | 25.72 | 1949275.0 |
| 2003-06-23 13:30:00 | MSFT | Stock | 25.72 | 25.73 | 25.67 | 25.71 | 1387375.0 |
| 2003-06-23 14:00:00 | MSFT | Stock | 25.71 | 25.74 | 25.62 | 25.65 | 2328883.0 |
| 2003-06-23 14:30:00 | MSFT | Stock | 25.65 | 25.68 | 25.55 | 25.56 | 3243916.0 |
| 2003-06-23 15:00:00 | MSFT | Stock | 25.56 | 25.61 | 25.49 | 25.59 | 3252020.0 |
| 2003-06-23 15:30:00 | MSFT | Stock | 25.59 | 25.792 | 25.58 | 25.77 | 4832646.0 |
| 2003-06-23 16:00:00 | MSFT | Stock | 25.75 | 25.82 | 25.6 | 25.78 | 977001.0 |
| 2003-06-23 16:30:00 | MSFT | Stock | 25.76 | 26.065 | 25.751 | 25.78 | 9416.0 |
| 2003-06-23 17:00:00 | MSFT | Stock | 25.77 | 25.78 | 25.77 | 25.78 | 2675.0 |
| 2003-06-23 17:30:00 | MSFT | Stock | 25.77 | 25.82 | 25.75 | 25.78 | 202549.0 |
| 2003-06-23 18:00:00 | MSFT | Stock | 25.78 | 25.82 | 25.78 | 25.79 | 214586.0 |
| 2003-06-23 08:00:00 | NVDA | Stock | 0.1983 | 0.1983 | 0.1975 | 0.1976 | 384000.0 |
| 2003-06-23 08:30:00 | NVDA | Stock | 0.1976 | 0.1977 | 0.1976 | 0.1977 | 182160.0 |
| 2003-06-23 09:00:00 | NVDA | Stock | 0.1977 | 0.1977 | 0.1972 | 0.1974 | 18462240.0 |
| 2003-06-23 09:30:00 | NVDA | Stock | 0.1972 | 0.1982 | 0.1947 | 0.1973 | 118936680.0 |
| 2003-06-23 10:00:00 | NVDA | Stock | 0.1972 | 0.1972 | 0.1936 | 0.1941 | 71897040.0 |
| 2003-06-23 10:30:00 | NVDA | Stock | 0.1941 | 0.1947 | 0.1923 | 0.1936 | 40833240.0 |
| 2003-06-23 11:00:00 | NVDA | Stock | 0.1936 | 0.1937 | 0.1917 | 0.1928 | 47520480.0 |
| 2003-06-23 11:30:00 | NVDA | Stock | 0.1929 | 0.1929 | 0.1912 | 0.1917 | 37447200.0 |
| 2003-06-23 12:00:00 | NVDA | Stock | 0.1917 | 0.1919 | 0.1899 | 0.1914 | 45942960.0 |
> showing 50 of 37,390 rows — these rows as CSV