PREVIEW / stock_1hour / 2003-05-02
file: by_date/stock_1hour/2003/2003-05-02.parquet size: 437 KB rows: 21,276 symbols: 1,582
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-05-02 08:00:00 | AAPL | Stock | 0.258 | 0.258 | 0.2571 | 0.2571 | 240800.0 |
| 2003-05-02 09:00:00 | AAPL | Stock | 0.258 | 0.2596 | 0.2571 | 0.2596 | 27567624.0 |
| 2003-05-02 10:00:00 | AAPL | Stock | 0.2596 | 0.2604 | 0.2579 | 0.2588 | 40628392.0 |
| 2003-05-02 11:00:00 | AAPL | Stock | 0.2588 | 0.2605 | 0.2577 | 0.2589 | 37569448.0 |
| 2003-05-02 12:00:00 | AAPL | Stock | 0.2589 | 0.2593 | 0.2564 | 0.2566 | 19141360.0 |
| 2003-05-02 13:00:00 | AAPL | Stock | 0.2566 | 0.2577 | 0.2561 | 0.2575 | 17560200.0 |
| 2003-05-02 14:00:00 | AAPL | Stock | 0.2577 | 0.2582 | 0.2566 | 0.2571 | 24429552.0 |
| 2003-05-02 15:00:00 | AAPL | Stock | 0.2571 | 0.2582 | 0.2563 | 0.258 | 95222680.0 |
| 2003-05-02 16:00:00 | AAPL | Stock | 0.258 | 0.2588 | 0.2574 | 0.2586 | 16660000.0 |
| 2003-05-02 17:00:00 | AAPL | Stock | 0.2571 | 0.2586 | 0.2571 | 0.2579 | 537600.0 |
| 2003-05-02 08:00:00 | MSFT | Stock | 25.82 | 25.92 | 25.72 | 25.92 | 499284.0 |
| 2003-05-02 09:00:00 | MSFT | Stock | 25.872 | 25.95 | 25.57 | 25.95 | 5814104.0 |
| 2003-05-02 10:00:00 | MSFT | Stock | 25.945 | 26.15 | 25.87 | 26.13 | 10164224.0 |
| 2003-05-02 11:00:00 | MSFT | Stock | 26.14 | 26.29 | 26.04 | 26.15 | 8536586.0 |
| 2003-05-02 12:00:00 | MSFT | Stock | 26.15 | 26.2 | 26.046 | 26.05 | 4094089.0 |
| 2003-05-02 13:00:00 | MSFT | Stock | 26.041 | 26.13 | 25.95 | 26.099 | 4450878.0 |
| 2003-05-02 14:00:00 | MSFT | Stock | 26.1 | 26.2 | 26.06 | 26.14 | 5069625.0 |
| 2003-05-02 15:00:00 | MSFT | Stock | 26.13 | 26.2 | 26.02 | 26.15 | 7525475.0 |
| 2003-05-02 16:00:00 | MSFT | Stock | 26.15 | 26.2 | 26.03 | 26.15 | 830759.0 |
| 2003-05-02 17:00:00 | MSFT | Stock | 26.14 | 26.14 | 26.069 | 26.11 | 84340.0 |
| 2003-05-02 18:00:00 | MSFT | Stock | 26.13 | 26.14 | 26.11 | 26.12 | 3800.0 |
| 2003-05-02 08:00:00 | NVDA | Stock | 0.1201 | 0.1207 | 0.12 | 0.1205 | 384000.0 |
| 2003-05-02 09:00:00 | NVDA | Stock | 0.1205 | 0.1239 | 0.1205 | 0.1238 | 157399440.0 |
| 2003-05-02 10:00:00 | NVDA | Stock | 0.1238 | 0.1272 | 0.1237 | 0.1272 | 372442680.0 |
| 2003-05-02 11:00:00 | NVDA | Stock | 0.1271 | 0.1332 | 0.1271 | 0.1295 | 318393840.0 |
| 2003-05-02 12:00:00 | NVDA | Stock | 0.1295 | 0.1302 | 0.1287 | 0.1294 | 143842200.0 |
| 2003-05-02 13:00:00 | NVDA | Stock | 0.1293 | 0.1312 | 0.1289 | 0.1308 | 115432560.0 |
| 2003-05-02 14:00:00 | NVDA | Stock | 0.131 | 0.1325 | 0.131 | 0.1319 | 153453000.0 |
| 2003-05-02 15:00:00 | NVDA | Stock | 0.1319 | 0.1333 | 0.1314 | 0.1327 | 274163760.0 |
| 2003-05-02 16:00:00 | NVDA | Stock | 0.1328 | 0.1331 | 0.1317 | 0.1327 | 17719080.0 |
| 2003-05-02 17:00:00 | NVDA | Stock | 0.1325 | 0.133 | 0.1321 | 0.1324 | 732000.0 |
| 2003-05-02 18:00:00 | NVDA | Stock | 0.1325 | 0.133 | 0.1325 | 0.133 | 617040.0 |
| 2003-05-02 08:00:00 | AMZN | Stock | 1.4345 | 1.4385 | 1.4345 | 1.4355 | 140000.0 |
| 2003-05-02 09:00:00 | AMZN | Stock | 1.4355 | 1.4385 | 1.4275 | 1.437 | 17784420.0 |
| 2003-05-02 10:00:00 | AMZN | Stock | 1.437 | 1.468 | 1.437 | 1.4665 | 44637740.0 |
| 2003-05-02 11:00:00 | AMZN | Stock | 1.467 | 1.473 | 1.4458 | 1.4535 | 36524120.0 |
| 2003-05-02 12:00:00 | AMZN | Stock | 1.4535 | 1.457 | 1.449 | 1.4505 | 12426780.0 |
| 2003-05-02 13:00:00 | AMZN | Stock | 1.4505 | 1.4645 | 1.45 | 1.4635 | 18448120.0 |
| 2003-05-02 14:00:00 | AMZN | Stock | 1.463 | 1.47 | 1.4595 | 1.46 | 20190600.0 |
| 2003-05-02 15:00:00 | AMZN | Stock | 1.4605 | 1.4725 | 1.46 | 1.47 | 26747660.0 |
| 2003-05-02 16:00:00 | AMZN | Stock | 1.4715 | 1.473 | 1.4646 | 1.472 | 2084780.0 |
| 2003-05-02 17:00:00 | AMZN | Stock | 1.472 | 1.4735 | 1.47 | 1.471 | 318000.0 |
| 2003-05-02 09:00:00 | CL | Stock | 28.445 | 28.445 | 28.115 | 28.325 | 573200.0 |
| 2003-05-02 10:00:00 | CL | Stock | 28.325 | 28.4 | 28.125 | 28.225 | 566800.0 |
| 2003-05-02 11:00:00 | CL | Stock | 28.23 | 28.305 | 28.195 | 28.23 | 309800.0 |
| 2003-05-02 12:00:00 | CL | Stock | 28.235 | 28.38 | 28.235 | 28.245 | 307400.0 |
| 2003-05-02 13:00:00 | CL | Stock | 28.245 | 28.28 | 28.2 | 28.265 | 254800.0 |
| 2003-05-02 14:00:00 | CL | Stock | 28.265 | 28.43 | 28.265 | 28.43 | 277600.0 |
| 2003-05-02 15:00:00 | CL | Stock | 28.43 | 28.565 | 28.43 | 28.565 | 611800.0 |
| 2003-05-02 16:00:00 | CL | Stock | 28.575 | 28.575 | 28.575 | 28.575 | 94600.0 |
> showing 50 of 21,276 rows — these rows as CSV