PREVIEW / etf_5min / 2008-06-12
file: by_date/etf_5min/2008/2008-06-12.parquet size: 500 KB rows: 22,396
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-12 04:15:00 | SPY | ETF | 134.67 | 134.67 | 134.63 | 134.63 | 1900.0 |
| 2008-06-12 04:50:00 | SPY | ETF | 134.53 | 134.53 | 134.51 | 134.51 | 1200.0 |
| 2008-06-12 05:30:00 | SPY | ETF | 134.48 | 134.48 | 134.48 | 134.48 | 100.0 |
| 2008-06-12 05:45:00 | SPY | ETF | 134.59 | 134.59 | 134.59 | 134.59 | 3000.0 |
| 2008-06-12 06:05:00 | SPY | ETF | 134.52 | 134.55 | 134.52 | 134.55 | 50000.0 |
| 2008-06-12 06:10:00 | SPY | ETF | 134.49 | 134.49 | 134.49 | 134.49 | 3000.0 |
| 2008-06-12 06:15:00 | SPY | ETF | 134.47 | 134.52 | 134.46 | 134.52 | 2700.0 |
| 2008-06-12 06:20:00 | SPY | ETF | 134.62 | 134.73 | 134.62 | 134.71 | 67000.0 |
| 2008-06-12 06:25:00 | SPY | ETF | 134.71 | 134.71 | 134.63 | 134.71 | 18000.0 |
| 2008-06-12 06:30:00 | SPY | ETF | 134.67 | 134.67 | 134.67 | 134.67 | 100.0 |
| 2008-06-12 06:35:00 | SPY | ETF | 134.65 | 134.65 | 134.6 | 134.6 | 13500.0 |
| 2008-06-12 06:40:00 | SPY | ETF | 134.73 | 134.73 | 134.7 | 134.71 | 12200.0 |
| 2008-06-12 06:45:00 | SPY | ETF | 134.8 | 134.8 | 134.79 | 134.79 | 1300.0 |
| 2008-06-12 06:50:00 | SPY | ETF | 134.81 | 134.81 | 134.81 | 134.81 | 600.0 |
| 2008-06-12 06:55:00 | SPY | ETF | 134.93 | 134.93 | 134.91 | 134.93 | 48000.0 |
| 2008-06-12 07:00:00 | SPY | ETF | 134.95 | 134.96 | 134.86 | 134.86 | 470700.0 |
| 2008-06-12 07:05:00 | SPY | ETF | 134.86 | 134.93 | 134.82 | 134.83 | 149000.0 |
| 2008-06-12 07:10:00 | SPY | ETF | 134.83 | 134.89 | 134.83 | 134.89 | 221190.0 |
| 2008-06-12 07:15:00 | SPY | ETF | 134.9 | 134.95 | 134.81 | 134.84 | 98100.0 |
| 2008-06-12 07:20:00 | SPY | ETF | 134.84 | 134.87 | 134.81 | 134.81 | 124300.0 |
| 2008-06-12 07:25:00 | SPY | ETF | 134.83 | 134.83 | 134.79 | 134.81 | 2350.0 |
| 2008-06-12 07:30:00 | SPY | ETF | 134.91 | 135.0 | 134.91 | 135.0 | 358108.0 |
| 2008-06-12 07:35:00 | SPY | ETF | 134.91 | 134.92 | 134.89 | 134.9 | 111704.0 |
| 2008-06-12 07:40:00 | SPY | ETF | 134.93 | 134.97 | 134.83 | 134.83 | 258213.0 |
| 2008-06-12 07:45:00 | SPY | ETF | 134.88 | 134.93 | 134.88 | 134.91 | 210200.0 |
| 2008-06-12 07:50:00 | SPY | ETF | 134.91 | 135.05 | 134.91 | 135.05 | 189438.0 |
| 2008-06-12 07:55:00 | SPY | ETF | 135.05 | 135.07 | 135.01 | 135.06 | 360675.0 |
| 2008-06-12 08:00:00 | SPY | ETF | 135.04 | 135.09 | 134.46 | 135.01 | 804084.0 |
| 2008-06-12 08:05:00 | SPY | ETF | 134.97 | 135.02 | 134.73 | 134.97 | 164362.0 |
| 2008-06-12 08:10:00 | SPY | ETF | 134.98 | 134.99 | 134.89 | 134.92 | 308753.0 |
| 2008-06-12 08:15:00 | SPY | ETF | 134.92 | 135.01 | 134.92 | 134.98 | 210538.0 |
| 2008-06-12 08:20:00 | SPY | ETF | 135.0 | 135.01 | 134.89 | 134.89 | 157122.0 |
| 2008-06-12 08:25:00 | SPY | ETF | 134.91 | 135.09 | 134.75 | 135.08 | 582822.0 |
| 2008-06-12 08:30:00 | SPY | ETF | 134.84 | 135.37 | 134.82 | 135.19 | 3441730.0 |
| 2008-06-12 08:35:00 | SPY | ETF | 135.18 | 135.26 | 134.98 | 135.06 | 518205.0 |
| 2008-06-12 08:40:00 | SPY | ETF | 135.09 | 135.11 | 134.96 | 134.99 | 232925.0 |
| 2008-06-12 08:45:00 | SPY | ETF | 134.98 | 135.01 | 134.52 | 134.54 | 874437.0 |
| 2008-06-12 08:50:00 | SPY | ETF | 134.52 | 134.88 | 134.45 | 134.81 | 3140967.0 |
| 2008-06-12 08:55:00 | SPY | ETF | 134.83 | 135.09 | 134.74 | 135.02 | 966960.0 |
| 2008-06-12 09:00:00 | SPY | ETF | 135.04 | 135.08 | 134.8 | 134.89 | 544799.0 |
| 2008-06-12 09:05:00 | SPY | ETF | 134.88 | 135.04 | 134.85 | 134.91 | 187140.0 |
| 2008-06-12 09:10:00 | SPY | ETF | 134.92 | 134.97 | 134.85 | 134.91 | 188506.0 |
| 2008-06-12 09:15:00 | SPY | ETF | 134.92 | 134.94 | 134.75 | 134.75 | 401961.0 |
| 2008-06-12 09:20:00 | SPY | ETF | 134.75 | 134.75 | 134.6 | 134.63 | 622734.0 |
| 2008-06-12 09:25:00 | SPY | ETF | 134.65 | 134.71 | 134.56 | 134.63 | 1002524.0 |
| 2008-06-12 09:30:00 | SPY | ETF | 134.6 | 134.98 | 134.53 | 134.85 | 5229770.0 |
| 2008-06-12 09:35:00 | SPY | ETF | 134.85 | 135.0 | 134.7 | 134.99 | 4035521.0 |
| 2008-06-12 09:40:00 | SPY | ETF | 135.0 | 135.17 | 134.85 | 135.14 | 4650987.0 |
| 2008-06-12 09:45:00 | SPY | ETF | 135.15 | 135.5 | 135.14 | 135.27 | 6526818.0 |
| 2008-06-12 09:50:00 | SPY | ETF | 135.27 | 135.62 | 135.25 | 135.57 | 3597099.0 |
> showing 50 of 22,396 rows — these rows as CSV