PREVIEW / etf_5min / 2007-12-19
file: by_date/etf_5min/2007/2007-12-19.parquet size: 413 KB rows: 20,117
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-19 04:55:00 | SPY | ETF | 145.62 | 145.62 | 145.55 | 145.55 | 3600.0 |
| 2007-12-19 05:05:00 | SPY | ETF | 145.57 | 145.62 | 145.57 | 145.62 | 1400.0 |
| 2007-12-19 05:10:00 | SPY | ETF | 145.5 | 145.5 | 145.5 | 145.5 | 600.0 |
| 2007-12-19 05:15:00 | SPY | ETF | 145.43 | 145.43 | 145.4 | 145.4 | 700.0 |
| 2007-12-19 05:20:00 | SPY | ETF | 145.33 | 145.33 | 145.1 | 145.1 | 3600.0 |
| 2007-12-19 05:25:00 | SPY | ETF | 145.15 | 145.15 | 145.15 | 145.15 | 500.0 |
| 2007-12-19 05:55:00 | SPY | ETF | 145.24 | 145.24 | 145.24 | 145.24 | 2000.0 |
| 2007-12-19 06:00:00 | SPY | ETF | 145.39 | 145.39 | 145.39 | 145.39 | 1000.0 |
| 2007-12-19 06:30:00 | SPY | ETF | 145.53 | 145.53 | 145.53 | 145.53 | 2000.0 |
| 2007-12-19 06:35:00 | SPY | ETF | 145.5 | 145.51 | 145.48 | 145.51 | 16000.0 |
| 2007-12-19 06:40:00 | SPY | ETF | 145.54 | 145.54 | 145.54 | 145.54 | 1000.0 |
| 2007-12-19 06:45:00 | SPY | ETF | 145.52 | 145.62 | 145.51 | 145.54 | 16000.0 |
| 2007-12-19 06:50:00 | SPY | ETF | 145.62 | 145.62 | 145.62 | 145.62 | 30000.0 |
| 2007-12-19 06:55:00 | SPY | ETF | 145.58 | 145.58 | 145.47 | 145.47 | 3100.0 |
| 2007-12-19 07:00:00 | SPY | ETF | 145.38 | 145.47 | 145.38 | 145.42 | 33800.0 |
| 2007-12-19 07:05:00 | SPY | ETF | 145.4 | 145.4 | 145.24 | 145.29 | 92600.0 |
| 2007-12-19 07:10:00 | SPY | ETF | 145.29 | 145.39 | 145.23 | 145.35 | 27200.0 |
| 2007-12-19 07:15:00 | SPY | ETF | 145.32 | 145.37 | 145.32 | 145.37 | 17500.0 |
| 2007-12-19 07:20:00 | SPY | ETF | 145.4 | 145.4 | 145.36 | 145.4 | 6800.0 |
| 2007-12-19 07:25:00 | SPY | ETF | 145.39 | 145.39 | 145.39 | 145.39 | 5000.0 |
| 2007-12-19 07:30:00 | SPY | ETF | 145.36 | 145.39 | 145.1 | 145.31 | 324800.0 |
| 2007-12-19 07:35:00 | SPY | ETF | 145.35 | 145.8 | 145.3 | 145.7 | 234000.0 |
| 2007-12-19 07:40:00 | SPY | ETF | 145.7 | 145.86 | 145.62 | 145.83 | 223100.0 |
| 2007-12-19 07:45:00 | SPY | ETF | 145.84 | 145.86 | 145.69 | 145.69 | 165200.0 |
| 2007-12-19 07:50:00 | SPY | ETF | 145.7 | 145.73 | 145.5 | 145.5 | 224800.0 |
| 2007-12-19 07:55:00 | SPY | ETF | 145.5 | 145.62 | 145.5 | 145.5 | 97900.0 |
| 2007-12-19 08:00:00 | SPY | ETF | 145.2 | 145.78 | 145.19 | 145.72 | 762100.0 |
| 2007-12-19 08:05:00 | SPY | ETF | 145.71 | 145.71 | 145.66 | 145.66 | 445500.0 |
| 2007-12-19 08:10:00 | SPY | ETF | 145.66 | 145.69 | 145.65 | 145.69 | 24000.0 |
| 2007-12-19 08:15:00 | SPY | ETF | 145.72 | 145.74 | 145.66 | 145.73 | 76400.0 |
| 2007-12-19 08:20:00 | SPY | ETF | 145.73 | 145.87 | 145.73 | 145.86 | 165500.0 |
| 2007-12-19 08:25:00 | SPY | ETF | 145.87 | 145.97 | 145.87 | 145.95 | 122300.0 |
| 2007-12-19 08:30:00 | SPY | ETF | 145.94 | 145.94 | 145.83 | 145.9 | 87300.0 |
| 2007-12-19 08:35:00 | SPY | ETF | 145.9 | 145.91 | 145.86 | 145.9 | 43300.0 |
| 2007-12-19 08:40:00 | SPY | ETF | 145.91 | 146.343 | 145.91 | 146.03 | 203000.0 |
| 2007-12-19 08:45:00 | SPY | ETF | 146.04 | 146.08 | 145.99 | 146.04 | 402000.0 |
| 2007-12-19 08:50:00 | SPY | ETF | 146.01 | 146.01 | 145.98 | 146.01 | 62200.0 |
| 2007-12-19 08:55:00 | SPY | ETF | 146.0 | 146.04 | 145.98 | 146.03 | 87600.0 |
| 2007-12-19 09:00:00 | SPY | ETF | 146.02 | 146.16 | 146.01 | 146.15 | 248749.0 |
| 2007-12-19 09:05:00 | SPY | ETF | 146.16 | 146.2 | 146.05 | 146.12 | 203572.0 |
| 2007-12-19 09:10:00 | SPY | ETF | 146.09 | 146.17 | 146.09 | 146.15 | 68878.0 |
| 2007-12-19 09:15:00 | SPY | ETF | 146.12 | 146.18 | 146.05 | 146.07 | 211071.0 |
| 2007-12-19 09:20:00 | SPY | ETF | 146.07 | 146.08 | 145.98 | 146.01 | 32600.0 |
| 2007-12-19 09:25:00 | SPY | ETF | 146.0 | 146.06 | 145.94 | 145.94 | 341019.0 |
| 2007-12-19 09:30:00 | SPY | ETF | 145.94 | 146.16 | 145.92 | 145.95 | 3455909.0 |
| 2007-12-19 09:35:00 | SPY | ETF | 145.96 | 146.0 | 145.69 | 145.85 | 2025714.0 |
| 2007-12-19 09:40:00 | SPY | ETF | 145.84 | 146.06 | 145.79 | 146.0 | 2644517.0 |
| 2007-12-19 09:45:00 | SPY | ETF | 146.0 | 146.42 | 145.98 | 146.41 | 4346042.0 |
| 2007-12-19 09:50:00 | SPY | ETF | 146.41 | 146.53 | 146.31 | 146.47 | 5531889.0 |
| 2007-12-19 09:55:00 | SPY | ETF | 146.48 | 146.6 | 146.32 | 146.39 | 6506853.0 |
> showing 50 of 20,117 rows — these rows as CSV