PREVIEW / stock_30min / 2008-03-04
file: by_date/stock_30min/2008/2008-03-04.parquet size: 1.2 MB rows: 70,645 symbols: 3,281
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-04 04:00:00 | AAPL | Stock | 4.3436 | 4.3436 | 4.3436 | 4.3436 | 2800.0 |
| 2008-03-04 04:30:00 | AAPL | Stock | 4.3436 | 4.3436 | 4.3436 | 4.3436 | 5600.0 |
| 2008-03-04 05:00:00 | AAPL | Stock | 4.3393 | 4.3393 | 4.3221 | 4.3221 | 8400.0 |
| 2008-03-04 05:30:00 | AAPL | Stock | 4.3221 | 4.3221 | 4.3039 | 4.3039 | 64400.0 |
| 2008-03-04 06:00:00 | AAPL | Stock | 4.305 | 4.305 | 4.2857 | 4.2857 | 75432.0 |
| 2008-03-04 06:30:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 11200.0 |
| 2008-03-04 07:00:00 | AAPL | Stock | 4.2861 | 4.3025 | 4.2857 | 4.2893 | 104272.0 |
| 2008-03-04 07:30:00 | AAPL | Stock | 4.2896 | 4.3182 | 4.2896 | 4.3171 | 74676.0 |
| 2008-03-04 08:00:00 | AAPL | Stock | 4.3082 | 4.3232 | 4.2911 | 4.3179 | 1793904.0 |
| 2008-03-04 08:30:00 | AAPL | Stock | 4.3168 | 4.3389 | 4.3143 | 4.3357 | 1871436.0 |
| 2008-03-04 09:00:00 | AAPL | Stock | 4.3357 | 4.3618 | 4.3143 | 4.3557 | 6235208.0 |
| 2008-03-04 09:30:00 | AAPL | Stock | 4.3554 | 4.385 | 4.3 | 4.3493 | 218094940.0 |
| 2008-03-04 10:00:00 | AAPL | Stock | 4.3493 | 4.3786 | 4.3245 | 4.3371 | 124804064.0 |
| 2008-03-04 10:30:00 | AAPL | Stock | 4.3382 | 4.385 | 4.3261 | 4.3541 | 114265424.0 |
| 2008-03-04 11:00:00 | AAPL | Stock | 4.3529 | 4.3761 | 4.3321 | 4.3564 | 87524892.0 |
| 2008-03-04 11:30:00 | AAPL | Stock | 4.3564 | 4.3711 | 4.3489 | 4.3648 | 57200472.0 |
| 2008-03-04 12:00:00 | AAPL | Stock | 4.3625 | 4.4229 | 4.3571 | 4.4211 | 99570604.0 |
| 2008-03-04 12:30:00 | AAPL | Stock | 4.42 | 4.4386 | 4.3814 | 4.3832 | 94933608.0 |
| 2008-03-04 13:00:00 | AAPL | Stock | 4.3839 | 4.42 | 4.3589 | 4.4075 | 81773272.0 |
| 2008-03-04 13:30:00 | AAPL | Stock | 4.4064 | 4.4568 | 4.3275 | 4.34 | 214988732.0 |
| 2008-03-04 14:00:00 | AAPL | Stock | 4.3407 | 4.3693 | 4.3089 | 4.3454 | 187255404.0 |
| 2008-03-04 14:30:00 | AAPL | Stock | 4.3457 | 4.3825 | 4.3082 | 4.3714 | 119905156.0 |
| 2008-03-04 15:00:00 | AAPL | Stock | 4.3711 | 4.46 | 4.3604 | 4.4214 | 202114472.0 |
| 2008-03-04 15:30:00 | AAPL | Stock | 4.4214 | 4.4582 | 4.4125 | 4.4507 | 150642492.0 |
| 2008-03-04 16:00:00 | AAPL | Stock | 4.4504 | 4.4509 | 4.3475 | 4.4411 | 20354096.0 |
| 2008-03-04 16:30:00 | AAPL | Stock | 4.4411 | 4.4507 | 4.4396 | 4.4471 | 3061072.0 |
| 2008-03-04 17:00:00 | AAPL | Stock | 4.4461 | 4.4507 | 4.4429 | 4.4429 | 224840.0 |
| 2008-03-04 17:30:00 | AAPL | Stock | 4.4507 | 4.4507 | 4.3974 | 4.4429 | 303660.0 |
| 2008-03-04 18:00:00 | AAPL | Stock | 4.4446 | 4.4493 | 4.4446 | 4.4493 | 139076.0 |
| 2008-03-04 18:30:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4429 | 4.4471 | 93940.0 |
| 2008-03-04 19:00:00 | AAPL | Stock | 4.4482 | 4.4493 | 4.4393 | 4.4393 | 156492.0 |
| 2008-03-04 19:30:00 | AAPL | Stock | 4.4436 | 4.4496 | 4.4436 | 4.4496 | 88256.0 |
| 2008-03-04 06:30:00 | MSFT | Stock | 26.88 | 26.88 | 26.88 | 26.88 | 1400.0 |
| 2008-03-04 07:30:00 | MSFT | Stock | 26.85 | 26.9 | 26.81 | 26.9 | 11300.0 |
| 2008-03-04 08:00:00 | MSFT | Stock | 26.9 | 26.92 | 26.8 | 26.9 | 18390.0 |
| 2008-03-04 08:30:00 | MSFT | Stock | 26.9 | 26.95 | 26.86 | 26.9 | 12685.0 |
| 2008-03-04 09:00:00 | MSFT | Stock | 26.86 | 27.1 | 26.85 | 27.02 | 211790.0 |
| 2008-03-04 09:30:00 | MSFT | Stock | 27.03 | 27.24 | 27.01 | 27.17 | 8882747.0 |
| 2008-03-04 10:00:00 | MSFT | Stock | 27.18 | 27.32 | 27.17 | 27.25 | 8782143.0 |
| 2008-03-04 10:30:00 | MSFT | Stock | 27.24 | 27.275 | 27.13 | 27.14 | 5592735.0 |
| 2008-03-04 11:00:00 | MSFT | Stock | 27.14 | 27.19 | 27.08 | 27.19 | 3000054.0 |
| 2008-03-04 11:30:00 | MSFT | Stock | 27.19 | 27.2 | 27.03 | 27.06 | 3736017.0 |
| 2008-03-04 12:00:00 | MSFT | Stock | 27.05 | 27.1 | 27.0 | 27.062 | 4615881.0 |
| 2008-03-04 12:30:00 | MSFT | Stock | 27.07 | 27.13 | 26.99 | 27.03 | 4380912.0 |
| 2008-03-04 13:00:00 | MSFT | Stock | 27.03 | 27.1 | 26.97 | 27.08 | 3108099.0 |
| 2008-03-04 13:30:00 | MSFT | Stock | 27.082 | 27.15 | 26.96 | 27.05 | 4695925.0 |
| 2008-03-04 14:00:00 | MSFT | Stock | 27.05 | 27.15 | 27.0 | 27.07 | 4833029.0 |
| 2008-03-04 14:30:00 | MSFT | Stock | 27.07 | 27.2 | 27.03 | 27.15 | 5397401.0 |
| 2008-03-04 15:00:00 | MSFT | Stock | 27.14 | 27.5 | 27.11 | 27.43 | 10917174.0 |
| 2008-03-04 15:30:00 | MSFT | Stock | 27.42 | 27.63 | 27.41 | 27.56 | 14025477.0 |
> showing 50 of 70,645 rows — these rows as CSV