PREVIEW / etf_5min / 2023-12-06
file: by_date/etf_5min/2023/2023-12-06.parquet size: 2.2 MB rows: 107,502
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-12-06 04:00:00 | SPY | ETF | 457.62 | 457.65 | 457.6 | 457.6 | 4071.0 |
| 2023-12-06 04:05:00 | SPY | ETF | 457.67 | 457.67 | 457.6 | 457.6 | 1308.0 |
| 2023-12-06 04:10:00 | SPY | ETF | 457.69 | 457.85 | 457.69 | 457.85 | 1235.0 |
| 2023-12-06 04:15:00 | SPY | ETF | 457.62 | 457.66 | 457.62 | 457.66 | 329.0 |
| 2023-12-06 04:20:00 | SPY | ETF | 457.56 | 457.56 | 457.56 | 457.56 | 135.0 |
| 2023-12-06 04:25:00 | SPY | ETF | 457.51 | 457.55 | 457.48 | 457.55 | 1023.0 |
| 2023-12-06 04:30:00 | SPY | ETF | 457.63 | 457.64 | 457.49 | 457.49 | 1985.0 |
| 2023-12-06 04:35:00 | SPY | ETF | 457.4 | 457.4 | 457.4 | 457.4 | 300.0 |
| 2023-12-06 04:45:00 | SPY | ETF | 457.45 | 457.45 | 457.45 | 457.45 | 300.0 |
| 2023-12-06 04:50:00 | SPY | ETF | 457.5 | 457.5 | 457.47 | 457.5 | 430.0 |
| 2023-12-06 05:00:00 | SPY | ETF | 457.52 | 457.52 | 457.52 | 457.52 | 197.0 |
| 2023-12-06 05:10:00 | SPY | ETF | 457.61 | 457.61 | 457.54 | 457.54 | 1250.0 |
| 2023-12-06 05:15:00 | SPY | ETF | 457.59 | 457.59 | 457.58 | 457.58 | 250.0 |
| 2023-12-06 05:20:00 | SPY | ETF | 457.62 | 457.62 | 457.47 | 457.47 | 11739.0 |
| 2023-12-06 05:25:00 | SPY | ETF | 457.54 | 457.54 | 457.54 | 457.54 | 100.0 |
| 2023-12-06 05:30:00 | SPY | ETF | 457.68 | 457.69 | 457.68 | 457.69 | 700.0 |
| 2023-12-06 05:35:00 | SPY | ETF | 457.66 | 457.66 | 457.62 | 457.62 | 957.0 |
| 2023-12-06 05:40:00 | SPY | ETF | 457.64 | 457.82 | 457.64 | 457.79 | 554.0 |
| 2023-12-06 05:45:00 | SPY | ETF | 457.85 | 457.85 | 457.76 | 457.76 | 2346.0 |
| 2023-12-06 05:50:00 | SPY | ETF | 457.83 | 457.83 | 457.81 | 457.81 | 747.0 |
| 2023-12-06 05:55:00 | SPY | ETF | 457.95 | 457.96 | 457.95 | 457.96 | 990.0 |
| 2023-12-06 06:00:00 | SPY | ETF | 457.85 | 457.85 | 457.85 | 457.85 | 400.0 |
| 2023-12-06 06:10:00 | SPY | ETF | 457.54 | 457.6 | 457.54 | 457.6 | 12714.0 |
| 2023-12-06 06:15:00 | SPY | ETF | 457.63 | 457.63 | 457.52 | 457.52 | 2586.0 |
| 2023-12-06 06:20:00 | SPY | ETF | 457.49 | 457.57 | 457.48 | 457.48 | 1000.0 |
| 2023-12-06 06:25:00 | SPY | ETF | 457.51 | 457.51 | 457.5 | 457.5 | 1792.0 |
| 2023-12-06 06:30:00 | SPY | ETF | 457.39 | 457.4 | 457.32 | 457.32 | 1300.0 |
| 2023-12-06 06:35:00 | SPY | ETF | 457.31 | 457.34 | 457.31 | 457.34 | 500.0 |
| 2023-12-06 06:40:00 | SPY | ETF | 457.29 | 457.34 | 457.29 | 457.34 | 887.0 |
| 2023-12-06 06:45:00 | SPY | ETF | 457.4 | 457.52 | 457.4 | 457.52 | 10549.0 |
| 2023-12-06 06:55:00 | SPY | ETF | 457.52 | 457.52 | 457.52 | 457.52 | 3000.0 |
| 2023-12-06 07:00:00 | SPY | ETF | 457.46 | 457.47 | 457.35 | 457.35 | 6735.0 |
| 2023-12-06 07:05:00 | SPY | ETF | 457.45 | 457.45 | 457.28 | 457.3 | 7456.0 |
| 2023-12-06 07:10:00 | SPY | ETF | 457.28 | 457.32 | 457.25 | 457.25 | 40263.0 |
| 2023-12-06 07:15:00 | SPY | ETF | 457.2 | 457.29 | 457.14 | 457.29 | 9378.0 |
| 2023-12-06 07:20:00 | SPY | ETF | 457.24 | 457.32 | 457.18 | 457.32 | 5794.0 |
| 2023-12-06 07:25:00 | SPY | ETF | 457.21 | 457.24 | 457.14 | 457.22 | 2926.0 |
| 2023-12-06 07:30:00 | SPY | ETF | 457.25 | 457.3 | 457.25 | 457.3 | 4550.0 |
| 2023-12-06 07:35:00 | SPY | ETF | 457.35 | 457.36 | 457.3 | 457.3 | 3069.0 |
| 2023-12-06 07:40:00 | SPY | ETF | 457.33 | 457.38 | 457.3 | 457.3 | 4097.0 |
| 2023-12-06 07:45:00 | SPY | ETF | 457.32 | 457.4 | 457.32 | 457.4 | 7190.0 |
| 2023-12-06 07:50:00 | SPY | ETF | 457.41 | 457.519 | 457.38 | 457.5 | 8043.0 |
| 2023-12-06 07:55:00 | SPY | ETF | 457.49 | 457.54 | 457.49 | 457.54 | 4135.0 |
| 2023-12-06 08:00:00 | SPY | ETF | 457.37 | 458.07 | 457.17 | 457.52 | 63940.0 |
| 2023-12-06 08:05:00 | SPY | ETF | 457.5 | 457.5 | 457.33 | 457.49 | 13350.0 |
| 2023-12-06 08:10:00 | SPY | ETF | 457.52 | 457.56 | 457.43 | 457.53 | 11152.0 |
| 2023-12-06 08:15:00 | SPY | ETF | 457.54 | 457.81 | 457.54 | 457.55 | 55575.0 |
| 2023-12-06 08:20:00 | SPY | ETF | 457.58 | 457.63 | 457.5408 | 457.55 | 13920.0 |
| 2023-12-06 08:25:00 | SPY | ETF | 457.58 | 457.79 | 457.58 | 457.78 | 38474.0 |
| 2023-12-06 08:30:00 | SPY | ETF | 457.79 | 458.58 | 457.79 | 458.44 | 137264.0 |
> showing 50 of 107,502 rows — these rows as CSV