PREVIEW / stock_5min / 2009-03-24
file: by_date/stock_5min/2009/2009-03-24.parquet size: 4.4 MB rows: 306,948 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:15:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 5600.0 |
| 2009-03-24 06:20:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 5600.0 |
| 2009-03-24 06:40:00 | AAPL | Stock | 3.7861 | 3.7861 | 3.7861 | 3.7861 | 2800.0 |
| 2009-03-24 06:55:00 | AAPL | Stock | 3.7761 | 3.7761 | 3.7761 | 3.7761 | 8400.0 |
| 2009-03-24 07:00:00 | AAPL | Stock | 3.7757 | 3.7757 | 3.7757 | 3.7757 | 8064.0 |
| 2009-03-24 07:05:00 | AAPL | Stock | 3.7829 | 3.7829 | 3.7814 | 3.7814 | 8400.0 |
| 2009-03-24 07:10:00 | AAPL | Stock | 3.7986 | 3.8036 | 3.7986 | 3.8036 | 30800.0 |
| 2009-03-24 07:15:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.7929 | 3.7929 | 17640.0 |
| 2009-03-24 07:20:00 | AAPL | Stock | 3.8018 | 3.8018 | 3.8018 | 3.8018 | 19600.0 |
| 2009-03-24 07:25:00 | AAPL | Stock | 3.8121 | 3.8121 | 3.8121 | 3.8121 | 4200.0 |
| 2009-03-24 07:35:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.8036 | 3.8036 | 3136.0 |
| 2009-03-24 07:40:00 | AAPL | Stock | 3.8018 | 3.8018 | 3.8018 | 3.8018 | 4200.0 |
| 2009-03-24 07:55:00 | AAPL | Stock | 3.8 | 3.8036 | 3.8 | 3.8036 | 14000.0 |
| 2009-03-24 08:00:00 | AAPL | Stock | 3.8036 | 3.8214 | 3.7982 | 3.8039 | 102480.0 |
| 2009-03-24 08:05:00 | AAPL | Stock | 3.8039 | 3.8039 | 3.7982 | 3.7982 | 113176.0 |
| 2009-03-24 08:10:00 | AAPL | Stock | 3.7982 | 3.8004 | 3.7982 | 3.8004 | 56812.0 |
| 2009-03-24 08:15:00 | AAPL | Stock | 3.8004 | 3.8004 | 3.8004 | 3.8004 | 2800.0 |
| 2009-03-24 08:20:00 | AAPL | Stock | 3.8018 | 3.8029 | 3.8018 | 3.8029 | 52696.0 |
| 2009-03-24 08:25:00 | AAPL | Stock | 3.8 | 3.8014 | 3.8 | 3.8014 | 30380.0 |
| 2009-03-24 08:30:00 | AAPL | Stock | 3.8018 | 3.8093 | 3.8004 | 3.8093 | 287448.0 |
| 2009-03-24 08:35:00 | AAPL | Stock | 3.8089 | 3.8089 | 3.8079 | 3.8086 | 33600.0 |
| 2009-03-24 08:40:00 | AAPL | Stock | 3.8054 | 3.8082 | 3.8032 | 3.8032 | 73920.0 |
| 2009-03-24 08:45:00 | AAPL | Stock | 3.8025 | 3.8036 | 3.8018 | 3.8036 | 49000.0 |
| 2009-03-24 08:50:00 | AAPL | Stock | 3.8021 | 3.8082 | 3.8018 | 3.805 | 50400.0 |
| 2009-03-24 08:55:00 | AAPL | Stock | 3.8036 | 3.8043 | 3.8021 | 3.8043 | 28000.0 |
| 2009-03-24 09:00:00 | AAPL | Stock | 3.8039 | 3.8061 | 3.8036 | 3.8036 | 59640.0 |
| 2009-03-24 09:05:00 | AAPL | Stock | 3.8036 | 3.8039 | 3.8036 | 3.8036 | 14000.0 |
| 2009-03-24 09:10:00 | AAPL | Stock | 3.8036 | 3.8089 | 3.8036 | 3.8082 | 77840.0 |
| 2009-03-24 09:15:00 | AAPL | Stock | 3.8089 | 3.8093 | 3.8075 | 3.8075 | 73696.0 |
| 2009-03-24 09:20:00 | AAPL | Stock | 3.8071 | 3.845 | 3.8071 | 3.8075 | 1025948.0 |
| 2009-03-24 09:25:00 | AAPL | Stock | 3.8039 | 3.8064 | 3.7857 | 3.7968 | 291760.0 |
| 2009-03-24 09:30:00 | AAPL | Stock | 3.7986 | 3.8171 | 3.7879 | 3.7982 | 18051936.0 |
| 2009-03-24 09:35:00 | AAPL | Stock | 3.7989 | 3.8282 | 3.7925 | 3.8214 | 16147544.0 |
| 2009-03-24 09:40:00 | AAPL | Stock | 3.8221 | 3.8304 | 3.8054 | 3.8171 | 13558048.0 |
| 2009-03-24 09:45:00 | AAPL | Stock | 3.8171 | 3.8179 | 3.7982 | 3.8146 | 10019492.0 |
| 2009-03-24 09:50:00 | AAPL | Stock | 3.8143 | 3.8254 | 3.8025 | 3.8182 | 8782844.0 |
| 2009-03-24 09:55:00 | AAPL | Stock | 3.8179 | 3.8204 | 3.8 | 3.8107 | 9553152.0 |
| 2009-03-24 10:00:00 | AAPL | Stock | 3.8093 | 3.8282 | 3.8 | 3.8054 | 11159204.0 |
| 2009-03-24 10:05:00 | AAPL | Stock | 3.8043 | 3.815 | 3.7918 | 3.8085 | 11998924.0 |
| 2009-03-24 10:10:00 | AAPL | Stock | 3.8089 | 3.8175 | 3.8032 | 3.8057 | 7163324.0 |
| 2009-03-24 10:15:00 | AAPL | Stock | 3.8046 | 3.8143 | 3.7993 | 3.8004 | 6959540.0 |
| 2009-03-24 10:20:00 | AAPL | Stock | 3.8 | 3.8071 | 3.7946 | 3.7993 | 5477276.0 |
| 2009-03-24 10:25:00 | AAPL | Stock | 3.7993 | 3.8014 | 3.7821 | 3.7846 | 9080204.0 |
| 2009-03-24 10:30:00 | AAPL | Stock | 3.7854 | 3.7879 | 3.7714 | 3.7807 | 8709260.0 |
| 2009-03-24 10:35:00 | AAPL | Stock | 3.7816 | 3.7832 | 3.7643 | 3.7814 | 10558604.0 |
| 2009-03-24 10:40:00 | AAPL | Stock | 3.7814 | 3.7914 | 3.7768 | 3.7841 | 9820888.0 |
| 2009-03-24 10:45:00 | AAPL | Stock | 3.7825 | 3.7861 | 3.7736 | 3.7771 | 7465556.0 |
| 2009-03-24 10:50:00 | AAPL | Stock | 3.7771 | 3.8007 | 3.7768 | 3.7951 | 7369936.0 |
| 2009-03-24 10:55:00 | AAPL | Stock | 3.7946 | 3.8086 | 3.7943 | 3.8064 | 6030836.0 |
| 2009-03-24 11:00:00 | AAPL | Stock | 3.8064 | 3.8125 | 3.7968 | 3.8036 | 10025456.0 |
> showing 50 of 306,948 rows — these rows as CSV