PREVIEW / etf_1min / 2023-06-30
file: by_date/etf_1min/2023/2023-06-30.parquet size: 4.6 MB rows: 258,088
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-30 04:00:00 | SPY | ETF | 438.65 | 438.77 | 438.35 | 438.71 | 24941.0 |
| 2023-06-30 04:01:00 | SPY | ETF | 438.79 | 438.79 | 438.79 | 438.79 | 1000.0 |
| 2023-06-30 04:02:00 | SPY | ETF | 438.87 | 438.87 | 438.86 | 438.86 | 1900.0 |
| 2023-06-30 04:03:00 | SPY | ETF | 438.9 | 438.92 | 438.9 | 438.92 | 244.0 |
| 2023-06-30 04:04:00 | SPY | ETF | 438.92 | 438.97 | 438.89 | 438.94 | 1157.0 |
| 2023-06-30 04:05:00 | SPY | ETF | 438.93 | 438.97 | 438.93 | 438.94 | 2050.0 |
| 2023-06-30 04:06:00 | SPY | ETF | 438.92 | 438.92 | 438.92 | 438.92 | 1925.0 |
| 2023-06-30 04:07:00 | SPY | ETF | 438.88 | 438.88 | 438.83 | 438.83 | 1100.0 |
| 2023-06-30 04:08:00 | SPY | ETF | 438.92 | 438.94 | 438.92 | 438.93 | 407.0 |
| 2023-06-30 04:09:00 | SPY | ETF | 438.94 | 438.94 | 438.88 | 438.88 | 860.0 |
| 2023-06-30 04:10:00 | SPY | ETF | 438.9 | 438.9 | 438.89 | 438.89 | 250.0 |
| 2023-06-30 04:11:00 | SPY | ETF | 438.95 | 438.95 | 438.94 | 438.94 | 1201.0 |
| 2023-06-30 04:12:00 | SPY | ETF | 438.9 | 438.9 | 438.9 | 438.9 | 120.0 |
| 2023-06-30 04:13:00 | SPY | ETF | 438.93 | 438.93 | 438.93 | 438.93 | 119.0 |
| 2023-06-30 04:14:00 | SPY | ETF | 438.82 | 438.82 | 438.82 | 438.82 | 300.0 |
| 2023-06-30 04:15:00 | SPY | ETF | 438.81 | 438.81 | 438.78 | 438.81 | 799.0 |
| 2023-06-30 04:16:00 | SPY | ETF | 438.75 | 438.75 | 438.75 | 438.75 | 277.0 |
| 2023-06-30 04:18:00 | SPY | ETF | 438.73 | 438.73 | 438.72 | 438.73 | 600.0 |
| 2023-06-30 04:20:00 | SPY | ETF | 438.79 | 438.79 | 438.79 | 438.79 | 300.0 |
| 2023-06-30 04:22:00 | SPY | ETF | 438.8 | 438.86 | 438.8 | 438.86 | 1301.0 |
| 2023-06-30 04:25:00 | SPY | ETF | 438.85 | 438.85 | 438.85 | 438.85 | 400.0 |
| 2023-06-30 04:26:00 | SPY | ETF | 438.87 | 438.87 | 438.87 | 438.87 | 600.0 |
| 2023-06-30 04:29:00 | SPY | ETF | 438.8 | 438.8 | 438.77 | 438.77 | 560.0 |
| 2023-06-30 04:30:00 | SPY | ETF | 438.85 | 438.85 | 438.85 | 438.85 | 1118.0 |
| 2023-06-30 04:31:00 | SPY | ETF | 438.78 | 438.82 | 438.78 | 438.82 | 202.0 |
| 2023-06-30 04:32:00 | SPY | ETF | 438.87 | 438.87 | 438.87 | 438.87 | 100.0 |
| 2023-06-30 04:33:00 | SPY | ETF | 438.84 | 438.84 | 438.84 | 438.84 | 300.0 |
| 2023-06-30 04:34:00 | SPY | ETF | 438.85 | 438.85 | 438.85 | 438.85 | 200.0 |
| 2023-06-30 04:35:00 | SPY | ETF | 438.89 | 438.92 | 438.89 | 438.92 | 800.0 |
| 2023-06-30 04:36:00 | SPY | ETF | 438.95 | 438.95 | 438.91 | 438.91 | 216.0 |
| 2023-06-30 04:39:00 | SPY | ETF | 439.0 | 439.0 | 439.0 | 439.0 | 400.0 |
| 2023-06-30 04:41:00 | SPY | ETF | 439.01 | 439.01 | 439.01 | 439.01 | 123.0 |
| 2023-06-30 04:44:00 | SPY | ETF | 439.13 | 439.13 | 439.13 | 439.13 | 304.0 |
| 2023-06-30 04:46:00 | SPY | ETF | 439.04 | 439.04 | 439.04 | 439.04 | 100.0 |
| 2023-06-30 04:48:00 | SPY | ETF | 439.11 | 439.11 | 439.11 | 439.11 | 100.0 |
| 2023-06-30 04:51:00 | SPY | ETF | 439.17 | 439.17 | 439.17 | 439.17 | 400.0 |
| 2023-06-30 04:53:00 | SPY | ETF | 439.15 | 439.18 | 439.15 | 439.18 | 500.0 |
| 2023-06-30 04:54:00 | SPY | ETF | 439.23 | 439.28 | 439.23 | 439.28 | 917.0 |
| 2023-06-30 04:55:00 | SPY | ETF | 439.23 | 439.23 | 439.23 | 439.23 | 100.0 |
| 2023-06-30 04:59:00 | SPY | ETF | 439.28 | 439.28 | 439.28 | 439.28 | 1000.0 |
| 2023-06-30 05:00:00 | SPY | ETF | 439.35 | 439.35 | 439.27 | 439.27 | 402.0 |
| 2023-06-30 05:01:00 | SPY | ETF | 439.23 | 439.28 | 439.23 | 439.28 | 1000.0 |
| 2023-06-30 05:02:00 | SPY | ETF | 439.35 | 439.37 | 439.35 | 439.37 | 700.0 |
| 2023-06-30 05:03:00 | SPY | ETF | 439.34 | 439.34 | 439.34 | 439.34 | 125.0 |
| 2023-06-30 05:04:00 | SPY | ETF | 439.4 | 439.5 | 439.4 | 439.5 | 760.0 |
| 2023-06-30 05:05:00 | SPY | ETF | 439.39 | 439.39 | 439.39 | 439.39 | 1200.0 |
| 2023-06-30 05:06:00 | SPY | ETF | 439.36 | 439.37 | 439.36 | 439.37 | 1000.0 |
| 2023-06-30 05:09:00 | SPY | ETF | 439.45 | 439.45 | 439.45 | 439.45 | 300.0 |
| 2023-06-30 05:10:00 | SPY | ETF | 439.43 | 439.43 | 439.43 | 439.43 | 150.0 |
| 2023-06-30 05:12:00 | SPY | ETF | 439.42 | 439.42 | 439.42 | 439.42 | 4900.0 |
> showing 50 of 258,088 rows — these rows as CSV