PREVIEW / etf_5min / 2008-02-27
file: by_date/etf_5min/2008/2008-02-27.parquet size: 448 KB rows: 21,736
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-27 04:10:00 | SPY | ETF | 138.11 | 138.11 | 138.11 | 138.11 | 1000.0 |
| 2008-02-27 04:30:00 | SPY | ETF | 138.12 | 138.12 | 138.12 | 138.12 | 3000.0 |
| 2008-02-27 04:35:00 | SPY | ETF | 138.16 | 138.16 | 138.16 | 138.16 | 500.0 |
| 2008-02-27 04:50:00 | SPY | ETF | 138.02 | 138.02 | 138.02 | 138.02 | 1000.0 |
| 2008-02-27 05:25:00 | SPY | ETF | 137.9 | 137.93 | 137.9 | 137.93 | 1800.0 |
| 2008-02-27 05:40:00 | SPY | ETF | 138.16 | 138.16 | 138.16 | 138.16 | 2500.0 |
| 2008-02-27 06:15:00 | SPY | ETF | 138.2 | 138.2 | 138.2 | 138.2 | 300.0 |
| 2008-02-27 06:25:00 | SPY | ETF | 138.08 | 138.08 | 138.0 | 138.0 | 50000.0 |
| 2008-02-27 06:30:00 | SPY | ETF | 138.15 | 138.15 | 138.15 | 138.15 | 10000.0 |
| 2008-02-27 06:40:00 | SPY | ETF | 138.2 | 138.23 | 138.2 | 138.22 | 11500.0 |
| 2008-02-27 06:45:00 | SPY | ETF | 138.2 | 138.3 | 138.2 | 138.23 | 19000.0 |
| 2008-02-27 06:50:00 | SPY | ETF | 138.28 | 138.3 | 138.25 | 138.25 | 2200.0 |
| 2008-02-27 06:55:00 | SPY | ETF | 138.26 | 138.32 | 138.25 | 138.31 | 5700.0 |
| 2008-02-27 07:00:00 | SPY | ETF | 138.2 | 138.21 | 138.18 | 138.18 | 128500.0 |
| 2008-02-27 07:05:00 | SPY | ETF | 138.13 | 138.14 | 138.09 | 138.09 | 30000.0 |
| 2008-02-27 07:10:00 | SPY | ETF | 138.08 | 138.08 | 138.05 | 138.05 | 5600.0 |
| 2008-02-27 07:15:00 | SPY | ETF | 138.14 | 138.25 | 138.12 | 138.25 | 5500.0 |
| 2008-02-27 07:20:00 | SPY | ETF | 138.21 | 138.21 | 138.17 | 138.17 | 2200.0 |
| 2008-02-27 07:25:00 | SPY | ETF | 138.16 | 138.2 | 138.11 | 138.17 | 3800.0 |
| 2008-02-27 07:30:00 | SPY | ETF | 138.18 | 138.18 | 138.13 | 138.14 | 74400.0 |
| 2008-02-27 07:35:00 | SPY | ETF | 138.13 | 138.15 | 138.1 | 138.15 | 54000.0 |
| 2008-02-27 07:40:00 | SPY | ETF | 138.21 | 138.21 | 138.14 | 138.14 | 27700.0 |
| 2008-02-27 07:45:00 | SPY | ETF | 138.17 | 138.17 | 138.01 | 138.05 | 6600.0 |
| 2008-02-27 07:50:00 | SPY | ETF | 138.11 | 138.11 | 137.94 | 137.94 | 385700.0 |
| 2008-02-27 07:55:00 | SPY | ETF | 137.94 | 137.96 | 137.85 | 137.9 | 249600.0 |
| 2008-02-27 08:00:00 | SPY | ETF | 137.93 | 138.21 | 137.87 | 137.95 | 643500.0 |
| 2008-02-27 08:05:00 | SPY | ETF | 137.94 | 138.02 | 137.91 | 137.91 | 56900.0 |
| 2008-02-27 08:10:00 | SPY | ETF | 137.87 | 137.9 | 137.69 | 137.69 | 867400.0 |
| 2008-02-27 08:15:00 | SPY | ETF | 137.69 | 137.7 | 137.58 | 137.6 | 612500.0 |
| 2008-02-27 08:20:00 | SPY | ETF | 137.6 | 137.6 | 137.41 | 137.51 | 879500.0 |
| 2008-02-27 08:25:00 | SPY | ETF | 137.53 | 137.7 | 137.47 | 137.64 | 400900.0 |
| 2008-02-27 08:30:00 | SPY | ETF | 137.62 | 137.62 | 137.34 | 137.56 | 1106700.0 |
| 2008-02-27 08:35:00 | SPY | ETF | 137.57 | 137.78 | 137.56 | 137.68 | 639800.0 |
| 2008-02-27 08:40:00 | SPY | ETF | 137.66 | 137.66 | 137.52 | 137.53 | 271900.0 |
| 2008-02-27 08:45:00 | SPY | ETF | 137.52 | 137.52 | 137.3 | 137.36 | 503000.0 |
| 2008-02-27 08:50:00 | SPY | ETF | 137.37 | 137.45 | 137.34 | 137.44 | 369100.0 |
| 2008-02-27 08:55:00 | SPY | ETF | 137.45 | 137.57 | 137.44 | 137.57 | 188400.0 |
| 2008-02-27 09:00:00 | SPY | ETF | 137.57 | 137.62 | 137.52 | 137.52 | 231500.0 |
| 2008-02-27 09:05:00 | SPY | ETF | 137.53 | 137.55 | 137.41 | 137.49 | 101800.0 |
| 2008-02-27 09:10:00 | SPY | ETF | 137.48 | 137.57 | 137.48 | 137.57 | 271800.0 |
| 2008-02-27 09:15:00 | SPY | ETF | 137.55 | 137.58 | 137.46 | 137.48 | 191200.0 |
| 2008-02-27 09:20:00 | SPY | ETF | 137.49 | 137.6 | 137.42 | 137.52 | 94700.0 |
| 2008-02-27 09:25:00 | SPY | ETF | 137.52 | 137.61 | 137.52 | 137.56 | 176000.0 |
| 2008-02-27 09:30:00 | SPY | ETF | 137.56 | 137.67 | 137.42 | 137.62 | 2811775.0 |
| 2008-02-27 09:35:00 | SPY | ETF | 137.62 | 137.67 | 137.41 | 137.59 | 2514865.0 |
| 2008-02-27 09:40:00 | SPY | ETF | 137.6 | 137.87 | 137.52 | 137.86 | 3837095.0 |
| 2008-02-27 09:45:00 | SPY | ETF | 137.86 | 138.04 | 137.6 | 138.04 | 3717213.0 |
| 2008-02-27 09:50:00 | SPY | ETF | 138.04 | 138.08 | 137.83 | 137.92 | 2683204.0 |
| 2008-02-27 09:55:00 | SPY | ETF | 137.92 | 138.1 | 137.86 | 138.01 | 1921113.0 |
| 2008-02-27 10:00:00 | SPY | ETF | 138.01 | 138.03 | 137.65 | 137.89 | 6377649.0 |
> showing 50 of 21,736 rows — these rows as CSV