PREVIEW / stock_30min / 2002-07-09
file: by_date/stock_30min/2002/2002-07-09.parquet size: 605 KB rows: 31,856 symbols: 1,448
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-09 08:00:00 | AAPL | Stock | 0.3218 | 0.3218 | 0.3184 | 0.32 | 106400.0 |
| 2002-07-09 08:30:00 | AAPL | Stock | 0.32 | 0.32 | 0.318 | 0.3182 | 28000.0 |
| 2002-07-09 09:00:00 | AAPL | Stock | 0.3209 | 0.3227 | 0.3198 | 0.3227 | 940800.0 |
| 2002-07-09 09:30:00 | AAPL | Stock | 0.3229 | 0.3252 | 0.3205 | 0.3223 | 33420800.0 |
| 2002-07-09 10:00:00 | AAPL | Stock | 0.3221 | 0.3222 | 0.3118 | 0.3202 | 27921600.0 |
| 2002-07-09 10:30:00 | AAPL | Stock | 0.3207 | 0.3227 | 0.3189 | 0.3223 | 29551200.0 |
| 2002-07-09 11:00:00 | AAPL | Stock | 0.3225 | 0.3266 | 0.3214 | 0.3236 | 12308800.0 |
| 2002-07-09 11:30:00 | AAPL | Stock | 0.3234 | 0.3236 | 0.3164 | 0.3179 | 10147200.0 |
| 2002-07-09 12:00:00 | AAPL | Stock | 0.3179 | 0.3214 | 0.3168 | 0.32 | 6098400.0 |
| 2002-07-09 12:30:00 | AAPL | Stock | 0.32 | 0.3232 | 0.3196 | 0.3214 | 6423200.0 |
| 2002-07-09 13:00:00 | AAPL | Stock | 0.3216 | 0.3243 | 0.3216 | 0.3234 | 7907200.0 |
| 2002-07-09 13:30:00 | AAPL | Stock | 0.3232 | 0.3232 | 0.3182 | 0.3191 | 16083200.0 |
| 2002-07-09 14:00:00 | AAPL | Stock | 0.3207 | 0.3214 | 0.317 | 0.3186 | 9643200.0 |
| 2002-07-09 14:30:00 | AAPL | Stock | 0.3184 | 0.3195 | 0.315 | 0.3171 | 11071200.0 |
| 2002-07-09 15:00:00 | AAPL | Stock | 0.3171 | 0.3191 | 0.315 | 0.3188 | 12667200.0 |
| 2002-07-09 15:30:00 | AAPL | Stock | 0.3179 | 0.32 | 0.3129 | 0.3129 | 22164800.0 |
| 2002-07-09 16:00:00 | AAPL | Stock | 0.313 | 0.3197 | 0.3125 | 0.3125 | 13518400.0 |
| 2002-07-09 16:30:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3125 | 0.3125 | 50400.0 |
| 2002-07-09 17:00:00 | AAPL | Stock | 0.3125 | 0.313 | 0.3125 | 0.313 | 1960000.0 |
| 2002-07-09 08:00:00 | MSFT | Stock | 26.45 | 26.505 | 26.39 | 26.495 | 37200.0 |
| 2002-07-09 08:30:00 | MSFT | Stock | 26.48 | 26.716 | 26.46 | 26.625 | 166000.0 |
| 2002-07-09 09:00:00 | MSFT | Stock | 26.636 | 26.7 | 26.565 | 26.675 | 278200.0 |
| 2002-07-09 09:30:00 | MSFT | Stock | 26.655 | 27.07 | 26.635 | 26.98 | 10427600.0 |
| 2002-07-09 10:00:00 | MSFT | Stock | 26.985 | 27.015 | 26.536 | 26.92 | 8745600.0 |
| 2002-07-09 10:30:00 | MSFT | Stock | 26.92 | 27.245 | 26.91 | 27.16 | 6742800.0 |
| 2002-07-09 11:00:00 | MSFT | Stock | 27.16 | 27.365 | 27.105 | 27.225 | 5302000.0 |
| 2002-07-09 11:30:00 | MSFT | Stock | 27.215 | 27.24 | 26.87 | 26.9925 | 6002800.0 |
| 2002-07-09 12:00:00 | MSFT | Stock | 26.99 | 27.1812 | 26.915 | 27.142 | 4625200.0 |
| 2002-07-09 12:30:00 | MSFT | Stock | 27.145 | 27.265 | 27.075 | 27.1 | 3611600.0 |
| 2002-07-09 13:00:00 | MSFT | Stock | 27.1 | 27.28 | 27.085 | 27.199 | 3170000.0 |
| 2002-07-09 13:30:00 | MSFT | Stock | 27.19 | 27.2285 | 26.98 | 27.055 | 4107000.0 |
| 2002-07-09 14:00:00 | MSFT | Stock | 27.06 | 27.11 | 26.88 | 26.95 | 5328200.0 |
| 2002-07-09 14:30:00 | MSFT | Stock | 26.945 | 27.002 | 26.77 | 26.845 | 5907400.0 |
| 2002-07-09 15:00:00 | MSFT | Stock | 26.835 | 26.985 | 26.75 | 26.8225 | 5854800.0 |
| 2002-07-09 15:30:00 | MSFT | Stock | 26.8115 | 26.875 | 26.485 | 26.615 | 8030000.0 |
| 2002-07-09 16:00:00 | MSFT | Stock | 26.61 | 26.9734 | 26.55 | 26.665 | 3377400.0 |
| 2002-07-09 16:30:00 | MSFT | Stock | 26.65 | 26.9744 | 26.605 | 26.65 | 583200.0 |
| 2002-07-09 17:00:00 | MSFT | Stock | 26.66 | 26.955 | 26.605 | 26.65 | 382600.0 |
| 2002-07-09 17:30:00 | MSFT | Stock | 26.665 | 26.705 | 26.655 | 26.655 | 16400.0 |
| 2002-07-09 18:00:00 | MSFT | Stock | 26.655 | 26.705 | 26.655 | 26.655 | 8400.0 |
| 2002-07-09 18:30:00 | MSFT | Stock | 26.655 | 26.655 | 26.655 | 26.655 | 1200.0 |
| 2002-07-09 08:00:00 | NVDA | Stock | 0.1615 | 0.1637 | 0.1601 | 0.162 | 3048000.0 |
| 2002-07-09 08:30:00 | NVDA | Stock | 0.1625 | 0.163 | 0.1618 | 0.163 | 540000.0 |
| 2002-07-09 09:00:00 | NVDA | Stock | 0.1621 | 0.1646 | 0.1621 | 0.1633 | 5520000.0 |
| 2002-07-09 09:30:00 | NVDA | Stock | 0.1634 | 0.1655 | 0.1592 | 0.1616 | 174324000.0 |
| 2002-07-09 10:00:00 | NVDA | Stock | 0.1616 | 0.1616 | 0.1575 | 0.1587 | 121740000.0 |
| 2002-07-09 10:30:00 | NVDA | Stock | 0.159 | 0.1608 | 0.1579 | 0.159 | 66552000.0 |
| 2002-07-09 11:00:00 | NVDA | Stock | 0.159 | 0.1615 | 0.1587 | 0.1614 | 58992000.0 |
| 2002-07-09 11:30:00 | NVDA | Stock | 0.1615 | 0.1623 | 0.1585 | 0.1593 | 70596000.0 |
| 2002-07-09 12:00:00 | NVDA | Stock | 0.1591 | 0.1597 | 0.1587 | 0.1594 | 41928000.0 |
> showing 50 of 31,856 rows — these rows as CSV