PREVIEW / stock_30min / 2008-07-18
file: by_date/stock_30min/2008/2008-07-18.parquet size: 1.2 MB rows: 68,681 symbols: 3,315
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-18 06:30:00 | AAPL | Stock | 6.0596 | 6.0714 | 6.0596 | 6.0714 | 7000.0 |
| 2008-07-18 07:00:00 | AAPL | Stock | 6.0536 | 6.0546 | 6.01 | 6.05 | 254660.0 |
| 2008-07-18 07:30:00 | AAPL | Stock | 6.07 | 6.07 | 6.0357 | 6.0429 | 492800.0 |
| 2008-07-18 08:00:00 | AAPL | Stock | 6.0389 | 6.0707 | 6.0182 | 6.07 | 2293816.0 |
| 2008-07-18 08:30:00 | AAPL | Stock | 6.0682 | 6.0696 | 6.0429 | 6.0554 | 2353148.0 |
| 2008-07-18 09:00:00 | AAPL | Stock | 6.0521 | 6.0571 | 6.0082 | 6.0107 | 2439472.0 |
| 2008-07-18 09:30:00 | AAPL | Stock | 6.0107 | 6.0589 | 5.9814 | 6.0082 | 161098952.0 |
| 2008-07-18 10:00:00 | AAPL | Stock | 6.0093 | 6.0407 | 6.0018 | 6.0218 | 46444244.0 |
| 2008-07-18 10:30:00 | AAPL | Stock | 6.0218 | 6.03 | 5.9925 | 5.9986 | 59954160.0 |
| 2008-07-18 11:00:00 | AAPL | Stock | 5.9989 | 6.0311 | 5.9854 | 6.0162 | 56963816.0 |
| 2008-07-18 11:30:00 | AAPL | Stock | 6.0161 | 6.0332 | 5.9971 | 6.0 | 36076264.0 |
| 2008-07-18 12:00:00 | AAPL | Stock | 6.0 | 6.005 | 5.9625 | 5.9654 | 53655224.0 |
| 2008-07-18 12:30:00 | AAPL | Stock | 5.9654 | 5.9679 | 5.9286 | 5.9339 | 67402440.0 |
| 2008-07-18 13:00:00 | AAPL | Stock | 5.9336 | 5.9457 | 5.9107 | 5.9186 | 59462592.0 |
| 2008-07-18 13:30:00 | AAPL | Stock | 5.9182 | 5.9546 | 5.9107 | 5.9343 | 45876124.0 |
| 2008-07-18 14:00:00 | AAPL | Stock | 5.9343 | 5.9525 | 5.9096 | 5.9411 | 42305956.0 |
| 2008-07-18 14:30:00 | AAPL | Stock | 5.9404 | 5.9436 | 5.9171 | 5.93 | 35578620.0 |
| 2008-07-18 15:00:00 | AAPL | Stock | 5.9289 | 5.9449 | 5.9111 | 5.9161 | 49287224.0 |
| 2008-07-18 15:30:00 | AAPL | Stock | 5.9161 | 5.9371 | 5.8929 | 5.9018 | 102493524.0 |
| 2008-07-18 16:00:00 | AAPL | Stock | 5.9004 | 5.9704 | 5.8868 | 5.8946 | 15671068.0 |
| 2008-07-18 16:30:00 | AAPL | Stock | 5.8932 | 5.9196 | 5.8921 | 5.8946 | 3117240.0 |
| 2008-07-18 17:00:00 | AAPL | Stock | 5.8943 | 5.9071 | 5.8932 | 5.9025 | 978460.0 |
| 2008-07-18 17:30:00 | AAPL | Stock | 5.9036 | 5.9368 | 5.8982 | 5.9321 | 5051956.0 |
| 2008-07-18 18:00:00 | AAPL | Stock | 5.9321 | 5.9346 | 5.9214 | 5.9218 | 267428.0 |
| 2008-07-18 18:30:00 | AAPL | Stock | 5.9254 | 5.9254 | 5.9161 | 5.9179 | 98140.0 |
| 2008-07-18 19:00:00 | AAPL | Stock | 5.9221 | 5.9282 | 5.9186 | 5.9189 | 101500.0 |
| 2008-07-18 19:30:00 | AAPL | Stock | 5.9232 | 5.9232 | 5.9114 | 5.9114 | 218456.0 |
| 2008-07-18 05:00:00 | MSFT | Stock | 25.92 | 25.92 | 25.91 | 25.91 | 1500.0 |
| 2008-07-18 06:30:00 | MSFT | Stock | 26.01 | 26.22 | 26.01 | 26.01 | 4800.0 |
| 2008-07-18 07:00:00 | MSFT | Stock | 26.01 | 26.1 | 25.86 | 26.1 | 127461.0 |
| 2008-07-18 07:30:00 | MSFT | Stock | 26.1 | 26.25 | 26.05 | 26.15 | 125313.0 |
| 2008-07-18 08:00:00 | MSFT | Stock | 26.15 | 26.33 | 26.05 | 26.21 | 284543.0 |
| 2008-07-18 08:30:00 | MSFT | Stock | 26.21 | 26.22 | 26.01 | 26.22 | 390707.0 |
| 2008-07-18 09:00:00 | MSFT | Stock | 26.22 | 26.36 | 26.15 | 26.36 | 484271.0 |
| 2008-07-18 09:30:00 | MSFT | Stock | 26.35 | 26.47 | 25.63 | 25.78 | 35097497.0 |
| 2008-07-18 10:00:00 | MSFT | Stock | 25.773 | 25.78 | 25.25 | 25.338 | 17572766.0 |
| 2008-07-18 10:30:00 | MSFT | Stock | 25.34 | 25.878 | 25.11 | 25.31 | 15841953.0 |
| 2008-07-18 11:00:00 | MSFT | Stock | 25.31 | 25.64 | 25.31 | 25.54 | 8525369.0 |
| 2008-07-18 11:30:00 | MSFT | Stock | 25.53 | 25.62 | 25.44 | 25.49 | 6761988.0 |
| 2008-07-18 12:00:00 | MSFT | Stock | 25.49 | 25.5 | 25.36 | 25.41 | 5064894.0 |
| 2008-07-18 12:30:00 | MSFT | Stock | 25.42 | 25.51 | 25.37 | 25.41 | 4971756.0 |
| 2008-07-18 13:00:00 | MSFT | Stock | 25.41 | 25.56 | 25.41 | 25.552 | 5413583.0 |
| 2008-07-18 13:30:00 | MSFT | Stock | 25.559 | 25.74 | 25.54 | 25.63 | 7856521.0 |
| 2008-07-18 14:00:00 | MSFT | Stock | 25.62 | 25.71 | 25.56 | 25.64 | 3491829.0 |
| 2008-07-18 14:30:00 | MSFT | Stock | 25.63 | 25.76 | 25.57 | 25.663 | 5875887.0 |
| 2008-07-18 15:00:00 | MSFT | Stock | 25.66 | 25.69 | 25.55 | 25.6 | 5290998.0 |
| 2008-07-18 15:30:00 | MSFT | Stock | 25.59 | 25.91 | 25.59 | 25.89 | 16181315.0 |
| 2008-07-18 16:00:00 | MSFT | Stock | 25.86 | 25.9 | 25.4 | 25.87 | 6201887.0 |
| 2008-07-18 16:30:00 | MSFT | Stock | 25.87 | 25.87 | 25.744 | 25.8 | 371794.0 |
| 2008-07-18 17:00:00 | MSFT | Stock | 25.86 | 25.88 | 25.734 | 25.734 | 83459.0 |
> showing 50 of 68,681 rows — these rows as CSV