PREVIEW / etf_5min / 2024-03-20
file: by_date/etf_5min/2024/2024-03-20.parquet size: 2.2 MB rows: 112,832
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-03-20 04:00:00 | SPY | ETF | 515.52 | 515.52 | 515.29 | 515.33 | 9684.0 |
| 2024-03-20 04:05:00 | SPY | ETF | 515.45 | 515.45 | 515.39 | 515.39 | 322.0 |
| 2024-03-20 04:10:00 | SPY | ETF | 515.39 | 515.39 | 515.39 | 515.39 | 250.0 |
| 2024-03-20 04:15:00 | SPY | ETF | 515.53 | 515.61 | 515.53 | 515.61 | 1225.0 |
| 2024-03-20 04:20:00 | SPY | ETF | 515.39 | 515.4 | 515.35 | 515.35 | 2549.0 |
| 2024-03-20 04:25:00 | SPY | ETF | 515.38 | 515.38 | 515.33 | 515.38 | 1200.0 |
| 2024-03-20 04:30:00 | SPY | ETF | 515.42 | 515.43 | 515.42 | 515.43 | 600.0 |
| 2024-03-20 04:35:00 | SPY | ETF | 515.45 | 515.45 | 515.3 | 515.3 | 2800.0 |
| 2024-03-20 04:40:00 | SPY | ETF | 515.2 | 515.2 | 515.1 | 515.18 | 3796.0 |
| 2024-03-20 04:45:00 | SPY | ETF | 515.22 | 515.22 | 515.12 | 515.12 | 289.0 |
| 2024-03-20 04:50:00 | SPY | ETF | 515.04 | 515.19 | 515.04 | 515.19 | 799.0 |
| 2024-03-20 04:55:00 | SPY | ETF | 515.3 | 515.4 | 515.3 | 515.3 | 2500.0 |
| 2024-03-20 05:00:00 | SPY | ETF | 515.31 | 515.31 | 515.06 | 515.12 | 2394.0 |
| 2024-03-20 05:10:00 | SPY | ETF | 515.26 | 515.26 | 515.26 | 515.26 | 300.0 |
| 2024-03-20 05:15:00 | SPY | ETF | 515.4 | 515.4 | 515.4 | 515.4 | 100.0 |
| 2024-03-20 05:25:00 | SPY | ETF | 515.38 | 515.45 | 515.38 | 515.42 | 625.0 |
| 2024-03-20 05:40:00 | SPY | ETF | 515.44 | 515.46 | 515.44 | 515.45 | 422.0 |
| 2024-03-20 05:45:00 | SPY | ETF | 515.33 | 515.33 | 515.3 | 515.3 | 1375.0 |
| 2024-03-20 05:50:00 | SPY | ETF | 515.35 | 515.35 | 515.22 | 515.32 | 387.0 |
| 2024-03-20 05:55:00 | SPY | ETF | 515.44 | 515.44 | 515.44 | 515.44 | 345.0 |
| 2024-03-20 06:00:00 | SPY | ETF | 515.48 | 515.48 | 515.33 | 515.33 | 525.0 |
| 2024-03-20 06:05:00 | SPY | ETF | 515.45 | 515.45 | 515.45 | 515.45 | 171.0 |
| 2024-03-20 06:10:00 | SPY | ETF | 515.52 | 515.53 | 515.47 | 515.53 | 491.0 |
| 2024-03-20 06:15:00 | SPY | ETF | 515.5 | 515.54 | 515.49 | 515.54 | 662.0 |
| 2024-03-20 06:25:00 | SPY | ETF | 515.35 | 515.35 | 515.35 | 515.35 | 111.0 |
| 2024-03-20 06:30:00 | SPY | ETF | 515.56 | 515.68 | 515.56 | 515.68 | 637.0 |
| 2024-03-20 06:35:00 | SPY | ETF | 515.7 | 515.7 | 515.66 | 515.66 | 500.0 |
| 2024-03-20 06:40:00 | SPY | ETF | 515.69 | 515.69 | 515.64 | 515.64 | 800.0 |
| 2024-03-20 06:45:00 | SPY | ETF | 515.63 | 515.63 | 515.57 | 515.57 | 785.0 |
| 2024-03-20 06:50:00 | SPY | ETF | 515.62 | 515.62 | 515.59 | 515.59 | 387.0 |
| 2024-03-20 06:55:00 | SPY | ETF | 515.62 | 515.74 | 515.62 | 515.73 | 634.0 |
| 2024-03-20 07:00:00 | SPY | ETF | 515.71 | 515.88 | 515.71 | 515.85 | 6466.0 |
| 2024-03-20 07:05:00 | SPY | ETF | 515.85 | 515.97 | 515.84 | 515.95 | 6199.0 |
| 2024-03-20 07:10:00 | SPY | ETF | 515.98 | 516.08 | 515.96 | 516.08 | 8288.0 |
| 2024-03-20 07:15:00 | SPY | ETF | 516.05 | 516.12 | 516.05 | 516.12 | 1588.0 |
| 2024-03-20 07:20:00 | SPY | ETF | 516.13 | 516.13 | 515.93 | 515.93 | 6400.0 |
| 2024-03-20 07:25:00 | SPY | ETF | 515.95 | 516.14 | 515.95 | 516.14 | 14094.0 |
| 2024-03-20 07:30:00 | SPY | ETF | 516.06 | 516.09 | 516.04 | 516.09 | 1492.0 |
| 2024-03-20 07:35:00 | SPY | ETF | 516.1 | 516.25 | 516.06 | 516.21 | 7698.0 |
| 2024-03-20 07:40:00 | SPY | ETF | 516.15 | 516.25 | 516.12 | 516.25 | 3445.0 |
| 2024-03-20 07:45:00 | SPY | ETF | 516.22 | 516.25 | 516.22 | 516.25 | 2748.0 |
| 2024-03-20 07:50:00 | SPY | ETF | 516.26 | 516.26 | 516.17 | 516.17 | 3497.0 |
| 2024-03-20 07:55:00 | SPY | ETF | 516.18 | 516.18 | 516.12 | 516.16 | 4816.0 |
| 2024-03-20 08:00:00 | SPY | ETF | 515.7109 | 516.28 | 515.17 | 516.09 | 30080.0 |
| 2024-03-20 08:05:00 | SPY | ETF | 516.05 | 516.06 | 515.83 | 515.83 | 13790.0 |
| 2024-03-20 08:10:00 | SPY | ETF | 515.88 | 515.9 | 515.71 | 515.73 | 7819.0 |
| 2024-03-20 08:15:00 | SPY | ETF | 515.7 | 515.72 | 515.6 | 515.64 | 6062.0 |
| 2024-03-20 08:20:00 | SPY | ETF | 515.63 | 515.7 | 515.54 | 515.67 | 7856.0 |
| 2024-03-20 08:25:00 | SPY | ETF | 515.67 | 515.91 | 515.67 | 515.81 | 6739.0 |
| 2024-03-20 08:30:00 | SPY | ETF | 515.81 | 515.91 | 515.81 | 515.91 | 1060.0 |
> showing 50 of 112,832 rows — these rows as CSV