PREVIEW / etf_1min / 2023-03-24
file: by_date/etf_1min/2023/2023-03-24.parquet size: 4.7 MB rows: 268,884
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-03-24 04:00:00 | SPY | ETF | 394.84 | 394.84 | 394.84 | 394.84 | 200.0 |
| 2023-03-24 04:01:00 | SPY | ETF | 394.58 | 394.58 | 394.57 | 394.57 | 1900.0 |
| 2023-03-24 04:03:00 | SPY | ETF | 394.47 | 394.47 | 394.47 | 394.47 | 212.0 |
| 2023-03-24 04:04:00 | SPY | ETF | 394.48 | 394.48 | 394.17 | 394.17 | 1165.0 |
| 2023-03-24 04:05:00 | SPY | ETF | 394.12 | 394.14 | 393.79 | 393.86 | 9102.0 |
| 2023-03-24 04:06:00 | SPY | ETF | 393.63 | 393.63 | 393.49 | 393.49 | 949.0 |
| 2023-03-24 04:07:00 | SPY | ETF | 393.57 | 393.59 | 393.24 | 393.25 | 9807.0 |
| 2023-03-24 04:08:00 | SPY | ETF | 393.23 | 393.27 | 393.21 | 393.23 | 10632.0 |
| 2023-03-24 04:09:00 | SPY | ETF | 393.17 | 393.17 | 392.85 | 392.85 | 5372.0 |
| 2023-03-24 04:10:00 | SPY | ETF | 393.2 | 393.22 | 393.16 | 393.22 | 2506.0 |
| 2023-03-24 04:11:00 | SPY | ETF | 393.28 | 393.34 | 393.28 | 393.33 | 3080.0 |
| 2023-03-24 04:12:00 | SPY | ETF | 393.3 | 393.3 | 393.3 | 393.3 | 1171.0 |
| 2023-03-24 04:13:00 | SPY | ETF | 393.46 | 393.46 | 393.46 | 393.46 | 600.0 |
| 2023-03-24 04:14:00 | SPY | ETF | 393.4 | 393.48 | 393.35 | 393.48 | 844.0 |
| 2023-03-24 04:15:00 | SPY | ETF | 393.49 | 393.62 | 393.45 | 393.58 | 2114.0 |
| 2023-03-24 04:16:00 | SPY | ETF | 393.49 | 393.49 | 393.4 | 393.46 | 978.0 |
| 2023-03-24 04:17:00 | SPY | ETF | 393.49 | 393.52 | 393.49 | 393.52 | 689.0 |
| 2023-03-24 04:18:00 | SPY | ETF | 393.47 | 393.47 | 393.38 | 393.45 | 1900.0 |
| 2023-03-24 04:19:00 | SPY | ETF | 393.37 | 393.37 | 393.16 | 393.16 | 2454.0 |
| 2023-03-24 04:20:00 | SPY | ETF | 393.13 | 393.21 | 393.05 | 393.05 | 1300.0 |
| 2023-03-24 04:21:00 | SPY | ETF | 393.01 | 393.01 | 392.91 | 392.91 | 720.0 |
| 2023-03-24 04:22:00 | SPY | ETF | 393.31 | 393.49 | 393.3 | 393.45 | 1213.0 |
| 2023-03-24 04:23:00 | SPY | ETF | 393.49 | 393.71 | 393.49 | 393.71 | 2600.0 |
| 2023-03-24 04:24:00 | SPY | ETF | 393.64 | 393.66 | 393.6 | 393.64 | 3475.0 |
| 2023-03-24 04:25:00 | SPY | ETF | 393.6 | 393.61 | 393.57 | 393.59 | 2854.0 |
| 2023-03-24 04:26:00 | SPY | ETF | 393.75 | 393.9 | 393.75 | 393.87 | 6423.0 |
| 2023-03-24 04:27:00 | SPY | ETF | 393.85 | 393.99 | 393.78 | 393.99 | 4700.0 |
| 2023-03-24 04:28:00 | SPY | ETF | 393.88 | 393.94 | 393.88 | 393.94 | 400.0 |
| 2023-03-24 04:29:00 | SPY | ETF | 393.9 | 393.9 | 393.83 | 393.83 | 500.0 |
| 2023-03-24 04:30:00 | SPY | ETF | 393.74 | 393.74 | 393.7 | 393.73 | 600.0 |
| 2023-03-24 04:31:00 | SPY | ETF | 393.73 | 393.73 | 393.73 | 393.73 | 200.0 |
| 2023-03-24 04:32:00 | SPY | ETF | 393.81 | 393.81 | 393.81 | 393.81 | 400.0 |
| 2023-03-24 04:33:00 | SPY | ETF | 393.77 | 393.77 | 393.71 | 393.71 | 700.0 |
| 2023-03-24 04:34:00 | SPY | ETF | 393.66 | 393.66 | 393.57 | 393.57 | 1200.0 |
| 2023-03-24 04:35:00 | SPY | ETF | 393.5 | 393.5 | 393.3 | 393.41 | 2500.0 |
| 2023-03-24 04:36:00 | SPY | ETF | 393.09 | 393.15 | 393.09 | 393.15 | 300.0 |
| 2023-03-24 04:37:00 | SPY | ETF | 393.23 | 393.23 | 393.21 | 393.21 | 700.0 |
| 2023-03-24 04:38:00 | SPY | ETF | 393.3 | 393.3 | 393.23 | 393.23 | 1300.0 |
| 2023-03-24 04:39:00 | SPY | ETF | 393.23 | 393.23 | 393.0 | 393.0 | 4300.0 |
| 2023-03-24 04:40:00 | SPY | ETF | 393.07 | 393.07 | 393.01 | 393.01 | 1100.0 |
| 2023-03-24 04:41:00 | SPY | ETF | 392.84 | 392.84 | 392.84 | 392.84 | 440.0 |
| 2023-03-24 04:42:00 | SPY | ETF | 392.65 | 392.65 | 392.39 | 392.4 | 4121.0 |
| 2023-03-24 04:43:00 | SPY | ETF | 392.46 | 392.49 | 392.35 | 392.35 | 5000.0 |
| 2023-03-24 04:44:00 | SPY | ETF | 392.43 | 392.5 | 392.43 | 392.5 | 1000.0 |
| 2023-03-24 04:45:00 | SPY | ETF | 392.33 | 392.33 | 392.11 | 392.11 | 5509.0 |
| 2023-03-24 04:46:00 | SPY | ETF | 392.05 | 392.21 | 392.04 | 392.17 | 1224.0 |
| 2023-03-24 04:47:00 | SPY | ETF | 392.12 | 392.12 | 391.87 | 391.87 | 4700.0 |
| 2023-03-24 04:48:00 | SPY | ETF | 391.94 | 392.04 | 391.94 | 392.0 | 1500.0 |
| 2023-03-24 04:49:00 | SPY | ETF | 392.01 | 392.07 | 391.88 | 391.88 | 1900.0 |
| 2023-03-24 04:50:00 | SPY | ETF | 391.86 | 391.95 | 391.86 | 391.93 | 1284.0 |
> showing 50 of 268,884 rows — these rows as CSV