PREVIEW / stock_30min / 2008-07-23
file: by_date/stock_30min/2008/2008-07-23.parquet size: 1.3 MB rows: 69,260 symbols: 3,341
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-23 07:00:00 | AAPL | Stock | 5.7893 | 5.9086 | 5.7889 | 5.8929 | 1537676.0 |
| 2008-07-23 07:30:00 | AAPL | Stock | 5.9064 | 5.9429 | 5.875 | 5.9036 | 2979004.0 |
| 2008-07-23 08:00:00 | AAPL | Stock | 5.8929 | 5.9107 | 5.7864 | 5.8861 | 6841184.0 |
| 2008-07-23 08:30:00 | AAPL | Stock | 5.8861 | 5.9071 | 5.8757 | 5.8964 | 3603992.0 |
| 2008-07-23 09:00:00 | AAPL | Stock | 5.8982 | 5.9154 | 5.875 | 5.8929 | 5445832.0 |
| 2008-07-23 09:30:00 | AAPL | Stock | 5.8911 | 5.9046 | 5.77 | 5.8486 | 165782904.0 |
| 2008-07-23 10:00:00 | AAPL | Stock | 5.8486 | 6.0071 | 5.8268 | 5.9789 | 159347580.0 |
| 2008-07-23 10:30:00 | AAPL | Stock | 5.9786 | 6.0132 | 5.9457 | 5.9511 | 110312412.0 |
| 2008-07-23 11:00:00 | AAPL | Stock | 5.9504 | 5.9604 | 5.9007 | 5.9179 | 72002644.0 |
| 2008-07-23 11:30:00 | AAPL | Stock | 5.9175 | 5.9264 | 5.8429 | 5.8653 | 61536608.0 |
| 2008-07-23 12:00:00 | AAPL | Stock | 5.8657 | 5.9032 | 5.8532 | 5.8671 | 62172712.0 |
| 2008-07-23 12:30:00 | AAPL | Stock | 5.8679 | 5.8946 | 5.8464 | 5.8918 | 43528856.0 |
| 2008-07-23 13:00:00 | AAPL | Stock | 5.8918 | 5.9586 | 5.8871 | 5.9379 | 55650700.0 |
| 2008-07-23 13:30:00 | AAPL | Stock | 5.9381 | 5.975 | 5.9014 | 5.9211 | 71500968.0 |
| 2008-07-23 14:00:00 | AAPL | Stock | 5.9225 | 5.95 | 5.915 | 5.9439 | 48434652.0 |
| 2008-07-23 14:30:00 | AAPL | Stock | 5.9456 | 5.9561 | 5.925 | 5.9343 | 43111572.0 |
| 2008-07-23 15:00:00 | AAPL | Stock | 5.9343 | 5.9514 | 5.9214 | 5.9279 | 47747840.0 |
| 2008-07-23 15:30:00 | AAPL | Stock | 5.9279 | 5.9439 | 5.9064 | 5.9312 | 71179780.0 |
| 2008-07-23 16:00:00 | AAPL | Stock | 5.9379 | 5.9679 | 5.7864 | 5.9361 | 11487784.0 |
| 2008-07-23 16:30:00 | AAPL | Stock | 5.9321 | 5.95 | 5.9286 | 5.9379 | 671608.0 |
| 2008-07-23 17:00:00 | AAPL | Stock | 5.9382 | 5.9539 | 5.7864 | 5.95 | 2435636.0 |
| 2008-07-23 17:30:00 | AAPL | Stock | 5.9507 | 5.9761 | 5.9507 | 5.9711 | 819112.0 |
| 2008-07-23 18:00:00 | AAPL | Stock | 5.9668 | 5.9696 | 5.9379 | 5.9661 | 945364.0 |
| 2008-07-23 18:30:00 | AAPL | Stock | 5.9675 | 5.9693 | 5.9575 | 5.9643 | 506884.0 |
| 2008-07-23 19:00:00 | AAPL | Stock | 5.9593 | 5.9707 | 5.9593 | 5.9679 | 203420.0 |
| 2008-07-23 19:30:00 | AAPL | Stock | 5.9696 | 5.9768 | 5.9668 | 5.9768 | 99148.0 |
| 2008-07-23 20:00:00 | AAPL | Stock | 5.9379 | 5.9379 | 5.9379 | 5.9379 | 288400.0 |
| 2008-07-23 07:30:00 | MSFT | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 100.0 |
| 2008-07-23 08:00:00 | MSFT | Stock | 25.78 | 25.95 | 25.78 | 25.92 | 13680.0 |
| 2008-07-23 08:30:00 | MSFT | Stock | 25.89 | 25.92 | 25.89 | 25.9 | 3345.0 |
| 2008-07-23 09:00:00 | MSFT | Stock | 25.91 | 25.96 | 25.8 | 25.88 | 146309.0 |
| 2008-07-23 09:30:00 | MSFT | Stock | 25.88 | 26.23 | 25.85 | 25.98 | 7288825.0 |
| 2008-07-23 10:00:00 | MSFT | Stock | 25.98 | 26.33 | 25.94 | 26.25 | 8507575.0 |
| 2008-07-23 10:30:00 | MSFT | Stock | 26.26 | 26.84 | 26.25 | 26.56 | 13335364.0 |
| 2008-07-23 11:00:00 | MSFT | Stock | 26.56 | 26.75 | 26.389 | 26.7 | 5509497.0 |
| 2008-07-23 11:30:00 | MSFT | Stock | 26.69 | 26.7 | 26.42 | 26.48 | 4696481.0 |
| 2008-07-23 12:00:00 | MSFT | Stock | 26.49 | 26.522 | 26.35 | 26.36 | 4077200.0 |
| 2008-07-23 12:30:00 | MSFT | Stock | 26.367 | 26.37 | 26.26 | 26.31 | 2138493.0 |
| 2008-07-23 13:00:00 | MSFT | Stock | 26.31 | 26.34 | 26.2 | 26.21 | 2450068.0 |
| 2008-07-23 13:30:00 | MSFT | Stock | 26.21 | 26.29 | 26.1 | 26.15 | 3976642.0 |
| 2008-07-23 14:00:00 | MSFT | Stock | 26.15 | 26.29 | 26.14 | 26.28 | 3557137.0 |
| 2008-07-23 14:30:00 | MSFT | Stock | 26.28 | 26.31 | 26.18 | 26.27 | 3182852.0 |
| 2008-07-23 15:00:00 | MSFT | Stock | 26.27 | 26.31 | 26.14 | 26.3 | 4461107.0 |
| 2008-07-23 15:30:00 | MSFT | Stock | 26.29 | 26.5 | 26.25 | 26.43 | 8967539.0 |
| 2008-07-23 16:00:00 | MSFT | Stock | 26.43 | 26.65 | 26.011 | 26.43 | 3179500.0 |
| 2008-07-23 16:30:00 | MSFT | Stock | 26.44 | 26.49 | 26.3 | 26.43 | 148509.0 |
| 2008-07-23 17:00:00 | MSFT | Stock | 26.4 | 26.53 | 26.346 | 26.45 | 199308.0 |
| 2008-07-23 17:30:00 | MSFT | Stock | 26.49 | 26.58 | 26.49 | 26.5 | 11100.0 |
| 2008-07-23 18:00:00 | MSFT | Stock | 26.5 | 26.56 | 26.43 | 26.56 | 1477523.0 |
| 2008-07-23 18:30:00 | MSFT | Stock | 26.56 | 26.56 | 26.5 | 26.5 | 300.0 |
> showing 50 of 69,260 rows — these rows as CSV