PREVIEW / stock_30min / 2009-07-31
file: by_date/stock_30min/2009/2009-07-31.parquet size: 1.3 MB rows: 74,262 symbols: 3,355
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-07-31 07:00:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 8596.0 |
| 2009-07-31 07:30:00 | AAPL | Stock | 5.8339 | 5.8425 | 5.8286 | 5.8425 | 58128.0 |
| 2009-07-31 08:00:00 | AAPL | Stock | 5.8218 | 5.8393 | 5.8214 | 5.8393 | 440860.0 |
| 2009-07-31 08:30:00 | AAPL | Stock | 5.8393 | 5.8479 | 5.7857 | 5.7914 | 1819468.0 |
| 2009-07-31 09:00:00 | AAPL | Stock | 5.7929 | 5.8229 | 5.79 | 5.8214 | 930608.0 |
| 2009-07-31 09:30:00 | AAPL | Stock | 5.8214 | 5.8696 | 5.8182 | 5.8568 | 75852448.0 |
| 2009-07-31 10:00:00 | AAPL | Stock | 5.8564 | 5.8929 | 5.8339 | 5.8777 | 58260776.0 |
| 2009-07-31 10:30:00 | AAPL | Stock | 5.8768 | 5.8929 | 5.8661 | 5.8775 | 27547212.0 |
| 2009-07-31 11:00:00 | AAPL | Stock | 5.8773 | 5.8857 | 5.8673 | 5.8736 | 16593864.0 |
| 2009-07-31 11:30:00 | AAPL | Stock | 5.8732 | 5.8886 | 5.8664 | 5.8829 | 15984640.0 |
| 2009-07-31 12:00:00 | AAPL | Stock | 5.8832 | 5.8857 | 5.8693 | 5.8846 | 18418120.0 |
| 2009-07-31 12:30:00 | AAPL | Stock | 5.8846 | 5.8857 | 5.8536 | 5.8671 | 22271228.0 |
| 2009-07-31 13:00:00 | AAPL | Stock | 5.8671 | 5.8675 | 5.8525 | 5.8639 | 14392616.0 |
| 2009-07-31 13:30:00 | AAPL | Stock | 5.8654 | 5.8736 | 5.8536 | 5.8686 | 15428812.0 |
| 2009-07-31 14:00:00 | AAPL | Stock | 5.8686 | 5.8832 | 5.8593 | 5.8732 | 22607844.0 |
| 2009-07-31 14:30:00 | AAPL | Stock | 5.8736 | 5.8754 | 5.8457 | 5.8518 | 25149320.0 |
| 2009-07-31 15:00:00 | AAPL | Stock | 5.8511 | 5.8786 | 5.8464 | 5.8689 | 29170568.0 |
| 2009-07-31 15:30:00 | AAPL | Stock | 5.8686 | 5.8857 | 5.8311 | 5.8421 | 57316448.0 |
| 2009-07-31 16:00:00 | AAPL | Stock | 5.8368 | 5.862 | 5.8321 | 5.8354 | 18862844.0 |
| 2009-07-31 16:30:00 | AAPL | Stock | 5.8325 | 5.8357 | 5.8286 | 5.8357 | 91392.0 |
| 2009-07-31 17:00:00 | AAPL | Stock | 5.8357 | 5.8364 | 5.8339 | 5.8357 | 51100.0 |
| 2009-07-31 17:30:00 | AAPL | Stock | 5.8411 | 5.8411 | 5.8375 | 5.8375 | 47180.0 |
| 2009-07-31 18:00:00 | AAPL | Stock | 5.8411 | 5.8411 | 5.8411 | 5.8411 | 2800.0 |
| 2009-07-31 18:30:00 | AAPL | Stock | 5.8354 | 5.8354 | 5.8354 | 5.8354 | 12096.0 |
| 2009-07-31 19:00:00 | AAPL | Stock | 5.8354 | 5.8393 | 5.8354 | 5.8375 | 23352.0 |
| 2009-07-31 19:30:00 | AAPL | Stock | 5.8389 | 5.8389 | 5.8339 | 5.8339 | 116928.0 |
| 2009-07-31 07:00:00 | MSFT | Stock | 23.72 | 23.78 | 23.7 | 23.73 | 5200.0 |
| 2009-07-31 07:30:00 | MSFT | Stock | 23.78 | 23.78 | 23.7 | 23.74 | 1350.0 |
| 2009-07-31 08:00:00 | MSFT | Stock | 23.71 | 23.77 | 23.65 | 23.77 | 28885.0 |
| 2009-07-31 08:30:00 | MSFT | Stock | 23.77 | 23.85 | 23.65 | 23.69 | 51857.0 |
| 2009-07-31 09:00:00 | MSFT | Stock | 23.69 | 23.82 | 23.68 | 23.77 | 10336.0 |
| 2009-07-31 09:30:00 | MSFT | Stock | 23.77 | 24.07 | 23.72 | 23.92 | 6768148.0 |
| 2009-07-31 10:00:00 | MSFT | Stock | 23.92 | 23.94 | 23.69 | 23.91 | 5937194.0 |
| 2009-07-31 10:30:00 | MSFT | Stock | 23.91 | 23.98 | 23.82 | 23.958 | 3113896.0 |
| 2009-07-31 11:00:00 | MSFT | Stock | 23.96 | 23.97 | 23.82 | 23.85 | 2525854.0 |
| 2009-07-31 11:30:00 | MSFT | Stock | 23.85 | 23.89 | 23.8 | 23.843 | 2744788.0 |
| 2009-07-31 12:00:00 | MSFT | Stock | 23.85 | 23.87 | 23.77 | 23.83 | 1686713.0 |
| 2009-07-31 12:30:00 | MSFT | Stock | 23.842 | 23.845 | 23.73 | 23.75 | 2232097.0 |
| 2009-07-31 13:00:00 | MSFT | Stock | 23.75 | 23.84 | 23.73 | 23.84 | 926817.0 |
| 2009-07-31 13:30:00 | MSFT | Stock | 23.84 | 23.87 | 23.79 | 23.82 | 1482808.0 |
| 2009-07-31 14:00:00 | MSFT | Stock | 23.82 | 23.88 | 23.79 | 23.81 | 2569322.0 |
| 2009-07-31 14:30:00 | MSFT | Stock | 23.81 | 23.82 | 23.59 | 23.6 | 3865664.0 |
| 2009-07-31 15:00:00 | MSFT | Stock | 23.615 | 23.68 | 23.52 | 23.64 | 4517520.0 |
| 2009-07-31 15:30:00 | MSFT | Stock | 23.65 | 23.65 | 23.5 | 23.55 | 9179317.0 |
| 2009-07-31 16:00:00 | MSFT | Stock | 23.54 | 23.829 | 23.51 | 23.55 | 5042776.0 |
| 2009-07-31 16:30:00 | MSFT | Stock | 23.52 | 23.55 | 23.52 | 23.55 | 2992.0 |
| 2009-07-31 17:00:00 | MSFT | Stock | 23.56 | 23.57 | 23.56 | 23.57 | 300.0 |
| 2009-07-31 17:30:00 | MSFT | Stock | 23.52 | 23.52 | 23.52 | 23.52 | 306.0 |
| 2009-07-31 18:00:00 | MSFT | Stock | 23.52 | 23.52 | 23.52 | 23.52 | 1360.0 |
| 2009-07-31 18:30:00 | MSFT | Stock | 23.52 | 23.52 | 23.52 | 23.52 | 340.0 |
> showing 50 of 74,262 rows — these rows as CSV