PREVIEW / stock_1min / 2009-11-02
file: by_date/stock_1min/2009/2009-11-02.parquet size: 13.7 MB rows: 1,034,289 symbols: 2,771
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-11-02 04:15:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 4200.0 |
| 2009-11-02 04:23:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 8400.0 |
| 2009-11-02 04:25:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 17808.0 |
| 2009-11-02 05:32:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-11-02 05:51:00 | AAPL | Stock | 6.7643 | 6.7643 | 6.7643 | 6.7643 | 2800.0 |
| 2009-11-02 06:40:00 | AAPL | Stock | 6.7821 | 6.7821 | 6.7821 | 6.7821 | 24360.0 |
| 2009-11-02 07:02:00 | AAPL | Stock | 6.7625 | 6.7625 | 6.7625 | 6.7625 | 2800.0 |
| 2009-11-02 07:03:00 | AAPL | Stock | 6.7679 | 6.7696 | 6.7679 | 6.7696 | 27776.0 |
| 2009-11-02 07:05:00 | AAPL | Stock | 6.7696 | 6.7696 | 6.7696 | 6.7696 | 8400.0 |
| 2009-11-02 07:06:00 | AAPL | Stock | 6.7768 | 6.7768 | 6.7768 | 6.7768 | 5600.0 |
| 2009-11-02 07:08:00 | AAPL | Stock | 6.7854 | 6.7854 | 6.7854 | 6.7854 | 5600.0 |
| 2009-11-02 07:09:00 | AAPL | Stock | 6.7768 | 6.7768 | 6.7768 | 6.7768 | 4480.0 |
| 2009-11-02 07:10:00 | AAPL | Stock | 6.7854 | 6.7854 | 6.7854 | 6.7854 | 2800.0 |
| 2009-11-02 07:12:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7839 | 6.7839 | 7168.0 |
| 2009-11-02 07:13:00 | AAPL | Stock | 6.7786 | 6.7786 | 6.7786 | 6.7786 | 2800.0 |
| 2009-11-02 07:14:00 | AAPL | Stock | 6.7786 | 6.7786 | 6.7786 | 6.7786 | 9968.0 |
| 2009-11-02 07:15:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 25900.0 |
| 2009-11-02 07:18:00 | AAPL | Stock | 6.7786 | 6.7786 | 6.7786 | 6.7786 | 31080.0 |
| 2009-11-02 07:19:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7793 | 6.7793 | 19600.0 |
| 2009-11-02 07:23:00 | AAPL | Stock | 6.77 | 6.7764 | 6.77 | 6.7764 | 16800.0 |
| 2009-11-02 07:27:00 | AAPL | Stock | 6.77 | 6.77 | 6.7679 | 6.7679 | 22736.0 |
| 2009-11-02 07:34:00 | AAPL | Stock | 6.7629 | 6.7629 | 6.7629 | 6.7629 | 5600.0 |
| 2009-11-02 07:35:00 | AAPL | Stock | 6.7629 | 6.7629 | 6.7625 | 6.7625 | 31444.0 |
| 2009-11-02 07:36:00 | AAPL | Stock | 6.7696 | 6.7696 | 6.7696 | 6.7696 | 5600.0 |
| 2009-11-02 07:37:00 | AAPL | Stock | 6.7768 | 6.7768 | 6.7764 | 6.7764 | 5600.0 |
| 2009-11-02 07:39:00 | AAPL | Stock | 6.7764 | 6.7786 | 6.7764 | 6.7786 | 65968.0 |
| 2009-11-02 07:42:00 | AAPL | Stock | 6.7818 | 6.7818 | 6.7818 | 6.7818 | 11200.0 |
| 2009-11-02 07:47:00 | AAPL | Stock | 6.7607 | 6.7607 | 6.7607 | 6.7607 | 22400.0 |
| 2009-11-02 08:00:00 | AAPL | Stock | 6.7714 | 6.7786 | 6.7321 | 6.775 | 230692.0 |
| 2009-11-02 08:01:00 | AAPL | Stock | 6.775 | 6.7786 | 6.7682 | 6.7786 | 26600.0 |
| 2009-11-02 08:02:00 | AAPL | Stock | 6.775 | 6.7786 | 6.775 | 6.7786 | 14000.0 |
| 2009-11-02 08:03:00 | AAPL | Stock | 6.7768 | 6.7782 | 6.7764 | 6.7768 | 42000.0 |
| 2009-11-02 08:04:00 | AAPL | Stock | 6.7714 | 6.7721 | 6.7714 | 6.7721 | 44800.0 |
| 2009-11-02 08:05:00 | AAPL | Stock | 6.7714 | 6.7729 | 6.7679 | 6.7682 | 17780.0 |
| 2009-11-02 08:06:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 15904.0 |
| 2009-11-02 08:08:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 5600.0 |
| 2009-11-02 08:09:00 | AAPL | Stock | 6.7696 | 6.7696 | 6.7679 | 6.7679 | 13300.0 |
| 2009-11-02 08:10:00 | AAPL | Stock | 6.7643 | 6.7643 | 6.7643 | 6.7643 | 4116.0 |
| 2009-11-02 08:11:00 | AAPL | Stock | 6.7643 | 6.7661 | 6.7643 | 6.7661 | 22400.0 |
| 2009-11-02 08:13:00 | AAPL | Stock | 6.7661 | 6.7679 | 6.7661 | 6.7661 | 31528.0 |
| 2009-11-02 08:15:00 | AAPL | Stock | 6.7661 | 6.7686 | 6.7629 | 6.7664 | 67200.0 |
| 2009-11-02 08:16:00 | AAPL | Stock | 6.7639 | 6.7639 | 6.7639 | 6.7639 | 2800.0 |
| 2009-11-02 08:17:00 | AAPL | Stock | 6.7664 | 6.7696 | 6.7664 | 6.7679 | 48020.0 |
| 2009-11-02 08:18:00 | AAPL | Stock | 6.7679 | 6.7711 | 6.7679 | 6.7711 | 39480.0 |
| 2009-11-02 08:19:00 | AAPL | Stock | 6.77 | 6.7704 | 6.77 | 6.7704 | 8400.0 |
| 2009-11-02 08:21:00 | AAPL | Stock | 6.7704 | 6.7714 | 6.7704 | 6.7714 | 7000.0 |
| 2009-11-02 08:22:00 | AAPL | Stock | 6.7732 | 6.7736 | 6.7732 | 6.7736 | 10920.0 |
| 2009-11-02 08:23:00 | AAPL | Stock | 6.7768 | 6.7786 | 6.7732 | 6.7786 | 36400.0 |
| 2009-11-02 08:24:00 | AAPL | Stock | 6.7796 | 6.7821 | 6.7786 | 6.7821 | 57820.0 |
| 2009-11-02 08:25:00 | AAPL | Stock | 6.7834 | 6.7834 | 6.7821 | 6.7821 | 5600.0 |
> showing 50 of 1,034,289 rows — these rows as CSV