PREVIEW / etf_5min / 2022-03-01
file: by_date/etf_5min/2022/2022-03-01.parquet size: 2.1 MB rows: 100,769
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-01 04:00:00 | SPY | ETF | 436.74 | 437.03 | 436.57 | 436.78 | 6105.0 |
| 2022-03-01 04:05:00 | SPY | ETF | 436.9 | 436.9 | 435.64 | 435.76 | 4475.0 |
| 2022-03-01 04:10:00 | SPY | ETF | 435.66 | 435.93 | 435.5 | 435.59 | 9390.0 |
| 2022-03-01 04:15:00 | SPY | ETF | 435.63 | 435.91 | 435.54 | 435.58 | 13375.0 |
| 2022-03-01 04:20:00 | SPY | ETF | 435.59 | 435.7 | 435.1 | 435.11 | 15940.0 |
| 2022-03-01 04:25:00 | SPY | ETF | 435.13 | 435.13 | 434.75 | 434.87 | 13072.0 |
| 2022-03-01 04:30:00 | SPY | ETF | 434.71 | 435.16 | 434.7 | 435.07 | 35526.0 |
| 2022-03-01 04:35:00 | SPY | ETF | 435.1 | 435.1 | 434.69 | 434.77 | 9251.0 |
| 2022-03-01 04:40:00 | SPY | ETF | 435.09 | 435.09 | 434.2 | 434.3 | 18083.0 |
| 2022-03-01 04:45:00 | SPY | ETF | 434.27 | 434.6 | 434.27 | 434.53 | 1400.0 |
| 2022-03-01 04:50:00 | SPY | ETF | 434.63 | 434.63 | 433.81 | 433.96 | 12717.0 |
| 2022-03-01 04:55:00 | SPY | ETF | 434.01 | 434.08 | 434.0 | 434.03 | 687.0 |
| 2022-03-01 05:00:00 | SPY | ETF | 434.14 | 434.14 | 433.53 | 433.53 | 2378.0 |
| 2022-03-01 05:05:00 | SPY | ETF | 433.71 | 433.71 | 433.33 | 433.35 | 6422.0 |
| 2022-03-01 05:10:00 | SPY | ETF | 433.36 | 433.6 | 433.26 | 433.56 | 24029.0 |
| 2022-03-01 05:15:00 | SPY | ETF | 433.58 | 433.99 | 433.5 | 433.97 | 4670.0 |
| 2022-03-01 05:20:00 | SPY | ETF | 433.89 | 433.9 | 433.65 | 433.66 | 7410.0 |
| 2022-03-01 05:25:00 | SPY | ETF | 433.67 | 433.69 | 433.44 | 433.49 | 5425.0 |
| 2022-03-01 05:30:00 | SPY | ETF | 433.4 | 433.4 | 432.71 | 433.2 | 7275.0 |
| 2022-03-01 05:35:00 | SPY | ETF | 433.06 | 433.15 | 432.66 | 433.0 | 8420.0 |
| 2022-03-01 05:40:00 | SPY | ETF | 432.85 | 433.94 | 432.85 | 433.79 | 33437.0 |
| 2022-03-01 05:45:00 | SPY | ETF | 433.55 | 434.16 | 433.49 | 434.16 | 3540.0 |
| 2022-03-01 05:50:00 | SPY | ETF | 434.05 | 434.46 | 434.0 | 434.34 | 10268.0 |
| 2022-03-01 05:55:00 | SPY | ETF | 434.26 | 434.43 | 434.0 | 434.43 | 18766.0 |
| 2022-03-01 06:00:00 | SPY | ETF | 434.1 | 434.21 | 433.93 | 433.99 | 10250.0 |
| 2022-03-01 06:05:00 | SPY | ETF | 433.98 | 434.06 | 433.94 | 433.96 | 2723.0 |
| 2022-03-01 06:10:00 | SPY | ETF | 433.91 | 433.91 | 433.3 | 433.68 | 7584.0 |
| 2022-03-01 06:15:00 | SPY | ETF | 433.76 | 433.88 | 433.66 | 433.88 | 1865.0 |
| 2022-03-01 06:20:00 | SPY | ETF | 433.91 | 434.33 | 433.91 | 434.33 | 1669.0 |
| 2022-03-01 06:25:00 | SPY | ETF | 434.04 | 434.45 | 433.98 | 434.01 | 13890.0 |
| 2022-03-01 06:30:00 | SPY | ETF | 434.03 | 434.6 | 434.03 | 434.31 | 9446.0 |
| 2022-03-01 06:35:00 | SPY | ETF | 434.33 | 434.4 | 434.08 | 434.08 | 11830.0 |
| 2022-03-01 06:40:00 | SPY | ETF | 434.1 | 434.19 | 433.47 | 433.47 | 11518.0 |
| 2022-03-01 06:45:00 | SPY | ETF | 433.61 | 433.62 | 433.0 | 433.01 | 22180.0 |
| 2022-03-01 06:50:00 | SPY | ETF | 433.14 | 433.14 | 432.21 | 432.39 | 19934.0 |
| 2022-03-01 06:55:00 | SPY | ETF | 432.4 | 432.76 | 432.07 | 432.73 | 15000.0 |
| 2022-03-01 07:00:00 | SPY | ETF | 432.79 | 433.3 | 432.68 | 433.29 | 61298.0 |
| 2022-03-01 07:05:00 | SPY | ETF | 433.394 | 433.63 | 433.379 | 433.54 | 37867.0 |
| 2022-03-01 07:10:00 | SPY | ETF | 433.56 | 433.56 | 433.25 | 433.32 | 34304.0 |
| 2022-03-01 07:15:00 | SPY | ETF | 433.29 | 433.29 | 432.78 | 432.78 | 54969.0 |
| 2022-03-01 07:20:00 | SPY | ETF | 432.85 | 433.6 | 432.77 | 433.54 | 31342.0 |
| 2022-03-01 07:25:00 | SPY | ETF | 433.54 | 434.35 | 433.15 | 434.3 | 61880.0 |
| 2022-03-01 07:30:00 | SPY | ETF | 434.28 | 434.28 | 433.76 | 433.89 | 45574.0 |
| 2022-03-01 07:35:00 | SPY | ETF | 434.0 | 434.0 | 433.37 | 433.4 | 22992.0 |
| 2022-03-01 07:40:00 | SPY | ETF | 433.399 | 433.399 | 432.8 | 433.12 | 41691.0 |
| 2022-03-01 07:45:00 | SPY | ETF | 433.09 | 433.4 | 432.86 | 433.39 | 20455.0 |
| 2022-03-01 07:50:00 | SPY | ETF | 433.36 | 433.46 | 432.96 | 432.98 | 34091.0 |
| 2022-03-01 07:55:00 | SPY | ETF | 433.0 | 433.47 | 432.78 | 433.33 | 39459.0 |
| 2022-03-01 08:00:00 | SPY | ETF | 432.8 | 439.56 | 432.5699 | 432.99 | 61814.0 |
| 2022-03-01 08:05:00 | SPY | ETF | 433.02 | 433.25 | 432.72 | 433.15 | 40120.0 |
> showing 50 of 100,769 rows — these rows as CSV