PREVIEW / etf_5min / 2022-06-14
file: by_date/etf_5min/2022/2022-06-14.parquet size: 2.1 MB rows: 103,106
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-06-14 04:00:00 | SPY | ETF | 379.29 | 379.6 | 378.57 | 379.0 | 10485.0 |
| 2022-06-14 04:05:00 | SPY | ETF | 378.92 | 378.92 | 378.35 | 378.47 | 5286.0 |
| 2022-06-14 04:10:00 | SPY | ETF | 378.5 | 379.04 | 378.42 | 378.82 | 5550.0 |
| 2022-06-14 04:15:00 | SPY | ETF | 378.75 | 379.0 | 378.48 | 378.48 | 4151.0 |
| 2022-06-14 04:20:00 | SPY | ETF | 378.82 | 378.82 | 378.54 | 378.64 | 400.0 |
| 2022-06-14 04:25:00 | SPY | ETF | 378.85 | 379.09 | 378.68 | 378.69 | 2725.0 |
| 2022-06-14 04:30:00 | SPY | ETF | 379.0 | 379.08 | 378.45 | 378.99 | 5682.0 |
| 2022-06-14 04:35:00 | SPY | ETF | 379.03 | 379.03 | 378.35 | 378.35 | 3179.0 |
| 2022-06-14 04:40:00 | SPY | ETF | 378.42 | 378.42 | 378.12 | 378.19 | 3261.0 |
| 2022-06-14 04:45:00 | SPY | ETF | 378.19 | 378.27 | 377.91 | 377.91 | 4893.0 |
| 2022-06-14 04:50:00 | SPY | ETF | 377.88 | 377.88 | 377.5 | 377.52 | 3370.0 |
| 2022-06-14 04:55:00 | SPY | ETF | 377.52 | 377.67 | 377.04 | 377.11 | 6042.0 |
| 2022-06-14 05:00:00 | SPY | ETF | 377.26 | 377.55 | 377.0 | 377.26 | 10052.0 |
| 2022-06-14 05:05:00 | SPY | ETF | 377.39 | 377.39 | 377.01 | 377.01 | 800.0 |
| 2022-06-14 05:10:00 | SPY | ETF | 377.15 | 377.15 | 376.75 | 376.8 | 1746.0 |
| 2022-06-14 05:15:00 | SPY | ETF | 376.72 | 377.13 | 376.64 | 377.07 | 4019.0 |
| 2022-06-14 05:20:00 | SPY | ETF | 377.14 | 377.5 | 377.11 | 377.5 | 4064.0 |
| 2022-06-14 05:25:00 | SPY | ETF | 377.48 | 377.48 | 376.83 | 376.85 | 5566.0 |
| 2022-06-14 05:30:00 | SPY | ETF | 376.96 | 377.01 | 376.82 | 376.82 | 4625.0 |
| 2022-06-14 05:35:00 | SPY | ETF | 376.97 | 377.36 | 376.97 | 377.3 | 2075.0 |
| 2022-06-14 05:40:00 | SPY | ETF | 377.35 | 377.45 | 377.34 | 377.34 | 3700.0 |
| 2022-06-14 05:45:00 | SPY | ETF | 377.39 | 377.5 | 377.3 | 377.5 | 1796.0 |
| 2022-06-14 05:50:00 | SPY | ETF | 377.3 | 377.5 | 377.18 | 377.18 | 1702.0 |
| 2022-06-14 05:55:00 | SPY | ETF | 377.08 | 377.16 | 376.86 | 376.97 | 2110.0 |
| 2022-06-14 06:00:00 | SPY | ETF | 376.65 | 376.65 | 376.04 | 376.09 | 6261.0 |
| 2022-06-14 06:05:00 | SPY | ETF | 376.17 | 376.38 | 376.12 | 376.24 | 3587.0 |
| 2022-06-14 06:10:00 | SPY | ETF | 376.38 | 376.38 | 375.91 | 375.91 | 6361.0 |
| 2022-06-14 06:15:00 | SPY | ETF | 375.88 | 375.88 | 375.69 | 375.69 | 2915.0 |
| 2022-06-14 06:20:00 | SPY | ETF | 375.72 | 376.21 | 375.64 | 375.73 | 4780.0 |
| 2022-06-14 06:25:00 | SPY | ETF | 375.78 | 375.92 | 375.74 | 375.77 | 5400.0 |
| 2022-06-14 06:30:00 | SPY | ETF | 375.69 | 376.65 | 375.61 | 376.54 | 18610.0 |
| 2022-06-14 06:35:00 | SPY | ETF | 376.58 | 376.72 | 376.29 | 376.35 | 16055.0 |
| 2022-06-14 06:40:00 | SPY | ETF | 376.73 | 376.73 | 376.73 | 376.73 | 700.0 |
| 2022-06-14 06:45:00 | SPY | ETF | 376.8 | 377.3 | 376.8 | 377.12 | 16346.0 |
| 2022-06-14 06:50:00 | SPY | ETF | 377.09 | 377.29 | 376.9 | 376.9 | 13398.0 |
| 2022-06-14 06:55:00 | SPY | ETF | 376.93 | 376.95 | 376.8 | 376.82 | 27385.0 |
| 2022-06-14 07:00:00 | SPY | ETF | 376.77 | 376.89 | 376.3 | 376.59 | 11333.0 |
| 2022-06-14 07:05:00 | SPY | ETF | 376.56 | 376.62 | 376.0 | 376.06 | 94881.0 |
| 2022-06-14 07:10:00 | SPY | ETF | 376.03 | 376.65 | 376.01 | 376.65 | 47782.0 |
| 2022-06-14 07:15:00 | SPY | ETF | 376.61 | 376.62 | 376.4 | 376.44 | 9741.0 |
| 2022-06-14 07:20:00 | SPY | ETF | 376.66 | 376.9 | 376.62 | 376.75 | 48787.0 |
| 2022-06-14 07:25:00 | SPY | ETF | 376.7 | 376.81 | 376.55 | 376.58 | 2990.0 |
| 2022-06-14 07:30:00 | SPY | ETF | 376.49 | 376.72 | 376.25 | 376.3 | 43294.0 |
| 2022-06-14 07:35:00 | SPY | ETF | 376.31 | 376.31 | 375.82 | 376.03 | 42150.0 |
| 2022-06-14 07:40:00 | SPY | ETF | 376.01 | 376.02 | 375.8 | 375.84 | 6906.0 |
| 2022-06-14 07:45:00 | SPY | ETF | 375.76 | 376.03 | 375.51 | 375.91 | 32527.0 |
| 2022-06-14 07:50:00 | SPY | ETF | 375.91 | 376.14 | 375.74 | 375.75 | 18443.0 |
| 2022-06-14 07:55:00 | SPY | ETF | 375.7 | 375.88 | 375.4 | 375.49 | 58799.0 |
| 2022-06-14 08:00:00 | SPY | ETF | 376.8674 | 380.3 | 375.4201 | 376.4 | 107941.0 |
| 2022-06-14 08:05:00 | SPY | ETF | 376.41 | 376.6 | 376.25 | 376.25 | 40715.0 |
> showing 50 of 103,106 rows — these rows as CSV