PREVIEW / stock_30min / 2009-03-19
file: by_date/stock_30min/2009/2009-03-19.parquet size: 1.3 MB rows: 73,981 symbols: 3,336
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-03-19 05:30:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6036 | 3.6036 | 2800.0 |
| 2009-03-19 07:00:00 | AAPL | Stock | 3.6243 | 3.6243 | 3.6243 | 3.6243 | 3500.0 |
| 2009-03-19 07:30:00 | AAPL | Stock | 3.6243 | 3.6393 | 3.6243 | 3.6257 | 39200.0 |
| 2009-03-19 08:00:00 | AAPL | Stock | 3.625 | 3.6286 | 3.5954 | 3.6182 | 277368.0 |
| 2009-03-19 08:30:00 | AAPL | Stock | 3.6179 | 3.6404 | 3.6125 | 3.6404 | 483616.0 |
| 2009-03-19 09:00:00 | AAPL | Stock | 3.6307 | 3.6514 | 3.6307 | 3.6404 | 2727788.0 |
| 2009-03-19 09:30:00 | AAPL | Stock | 3.6375 | 3.6489 | 3.5804 | 3.6036 | 60075988.0 |
| 2009-03-19 10:00:00 | AAPL | Stock | 3.6054 | 3.6782 | 3.5907 | 3.6661 | 57025696.0 |
| 2009-03-19 10:30:00 | AAPL | Stock | 3.6664 | 3.6857 | 3.6496 | 3.6593 | 42372204.0 |
| 2009-03-19 11:00:00 | AAPL | Stock | 3.6568 | 3.6714 | 3.6282 | 3.6286 | 35325976.0 |
| 2009-03-19 11:30:00 | AAPL | Stock | 3.6286 | 3.6514 | 3.6071 | 3.6143 | 44217180.0 |
| 2009-03-19 12:00:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.5914 | 3.6112 | 31048388.0 |
| 2009-03-19 12:30:00 | AAPL | Stock | 3.6107 | 3.6268 | 3.6011 | 3.6046 | 22059492.0 |
| 2009-03-19 13:00:00 | AAPL | Stock | 3.6036 | 3.6146 | 3.5896 | 3.6075 | 24709944.0 |
| 2009-03-19 13:30:00 | AAPL | Stock | 3.6089 | 3.6264 | 3.5989 | 3.6182 | 23501380.0 |
| 2009-03-19 14:00:00 | AAPL | Stock | 3.6175 | 3.6264 | 3.6004 | 3.6043 | 22171184.0 |
| 2009-03-19 14:30:00 | AAPL | Stock | 3.6036 | 3.6207 | 3.5982 | 3.6178 | 27046460.0 |
| 2009-03-19 15:00:00 | AAPL | Stock | 3.6171 | 3.6343 | 3.6118 | 3.6271 | 29424024.0 |
| 2009-03-19 15:30:00 | AAPL | Stock | 3.6271 | 3.6429 | 3.6143 | 3.63 | 51659272.0 |
| 2009-03-19 16:00:00 | AAPL | Stock | 3.6318 | 3.6362 | 3.6176 | 3.6296 | 11159736.0 |
| 2009-03-19 16:30:00 | AAPL | Stock | 3.6293 | 3.6293 | 3.6261 | 3.6293 | 5107536.0 |
| 2009-03-19 17:00:00 | AAPL | Stock | 3.6293 | 3.6423 | 3.5929 | 3.6083 | 259168.0 |
| 2009-03-19 17:30:00 | AAPL | Stock | 3.6409 | 3.6409 | 3.6017 | 3.6179 | 523796.0 |
| 2009-03-19 18:00:00 | AAPL | Stock | 3.6193 | 3.6345 | 3.6143 | 3.6143 | 540456.0 |
| 2009-03-19 18:30:00 | AAPL | Stock | 3.6243 | 3.6246 | 3.6071 | 3.6143 | 54684.0 |
| 2009-03-19 19:30:00 | AAPL | Stock | 3.6175 | 3.6207 | 3.6157 | 3.6164 | 83776.0 |
| 2009-03-19 05:30:00 | MSFT | Stock | 17.12 | 17.12 | 17.12 | 17.12 | 500.0 |
| 2009-03-19 07:30:00 | MSFT | Stock | 17.16 | 17.23 | 17.16 | 17.23 | 3000.0 |
| 2009-03-19 08:00:00 | MSFT | Stock | 17.2 | 17.2 | 17.13 | 17.14 | 9543.0 |
| 2009-03-19 08:30:00 | MSFT | Stock | 17.14 | 17.24 | 17.14 | 17.21 | 39448.0 |
| 2009-03-19 09:00:00 | MSFT | Stock | 17.21 | 17.38 | 17.15 | 17.35 | 187953.0 |
| 2009-03-19 09:30:00 | MSFT | Stock | 17.37 | 17.45 | 17.01 | 17.05 | 9664546.0 |
| 2009-03-19 10:00:00 | MSFT | Stock | 17.05 | 17.08 | 16.92 | 17.057 | 4928970.0 |
| 2009-03-19 10:30:00 | MSFT | Stock | 17.058 | 17.14 | 17.01 | 17.07 | 3846525.0 |
| 2009-03-19 11:00:00 | MSFT | Stock | 17.07 | 17.1 | 17.0 | 17.0 | 2511110.0 |
| 2009-03-19 11:30:00 | MSFT | Stock | 17.0 | 17.12 | 16.99 | 17.11 | 4555449.0 |
| 2009-03-19 12:00:00 | MSFT | Stock | 17.12 | 17.2 | 17.07 | 17.11 | 3897313.0 |
| 2009-03-19 12:30:00 | MSFT | Stock | 17.11 | 17.13 | 17.02 | 17.032 | 2579378.0 |
| 2009-03-19 13:00:00 | MSFT | Stock | 17.04 | 17.14 | 17.01 | 17.11 | 2444930.0 |
| 2009-03-19 13:30:00 | MSFT | Stock | 17.11 | 17.26 | 17.08 | 17.21 | 3391433.0 |
| 2009-03-19 14:00:00 | MSFT | Stock | 17.211 | 17.27 | 17.12 | 17.15 | 2924676.0 |
| 2009-03-19 14:30:00 | MSFT | Stock | 17.16 | 17.18 | 17.05 | 17.1 | 2701625.0 |
| 2009-03-19 15:00:00 | MSFT | Stock | 17.1 | 17.16 | 17.04 | 17.08 | 3042934.0 |
| 2009-03-19 15:30:00 | MSFT | Stock | 17.08 | 17.16 | 17.01 | 17.13 | 6156697.0 |
| 2009-03-19 16:00:00 | MSFT | Stock | 17.13 | 17.16 | 16.97 | 17.14 | 2926241.0 |
| 2009-03-19 16:30:00 | MSFT | Stock | 17.14 | 17.37 | 17.032 | 17.14 | 866017.0 |
| 2009-03-19 17:00:00 | MSFT | Stock | 17.14 | 17.19 | 17.0 | 17.08 | 200834.0 |
| 2009-03-19 17:30:00 | MSFT | Stock | 17.08 | 17.25 | 17.018 | 17.07 | 63493.0 |
| 2009-03-19 18:00:00 | MSFT | Stock | 17.115 | 17.14 | 17.02 | 17.06 | 79813.0 |
| 2009-03-19 18:30:00 | MSFT | Stock | 17.07 | 17.07 | 17.07 | 17.07 | 700.0 |
> showing 50 of 73,981 rows — these rows as CSV