PREVIEW / stock_30min / 2008-09-16
file: by_date/stock_30min/2008/2008-09-16.parquet size: 1.3 MB rows: 74,413 symbols: 3,356
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-09-16 06:30:00 | AAPL | Stock | 5.0 | 5.0 | 4.9446 | 4.9446 | 26824.0 |
| 2008-09-16 07:00:00 | AAPL | Stock | 4.9643 | 4.9804 | 4.9296 | 4.9779 | 253008.0 |
| 2008-09-16 07:30:00 | AAPL | Stock | 4.9643 | 4.9804 | 4.9068 | 4.9639 | 519932.0 |
| 2008-09-16 08:00:00 | AAPL | Stock | 4.9393 | 4.9554 | 4.8354 | 4.8536 | 2416540.0 |
| 2008-09-16 08:30:00 | AAPL | Stock | 4.8536 | 4.8796 | 4.825 | 4.8254 | 3905832.0 |
| 2008-09-16 09:00:00 | AAPL | Stock | 4.825 | 4.8286 | 4.7618 | 4.7807 | 7501200.0 |
| 2008-09-16 09:30:00 | AAPL | Stock | 4.7739 | 4.8357 | 4.7196 | 4.7568 | 189790048.0 |
| 2008-09-16 10:00:00 | AAPL | Stock | 4.7546 | 4.9286 | 4.7393 | 4.9097 | 145824448.0 |
| 2008-09-16 10:30:00 | AAPL | Stock | 4.9097 | 4.955 | 4.835 | 4.9444 | 99453956.0 |
| 2008-09-16 11:00:00 | AAPL | Stock | 4.9475 | 4.9865 | 4.8414 | 4.8593 | 87207876.0 |
| 2008-09-16 11:30:00 | AAPL | Stock | 4.8604 | 4.9271 | 4.8536 | 4.9136 | 46317880.0 |
| 2008-09-16 12:00:00 | AAPL | Stock | 4.9139 | 4.9768 | 4.9082 | 4.9682 | 52943772.0 |
| 2008-09-16 12:30:00 | AAPL | Stock | 4.9682 | 4.9811 | 4.9389 | 4.98 | 44877280.0 |
| 2008-09-16 13:00:00 | AAPL | Stock | 4.98 | 5.0 | 4.9554 | 4.9554 | 42963452.0 |
| 2008-09-16 13:30:00 | AAPL | Stock | 4.9554 | 4.9682 | 4.9232 | 4.9593 | 37606212.0 |
| 2008-09-16 14:00:00 | AAPL | Stock | 4.9595 | 5.0 | 4.8382 | 4.8846 | 87094532.0 |
| 2008-09-16 14:30:00 | AAPL | Stock | 4.8843 | 5.0357 | 4.8661 | 5.0137 | 89014996.0 |
| 2008-09-16 15:00:00 | AAPL | Stock | 5.0118 | 5.0893 | 4.9804 | 5.0014 | 93643340.0 |
| 2008-09-16 15:30:00 | AAPL | Stock | 5.0018 | 5.0232 | 4.9686 | 4.9893 | 91993552.0 |
| 2008-09-16 16:00:00 | AAPL | Stock | 4.99 | 5.0282 | 4.8666 | 5.0 | 45028844.0 |
| 2008-09-16 16:30:00 | AAPL | Stock | 5.0089 | 5.0132 | 4.9127 | 4.9607 | 1209432.0 |
| 2008-09-16 17:00:00 | AAPL | Stock | 4.9607 | 4.9964 | 4.9193 | 4.9596 | 9469908.0 |
| 2008-09-16 17:30:00 | AAPL | Stock | 4.9632 | 4.9957 | 4.9614 | 4.9889 | 186480.0 |
| 2008-09-16 18:00:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9618 | 4.9618 | 25760.0 |
| 2008-09-16 18:30:00 | AAPL | Stock | 4.9614 | 4.9732 | 4.9614 | 4.9732 | 107240.0 |
| 2008-09-16 19:00:00 | AAPL | Stock | 4.9643 | 5.0364 | 4.9643 | 5.0364 | 394604.0 |
| 2008-09-16 19:30:00 | AAPL | Stock | 5.0446 | 5.0871 | 5.0446 | 5.0818 | 800016.0 |
| 2008-09-16 05:30:00 | MSFT | Stock | 26.5 | 27.11 | 26.5 | 27.11 | 600.0 |
| 2008-09-16 06:00:00 | MSFT | Stock | 26.21 | 27.13 | 26.21 | 27.13 | 500.0 |
| 2008-09-16 08:00:00 | MSFT | Stock | 26.52 | 26.68 | 26.4 | 26.5 | 13381.0 |
| 2008-09-16 08:30:00 | MSFT | Stock | 26.41 | 26.5 | 26.28 | 26.35 | 76971.0 |
| 2008-09-16 09:00:00 | MSFT | Stock | 26.29 | 26.48 | 26.03 | 26.12 | 282989.0 |
| 2008-09-16 09:30:00 | MSFT | Stock | 26.11 | 26.49 | 25.65 | 26.0 | 16807658.0 |
| 2008-09-16 10:00:00 | MSFT | Stock | 26.0 | 26.15 | 25.98 | 26.11 | 10075545.0 |
| 2008-09-16 10:30:00 | MSFT | Stock | 26.1 | 26.14 | 25.89 | 26.07 | 8585769.0 |
| 2008-09-16 11:00:00 | MSFT | Stock | 26.07 | 26.29 | 25.79 | 25.82 | 6894569.0 |
| 2008-09-16 11:30:00 | MSFT | Stock | 25.83 | 26.03 | 25.8 | 25.99 | 3788366.0 |
| 2008-09-16 12:00:00 | MSFT | Stock | 25.99 | 26.12 | 25.86 | 26.06 | 5007729.0 |
| 2008-09-16 12:30:00 | MSFT | Stock | 26.05 | 26.07 | 25.91 | 26.06 | 3583320.0 |
| 2008-09-16 13:00:00 | MSFT | Stock | 26.07 | 26.11 | 25.86 | 25.892 | 3315660.0 |
| 2008-09-16 13:30:00 | MSFT | Stock | 25.899 | 25.94 | 25.77 | 25.88 | 3802120.0 |
| 2008-09-16 14:00:00 | MSFT | Stock | 25.87 | 25.92 | 25.55 | 25.61 | 8377974.0 |
| 2008-09-16 14:30:00 | MSFT | Stock | 25.61 | 26.05 | 25.52 | 25.97 | 11234412.0 |
| 2008-09-16 15:00:00 | MSFT | Stock | 25.98 | 26.25 | 25.86 | 25.87 | 6064961.0 |
| 2008-09-16 15:30:00 | MSFT | Stock | 25.87 | 26.02 | 25.75 | 25.99 | 12859252.0 |
| 2008-09-16 16:00:00 | MSFT | Stock | 25.92 | 26.175 | 25.84 | 25.98 | 7693527.0 |
| 2008-09-16 16:30:00 | MSFT | Stock | 25.96 | 25.99 | 25.8 | 25.8 | 17988.0 |
| 2008-09-16 17:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.8 | 25.8 | 1074404.0 |
| 2008-09-16 17:30:00 | MSFT | Stock | 25.941 | 25.99 | 25.941 | 25.99 | 10200.0 |
| 2008-09-16 18:00:00 | MSFT | Stock | 25.85 | 25.91 | 25.81 | 25.81 | 2545.0 |
> showing 50 of 74,413 rows — these rows as CSV