PREVIEW / stock_30min / 2006-03-15
file: by_date/stock_30min/2006/2006-03-15.parquet size: 903 KB rows: 48,625 symbols: 2,192
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-15 07:00:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4071 | 2.4071 | 8400.0 |
| 2006-03-15 07:30:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4125 | 2.4125 | 2800.0 |
| 2006-03-15 08:00:00 | AAPL | Stock | 2.4107 | 2.425 | 2.4107 | 2.4164 | 1201732.0 |
| 2006-03-15 08:30:00 | AAPL | Stock | 2.4161 | 2.4229 | 2.4157 | 2.42 | 809816.0 |
| 2006-03-15 09:00:00 | AAPL | Stock | 2.4196 | 2.4232 | 2.4164 | 2.4179 | 2310952.0 |
| 2006-03-15 09:30:00 | AAPL | Stock | 2.4182 | 2.43 | 2.3979 | 2.4117 | 119355740.0 |
| 2006-03-15 10:00:00 | AAPL | Stock | 2.4121 | 2.4154 | 2.3882 | 2.3986 | 70469392.0 |
| 2006-03-15 10:30:00 | AAPL | Stock | 2.3989 | 2.4071 | 2.3714 | 2.3718 | 82140688.0 |
| 2006-03-15 11:00:00 | AAPL | Stock | 2.3714 | 2.3882 | 2.3714 | 2.3764 | 45039344.0 |
| 2006-03-15 11:30:00 | AAPL | Stock | 2.3764 | 2.3821 | 2.3718 | 2.3767 | 33987464.0 |
| 2006-03-15 12:00:00 | AAPL | Stock | 2.3764 | 2.38 | 2.3607 | 2.3632 | 60444636.0 |
| 2006-03-15 12:30:00 | AAPL | Stock | 2.3629 | 2.3657 | 2.3418 | 2.36 | 104668452.0 |
| 2006-03-15 13:00:00 | AAPL | Stock | 2.3604 | 2.3661 | 2.3439 | 2.3471 | 60573800.0 |
| 2006-03-15 13:30:00 | AAPL | Stock | 2.3471 | 2.3579 | 2.34 | 2.3561 | 48948788.0 |
| 2006-03-15 14:00:00 | AAPL | Stock | 2.3561 | 2.3639 | 2.3497 | 2.3504 | 56516768.0 |
| 2006-03-15 14:30:00 | AAPL | Stock | 2.3504 | 2.3614 | 2.3411 | 2.3457 | 61970020.0 |
| 2006-03-15 15:00:00 | AAPL | Stock | 2.3457 | 2.3571 | 2.3436 | 2.3529 | 50728384.0 |
| 2006-03-15 15:30:00 | AAPL | Stock | 2.3529 | 2.3671 | 2.3521 | 2.3664 | 75092528.0 |
| 2006-03-15 16:00:00 | AAPL | Stock | 2.3661 | 2.3704 | 2.3607 | 2.3636 | 7354648.0 |
| 2006-03-15 16:30:00 | AAPL | Stock | 2.3636 | 2.3643 | 2.355 | 2.3625 | 413196.0 |
| 2006-03-15 17:00:00 | AAPL | Stock | 2.3625 | 2.3693 | 2.3625 | 2.3661 | 148820.0 |
| 2006-03-15 17:30:00 | AAPL | Stock | 2.3661 | 2.3679 | 2.3643 | 2.3643 | 327796.0 |
| 2006-03-15 18:00:00 | AAPL | Stock | 2.3643 | 2.3654 | 2.3632 | 2.3636 | 248808.0 |
| 2006-03-15 04:00:00 | MSFT | Stock | 27.27 | 27.27 | 27.27 | 27.27 | 1000.0 |
| 2006-03-15 07:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 4800.0 |
| 2006-03-15 07:30:00 | MSFT | Stock | 27.29 | 27.29 | 27.29 | 27.29 | 900.0 |
| 2006-03-15 08:00:00 | MSFT | Stock | 27.31 | 27.32 | 27.26 | 27.26 | 33435.0 |
| 2006-03-15 08:30:00 | MSFT | Stock | 27.27 | 27.27 | 27.26 | 27.27 | 78200.0 |
| 2006-03-15 09:00:00 | MSFT | Stock | 27.27 | 27.29 | 27.18 | 27.18 | 134642.0 |
| 2006-03-15 09:30:00 | MSFT | Stock | 27.2 | 27.25 | 27.05 | 27.16 | 8144079.0 |
| 2006-03-15 10:00:00 | MSFT | Stock | 27.16 | 27.19 | 27.08 | 27.11 | 4964232.0 |
| 2006-03-15 10:30:00 | MSFT | Stock | 27.119 | 27.13 | 27.03 | 27.05 | 3604404.0 |
| 2006-03-15 11:00:00 | MSFT | Stock | 27.04 | 27.16 | 27.02 | 27.04 | 3255417.0 |
| 2006-03-15 11:30:00 | MSFT | Stock | 27.04 | 27.06 | 27.01 | 27.03 | 3015768.0 |
| 2006-03-15 12:00:00 | MSFT | Stock | 27.03 | 27.17 | 27.02 | 27.04 | 2398353.0 |
| 2006-03-15 12:30:00 | MSFT | Stock | 27.03 | 27.16 | 27.03 | 27.15 | 2466892.0 |
| 2006-03-15 13:00:00 | MSFT | Stock | 27.16 | 27.16 | 27.07 | 27.08 | 1497698.0 |
| 2006-03-15 13:30:00 | MSFT | Stock | 27.09 | 27.15 | 27.07 | 27.14 | 2324287.0 |
| 2006-03-15 14:00:00 | MSFT | Stock | 27.13 | 27.41 | 27.13 | 27.4 | 7432614.0 |
| 2006-03-15 14:30:00 | MSFT | Stock | 27.41 | 27.45 | 27.34 | 27.34 | 4551263.0 |
| 2006-03-15 15:00:00 | MSFT | Stock | 27.34 | 27.44 | 27.33 | 27.39 | 3402677.0 |
| 2006-03-15 15:30:00 | MSFT | Stock | 27.38 | 27.43 | 27.27 | 27.35 | 6362248.0 |
| 2006-03-15 16:00:00 | MSFT | Stock | 27.36 | 27.39 | 27.33 | 27.34 | 99387.0 |
| 2006-03-15 16:30:00 | MSFT | Stock | 27.33 | 27.34 | 27.33 | 27.33 | 3100.0 |
| 2006-03-15 17:00:00 | MSFT | Stock | 27.33 | 27.34 | 27.33 | 27.34 | 4200.0 |
| 2006-03-15 17:30:00 | MSFT | Stock | 27.33 | 27.34 | 27.33 | 27.33 | 2800.0 |
| 2006-03-15 18:00:00 | MSFT | Stock | 27.34 | 27.34 | 27.33 | 27.34 | 7359.0 |
| 2006-03-15 08:30:00 | NVDA | Stock | 0.4104 | 0.4106 | 0.4083 | 0.409 | 1068000.0 |
| 2006-03-15 09:00:00 | NVDA | Stock | 0.4098 | 0.4104 | 0.4092 | 0.4104 | 732000.0 |
| 2006-03-15 09:30:00 | NVDA | Stock | 0.4116 | 0.4146 | 0.4102 | 0.4135 | 55359840.0 |
> showing 50 of 48,625 rows — these rows as CSV