PREVIEW / etf_1min / 2022-01-25
file: by_date/etf_1min/2022/2022-01-25.parquet size: 5.2 MB rows: 293,534
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-25 04:00:00 | SPY | ETF | 434.95 | 435.49 | 433.53 | 433.53 | 15775.0 |
| 2022-01-25 04:01:00 | SPY | ETF | 433.59 | 433.76 | 433.45 | 433.76 | 9755.0 |
| 2022-01-25 04:02:00 | SPY | ETF | 433.76 | 433.83 | 433.46 | 433.66 | 5651.0 |
| 2022-01-25 04:03:00 | SPY | ETF | 433.62 | 433.62 | 433.24 | 433.3 | 6253.0 |
| 2022-01-25 04:04:00 | SPY | ETF | 433.22 | 433.69 | 433.22 | 433.59 | 5028.0 |
| 2022-01-25 04:05:00 | SPY | ETF | 433.54 | 433.54 | 433.54 | 433.54 | 100.0 |
| 2022-01-25 04:06:00 | SPY | ETF | 433.64 | 433.67 | 433.48 | 433.6 | 5400.0 |
| 2022-01-25 04:07:00 | SPY | ETF | 433.81 | 433.82 | 433.79 | 433.79 | 1341.0 |
| 2022-01-25 04:08:00 | SPY | ETF | 433.63 | 433.86 | 433.63 | 433.86 | 968.0 |
| 2022-01-25 04:10:00 | SPY | ETF | 434.14 | 434.14 | 434.07 | 434.07 | 350.0 |
| 2022-01-25 04:11:00 | SPY | ETF | 433.85 | 433.85 | 433.71 | 433.84 | 5247.0 |
| 2022-01-25 04:12:00 | SPY | ETF | 433.59 | 434.12 | 433.58 | 434.0 | 5315.0 |
| 2022-01-25 04:14:00 | SPY | ETF | 433.79 | 433.79 | 433.79 | 433.79 | 133.0 |
| 2022-01-25 04:16:00 | SPY | ETF | 434.15 | 434.34 | 434.15 | 434.34 | 1002.0 |
| 2022-01-25 04:17:00 | SPY | ETF | 434.44 | 434.44 | 434.34 | 434.35 | 1600.0 |
| 2022-01-25 04:18:00 | SPY | ETF | 434.12 | 434.16 | 434.12 | 434.16 | 700.0 |
| 2022-01-25 04:20:00 | SPY | ETF | 434.1 | 434.31 | 434.08 | 434.31 | 2738.0 |
| 2022-01-25 04:21:00 | SPY | ETF | 434.74 | 434.93 | 434.73 | 434.83 | 2921.0 |
| 2022-01-25 04:22:00 | SPY | ETF | 435.0 | 435.0 | 434.99 | 434.99 | 2499.0 |
| 2022-01-25 04:23:00 | SPY | ETF | 434.83 | 435.08 | 434.81 | 435.08 | 1098.0 |
| 2022-01-25 04:24:00 | SPY | ETF | 435.24 | 435.25 | 435.24 | 435.24 | 750.0 |
| 2022-01-25 04:25:00 | SPY | ETF | 435.37 | 435.5 | 435.22 | 435.22 | 3207.0 |
| 2022-01-25 04:26:00 | SPY | ETF | 435.65 | 435.83 | 435.65 | 435.83 | 3000.0 |
| 2022-01-25 04:27:00 | SPY | ETF | 435.61 | 435.92 | 435.6 | 435.91 | 4699.0 |
| 2022-01-25 04:28:00 | SPY | ETF | 435.65 | 435.94 | 435.65 | 435.94 | 1291.0 |
| 2022-01-25 04:29:00 | SPY | ETF | 436.1 | 436.1 | 436.1 | 436.1 | 300.0 |
| 2022-01-25 04:30:00 | SPY | ETF | 435.94 | 435.94 | 435.9 | 435.94 | 918.0 |
| 2022-01-25 04:31:00 | SPY | ETF | 436.12 | 436.24 | 436.12 | 436.24 | 200.0 |
| 2022-01-25 04:35:00 | SPY | ETF | 435.72 | 435.72 | 435.64 | 435.67 | 2939.0 |
| 2022-01-25 04:36:00 | SPY | ETF | 435.8 | 435.93 | 435.8 | 435.93 | 534.0 |
| 2022-01-25 04:37:00 | SPY | ETF | 435.93 | 436.04 | 435.93 | 436.04 | 500.0 |
| 2022-01-25 04:39:00 | SPY | ETF | 436.0 | 436.0 | 436.0 | 436.0 | 300.0 |
| 2022-01-25 04:40:00 | SPY | ETF | 435.96 | 435.96 | 435.6 | 435.62 | 12755.0 |
| 2022-01-25 04:42:00 | SPY | ETF | 436.12 | 436.14 | 436.11 | 436.12 | 1200.0 |
| 2022-01-25 04:44:00 | SPY | ETF | 436.22 | 436.25 | 436.2 | 436.25 | 1020.0 |
| 2022-01-25 04:45:00 | SPY | ETF | 436.32 | 436.91 | 436.32 | 436.83 | 4211.0 |
| 2022-01-25 04:46:00 | SPY | ETF | 436.6 | 436.6 | 436.56 | 436.56 | 300.0 |
| 2022-01-25 04:47:00 | SPY | ETF | 436.44 | 436.5 | 436.44 | 436.5 | 1000.0 |
| 2022-01-25 04:48:00 | SPY | ETF | 436.81 | 436.9 | 436.81 | 436.9 | 4651.0 |
| 2022-01-25 04:49:00 | SPY | ETF | 436.9 | 436.9 | 436.69 | 436.69 | 6476.0 |
| 2022-01-25 04:50:00 | SPY | ETF | 436.69 | 436.75 | 436.69 | 436.75 | 2470.0 |
| 2022-01-25 04:51:00 | SPY | ETF | 436.83 | 437.0 | 436.82 | 437.0 | 10795.0 |
| 2022-01-25 04:52:00 | SPY | ETF | 436.86 | 436.86 | 436.83 | 436.84 | 1900.0 |
| 2022-01-25 04:53:00 | SPY | ETF | 436.99 | 437.1 | 436.99 | 437.1 | 1835.0 |
| 2022-01-25 04:54:00 | SPY | ETF | 437.16 | 437.2 | 437.16 | 437.2 | 2440.0 |
| 2022-01-25 04:55:00 | SPY | ETF | 437.16 | 437.32 | 437.16 | 437.32 | 600.0 |
| 2022-01-25 04:56:00 | SPY | ETF | 437.38 | 437.4 | 437.21 | 437.21 | 1605.0 |
| 2022-01-25 04:57:00 | SPY | ETF | 437.4 | 437.4 | 437.4 | 437.4 | 150.0 |
| 2022-01-25 04:58:00 | SPY | ETF | 437.21 | 437.21 | 437.21 | 437.21 | 1096.0 |
| 2022-01-25 04:59:00 | SPY | ETF | 436.72 | 436.89 | 436.63 | 436.89 | 5400.0 |
> showing 50 of 293,534 rows — these rows as CSV