PREVIEW / stock_30min / 2009-03-24
file: by_date/stock_30min/2009/2009-03-24.parquet size: 1.3 MB rows: 70,707 symbols: 3,309
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-24 06:00:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 11200.0 |
| 2009-03-24 06:30:00 | AAPL | Stock | 3.7861 | 3.7861 | 3.7761 | 3.7761 | 11200.0 |
| 2009-03-24 07:00:00 | AAPL | Stock | 3.7757 | 3.8121 | 3.7757 | 3.8121 | 88704.0 |
| 2009-03-24 07:30:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.8 | 3.8036 | 21336.0 |
| 2009-03-24 08:00:00 | AAPL | Stock | 3.8036 | 3.8214 | 3.7982 | 3.8014 | 358344.0 |
| 2009-03-24 08:30:00 | AAPL | Stock | 3.8018 | 3.8093 | 3.8004 | 3.8043 | 522368.0 |
| 2009-03-24 09:00:00 | AAPL | Stock | 3.8039 | 3.845 | 3.7857 | 3.7968 | 1542884.0 |
| 2009-03-24 09:30:00 | AAPL | Stock | 3.7986 | 3.8304 | 3.7879 | 3.8107 | 76113016.0 |
| 2009-03-24 10:00:00 | AAPL | Stock | 3.8093 | 3.8282 | 3.7821 | 3.7846 | 51838472.0 |
| 2009-03-24 10:30:00 | AAPL | Stock | 3.7854 | 3.8086 | 3.7643 | 3.8064 | 49955080.0 |
| 2009-03-24 11:00:00 | AAPL | Stock | 3.8064 | 3.8393 | 3.7968 | 3.8307 | 47511968.0 |
| 2009-03-24 11:30:00 | AAPL | Stock | 3.8296 | 3.8364 | 3.8154 | 3.8189 | 25310600.0 |
| 2009-03-24 12:00:00 | AAPL | Stock | 3.8193 | 3.8554 | 3.8054 | 3.8532 | 37658712.0 |
| 2009-03-24 12:30:00 | AAPL | Stock | 3.8539 | 3.8875 | 3.8521 | 3.8829 | 54758676.0 |
| 2009-03-24 13:00:00 | AAPL | Stock | 3.8829 | 3.9086 | 3.8694 | 3.9078 | 44453948.0 |
| 2009-03-24 13:30:00 | AAPL | Stock | 3.9071 | 3.9082 | 3.8054 | 3.8558 | 42378448.0 |
| 2009-03-24 14:00:00 | AAPL | Stock | 3.8568 | 3.8896 | 3.8489 | 3.8593 | 36526504.0 |
| 2009-03-24 14:30:00 | AAPL | Stock | 3.8596 | 3.8693 | 3.8229 | 3.8321 | 44359812.0 |
| 2009-03-24 15:00:00 | AAPL | Stock | 3.8329 | 3.8339 | 3.805 | 3.825 | 48218352.0 |
| 2009-03-24 15:30:00 | AAPL | Stock | 3.8243 | 3.8321 | 3.795 | 3.8043 | 59398528.0 |
| 2009-03-24 16:00:00 | AAPL | Stock | 3.8039 | 3.8487 | 3.7929 | 3.8075 | 968184.0 |
| 2009-03-24 16:30:00 | AAPL | Stock | 3.8089 | 3.8324 | 3.8039 | 3.8093 | 857164.0 |
| 2009-03-24 17:00:00 | AAPL | Stock | 3.8096 | 3.8154 | 3.8036 | 3.8129 | 1547112.0 |
| 2009-03-24 17:30:00 | AAPL | Stock | 3.8043 | 3.8154 | 3.8043 | 3.8136 | 655536.0 |
| 2009-03-24 18:00:00 | AAPL | Stock | 3.8157 | 3.8182 | 3.81 | 3.8179 | 5903464.0 |
| 2009-03-24 18:30:00 | AAPL | Stock | 3.8179 | 3.8204 | 3.8171 | 3.8189 | 249424.0 |
| 2009-03-24 19:00:00 | AAPL | Stock | 3.8139 | 3.8189 | 3.8125 | 3.8189 | 72884.0 |
| 2009-03-24 19:30:00 | AAPL | Stock | 3.8196 | 3.8214 | 3.8186 | 3.8211 | 229824.0 |
| 2009-03-24 20:00:00 | AAPL | Stock | 3.8164 | 3.8164 | 3.8164 | 3.8164 | 2205000.0 |
| 2009-03-24 07:00:00 | MSFT | Stock | 18.26 | 18.26 | 18.26 | 18.26 | 100.0 |
| 2009-03-24 07:30:00 | MSFT | Stock | 18.24 | 18.25 | 18.24 | 18.25 | 500.0 |
| 2009-03-24 08:00:00 | MSFT | Stock | 18.25 | 18.25 | 18.02 | 18.02 | 9290.0 |
| 2009-03-24 08:30:00 | MSFT | Stock | 18.03 | 18.08 | 18.03 | 18.05 | 4300.0 |
| 2009-03-24 09:00:00 | MSFT | Stock | 18.06 | 18.33 | 18.02 | 18.03 | 480197.0 |
| 2009-03-24 09:30:00 | MSFT | Stock | 18.07 | 18.212 | 17.92 | 18.09 | 6897633.0 |
| 2009-03-24 10:00:00 | MSFT | Stock | 18.09 | 18.2 | 17.95 | 17.986 | 4470348.0 |
| 2009-03-24 10:30:00 | MSFT | Stock | 17.98 | 18.08 | 17.91 | 18.01 | 3889452.0 |
| 2009-03-24 11:00:00 | MSFT | Stock | 18.008 | 18.13 | 17.98 | 18.091 | 2062918.0 |
| 2009-03-24 11:30:00 | MSFT | Stock | 18.09 | 18.13 | 17.95 | 17.95 | 2291209.0 |
| 2009-03-24 12:00:00 | MSFT | Stock | 17.96 | 18.02 | 17.9 | 17.99 | 2698254.0 |
| 2009-03-24 12:30:00 | MSFT | Stock | 17.98 | 18.12 | 17.98 | 18.09 | 2953930.0 |
| 2009-03-24 13:00:00 | MSFT | Stock | 18.09 | 18.15 | 18.03 | 18.11 | 2938884.0 |
| 2009-03-24 13:30:00 | MSFT | Stock | 18.101 | 18.16 | 17.98 | 18.04 | 2760784.0 |
| 2009-03-24 14:00:00 | MSFT | Stock | 18.04 | 18.17 | 18.0 | 18.07 | 3076156.0 |
| 2009-03-24 14:30:00 | MSFT | Stock | 18.06 | 18.1 | 17.99 | 18.02 | 3081768.0 |
| 2009-03-24 15:00:00 | MSFT | Stock | 18.02 | 18.06 | 17.93 | 18.01 | 3042089.0 |
| 2009-03-24 15:30:00 | MSFT | Stock | 18.0 | 18.03 | 17.85 | 17.93 | 6744888.0 |
| 2009-03-24 16:00:00 | MSFT | Stock | 17.92 | 18.036 | 17.899 | 17.92 | 34420.0 |
| 2009-03-24 16:30:00 | MSFT | Stock | 17.92 | 18.036 | 17.84 | 17.91 | 261443.0 |
| 2009-03-24 17:00:00 | MSFT | Stock | 17.87 | 17.93 | 17.84 | 17.89 | 945677.0 |
> showing 50 of 70,707 rows — these rows as CSV