PREVIEW / etf_1min / 2022-01-24
file: by_date/etf_1min/2022/2022-01-24.parquet size: 6.1 MB rows: 343,554
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-01-24 04:00:00 | SPY | ETF | 439.02 | 440.12 | 439.02 | 440.12 | 8033.0 |
| 2022-01-24 04:01:00 | SPY | ETF | 440.09 | 440.11 | 439.95 | 439.95 | 1400.0 |
| 2022-01-24 04:02:00 | SPY | ETF | 439.85 | 439.98 | 439.8 | 439.98 | 5551.0 |
| 2022-01-24 04:03:00 | SPY | ETF | 439.84 | 439.88 | 439.75 | 439.75 | 594.0 |
| 2022-01-24 04:04:00 | SPY | ETF | 439.75 | 440.01 | 439.72 | 440.01 | 8310.0 |
| 2022-01-24 04:05:00 | SPY | ETF | 440.09 | 440.09 | 439.89 | 439.89 | 346.0 |
| 2022-01-24 04:06:00 | SPY | ETF | 439.85 | 439.93 | 439.79 | 439.79 | 3774.0 |
| 2022-01-24 04:07:00 | SPY | ETF | 439.84 | 439.88 | 439.76 | 439.88 | 12340.0 |
| 2022-01-24 04:08:00 | SPY | ETF | 440.08 | 440.11 | 440.08 | 440.1 | 7510.0 |
| 2022-01-24 04:09:00 | SPY | ETF | 440.23 | 440.23 | 440.16 | 440.2 | 5083.0 |
| 2022-01-24 04:10:00 | SPY | ETF | 440.05 | 440.05 | 439.89 | 439.9 | 5517.0 |
| 2022-01-24 04:11:00 | SPY | ETF | 439.84 | 439.84 | 439.71 | 439.71 | 282.0 |
| 2022-01-24 04:12:00 | SPY | ETF | 439.72 | 439.93 | 439.7 | 439.93 | 2503.0 |
| 2022-01-24 04:13:00 | SPY | ETF | 439.79 | 439.91 | 439.69 | 439.91 | 564.0 |
| 2022-01-24 04:14:00 | SPY | ETF | 439.89 | 440.05 | 439.89 | 439.91 | 1242.0 |
| 2022-01-24 04:15:00 | SPY | ETF | 439.86 | 439.86 | 439.71 | 439.75 | 574.0 |
| 2022-01-24 04:16:00 | SPY | ETF | 439.64 | 439.72 | 439.6 | 439.6 | 849.0 |
| 2022-01-24 04:17:00 | SPY | ETF | 439.45 | 439.52 | 439.45 | 439.47 | 500.0 |
| 2022-01-24 04:18:00 | SPY | ETF | 439.47 | 439.47 | 439.47 | 439.47 | 110.0 |
| 2022-01-24 04:19:00 | SPY | ETF | 439.44 | 439.44 | 439.39 | 439.39 | 1390.0 |
| 2022-01-24 04:20:00 | SPY | ETF | 439.49 | 439.49 | 439.36 | 439.36 | 273.0 |
| 2022-01-24 04:21:00 | SPY | ETF | 439.3 | 439.3 | 439.23 | 439.23 | 10268.0 |
| 2022-01-24 04:22:00 | SPY | ETF | 439.14 | 439.2 | 439.12 | 439.15 | 9650.0 |
| 2022-01-24 04:23:00 | SPY | ETF | 439.07 | 439.1 | 439.04 | 439.1 | 14569.0 |
| 2022-01-24 04:24:00 | SPY | ETF | 439.1 | 439.1 | 439.03 | 439.05 | 5548.0 |
| 2022-01-24 04:25:00 | SPY | ETF | 439.2 | 439.24 | 439.2 | 439.24 | 1260.0 |
| 2022-01-24 04:26:00 | SPY | ETF | 439.2 | 439.4 | 439.2 | 439.4 | 2298.0 |
| 2022-01-24 04:27:00 | SPY | ETF | 439.4 | 439.43 | 439.38 | 439.42 | 2791.0 |
| 2022-01-24 04:28:00 | SPY | ETF | 439.63 | 439.64 | 439.63 | 439.64 | 230.0 |
| 2022-01-24 04:29:00 | SPY | ETF | 439.62 | 439.62 | 439.52 | 439.52 | 544.0 |
| 2022-01-24 04:30:00 | SPY | ETF | 439.47 | 439.74 | 439.44 | 439.74 | 4445.0 |
| 2022-01-24 04:31:00 | SPY | ETF | 439.63 | 439.7 | 439.63 | 439.7 | 204.0 |
| 2022-01-24 04:34:00 | SPY | ETF | 439.52 | 439.52 | 439.52 | 439.52 | 100.0 |
| 2022-01-24 04:35:00 | SPY | ETF | 439.59 | 439.59 | 439.59 | 439.59 | 2480.0 |
| 2022-01-24 04:37:00 | SPY | ETF | 439.69 | 439.69 | 439.69 | 439.69 | 400.0 |
| 2022-01-24 04:38:00 | SPY | ETF | 439.76 | 439.76 | 439.67 | 439.67 | 703.0 |
| 2022-01-24 04:40:00 | SPY | ETF | 439.39 | 439.49 | 439.29 | 439.49 | 1488.0 |
| 2022-01-24 04:41:00 | SPY | ETF | 439.42 | 439.42 | 439.42 | 439.42 | 100.0 |
| 2022-01-24 04:43:00 | SPY | ETF | 439.59 | 439.59 | 439.56 | 439.56 | 1928.0 |
| 2022-01-24 04:44:00 | SPY | ETF | 439.65 | 439.65 | 439.65 | 439.65 | 100.0 |
| 2022-01-24 04:45:00 | SPY | ETF | 439.31 | 439.31 | 439.09 | 439.09 | 265.0 |
| 2022-01-24 04:46:00 | SPY | ETF | 439.15 | 439.15 | 438.98 | 438.98 | 2973.0 |
| 2022-01-24 04:48:00 | SPY | ETF | 439.08 | 439.08 | 439.08 | 439.08 | 1000.0 |
| 2022-01-24 04:50:00 | SPY | ETF | 439.46 | 439.76 | 439.46 | 439.76 | 5499.0 |
| 2022-01-24 04:51:00 | SPY | ETF | 439.69 | 439.74 | 439.69 | 439.72 | 1275.0 |
| 2022-01-24 04:52:00 | SPY | ETF | 439.74 | 439.8 | 439.69 | 439.7 | 2292.0 |
| 2022-01-24 04:53:00 | SPY | ETF | 439.49 | 439.49 | 439.41 | 439.42 | 2050.0 |
| 2022-01-24 04:54:00 | SPY | ETF | 439.36 | 439.5 | 439.36 | 439.45 | 4658.0 |
| 2022-01-24 04:55:00 | SPY | ETF | 439.5 | 439.5 | 439.5 | 439.5 | 799.0 |
| 2022-01-24 04:57:00 | SPY | ETF | 439.41 | 439.58 | 439.41 | 439.58 | 625.0 |
> showing 50 of 343,554 rows — these rows as CSV