PREVIEW / etf_5min / 2008-05-27
file: by_date/etf_5min/2008/2008-05-27.parquet size: 463 KB rows: 21,542
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-05-27 06:05:00 | SPY | ETF | 137.69 | 137.69 | 137.69 | 137.69 | 1000.0 |
| 2008-05-27 06:35:00 | SPY | ETF | 137.55 | 137.55 | 137.45 | 137.45 | 1200.0 |
| 2008-05-27 06:40:00 | SPY | ETF | 137.48 | 137.48 | 137.48 | 137.48 | 2000.0 |
| 2008-05-27 06:50:00 | SPY | ETF | 137.55 | 137.55 | 137.55 | 137.55 | 23900.0 |
| 2008-05-27 07:00:00 | SPY | ETF | 137.48 | 137.48 | 137.48 | 137.48 | 300.0 |
| 2008-05-27 07:05:00 | SPY | ETF | 137.45 | 137.45 | 137.38 | 137.38 | 2200.0 |
| 2008-05-27 07:10:00 | SPY | ETF | 137.34 | 137.34 | 137.32 | 137.32 | 25100.0 |
| 2008-05-27 07:15:00 | SPY | ETF | 137.35 | 137.46 | 137.35 | 137.45 | 40900.0 |
| 2008-05-27 07:20:00 | SPY | ETF | 137.46 | 137.48 | 137.4 | 137.44 | 102800.0 |
| 2008-05-27 07:25:00 | SPY | ETF | 137.44 | 137.46 | 137.4 | 137.44 | 108200.0 |
| 2008-05-27 07:30:00 | SPY | ETF | 137.46 | 137.5 | 137.4 | 137.49 | 11600.0 |
| 2008-05-27 07:35:00 | SPY | ETF | 137.48 | 137.48 | 137.41 | 137.43 | 5900.0 |
| 2008-05-27 07:40:00 | SPY | ETF | 137.44 | 137.55 | 137.44 | 137.54 | 16900.0 |
| 2008-05-27 07:45:00 | SPY | ETF | 137.54 | 137.55 | 137.47 | 137.47 | 30200.0 |
| 2008-05-27 07:55:00 | SPY | ETF | 137.5 | 137.53 | 137.5 | 137.51 | 15500.0 |
| 2008-05-27 08:00:00 | SPY | ETF | 137.5 | 137.56 | 137.47 | 137.55 | 42600.0 |
| 2008-05-27 08:05:00 | SPY | ETF | 137.55 | 137.56 | 137.52 | 137.52 | 147700.0 |
| 2008-05-27 08:10:00 | SPY | ETF | 137.51 | 137.55 | 137.47 | 137.47 | 64815.0 |
| 2008-05-27 08:15:00 | SPY | ETF | 137.46 | 137.47 | 137.43 | 137.43 | 7700.0 |
| 2008-05-27 08:20:00 | SPY | ETF | 137.43 | 137.45 | 137.4 | 137.4 | 4000.0 |
| 2008-05-27 08:25:00 | SPY | ETF | 137.43 | 137.43 | 137.4 | 137.4 | 128770.0 |
| 2008-05-27 08:30:00 | SPY | ETF | 137.39 | 137.43 | 137.39 | 137.43 | 18900.0 |
| 2008-05-27 08:35:00 | SPY | ETF | 137.41 | 137.95 | 137.39 | 137.42 | 49900.0 |
| 2008-05-27 08:40:00 | SPY | ETF | 137.44 | 137.6 | 137.44 | 137.5 | 132213.0 |
| 2008-05-27 08:45:00 | SPY | ETF | 137.51 | 137.56 | 137.49 | 137.51 | 268000.0 |
| 2008-05-27 08:50:00 | SPY | ETF | 137.53 | 137.55 | 137.47 | 137.55 | 49387.0 |
| 2008-05-27 08:55:00 | SPY | ETF | 137.55 | 137.62 | 137.53 | 137.62 | 91272.0 |
| 2008-05-27 09:00:00 | SPY | ETF | 137.62 | 137.71 | 137.54 | 137.7 | 378302.0 |
| 2008-05-27 09:05:00 | SPY | ETF | 137.72 | 137.8 | 137.7 | 137.75 | 223200.0 |
| 2008-05-27 09:10:00 | SPY | ETF | 137.77 | 137.83 | 137.76 | 137.79 | 111297.0 |
| 2008-05-27 09:15:00 | SPY | ETF | 137.8 | 137.91 | 137.76 | 137.86 | 560831.0 |
| 2008-05-27 09:20:00 | SPY | ETF | 137.85 | 137.98 | 137.85 | 137.91 | 243149.0 |
| 2008-05-27 09:25:00 | SPY | ETF | 137.92 | 137.92 | 137.81 | 137.81 | 119502.0 |
| 2008-05-27 09:30:00 | SPY | ETF | 137.8 | 138.01 | 137.8 | 137.82 | 3093181.0 |
| 2008-05-27 09:35:00 | SPY | ETF | 137.82 | 138.11 | 137.82 | 138.08 | 2985566.0 |
| 2008-05-27 09:40:00 | SPY | ETF | 138.07 | 138.16 | 138.02 | 138.06 | 2351466.0 |
| 2008-05-27 09:45:00 | SPY | ETF | 138.07 | 138.41 | 138.07 | 138.3 | 7156874.0 |
| 2008-05-27 09:50:00 | SPY | ETF | 138.3 | 138.32 | 138.19 | 138.2 | 2682603.0 |
| 2008-05-27 09:55:00 | SPY | ETF | 138.19 | 138.22 | 138.04 | 138.14 | 2368945.0 |
| 2008-05-27 10:00:00 | SPY | ETF | 138.13 | 138.58 | 137.89 | 138.5 | 7949426.0 |
| 2008-05-27 10:05:00 | SPY | ETF | 138.5 | 138.66 | 138.47 | 138.58 | 3386937.0 |
| 2008-05-27 10:10:00 | SPY | ETF | 138.58 | 138.63 | 138.41 | 138.45 | 2194836.0 |
| 2008-05-27 10:15:00 | SPY | ETF | 138.44 | 138.56 | 138.38 | 138.4 | 2849951.0 |
| 2008-05-27 10:20:00 | SPY | ETF | 138.4 | 138.41 | 138.31 | 138.35 | 1402512.0 |
| 2008-05-27 10:25:00 | SPY | ETF | 138.35 | 138.4 | 138.23 | 138.295 | 1713962.0 |
| 2008-05-27 10:30:00 | SPY | ETF | 138.3 | 138.39 | 138.17 | 138.21 | 1667236.0 |
| 2008-05-27 10:35:00 | SPY | ETF | 138.2 | 138.24 | 138.13 | 138.13 | 1834098.0 |
| 2008-05-27 10:40:00 | SPY | ETF | 138.13 | 138.27 | 138.12 | 138.21 | 903822.0 |
| 2008-05-27 10:45:00 | SPY | ETF | 138.21 | 138.36 | 138.21 | 138.29 | 1150071.0 |
| 2008-05-27 10:50:00 | SPY | ETF | 138.29 | 138.3 | 138.17 | 138.23 | 1116952.0 |
> showing 50 of 21,542 rows — these rows as CSV