PREVIEW / etf_1min / 2024-08-09
file: by_date/etf_1min/2024/2024-08-09.parquet size: 5.0 MB rows: 284,054
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-08-09 04:00:00 | SPY | ETF | 531.69 | 531.75 | 531.6 | 531.74 | 3702.0 |
| 2024-08-09 04:01:00 | SPY | ETF | 531.81 | 531.96 | 531.6 | 531.6 | 3352.0 |
| 2024-08-09 04:02:00 | SPY | ETF | 531.57 | 531.57 | 531.57 | 531.57 | 300.0 |
| 2024-08-09 04:03:00 | SPY | ETF | 531.56 | 531.56 | 531.55 | 531.56 | 500.0 |
| 2024-08-09 04:04:00 | SPY | ETF | 531.62 | 531.75 | 531.62 | 531.75 | 363.0 |
| 2024-08-09 04:05:00 | SPY | ETF | 531.81 | 531.81 | 531.63 | 531.63 | 231.0 |
| 2024-08-09 04:07:00 | SPY | ETF | 531.65 | 531.65 | 531.65 | 531.65 | 100.0 |
| 2024-08-09 04:08:00 | SPY | ETF | 531.62 | 531.62 | 531.62 | 531.62 | 250.0 |
| 2024-08-09 04:10:00 | SPY | ETF | 531.57 | 531.68 | 531.57 | 531.68 | 342.0 |
| 2024-08-09 04:13:00 | SPY | ETF | 531.9 | 531.9 | 531.9 | 531.9 | 300.0 |
| 2024-08-09 04:14:00 | SPY | ETF | 531.72 | 531.72 | 531.61 | 531.61 | 438.0 |
| 2024-08-09 04:15:00 | SPY | ETF | 531.6 | 531.65 | 531.56 | 531.56 | 4644.0 |
| 2024-08-09 04:16:00 | SPY | ETF | 531.53 | 531.53 | 531.53 | 531.53 | 100.0 |
| 2024-08-09 04:20:00 | SPY | ETF | 531.42 | 531.42 | 531.42 | 531.42 | 713.0 |
| 2024-08-09 04:21:00 | SPY | ETF | 531.46 | 531.46 | 531.36 | 531.36 | 779.0 |
| 2024-08-09 04:22:00 | SPY | ETF | 531.43 | 531.47 | 531.43 | 531.47 | 228.0 |
| 2024-08-09 04:23:00 | SPY | ETF | 531.54 | 531.54 | 531.54 | 531.54 | 250.0 |
| 2024-08-09 04:24:00 | SPY | ETF | 531.6 | 531.6 | 531.6 | 531.6 | 100.0 |
| 2024-08-09 04:25:00 | SPY | ETF | 531.6 | 531.6 | 531.6 | 531.6 | 172.0 |
| 2024-08-09 04:28:00 | SPY | ETF | 531.76 | 531.76 | 531.76 | 531.76 | 100.0 |
| 2024-08-09 04:29:00 | SPY | ETF | 531.85 | 531.9 | 531.85 | 531.9 | 389.0 |
| 2024-08-09 04:30:00 | SPY | ETF | 531.79 | 531.86 | 531.79 | 531.86 | 354.0 |
| 2024-08-09 04:31:00 | SPY | ETF | 532.0 | 532.25 | 532.0 | 532.25 | 498.0 |
| 2024-08-09 04:32:00 | SPY | ETF | 532.31 | 532.62 | 532.3 | 532.62 | 9315.0 |
| 2024-08-09 04:33:00 | SPY | ETF | 532.5 | 532.5 | 532.26 | 532.26 | 10614.0 |
| 2024-08-09 04:34:00 | SPY | ETF | 532.49 | 532.72 | 532.34 | 532.72 | 3009.0 |
| 2024-08-09 04:35:00 | SPY | ETF | 532.82 | 532.92 | 532.75 | 532.92 | 1142.0 |
| 2024-08-09 04:36:00 | SPY | ETF | 532.73 | 532.75 | 532.66 | 532.66 | 309.0 |
| 2024-08-09 04:37:00 | SPY | ETF | 532.73 | 532.85 | 532.73 | 532.81 | 2584.0 |
| 2024-08-09 04:39:00 | SPY | ETF | 532.95 | 533.02 | 532.95 | 533.02 | 400.0 |
| 2024-08-09 04:42:00 | SPY | ETF | 532.99 | 532.99 | 532.99 | 532.99 | 300.0 |
| 2024-08-09 04:43:00 | SPY | ETF | 532.97 | 533.02 | 532.97 | 533.02 | 614.0 |
| 2024-08-09 04:45:00 | SPY | ETF | 533.06 | 533.06 | 533.06 | 533.06 | 2000.0 |
| 2024-08-09 04:46:00 | SPY | ETF | 532.85 | 532.85 | 532.85 | 532.85 | 668.0 |
| 2024-08-09 04:47:00 | SPY | ETF | 532.845 | 532.93 | 532.845 | 532.9 | 657.0 |
| 2024-08-09 04:48:00 | SPY | ETF | 532.93 | 532.93 | 532.93 | 532.93 | 200.0 |
| 2024-08-09 04:49:00 | SPY | ETF | 532.82 | 532.93 | 532.82 | 532.93 | 379.0 |
| 2024-08-09 04:51:00 | SPY | ETF | 533.04 | 533.04 | 533.04 | 533.04 | 132.0 |
| 2024-08-09 04:52:00 | SPY | ETF | 533.13 | 533.14 | 533.13 | 533.14 | 453.0 |
| 2024-08-09 04:56:00 | SPY | ETF | 533.1 | 533.1 | 533.1 | 533.1 | 100.0 |
| 2024-08-09 04:59:00 | SPY | ETF | 532.94 | 532.94 | 532.94 | 532.94 | 100.0 |
| 2024-08-09 05:00:00 | SPY | ETF | 533.0 | 533.0 | 533.0 | 533.0 | 100.0 |
| 2024-08-09 05:05:00 | SPY | ETF | 532.94 | 532.94 | 532.94 | 532.94 | 200.0 |
| 2024-08-09 05:08:00 | SPY | ETF | 532.95 | 532.95 | 532.95 | 532.95 | 500.0 |
| 2024-08-09 05:09:00 | SPY | ETF | 532.87 | 532.87 | 532.87 | 532.87 | 115.0 |
| 2024-08-09 05:10:00 | SPY | ETF | 532.92 | 532.92 | 532.91 | 532.91 | 1525.0 |
| 2024-08-09 05:11:00 | SPY | ETF | 533.07 | 533.07 | 533.07 | 533.07 | 250.0 |
| 2024-08-09 05:13:00 | SPY | ETF | 532.77 | 532.82 | 532.71 | 532.82 | 2231.0 |
| 2024-08-09 05:15:00 | SPY | ETF | 532.71 | 532.83 | 532.71 | 532.83 | 204.0 |
| 2024-08-09 05:16:00 | SPY | ETF | 532.76 | 532.98 | 532.76 | 532.98 | 486.0 |
> showing 50 of 284,054 rows — these rows as CSV