PREVIEW / etf_1min / 2024-09-27
file: by_date/etf_1min/2024/2024-09-27.parquet size: 5.4 MB rows: 304,728
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-27 04:00:00 | SPY | ETF | 571.44 | 571.59 | 571.4 | 571.45 | 655.0 |
| 2024-09-27 04:01:00 | SPY | ETF | 571.57 | 571.57 | 571.56 | 571.56 | 200.0 |
| 2024-09-27 04:03:00 | SPY | ETF | 571.67 | 571.67 | 571.55 | 571.6 | 663.0 |
| 2024-09-27 04:04:00 | SPY | ETF | 571.61 | 571.72 | 571.61 | 571.72 | 370.0 |
| 2024-09-27 04:05:00 | SPY | ETF | 571.57 | 571.57 | 571.57 | 571.57 | 200.0 |
| 2024-09-27 04:06:00 | SPY | ETF | 571.57 | 571.57 | 571.53 | 571.53 | 300.0 |
| 2024-09-27 04:07:00 | SPY | ETF | 571.55 | 571.59 | 571.54 | 571.59 | 300.0 |
| 2024-09-27 04:08:00 | SPY | ETF | 571.56 | 571.56 | 571.56 | 571.56 | 100.0 |
| 2024-09-27 04:09:00 | SPY | ETF | 571.73 | 571.77 | 571.73 | 571.77 | 2184.0 |
| 2024-09-27 04:10:00 | SPY | ETF | 571.66 | 571.66 | 571.64 | 571.64 | 600.0 |
| 2024-09-27 04:12:00 | SPY | ETF | 571.7 | 571.7 | 571.69 | 571.69 | 701.0 |
| 2024-09-27 04:13:00 | SPY | ETF | 571.74 | 571.84 | 571.74 | 571.84 | 375.0 |
| 2024-09-27 04:14:00 | SPY | ETF | 571.81 | 571.81 | 571.71 | 571.71 | 324.0 |
| 2024-09-27 04:15:00 | SPY | ETF | 571.85 | 571.85 | 571.85 | 571.85 | 100.0 |
| 2024-09-27 04:16:00 | SPY | ETF | 571.69 | 571.69 | 571.69 | 571.69 | 100.0 |
| 2024-09-27 04:23:00 | SPY | ETF | 572.27 | 572.36 | 572.27 | 572.36 | 894.0 |
| 2024-09-27 04:24:00 | SPY | ETF | 572.34 | 572.34 | 572.29 | 572.29 | 200.0 |
| 2024-09-27 04:26:00 | SPY | ETF | 572.29 | 572.37 | 572.29 | 572.37 | 620.0 |
| 2024-09-27 04:27:00 | SPY | ETF | 572.24 | 572.24 | 572.24 | 572.24 | 151.0 |
| 2024-09-27 04:29:00 | SPY | ETF | 572.22 | 572.22 | 572.22 | 572.22 | 100.0 |
| 2024-09-27 04:31:00 | SPY | ETF | 572.33 | 572.33 | 572.33 | 572.33 | 200.0 |
| 2024-09-27 04:34:00 | SPY | ETF | 572.48 | 572.52 | 572.47 | 572.52 | 1293.0 |
| 2024-09-27 04:35:00 | SPY | ETF | 572.44 | 572.44 | 572.44 | 572.44 | 139.0 |
| 2024-09-27 04:37:00 | SPY | ETF | 572.35 | 572.35 | 572.35 | 572.35 | 101.0 |
| 2024-09-27 04:39:00 | SPY | ETF | 572.32 | 572.39 | 572.32 | 572.39 | 785.0 |
| 2024-09-27 04:41:00 | SPY | ETF | 572.36 | 572.36 | 572.28 | 572.28 | 250.0 |
| 2024-09-27 04:42:00 | SPY | ETF | 572.08 | 572.08 | 572.08 | 572.08 | 600.0 |
| 2024-09-27 04:45:00 | SPY | ETF | 572.02 | 572.02 | 572.02 | 572.02 | 100.0 |
| 2024-09-27 04:52:00 | SPY | ETF | 572.03 | 572.03 | 572.03 | 572.03 | 201.0 |
| 2024-09-27 04:54:00 | SPY | ETF | 572.17 | 572.17 | 572.17 | 572.17 | 152.0 |
| 2024-09-27 04:55:00 | SPY | ETF | 572.0 | 572.0 | 572.0 | 572.0 | 105.0 |
| 2024-09-27 05:07:00 | SPY | ETF | 572.07 | 572.07 | 572.07 | 572.07 | 100.0 |
| 2024-09-27 05:08:00 | SPY | ETF | 572.15 | 572.15 | 572.15 | 572.15 | 100.0 |
| 2024-09-27 05:12:00 | SPY | ETF | 572.38 | 572.38 | 572.32 | 572.32 | 487.0 |
| 2024-09-27 05:13:00 | SPY | ETF | 572.27 | 572.27 | 572.27 | 572.27 | 200.0 |
| 2024-09-27 05:14:00 | SPY | ETF | 572.26 | 572.26 | 572.26 | 572.26 | 187.0 |
| 2024-09-27 05:15:00 | SPY | ETF | 572.31 | 572.31 | 572.31 | 572.31 | 187.0 |
| 2024-09-27 05:16:00 | SPY | ETF | 572.3 | 572.5 | 572.3 | 572.5 | 887.0 |
| 2024-09-27 05:20:00 | SPY | ETF | 572.54 | 572.54 | 572.54 | 572.54 | 100.0 |
| 2024-09-27 05:21:00 | SPY | ETF | 572.53 | 572.53 | 572.53 | 572.53 | 600.0 |
| 2024-09-27 05:22:00 | SPY | ETF | 572.43 | 572.43 | 572.43 | 572.43 | 200.0 |
| 2024-09-27 05:23:00 | SPY | ETF | 572.31 | 572.31 | 572.31 | 572.31 | 100.0 |
| 2024-09-27 05:26:00 | SPY | ETF | 572.18 | 572.19 | 572.18 | 572.19 | 4000.0 |
| 2024-09-27 05:31:00 | SPY | ETF | 572.0 | 572.0 | 571.85 | 571.85 | 1107.0 |
| 2024-09-27 05:35:00 | SPY | ETF | 572.07 | 572.07 | 572.07 | 572.07 | 140.0 |
| 2024-09-27 05:42:00 | SPY | ETF | 572.08 | 572.08 | 572.08 | 572.08 | 200.0 |
| 2024-09-27 05:43:00 | SPY | ETF | 572.3 | 572.3 | 572.3 | 572.3 | 100.0 |
| 2024-09-27 05:48:00 | SPY | ETF | 572.42 | 572.42 | 572.42 | 572.42 | 249.0 |
| 2024-09-27 05:49:00 | SPY | ETF | 572.28 | 572.28 | 572.28 | 572.28 | 100.0 |
| 2024-09-27 05:58:00 | SPY | ETF | 572.4 | 572.4 | 572.4 | 572.4 | 200.0 |
> showing 50 of 304,728 rows — these rows as CSV