PREVIEW / stock_30min / 2009-08-18
file: by_date/stock_30min/2009/2009-08-18.parquet size: 1.3 MB rows: 72,072 symbols: 3,369
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-18 04:30:00 | AAPL | Stock | 5.7389 | 5.7389 | 5.7389 | 5.7389 | 25200.0 |
| 2009-08-18 05:30:00 | AAPL | Stock | 5.7357 | 5.7357 | 5.7357 | 5.7357 | 5600.0 |
| 2009-08-18 06:00:00 | AAPL | Stock | 5.7482 | 5.7711 | 5.7429 | 5.7429 | 119896.0 |
| 2009-08-18 07:00:00 | AAPL | Stock | 5.7429 | 5.7639 | 5.7393 | 5.7518 | 106400.0 |
| 2009-08-18 07:30:00 | AAPL | Stock | 5.7571 | 5.79 | 5.75 | 5.7746 | 957880.0 |
| 2009-08-18 08:00:00 | AAPL | Stock | 5.775 | 5.7839 | 5.7661 | 5.7693 | 2130744.0 |
| 2009-08-18 08:30:00 | AAPL | Stock | 5.7693 | 5.7832 | 5.7593 | 5.7789 | 2299920.0 |
| 2009-08-18 09:00:00 | AAPL | Stock | 5.7789 | 5.7907 | 5.7679 | 5.7739 | 2132060.0 |
| 2009-08-18 09:30:00 | AAPL | Stock | 5.7725 | 5.8089 | 5.7646 | 5.7943 | 83981436.0 |
| 2009-08-18 10:00:00 | AAPL | Stock | 5.7943 | 5.8143 | 5.7875 | 5.7954 | 46277168.0 |
| 2009-08-18 10:30:00 | AAPL | Stock | 5.7954 | 5.8057 | 5.79 | 5.7968 | 23391816.0 |
| 2009-08-18 11:00:00 | AAPL | Stock | 5.7971 | 5.82 | 5.7936 | 5.8172 | 27922384.0 |
| 2009-08-18 11:30:00 | AAPL | Stock | 5.8175 | 5.8396 | 5.7964 | 5.8318 | 32294920.0 |
| 2009-08-18 12:00:00 | AAPL | Stock | 5.8311 | 5.8382 | 5.8246 | 5.8336 | 17507980.0 |
| 2009-08-18 12:30:00 | AAPL | Stock | 5.8339 | 5.8457 | 5.8034 | 5.8414 | 13981884.0 |
| 2009-08-18 13:00:00 | AAPL | Stock | 5.8414 | 5.8461 | 5.8343 | 5.8357 | 17462984.0 |
| 2009-08-18 13:30:00 | AAPL | Stock | 5.8357 | 5.84 | 5.8286 | 5.8321 | 19415284.0 |
| 2009-08-18 14:00:00 | AAPL | Stock | 5.8318 | 5.8418 | 5.8293 | 5.8418 | 15239700.0 |
| 2009-08-18 14:30:00 | AAPL | Stock | 5.8415 | 5.8564 | 5.8332 | 5.8475 | 28714112.0 |
| 2009-08-18 15:00:00 | AAPL | Stock | 5.8475 | 5.8657 | 5.8471 | 5.8589 | 32362540.0 |
| 2009-08-18 15:30:00 | AAPL | Stock | 5.8593 | 5.8654 | 5.8482 | 5.8571 | 41774768.0 |
| 2009-08-18 16:00:00 | AAPL | Stock | 5.8525 | 5.8643 | 5.8224 | 5.8521 | 11320568.0 |
| 2009-08-18 16:30:00 | AAPL | Stock | 5.8582 | 5.8582 | 5.8221 | 5.8464 | 486780.0 |
| 2009-08-18 17:00:00 | AAPL | Stock | 5.85 | 5.8582 | 5.8429 | 5.8464 | 556696.0 |
| 2009-08-18 17:30:00 | AAPL | Stock | 5.8446 | 5.8482 | 5.8393 | 5.8475 | 226520.0 |
| 2009-08-18 18:00:00 | AAPL | Stock | 5.8482 | 5.8582 | 5.8482 | 5.85 | 5637408.0 |
| 2009-08-18 18:30:00 | AAPL | Stock | 5.85 | 5.8554 | 5.85 | 5.8518 | 126560.0 |
| 2009-08-18 19:00:00 | AAPL | Stock | 5.8511 | 5.8514 | 5.8425 | 5.8425 | 282912.0 |
| 2009-08-18 19:30:00 | AAPL | Stock | 5.8425 | 5.8486 | 5.8404 | 5.8407 | 331660.0 |
| 2009-08-18 04:00:00 | MSFT | Stock | 23.34 | 23.34 | 23.34 | 23.34 | 200.0 |
| 2009-08-18 06:30:00 | MSFT | Stock | 23.52 | 23.55 | 23.52 | 23.55 | 2100.0 |
| 2009-08-18 07:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.38 | 23.39 | 1300.0 |
| 2009-08-18 07:30:00 | MSFT | Stock | 23.4 | 23.4 | 23.39 | 23.39 | 1700.0 |
| 2009-08-18 08:00:00 | MSFT | Stock | 23.4 | 23.4 | 23.37 | 23.39 | 19463.0 |
| 2009-08-18 08:30:00 | MSFT | Stock | 23.42 | 23.42 | 23.35 | 23.37 | 49570.0 |
| 2009-08-18 09:00:00 | MSFT | Stock | 23.35 | 23.36 | 23.21 | 23.29 | 104319.0 |
| 2009-08-18 09:30:00 | MSFT | Stock | 23.29 | 23.42 | 23.27 | 23.34 | 4942389.0 |
| 2009-08-18 10:00:00 | MSFT | Stock | 23.34 | 23.39 | 23.31 | 23.31 | 3275328.0 |
| 2009-08-18 10:30:00 | MSFT | Stock | 23.31 | 23.36 | 23.29 | 23.29 | 1846233.0 |
| 2009-08-18 11:00:00 | MSFT | Stock | 23.298 | 23.42 | 23.285 | 23.4 | 2149000.0 |
| 2009-08-18 11:30:00 | MSFT | Stock | 23.41 | 23.5 | 23.37 | 23.37 | 2020306.0 |
| 2009-08-18 12:00:00 | MSFT | Stock | 23.375 | 23.4 | 23.35 | 23.38 | 1322866.0 |
| 2009-08-18 12:30:00 | MSFT | Stock | 23.39 | 23.52 | 23.38 | 23.486 | 2234497.0 |
| 2009-08-18 13:00:00 | MSFT | Stock | 23.48 | 23.57 | 23.47 | 23.57 | 2652566.0 |
| 2009-08-18 13:30:00 | MSFT | Stock | 23.57 | 23.6 | 23.53 | 23.56 | 2064309.0 |
| 2009-08-18 14:00:00 | MSFT | Stock | 23.57 | 23.64 | 23.56 | 23.63 | 2118999.0 |
| 2009-08-18 14:30:00 | MSFT | Stock | 23.63 | 23.65 | 23.58 | 23.6 | 1893147.0 |
| 2009-08-18 15:00:00 | MSFT | Stock | 23.59 | 23.65 | 23.58 | 23.592 | 2434052.0 |
| 2009-08-18 15:30:00 | MSFT | Stock | 23.6 | 23.63 | 23.53 | 23.58 | 6386669.0 |
| 2009-08-18 16:00:00 | MSFT | Stock | 23.58 | 23.6 | 23.48 | 23.55 | 2394079.0 |
> showing 50 of 72,072 rows — these rows as CSV