PREVIEW / etf_5min / 2024-08-14
file: by_date/etf_5min/2024/2024-08-14.parquet size: 2.2 MB rows: 109,934
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-14 04:00:00 | SPY | ETF | 542.04 | 542.09 | 541.87 | 541.89 | 5460.0 |
| 2024-08-14 04:05:00 | SPY | ETF | 542.0 | 542.02 | 541.78 | 541.79 | 3854.0 |
| 2024-08-14 04:10:00 | SPY | ETF | 541.72 | 541.87 | 541.69 | 541.74 | 3394.0 |
| 2024-08-14 04:15:00 | SPY | ETF | 541.72 | 541.72 | 541.64 | 541.64 | 814.0 |
| 2024-08-14 04:20:00 | SPY | ETF | 542.02 | 542.04 | 542.02 | 542.04 | 350.0 |
| 2024-08-14 04:25:00 | SPY | ETF | 542.03 | 542.03 | 541.87 | 541.89 | 770.0 |
| 2024-08-14 04:30:00 | SPY | ETF | 542.12 | 542.12 | 542.12 | 542.12 | 100.0 |
| 2024-08-14 04:35:00 | SPY | ETF | 542.09 | 542.09 | 542.04 | 542.04 | 218.0 |
| 2024-08-14 04:40:00 | SPY | ETF | 542.05 | 542.09 | 541.99 | 542.06 | 998.0 |
| 2024-08-14 04:45:00 | SPY | ETF | 542.07 | 542.15 | 541.99 | 541.99 | 1666.0 |
| 2024-08-14 04:50:00 | SPY | ETF | 542.11 | 542.12 | 542.05 | 542.12 | 798.0 |
| 2024-08-14 04:55:00 | SPY | ETF | 542.04 | 542.13 | 542.04 | 542.13 | 454.0 |
| 2024-08-14 05:00:00 | SPY | ETF | 542.15 | 542.17 | 542.15 | 542.17 | 600.0 |
| 2024-08-14 05:05:00 | SPY | ETF | 542.1 | 542.1 | 542.1 | 542.1 | 200.0 |
| 2024-08-14 05:10:00 | SPY | ETF | 542.16 | 542.16 | 542.09 | 542.09 | 397.0 |
| 2024-08-14 05:15:00 | SPY | ETF | 542.17 | 542.17 | 542.05 | 542.05 | 1465.0 |
| 2024-08-14 05:20:00 | SPY | ETF | 542.16 | 542.28 | 542.16 | 542.28 | 418.0 |
| 2024-08-14 05:25:00 | SPY | ETF | 542.2 | 542.2 | 542.15 | 542.16 | 1120.0 |
| 2024-08-14 05:30:00 | SPY | ETF | 542.16 | 542.16 | 542.16 | 542.16 | 1613.0 |
| 2024-08-14 05:35:00 | SPY | ETF | 542.3 | 542.3 | 542.3 | 542.3 | 159.0 |
| 2024-08-14 05:40:00 | SPY | ETF | 542.19 | 542.19 | 542.19 | 542.19 | 100.0 |
| 2024-08-14 05:50:00 | SPY | ETF | 542.19 | 542.25 | 542.1 | 542.25 | 10041.0 |
| 2024-08-14 05:55:00 | SPY | ETF | 542.12 | 542.12 | 542.12 | 542.12 | 1004.0 |
| 2024-08-14 06:00:00 | SPY | ETF | 542.15 | 542.4 | 542.15 | 542.4 | 2197.0 |
| 2024-08-14 06:05:00 | SPY | ETF | 542.34 | 542.4 | 542.33 | 542.33 | 3330.0 |
| 2024-08-14 06:10:00 | SPY | ETF | 542.27 | 542.32 | 542.27 | 542.28 | 1067.0 |
| 2024-08-14 06:15:00 | SPY | ETF | 542.2 | 542.2 | 542.09 | 542.15 | 980.0 |
| 2024-08-14 06:25:00 | SPY | ETF | 542.3 | 542.31 | 542.3 | 542.31 | 319.0 |
| 2024-08-14 06:30:00 | SPY | ETF | 542.32 | 542.39 | 542.26 | 542.31 | 1888.0 |
| 2024-08-14 06:35:00 | SPY | ETF | 542.27 | 542.34 | 542.27 | 542.34 | 1560.0 |
| 2024-08-14 06:40:00 | SPY | ETF | 542.37 | 542.37 | 542.37 | 542.37 | 100.0 |
| 2024-08-14 06:45:00 | SPY | ETF | 542.5 | 542.5 | 542.38 | 542.38 | 927.0 |
| 2024-08-14 06:50:00 | SPY | ETF | 542.35 | 542.35 | 542.32 | 542.32 | 866.0 |
| 2024-08-14 06:55:00 | SPY | ETF | 542.29 | 542.29 | 542.13 | 542.2 | 3163.0 |
| 2024-08-14 07:00:00 | SPY | ETF | 542.28 | 542.31 | 542.17 | 542.251 | 16490.0 |
| 2024-08-14 07:05:00 | SPY | ETF | 542.2 | 542.23 | 542.12 | 542.18 | 10681.0 |
| 2024-08-14 07:10:00 | SPY | ETF | 542.12 | 542.12 | 542.05 | 542.07 | 2737.0 |
| 2024-08-14 07:15:00 | SPY | ETF | 542.08 | 542.15 | 542.01 | 542.04 | 12922.0 |
| 2024-08-14 07:20:00 | SPY | ETF | 542.02 | 542.14 | 541.99 | 542.14 | 20959.0 |
| 2024-08-14 07:25:00 | SPY | ETF | 542.14 | 542.32 | 542.1 | 542.12 | 21011.0 |
| 2024-08-14 07:30:00 | SPY | ETF | 542.21 | 542.21 | 542.01 | 542.09 | 2650.0 |
| 2024-08-14 07:35:00 | SPY | ETF | 542.15 | 542.24 | 542.15 | 542.21 | 1372.0 |
| 2024-08-14 07:40:00 | SPY | ETF | 542.19 | 542.25 | 542.07 | 542.15 | 18663.0 |
| 2024-08-14 07:45:00 | SPY | ETF | 542.16 | 542.34 | 542.16 | 542.31 | 26335.0 |
| 2024-08-14 07:50:00 | SPY | ETF | 542.27 | 542.43 | 542.22 | 542.3 | 4188.0 |
| 2024-08-14 07:55:00 | SPY | ETF | 542.3 | 542.41 | 542.27 | 542.28 | 13148.0 |
| 2024-08-14 08:00:00 | SPY | ETF | 542.25 | 542.4496 | 542.01 | 542.2995 | 16743.0 |
| 2024-08-14 08:05:00 | SPY | ETF | 542.35 | 542.35 | 542.23 | 542.3 | 9338.0 |
| 2024-08-14 08:10:00 | SPY | ETF | 542.27 | 542.34 | 542.13 | 542.23 | 17065.0 |
| 2024-08-14 08:15:00 | SPY | ETF | 542.2 | 542.31 | 542.15 | 542.2 | 9521.0 |
> showing 50 of 109,934 rows — these rows as CSV