PREVIEW / stock_30min / 2009-07-30
file: by_date/stock_30min/2009/2009-07-30.parquet size: 1.3 MB rows: 73,950 symbols: 3,367
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-07-30 04:00:00 | AAPL | Stock | 5.7261 | 5.7261 | 5.7261 | 5.7261 | 2800.0 |
| 2009-07-30 04:30:00 | AAPL | Stock | 5.7264 | 5.7264 | 5.7264 | 5.7264 | 2800.0 |
| 2009-07-30 07:00:00 | AAPL | Stock | 5.75 | 5.7704 | 5.7393 | 5.7614 | 125076.0 |
| 2009-07-30 07:30:00 | AAPL | Stock | 5.7589 | 5.7614 | 5.75 | 5.7586 | 187824.0 |
| 2009-07-30 08:00:00 | AAPL | Stock | 5.7536 | 5.7696 | 5.75 | 5.7654 | 1018108.0 |
| 2009-07-30 08:30:00 | AAPL | Stock | 5.7643 | 5.7764 | 5.7611 | 5.775 | 1361388.0 |
| 2009-07-30 09:00:00 | AAPL | Stock | 5.7746 | 5.7768 | 5.7682 | 5.7729 | 888244.0 |
| 2009-07-30 09:30:00 | AAPL | Stock | 5.7746 | 5.8743 | 5.7679 | 5.8725 | 95062520.0 |
| 2009-07-30 10:00:00 | AAPL | Stock | 5.8725 | 5.8782 | 5.8446 | 5.8646 | 53197536.0 |
| 2009-07-30 10:30:00 | AAPL | Stock | 5.865 | 5.875 | 5.855 | 5.8636 | 28102956.0 |
| 2009-07-30 11:00:00 | AAPL | Stock | 5.8639 | 5.87 | 5.85 | 5.8529 | 20913956.0 |
| 2009-07-30 11:30:00 | AAPL | Stock | 5.8548 | 5.8675 | 5.85 | 5.8501 | 23053324.0 |
| 2009-07-30 12:00:00 | AAPL | Stock | 5.8511 | 5.8536 | 5.8364 | 5.8432 | 22139432.0 |
| 2009-07-30 12:30:00 | AAPL | Stock | 5.8446 | 5.8554 | 5.8393 | 5.843 | 18566576.0 |
| 2009-07-30 13:00:00 | AAPL | Stock | 5.8429 | 5.8586 | 5.8404 | 5.8479 | 22817284.0 |
| 2009-07-30 13:30:00 | AAPL | Stock | 5.8482 | 5.8604 | 5.8454 | 5.8489 | 15214948.0 |
| 2009-07-30 14:00:00 | AAPL | Stock | 5.8493 | 5.8529 | 5.8364 | 5.8529 | 20175288.0 |
| 2009-07-30 14:30:00 | AAPL | Stock | 5.8525 | 5.8732 | 5.8475 | 5.8679 | 31428320.0 |
| 2009-07-30 15:00:00 | AAPL | Stock | 5.8679 | 5.8829 | 5.8632 | 5.8682 | 30690464.0 |
| 2009-07-30 15:30:00 | AAPL | Stock | 5.8686 | 5.8686 | 5.7857 | 5.8125 | 65876552.0 |
| 2009-07-30 16:00:00 | AAPL | Stock | 5.8136 | 5.8571 | 5.7154 | 5.7875 | 12038068.0 |
| 2009-07-30 16:30:00 | AAPL | Stock | 5.7904 | 5.8139 | 5.7836 | 5.7964 | 349608.0 |
| 2009-07-30 17:00:00 | AAPL | Stock | 5.7986 | 5.8121 | 5.7911 | 5.7911 | 114408.0 |
| 2009-07-30 17:30:00 | AAPL | Stock | 5.7964 | 5.8029 | 5.7929 | 5.7982 | 50736.0 |
| 2009-07-30 18:00:00 | AAPL | Stock | 5.7968 | 5.8139 | 5.7968 | 5.8007 | 783160.0 |
| 2009-07-30 18:30:00 | AAPL | Stock | 5.8011 | 5.8064 | 5.8011 | 5.8064 | 9044.0 |
| 2009-07-30 19:00:00 | AAPL | Stock | 5.8086 | 5.8132 | 5.8086 | 5.8121 | 92904.0 |
| 2009-07-30 19:30:00 | AAPL | Stock | 5.8121 | 5.8121 | 5.8054 | 5.8121 | 121072.0 |
| 2009-07-30 05:00:00 | MSFT | Stock | 23.91 | 23.91 | 23.91 | 23.91 | 270.0 |
| 2009-07-30 05:30:00 | MSFT | Stock | 23.92 | 23.92 | 23.92 | 23.92 | 400.0 |
| 2009-07-30 07:00:00 | MSFT | Stock | 24.0 | 24.0 | 23.99 | 23.99 | 2521.0 |
| 2009-07-30 07:30:00 | MSFT | Stock | 23.99 | 24.05 | 23.95 | 23.95 | 6000.0 |
| 2009-07-30 08:00:00 | MSFT | Stock | 23.93 | 23.95 | 23.85 | 23.94 | 49188.0 |
| 2009-07-30 08:30:00 | MSFT | Stock | 23.93 | 24.0 | 23.86 | 23.99 | 31817.0 |
| 2009-07-30 09:00:00 | MSFT | Stock | 23.99 | 24.3 | 23.96 | 24.2 | 319365.0 |
| 2009-07-30 09:30:00 | MSFT | Stock | 24.2 | 24.26 | 24.02 | 24.22 | 10081815.0 |
| 2009-07-30 10:00:00 | MSFT | Stock | 24.23 | 24.43 | 24.2 | 24.3 | 6547271.0 |
| 2009-07-30 10:30:00 | MSFT | Stock | 24.3 | 24.42 | 24.2 | 24.38 | 5687422.0 |
| 2009-07-30 11:00:00 | MSFT | Stock | 24.38 | 24.43 | 24.11 | 24.15 | 6196163.0 |
| 2009-07-30 11:30:00 | MSFT | Stock | 24.14 | 24.17 | 24.0 | 24.0 | 4410785.0 |
| 2009-07-30 12:00:00 | MSFT | Stock | 24.01 | 24.1 | 23.92 | 24.07 | 4564884.0 |
| 2009-07-30 12:30:00 | MSFT | Stock | 24.07 | 24.1 | 24.0 | 24.07 | 2202352.0 |
| 2009-07-30 13:00:00 | MSFT | Stock | 24.07 | 24.15 | 24.01 | 24.07 | 2597993.0 |
| 2009-07-30 13:30:00 | MSFT | Stock | 24.067 | 24.13 | 23.99 | 23.99 | 2318745.0 |
| 2009-07-30 14:00:00 | MSFT | Stock | 23.99 | 24.0 | 23.88 | 23.92 | 2746627.0 |
| 2009-07-30 14:30:00 | MSFT | Stock | 23.92 | 24.0 | 23.92 | 23.97 | 1928163.0 |
| 2009-07-30 15:00:00 | MSFT | Stock | 23.96 | 24.02 | 23.9 | 23.96 | 3733771.0 |
| 2009-07-30 15:30:00 | MSFT | Stock | 23.96 | 23.96 | 23.71 | 23.81 | 10149936.0 |
| 2009-07-30 16:00:00 | MSFT | Stock | 23.81 | 24.09 | 23.7 | 23.71 | 2583154.0 |
| 2009-07-30 16:30:00 | MSFT | Stock | 23.72 | 24.082 | 23.68 | 23.69 | 126506.0 |
> showing 50 of 73,950 rows — these rows as CSV