PREVIEW / stock_30min / 2005-08-15
file: by_date/stock_30min/2005/2005-08-15.parquet size: 838 KB rows: 45,823 symbols: 2,062
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-15 07:00:00 | AAPL | Stock | 1.6536 | 1.6679 | 1.6521 | 1.6532 | 164500.0 |
| 2005-08-15 07:30:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6461 | 1.6482 | 584360.0 |
| 2005-08-15 08:00:00 | AAPL | Stock | 1.6493 | 1.6786 | 1.6486 | 1.6639 | 5750556.0 |
| 2005-08-15 08:30:00 | AAPL | Stock | 1.6639 | 1.6714 | 1.6607 | 1.6639 | 6666268.0 |
| 2005-08-15 09:00:00 | AAPL | Stock | 1.6618 | 1.6746 | 1.6604 | 1.6607 | 9586472.0 |
| 2005-08-15 09:30:00 | AAPL | Stock | 1.66 | 1.6957 | 1.6589 | 1.695 | 235977560.0 |
| 2005-08-15 10:00:00 | AAPL | Stock | 1.695 | 1.6996 | 1.6843 | 1.6979 | 124100676.0 |
| 2005-08-15 10:30:00 | AAPL | Stock | 1.6982 | 1.7125 | 1.6957 | 1.7036 | 114582356.0 |
| 2005-08-15 11:00:00 | AAPL | Stock | 1.7036 | 1.7071 | 1.6986 | 1.7011 | 60364808.0 |
| 2005-08-15 11:30:00 | AAPL | Stock | 1.7011 | 1.7093 | 1.6964 | 1.7064 | 52356640.0 |
| 2005-08-15 12:00:00 | AAPL | Stock | 1.7064 | 1.7139 | 1.7043 | 1.7118 | 48206004.0 |
| 2005-08-15 12:30:00 | AAPL | Stock | 1.7121 | 1.7236 | 1.7111 | 1.7229 | 64944516.0 |
| 2005-08-15 13:00:00 | AAPL | Stock | 1.7225 | 1.7261 | 1.7118 | 1.7168 | 68329548.0 |
| 2005-08-15 13:30:00 | AAPL | Stock | 1.7168 | 1.72 | 1.705 | 1.7054 | 55330576.0 |
| 2005-08-15 14:00:00 | AAPL | Stock | 1.7057 | 1.7107 | 1.7036 | 1.7068 | 42866796.0 |
| 2005-08-15 14:30:00 | AAPL | Stock | 1.7064 | 1.7168 | 1.7053 | 1.7114 | 46556720.0 |
| 2005-08-15 15:00:00 | AAPL | Stock | 1.7118 | 1.7171 | 1.7114 | 1.7139 | 41498408.0 |
| 2005-08-15 15:30:00 | AAPL | Stock | 1.7139 | 1.7164 | 1.7014 | 1.7029 | 87137176.0 |
| 2005-08-15 16:00:00 | AAPL | Stock | 1.7018 | 1.7039 | 1.6954 | 1.7032 | 10593996.0 |
| 2005-08-15 16:30:00 | AAPL | Stock | 1.7032 | 1.7107 | 1.7004 | 1.7011 | 1881236.0 |
| 2005-08-15 17:00:00 | AAPL | Stock | 1.7029 | 1.7043 | 1.7029 | 1.7043 | 95200.0 |
| 2005-08-15 17:30:00 | AAPL | Stock | 1.7036 | 1.7043 | 1.7014 | 1.7043 | 230860.0 |
| 2005-08-15 18:00:00 | AAPL | Stock | 1.7018 | 1.7043 | 1.7018 | 1.7036 | 154700.0 |
| 2005-08-15 08:00:00 | MSFT | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 960.0 |
| 2005-08-15 08:30:00 | MSFT | Stock | 27.03 | 27.03 | 26.98 | 26.98 | 1290.0 |
| 2005-08-15 09:00:00 | MSFT | Stock | 27.01 | 27.05 | 26.97 | 26.98 | 137872.0 |
| 2005-08-15 09:30:00 | MSFT | Stock | 26.98 | 27.05 | 26.84 | 26.87 | 5370693.0 |
| 2005-08-15 10:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.69 | 26.81 | 4889414.0 |
| 2005-08-15 10:30:00 | MSFT | Stock | 26.82 | 26.92 | 26.77 | 26.9 | 2799809.0 |
| 2005-08-15 11:00:00 | MSFT | Stock | 26.91 | 27.0 | 26.89 | 26.918 | 2835208.0 |
| 2005-08-15 11:30:00 | MSFT | Stock | 26.91 | 26.971 | 26.88 | 26.94 | 1682487.0 |
| 2005-08-15 12:00:00 | MSFT | Stock | 26.94 | 27.13 | 26.94 | 27.092 | 2674431.0 |
| 2005-08-15 12:30:00 | MSFT | Stock | 27.1 | 27.13 | 27.04 | 27.06 | 2612098.0 |
| 2005-08-15 13:00:00 | MSFT | Stock | 27.06 | 27.13 | 27.05 | 27.1 | 2097961.0 |
| 2005-08-15 13:30:00 | MSFT | Stock | 27.1 | 27.22 | 27.09 | 27.18 | 3538868.0 |
| 2005-08-15 14:00:00 | MSFT | Stock | 27.18 | 27.24 | 27.16 | 27.24 | 2270954.0 |
| 2005-08-15 14:30:00 | MSFT | Stock | 27.24 | 27.301 | 27.2 | 27.29 | 3914041.0 |
| 2005-08-15 15:00:00 | MSFT | Stock | 27.29 | 27.3 | 27.17 | 27.17 | 3025951.0 |
| 2005-08-15 15:30:00 | MSFT | Stock | 27.17 | 27.2 | 27.07 | 27.11 | 4573597.0 |
| 2005-08-15 16:00:00 | MSFT | Stock | 27.1 | 27.19 | 27.053 | 27.16 | 293185.0 |
| 2005-08-15 16:30:00 | MSFT | Stock | 27.16 | 27.17 | 27.15 | 27.17 | 29150.0 |
| 2005-08-15 17:00:00 | MSFT | Stock | 27.17 | 27.18 | 27.14 | 27.18 | 473437.0 |
| 2005-08-15 17:30:00 | MSFT | Stock | 27.17 | 27.19 | 27.13 | 27.18 | 40414.0 |
| 2005-08-15 18:00:00 | MSFT | Stock | 27.19 | 27.19 | 27.1 | 27.11 | 38364.0 |
| 2005-08-15 08:00:00 | NVDA | Stock | 0.2508 | 0.252 | 0.25 | 0.25 | 564000.0 |
| 2005-08-15 08:30:00 | NVDA | Stock | 0.25 | 0.25 | 0.2496 | 0.25 | 162000.0 |
| 2005-08-15 09:00:00 | NVDA | Stock | 0.25 | 0.25 | 0.2492 | 0.2496 | 490200.0 |
| 2005-08-15 09:30:00 | NVDA | Stock | 0.2504 | 0.2506 | 0.2472 | 0.2492 | 100538760.0 |
| 2005-08-15 10:00:00 | NVDA | Stock | 0.2492 | 0.2507 | 0.2483 | 0.2493 | 74318880.0 |
| 2005-08-15 10:30:00 | NVDA | Stock | 0.2494 | 0.254 | 0.2494 | 0.2535 | 119649600.0 |
> showing 50 of 45,823 rows — these rows as CSV