PREVIEW / stock_30min / 2009-09-16
file: by_date/stock_30min/2009/2009-09-16.parquet size: 1.4 MB rows: 74,723 symbols: 3,391
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-09-16 04:00:00 | AAPL | Stock | 6.3389 | 6.3389 | 6.3354 | 6.3389 | 20944.0 |
| 2009-09-16 05:00:00 | AAPL | Stock | 6.3525 | 6.3525 | 6.3525 | 6.3525 | 2800.0 |
| 2009-09-16 05:30:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 2800.0 |
| 2009-09-16 06:00:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 15904.0 |
| 2009-09-16 06:30:00 | AAPL | Stock | 6.3425 | 6.3804 | 6.3425 | 6.3804 | 61600.0 |
| 2009-09-16 07:00:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.35 | 6.3536 | 430920.0 |
| 2009-09-16 07:30:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3304 | 6.3414 | 817880.0 |
| 2009-09-16 08:00:00 | AAPL | Stock | 6.3443 | 6.3679 | 6.3414 | 6.3621 | 2567964.0 |
| 2009-09-16 08:30:00 | AAPL | Stock | 6.3625 | 6.3679 | 6.3511 | 6.3554 | 2188872.0 |
| 2009-09-16 09:00:00 | AAPL | Stock | 6.3564 | 6.3714 | 6.3468 | 6.3571 | 4663820.0 |
| 2009-09-16 09:30:00 | AAPL | Stock | 6.355 | 6.4214 | 6.3529 | 6.4111 | 122692360.0 |
| 2009-09-16 10:00:00 | AAPL | Stock | 6.4114 | 6.4257 | 6.3889 | 6.4039 | 65152836.0 |
| 2009-09-16 10:30:00 | AAPL | Stock | 6.405 | 6.4346 | 6.4004 | 6.4289 | 30348584.0 |
| 2009-09-16 11:00:00 | AAPL | Stock | 6.4289 | 6.4611 | 6.4257 | 6.445 | 52529400.0 |
| 2009-09-16 11:30:00 | AAPL | Stock | 6.4446 | 6.4929 | 6.4407 | 6.4676 | 62806548.0 |
| 2009-09-16 12:00:00 | AAPL | Stock | 6.4682 | 6.5268 | 6.4661 | 6.5125 | 62231288.0 |
| 2009-09-16 12:30:00 | AAPL | Stock | 6.5118 | 6.5161 | 6.4668 | 6.4729 | 43246196.0 |
| 2009-09-16 13:00:00 | AAPL | Stock | 6.4722 | 6.505 | 6.4686 | 6.4972 | 32801020.0 |
| 2009-09-16 13:30:00 | AAPL | Stock | 6.4972 | 6.5032 | 6.4868 | 6.5011 | 24496752.0 |
| 2009-09-16 14:00:00 | AAPL | Stock | 6.5011 | 6.5207 | 6.5 | 6.5007 | 35628768.0 |
| 2009-09-16 14:30:00 | AAPL | Stock | 6.5007 | 6.5157 | 6.4929 | 6.4954 | 40187112.0 |
| 2009-09-16 15:00:00 | AAPL | Stock | 6.4957 | 6.5068 | 6.49 | 6.5 | 40196044.0 |
| 2009-09-16 15:30:00 | AAPL | Stock | 6.4996 | 6.5 | 6.4839 | 6.4957 | 65017708.0 |
| 2009-09-16 16:00:00 | AAPL | Stock | 6.4979 | 6.4996 | 6.4582 | 6.4918 | 11215540.0 |
| 2009-09-16 16:30:00 | AAPL | Stock | 6.4889 | 6.4954 | 6.4857 | 6.49 | 200032.0 |
| 2009-09-16 17:00:00 | AAPL | Stock | 6.4954 | 6.4954 | 6.4821 | 6.4893 | 6657448.0 |
| 2009-09-16 17:30:00 | AAPL | Stock | 6.4893 | 6.4911 | 6.4854 | 6.4889 | 76412.0 |
| 2009-09-16 18:00:00 | AAPL | Stock | 6.4882 | 6.4957 | 6.4857 | 6.4893 | 841372.0 |
| 2009-09-16 18:30:00 | AAPL | Stock | 6.4893 | 6.5 | 6.4893 | 6.5 | 155260.0 |
| 2009-09-16 19:00:00 | AAPL | Stock | 6.4996 | 6.4996 | 6.4929 | 6.4964 | 177520.0 |
| 2009-09-16 19:30:00 | AAPL | Stock | 6.4964 | 6.5054 | 6.4964 | 6.5029 | 256816.0 |
| 2009-09-16 05:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 100.0 |
| 2009-09-16 07:00:00 | MSFT | Stock | 25.31 | 25.31 | 25.1 | 25.1 | 4300.0 |
| 2009-09-16 07:30:00 | MSFT | Stock | 25.21 | 25.21 | 25.21 | 25.21 | 2000.0 |
| 2009-09-16 08:00:00 | MSFT | Stock | 25.21 | 25.25 | 25.21 | 25.21 | 4733.0 |
| 2009-09-16 08:30:00 | MSFT | Stock | 25.21 | 25.25 | 25.21 | 25.23 | 11673.0 |
| 2009-09-16 09:00:00 | MSFT | Stock | 25.25 | 25.26 | 25.18 | 25.26 | 10916.0 |
| 2009-09-16 09:30:00 | MSFT | Stock | 25.25 | 25.35 | 24.95 | 25.05 | 8528439.0 |
| 2009-09-16 10:00:00 | MSFT | Stock | 25.05 | 25.14 | 25.04 | 25.06 | 2969512.0 |
| 2009-09-16 10:30:00 | MSFT | Stock | 25.06 | 25.14 | 25.03 | 25.08 | 2287546.0 |
| 2009-09-16 11:00:00 | MSFT | Stock | 25.08 | 25.09 | 25.0 | 25.0 | 2253754.0 |
| 2009-09-16 11:30:00 | MSFT | Stock | 25.0 | 25.12 | 25.0 | 25.1 | 2480662.0 |
| 2009-09-16 12:00:00 | MSFT | Stock | 25.09 | 25.18 | 25.08 | 25.13 | 2719262.0 |
| 2009-09-16 12:30:00 | MSFT | Stock | 25.14 | 25.16 | 25.03 | 25.035 | 1702362.0 |
| 2009-09-16 13:00:00 | MSFT | Stock | 25.04 | 25.16 | 25.03 | 25.13 | 1626107.0 |
| 2009-09-16 13:30:00 | MSFT | Stock | 25.13 | 25.15 | 25.1 | 25.122 | 1483163.0 |
| 2009-09-16 14:00:00 | MSFT | Stock | 25.12 | 25.23 | 25.12 | 25.23 | 1922904.0 |
| 2009-09-16 14:30:00 | MSFT | Stock | 25.23 | 25.31 | 25.15 | 25.23 | 3084157.0 |
| 2009-09-16 15:00:00 | MSFT | Stock | 25.23 | 25.29 | 25.2 | 25.29 | 2670564.0 |
| 2009-09-16 15:30:00 | MSFT | Stock | 25.29 | 25.32 | 25.19 | 25.2 | 7649599.0 |
> showing 50 of 74,723 rows — these rows as CSV