PREVIEW / stock_30min / 2009-07-28
file: by_date/stock_30min/2009/2009-07-28.parquet size: 1.3 MB rows: 71,710 symbols: 3,353
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-28 07:00:00 | AAPL | Stock | 5.6804 | 5.6804 | 5.6804 | 5.6804 | 47264.0 |
| 2009-07-28 07:30:00 | AAPL | Stock | 5.675 | 5.6786 | 5.675 | 5.6786 | 79604.0 |
| 2009-07-28 08:00:00 | AAPL | Stock | 5.67 | 5.6893 | 5.6696 | 5.6786 | 418572.0 |
| 2009-07-28 08:30:00 | AAPL | Stock | 5.6779 | 5.7179 | 5.67 | 5.6718 | 478156.0 |
| 2009-07-28 09:00:00 | AAPL | Stock | 5.6721 | 5.6786 | 5.6679 | 5.6761 | 559776.0 |
| 2009-07-28 09:30:00 | AAPL | Stock | 5.6771 | 5.6957 | 5.6436 | 5.6736 | 62022688.0 |
| 2009-07-28 10:00:00 | AAPL | Stock | 5.6736 | 5.6757 | 5.645 | 5.6654 | 34489392.0 |
| 2009-07-28 10:30:00 | AAPL | Stock | 5.6654 | 5.6746 | 5.6525 | 5.66 | 16769816.0 |
| 2009-07-28 11:00:00 | AAPL | Stock | 5.6593 | 5.6596 | 5.6375 | 5.6414 | 23219280.0 |
| 2009-07-28 11:30:00 | AAPL | Stock | 5.6414 | 5.6564 | 5.6286 | 5.6536 | 25890480.0 |
| 2009-07-28 12:00:00 | AAPL | Stock | 5.6536 | 5.6546 | 5.6389 | 5.6461 | 10880604.0 |
| 2009-07-28 12:30:00 | AAPL | Stock | 5.6461 | 5.6579 | 5.6429 | 5.6571 | 12411616.0 |
| 2009-07-28 13:00:00 | AAPL | Stock | 5.6568 | 5.6814 | 5.6482 | 5.6696 | 22698004.0 |
| 2009-07-28 13:30:00 | AAPL | Stock | 5.6696 | 5.6925 | 5.6696 | 5.6904 | 20200740.0 |
| 2009-07-28 14:00:00 | AAPL | Stock | 5.6898 | 5.7021 | 5.6768 | 5.6929 | 19749352.0 |
| 2009-07-28 14:30:00 | AAPL | Stock | 5.6925 | 5.718 | 5.6875 | 5.6939 | 37950276.0 |
| 2009-07-28 15:00:00 | AAPL | Stock | 5.6939 | 5.6943 | 5.6718 | 5.6812 | 23974636.0 |
| 2009-07-28 15:30:00 | AAPL | Stock | 5.6814 | 5.7143 | 5.6804 | 5.7139 | 42040124.0 |
| 2009-07-28 16:00:00 | AAPL | Stock | 5.7139 | 5.715 | 5.674 | 5.7125 | 5862024.0 |
| 2009-07-28 16:30:00 | AAPL | Stock | 5.7125 | 5.7154 | 5.6844 | 5.7118 | 244552.0 |
| 2009-07-28 17:00:00 | AAPL | Stock | 5.7118 | 5.7125 | 5.7089 | 5.7093 | 80332.0 |
| 2009-07-28 17:30:00 | AAPL | Stock | 5.6692 | 5.7093 | 5.6692 | 5.7089 | 70420.0 |
| 2009-07-28 18:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.705 | 5.705 | 197540.0 |
| 2009-07-28 18:30:00 | AAPL | Stock | 5.7 | 5.7018 | 5.6975 | 5.698 | 29120.0 |
| 2009-07-28 19:00:00 | AAPL | Stock | 5.6979 | 5.7 | 5.6979 | 5.6979 | 27356.0 |
| 2009-07-28 19:30:00 | AAPL | Stock | 5.6982 | 5.7071 | 5.6786 | 5.7071 | 169316.0 |
| 2009-07-28 07:00:00 | MSFT | Stock | 23.06 | 23.06 | 23.01 | 23.01 | 3000.0 |
| 2009-07-28 07:30:00 | MSFT | Stock | 23.02 | 23.02 | 22.95 | 22.98 | 7630.0 |
| 2009-07-28 08:00:00 | MSFT | Stock | 22.99 | 23.11 | 22.95 | 22.97 | 15436.0 |
| 2009-07-28 08:30:00 | MSFT | Stock | 22.97 | 22.97 | 22.93 | 22.93 | 31756.0 |
| 2009-07-28 09:00:00 | MSFT | Stock | 22.93 | 23.03 | 22.91 | 23.01 | 126334.0 |
| 2009-07-28 09:30:00 | MSFT | Stock | 22.99 | 23.12 | 22.91 | 23.08 | 7573669.0 |
| 2009-07-28 10:00:00 | MSFT | Stock | 23.08 | 23.14 | 22.97 | 23.038 | 5922486.0 |
| 2009-07-28 10:30:00 | MSFT | Stock | 23.04 | 23.11 | 23.0 | 23.035 | 2806068.0 |
| 2009-07-28 11:00:00 | MSFT | Stock | 23.04 | 23.04 | 22.93 | 22.94 | 5406056.0 |
| 2009-07-28 11:30:00 | MSFT | Stock | 22.94 | 23.02 | 22.9 | 23.0 | 3777040.0 |
| 2009-07-28 12:00:00 | MSFT | Stock | 23.005 | 23.05 | 22.97 | 22.972 | 2982170.0 |
| 2009-07-28 12:30:00 | MSFT | Stock | 22.972 | 23.06 | 22.972 | 23.04 | 2120866.0 |
| 2009-07-28 13:00:00 | MSFT | Stock | 23.05 | 23.23 | 23.02 | 23.22 | 5146404.0 |
| 2009-07-28 13:30:00 | MSFT | Stock | 23.22 | 23.39 | 23.215 | 23.35 | 6108687.0 |
| 2009-07-28 14:00:00 | MSFT | Stock | 23.358 | 23.47 | 23.31 | 23.39 | 5130712.0 |
| 2009-07-28 14:30:00 | MSFT | Stock | 23.39 | 23.48 | 23.32 | 23.34 | 4523543.0 |
| 2009-07-28 15:00:00 | MSFT | Stock | 23.33 | 23.395 | 23.3 | 23.33 | 3745933.0 |
| 2009-07-28 15:30:00 | MSFT | Stock | 23.32 | 23.55 | 23.3 | 23.48 | 11568192.0 |
| 2009-07-28 16:00:00 | MSFT | Stock | 23.48 | 23.52 | 22.97 | 23.5 | 2051082.0 |
| 2009-07-28 16:30:00 | MSFT | Stock | 23.5 | 23.5 | 23.307 | 23.5 | 37183.0 |
| 2009-07-28 17:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.45 | 23.45 | 4313.0 |
| 2009-07-28 17:30:00 | MSFT | Stock | 23.053 | 23.48 | 23.053 | 23.42 | 5537.0 |
| 2009-07-28 18:00:00 | MSFT | Stock | 23.47 | 23.47 | 23.42 | 23.42 | 6341.0 |
| 2009-07-28 18:30:00 | MSFT | Stock | 23.42 | 23.52 | 23.42 | 23.5 | 24014.0 |
> showing 50 of 71,710 rows — these rows as CSV