PREVIEW / stock_30min / 2009-02-13
file: by_date/stock_30min/2009/2009-02-13.parquet size: 1.2 MB rows: 65,294 symbols: 3,317
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-13 05:00:00 | AAPL | Stock | 3.5589 | 3.5589 | 3.5589 | 3.5589 | 2800.0 |
| 2009-02-13 05:30:00 | AAPL | Stock | 3.5693 | 3.5693 | 3.5693 | 3.5693 | 2800.0 |
| 2009-02-13 06:00:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 2800.0 |
| 2009-02-13 07:00:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5571 | 3.5571 | 11200.0 |
| 2009-02-13 07:30:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 2800.0 |
| 2009-02-13 08:00:00 | AAPL | Stock | 3.5554 | 3.5554 | 3.5111 | 3.5461 | 711088.0 |
| 2009-02-13 08:30:00 | AAPL | Stock | 3.5461 | 3.5507 | 3.5321 | 3.5357 | 486808.0 |
| 2009-02-13 09:00:00 | AAPL | Stock | 3.5343 | 3.5429 | 3.5246 | 3.5421 | 818244.0 |
| 2009-02-13 09:30:00 | AAPL | Stock | 3.5354 | 3.5536 | 3.5043 | 3.5264 | 70278348.0 |
| 2009-02-13 10:00:00 | AAPL | Stock | 3.5264 | 3.5386 | 3.5107 | 3.5375 | 62829200.0 |
| 2009-02-13 10:30:00 | AAPL | Stock | 3.5371 | 3.5568 | 3.535 | 3.5514 | 56096572.0 |
| 2009-02-13 11:00:00 | AAPL | Stock | 3.5507 | 3.5518 | 3.5307 | 3.5414 | 49118104.0 |
| 2009-02-13 11:30:00 | AAPL | Stock | 3.5418 | 3.5543 | 3.5318 | 3.5329 | 39663792.0 |
| 2009-02-13 12:00:00 | AAPL | Stock | 3.5325 | 3.5479 | 3.5293 | 3.5461 | 32270896.0 |
| 2009-02-13 12:30:00 | AAPL | Stock | 3.5461 | 3.5475 | 3.5211 | 3.5268 | 26022108.0 |
| 2009-02-13 13:00:00 | AAPL | Stock | 3.5261 | 3.5454 | 3.5196 | 3.5435 | 29148868.0 |
| 2009-02-13 13:30:00 | AAPL | Stock | 3.5436 | 3.5629 | 3.5389 | 3.5575 | 40651128.0 |
| 2009-02-13 14:00:00 | AAPL | Stock | 3.5582 | 3.5625 | 3.5454 | 3.5507 | 32741436.0 |
| 2009-02-13 14:30:00 | AAPL | Stock | 3.5507 | 3.5643 | 3.5411 | 3.5579 | 36963304.0 |
| 2009-02-13 15:00:00 | AAPL | Stock | 3.5586 | 3.5693 | 3.5393 | 3.5536 | 54253108.0 |
| 2009-02-13 15:30:00 | AAPL | Stock | 3.5539 | 3.5657 | 3.5368 | 3.54 | 61949412.0 |
| 2009-02-13 16:00:00 | AAPL | Stock | 3.5418 | 3.5479 | 3.5379 | 3.5446 | 6896792.0 |
| 2009-02-13 16:30:00 | AAPL | Stock | 3.5429 | 3.5429 | 3.5375 | 3.5429 | 174188.0 |
| 2009-02-13 17:00:00 | AAPL | Stock | 3.5414 | 3.5429 | 3.5414 | 3.5429 | 11200.0 |
| 2009-02-13 17:30:00 | AAPL | Stock | 3.5421 | 3.5421 | 3.5393 | 3.5393 | 24640.0 |
| 2009-02-13 18:00:00 | AAPL | Stock | 3.5414 | 3.5429 | 3.5393 | 3.5429 | 2914240.0 |
| 2009-02-13 18:30:00 | AAPL | Stock | 3.5414 | 3.5443 | 3.5414 | 3.5443 | 29400.0 |
| 2009-02-13 19:00:00 | AAPL | Stock | 3.5414 | 3.5414 | 3.5393 | 3.5393 | 22400.0 |
| 2009-02-13 19:30:00 | AAPL | Stock | 3.5393 | 3.5411 | 3.5393 | 3.5411 | 28000.0 |
| 2009-02-13 07:30:00 | MSFT | Stock | 19.2 | 19.35 | 19.2 | 19.35 | 500.0 |
| 2009-02-13 08:00:00 | MSFT | Stock | 19.36 | 19.37 | 19.21 | 19.21 | 9001.0 |
| 2009-02-13 08:30:00 | MSFT | Stock | 19.21 | 19.26 | 19.2 | 19.26 | 6866.0 |
| 2009-02-13 09:00:00 | MSFT | Stock | 19.23 | 19.29 | 19.2 | 19.28 | 14710.0 |
| 2009-02-13 09:30:00 | MSFT | Stock | 19.27 | 19.4 | 19.09 | 19.25 | 8098059.0 |
| 2009-02-13 10:00:00 | MSFT | Stock | 19.25 | 19.46 | 19.24 | 19.328 | 5438869.0 |
| 2009-02-13 10:30:00 | MSFT | Stock | 19.34 | 19.47 | 19.34 | 19.42 | 2998672.0 |
| 2009-02-13 11:00:00 | MSFT | Stock | 19.43 | 19.43 | 19.26 | 19.33 | 2872133.0 |
| 2009-02-13 11:30:00 | MSFT | Stock | 19.32 | 19.33 | 19.2 | 19.23 | 2815590.0 |
| 2009-02-13 12:00:00 | MSFT | Stock | 19.23 | 19.3 | 19.22 | 19.29 | 2010320.0 |
| 2009-02-13 12:30:00 | MSFT | Stock | 19.3 | 19.3 | 19.16 | 19.19 | 2574116.0 |
| 2009-02-13 13:00:00 | MSFT | Stock | 19.18 | 19.24 | 19.168 | 19.232 | 1702626.0 |
| 2009-02-13 13:30:00 | MSFT | Stock | 19.228 | 19.33 | 19.2 | 19.27 | 2704952.0 |
| 2009-02-13 14:00:00 | MSFT | Stock | 19.26 | 19.32 | 19.18 | 19.24 | 2611467.0 |
| 2009-02-13 14:30:00 | MSFT | Stock | 19.24 | 19.3 | 19.21 | 19.262 | 2003750.0 |
| 2009-02-13 15:00:00 | MSFT | Stock | 19.27 | 19.28 | 19.1 | 19.21 | 3384039.0 |
| 2009-02-13 15:30:00 | MSFT | Stock | 19.22 | 19.27 | 19.04 | 19.08 | 5564146.0 |
| 2009-02-13 16:00:00 | MSFT | Stock | 19.09 | 19.41 | 19.0 | 19.06 | 2067252.0 |
| 2009-02-13 16:30:00 | MSFT | Stock | 19.06 | 19.09 | 19.04 | 19.06 | 4088.0 |
| 2009-02-13 17:00:00 | MSFT | Stock | 19.02 | 19.07 | 19.02 | 19.07 | 8137.0 |
| 2009-02-13 17:30:00 | MSFT | Stock | 19.07 | 19.07 | 19.07 | 19.07 | 800.0 |
> showing 50 of 65,294 rows — these rows as CSV