PREVIEW / stock_1hour / 2003-09-08
file: by_date/stock_1hour/2003/2003-09-08.parquet size: 473 KB rows: 22,587 symbols: 1,623
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-09-08 09:00:00 | AAPL | Stock | 0.4032 | 0.4061 | 0.4013 | 0.4036 | 18270560.0 |
| 2003-09-08 10:00:00 | AAPL | Stock | 0.4036 | 0.4063 | 0.4027 | 0.4032 | 36133944.0 |
| 2003-09-08 11:00:00 | AAPL | Stock | 0.4032 | 0.405 | 0.402 | 0.4025 | 25402608.0 |
| 2003-09-08 12:00:00 | AAPL | Stock | 0.4027 | 0.4043 | 0.4021 | 0.4039 | 13896848.0 |
| 2003-09-08 13:00:00 | AAPL | Stock | 0.4041 | 0.4048 | 0.4034 | 0.4045 | 12883360.0 |
| 2003-09-08 14:00:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4029 | 0.4032 | 8232616.0 |
| 2003-09-08 15:00:00 | AAPL | Stock | 0.4034 | 0.407 | 0.4023 | 0.4063 | 35324072.0 |
| 2003-09-08 16:00:00 | AAPL | Stock | 0.4055 | 0.4195 | 0.4055 | 0.4102 | 1282400.0 |
| 2003-09-08 17:00:00 | AAPL | Stock | 0.4055 | 0.4107 | 0.4055 | 0.408 | 72800.0 |
| 2003-09-08 18:00:00 | AAPL | Stock | 0.4055 | 0.4063 | 0.4055 | 0.4063 | 44800.0 |
| 2003-09-08 08:00:00 | MSFT | Stock | 28.5 | 28.505 | 28.38 | 28.45 | 76870.0 |
| 2003-09-08 09:00:00 | MSFT | Stock | 28.45 | 28.7 | 28.38 | 28.69 | 7488714.0 |
| 2003-09-08 10:00:00 | MSFT | Stock | 28.68 | 28.9 | 28.61 | 28.85 | 6963376.0 |
| 2003-09-08 11:00:00 | MSFT | Stock | 28.85 | 28.92 | 28.77 | 28.82 | 7184645.0 |
| 2003-09-08 12:00:00 | MSFT | Stock | 28.82 | 28.821 | 28.7 | 28.731 | 3270075.0 |
| 2003-09-08 13:00:00 | MSFT | Stock | 28.73 | 28.89 | 28.72 | 28.85 | 3850705.0 |
| 2003-09-08 14:00:00 | MSFT | Stock | 28.84 | 28.881 | 28.75 | 28.751 | 4377024.0 |
| 2003-09-08 15:00:00 | MSFT | Stock | 28.76 | 28.86 | 28.71 | 28.83 | 7702347.0 |
| 2003-09-08 16:00:00 | MSFT | Stock | 28.83 | 28.96 | 28.76 | 28.96 | 573751.0 |
| 2003-09-08 17:00:00 | MSFT | Stock | 28.95 | 28.96 | 28.81 | 28.86 | 52041.0 |
| 2003-09-08 18:00:00 | MSFT | Stock | 28.84 | 28.94 | 28.84 | 28.94 | 27300.0 |
| 2003-09-08 08:00:00 | NVDA | Stock | 0.1562 | 0.1582 | 0.156 | 0.1582 | 360000.0 |
| 2003-09-08 09:00:00 | NVDA | Stock | 0.1574 | 0.1601 | 0.1562 | 0.1597 | 149179320.0 |
| 2003-09-08 10:00:00 | NVDA | Stock | 0.1597 | 0.1607 | 0.1587 | 0.1592 | 163312200.0 |
| 2003-09-08 11:00:00 | NVDA | Stock | 0.1592 | 0.1624 | 0.1587 | 0.1609 | 201050520.0 |
| 2003-09-08 12:00:00 | NVDA | Stock | 0.1609 | 0.1613 | 0.1602 | 0.1611 | 170478600.0 |
| 2003-09-08 13:00:00 | NVDA | Stock | 0.1611 | 0.1637 | 0.1611 | 0.1634 | 149269800.0 |
| 2003-09-08 14:00:00 | NVDA | Stock | 0.1635 | 0.1647 | 0.163 | 0.1637 | 200940720.0 |
| 2003-09-08 15:00:00 | NVDA | Stock | 0.1637 | 0.1641 | 0.1623 | 0.1633 | 238803000.0 |
| 2003-09-08 16:00:00 | NVDA | Stock | 0.1632 | 0.1635 | 0.1627 | 0.1633 | 16871280.0 |
| 2003-09-08 17:00:00 | NVDA | Stock | 0.1633 | 0.1642 | 0.1627 | 0.1632 | 1818000.0 |
| 2003-09-08 18:00:00 | NVDA | Stock | 0.1633 | 0.1633 | 0.1631 | 0.1631 | 384000.0 |
| 2003-09-08 08:00:00 | AMZN | Stock | 2.325 | 2.326 | 2.321 | 2.3225 | 76000.0 |
| 2003-09-08 09:00:00 | AMZN | Stock | 2.3225 | 2.333 | 2.303 | 2.328 | 20307060.0 |
| 2003-09-08 10:00:00 | AMZN | Stock | 2.3276 | 2.3325 | 2.3055 | 2.3325 | 33288580.0 |
| 2003-09-08 11:00:00 | AMZN | Stock | 2.3325 | 2.3675 | 2.3308 | 2.3495 | 24656700.0 |
| 2003-09-08 12:00:00 | AMZN | Stock | 2.35 | 2.35 | 2.3355 | 2.34 | 8864500.0 |
| 2003-09-08 13:00:00 | AMZN | Stock | 2.34 | 2.3595 | 2.339 | 2.3525 | 12093860.0 |
| 2003-09-08 14:00:00 | AMZN | Stock | 2.352 | 2.3565 | 2.344 | 2.35 | 8087860.0 |
| 2003-09-08 15:00:00 | AMZN | Stock | 2.3495 | 2.365 | 2.3445 | 2.363 | 25835640.0 |
| 2003-09-08 16:00:00 | AMZN | Stock | 2.361 | 2.375 | 2.357 | 2.3675 | 1437760.0 |
| 2003-09-08 17:00:00 | AMZN | Stock | 2.3675 | 2.37 | 2.3586 | 2.3655 | 358600.0 |
| 2003-09-08 18:00:00 | AMZN | Stock | 2.365 | 2.365 | 2.3645 | 2.3645 | 20000.0 |
| 2003-09-08 09:00:00 | CL | Stock | 28.065 | 28.23 | 27.98 | 28.19 | 172600.0 |
| 2003-09-08 10:00:00 | CL | Stock | 28.18 | 28.19 | 28.045 | 28.115 | 230800.0 |
| 2003-09-08 11:00:00 | CL | Stock | 28.115 | 28.145 | 27.995 | 28.02 | 187600.0 |
| 2003-09-08 12:00:00 | CL | Stock | 28.035 | 28.08 | 27.99 | 28.055 | 238400.0 |
| 2003-09-08 13:00:00 | CL | Stock | 28.055 | 28.065 | 27.98 | 27.99 | 263400.0 |
| 2003-09-08 14:00:00 | CL | Stock | 27.985 | 28.085 | 27.95 | 28.025 | 737400.0 |
| 2003-09-08 15:00:00 | CL | Stock | 28.025 | 28.245 | 28.025 | 28.245 | 1055600.0 |
> showing 50 of 22,587 rows — these rows as CSV