PREVIEW / etf_5min / 2008-01-29
file: by_date/etf_5min/2008/2008-01-29.parquet size: 427 KB rows: 21,452
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-01-29 04:50:00 | SPY | ETF | 135.29 | 135.29 | 135.29 | 135.29 | 100.0 |
| 2008-01-29 05:30:00 | SPY | ETF | 135.41 | 135.41 | 135.41 | 135.41 | 100.0 |
| 2008-01-29 05:50:00 | SPY | ETF | 135.66 | 135.66 | 135.66 | 135.66 | 100.0 |
| 2008-01-29 06:10:00 | SPY | ETF | 135.89 | 135.89 | 135.89 | 135.89 | 25000.0 |
| 2008-01-29 06:50:00 | SPY | ETF | 135.56 | 135.56 | 135.56 | 135.56 | 5000.0 |
| 2008-01-29 06:55:00 | SPY | ETF | 135.72 | 135.72 | 135.72 | 135.72 | 4000.0 |
| 2008-01-29 07:00:00 | SPY | ETF | 135.57 | 135.57 | 135.44 | 135.49 | 13600.0 |
| 2008-01-29 07:05:00 | SPY | ETF | 135.45 | 135.56 | 135.44 | 135.55 | 11400.0 |
| 2008-01-29 07:10:00 | SPY | ETF | 135.6 | 135.72 | 135.57 | 135.65 | 123800.0 |
| 2008-01-29 07:15:00 | SPY | ETF | 135.63 | 135.63 | 135.55 | 135.55 | 5500.0 |
| 2008-01-29 07:20:00 | SPY | ETF | 135.5 | 135.62 | 135.5 | 135.61 | 8200.0 |
| 2008-01-29 07:25:00 | SPY | ETF | 135.63 | 135.67 | 135.63 | 135.65 | 3600.0 |
| 2008-01-29 07:30:00 | SPY | ETF | 135.65 | 135.8 | 135.65 | 135.72 | 222700.0 |
| 2008-01-29 07:35:00 | SPY | ETF | 135.77 | 135.77 | 135.7 | 135.7 | 4500.0 |
| 2008-01-29 07:40:00 | SPY | ETF | 135.7 | 135.7 | 135.65 | 135.65 | 61600.0 |
| 2008-01-29 07:45:00 | SPY | ETF | 135.65 | 135.74 | 135.65 | 135.71 | 39000.0 |
| 2008-01-29 07:50:00 | SPY | ETF | 135.6 | 135.6 | 135.47 | 135.47 | 35400.0 |
| 2008-01-29 07:55:00 | SPY | ETF | 135.51 | 135.63 | 135.49 | 135.59 | 30900.0 |
| 2008-01-29 08:00:00 | SPY | ETF | 135.59 | 135.69 | 135.56 | 135.62 | 61800.0 |
| 2008-01-29 08:05:00 | SPY | ETF | 135.7984 | 135.7984 | 135.07 | 135.56 | 132700.0 |
| 2008-01-29 08:10:00 | SPY | ETF | 135.55 | 135.61 | 135.53 | 135.61 | 11900.0 |
| 2008-01-29 08:15:00 | SPY | ETF | 135.61 | 135.84 | 135.61 | 135.81 | 407600.0 |
| 2008-01-29 08:20:00 | SPY | ETF | 135.81 | 135.93 | 135.8 | 135.8 | 846200.0 |
| 2008-01-29 08:25:00 | SPY | ETF | 135.8 | 135.9 | 135.75 | 135.76 | 280400.0 |
| 2008-01-29 08:30:00 | SPY | ETF | 135.82 | 136.35 | 135.82 | 136.01 | 3789600.0 |
| 2008-01-29 08:35:00 | SPY | ETF | 136.01 | 136.06 | 135.88 | 135.95 | 683400.0 |
| 2008-01-29 08:40:00 | SPY | ETF | 135.95 | 136.04 | 135.87 | 135.99 | 241900.0 |
| 2008-01-29 08:45:00 | SPY | ETF | 135.97 | 136.01 | 135.87 | 135.98 | 69200.0 |
| 2008-01-29 08:50:00 | SPY | ETF | 136.01 | 136.15 | 136.0 | 136.13 | 205200.0 |
| 2008-01-29 08:55:00 | SPY | ETF | 136.1 | 136.21 | 136.07 | 136.11 | 134800.0 |
| 2008-01-29 09:00:00 | SPY | ETF | 136.12 | 136.2 | 136.04 | 136.2 | 170100.0 |
| 2008-01-29 09:05:00 | SPY | ETF | 136.2 | 136.36 | 136.14 | 136.18 | 486800.0 |
| 2008-01-29 09:10:00 | SPY | ETF | 136.22 | 136.23 | 136.11 | 136.12 | 78600.0 |
| 2008-01-29 09:15:00 | SPY | ETF | 136.14 | 136.24 | 136.11 | 136.15 | 336000.0 |
| 2008-01-29 09:20:00 | SPY | ETF | 136.16 | 136.25 | 136.15 | 136.16 | 245100.0 |
| 2008-01-29 09:25:00 | SPY | ETF | 136.18 | 136.21 | 136.13 | 136.13 | 205400.0 |
| 2008-01-29 09:30:00 | SPY | ETF | 136.1 | 136.3 | 135.81 | 136.02 | 5210390.0 |
| 2008-01-29 09:35:00 | SPY | ETF | 136.02 | 136.25 | 135.83 | 136.18 | 2897443.0 |
| 2008-01-29 09:40:00 | SPY | ETF | 136.17 | 136.2 | 135.84 | 135.88 | 3165941.0 |
| 2008-01-29 09:45:00 | SPY | ETF | 135.89 | 136.0 | 135.59 | 135.78 | 4281352.0 |
| 2008-01-29 09:50:00 | SPY | ETF | 135.76 | 135.77 | 135.5 | 135.57 | 3406682.0 |
| 2008-01-29 09:55:00 | SPY | ETF | 135.57 | 135.69 | 135.2 | 135.24 | 2439707.0 |
| 2008-01-29 10:00:00 | SPY | ETF | 135.25 | 135.6 | 134.88 | 135.29 | 5510447.0 |
| 2008-01-29 10:05:00 | SPY | ETF | 135.29 | 135.61 | 135.1 | 135.34 | 4036040.0 |
| 2008-01-29 10:10:00 | SPY | ETF | 135.32 | 135.89 | 135.27 | 135.73 | 4216323.0 |
| 2008-01-29 10:15:00 | SPY | ETF | 135.74 | 135.8 | 135.54 | 135.58 | 1814022.0 |
| 2008-01-29 10:20:00 | SPY | ETF | 135.59 | 135.91 | 135.58 | 135.77 | 1983097.0 |
| 2008-01-29 10:25:00 | SPY | ETF | 135.77 | 135.98 | 135.7 | 135.89 | 2199889.0 |
| 2008-01-29 10:30:00 | SPY | ETF | 135.88 | 135.95 | 135.8 | 135.8 | 1249330.0 |
| 2008-01-29 10:35:00 | SPY | ETF | 135.81 | 135.88 | 135.67 | 135.77 | 1490849.0 |
> showing 50 of 21,452 rows — these rows as CSV