PREVIEW / etf_5min / 2010-08-09
file: by_date/etf_5min/2010/2010-08-09.parquet size: 695 KB rows: 30,601
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-09 04:00:00 | SPY | ETF | 112.71 | 112.87 | 112.71 | 112.87 | 700.0 |
| 2010-08-09 04:05:00 | SPY | ETF | 112.83 | 112.83 | 112.83 | 112.83 | 200.0 |
| 2010-08-09 04:10:00 | SPY | ETF | 112.79 | 112.79 | 112.79 | 112.79 | 100.0 |
| 2010-08-09 04:15:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 700.0 |
| 2010-08-09 04:50:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 100.0 |
| 2010-08-09 04:55:00 | SPY | ETF | 112.85 | 112.9 | 112.85 | 112.9 | 1100.0 |
| 2010-08-09 05:05:00 | SPY | ETF | 112.91 | 112.91 | 112.91 | 112.91 | 600.0 |
| 2010-08-09 06:00:00 | SPY | ETF | 112.88 | 112.88 | 112.88 | 112.88 | 200.0 |
| 2010-08-09 06:10:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 200.0 |
| 2010-08-09 06:15:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 100.0 |
| 2010-08-09 06:25:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 300.0 |
| 2010-08-09 06:40:00 | SPY | ETF | 112.84 | 112.85 | 112.84 | 112.84 | 11050.0 |
| 2010-08-09 06:45:00 | SPY | ETF | 112.84 | 112.85 | 112.83 | 112.85 | 3550.0 |
| 2010-08-09 06:55:00 | SPY | ETF | 112.89 | 112.89 | 112.89 | 112.89 | 11025.0 |
| 2010-08-09 07:00:00 | SPY | ETF | 112.87 | 112.89 | 112.87 | 112.89 | 25500.0 |
| 2010-08-09 07:05:00 | SPY | ETF | 112.87 | 112.88 | 112.85 | 112.87 | 40700.0 |
| 2010-08-09 07:10:00 | SPY | ETF | 112.9 | 112.92 | 112.9 | 112.92 | 12501.0 |
| 2010-08-09 07:15:00 | SPY | ETF | 112.89 | 112.89 | 112.84 | 112.84 | 54499.0 |
| 2010-08-09 07:20:00 | SPY | ETF | 112.83 | 112.85 | 112.8 | 112.8 | 63700.0 |
| 2010-08-09 07:25:00 | SPY | ETF | 112.8 | 112.85 | 112.8 | 112.85 | 100100.0 |
| 2010-08-09 07:30:00 | SPY | ETF | 112.85 | 112.9 | 112.82 | 112.87 | 140400.0 |
| 2010-08-09 07:35:00 | SPY | ETF | 112.89 | 112.94 | 112.87 | 112.94 | 43600.0 |
| 2010-08-09 07:40:00 | SPY | ETF | 112.94 | 112.98 | 112.87 | 112.87 | 67740.0 |
| 2010-08-09 07:45:00 | SPY | ETF | 112.89 | 112.98 | 112.89 | 112.98 | 34100.0 |
| 2010-08-09 07:50:00 | SPY | ETF | 112.99 | 113.01 | 112.97 | 112.97 | 76155.0 |
| 2010-08-09 07:55:00 | SPY | ETF | 113.0 | 113.0 | 112.96 | 112.97 | 6747.0 |
| 2010-08-09 08:00:00 | SPY | ETF | 112.97 | 113.0 | 112.95 | 112.95 | 242495.0 |
| 2010-08-09 08:05:00 | SPY | ETF | 112.95 | 113.03 | 112.94 | 113.03 | 59837.0 |
| 2010-08-09 08:10:00 | SPY | ETF | 113.02 | 113.03 | 112.92 | 112.94 | 86710.0 |
| 2010-08-09 08:15:00 | SPY | ETF | 112.94 | 112.99 | 112.94 | 112.97 | 48495.0 |
| 2010-08-09 08:20:00 | SPY | ETF | 112.96 | 113.05 | 112.96 | 113.02 | 70414.0 |
| 2010-08-09 08:25:00 | SPY | ETF | 113.03 | 113.03 | 112.98 | 112.98 | 18600.0 |
| 2010-08-09 08:30:00 | SPY | ETF | 112.98 | 113.0 | 112.97 | 112.99 | 26800.0 |
| 2010-08-09 08:35:00 | SPY | ETF | 112.98 | 112.98 | 112.95 | 112.97 | 71450.0 |
| 2010-08-09 08:40:00 | SPY | ETF | 112.96 | 112.97 | 112.93 | 112.94 | 14522.0 |
| 2010-08-09 08:45:00 | SPY | ETF | 112.95 | 112.96 | 112.91 | 112.95 | 58700.0 |
| 2010-08-09 08:50:00 | SPY | ETF | 112.95 | 112.97 | 112.93 | 112.94 | 185425.0 |
| 2010-08-09 08:55:00 | SPY | ETF | 112.94 | 112.95 | 112.93 | 112.93 | 16945.0 |
| 2010-08-09 09:00:00 | SPY | ETF | 112.94 | 112.97 | 112.93 | 112.97 | 14450.0 |
| 2010-08-09 09:05:00 | SPY | ETF | 112.96 | 112.98 | 112.93 | 112.94 | 304190.0 |
| 2010-08-09 09:10:00 | SPY | ETF | 112.95 | 112.96 | 112.89 | 112.9 | 153950.0 |
| 2010-08-09 09:15:00 | SPY | ETF | 112.89 | 112.92 | 112.87 | 112.9 | 130257.0 |
| 2010-08-09 09:20:00 | SPY | ETF | 112.89 | 112.89 | 112.83 | 112.88 | 111498.0 |
| 2010-08-09 09:25:00 | SPY | ETF | 112.88 | 112.92 | 112.87 | 112.92 | 88210.0 |
| 2010-08-09 09:30:00 | SPY | ETF | 112.92 | 112.95 | 112.73 | 112.77 | 3403992.0 |
| 2010-08-09 09:35:00 | SPY | ETF | 112.78 | 112.82 | 112.65 | 112.74 | 3488834.0 |
| 2010-08-09 09:40:00 | SPY | ETF | 112.74 | 112.74 | 112.48 | 112.52 | 3977020.0 |
| 2010-08-09 09:45:00 | SPY | ETF | 112.53 | 112.59 | 112.41 | 112.52 | 2660511.0 |
| 2010-08-09 09:50:00 | SPY | ETF | 112.52 | 112.6061 | 112.42 | 112.45 | 2204705.0 |
| 2010-08-09 09:55:00 | SPY | ETF | 112.45 | 112.48 | 112.32 | 112.47 | 2196884.0 |
> showing 50 of 30,601 rows — these rows as CSV