PREVIEW / etf_5min / 2008-02-13
file: by_date/etf_5min/2008/2008-02-13.parquet size: 435 KB rows: 20,586
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-02-13 05:00:00 | SPY | ETF | 135.26 | 135.26 | 135.26 | 135.26 | 5000.0 |
| 2008-02-13 05:50:00 | SPY | ETF | 135.41 | 135.41 | 135.41 | 135.41 | 800.0 |
| 2008-02-13 06:00:00 | SPY | ETF | 135.41 | 135.44 | 135.41 | 135.44 | 9000.0 |
| 2008-02-13 06:10:00 | SPY | ETF | 135.31 | 135.31 | 135.31 | 135.31 | 500.0 |
| 2008-02-13 06:15:00 | SPY | ETF | 135.24 | 135.24 | 135.24 | 135.24 | 5000.0 |
| 2008-02-13 06:25:00 | SPY | ETF | 135.31 | 135.31 | 135.31 | 135.31 | 300.0 |
| 2008-02-13 06:30:00 | SPY | ETF | 135.24 | 135.24 | 135.24 | 135.24 | 10000.0 |
| 2008-02-13 06:40:00 | SPY | ETF | 135.11 | 135.11 | 135.1 | 135.1 | 5000.0 |
| 2008-02-13 06:55:00 | SPY | ETF | 135.11 | 135.11 | 135.11 | 135.11 | 4000.0 |
| 2008-02-13 07:00:00 | SPY | ETF | 135.09 | 135.19 | 135.09 | 135.19 | 54500.0 |
| 2008-02-13 07:05:00 | SPY | ETF | 135.22 | 135.54 | 135.22 | 135.52 | 189500.0 |
| 2008-02-13 07:10:00 | SPY | ETF | 135.51 | 135.57 | 135.47 | 135.52 | 145700.0 |
| 2008-02-13 07:15:00 | SPY | ETF | 135.48 | 135.56 | 135.44 | 135.44 | 195400.0 |
| 2008-02-13 07:20:00 | SPY | ETF | 135.45 | 135.45 | 135.45 | 135.45 | 27600.0 |
| 2008-02-13 07:25:00 | SPY | ETF | 135.5 | 135.58 | 135.5 | 135.58 | 47100.0 |
| 2008-02-13 07:30:00 | SPY | ETF | 135.58 | 135.58 | 135.45 | 135.52 | 142800.0 |
| 2008-02-13 07:35:00 | SPY | ETF | 135.48 | 135.58 | 135.48 | 135.58 | 19100.0 |
| 2008-02-13 07:40:00 | SPY | ETF | 135.58 | 135.58 | 135.53 | 135.53 | 38000.0 |
| 2008-02-13 07:45:00 | SPY | ETF | 135.53 | 135.55 | 135.46 | 135.48 | 79300.0 |
| 2008-02-13 07:50:00 | SPY | ETF | 135.47 | 135.48 | 135.45 | 135.46 | 65600.0 |
| 2008-02-13 07:55:00 | SPY | ETF | 135.47 | 135.53 | 135.47 | 135.51 | 55100.0 |
| 2008-02-13 08:00:00 | SPY | ETF | 135.5 | 135.55 | 134.58 | 135.35 | 417200.0 |
| 2008-02-13 08:05:00 | SPY | ETF | 135.34 | 135.36 | 135.28 | 135.28 | 120600.0 |
| 2008-02-13 08:10:00 | SPY | ETF | 135.27 | 135.54 | 135.25 | 135.4 | 114500.0 |
| 2008-02-13 08:15:00 | SPY | ETF | 135.43 | 135.52 | 135.4 | 135.52 | 232700.0 |
| 2008-02-13 08:20:00 | SPY | ETF | 135.48 | 135.55 | 135.44 | 135.45 | 318400.0 |
| 2008-02-13 08:25:00 | SPY | ETF | 135.44 | 135.46 | 135.32 | 135.38 | 448300.0 |
| 2008-02-13 08:30:00 | SPY | ETF | 135.38 | 136.23 | 135.35 | 135.94 | 4604940.0 |
| 2008-02-13 08:35:00 | SPY | ETF | 135.94 | 136.27 | 135.88 | 136.14 | 1738300.0 |
| 2008-02-13 08:40:00 | SPY | ETF | 136.11 | 136.2 | 136.05 | 136.1 | 447500.0 |
| 2008-02-13 08:45:00 | SPY | ETF | 136.11 | 136.22 | 136.0 | 136.08 | 329700.0 |
| 2008-02-13 08:50:00 | SPY | ETF | 136.07 | 136.08 | 135.93 | 135.95 | 223900.0 |
| 2008-02-13 08:55:00 | SPY | ETF | 135.97 | 136.01 | 134.99 | 135.9 | 699500.0 |
| 2008-02-13 09:00:00 | SPY | ETF | 135.89 | 135.92 | 135.83 | 135.86 | 794452.0 |
| 2008-02-13 09:05:00 | SPY | ETF | 135.86 | 135.9 | 135.82 | 135.85 | 293669.0 |
| 2008-02-13 09:10:00 | SPY | ETF | 135.86 | 136.0 | 135.84 | 136.0 | 144100.0 |
| 2008-02-13 09:15:00 | SPY | ETF | 136.0 | 136.07 | 134.51 | 136.07 | 200500.0 |
| 2008-02-13 09:20:00 | SPY | ETF | 136.07 | 136.08 | 136.01 | 136.01 | 100300.0 |
| 2008-02-13 09:25:00 | SPY | ETF | 136.02 | 136.18 | 135.98 | 136.07 | 576292.0 |
| 2008-02-13 09:30:00 | SPY | ETF | 136.06 | 136.49 | 135.96 | 136.46 | 4743567.0 |
| 2008-02-13 09:35:00 | SPY | ETF | 136.47 | 136.5 | 136.05 | 136.09 | 4423447.0 |
| 2008-02-13 09:40:00 | SPY | ETF | 136.11 | 136.16 | 135.71 | 135.86 | 4631112.0 |
| 2008-02-13 09:45:00 | SPY | ETF | 135.85 | 136.0 | 135.76 | 135.9485 | 3385222.0 |
| 2008-02-13 09:50:00 | SPY | ETF | 135.95 | 135.95 | 135.67 | 135.81 | 3371621.0 |
| 2008-02-13 09:55:00 | SPY | ETF | 135.8 | 135.96 | 135.73 | 135.8 | 2766274.0 |
| 2008-02-13 10:00:00 | SPY | ETF | 135.79 | 136.02 | 135.65 | 135.74 | 3213688.0 |
| 2008-02-13 10:05:00 | SPY | ETF | 135.74 | 136.0 | 135.63 | 135.97 | 3075647.0 |
| 2008-02-13 10:10:00 | SPY | ETF | 135.97 | 136.2 | 135.8 | 136.14 | 2046497.0 |
| 2008-02-13 10:15:00 | SPY | ETF | 136.14 | 136.21 | 135.86 | 135.91 | 4923063.0 |
| 2008-02-13 10:20:00 | SPY | ETF | 135.91 | 136.0 | 135.58 | 135.64 | 2548987.0 |
> showing 50 of 20,586 rows — these rows as CSV