PREVIEW / etf_5min / 2008-04-29
file: by_date/etf_5min/2008/2008-04-29.parquet size: 453 KB rows: 21,329
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-29 04:15:00 | SPY | ETF | 139.57 | 139.57 | 139.57 | 139.57 | 300.0 |
| 2008-04-29 05:10:00 | SPY | ETF | 139.43 | 139.43 | 139.43 | 139.43 | 100.0 |
| 2008-04-29 05:20:00 | SPY | ETF | 139.41 | 139.41 | 139.41 | 139.41 | 100.0 |
| 2008-04-29 05:30:00 | SPY | ETF | 139.42 | 139.42 | 139.37 | 139.37 | 200.0 |
| 2008-04-29 05:45:00 | SPY | ETF | 139.41 | 139.41 | 139.41 | 139.41 | 100.0 |
| 2008-04-29 06:05:00 | SPY | ETF | 139.3 | 139.3 | 139.22 | 139.25 | 75100.0 |
| 2008-04-29 06:10:00 | SPY | ETF | 139.29 | 139.29 | 139.29 | 139.29 | 100.0 |
| 2008-04-29 06:15:00 | SPY | ETF | 139.34 | 139.35 | 139.34 | 139.35 | 75000.0 |
| 2008-04-29 06:30:00 | SPY | ETF | 139.31 | 139.31 | 139.31 | 139.31 | 500.0 |
| 2008-04-29 06:35:00 | SPY | ETF | 139.4 | 139.4 | 139.33 | 139.33 | 1200.0 |
| 2008-04-29 06:40:00 | SPY | ETF | 139.28 | 139.35 | 139.28 | 139.35 | 2600.0 |
| 2008-04-29 06:45:00 | SPY | ETF | 139.34 | 139.34 | 139.33 | 139.33 | 22600.0 |
| 2008-04-29 06:50:00 | SPY | ETF | 139.29 | 139.35 | 139.29 | 139.35 | 21000.0 |
| 2008-04-29 06:55:00 | SPY | ETF | 139.35 | 139.35 | 139.35 | 139.35 | 29100.0 |
| 2008-04-29 07:00:00 | SPY | ETF | 139.34 | 139.35 | 139.3 | 139.3 | 111600.0 |
| 2008-04-29 07:05:00 | SPY | ETF | 139.3 | 139.3 | 139.26 | 139.3 | 18600.0 |
| 2008-04-29 07:10:00 | SPY | ETF | 139.3 | 139.33 | 139.25 | 139.3 | 53375.0 |
| 2008-04-29 07:15:00 | SPY | ETF | 139.32 | 139.32 | 139.32 | 139.32 | 600.0 |
| 2008-04-29 07:20:00 | SPY | ETF | 139.34 | 139.35 | 139.3 | 139.35 | 40300.0 |
| 2008-04-29 07:25:00 | SPY | ETF | 139.37 | 139.48 | 139.37 | 139.47 | 143825.0 |
| 2008-04-29 07:30:00 | SPY | ETF | 139.41 | 139.49 | 139.37 | 139.45 | 8200.0 |
| 2008-04-29 07:35:00 | SPY | ETF | 139.45 | 139.5 | 139.45 | 139.5 | 12050.0 |
| 2008-04-29 07:40:00 | SPY | ETF | 139.5 | 139.5 | 139.41 | 139.41 | 8000.0 |
| 2008-04-29 07:45:00 | SPY | ETF | 139.4 | 139.41 | 139.4 | 139.41 | 13050.0 |
| 2008-04-29 07:50:00 | SPY | ETF | 139.44 | 139.46 | 139.4 | 139.4 | 41700.0 |
| 2008-04-29 07:55:00 | SPY | ETF | 139.39 | 139.4 | 139.3 | 139.3 | 115905.0 |
| 2008-04-29 08:00:00 | SPY | ETF | 139.31 | 139.34 | 139.26 | 139.33 | 276850.0 |
| 2008-04-29 08:05:00 | SPY | ETF | 139.32 | 139.37 | 139.3 | 139.31 | 219500.0 |
| 2008-04-29 08:10:00 | SPY | ETF | 139.3 | 139.36 | 139.27 | 139.36 | 493635.0 |
| 2008-04-29 08:15:00 | SPY | ETF | 139.36 | 139.4 | 139.33 | 139.4 | 71084.0 |
| 2008-04-29 08:20:00 | SPY | ETF | 139.4 | 139.51 | 139.39 | 139.51 | 179970.0 |
| 2008-04-29 08:25:00 | SPY | ETF | 139.47 | 139.58 | 139.45 | 139.53 | 504714.0 |
| 2008-04-29 08:30:00 | SPY | ETF | 139.53 | 139.62 | 139.52 | 139.54 | 116159.0 |
| 2008-04-29 08:35:00 | SPY | ETF | 139.56 | 139.57 | 139.53 | 139.55 | 16200.0 |
| 2008-04-29 08:40:00 | SPY | ETF | 139.54 | 139.58 | 139.5 | 139.53 | 66694.0 |
| 2008-04-29 08:45:00 | SPY | ETF | 139.51 | 139.51 | 139.44 | 139.46 | 79482.0 |
| 2008-04-29 08:50:00 | SPY | ETF | 139.44 | 139.44 | 139.41 | 139.43 | 65040.0 |
| 2008-04-29 08:55:00 | SPY | ETF | 139.44 | 139.51 | 139.42 | 139.47 | 111947.0 |
| 2008-04-29 09:00:00 | SPY | ETF | 139.47 | 139.47 | 139.35 | 139.39 | 191696.0 |
| 2008-04-29 09:05:00 | SPY | ETF | 139.4 | 139.46 | 139.39 | 139.43 | 45542.0 |
| 2008-04-29 09:10:00 | SPY | ETF | 139.44 | 139.44 | 139.34 | 139.35 | 149544.0 |
| 2008-04-29 09:15:00 | SPY | ETF | 139.36 | 139.4 | 139.35 | 139.4 | 86800.0 |
| 2008-04-29 09:20:00 | SPY | ETF | 139.37 | 139.37 | 139.35 | 139.36 | 28500.0 |
| 2008-04-29 09:25:00 | SPY | ETF | 139.36 | 139.49 | 139.35 | 139.4 | 364185.0 |
| 2008-04-29 09:30:00 | SPY | ETF | 139.39 | 139.47 | 139.34 | 139.46 | 2136290.0 |
| 2008-04-29 09:35:00 | SPY | ETF | 139.46 | 139.73 | 139.41 | 139.62 | 5217844.0 |
| 2008-04-29 09:40:00 | SPY | ETF | 139.62 | 139.66 | 139.3 | 139.34 | 2741954.0 |
| 2008-04-29 09:45:00 | SPY | ETF | 139.34 | 139.55 | 139.33 | 139.36 | 1872716.0 |
| 2008-04-29 09:50:00 | SPY | ETF | 139.34 | 139.43 | 139.22 | 139.24 | 2484684.0 |
| 2008-04-29 09:55:00 | SPY | ETF | 139.25 | 139.36 | 139.23 | 139.31 | 1383343.0 |
> showing 50 of 21,329 rows — these rows as CSV