PREVIEW / stock_30min / 2009-05-15
file: by_date/stock_30min/2009/2009-05-15.parquet size: 1.3 MB rows: 70,673 symbols: 3,333
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-05-15 08:00:00 | AAPL | Stock | 4.3746 | 4.3832 | 4.3746 | 4.3832 | 106512.0 |
| 2009-05-15 08:30:00 | AAPL | Stock | 4.3832 | 4.3907 | 4.3721 | 4.3786 | 275912.0 |
| 2009-05-15 09:00:00 | AAPL | Stock | 4.385 | 4.3871 | 4.3646 | 4.3646 | 1362424.0 |
| 2009-05-15 09:30:00 | AAPL | Stock | 4.3654 | 4.4293 | 4.3432 | 4.4132 | 77420504.0 |
| 2009-05-15 10:00:00 | AAPL | Stock | 4.4125 | 4.4461 | 4.3979 | 4.4354 | 41858404.0 |
| 2009-05-15 10:30:00 | AAPL | Stock | 4.4354 | 4.4507 | 4.4307 | 4.4421 | 24823456.0 |
| 2009-05-15 11:00:00 | AAPL | Stock | 4.4407 | 4.4475 | 4.4121 | 4.4264 | 23978556.0 |
| 2009-05-15 11:30:00 | AAPL | Stock | 4.4268 | 4.4314 | 4.4121 | 4.4125 | 14623952.0 |
| 2009-05-15 12:00:00 | AAPL | Stock | 4.4121 | 4.425 | 4.4011 | 4.4157 | 15422288.0 |
| 2009-05-15 12:30:00 | AAPL | Stock | 4.4159 | 4.4221 | 4.3929 | 4.4005 | 13163052.0 |
| 2009-05-15 13:00:00 | AAPL | Stock | 4.4007 | 4.4246 | 4.3964 | 4.4032 | 12887644.0 |
| 2009-05-15 13:30:00 | AAPL | Stock | 4.4036 | 4.4057 | 4.3914 | 4.3982 | 13183772.0 |
| 2009-05-15 14:00:00 | AAPL | Stock | 4.3975 | 4.4082 | 4.3875 | 4.3996 | 16019052.0 |
| 2009-05-15 14:30:00 | AAPL | Stock | 4.3996 | 4.4014 | 4.3761 | 4.3779 | 22454992.0 |
| 2009-05-15 15:00:00 | AAPL | Stock | 4.3782 | 4.3932 | 4.3693 | 4.3829 | 26103448.0 |
| 2009-05-15 15:30:00 | AAPL | Stock | 4.3836 | 4.3993 | 4.3689 | 4.3693 | 40033504.0 |
| 2009-05-15 16:00:00 | AAPL | Stock | 4.3721 | 4.404 | 4.3639 | 4.3721 | 13245512.0 |
| 2009-05-15 16:30:00 | AAPL | Stock | 4.3693 | 4.4373 | 4.3679 | 4.3693 | 3062836.0 |
| 2009-05-15 17:00:00 | AAPL | Stock | 4.3643 | 4.3764 | 4.3643 | 4.3721 | 62720.0 |
| 2009-05-15 17:30:00 | AAPL | Stock | 4.3643 | 4.3646 | 4.3643 | 4.3646 | 9856.0 |
| 2009-05-15 18:00:00 | AAPL | Stock | 4.3679 | 4.3721 | 4.3646 | 4.3693 | 727160.0 |
| 2009-05-15 18:30:00 | AAPL | Stock | 4.3693 | 4.3693 | 4.3643 | 4.3643 | 35028.0 |
| 2009-05-15 19:00:00 | AAPL | Stock | 4.3639 | 4.3643 | 4.3639 | 4.3643 | 14000.0 |
| 2009-05-15 19:30:00 | AAPL | Stock | 4.3661 | 4.3679 | 4.3643 | 4.3679 | 125944.0 |
| 2009-05-15 08:00:00 | MSFT | Stock | 20.1 | 20.1 | 19.9 | 20.04 | 3755.0 |
| 2009-05-15 08:30:00 | MSFT | Stock | 20.04 | 20.06 | 20.03 | 20.05 | 6388.0 |
| 2009-05-15 09:00:00 | MSFT | Stock | 20.05 | 20.19 | 20.05 | 20.06 | 31696.0 |
| 2009-05-15 09:30:00 | MSFT | Stock | 20.08 | 20.5 | 19.975 | 20.448 | 10114543.0 |
| 2009-05-15 10:00:00 | MSFT | Stock | 20.46 | 20.495 | 20.36 | 20.46 | 4325525.0 |
| 2009-05-15 10:30:00 | MSFT | Stock | 20.46 | 20.5 | 20.44 | 20.47 | 3945480.0 |
| 2009-05-15 11:00:00 | MSFT | Stock | 20.48 | 20.5 | 20.41 | 20.45 | 3283523.0 |
| 2009-05-15 11:30:00 | MSFT | Stock | 20.44 | 20.48 | 20.31 | 20.32 | 3889379.0 |
| 2009-05-15 12:00:00 | MSFT | Stock | 20.32 | 20.4 | 20.26 | 20.4 | 4146667.0 |
| 2009-05-15 12:30:00 | MSFT | Stock | 20.385 | 20.42 | 20.28 | 20.34 | 2449295.0 |
| 2009-05-15 13:00:00 | MSFT | Stock | 20.34 | 20.4 | 20.31 | 20.31 | 1678551.0 |
| 2009-05-15 13:30:00 | MSFT | Stock | 20.31 | 20.38 | 20.28 | 20.35 | 2535090.0 |
| 2009-05-15 14:00:00 | MSFT | Stock | 20.35 | 20.39 | 20.29 | 20.365 | 2748252.0 |
| 2009-05-15 14:30:00 | MSFT | Stock | 20.37 | 20.39 | 20.26 | 20.272 | 2959455.0 |
| 2009-05-15 15:00:00 | MSFT | Stock | 20.27 | 20.38 | 20.21 | 20.3 | 4462603.0 |
| 2009-05-15 15:30:00 | MSFT | Stock | 20.3 | 20.33 | 20.2 | 20.2 | 6170859.0 |
| 2009-05-15 16:00:00 | MSFT | Stock | 20.22 | 20.367 | 20.19 | 20.22 | 3581916.0 |
| 2009-05-15 16:30:00 | MSFT | Stock | 20.22 | 20.466 | 20.22 | 20.22 | 595037.0 |
| 2009-05-15 17:00:00 | MSFT | Stock | 20.21 | 20.22 | 20.21 | 20.22 | 900.0 |
| 2009-05-15 17:30:00 | MSFT | Stock | 20.19 | 20.19 | 20.18 | 20.18 | 3150.0 |
| 2009-05-15 18:00:00 | MSFT | Stock | 20.22 | 20.22 | 20.22 | 20.22 | 53242.0 |
| 2009-05-15 18:30:00 | MSFT | Stock | 20.23 | 20.23 | 20.23 | 20.23 | 500.0 |
| 2009-05-15 19:00:00 | MSFT | Stock | 20.23 | 20.23 | 20.23 | 20.23 | 100.0 |
| 2009-05-15 06:30:00 | NVDA | Stock | 0.2112 | 0.2112 | 0.2112 | 0.2112 | 4000.0 |
| 2009-05-15 07:00:00 | NVDA | Stock | 0.213 | 0.213 | 0.213 | 0.213 | 16000.0 |
| 2009-05-15 08:00:00 | NVDA | Stock | 0.214 | 0.22 | 0.2108 | 0.2108 | 244400.0 |
> showing 50 of 70,673 rows — these rows as CSV