PREVIEW / etf_5min / 2022-03-11
file: by_date/etf_5min/2022/2022-03-11.parquet size: 2.0 MB rows: 94,793
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-11 04:00:00 | SPY | ETF | 425.67 | 425.74 | 425.53 | 425.59 | 2510.0 |
| 2022-03-11 04:05:00 | SPY | ETF | 425.7 | 426.3 | 425.7 | 426.12 | 9123.0 |
| 2022-03-11 04:10:00 | SPY | ETF | 426.24 | 426.63 | 426.24 | 426.63 | 720.0 |
| 2022-03-11 04:15:00 | SPY | ETF | 426.58 | 426.65 | 426.37 | 426.5 | 3137.0 |
| 2022-03-11 04:20:00 | SPY | ETF | 426.65 | 426.88 | 426.58 | 426.61 | 4300.0 |
| 2022-03-11 04:25:00 | SPY | ETF | 426.86 | 426.9 | 426.65 | 426.65 | 1200.0 |
| 2022-03-11 04:30:00 | SPY | ETF | 426.4 | 426.5 | 426.4 | 426.48 | 500.0 |
| 2022-03-11 04:35:00 | SPY | ETF | 426.39 | 426.43 | 426.2 | 426.2 | 3800.0 |
| 2022-03-11 04:40:00 | SPY | ETF | 426.02 | 426.19 | 426.0 | 426.19 | 6184.0 |
| 2022-03-11 04:45:00 | SPY | ETF | 426.39 | 426.87 | 426.38 | 426.87 | 8296.0 |
| 2022-03-11 04:50:00 | SPY | ETF | 426.8 | 427.13 | 426.8 | 427.12 | 900.0 |
| 2022-03-11 04:55:00 | SPY | ETF | 426.91 | 426.91 | 426.91 | 426.91 | 100.0 |
| 2022-03-11 05:00:00 | SPY | ETF | 427.2 | 427.79 | 427.2 | 427.78 | 9600.0 |
| 2022-03-11 05:05:00 | SPY | ETF | 428.0 | 428.03 | 427.6 | 427.6 | 6397.0 |
| 2022-03-11 05:10:00 | SPY | ETF | 427.59 | 427.59 | 427.42 | 427.42 | 250.0 |
| 2022-03-11 05:15:00 | SPY | ETF | 427.44 | 427.59 | 427.34 | 427.34 | 3500.0 |
| 2022-03-11 05:20:00 | SPY | ETF | 427.39 | 427.41 | 427.39 | 427.41 | 400.0 |
| 2022-03-11 05:25:00 | SPY | ETF | 428.0 | 428.0 | 427.93 | 427.93 | 1770.0 |
| 2022-03-11 05:30:00 | SPY | ETF | 427.75 | 427.75 | 427.63 | 427.63 | 4550.0 |
| 2022-03-11 05:35:00 | SPY | ETF | 427.68 | 427.73 | 427.33 | 427.33 | 840.0 |
| 2022-03-11 05:40:00 | SPY | ETF | 427.16 | 427.16 | 427.01 | 427.01 | 1000.0 |
| 2022-03-11 05:45:00 | SPY | ETF | 427.28 | 427.34 | 427.28 | 427.3 | 1350.0 |
| 2022-03-11 05:50:00 | SPY | ETF | 427.3 | 427.3 | 426.95 | 426.95 | 1200.0 |
| 2022-03-11 05:55:00 | SPY | ETF | 427.54 | 427.56 | 427.54 | 427.56 | 220.0 |
| 2022-03-11 06:00:00 | SPY | ETF | 427.34 | 427.4 | 427.34 | 427.4 | 595.0 |
| 2022-03-11 06:05:00 | SPY | ETF | 427.44 | 427.58 | 427.4 | 427.4 | 3097.0 |
| 2022-03-11 06:10:00 | SPY | ETF | 427.44 | 427.44 | 427.11 | 427.15 | 4600.0 |
| 2022-03-11 06:15:00 | SPY | ETF | 427.04 | 427.04 | 427.04 | 427.04 | 100.0 |
| 2022-03-11 06:20:00 | SPY | ETF | 427.23 | 430.38 | 426.88 | 430.12 | 38031.0 |
| 2022-03-11 06:25:00 | SPY | ETF | 429.86 | 433.22 | 429.79 | 431.67 | 188502.0 |
| 2022-03-11 06:30:00 | SPY | ETF | 431.64 | 432.04 | 430.62 | 431.84 | 60875.0 |
| 2022-03-11 06:35:00 | SPY | ETF | 431.95 | 431.95 | 430.75 | 431.12 | 44744.0 |
| 2022-03-11 06:40:00 | SPY | ETF | 431.2 | 432.19 | 431.08 | 431.66 | 84346.0 |
| 2022-03-11 06:45:00 | SPY | ETF | 431.73 | 432.09 | 431.01 | 431.48 | 40955.0 |
| 2022-03-11 06:50:00 | SPY | ETF | 431.33 | 431.48 | 430.16 | 430.68 | 39912.0 |
| 2022-03-11 06:55:00 | SPY | ETF | 430.62 | 431.5 | 430.58 | 431.5 | 19131.0 |
| 2022-03-11 07:00:00 | SPY | ETF | 431.4 | 431.4 | 430.66 | 431.2 | 86303.0 |
| 2022-03-11 07:05:00 | SPY | ETF | 431.09 | 431.34 | 430.81 | 431.29 | 29603.0 |
| 2022-03-11 07:10:00 | SPY | ETF | 431.09 | 431.57 | 431.0 | 431.36 | 25729.0 |
| 2022-03-11 07:15:00 | SPY | ETF | 431.27 | 431.42 | 431.1 | 431.12 | 26655.0 |
| 2022-03-11 07:20:00 | SPY | ETF | 431.1 | 431.43 | 431.1 | 431.21 | 26409.0 |
| 2022-03-11 07:25:00 | SPY | ETF | 431.16 | 431.16 | 430.52 | 430.8 | 65120.0 |
| 2022-03-11 07:30:00 | SPY | ETF | 430.82 | 431.27 | 430.8 | 431.25 | 60813.0 |
| 2022-03-11 07:35:00 | SPY | ETF | 431.38 | 431.45 | 431.05 | 431.45 | 10728.0 |
| 2022-03-11 07:40:00 | SPY | ETF | 431.46 | 431.5 | 431.0 | 431.2 | 22116.0 |
| 2022-03-11 07:45:00 | SPY | ETF | 431.15 | 431.15 | 430.54 | 430.74 | 29876.0 |
| 2022-03-11 07:50:00 | SPY | ETF | 430.68 | 430.75 | 430.19 | 430.19 | 47730.0 |
| 2022-03-11 07:55:00 | SPY | ETF | 430.18 | 430.25 | 429.69 | 430.0 | 44428.0 |
| 2022-03-11 08:00:00 | SPY | ETF | 431.05 | 431.9104 | 424.88 | 429.92 | 155975.0 |
| 2022-03-11 08:05:00 | SPY | ETF | 429.94 | 430.21 | 429.8 | 430.16 | 60809.0 |
> showing 50 of 94,793 rows — these rows as CSV