PREVIEW / stock_30min / 2009-08-19
file: by_date/stock_30min/2009/2009-08-19.parquet size: 1.3 MB rows: 70,326 symbols: 3,354
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-19 04:30:00 | AAPL | Stock | 5.79 | 5.79 | 5.79 | 5.79 | 14000.0 |
| 2009-08-19 05:00:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 8400.0 |
| 2009-08-19 05:30:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 8400.0 |
| 2009-08-19 06:00:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7857 | 5.7857 | 30800.0 |
| 2009-08-19 06:30:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8107 | 5.8107 | 3360.0 |
| 2009-08-19 07:00:00 | AAPL | Stock | 5.8061 | 5.8179 | 5.8061 | 5.8068 | 71960.0 |
| 2009-08-19 07:30:00 | AAPL | Stock | 5.8 | 5.8071 | 5.8 | 5.8036 | 261744.0 |
| 2009-08-19 08:00:00 | AAPL | Stock | 5.8036 | 5.8196 | 5.8014 | 5.8018 | 1569680.0 |
| 2009-08-19 08:30:00 | AAPL | Stock | 5.8018 | 5.8136 | 5.8018 | 5.8121 | 756728.0 |
| 2009-08-19 09:00:00 | AAPL | Stock | 5.8107 | 5.8179 | 5.8071 | 5.8143 | 1188600.0 |
| 2009-08-19 09:30:00 | AAPL | Stock | 5.8125 | 5.8636 | 5.8018 | 5.8575 | 70552104.0 |
| 2009-08-19 10:00:00 | AAPL | Stock | 5.8586 | 5.9036 | 5.8575 | 5.8721 | 55434680.0 |
| 2009-08-19 10:30:00 | AAPL | Stock | 5.8721 | 5.8839 | 5.8614 | 5.8679 | 29464260.0 |
| 2009-08-19 11:00:00 | AAPL | Stock | 5.8679 | 5.8732 | 5.8529 | 5.8564 | 18563748.0 |
| 2009-08-19 11:30:00 | AAPL | Stock | 5.8571 | 5.8714 | 5.8457 | 5.8682 | 27073032.0 |
| 2009-08-19 12:00:00 | AAPL | Stock | 5.8686 | 5.8821 | 5.8636 | 5.8671 | 27409956.0 |
| 2009-08-19 12:30:00 | AAPL | Stock | 5.8671 | 5.8779 | 5.8607 | 5.8686 | 20226248.0 |
| 2009-08-19 13:00:00 | AAPL | Stock | 5.8682 | 5.8761 | 5.8643 | 5.8671 | 14535528.0 |
| 2009-08-19 13:30:00 | AAPL | Stock | 5.8671 | 5.8846 | 5.8643 | 5.8846 | 15530648.0 |
| 2009-08-19 14:00:00 | AAPL | Stock | 5.8846 | 5.8886 | 5.8754 | 5.8804 | 14947268.0 |
| 2009-08-19 14:30:00 | AAPL | Stock | 5.8804 | 5.8818 | 5.8683 | 5.8786 | 15577828.0 |
| 2009-08-19 15:00:00 | AAPL | Stock | 5.8786 | 5.8786 | 5.8557 | 5.8628 | 25215064.0 |
| 2009-08-19 15:30:00 | AAPL | Stock | 5.8625 | 5.8789 | 5.8571 | 5.8786 | 38286864.0 |
| 2009-08-19 16:00:00 | AAPL | Stock | 5.8786 | 5.8821 | 5.856 | 5.88 | 27510896.0 |
| 2009-08-19 16:30:00 | AAPL | Stock | 5.88 | 5.8821 | 5.88 | 5.8804 | 153888.0 |
| 2009-08-19 17:00:00 | AAPL | Stock | 5.8804 | 5.8811 | 5.863 | 5.8804 | 95760.0 |
| 2009-08-19 17:30:00 | AAPL | Stock | 5.8804 | 5.8821 | 5.8804 | 5.8818 | 214816.0 |
| 2009-08-19 18:00:00 | AAPL | Stock | 5.8818 | 5.8836 | 5.8786 | 5.8814 | 784812.0 |
| 2009-08-19 18:30:00 | AAPL | Stock | 5.8818 | 5.8818 | 5.8807 | 5.8807 | 30996.0 |
| 2009-08-19 19:00:00 | AAPL | Stock | 5.8789 | 5.8807 | 5.8786 | 5.8804 | 39340.0 |
| 2009-08-19 19:30:00 | AAPL | Stock | 5.8839 | 5.8857 | 5.8789 | 5.8857 | 187992.0 |
| 2009-08-19 07:30:00 | MSFT | Stock | 23.34 | 23.34 | 23.34 | 23.34 | 400.0 |
| 2009-08-19 08:00:00 | MSFT | Stock | 23.36 | 23.39 | 23.24 | 23.24 | 18445.0 |
| 2009-08-19 08:30:00 | MSFT | Stock | 23.25 | 23.33 | 23.21 | 23.25 | 37186.0 |
| 2009-08-19 09:00:00 | MSFT | Stock | 23.32 | 23.34 | 23.25 | 23.26 | 31155.0 |
| 2009-08-19 09:30:00 | MSFT | Stock | 23.27 | 23.385 | 23.25 | 23.35 | 6326000.0 |
| 2009-08-19 10:00:00 | MSFT | Stock | 23.36 | 23.49 | 23.31 | 23.33 | 3661327.0 |
| 2009-08-19 10:30:00 | MSFT | Stock | 23.34 | 23.36 | 23.28 | 23.312 | 3404755.0 |
| 2009-08-19 11:00:00 | MSFT | Stock | 23.309 | 23.36 | 23.29 | 23.311 | 2089624.0 |
| 2009-08-19 11:30:00 | MSFT | Stock | 23.32 | 23.56 | 23.319 | 23.56 | 2852442.0 |
| 2009-08-19 12:00:00 | MSFT | Stock | 23.56 | 23.69 | 23.53 | 23.65 | 3876547.0 |
| 2009-08-19 12:30:00 | MSFT | Stock | 23.65 | 23.705 | 23.65 | 23.65 | 1999417.0 |
| 2009-08-19 13:00:00 | MSFT | Stock | 23.66 | 23.72 | 23.649 | 23.69 | 2101753.0 |
| 2009-08-19 13:30:00 | MSFT | Stock | 23.69 | 23.69 | 23.63 | 23.685 | 1701619.0 |
| 2009-08-19 14:00:00 | MSFT | Stock | 23.69 | 23.71 | 23.63 | 23.7 | 2007831.0 |
| 2009-08-19 14:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.59 | 23.655 | 2092719.0 |
| 2009-08-19 15:00:00 | MSFT | Stock | 23.65 | 23.66 | 23.54 | 23.605 | 2074363.0 |
| 2009-08-19 15:30:00 | MSFT | Stock | 23.6 | 23.67 | 23.473 | 23.65 | 5214247.0 |
| 2009-08-19 16:00:00 | MSFT | Stock | 23.64 | 23.65 | 23.502 | 23.64 | 1720781.0 |
| 2009-08-19 16:30:00 | MSFT | Stock | 23.64 | 23.68 | 23.64 | 23.68 | 3238.0 |
> showing 50 of 70,326 rows — these rows as CSV