PREVIEW / stock_30min / 2009-02-25
file: by_date/stock_30min/2009/2009-02-25.parquet size: 1.3 MB rows: 71,110 symbols: 3,309
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-02-25 06:30:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 5600.0 |
| 2009-02-25 07:00:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.1964 | 3.1964 | 5964.0 |
| 2009-02-25 07:30:00 | AAPL | Stock | 3.1807 | 3.2143 | 3.1807 | 3.2143 | 28000.0 |
| 2009-02-25 08:00:00 | AAPL | Stock | 3.2143 | 3.2232 | 3.2143 | 3.2232 | 60200.0 |
| 2009-02-25 08:30:00 | AAPL | Stock | 3.2179 | 3.2232 | 3.215 | 3.2164 | 177436.0 |
| 2009-02-25 09:00:00 | AAPL | Stock | 3.2196 | 3.2286 | 3.2029 | 3.2089 | 1034544.0 |
| 2009-02-25 09:30:00 | AAPL | Stock | 3.2136 | 3.2679 | 3.205 | 3.2393 | 90591620.0 |
| 2009-02-25 10:00:00 | AAPL | Stock | 3.2396 | 3.2404 | 3.1875 | 3.2146 | 71775452.0 |
| 2009-02-25 10:30:00 | AAPL | Stock | 3.215 | 3.25 | 3.1993 | 3.2286 | 77005012.0 |
| 2009-02-25 11:00:00 | AAPL | Stock | 3.2282 | 3.2657 | 3.2218 | 3.259 | 45762024.0 |
| 2009-02-25 11:30:00 | AAPL | Stock | 3.2586 | 3.2893 | 3.245 | 3.26 | 61922784.0 |
| 2009-02-25 12:00:00 | AAPL | Stock | 3.2596 | 3.265 | 3.2404 | 3.2454 | 30805656.0 |
| 2009-02-25 12:30:00 | AAPL | Stock | 3.2461 | 3.2582 | 3.2282 | 3.2479 | 26193188.0 |
| 2009-02-25 13:00:00 | AAPL | Stock | 3.2471 | 3.2664 | 3.2429 | 3.2504 | 29588580.0 |
| 2009-02-25 13:30:00 | AAPL | Stock | 3.2511 | 3.2914 | 3.2471 | 3.2816 | 43784132.0 |
| 2009-02-25 14:00:00 | AAPL | Stock | 3.2807 | 3.2871 | 3.2461 | 3.2768 | 67675524.0 |
| 2009-02-25 14:30:00 | AAPL | Stock | 3.2764 | 3.2911 | 3.2711 | 3.2768 | 42592620.0 |
| 2009-02-25 15:00:00 | AAPL | Stock | 3.2768 | 3.3186 | 3.2718 | 3.3121 | 66514364.0 |
| 2009-02-25 15:30:00 | AAPL | Stock | 3.3129 | 3.3186 | 3.2525 | 3.2525 | 93548280.0 |
| 2009-02-25 16:00:00 | AAPL | Stock | 3.2579 | 3.2803 | 3.25 | 3.2539 | 19948628.0 |
| 2009-02-25 16:30:00 | AAPL | Stock | 3.2511 | 3.2607 | 3.2511 | 3.2536 | 197232.0 |
| 2009-02-25 17:00:00 | AAPL | Stock | 3.2771 | 3.2771 | 3.2557 | 3.2714 | 39057620.0 |
| 2009-02-25 17:30:00 | AAPL | Stock | 3.2682 | 3.2682 | 3.2571 | 3.2625 | 92400.0 |
| 2009-02-25 18:00:00 | AAPL | Stock | 3.2589 | 3.2607 | 3.2557 | 3.2607 | 15568280.0 |
| 2009-02-25 18:30:00 | AAPL | Stock | 3.2607 | 3.2607 | 3.2607 | 3.2607 | 5600.0 |
| 2009-02-25 19:00:00 | AAPL | Stock | 3.26 | 3.2607 | 3.2589 | 3.2607 | 186536.0 |
| 2009-02-25 19:30:00 | AAPL | Stock | 3.2654 | 3.2654 | 3.2625 | 3.2625 | 63000.0 |
| 2009-02-25 07:00:00 | MSFT | Stock | 17.12 | 17.13 | 17.12 | 17.13 | 200.0 |
| 2009-02-25 08:00:00 | MSFT | Stock | 17.12 | 17.13 | 17.03 | 17.03 | 17827.0 |
| 2009-02-25 08:30:00 | MSFT | Stock | 17.1 | 17.12 | 17.05 | 17.1 | 30410.0 |
| 2009-02-25 09:00:00 | MSFT | Stock | 17.11 | 17.17 | 17.0 | 17.01 | 67685.0 |
| 2009-02-25 09:30:00 | MSFT | Stock | 17.01 | 17.03 | 16.77 | 16.9 | 9391309.0 |
| 2009-02-25 10:00:00 | MSFT | Stock | 16.9 | 16.9 | 16.54 | 16.738 | 9822573.0 |
| 2009-02-25 10:30:00 | MSFT | Stock | 16.73 | 16.74 | 16.46 | 16.62 | 5673250.0 |
| 2009-02-25 11:00:00 | MSFT | Stock | 16.62 | 16.8 | 16.6 | 16.779 | 4560433.0 |
| 2009-02-25 11:30:00 | MSFT | Stock | 16.78 | 16.89 | 16.74 | 16.76 | 4834673.0 |
| 2009-02-25 12:00:00 | MSFT | Stock | 16.76 | 16.81 | 16.72 | 16.733 | 3933354.0 |
| 2009-02-25 12:30:00 | MSFT | Stock | 16.73 | 16.8 | 16.71 | 16.79 | 4379804.0 |
| 2009-02-25 13:00:00 | MSFT | Stock | 16.798 | 16.9 | 16.78 | 16.823 | 3770013.0 |
| 2009-02-25 13:30:00 | MSFT | Stock | 16.822 | 17.08 | 16.82 | 17.02 | 5088025.0 |
| 2009-02-25 14:00:00 | MSFT | Stock | 17.01 | 17.06 | 16.78 | 16.98 | 5659390.0 |
| 2009-02-25 14:30:00 | MSFT | Stock | 16.98 | 17.03 | 16.88 | 16.93 | 3877690.0 |
| 2009-02-25 15:00:00 | MSFT | Stock | 16.93 | 17.2 | 16.89 | 17.175 | 6772294.0 |
| 2009-02-25 15:30:00 | MSFT | Stock | 17.18 | 17.24 | 16.84 | 16.84 | 13299999.0 |
| 2009-02-25 16:00:00 | MSFT | Stock | 16.85 | 17.0 | 16.785 | 16.9 | 13138871.0 |
| 2009-02-25 16:30:00 | MSFT | Stock | 16.9 | 16.961 | 16.9 | 16.908 | 6550524.0 |
| 2009-02-25 17:00:00 | MSFT | Stock | 16.94 | 16.96 | 16.94 | 16.96 | 743.0 |
| 2009-02-25 17:30:00 | MSFT | Stock | 16.96 | 16.96 | 16.91 | 16.91 | 9053.0 |
| 2009-02-25 18:00:00 | MSFT | Stock | 16.98 | 16.98 | 16.95 | 16.95 | 1600.0 |
| 2009-02-25 18:30:00 | MSFT | Stock | 16.95 | 16.95 | 16.95 | 16.95 | 77070.0 |
> showing 50 of 71,110 rows — these rows as CSV