PREVIEW / etf_5min / 2023-04-12
file: by_date/etf_5min/2023/2023-04-12.parquet size: 2.0 MB rows: 96,867
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-12 04:00:00 | SPY | ETF | 409.91 | 410.04 | 409.9 | 410.04 | 6436.0 |
| 2023-04-12 04:05:00 | SPY | ETF | 410.06 | 410.21 | 410.06 | 410.21 | 1010.0 |
| 2023-04-12 04:10:00 | SPY | ETF | 410.26 | 410.46 | 410.24 | 410.46 | 920.0 |
| 2023-04-12 04:15:00 | SPY | ETF | 410.47 | 410.48 | 410.34 | 410.34 | 5705.0 |
| 2023-04-12 04:20:00 | SPY | ETF | 410.26 | 410.32 | 410.26 | 410.32 | 1000.0 |
| 2023-04-12 04:25:00 | SPY | ETF | 410.3 | 410.3 | 410.2 | 410.21 | 899.0 |
| 2023-04-12 04:30:00 | SPY | ETF | 410.2 | 410.25 | 410.15 | 410.15 | 800.0 |
| 2023-04-12 04:35:00 | SPY | ETF | 410.1 | 410.19 | 410.09 | 410.09 | 990.0 |
| 2023-04-12 04:40:00 | SPY | ETF | 410.08 | 410.08 | 410.08 | 410.08 | 200.0 |
| 2023-04-12 04:45:00 | SPY | ETF | 410.08 | 410.09 | 410.07 | 410.07 | 1100.0 |
| 2023-04-12 05:00:00 | SPY | ETF | 409.97 | 410.04 | 409.97 | 410.02 | 2420.0 |
| 2023-04-12 05:05:00 | SPY | ETF | 410.17 | 410.17 | 410.17 | 410.17 | 100.0 |
| 2023-04-12 05:10:00 | SPY | ETF | 410.17 | 410.17 | 410.07 | 410.07 | 1000.0 |
| 2023-04-12 05:15:00 | SPY | ETF | 410.02 | 410.02 | 410.0 | 410.0 | 400.0 |
| 2023-04-12 05:20:00 | SPY | ETF | 409.93 | 409.93 | 409.92 | 409.92 | 600.0 |
| 2023-04-12 05:25:00 | SPY | ETF | 410.07 | 410.12 | 410.06 | 410.11 | 1850.0 |
| 2023-04-12 05:30:00 | SPY | ETF | 410.16 | 410.16 | 410.14 | 410.14 | 500.0 |
| 2023-04-12 05:35:00 | SPY | ETF | 410.14 | 410.14 | 410.13 | 410.13 | 400.0 |
| 2023-04-12 05:40:00 | SPY | ETF | 410.2 | 410.2 | 410.2 | 410.2 | 200.0 |
| 2023-04-12 05:50:00 | SPY | ETF | 410.18 | 410.38 | 410.18 | 410.38 | 1297.0 |
| 2023-04-12 05:55:00 | SPY | ETF | 410.46 | 410.5 | 410.43 | 410.43 | 3853.0 |
| 2023-04-12 06:00:00 | SPY | ETF | 410.48 | 410.5 | 410.48 | 410.5 | 2100.0 |
| 2023-04-12 06:05:00 | SPY | ETF | 410.43 | 410.54 | 410.41 | 410.54 | 1006.0 |
| 2023-04-12 06:10:00 | SPY | ETF | 410.63 | 410.67 | 410.58 | 410.58 | 2130.0 |
| 2023-04-12 06:15:00 | SPY | ETF | 410.49 | 410.49 | 410.43 | 410.43 | 330.0 |
| 2023-04-12 06:20:00 | SPY | ETF | 410.46 | 410.46 | 410.39 | 410.4 | 2775.0 |
| 2023-04-12 06:25:00 | SPY | ETF | 410.48 | 410.48 | 410.46 | 410.48 | 300.0 |
| 2023-04-12 06:30:00 | SPY | ETF | 410.47 | 410.5 | 410.39 | 410.43 | 5762.0 |
| 2023-04-12 06:35:00 | SPY | ETF | 410.45 | 410.47 | 410.44 | 410.47 | 1300.0 |
| 2023-04-12 06:40:00 | SPY | ETF | 410.4 | 410.46 | 410.36 | 410.38 | 1840.0 |
| 2023-04-12 06:45:00 | SPY | ETF | 410.36 | 410.36 | 410.32 | 410.33 | 1600.0 |
| 2023-04-12 06:50:00 | SPY | ETF | 410.33 | 410.34 | 410.33 | 410.34 | 330.0 |
| 2023-04-12 06:55:00 | SPY | ETF | 410.3 | 410.3 | 410.26 | 410.26 | 955.0 |
| 2023-04-12 07:00:00 | SPY | ETF | 410.29 | 410.31 | 410.2 | 410.31 | 7814.0 |
| 2023-04-12 07:05:00 | SPY | ETF | 410.31 | 410.31 | 410.25 | 410.3 | 4778.0 |
| 2023-04-12 07:10:00 | SPY | ETF | 410.29 | 410.35 | 410.22 | 410.34 | 6052.0 |
| 2023-04-12 07:15:00 | SPY | ETF | 410.36 | 410.38 | 410.23 | 410.23 | 9862.0 |
| 2023-04-12 07:20:00 | SPY | ETF | 410.2 | 410.2 | 410.12 | 410.12 | 13947.0 |
| 2023-04-12 07:25:00 | SPY | ETF | 410.15 | 410.21 | 410.15 | 410.2 | 8819.0 |
| 2023-04-12 07:30:00 | SPY | ETF | 410.19 | 410.2 | 410.14 | 410.14 | 25053.0 |
| 2023-04-12 07:35:00 | SPY | ETF | 410.14 | 410.19 | 410.13 | 410.15 | 32952.0 |
| 2023-04-12 07:40:00 | SPY | ETF | 410.2 | 410.4 | 410.19 | 410.36 | 7525.0 |
| 2023-04-12 07:45:00 | SPY | ETF | 410.33 | 410.42 | 410.32 | 410.38 | 7478.0 |
| 2023-04-12 07:50:00 | SPY | ETF | 410.4 | 410.57 | 410.37 | 410.57 | 8434.0 |
| 2023-04-12 07:55:00 | SPY | ETF | 410.55 | 410.63 | 410.51 | 410.61 | 22327.0 |
| 2023-04-12 08:00:00 | SPY | ETF | 410.61 | 410.6104 | 409.52 | 410.32 | 71302.0 |
| 2023-04-12 08:05:00 | SPY | ETF | 410.3 | 410.3 | 410.14 | 410.16 | 19375.0 |
| 2023-04-12 08:10:00 | SPY | ETF | 410.12 | 410.23 | 409.99 | 410.0 | 47290.0 |
| 2023-04-12 08:15:00 | SPY | ETF | 410.01 | 410.03 | 409.92 | 410.01 | 89161.0 |
| 2023-04-12 08:20:00 | SPY | ETF | 410.04 | 410.24 | 410.01 | 410.18 | 48550.0 |
> showing 50 of 96,867 rows — these rows as CSV