PREVIEW / stock_30min / 2013-02-11
file: by_date/stock_30min/2013/2013-02-11.parquet size: 1.4 MB rows: 75,482 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-11 04:00:00 | AAPL | Stock | 17.0393 | 17.0893 | 17.0357 | 17.0893 | 90020.0 |
| 2013-02-11 04:30:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0804 | 17.0804 | 21420.0 |
| 2013-02-11 05:00:00 | AAPL | Stock | 17.0718 | 17.0739 | 17.0536 | 17.0589 | 43400.0 |
| 2013-02-11 05:30:00 | AAPL | Stock | 17.0464 | 17.0689 | 17.0464 | 17.0668 | 16240.0 |
| 2013-02-11 06:00:00 | AAPL | Stock | 17.0689 | 17.0711 | 17.0571 | 17.0571 | 33600.0 |
| 2013-02-11 06:30:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0625 | 17.0696 | 14000.0 |
| 2013-02-11 07:00:00 | AAPL | Stock | 17.0696 | 17.0714 | 17.0321 | 17.0429 | 570528.0 |
| 2013-02-11 07:30:00 | AAPL | Stock | 17.0496 | 17.0639 | 17.0021 | 17.0118 | 545076.0 |
| 2013-02-11 08:00:00 | AAPL | Stock | 17.0096 | 17.0696 | 17.0093 | 17.0329 | 2196040.0 |
| 2013-02-11 08:30:00 | AAPL | Stock | 17.03 | 17.0329 | 16.9636 | 17.0196 | 1951152.0 |
| 2013-02-11 09:00:00 | AAPL | Stock | 17.0186 | 17.0464 | 16.9893 | 17.02 | 3036096.0 |
| 2013-02-11 09:30:00 | AAPL | Stock | 17.0179 | 17.1271 | 16.9018 | 17.1224 | 80648400.0 |
| 2013-02-11 10:00:00 | AAPL | Stock | 17.1185 | 17.2668 | 17.1136 | 17.2507 | 72300368.0 |
| 2013-02-11 10:30:00 | AAPL | Stock | 17.2539 | 17.2768 | 17.2004 | 17.2607 | 47839484.0 |
| 2013-02-11 11:00:00 | AAPL | Stock | 17.2607 | 17.3193 | 17.2243 | 17.245 | 47220460.0 |
| 2013-02-11 11:30:00 | AAPL | Stock | 17.2474 | 17.3068 | 17.2289 | 17.2857 | 21836948.0 |
| 2013-02-11 12:00:00 | AAPL | Stock | 17.2868 | 17.2893 | 17.1979 | 17.2189 | 19553576.0 |
| 2013-02-11 12:30:00 | AAPL | Stock | 17.2189 | 17.2298 | 17.1357 | 17.2011 | 30933112.0 |
| 2013-02-11 13:00:00 | AAPL | Stock | 17.2011 | 17.2246 | 17.1482 | 17.1873 | 19861128.0 |
| 2013-02-11 13:30:00 | AAPL | Stock | 17.1914 | 17.2196 | 17.1611 | 17.1832 | 16921408.0 |
| 2013-02-11 14:00:00 | AAPL | Stock | 17.1846 | 17.2321 | 17.1661 | 17.2111 | 16313724.0 |
| 2013-02-11 14:30:00 | AAPL | Stock | 17.2129 | 17.2254 | 17.13 | 17.1341 | 20040552.0 |
| 2013-02-11 15:00:00 | AAPL | Stock | 17.1339 | 17.1696 | 17.0825 | 17.1482 | 33633936.0 |
| 2013-02-11 15:30:00 | AAPL | Stock | 17.15 | 17.2107 | 17.1246 | 17.141 | 41038452.0 |
| 2013-02-11 16:00:00 | AAPL | Stock | 17.1404 | 17.1837 | 17.0186 | 17.0536 | 19480272.0 |
| 2013-02-11 16:30:00 | AAPL | Stock | 17.0618 | 17.1474 | 17.0571 | 17.0679 | 1060304.0 |
| 2013-02-11 17:00:00 | AAPL | Stock | 17.0646 | 17.105 | 17.0646 | 17.0896 | 897204.0 |
| 2013-02-11 17:30:00 | AAPL | Stock | 17.0964 | 17.1 | 17.0861 | 17.0861 | 80500.0 |
| 2013-02-11 18:00:00 | AAPL | Stock | 17.0861 | 17.0957 | 17.0721 | 17.0832 | 262360.0 |
| 2013-02-11 18:30:00 | AAPL | Stock | 17.0886 | 17.0886 | 17.0679 | 17.0689 | 711116.0 |
| 2013-02-11 19:00:00 | AAPL | Stock | 17.0746 | 17.0775 | 17.0682 | 17.0696 | 135632.0 |
| 2013-02-11 19:30:00 | AAPL | Stock | 17.0679 | 17.0714 | 17.0568 | 17.0568 | 207256.0 |
| 2013-02-11 07:00:00 | MSFT | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 200.0 |
| 2013-02-11 07:30:00 | MSFT | Stock | 27.6 | 27.68 | 27.6 | 27.68 | 2505.0 |
| 2013-02-11 08:00:00 | MSFT | Stock | 27.67 | 27.68 | 27.53 | 27.67 | 9141.0 |
| 2013-02-11 08:30:00 | MSFT | Stock | 27.65 | 27.67 | 27.55 | 27.66 | 52093.0 |
| 2013-02-11 09:00:00 | MSFT | Stock | 27.65 | 27.68 | 27.62 | 27.64 | 18500.0 |
| 2013-02-11 09:30:00 | MSFT | Stock | 27.65 | 27.71 | 27.5 | 27.53 | 2977008.0 |
| 2013-02-11 10:00:00 | MSFT | Stock | 27.54 | 27.62 | 27.53 | 27.6 | 2971396.0 |
| 2013-02-11 10:30:00 | MSFT | Stock | 27.605 | 27.695 | 27.565 | 27.69 | 2579796.0 |
| 2013-02-11 11:00:00 | MSFT | Stock | 27.7 | 27.785 | 27.69 | 27.73 | 2797235.0 |
| 2013-02-11 11:30:00 | MSFT | Stock | 27.73 | 27.74 | 27.7 | 27.725 | 1484053.0 |
| 2013-02-11 12:00:00 | MSFT | Stock | 27.72 | 27.74 | 27.68 | 27.714 | 1460004.0 |
| 2013-02-11 12:30:00 | MSFT | Stock | 27.715 | 27.729 | 27.675 | 27.7 | 1740630.0 |
| 2013-02-11 13:00:00 | MSFT | Stock | 27.7 | 27.73 | 27.67 | 27.69 | 1163769.0 |
| 2013-02-11 13:30:00 | MSFT | Stock | 27.685 | 27.73 | 27.68 | 27.73 | 1340999.0 |
| 2013-02-11 14:00:00 | MSFT | Stock | 27.725 | 27.78 | 27.71 | 27.77 | 1613100.0 |
| 2013-02-11 14:30:00 | MSFT | Stock | 27.77 | 27.78 | 27.745 | 27.77 | 1443786.0 |
| 2013-02-11 15:00:00 | MSFT | Stock | 27.769 | 27.88 | 27.75 | 27.86 | 3718508.0 |
| 2013-02-11 15:30:00 | MSFT | Stock | 27.86 | 27.92 | 27.84 | 27.85 | 5660797.0 |
> showing 50 of 75,482 rows — these rows as CSV