PREVIEW / stock_30min / 2007-09-11
file: by_date/stock_30min/2007/2007-09-11.parquet size: 1.1 MB rows: 64,118 symbols: 3,125
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-11 09:30:00 | AAPL | Stock | 4.925 | 4.9393 | 4.8421 | 4.8564 | 159810756.0 |
| 2007-09-11 10:00:00 | AAPL | Stock | 4.8568 | 4.8754 | 4.8357 | 4.8714 | 98070392.0 |
| 2007-09-11 10:30:00 | AAPL | Stock | 4.87 | 4.8725 | 4.8368 | 4.8454 | 58089276.0 |
| 2007-09-11 11:00:00 | AAPL | Stock | 4.8454 | 4.8579 | 4.8229 | 4.8557 | 67133920.0 |
| 2007-09-11 11:30:00 | AAPL | Stock | 4.8561 | 4.8629 | 4.835 | 4.8454 | 39149068.0 |
| 2007-09-11 12:00:00 | AAPL | Stock | 4.8461 | 4.8461 | 4.8279 | 4.8307 | 34154904.0 |
| 2007-09-11 12:30:00 | AAPL | Stock | 4.8311 | 4.8571 | 4.8261 | 4.8561 | 42425376.0 |
| 2007-09-11 13:00:00 | AAPL | Stock | 4.8568 | 4.8661 | 4.8404 | 4.8514 | 37327248.0 |
| 2007-09-11 13:30:00 | AAPL | Stock | 4.8514 | 4.8586 | 4.8436 | 4.8507 | 29581524.0 |
| 2007-09-11 14:00:00 | AAPL | Stock | 4.85 | 4.8621 | 4.8468 | 4.8611 | 50352792.0 |
| 2007-09-11 14:30:00 | AAPL | Stock | 4.8611 | 4.8655 | 4.8379 | 4.8464 | 47817504.0 |
| 2007-09-11 15:00:00 | AAPL | Stock | 4.8461 | 4.8529 | 4.8368 | 4.85 | 44093616.0 |
| 2007-09-11 15:30:00 | AAPL | Stock | 4.85 | 4.855 | 4.7768 | 4.8389 | 157603824.0 |
| 2007-09-11 16:00:00 | AAPL | Stock | 4.8389 | 4.8389 | 4.8384 | 4.8389 | 6589632.0 |
| 2007-09-11 09:30:00 | MSFT | Stock | 28.63 | 28.77 | 28.58 | 28.74 | 3088296.0 |
| 2007-09-11 10:00:00 | MSFT | Stock | 28.74 | 28.95 | 28.7 | 28.94 | 3460584.0 |
| 2007-09-11 10:30:00 | MSFT | Stock | 28.945 | 28.95 | 28.82 | 28.84 | 1693998.0 |
| 2007-09-11 11:00:00 | MSFT | Stock | 28.83 | 28.89 | 28.76 | 28.874 | 1684934.0 |
| 2007-09-11 11:30:00 | MSFT | Stock | 28.879 | 28.91 | 28.76 | 28.78 | 1365792.0 |
| 2007-09-11 12:00:00 | MSFT | Stock | 28.79 | 28.87 | 28.76 | 28.85 | 1153821.0 |
| 2007-09-11 12:30:00 | MSFT | Stock | 28.85 | 28.88 | 28.82 | 28.86 | 1118735.0 |
| 2007-09-11 13:00:00 | MSFT | Stock | 28.87 | 28.89 | 28.83 | 28.89 | 1258265.0 |
| 2007-09-11 13:30:00 | MSFT | Stock | 28.89 | 28.95 | 28.88 | 28.91 | 1664853.0 |
| 2007-09-11 14:00:00 | MSFT | Stock | 28.92 | 28.95 | 28.91 | 28.94 | 1631187.0 |
| 2007-09-11 14:30:00 | MSFT | Stock | 28.95 | 28.95 | 28.83 | 28.88 | 2712763.0 |
| 2007-09-11 15:00:00 | MSFT | Stock | 28.89 | 28.928 | 28.86 | 28.9 | 1763735.0 |
| 2007-09-11 15:30:00 | MSFT | Stock | 28.9 | 28.95 | 28.81 | 28.95 | 5232314.0 |
| 2007-09-11 16:00:00 | MSFT | Stock | 28.95 | 28.95 | 28.93 | 28.93 | 1443432.0 |
| 2007-09-11 07:30:00 | NVDA | Stock | 0.85 | 0.85 | 0.85 | 0.85 | 20000.0 |
| 2007-09-11 08:00:00 | NVDA | Stock | 0.8622 | 0.8625 | 0.8538 | 0.854 | 294640.0 |
| 2007-09-11 08:30:00 | NVDA | Stock | 0.859 | 0.8625 | 0.859 | 0.8612 | 376000.0 |
| 2007-09-11 09:00:00 | NVDA | Stock | 0.8552 | 0.8592 | 0.8518 | 0.8588 | 350280.0 |
| 2007-09-11 09:30:00 | NVDA | Stock | 0.8566 | 0.8655 | 0.8478 | 0.8538 | 43038640.0 |
| 2007-09-11 10:00:00 | NVDA | Stock | 0.854 | 0.8612 | 0.8512 | 0.8612 | 33765480.0 |
| 2007-09-11 10:30:00 | NVDA | Stock | 0.861 | 0.865 | 0.8592 | 0.8638 | 26743040.0 |
| 2007-09-11 11:00:00 | NVDA | Stock | 0.864 | 0.8665 | 0.8628 | 0.866 | 35043520.0 |
| 2007-09-11 11:30:00 | NVDA | Stock | 0.866 | 0.869 | 0.8638 | 0.867 | 22937320.0 |
| 2007-09-11 12:00:00 | NVDA | Stock | 0.8672 | 0.8705 | 0.8632 | 0.8685 | 31274240.0 |
| 2007-09-11 12:30:00 | NVDA | Stock | 0.8686 | 0.871 | 0.8638 | 0.866 | 21331400.0 |
| 2007-09-11 13:00:00 | NVDA | Stock | 0.866 | 0.8688 | 0.8615 | 0.863 | 25128200.0 |
| 2007-09-11 13:30:00 | NVDA | Stock | 0.863 | 0.8672 | 0.862 | 0.865 | 26210560.0 |
| 2007-09-11 14:00:00 | NVDA | Stock | 0.865 | 0.8695 | 0.8645 | 0.8675 | 18344280.0 |
| 2007-09-11 14:30:00 | NVDA | Stock | 0.8678 | 0.8685 | 0.863 | 0.864 | 19241640.0 |
| 2007-09-11 15:00:00 | NVDA | Stock | 0.864 | 0.8665 | 0.8625 | 0.8635 | 25919360.0 |
| 2007-09-11 15:30:00 | NVDA | Stock | 0.8632 | 0.865 | 0.8562 | 0.8645 | 42812960.0 |
| 2007-09-11 16:00:00 | NVDA | Stock | 0.8645 | 0.8645 | 0.8612 | 0.8615 | 6653120.0 |
| 2007-09-11 16:30:00 | NVDA | Stock | 0.8642 | 0.8645 | 0.8615 | 0.8615 | 1362440.0 |
| 2007-09-11 17:30:00 | NVDA | Stock | 0.8645 | 0.8645 | 0.8635 | 0.8645 | 1324000.0 |
| 2007-09-11 18:00:00 | NVDA | Stock | 0.8645 | 0.8658 | 0.8645 | 0.8658 | 35480.0 |
| 2007-09-11 18:30:00 | NVDA | Stock | 0.865 | 0.865 | 0.8612 | 0.8648 | 21680.0 |
> showing 50 of 64,118 rows — these rows as CSV