PREVIEW / stock_30min / 2009-09-28
file: by_date/stock_30min/2009/2009-09-28.parquet size: 1.3 MB rows: 71,497 symbols: 3,381
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-28 05:00:00 | AAPL | Stock | 6.5371 | 6.5371 | 6.5371 | 6.5371 | 14000.0 |
| 2009-09-28 06:30:00 | AAPL | Stock | 6.5539 | 6.5539 | 6.5539 | 6.5539 | 5600.0 |
| 2009-09-28 07:30:00 | AAPL | Stock | 6.5536 | 6.5679 | 6.5482 | 6.5579 | 62860.0 |
| 2009-09-28 08:00:00 | AAPL | Stock | 6.5571 | 6.5711 | 6.5396 | 6.5682 | 848512.0 |
| 2009-09-28 08:30:00 | AAPL | Stock | 6.5707 | 6.6071 | 6.5707 | 6.5857 | 1194032.0 |
| 2009-09-28 09:00:00 | AAPL | Stock | 6.5914 | 6.5914 | 6.5607 | 6.5657 | 1598016.0 |
| 2009-09-28 09:30:00 | AAPL | Stock | 6.5661 | 6.6061 | 6.5475 | 6.5871 | 65237648.0 |
| 2009-09-28 10:00:00 | AAPL | Stock | 6.5871 | 6.6139 | 6.5857 | 6.5964 | 40728156.0 |
| 2009-09-28 10:30:00 | AAPL | Stock | 6.5964 | 6.6196 | 6.5904 | 6.6154 | 23412620.0 |
| 2009-09-28 11:00:00 | AAPL | Stock | 6.6159 | 6.6361 | 6.6136 | 6.6329 | 21363496.0 |
| 2009-09-28 11:30:00 | AAPL | Stock | 6.6329 | 6.6489 | 6.6329 | 6.6425 | 20740076.0 |
| 2009-09-28 12:00:00 | AAPL | Stock | 6.6425 | 6.6671 | 6.6407 | 6.6529 | 17190880.0 |
| 2009-09-28 12:30:00 | AAPL | Stock | 6.6525 | 6.6625 | 6.6446 | 6.6446 | 14010892.0 |
| 2009-09-28 13:00:00 | AAPL | Stock | 6.6446 | 6.6575 | 6.6389 | 6.655 | 14461916.0 |
| 2009-09-28 13:30:00 | AAPL | Stock | 6.655 | 6.6593 | 6.6325 | 6.6339 | 17618132.0 |
| 2009-09-28 14:00:00 | AAPL | Stock | 6.6339 | 6.6507 | 6.6268 | 6.6477 | 18087328.0 |
| 2009-09-28 14:30:00 | AAPL | Stock | 6.6475 | 6.6571 | 6.6393 | 6.6502 | 16367876.0 |
| 2009-09-28 15:00:00 | AAPL | Stock | 6.6496 | 6.66 | 6.6439 | 6.6507 | 20251924.0 |
| 2009-09-28 15:30:00 | AAPL | Stock | 6.6504 | 6.6582 | 6.625 | 6.6486 | 33638220.0 |
| 2009-09-28 16:00:00 | AAPL | Stock | 6.6486 | 6.65 | 6.6161 | 6.6446 | 6351492.0 |
| 2009-09-28 16:30:00 | AAPL | Stock | 6.6446 | 6.6489 | 6.6446 | 6.6457 | 203952.0 |
| 2009-09-28 17:00:00 | AAPL | Stock | 6.6096 | 6.6468 | 6.6096 | 6.645 | 361956.0 |
| 2009-09-28 17:30:00 | AAPL | Stock | 6.6457 | 6.6496 | 6.6414 | 6.6496 | 323260.0 |
| 2009-09-28 18:00:00 | AAPL | Stock | 6.65 | 6.6571 | 6.65 | 6.6571 | 76244.0 |
| 2009-09-28 18:30:00 | AAPL | Stock | 6.6589 | 6.6589 | 6.6554 | 6.6554 | 49924.0 |
| 2009-09-28 19:00:00 | AAPL | Stock | 6.6586 | 6.6596 | 6.6554 | 6.6596 | 53788.0 |
| 2009-09-28 19:30:00 | AAPL | Stock | 6.6596 | 6.6607 | 6.6571 | 6.6571 | 43932.0 |
| 2009-09-28 04:00:00 | MSFT | Stock | 25.59 | 25.59 | 25.59 | 25.59 | 150.0 |
| 2009-09-28 07:00:00 | MSFT | Stock | 25.51 | 25.51 | 25.51 | 25.51 | 600.0 |
| 2009-09-28 07:30:00 | MSFT | Stock | 25.65 | 25.65 | 25.65 | 25.65 | 500.0 |
| 2009-09-28 08:00:00 | MSFT | Stock | 25.58 | 25.7 | 25.57 | 25.69 | 12549.0 |
| 2009-09-28 08:30:00 | MSFT | Stock | 25.64 | 25.64 | 25.64 | 25.64 | 100.0 |
| 2009-09-28 09:00:00 | MSFT | Stock | 25.65 | 25.7 | 25.6 | 25.6 | 7018.0 |
| 2009-09-28 09:30:00 | MSFT | Stock | 25.6 | 25.89 | 25.6 | 25.8 | 4142283.0 |
| 2009-09-28 10:00:00 | MSFT | Stock | 25.8 | 25.96 | 25.79 | 25.935 | 4007022.0 |
| 2009-09-28 10:30:00 | MSFT | Stock | 25.94 | 26.05 | 25.896 | 25.97 | 4450844.0 |
| 2009-09-28 11:00:00 | MSFT | Stock | 25.97 | 26.04 | 25.94 | 26.03 | 2838747.0 |
| 2009-09-28 11:30:00 | MSFT | Stock | 26.03 | 26.1 | 26.03 | 26.1 | 1557330.0 |
| 2009-09-28 12:00:00 | MSFT | Stock | 26.1 | 26.12 | 26.04 | 26.045 | 1368500.0 |
| 2009-09-28 12:30:00 | MSFT | Stock | 26.05 | 26.09 | 26.0 | 26.015 | 1183530.0 |
| 2009-09-28 13:00:00 | MSFT | Stock | 26.012 | 26.1 | 26.012 | 26.1 | 1209781.0 |
| 2009-09-28 13:30:00 | MSFT | Stock | 26.1 | 26.16 | 26.07 | 26.072 | 2648502.0 |
| 2009-09-28 14:00:00 | MSFT | Stock | 26.07 | 26.08 | 25.99 | 26.037 | 1719603.0 |
| 2009-09-28 14:30:00 | MSFT | Stock | 26.03 | 26.035 | 25.92 | 25.92 | 2540330.0 |
| 2009-09-28 15:00:00 | MSFT | Stock | 25.929 | 25.93 | 25.87 | 25.92 | 2623174.0 |
| 2009-09-28 15:30:00 | MSFT | Stock | 25.925 | 25.93 | 25.79 | 25.88 | 5939451.0 |
| 2009-09-28 16:00:00 | MSFT | Stock | 25.83 | 26.2 | 25.77 | 25.86 | 2911010.0 |
| 2009-09-28 16:30:00 | MSFT | Stock | 25.83 | 25.86 | 25.83 | 25.86 | 2297.0 |
| 2009-09-28 18:00:00 | MSFT | Stock | 25.89 | 25.9 | 25.89 | 25.9 | 600.0 |
| 2009-09-28 18:30:00 | MSFT | Stock | 25.89 | 25.89 | 25.89 | 25.89 | 100.0 |
> showing 50 of 71,497 rows — these rows as CSV