PREVIEW / stock_30min / 2003-07-09
file: by_date/stock_30min/2003/2003-07-09.parquet size: 717 KB rows: 38,701 symbols: 1,586
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-07-09 08:30:00 | AAPL | Stock | 0.3588 | 0.3607 | 0.3588 | 0.3607 | 117600.0 |
| 2003-07-09 09:00:00 | AAPL | Stock | 0.3613 | 0.3643 | 0.3609 | 0.3609 | 509600.0 |
| 2003-07-09 09:30:00 | AAPL | Stock | 0.3609 | 0.3652 | 0.3604 | 0.3616 | 32605160.0 |
| 2003-07-09 10:00:00 | AAPL | Stock | 0.3618 | 0.365 | 0.3593 | 0.3623 | 15587208.0 |
| 2003-07-09 10:30:00 | AAPL | Stock | 0.3627 | 0.3629 | 0.3577 | 0.3577 | 15001112.0 |
| 2003-07-09 11:00:00 | AAPL | Stock | 0.3577 | 0.3591 | 0.3573 | 0.3586 | 12229952.0 |
| 2003-07-09 11:30:00 | AAPL | Stock | 0.3586 | 0.3621 | 0.3586 | 0.3609 | 17863776.0 |
| 2003-07-09 12:00:00 | AAPL | Stock | 0.3604 | 0.3605 | 0.358 | 0.3595 | 10384864.0 |
| 2003-07-09 12:30:00 | AAPL | Stock | 0.3595 | 0.36 | 0.3589 | 0.3595 | 8360240.0 |
| 2003-07-09 13:00:00 | AAPL | Stock | 0.3595 | 0.3602 | 0.3581 | 0.3586 | 7426888.0 |
| 2003-07-09 13:30:00 | AAPL | Stock | 0.3584 | 0.36 | 0.358 | 0.3593 | 8004472.0 |
| 2003-07-09 14:00:00 | AAPL | Stock | 0.3593 | 0.3602 | 0.358 | 0.3591 | 11068344.0 |
| 2003-07-09 14:30:00 | AAPL | Stock | 0.3593 | 0.3605 | 0.3584 | 0.3604 | 9967720.0 |
| 2003-07-09 15:00:00 | AAPL | Stock | 0.3604 | 0.3609 | 0.3595 | 0.3598 | 10481520.0 |
| 2003-07-09 15:30:00 | AAPL | Stock | 0.3596 | 0.3605 | 0.3555 | 0.3557 | 28035728.0 |
| 2003-07-09 16:00:00 | AAPL | Stock | 0.3557 | 0.3582 | 0.3546 | 0.3552 | 5012000.0 |
| 2003-07-09 16:30:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3552 | 0.3552 | 280000.0 |
| 2003-07-09 17:00:00 | AAPL | Stock | 0.3554 | 0.361 | 0.3545 | 0.3545 | 100800.0 |
| 2003-07-09 17:30:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 50400.0 |
| 2003-07-09 18:00:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3552 | 0.3552 | 196000.0 |
| 2003-07-09 08:00:00 | MSFT | Stock | 27.45 | 27.6 | 27.28 | 27.5 | 71922.0 |
| 2003-07-09 08:30:00 | MSFT | Stock | 27.549 | 27.55 | 27.45 | 27.54 | 304910.0 |
| 2003-07-09 09:00:00 | MSFT | Stock | 27.51 | 27.58 | 27.5 | 27.51 | 213958.0 |
| 2003-07-09 09:30:00 | MSFT | Stock | 27.56 | 27.7 | 27.51 | 27.54 | 8743250.0 |
| 2003-07-09 10:00:00 | MSFT | Stock | 27.54 | 27.68 | 27.4221 | 27.62 | 5308295.0 |
| 2003-07-09 10:30:00 | MSFT | Stock | 27.62 | 27.62 | 27.35 | 27.38 | 4646558.0 |
| 2003-07-09 11:00:00 | MSFT | Stock | 27.38 | 27.501 | 27.34 | 27.46 | 3197167.0 |
| 2003-07-09 11:30:00 | MSFT | Stock | 27.46 | 27.49 | 27.33 | 27.36 | 2962615.0 |
| 2003-07-09 12:00:00 | MSFT | Stock | 27.36 | 27.37 | 27.249 | 27.3 | 3909435.0 |
| 2003-07-09 12:30:00 | MSFT | Stock | 27.3 | 27.358 | 27.248 | 27.284 | 3091491.0 |
| 2003-07-09 13:00:00 | MSFT | Stock | 27.28 | 27.36 | 27.27 | 27.313 | 2275258.0 |
| 2003-07-09 13:30:00 | MSFT | Stock | 27.319 | 27.36 | 27.29 | 27.34 | 1890901.0 |
| 2003-07-09 14:00:00 | MSFT | Stock | 27.34 | 27.5 | 27.33 | 27.41 | 3700547.0 |
| 2003-07-09 14:30:00 | MSFT | Stock | 27.41 | 27.57 | 27.4 | 27.52 | 3934091.0 |
| 2003-07-09 15:00:00 | MSFT | Stock | 27.52 | 27.69 | 27.45 | 27.63 | 4597637.0 |
| 2003-07-09 15:30:00 | MSFT | Stock | 27.62 | 27.65 | 27.34 | 27.48 | 5818242.0 |
| 2003-07-09 16:00:00 | MSFT | Stock | 27.48 | 27.56 | 27.35 | 27.49 | 797859.0 |
| 2003-07-09 16:30:00 | MSFT | Stock | 27.49 | 27.49 | 27.39 | 27.4 | 350409.0 |
| 2003-07-09 17:00:00 | MSFT | Stock | 27.4 | 27.4018 | 27.37 | 27.37 | 22155.0 |
| 2003-07-09 17:30:00 | MSFT | Stock | 27.38 | 27.41 | 27.37 | 27.4 | 19289.0 |
| 2003-07-09 18:00:00 | MSFT | Stock | 27.31 | 27.49 | 27.31 | 27.49 | 94146.0 |
| 2003-07-09 08:30:00 | NVDA | Stock | 0.2054 | 0.2094 | 0.2054 | 0.2094 | 612000.0 |
| 2003-07-09 09:00:00 | NVDA | Stock | 0.2054 | 0.2062 | 0.2054 | 0.2062 | 984000.0 |
| 2003-07-09 09:30:00 | NVDA | Stock | 0.2063 | 0.2099 | 0.206 | 0.2083 | 96440880.0 |
| 2003-07-09 10:00:00 | NVDA | Stock | 0.2085 | 0.2146 | 0.2079 | 0.213 | 92731680.0 |
| 2003-07-09 10:30:00 | NVDA | Stock | 0.2132 | 0.2133 | 0.2086 | 0.2087 | 76447320.0 |
| 2003-07-09 11:00:00 | NVDA | Stock | 0.2086 | 0.2108 | 0.2083 | 0.2097 | 47591040.0 |
| 2003-07-09 11:30:00 | NVDA | Stock | 0.21 | 0.2108 | 0.2084 | 0.209 | 37521480.0 |
| 2003-07-09 12:00:00 | NVDA | Stock | 0.2088 | 0.2092 | 0.2076 | 0.2091 | 35517720.0 |
| 2003-07-09 12:30:00 | NVDA | Stock | 0.2092 | 0.2098 | 0.209 | 0.2095 | 25821600.0 |
> showing 50 of 38,701 rows — these rows as CSV