PREVIEW / etf_5min / 2008-11-20
file: by_date/etf_5min/2008/2008-11-20.parquet size: 619 KB rows: 29,388
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-20 04:15:00 | SPY | ETF | 80.51 | 80.51 | 80.33 | 80.33 | 200.0 |
| 2008-11-20 04:20:00 | SPY | ETF | 80.42 | 80.42 | 80.42 | 80.42 | 100.0 |
| 2008-11-20 04:25:00 | SPY | ETF | 80.37 | 80.66 | 80.37 | 80.66 | 440.0 |
| 2008-11-20 04:30:00 | SPY | ETF | 80.54 | 80.54 | 80.54 | 80.54 | 100.0 |
| 2008-11-20 04:40:00 | SPY | ETF | 80.44 | 80.44 | 80.25 | 80.25 | 3300.0 |
| 2008-11-20 04:45:00 | SPY | ETF | 80.27 | 80.34 | 80.25 | 80.34 | 2300.0 |
| 2008-11-20 04:50:00 | SPY | ETF | 80.24 | 80.24 | 80.1 | 80.15 | 2500.0 |
| 2008-11-20 04:55:00 | SPY | ETF | 80.28 | 80.28 | 80.27 | 80.27 | 1120.0 |
| 2008-11-20 05:00:00 | SPY | ETF | 80.18 | 80.18 | 80.16 | 80.17 | 400.0 |
| 2008-11-20 05:10:00 | SPY | ETF | 80.28 | 80.34 | 80.28 | 80.34 | 2600.0 |
| 2008-11-20 05:15:00 | SPY | ETF | 80.36 | 80.36 | 80.36 | 80.36 | 100.0 |
| 2008-11-20 05:20:00 | SPY | ETF | 80.3 | 80.3 | 80.12 | 80.12 | 900.0 |
| 2008-11-20 05:25:00 | SPY | ETF | 80.1 | 80.11 | 80.03 | 80.11 | 1400.0 |
| 2008-11-20 05:30:00 | SPY | ETF | 80.12 | 80.17 | 80.0 | 80.0 | 1700.0 |
| 2008-11-20 05:35:00 | SPY | ETF | 80.11 | 80.37 | 80.11 | 80.32 | 1700.0 |
| 2008-11-20 05:40:00 | SPY | ETF | 80.39 | 80.51 | 80.39 | 80.5 | 2000.0 |
| 2008-11-20 05:45:00 | SPY | ETF | 80.39 | 80.39 | 80.29 | 80.29 | 1200.0 |
| 2008-11-20 05:50:00 | SPY | ETF | 80.17 | 80.17 | 80.1 | 80.1 | 200.0 |
| 2008-11-20 05:55:00 | SPY | ETF | 80.27 | 80.27 | 80.27 | 80.27 | 100.0 |
| 2008-11-20 06:05:00 | SPY | ETF | 80.49 | 80.5 | 80.49 | 80.5 | 200.0 |
| 2008-11-20 06:10:00 | SPY | ETF | 80.56 | 80.56 | 80.56 | 80.56 | 500.0 |
| 2008-11-20 06:15:00 | SPY | ETF | 80.35 | 80.35 | 80.3 | 80.3 | 700.0 |
| 2008-11-20 06:20:00 | SPY | ETF | 80.29 | 80.29 | 80.29 | 80.29 | 100.0 |
| 2008-11-20 06:25:00 | SPY | ETF | 80.37 | 80.37 | 80.28 | 80.28 | 4131.0 |
| 2008-11-20 06:30:00 | SPY | ETF | 80.22 | 80.22 | 80.18 | 80.2 | 10100.0 |
| 2008-11-20 06:35:00 | SPY | ETF | 80.35 | 80.41 | 80.28 | 80.41 | 22000.0 |
| 2008-11-20 06:40:00 | SPY | ETF | 80.53 | 80.63 | 80.52 | 80.63 | 16400.0 |
| 2008-11-20 06:45:00 | SPY | ETF | 80.54 | 80.54 | 80.49 | 80.49 | 10200.0 |
| 2008-11-20 06:50:00 | SPY | ETF | 80.54 | 80.72 | 80.54 | 80.7 | 19000.0 |
| 2008-11-20 06:55:00 | SPY | ETF | 80.74 | 80.78 | 80.71 | 80.75 | 43100.0 |
| 2008-11-20 07:00:00 | SPY | ETF | 80.75 | 81.2 | 80.69 | 81.19 | 134809.0 |
| 2008-11-20 07:05:00 | SPY | ETF | 81.24 | 81.25 | 80.8 | 80.82 | 70453.0 |
| 2008-11-20 07:10:00 | SPY | ETF | 80.85 | 81.61 | 80.85 | 81.43 | 147919.0 |
| 2008-11-20 07:15:00 | SPY | ETF | 81.42 | 81.48 | 81.25 | 81.35 | 129068.0 |
| 2008-11-20 07:20:00 | SPY | ETF | 81.34 | 81.41 | 81.2 | 81.28 | 82900.0 |
| 2008-11-20 07:25:00 | SPY | ETF | 81.28 | 81.46 | 81.23 | 81.26 | 109947.0 |
| 2008-11-20 07:30:00 | SPY | ETF | 81.25 | 81.31 | 81.1 | 81.15 | 87963.0 |
| 2008-11-20 07:35:00 | SPY | ETF | 81.11 | 81.2 | 80.71 | 80.73 | 213734.0 |
| 2008-11-20 07:40:00 | SPY | ETF | 80.73 | 81.0 | 80.68 | 81.0 | 91911.0 |
| 2008-11-20 07:45:00 | SPY | ETF | 81.0 | 81.22 | 80.98 | 81.2 | 74370.0 |
| 2008-11-20 07:50:00 | SPY | ETF | 81.2 | 81.35 | 81.0 | 81.04 | 136038.0 |
| 2008-11-20 07:55:00 | SPY | ETF | 81.06 | 81.17 | 80.91 | 81.02 | 162177.0 |
| 2008-11-20 08:00:00 | SPY | ETF | 81.0 | 81.8 | 80.65 | 80.95 | 493291.0 |
| 2008-11-20 08:05:00 | SPY | ETF | 80.95 | 81.05 | 80.89 | 81.0 | 283229.0 |
| 2008-11-20 08:10:00 | SPY | ETF | 81.01 | 81.5 | 81.0 | 81.22 | 166402.0 |
| 2008-11-20 08:15:00 | SPY | ETF | 81.22 | 81.27 | 81.14 | 81.19 | 155019.0 |
| 2008-11-20 08:20:00 | SPY | ETF | 81.2 | 81.23 | 81.0 | 81.01 | 124275.0 |
| 2008-11-20 08:25:00 | SPY | ETF | 81.01 | 81.05 | 80.8 | 80.85 | 195628.0 |
| 2008-11-20 08:30:00 | SPY | ETF | 80.83 | 80.87 | 80.27 | 80.27 | 2032270.0 |
| 2008-11-20 08:35:00 | SPY | ETF | 80.27 | 80.42 | 79.99 | 80.41 | 871290.0 |
> showing 50 of 29,388 rows — these rows as CSV