PREVIEW / stock_30min / 2009-06-16
file: by_date/stock_30min/2009/2009-06-16.parquet size: 1.3 MB rows: 71,815 symbols: 3,338
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-06-16 05:00:00 | AAPL | Stock | 4.8771 | 4.8771 | 4.8725 | 4.8725 | 28000.0 |
| 2009-06-16 05:30:00 | AAPL | Stock | 4.8725 | 4.8725 | 4.87 | 4.87 | 8400.0 |
| 2009-06-16 06:00:00 | AAPL | Stock | 4.8654 | 4.8654 | 4.8654 | 4.8654 | 5600.0 |
| 2009-06-16 06:30:00 | AAPL | Stock | 4.8632 | 4.8643 | 4.8571 | 4.8571 | 47600.0 |
| 2009-06-16 07:00:00 | AAPL | Stock | 4.8679 | 4.8875 | 4.8643 | 4.8768 | 110600.0 |
| 2009-06-16 07:30:00 | AAPL | Stock | 4.8732 | 4.8732 | 4.8607 | 4.8721 | 26600.0 |
| 2009-06-16 08:00:00 | AAPL | Stock | 4.8679 | 4.875 | 4.8575 | 4.8696 | 412132.0 |
| 2009-06-16 08:30:00 | AAPL | Stock | 4.8714 | 4.8911 | 4.8696 | 4.8846 | 866040.0 |
| 2009-06-16 09:00:00 | AAPL | Stock | 4.8839 | 4.8964 | 4.8804 | 4.8804 | 1045940.0 |
| 2009-06-16 09:30:00 | AAPL | Stock | 4.8811 | 4.9234 | 4.8607 | 4.9118 | 86873584.0 |
| 2009-06-16 10:00:00 | AAPL | Stock | 4.9114 | 4.9193 | 4.8864 | 4.9061 | 45465140.0 |
| 2009-06-16 10:30:00 | AAPL | Stock | 4.9061 | 4.93 | 4.9004 | 4.92 | 38216920.0 |
| 2009-06-16 11:00:00 | AAPL | Stock | 4.92 | 4.9454 | 4.9193 | 4.9397 | 35514976.0 |
| 2009-06-16 11:30:00 | AAPL | Stock | 4.9396 | 4.9446 | 4.9264 | 4.9307 | 27253296.0 |
| 2009-06-16 12:00:00 | AAPL | Stock | 4.9311 | 4.9432 | 4.925 | 4.9364 | 22627248.0 |
| 2009-06-16 12:30:00 | AAPL | Stock | 4.9361 | 4.9368 | 4.8929 | 4.9032 | 43593032.0 |
| 2009-06-16 13:00:00 | AAPL | Stock | 4.9036 | 4.9043 | 4.8864 | 4.9001 | 21850556.0 |
| 2009-06-16 13:30:00 | AAPL | Stock | 4.9004 | 4.9168 | 4.8968 | 4.9071 | 25226152.0 |
| 2009-06-16 14:00:00 | AAPL | Stock | 4.9061 | 4.9132 | 4.8843 | 4.8864 | 30764328.0 |
| 2009-06-16 14:30:00 | AAPL | Stock | 4.8864 | 4.9089 | 4.8821 | 4.9 | 30712500.0 |
| 2009-06-16 15:00:00 | AAPL | Stock | 4.9004 | 4.9121 | 4.8886 | 4.8936 | 35624596.0 |
| 2009-06-16 15:30:00 | AAPL | Stock | 4.8942 | 4.9036 | 4.8675 | 4.8696 | 48570396.0 |
| 2009-06-16 16:00:00 | AAPL | Stock | 4.8696 | 4.9076 | 4.8679 | 4.8696 | 7575932.0 |
| 2009-06-16 16:30:00 | AAPL | Stock | 4.8704 | 4.9404 | 4.8679 | 4.8725 | 737996.0 |
| 2009-06-16 17:00:00 | AAPL | Stock | 4.8704 | 4.8729 | 4.8679 | 4.8679 | 229432.0 |
| 2009-06-16 17:30:00 | AAPL | Stock | 4.8689 | 4.8725 | 4.8682 | 4.8704 | 126308.0 |
| 2009-06-16 18:00:00 | AAPL | Stock | 4.8725 | 4.8768 | 4.8696 | 4.8711 | 152152.0 |
| 2009-06-16 18:30:00 | AAPL | Stock | 4.8725 | 4.8732 | 4.87 | 4.87 | 53704.0 |
| 2009-06-16 19:00:00 | AAPL | Stock | 4.8704 | 4.8732 | 4.8704 | 4.8732 | 11200.0 |
| 2009-06-16 19:30:00 | AAPL | Stock | 4.8707 | 4.8721 | 4.8707 | 4.8721 | 17920.0 |
| 2009-06-16 07:00:00 | MSFT | Stock | 23.4 | 23.41 | 23.4 | 23.41 | 3450.0 |
| 2009-06-16 07:30:00 | MSFT | Stock | 23.49 | 23.54 | 23.48 | 23.54 | 9000.0 |
| 2009-06-16 08:00:00 | MSFT | Stock | 23.5 | 23.53 | 23.45 | 23.45 | 15700.0 |
| 2009-06-16 08:30:00 | MSFT | Stock | 23.48 | 23.53 | 23.46 | 23.5 | 34724.0 |
| 2009-06-16 09:00:00 | MSFT | Stock | 23.5 | 23.54 | 23.5 | 23.54 | 36539.0 |
| 2009-06-16 09:30:00 | MSFT | Stock | 23.52 | 23.94 | 23.47 | 23.85 | 12694928.0 |
| 2009-06-16 10:00:00 | MSFT | Stock | 23.852 | 23.95 | 23.79 | 23.87 | 10637303.0 |
| 2009-06-16 10:30:00 | MSFT | Stock | 23.87 | 23.94 | 23.82 | 23.908 | 7914190.0 |
| 2009-06-16 11:00:00 | MSFT | Stock | 23.905 | 24.11 | 23.9 | 24.05 | 11237743.0 |
| 2009-06-16 11:30:00 | MSFT | Stock | 24.05 | 24.1 | 23.8 | 23.81 | 7140121.0 |
| 2009-06-16 12:00:00 | MSFT | Stock | 23.808 | 23.96 | 23.77 | 23.8 | 6881026.0 |
| 2009-06-16 12:30:00 | MSFT | Stock | 23.79 | 23.81 | 23.71 | 23.77 | 6322526.0 |
| 2009-06-16 13:00:00 | MSFT | Stock | 23.768 | 23.84 | 23.69 | 23.73 | 4352391.0 |
| 2009-06-16 13:30:00 | MSFT | Stock | 23.73 | 23.74 | 23.64 | 23.7 | 4620817.0 |
| 2009-06-16 14:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.53 | 23.55 | 5056130.0 |
| 2009-06-16 14:30:00 | MSFT | Stock | 23.55 | 23.66 | 23.51 | 23.65 | 3832177.0 |
| 2009-06-16 15:00:00 | MSFT | Stock | 23.64 | 23.68 | 23.55 | 23.63 | 4468719.0 |
| 2009-06-16 15:30:00 | MSFT | Stock | 23.64 | 23.73 | 23.44 | 23.45 | 12819903.0 |
| 2009-06-16 16:00:00 | MSFT | Stock | 23.44 | 23.778 | 23.43 | 23.45 | 3040404.0 |
| 2009-06-16 16:30:00 | MSFT | Stock | 24.005 | 24.005 | 23.43 | 23.47 | 411005.0 |
> showing 50 of 71,815 rows — these rows as CSV