PREVIEW / stock_30min / 2009-06-15
file: by_date/stock_30min/2009/2009-06-15.parquet size: 1.3 MB rows: 73,883 symbols: 3,341
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-06-15 07:00:00 | AAPL | Stock | 4.8561 | 4.8561 | 4.8561 | 4.8561 | 2800.0 |
| 2009-06-15 07:30:00 | AAPL | Stock | 4.8393 | 4.8564 | 4.8393 | 4.8471 | 53648.0 |
| 2009-06-15 08:00:00 | AAPL | Stock | 4.8536 | 4.8568 | 4.8182 | 4.8468 | 1366708.0 |
| 2009-06-15 08:30:00 | AAPL | Stock | 4.8468 | 4.8543 | 4.8432 | 4.8529 | 638652.0 |
| 2009-06-15 09:00:00 | AAPL | Stock | 4.8507 | 4.8714 | 4.85 | 4.8593 | 1646176.0 |
| 2009-06-15 09:30:00 | AAPL | Stock | 4.8593 | 4.8875 | 4.8175 | 4.8593 | 101803772.0 |
| 2009-06-15 10:00:00 | AAPL | Stock | 4.8589 | 4.8904 | 4.8429 | 4.8782 | 52541972.0 |
| 2009-06-15 10:30:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8314 | 4.8511 | 73984176.0 |
| 2009-06-15 11:00:00 | AAPL | Stock | 4.8511 | 4.8532 | 4.825 | 4.8357 | 35154896.0 |
| 2009-06-15 11:30:00 | AAPL | Stock | 4.8355 | 4.8429 | 4.825 | 4.8314 | 23406124.0 |
| 2009-06-15 12:00:00 | AAPL | Stock | 4.8311 | 4.8346 | 4.8196 | 4.8223 | 26773824.0 |
| 2009-06-15 12:30:00 | AAPL | Stock | 4.8225 | 4.8321 | 4.8204 | 4.8314 | 15621396.0 |
| 2009-06-15 13:00:00 | AAPL | Stock | 4.8314 | 4.8407 | 4.8254 | 4.8314 | 21450800.0 |
| 2009-06-15 13:30:00 | AAPL | Stock | 4.8314 | 4.8386 | 4.8232 | 4.8357 | 19366648.0 |
| 2009-06-15 14:00:00 | AAPL | Stock | 4.8357 | 4.8568 | 4.8336 | 4.8521 | 28515564.0 |
| 2009-06-15 14:30:00 | AAPL | Stock | 4.8525 | 4.8546 | 4.8332 | 4.8543 | 28019320.0 |
| 2009-06-15 15:00:00 | AAPL | Stock | 4.8543 | 4.8571 | 4.8411 | 4.8471 | 29053584.0 |
| 2009-06-15 15:30:00 | AAPL | Stock | 4.8471 | 4.8614 | 4.8443 | 4.8604 | 57477168.0 |
| 2009-06-15 16:00:00 | AAPL | Stock | 4.8604 | 4.8639 | 4.8474 | 4.8604 | 12736836.0 |
| 2009-06-15 16:30:00 | AAPL | Stock | 4.8604 | 4.8618 | 4.8311 | 4.8557 | 169316.0 |
| 2009-06-15 17:00:00 | AAPL | Stock | 4.8582 | 4.8618 | 4.8571 | 4.8571 | 5833632.0 |
| 2009-06-15 17:30:00 | AAPL | Stock | 4.8571 | 4.8593 | 4.8571 | 4.8586 | 32200.0 |
| 2009-06-15 18:00:00 | AAPL | Stock | 4.8604 | 4.8604 | 4.8543 | 4.8543 | 255416.0 |
| 2009-06-15 18:30:00 | AAPL | Stock | 4.8543 | 4.8586 | 4.8543 | 4.8586 | 30492.0 |
| 2009-06-15 19:00:00 | AAPL | Stock | 4.8586 | 4.8586 | 4.8586 | 4.8586 | 33600.0 |
| 2009-06-15 19:30:00 | AAPL | Stock | 4.8554 | 4.8607 | 4.8554 | 4.8607 | 96936.0 |
| 2009-06-15 20:00:00 | AAPL | Stock | 4.8289 | 4.8289 | 4.8289 | 4.8289 | 13244.0 |
| 2009-06-15 07:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.14 | 23.16 | 5300.0 |
| 2009-06-15 07:30:00 | MSFT | Stock | 23.15 | 23.23 | 23.15 | 23.23 | 426.0 |
| 2009-06-15 08:00:00 | MSFT | Stock | 23.24 | 23.26 | 23.14 | 23.25 | 39435.0 |
| 2009-06-15 08:30:00 | MSFT | Stock | 23.25 | 23.3 | 23.19 | 23.3 | 40746.0 |
| 2009-06-15 09:00:00 | MSFT | Stock | 23.3 | 23.33 | 23.21 | 23.23 | 58558.0 |
| 2009-06-15 09:30:00 | MSFT | Stock | 23.24 | 23.54 | 23.19 | 23.37 | 9326899.0 |
| 2009-06-15 10:00:00 | MSFT | Stock | 23.38 | 23.41 | 23.3 | 23.35 | 4814676.0 |
| 2009-06-15 10:30:00 | MSFT | Stock | 23.36 | 23.37 | 23.05 | 23.06 | 6436349.0 |
| 2009-06-15 11:00:00 | MSFT | Stock | 23.07 | 23.22 | 23.02 | 23.21 | 4684350.0 |
| 2009-06-15 11:30:00 | MSFT | Stock | 23.22 | 23.32 | 23.2 | 23.3 | 3760320.0 |
| 2009-06-15 12:00:00 | MSFT | Stock | 23.3 | 23.32 | 23.21 | 23.23 | 2125380.0 |
| 2009-06-15 12:30:00 | MSFT | Stock | 23.23 | 23.28 | 23.17 | 23.22 | 1796611.0 |
| 2009-06-15 13:00:00 | MSFT | Stock | 23.21 | 23.27 | 23.18 | 23.19 | 2229678.0 |
| 2009-06-15 13:30:00 | MSFT | Stock | 23.19 | 23.19 | 23.06 | 23.09 | 3068942.0 |
| 2009-06-15 14:00:00 | MSFT | Stock | 23.09 | 23.23 | 23.09 | 23.21 | 2260450.0 |
| 2009-06-15 14:30:00 | MSFT | Stock | 23.2 | 23.21 | 23.04 | 23.14 | 3142583.0 |
| 2009-06-15 15:00:00 | MSFT | Stock | 23.15 | 23.33 | 23.11 | 23.31 | 4727211.0 |
| 2009-06-15 15:30:00 | MSFT | Stock | 23.3 | 23.48 | 23.15 | 23.44 | 10764660.0 |
| 2009-06-15 16:00:00 | MSFT | Stock | 23.41 | 23.45 | 23.266 | 23.45 | 5628894.0 |
| 2009-06-15 16:30:00 | MSFT | Stock | 23.45 | 23.45 | 23.269 | 23.39 | 305961.0 |
| 2009-06-15 17:00:00 | MSFT | Stock | 23.44 | 23.45 | 23.39 | 23.41 | 1042188.0 |
| 2009-06-15 17:30:00 | MSFT | Stock | 23.39 | 23.44 | 23.39 | 23.44 | 6274.0 |
| 2009-06-15 18:00:00 | MSFT | Stock | 23.43 | 23.43 | 23.41 | 23.43 | 12308.0 |
> showing 50 of 73,883 rows — these rows as CSV