PREVIEW / etf_5min / 2022-03-17
file: by_date/etf_5min/2022/2022-03-17.parquet size: 2.0 MB rows: 95,953
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-17 04:00:00 | SPY | ETF | 436.06 | 436.06 | 435.87 | 436.0 | 3853.0 |
| 2022-03-17 04:05:00 | SPY | ETF | 436.09 | 436.1 | 435.36 | 435.44 | 3820.0 |
| 2022-03-17 04:10:00 | SPY | ETF | 435.44 | 435.44 | 435.33 | 435.33 | 710.0 |
| 2022-03-17 04:15:00 | SPY | ETF | 435.37 | 435.5 | 435.37 | 435.5 | 300.0 |
| 2022-03-17 04:20:00 | SPY | ETF | 435.58 | 435.65 | 435.35 | 435.65 | 2310.0 |
| 2022-03-17 04:25:00 | SPY | ETF | 435.67 | 436.06 | 435.67 | 435.78 | 5450.0 |
| 2022-03-17 04:30:00 | SPY | ETF | 435.72 | 435.87 | 435.51 | 435.51 | 2850.0 |
| 2022-03-17 04:35:00 | SPY | ETF | 435.65 | 435.65 | 435.25 | 435.32 | 5720.0 |
| 2022-03-17 04:40:00 | SPY | ETF | 435.39 | 435.46 | 435.01 | 435.01 | 4244.0 |
| 2022-03-17 04:45:00 | SPY | ETF | 435.48 | 435.69 | 435.46 | 435.46 | 2500.0 |
| 2022-03-17 04:50:00 | SPY | ETF | 435.23 | 435.27 | 434.92 | 434.92 | 1401.0 |
| 2022-03-17 04:55:00 | SPY | ETF | 434.96 | 435.25 | 434.62 | 435.1 | 7006.0 |
| 2022-03-17 05:00:00 | SPY | ETF | 435.29 | 435.34 | 435.15 | 435.15 | 2000.0 |
| 2022-03-17 05:05:00 | SPY | ETF | 435.05 | 435.05 | 434.85 | 434.85 | 1963.0 |
| 2022-03-17 05:10:00 | SPY | ETF | 434.94 | 434.94 | 434.83 | 434.94 | 325.0 |
| 2022-03-17 05:15:00 | SPY | ETF | 434.78 | 434.99 | 434.63 | 434.68 | 3236.0 |
| 2022-03-17 05:20:00 | SPY | ETF | 434.6 | 434.7 | 434.6 | 434.7 | 554.0 |
| 2022-03-17 05:25:00 | SPY | ETF | 434.79 | 434.94 | 434.79 | 434.94 | 700.0 |
| 2022-03-17 05:30:00 | SPY | ETF | 434.95 | 434.95 | 434.65 | 434.65 | 1000.0 |
| 2022-03-17 05:35:00 | SPY | ETF | 434.45 | 434.45 | 434.18 | 434.3 | 3752.0 |
| 2022-03-17 05:40:00 | SPY | ETF | 434.3 | 434.52 | 434.25 | 434.52 | 327.0 |
| 2022-03-17 05:45:00 | SPY | ETF | 434.38 | 434.38 | 434.28 | 434.28 | 500.0 |
| 2022-03-17 05:50:00 | SPY | ETF | 434.25 | 434.52 | 434.23 | 434.51 | 1620.0 |
| 2022-03-17 05:55:00 | SPY | ETF | 434.6 | 434.8 | 434.6 | 434.66 | 1723.0 |
| 2022-03-17 06:00:00 | SPY | ETF | 434.79 | 434.79 | 433.0 | 433.37 | 67587.0 |
| 2022-03-17 06:05:00 | SPY | ETF | 433.24 | 433.3 | 432.65 | 432.84 | 6804.0 |
| 2022-03-17 06:10:00 | SPY | ETF | 432.79 | 433.31 | 432.68 | 433.26 | 10304.0 |
| 2022-03-17 06:15:00 | SPY | ETF | 433.17 | 433.61 | 433.01 | 433.61 | 12867.0 |
| 2022-03-17 06:20:00 | SPY | ETF | 433.56 | 433.94 | 433.56 | 433.89 | 1035.0 |
| 2022-03-17 06:25:00 | SPY | ETF | 433.78 | 433.82 | 433.6 | 433.79 | 2438.0 |
| 2022-03-17 06:30:00 | SPY | ETF | 433.79 | 434.25 | 433.79 | 434.13 | 23570.0 |
| 2022-03-17 06:35:00 | SPY | ETF | 434.05 | 434.09 | 433.74 | 434.05 | 35600.0 |
| 2022-03-17 06:40:00 | SPY | ETF | 434.0 | 434.11 | 433.81 | 434.03 | 4855.0 |
| 2022-03-17 06:45:00 | SPY | ETF | 434.05 | 434.21 | 433.92 | 434.21 | 24032.0 |
| 2022-03-17 06:50:00 | SPY | ETF | 434.21 | 434.23 | 433.96 | 434.11 | 2325.0 |
| 2022-03-17 06:55:00 | SPY | ETF | 434.13 | 434.5 | 434.13 | 434.5 | 18000.0 |
| 2022-03-17 07:00:00 | SPY | ETF | 434.53 | 434.84 | 434.41 | 434.81 | 20216.0 |
| 2022-03-17 07:05:00 | SPY | ETF | 434.84 | 434.99 | 434.74 | 434.91 | 44099.0 |
| 2022-03-17 07:10:00 | SPY | ETF | 434.75 | 434.79 | 434.68 | 434.709 | 18754.0 |
| 2022-03-17 07:15:00 | SPY | ETF | 434.74 | 434.9 | 434.5 | 434.5 | 19260.0 |
| 2022-03-17 07:20:00 | SPY | ETF | 434.5 | 434.53 | 434.2 | 434.36 | 26938.0 |
| 2022-03-17 07:25:00 | SPY | ETF | 434.35 | 434.39 | 434.03 | 434.25 | 19125.0 |
| 2022-03-17 07:30:00 | SPY | ETF | 434.25 | 434.38 | 434.13 | 434.27 | 35100.0 |
| 2022-03-17 07:35:00 | SPY | ETF | 434.17 | 434.3 | 433.85 | 433.85 | 24972.0 |
| 2022-03-17 07:40:00 | SPY | ETF | 433.87 | 433.99 | 433.62 | 433.7 | 16261.0 |
| 2022-03-17 07:45:00 | SPY | ETF | 433.73 | 434.06 | 433.65 | 433.81 | 24177.0 |
| 2022-03-17 07:50:00 | SPY | ETF | 433.8 | 434.03 | 433.8 | 434.0 | 17239.0 |
| 2022-03-17 07:55:00 | SPY | ETF | 434.05 | 434.48 | 434.05 | 434.18 | 25843.0 |
| 2022-03-17 08:00:00 | SPY | ETF | 433.7201 | 436.69 | 433.3596 | 434.6899 | 135745.0 |
| 2022-03-17 08:05:00 | SPY | ETF | 434.64 | 434.98 | 434.42 | 434.59 | 35666.0 |
> showing 50 of 95,953 rows — these rows as CSV