PREVIEW / etf_5min / 2023-01-13
file: by_date/etf_5min/2023/2023-01-13.parquet size: 2.0 MB rows: 97,192
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-13 04:00:00 | SPY | ETF | 396.92 | 396.99 | 396.67 | 396.99 | 16764.0 |
| 2023-01-13 04:05:00 | SPY | ETF | 397.06 | 397.09 | 397.01 | 397.09 | 3704.0 |
| 2023-01-13 04:10:00 | SPY | ETF | 397.11 | 397.2 | 397.11 | 397.17 | 1165.0 |
| 2023-01-13 04:15:00 | SPY | ETF | 397.18 | 397.18 | 396.89 | 396.89 | 3715.0 |
| 2023-01-13 04:20:00 | SPY | ETF | 396.97 | 396.98 | 396.8 | 396.83 | 1096.0 |
| 2023-01-13 04:25:00 | SPY | ETF | 396.68 | 396.68 | 396.5 | 396.5 | 350.0 |
| 2023-01-13 04:30:00 | SPY | ETF | 396.51 | 396.73 | 396.51 | 396.69 | 2390.0 |
| 2023-01-13 04:35:00 | SPY | ETF | 396.79 | 396.79 | 396.79 | 396.79 | 100.0 |
| 2023-01-13 04:40:00 | SPY | ETF | 396.61 | 396.86 | 396.6 | 396.86 | 2368.0 |
| 2023-01-13 04:45:00 | SPY | ETF | 396.84 | 396.93 | 396.84 | 396.93 | 430.0 |
| 2023-01-13 04:50:00 | SPY | ETF | 396.85 | 397.22 | 396.78 | 397.17 | 7144.0 |
| 2023-01-13 04:55:00 | SPY | ETF | 397.11 | 397.23 | 397.05 | 397.05 | 12189.0 |
| 2023-01-13 05:00:00 | SPY | ETF | 397.06 | 397.07 | 396.99 | 396.99 | 3112.0 |
| 2023-01-13 05:05:00 | SPY | ETF | 397.08 | 397.09 | 397.0 | 397.0 | 3015.0 |
| 2023-01-13 05:10:00 | SPY | ETF | 397.07 | 397.23 | 397.07 | 397.23 | 1320.0 |
| 2023-01-13 05:15:00 | SPY | ETF | 397.2 | 397.22 | 397.2 | 397.22 | 3090.0 |
| 2023-01-13 05:20:00 | SPY | ETF | 397.22 | 397.31 | 397.13 | 397.15 | 3390.0 |
| 2023-01-13 05:25:00 | SPY | ETF | 397.11 | 397.12 | 397.0 | 397.06 | 2408.0 |
| 2023-01-13 05:30:00 | SPY | ETF | 397.03 | 397.03 | 397.0 | 397.02 | 1030.0 |
| 2023-01-13 05:35:00 | SPY | ETF | 397.12 | 397.12 | 397.0 | 397.07 | 1737.0 |
| 2023-01-13 05:40:00 | SPY | ETF | 397.1 | 397.1 | 397.05 | 397.05 | 500.0 |
| 2023-01-13 05:45:00 | SPY | ETF | 397.01 | 397.01 | 397.01 | 397.01 | 300.0 |
| 2023-01-13 05:50:00 | SPY | ETF | 397.01 | 397.01 | 396.84 | 396.88 | 1200.0 |
| 2023-01-13 05:55:00 | SPY | ETF | 396.87 | 397.07 | 396.87 | 397.07 | 720.0 |
| 2023-01-13 06:00:00 | SPY | ETF | 397.0 | 397.0 | 396.84 | 396.85 | 4450.0 |
| 2023-01-13 06:05:00 | SPY | ETF | 396.74 | 396.78 | 396.72 | 396.72 | 3029.0 |
| 2023-01-13 06:10:00 | SPY | ETF | 396.65 | 396.85 | 396.64 | 396.85 | 2628.0 |
| 2023-01-13 06:15:00 | SPY | ETF | 396.85 | 396.93 | 396.72 | 396.72 | 2500.0 |
| 2023-01-13 06:20:00 | SPY | ETF | 396.71 | 396.71 | 396.5 | 396.6 | 19653.0 |
| 2023-01-13 06:25:00 | SPY | ETF | 396.53 | 396.58 | 396.24 | 396.27 | 4083.0 |
| 2023-01-13 06:30:00 | SPY | ETF | 396.26 | 396.26 | 395.9 | 395.9 | 5350.0 |
| 2023-01-13 06:35:00 | SPY | ETF | 395.91 | 396.03 | 395.58 | 395.58 | 6889.0 |
| 2023-01-13 06:40:00 | SPY | ETF | 395.63 | 396.02 | 395.63 | 396.0 | 15050.0 |
| 2023-01-13 06:45:00 | SPY | ETF | 396.02 | 396.26 | 395.7 | 395.84 | 24130.0 |
| 2023-01-13 06:50:00 | SPY | ETF | 395.74 | 395.98 | 395.39 | 395.4 | 37053.0 |
| 2023-01-13 06:55:00 | SPY | ETF | 395.58 | 395.64 | 395.38 | 395.51 | 21422.0 |
| 2023-01-13 07:00:00 | SPY | ETF | 395.56 | 395.78 | 395.56 | 395.78 | 25121.0 |
| 2023-01-13 07:05:00 | SPY | ETF | 395.79 | 395.79 | 395.41 | 395.46 | 10464.0 |
| 2023-01-13 07:10:00 | SPY | ETF | 395.6 | 395.6 | 395.3 | 395.4 | 9865.0 |
| 2023-01-13 07:15:00 | SPY | ETF | 395.42 | 395.62 | 395.35 | 395.42 | 5379.0 |
| 2023-01-13 07:20:00 | SPY | ETF | 395.35 | 395.35 | 394.57 | 394.59 | 29739.0 |
| 2023-01-13 07:25:00 | SPY | ETF | 394.55 | 394.55 | 394.14 | 394.18 | 15651.0 |
| 2023-01-13 07:30:00 | SPY | ETF | 394.18 | 394.62 | 393.99 | 394.54 | 30460.0 |
| 2023-01-13 07:35:00 | SPY | ETF | 394.55 | 394.57 | 394.25 | 394.26 | 29749.0 |
| 2023-01-13 07:40:00 | SPY | ETF | 394.25 | 394.25 | 393.87 | 393.9 | 20747.0 |
| 2023-01-13 07:45:00 | SPY | ETF | 393.9 | 394.16 | 393.79 | 393.88 | 37522.0 |
| 2023-01-13 07:50:00 | SPY | ETF | 393.88 | 393.95 | 393.56 | 393.56 | 38268.0 |
| 2023-01-13 07:55:00 | SPY | ETF | 393.57 | 393.61 | 393.43 | 393.5 | 80761.0 |
| 2023-01-13 08:00:00 | SPY | ETF | 395.65 | 397.1504 | 393.41 | 393.43 | 107561.0 |
| 2023-01-13 08:05:00 | SPY | ETF | 393.44 | 393.53 | 393.16 | 393.23 | 37588.0 |
> showing 50 of 97,192 rows — these rows as CSV