PREVIEW / etf_5min / 2023-04-10
file: by_date/etf_5min/2023/2023-04-10.parquet size: 2.0 MB rows: 95,256
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-04-10 04:00:00 | SPY | ETF | 409.07 | 409.08 | 409.02 | 409.06 | 4100.0 |
| 2023-04-10 04:05:00 | SPY | ETF | 409.08 | 409.16 | 409.05 | 409.16 | 13144.0 |
| 2023-04-10 04:10:00 | SPY | ETF | 409.16 | 409.16 | 409.13 | 409.15 | 2216.0 |
| 2023-04-10 04:15:00 | SPY | ETF | 409.13 | 409.13 | 408.98 | 408.98 | 4376.0 |
| 2023-04-10 04:20:00 | SPY | ETF | 409.03 | 409.03 | 408.95 | 408.95 | 550.0 |
| 2023-04-10 04:30:00 | SPY | ETF | 408.97 | 408.97 | 408.97 | 408.97 | 150.0 |
| 2023-04-10 04:35:00 | SPY | ETF | 409.03 | 409.04 | 409.03 | 409.04 | 206.0 |
| 2023-04-10 04:40:00 | SPY | ETF | 409.05 | 409.08 | 409.05 | 409.08 | 2038.0 |
| 2023-04-10 04:50:00 | SPY | ETF | 409.11 | 409.15 | 409.07 | 409.15 | 6588.0 |
| 2023-04-10 04:55:00 | SPY | ETF | 409.13 | 409.2 | 409.13 | 409.2 | 817.0 |
| 2023-04-10 05:00:00 | SPY | ETF | 409.22 | 409.23 | 409.18 | 409.22 | 3754.0 |
| 2023-04-10 05:05:00 | SPY | ETF | 409.19 | 409.21 | 409.19 | 409.21 | 306.0 |
| 2023-04-10 05:10:00 | SPY | ETF | 409.28 | 409.34 | 409.28 | 409.3 | 1082.0 |
| 2023-04-10 05:15:00 | SPY | ETF | 409.33 | 409.33 | 409.33 | 409.33 | 100.0 |
| 2023-04-10 05:20:00 | SPY | ETF | 409.35 | 409.35 | 409.33 | 409.34 | 1314.0 |
| 2023-04-10 05:25:00 | SPY | ETF | 409.34 | 409.34 | 409.3 | 409.34 | 1150.0 |
| 2023-04-10 05:30:00 | SPY | ETF | 409.38 | 409.38 | 409.38 | 409.38 | 208.0 |
| 2023-04-10 05:35:00 | SPY | ETF | 409.41 | 409.43 | 409.37 | 409.43 | 411.0 |
| 2023-04-10 05:40:00 | SPY | ETF | 409.43 | 409.46 | 409.43 | 409.46 | 367.0 |
| 2023-04-10 05:45:00 | SPY | ETF | 409.49 | 409.49 | 409.44 | 409.44 | 1395.0 |
| 2023-04-10 05:50:00 | SPY | ETF | 409.48 | 409.48 | 409.34 | 409.34 | 1050.0 |
| 2023-04-10 06:00:00 | SPY | ETF | 409.35 | 409.43 | 409.35 | 409.43 | 1150.0 |
| 2023-04-10 06:05:00 | SPY | ETF | 409.41 | 409.42 | 409.4 | 409.42 | 347.0 |
| 2023-04-10 06:10:00 | SPY | ETF | 409.36 | 409.36 | 409.31 | 409.34 | 825.0 |
| 2023-04-10 06:15:00 | SPY | ETF | 409.45 | 409.46 | 409.42 | 409.42 | 1400.0 |
| 2023-04-10 06:20:00 | SPY | ETF | 409.43 | 409.43 | 409.39 | 409.39 | 1414.0 |
| 2023-04-10 06:25:00 | SPY | ETF | 409.38 | 409.38 | 409.35 | 409.35 | 300.0 |
| 2023-04-10 06:30:00 | SPY | ETF | 409.35 | 409.35 | 409.35 | 409.35 | 269.0 |
| 2023-04-10 06:35:00 | SPY | ETF | 409.42 | 409.46 | 409.42 | 409.46 | 400.0 |
| 2023-04-10 06:40:00 | SPY | ETF | 409.39 | 409.39 | 409.39 | 409.39 | 155.0 |
| 2023-04-10 06:45:00 | SPY | ETF | 409.41 | 409.41 | 409.31 | 409.34 | 406.0 |
| 2023-04-10 06:50:00 | SPY | ETF | 409.37 | 409.38 | 409.37 | 409.38 | 392.0 |
| 2023-04-10 06:55:00 | SPY | ETF | 409.34 | 409.36 | 409.33 | 409.33 | 1300.0 |
| 2023-04-10 07:00:00 | SPY | ETF | 409.29 | 409.32 | 409.2 | 409.2 | 4439.0 |
| 2023-04-10 07:05:00 | SPY | ETF | 409.26 | 409.32 | 409.24 | 409.32 | 5265.0 |
| 2023-04-10 07:10:00 | SPY | ETF | 409.3 | 409.3 | 409.24 | 409.26 | 1187.0 |
| 2023-04-10 07:15:00 | SPY | ETF | 409.21 | 409.22 | 409.16 | 409.16 | 2500.0 |
| 2023-04-10 07:20:00 | SPY | ETF | 409.06 | 409.06 | 408.96 | 409.0 | 4503.0 |
| 2023-04-10 07:25:00 | SPY | ETF | 408.92 | 408.95 | 408.6 | 408.62 | 7167.0 |
| 2023-04-10 07:30:00 | SPY | ETF | 408.59 | 408.59 | 408.29 | 408.34 | 8561.0 |
| 2023-04-10 07:35:00 | SPY | ETF | 408.35 | 408.43 | 408.26 | 408.27 | 8857.0 |
| 2023-04-10 07:40:00 | SPY | ETF | 408.33 | 408.46 | 408.28 | 408.4 | 34642.0 |
| 2023-04-10 07:45:00 | SPY | ETF | 408.42 | 408.42 | 408.25 | 408.34 | 17881.0 |
| 2023-04-10 07:50:00 | SPY | ETF | 408.39 | 408.5 | 408.38 | 408.5 | 4970.0 |
| 2023-04-10 07:55:00 | SPY | ETF | 408.48 | 408.48 | 408.41 | 408.45 | 2100.0 |
| 2023-04-10 08:00:00 | SPY | ETF | 408.9598 | 409.31 | 408.14 | 408.16 | 35696.0 |
| 2023-04-10 08:05:00 | SPY | ETF | 408.13 | 408.13 | 407.98 | 408.01 | 13427.0 |
| 2023-04-10 08:10:00 | SPY | ETF | 408.03 | 408.03 | 407.85 | 407.87 | 9555.0 |
| 2023-04-10 08:15:00 | SPY | ETF | 407.9 | 407.9 | 407.15 | 407.21 | 62413.0 |
| 2023-04-10 08:20:00 | SPY | ETF | 407.21 | 407.21 | 406.92 | 406.99 | 41642.0 |
> showing 50 of 95,256 rows — these rows as CSV