PREVIEW / stock_30min / 2011-03-11
file: by_date/stock_30min/2011/2011-03-11.parquet size: 1.4 MB rows: 77,082 symbols: 3,488
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-11 04:00:00 | AAPL | Stock | 12.3246 | 12.3246 | 12.2679 | 12.2679 | 17892.0 |
| 2011-03-11 04:30:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2661 | 12.2729 | 14000.0 |
| 2011-03-11 05:00:00 | AAPL | Stock | 12.2511 | 12.2679 | 12.2214 | 12.2489 | 30100.0 |
| 2011-03-11 05:30:00 | AAPL | Stock | 12.2321 | 12.2579 | 12.2218 | 12.2375 | 282800.0 |
| 2011-03-11 06:00:00 | AAPL | Stock | 12.25 | 12.2679 | 12.2275 | 12.2336 | 168224.0 |
| 2011-03-11 06:30:00 | AAPL | Stock | 12.2464 | 12.2939 | 12.2464 | 12.2939 | 128800.0 |
| 2011-03-11 07:00:00 | AAPL | Stock | 12.2939 | 12.3393 | 12.2714 | 12.325 | 398468.0 |
| 2011-03-11 07:30:00 | AAPL | Stock | 12.32 | 12.3368 | 12.3071 | 12.3304 | 291368.0 |
| 2011-03-11 08:00:00 | AAPL | Stock | 12.3304 | 12.375 | 12.2857 | 12.35 | 1272516.0 |
| 2011-03-11 08:30:00 | AAPL | Stock | 12.3496 | 12.3679 | 12.3446 | 12.3636 | 1995532.0 |
| 2011-03-11 09:00:00 | AAPL | Stock | 12.3629 | 12.3636 | 12.3214 | 12.3293 | 1372812.0 |
| 2011-03-11 09:30:00 | AAPL | Stock | 12.3289 | 12.4739 | 12.3214 | 12.4379 | 78926988.0 |
| 2011-03-11 10:00:00 | AAPL | Stock | 12.4361 | 12.4443 | 12.3882 | 12.4171 | 39503464.0 |
| 2011-03-11 10:30:00 | AAPL | Stock | 12.4179 | 12.4643 | 12.4064 | 12.4612 | 38141180.0 |
| 2011-03-11 11:00:00 | AAPL | Stock | 12.4632 | 12.4768 | 12.3329 | 12.4604 | 32494700.0 |
| 2011-03-11 11:30:00 | AAPL | Stock | 12.4579 | 12.5643 | 12.4521 | 12.5636 | 49260344.0 |
| 2011-03-11 12:00:00 | AAPL | Stock | 12.5643 | 12.5804 | 12.5471 | 12.5628 | 37697436.0 |
| 2011-03-11 12:30:00 | AAPL | Stock | 12.5629 | 12.5707 | 12.5479 | 12.5671 | 14890792.0 |
| 2011-03-11 13:00:00 | AAPL | Stock | 12.5671 | 12.5696 | 12.5007 | 12.5371 | 25784780.0 |
| 2011-03-11 13:30:00 | AAPL | Stock | 12.5382 | 12.5521 | 12.5221 | 12.5368 | 13416536.0 |
| 2011-03-11 14:00:00 | AAPL | Stock | 12.5371 | 12.5593 | 12.5289 | 12.558 | 15725136.0 |
| 2011-03-11 14:30:00 | AAPL | Stock | 12.5582 | 12.5718 | 12.5579 | 12.5629 | 17384808.0 |
| 2011-03-11 15:00:00 | AAPL | Stock | 12.5621 | 12.5796 | 12.5589 | 12.5765 | 31437756.0 |
| 2011-03-11 15:30:00 | AAPL | Stock | 12.5775 | 12.5829 | 12.5468 | 12.5717 | 54230120.0 |
| 2011-03-11 16:00:00 | AAPL | Stock | 12.5714 | 12.5875 | 12.3796 | 12.5857 | 6497176.0 |
| 2011-03-11 16:30:00 | AAPL | Stock | 12.5857 | 12.5979 | 12.559 | 12.5979 | 741916.0 |
| 2011-03-11 17:00:00 | AAPL | Stock | 12.5936 | 12.6079 | 12.5907 | 12.6079 | 323092.0 |
| 2011-03-11 17:30:00 | AAPL | Stock | 12.6075 | 12.6107 | 12.6 | 12.6107 | 72100.0 |
| 2011-03-11 18:00:00 | AAPL | Stock | 12.6143 | 12.6214 | 12.5711 | 12.6214 | 309848.0 |
| 2011-03-11 18:30:00 | AAPL | Stock | 12.6232 | 12.6375 | 12.6143 | 12.6214 | 224560.0 |
| 2011-03-11 19:00:00 | AAPL | Stock | 12.6179 | 12.625 | 12.6125 | 12.6129 | 166712.0 |
| 2011-03-11 19:30:00 | AAPL | Stock | 12.6129 | 12.6214 | 12.6061 | 12.6214 | 222992.0 |
| 2011-03-11 04:30:00 | MSFT | Stock | 25.34 | 25.34 | 25.34 | 25.34 | 300.0 |
| 2011-03-11 05:00:00 | MSFT | Stock | 25.25 | 25.26 | 25.25 | 25.26 | 600.0 |
| 2011-03-11 05:30:00 | MSFT | Stock | 25.26 | 25.26 | 25.26 | 25.26 | 200.0 |
| 2011-03-11 06:30:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 200.0 |
| 2011-03-11 07:00:00 | MSFT | Stock | 25.36 | 25.36 | 25.27 | 25.27 | 5850.0 |
| 2011-03-11 07:30:00 | MSFT | Stock | 25.27 | 25.27 | 25.26 | 25.26 | 625.0 |
| 2011-03-11 08:00:00 | MSFT | Stock | 25.29 | 25.37 | 25.29 | 25.34 | 23122.0 |
| 2011-03-11 08:30:00 | MSFT | Stock | 25.36 | 25.42 | 25.32 | 25.32 | 19532.0 |
| 2011-03-11 09:00:00 | MSFT | Stock | 25.38 | 25.45 | 25.32 | 25.42 | 54143.0 |
| 2011-03-11 09:30:00 | MSFT | Stock | 25.41 | 25.64 | 25.4 | 25.585 | 7009890.0 |
| 2011-03-11 10:00:00 | MSFT | Stock | 25.58 | 25.62 | 25.43 | 25.45 | 3392454.0 |
| 2011-03-11 10:30:00 | MSFT | Stock | 25.455 | 25.48 | 25.36 | 25.43 | 3525842.0 |
| 2011-03-11 11:00:00 | MSFT | Stock | 25.43 | 25.47 | 25.41 | 25.441 | 2347362.0 |
| 2011-03-11 11:30:00 | MSFT | Stock | 25.44 | 25.53 | 25.42 | 25.52 | 2489158.0 |
| 2011-03-11 12:00:00 | MSFT | Stock | 25.519 | 25.6 | 25.49 | 25.59 | 3078652.0 |
| 2011-03-11 12:30:00 | MSFT | Stock | 25.59 | 25.66 | 25.58 | 25.66 | 2646588.0 |
| 2011-03-11 13:00:00 | MSFT | Stock | 25.66 | 25.69 | 25.61 | 25.62 | 2693149.0 |
| 2011-03-11 13:30:00 | MSFT | Stock | 25.625 | 25.63 | 25.56 | 25.6 | 2326926.0 |
> showing 50 of 77,082 rows — these rows as CSV