PREVIEW / etf_5min / 2008-04-21
file: by_date/etf_5min/2008/2008-04-21.parquet size: 440 KB rows: 21,293
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-04-21 06:25:00 | SPY | ETF | 138.59 | 138.59 | 138.59 | 138.59 | 100.0 |
| 2008-04-21 06:50:00 | SPY | ETF | 138.5 | 138.5 | 138.49 | 138.49 | 1500.0 |
| 2008-04-21 06:55:00 | SPY | ETF | 138.5 | 138.5 | 138.48 | 138.48 | 3500.0 |
| 2008-04-21 07:00:00 | SPY | ETF | 138.44 | 138.48 | 138.25 | 138.25 | 82300.0 |
| 2008-04-21 07:05:00 | SPY | ETF | 138.25 | 138.25 | 138.08 | 138.08 | 55080.0 |
| 2008-04-21 07:10:00 | SPY | ETF | 138.1 | 138.11 | 138.05 | 138.05 | 33723.0 |
| 2008-04-21 07:15:00 | SPY | ETF | 138.05 | 138.15 | 138.04 | 138.15 | 171600.0 |
| 2008-04-21 07:20:00 | SPY | ETF | 138.15 | 138.15 | 138.08 | 138.11 | 159000.0 |
| 2008-04-21 07:25:00 | SPY | ETF | 138.15 | 138.15 | 138.08 | 138.08 | 41600.0 |
| 2008-04-21 07:30:00 | SPY | ETF | 138.16 | 138.24 | 138.15 | 138.15 | 86700.0 |
| 2008-04-21 07:35:00 | SPY | ETF | 138.12 | 138.23 | 138.1 | 138.22 | 44300.0 |
| 2008-04-21 07:40:00 | SPY | ETF | 138.21 | 138.32 | 138.21 | 138.28 | 59894.0 |
| 2008-04-21 07:45:00 | SPY | ETF | 138.3 | 138.37 | 138.29 | 138.3 | 51100.0 |
| 2008-04-21 07:50:00 | SPY | ETF | 138.3 | 138.4 | 138.3 | 138.36 | 27100.0 |
| 2008-04-21 07:55:00 | SPY | ETF | 138.32 | 138.36 | 138.29 | 138.33 | 15000.0 |
| 2008-04-21 08:00:00 | SPY | ETF | 138.33 | 138.95 | 138.32 | 138.42 | 42353.0 |
| 2008-04-21 08:05:00 | SPY | ETF | 138.45 | 138.46 | 138.39 | 138.44 | 49640.0 |
| 2008-04-21 08:10:00 | SPY | ETF | 138.45 | 138.48 | 138.4 | 138.4 | 12370.0 |
| 2008-04-21 08:15:00 | SPY | ETF | 138.37 | 138.39 | 138.35 | 138.35 | 72300.0 |
| 2008-04-21 08:20:00 | SPY | ETF | 138.38 | 138.4 | 138.31 | 138.37 | 83362.0 |
| 2008-04-21 08:25:00 | SPY | ETF | 138.37 | 138.46 | 138.33 | 138.43 | 102873.0 |
| 2008-04-21 08:30:00 | SPY | ETF | 138.41 | 138.45 | 138.39 | 138.39 | 94000.0 |
| 2008-04-21 08:35:00 | SPY | ETF | 138.39 | 138.44 | 138.35 | 138.42 | 247150.0 |
| 2008-04-21 08:40:00 | SPY | ETF | 138.41 | 138.41 | 138.3 | 138.3 | 57600.0 |
| 2008-04-21 08:45:00 | SPY | ETF | 138.31 | 138.36 | 138.31 | 138.33 | 40300.0 |
| 2008-04-21 08:50:00 | SPY | ETF | 138.33 | 138.37 | 138.25 | 138.34 | 197546.0 |
| 2008-04-21 08:55:00 | SPY | ETF | 138.33 | 138.35 | 138.27 | 138.35 | 249411.0 |
| 2008-04-21 09:00:00 | SPY | ETF | 138.35 | 138.36 | 138.29 | 138.29 | 52090.0 |
| 2008-04-21 09:05:00 | SPY | ETF | 138.29 | 138.29 | 138.15 | 138.17 | 248718.0 |
| 2008-04-21 09:10:00 | SPY | ETF | 138.2 | 138.21 | 138.07 | 138.14 | 556306.0 |
| 2008-04-21 09:15:00 | SPY | ETF | 138.13 | 138.21 | 138.11 | 138.18 | 162972.0 |
| 2008-04-21 09:20:00 | SPY | ETF | 138.17 | 138.25 | 138.15 | 138.23 | 101531.0 |
| 2008-04-21 09:25:00 | SPY | ETF | 138.25 | 138.26 | 138.16 | 138.21 | 572797.0 |
| 2008-04-21 09:30:00 | SPY | ETF | 138.23 | 138.41 | 138.2 | 138.34 | 2124038.0 |
| 2008-04-21 09:35:00 | SPY | ETF | 138.34 | 138.48 | 138.32 | 138.44 | 2069002.0 |
| 2008-04-21 09:40:00 | SPY | ETF | 138.45 | 138.58 | 138.33 | 138.57 | 1657648.0 |
| 2008-04-21 09:45:00 | SPY | ETF | 138.57 | 138.63 | 138.4 | 138.47 | 2418716.0 |
| 2008-04-21 09:50:00 | SPY | ETF | 138.47 | 138.65 | 138.46 | 138.56 | 1898503.0 |
| 2008-04-21 09:55:00 | SPY | ETF | 138.55 | 138.6 | 138.46 | 138.46 | 2135616.0 |
| 2008-04-21 10:00:00 | SPY | ETF | 138.47 | 138.47 | 138.22 | 138.25 | 2766080.0 |
| 2008-04-21 10:05:00 | SPY | ETF | 138.26 | 138.38 | 138.19 | 138.3 | 2107854.0 |
| 2008-04-21 10:10:00 | SPY | ETF | 138.31 | 138.39 | 138.13 | 138.2 | 1995660.0 |
| 2008-04-21 10:15:00 | SPY | ETF | 138.19 | 138.21 | 138.0 | 138.13 | 3007311.0 |
| 2008-04-21 10:20:00 | SPY | ETF | 138.13 | 138.2 | 138.03 | 138.17 | 860004.0 |
| 2008-04-21 10:25:00 | SPY | ETF | 138.17 | 138.19 | 137.89 | 137.95 | 2475280.0 |
| 2008-04-21 10:30:00 | SPY | ETF | 137.94 | 138.02 | 137.87 | 137.98 | 1504140.0 |
| 2008-04-21 10:35:00 | SPY | ETF | 137.98 | 138.03 | 137.88 | 138.02 | 2387143.0 |
| 2008-04-21 10:40:00 | SPY | ETF | 138.01 | 138.12 | 138.001 | 138.08 | 1047226.0 |
| 2008-04-21 10:45:00 | SPY | ETF | 138.08 | 138.11 | 138.01 | 138.06 | 697111.0 |
| 2008-04-21 10:50:00 | SPY | ETF | 138.06 | 138.2 | 137.93 | 137.97 | 1667629.0 |
> showing 50 of 21,293 rows — these rows as CSV