PREVIEW / stock_30min / 2009-08-24
file: by_date/stock_30min/2009/2009-08-24.parquet size: 1.3 MB rows: 71,070 symbols: 3,390
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-08-24 04:00:00 | AAPL | Stock | 6.0482 | 6.0714 | 6.0482 | 6.0714 | 7560.0 |
| 2009-08-24 07:00:00 | AAPL | Stock | 6.0679 | 6.0714 | 6.0679 | 6.0679 | 108080.0 |
| 2009-08-24 07:30:00 | AAPL | Stock | 6.0643 | 6.0761 | 6.0643 | 6.0761 | 94108.0 |
| 2009-08-24 08:00:00 | AAPL | Stock | 6.0718 | 6.0882 | 6.0643 | 6.0804 | 1695288.0 |
| 2009-08-24 08:30:00 | AAPL | Stock | 6.0804 | 6.0839 | 6.0679 | 6.0814 | 716436.0 |
| 2009-08-24 09:00:00 | AAPL | Stock | 6.0821 | 6.0875 | 6.0714 | 6.0739 | 1325156.0 |
| 2009-08-24 09:30:00 | AAPL | Stock | 6.0757 | 6.0786 | 6.025 | 6.071 | 94252676.0 |
| 2009-08-24 10:00:00 | AAPL | Stock | 6.07 | 6.0968 | 6.0686 | 6.0871 | 43427356.0 |
| 2009-08-24 10:30:00 | AAPL | Stock | 6.0875 | 6.0893 | 6.0782 | 6.0849 | 22055768.0 |
| 2009-08-24 11:00:00 | AAPL | Stock | 6.0854 | 6.095 | 6.08 | 6.0836 | 17942792.0 |
| 2009-08-24 11:30:00 | AAPL | Stock | 6.0839 | 6.0846 | 6.0661 | 6.0668 | 16959460.0 |
| 2009-08-24 12:00:00 | AAPL | Stock | 6.0668 | 6.0714 | 6.0546 | 6.0625 | 19282536.0 |
| 2009-08-24 12:30:00 | AAPL | Stock | 6.0639 | 6.0704 | 6.0575 | 6.0632 | 11146016.0 |
| 2009-08-24 13:00:00 | AAPL | Stock | 6.0632 | 6.065 | 6.0332 | 6.0369 | 28946792.0 |
| 2009-08-24 13:30:00 | AAPL | Stock | 6.0364 | 6.0539 | 6.0361 | 6.0386 | 15742972.0 |
| 2009-08-24 14:00:00 | AAPL | Stock | 6.0386 | 6.0607 | 6.0368 | 6.0532 | 16875768.0 |
| 2009-08-24 14:30:00 | AAPL | Stock | 6.0536 | 6.0579 | 6.0446 | 6.05 | 11670988.0 |
| 2009-08-24 15:00:00 | AAPL | Stock | 6.0496 | 6.0893 | 6.0189 | 6.0411 | 30159696.0 |
| 2009-08-24 15:30:00 | AAPL | Stock | 6.04 | 6.05 | 6.0096 | 6.0429 | 47753748.0 |
| 2009-08-24 16:00:00 | AAPL | Stock | 6.0393 | 6.0569 | 6.0236 | 6.0304 | 13335616.0 |
| 2009-08-24 16:30:00 | AAPL | Stock | 6.0304 | 6.0339 | 6.0214 | 6.0232 | 327600.0 |
| 2009-08-24 17:00:00 | AAPL | Stock | 6.0214 | 6.0214 | 6.0179 | 6.0179 | 178080.0 |
| 2009-08-24 17:30:00 | AAPL | Stock | 6.0179 | 6.0261 | 6.0179 | 6.0229 | 212576.0 |
| 2009-08-24 18:00:00 | AAPL | Stock | 6.0379 | 6.0379 | 6.0179 | 6.0196 | 305928.0 |
| 2009-08-24 18:30:00 | AAPL | Stock | 6.0243 | 6.0261 | 6.0243 | 6.0243 | 23800.0 |
| 2009-08-24 19:00:00 | AAPL | Stock | 6.0239 | 6.0239 | 6.0196 | 6.0196 | 36176.0 |
| 2009-08-24 19:30:00 | AAPL | Stock | 6.0196 | 6.0229 | 6.0082 | 6.0111 | 198856.0 |
| 2009-08-24 04:30:00 | MSFT | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 700.0 |
| 2009-08-24 08:00:00 | MSFT | Stock | 24.42 | 24.5 | 24.32 | 24.47 | 12108.0 |
| 2009-08-24 08:30:00 | MSFT | Stock | 24.47 | 24.5 | 24.44 | 24.49 | 14810.0 |
| 2009-08-24 09:00:00 | MSFT | Stock | 24.46 | 24.48 | 24.29 | 24.41 | 43925.0 |
| 2009-08-24 09:30:00 | MSFT | Stock | 24.41 | 24.6 | 24.28 | 24.53 | 7768121.0 |
| 2009-08-24 10:00:00 | MSFT | Stock | 24.53 | 24.68 | 24.51 | 24.655 | 4653049.0 |
| 2009-08-24 10:30:00 | MSFT | Stock | 24.655 | 24.67 | 24.61 | 24.641 | 4484240.0 |
| 2009-08-24 11:00:00 | MSFT | Stock | 24.65 | 24.68 | 24.6 | 24.658 | 2128416.0 |
| 2009-08-24 11:30:00 | MSFT | Stock | 24.66 | 24.66 | 24.62 | 24.64 | 2163250.0 |
| 2009-08-24 12:00:00 | MSFT | Stock | 24.64 | 24.67 | 24.63 | 24.65 | 1867362.0 |
| 2009-08-24 12:30:00 | MSFT | Stock | 24.65 | 24.69 | 24.64 | 24.65 | 2804631.0 |
| 2009-08-24 13:00:00 | MSFT | Stock | 24.65 | 24.67 | 24.51 | 24.543 | 5509936.0 |
| 2009-08-24 13:30:00 | MSFT | Stock | 24.54 | 24.66 | 24.52 | 24.64 | 2665184.0 |
| 2009-08-24 14:00:00 | MSFT | Stock | 24.64 | 24.65 | 24.58 | 24.58 | 1326112.0 |
| 2009-08-24 14:30:00 | MSFT | Stock | 24.58 | 24.61 | 24.5 | 24.56 | 2770575.0 |
| 2009-08-24 15:00:00 | MSFT | Stock | 24.56 | 24.65 | 24.49 | 24.615 | 3965401.0 |
| 2009-08-24 15:30:00 | MSFT | Stock | 24.61 | 24.68 | 24.59 | 24.66 | 9611050.0 |
| 2009-08-24 16:00:00 | MSFT | Stock | 24.64 | 24.67 | 24.52 | 24.52 | 1195766.0 |
| 2009-08-24 16:30:00 | MSFT | Stock | 24.598 | 24.63 | 24.598 | 24.6 | 42055.0 |
| 2009-08-24 17:00:00 | MSFT | Stock | 24.6 | 24.6 | 24.6 | 24.6 | 1600.0 |
| 2009-08-24 18:00:00 | MSFT | Stock | 24.64 | 24.64 | 24.61 | 24.61 | 13679.0 |
| 2009-08-24 19:00:00 | MSFT | Stock | 24.6 | 24.6 | 24.6 | 24.6 | 100.0 |
| 2009-08-24 19:30:00 | MSFT | Stock | 24.6 | 24.67 | 24.6 | 24.65 | 7815.0 |
> showing 50 of 71,070 rows — these rows as CSV