PREVIEW / etf_5min / 2008-11-21
file: by_date/etf_5min/2008/2008-11-21.parquet size: 618 KB rows: 30,188
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-11-21 04:05:00 | SPY | ETF | 78.52 | 78.52 | 78.52 | 78.52 | 500.0 |
| 2008-11-21 04:15:00 | SPY | ETF | 78.62 | 78.63 | 78.53 | 78.56 | 1823.0 |
| 2008-11-21 04:20:00 | SPY | ETF | 78.58 | 78.67 | 78.58 | 78.67 | 2082.0 |
| 2008-11-21 04:30:00 | SPY | ETF | 78.5 | 78.55 | 78.5 | 78.55 | 499.0 |
| 2008-11-21 04:35:00 | SPY | ETF | 78.5 | 78.5 | 78.46 | 78.46 | 579.0 |
| 2008-11-21 04:40:00 | SPY | ETF | 78.45 | 78.45 | 78.45 | 78.45 | 5000.0 |
| 2008-11-21 04:45:00 | SPY | ETF | 78.34 | 78.34 | 78.34 | 78.34 | 100.0 |
| 2008-11-21 04:50:00 | SPY | ETF | 78.32 | 78.49 | 78.32 | 78.34 | 16200.0 |
| 2008-11-21 04:55:00 | SPY | ETF | 78.41 | 78.41 | 78.41 | 78.41 | 100.0 |
| 2008-11-21 05:00:00 | SPY | ETF | 78.75 | 78.93 | 78.75 | 78.88 | 800.0 |
| 2008-11-21 05:05:00 | SPY | ETF | 78.64 | 78.72 | 78.64 | 78.72 | 4400.0 |
| 2008-11-21 05:10:00 | SPY | ETF | 78.71 | 78.71 | 78.67 | 78.67 | 1500.0 |
| 2008-11-21 05:15:00 | SPY | ETF | 78.58 | 78.58 | 78.58 | 78.58 | 399.0 |
| 2008-11-21 05:20:00 | SPY | ETF | 78.52 | 78.52 | 78.52 | 78.52 | 399.0 |
| 2008-11-21 05:25:00 | SPY | ETF | 78.33 | 78.38 | 78.33 | 78.38 | 2213.0 |
| 2008-11-21 05:30:00 | SPY | ETF | 78.41 | 78.45 | 78.4 | 78.4 | 35699.0 |
| 2008-11-21 05:40:00 | SPY | ETF | 78.48 | 78.53 | 78.48 | 78.53 | 700.0 |
| 2008-11-21 05:45:00 | SPY | ETF | 78.5 | 78.5 | 78.32 | 78.32 | 400.0 |
| 2008-11-21 05:50:00 | SPY | ETF | 78.01 | 78.01 | 77.75 | 77.75 | 11300.0 |
| 2008-11-21 05:55:00 | SPY | ETF | 77.8 | 77.89 | 77.8 | 77.8 | 15100.0 |
| 2008-11-21 06:05:00 | SPY | ETF | 78.06 | 78.06 | 77.97 | 77.97 | 1200.0 |
| 2008-11-21 06:10:00 | SPY | ETF | 77.99 | 78.02 | 77.99 | 78.01 | 700.0 |
| 2008-11-21 06:15:00 | SPY | ETF | 77.8 | 77.81 | 77.76 | 77.78 | 13100.0 |
| 2008-11-21 06:20:00 | SPY | ETF | 77.75 | 77.76 | 77.7 | 77.75 | 50100.0 |
| 2008-11-21 06:25:00 | SPY | ETF | 77.7 | 77.7 | 77.48 | 77.48 | 155780.0 |
| 2008-11-21 06:30:00 | SPY | ETF | 77.6 | 77.75 | 77.6 | 77.75 | 6500.0 |
| 2008-11-21 06:35:00 | SPY | ETF | 77.55 | 77.55 | 77.55 | 77.55 | 100.0 |
| 2008-11-21 06:40:00 | SPY | ETF | 77.51 | 77.65 | 77.47 | 77.65 | 76100.0 |
| 2008-11-21 06:45:00 | SPY | ETF | 77.65 | 77.79 | 77.47 | 77.47 | 32590.0 |
| 2008-11-21 06:50:00 | SPY | ETF | 77.47 | 77.61 | 77.31 | 77.31 | 53800.0 |
| 2008-11-21 06:55:00 | SPY | ETF | 77.44 | 77.58 | 77.41 | 77.58 | 17100.0 |
| 2008-11-21 07:00:00 | SPY | ETF | 77.52 | 77.52 | 77.15 | 77.27 | 290608.0 |
| 2008-11-21 07:05:00 | SPY | ETF | 77.27 | 77.38 | 77.22 | 77.32 | 87800.0 |
| 2008-11-21 07:10:00 | SPY | ETF | 77.32 | 77.47 | 77.18 | 77.45 | 314337.0 |
| 2008-11-21 07:15:00 | SPY | ETF | 77.47 | 77.7 | 77.47 | 77.6 | 132300.0 |
| 2008-11-21 07:20:00 | SPY | ETF | 77.6 | 77.63 | 77.38 | 77.44 | 80053.0 |
| 2008-11-21 07:25:00 | SPY | ETF | 77.41 | 77.6 | 77.35 | 77.6 | 169611.0 |
| 2008-11-21 07:30:00 | SPY | ETF | 77.55 | 77.55 | 77.3 | 77.48 | 49303.0 |
| 2008-11-21 07:35:00 | SPY | ETF | 77.45 | 77.62 | 77.42 | 77.51 | 284262.0 |
| 2008-11-21 07:40:00 | SPY | ETF | 77.41 | 77.5 | 77.35 | 77.44 | 492733.0 |
| 2008-11-21 07:45:00 | SPY | ETF | 77.44 | 77.46 | 77.33 | 77.33 | 56937.0 |
| 2008-11-21 07:50:00 | SPY | ETF | 77.35 | 77.44 | 77.18 | 77.25 | 317967.0 |
| 2008-11-21 07:55:00 | SPY | ETF | 77.27 | 77.34 | 77.04 | 77.06 | 381278.0 |
| 2008-11-21 08:00:00 | SPY | ETF | 77.44 | 78.5 | 76.4 | 77.0 | 2288291.0 |
| 2008-11-21 08:05:00 | SPY | ETF | 76.98 | 77.16 | 76.93 | 77.15 | 447025.0 |
| 2008-11-21 08:10:00 | SPY | ETF | 77.15 | 77.34 | 77.12 | 77.24 | 246737.0 |
| 2008-11-21 08:15:00 | SPY | ETF | 77.26 | 77.26 | 77.09 | 77.15 | 265902.0 |
| 2008-11-21 08:20:00 | SPY | ETF | 77.15 | 77.34 | 77.11 | 77.31 | 254444.0 |
| 2008-11-21 08:25:00 | SPY | ETF | 77.31 | 77.54 | 77.3 | 77.33 | 547015.0 |
| 2008-11-21 08:30:00 | SPY | ETF | 77.33 | 77.33 | 77.15 | 77.28 | 301130.0 |
> showing 50 of 30,188 rows — these rows as CSV