PREVIEW / etf_5min / 2023-12-01
file: by_date/etf_5min/2023/2023-12-01.parquet size: 2.2 MB rows: 107,603
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-12-01 04:00:00 | SPY | ETF | 456.2 | 457.21 | 456.2 | 457.15 | 2111.0 |
| 2023-12-01 04:05:00 | SPY | ETF | 457.16 | 457.18 | 457.08 | 457.18 | 9850.0 |
| 2023-12-01 04:10:00 | SPY | ETF | 457.2 | 457.21 | 457.08 | 457.08 | 30599.0 |
| 2023-12-01 04:15:00 | SPY | ETF | 457.09 | 457.09 | 457.09 | 457.09 | 733.0 |
| 2023-12-01 04:20:00 | SPY | ETF | 457.2 | 457.22 | 457.19 | 457.19 | 3505.0 |
| 2023-12-01 04:25:00 | SPY | ETF | 457.13 | 457.13 | 457.13 | 457.13 | 1200.0 |
| 2023-12-01 04:30:00 | SPY | ETF | 457.24 | 457.24 | 457.24 | 457.24 | 133.0 |
| 2023-12-01 04:40:00 | SPY | ETF | 457.27 | 457.28 | 457.27 | 457.27 | 300.0 |
| 2023-12-01 04:45:00 | SPY | ETF | 457.21 | 457.25 | 457.21 | 457.23 | 1390.0 |
| 2023-12-01 04:50:00 | SPY | ETF | 457.24 | 457.25 | 457.13 | 457.13 | 1150.0 |
| 2023-12-01 04:55:00 | SPY | ETF | 457.05 | 457.05 | 457.05 | 457.05 | 100.0 |
| 2023-12-01 05:00:00 | SPY | ETF | 457.03 | 457.03 | 456.99 | 456.99 | 2423.0 |
| 2023-12-01 05:20:00 | SPY | ETF | 456.94 | 456.94 | 456.94 | 456.94 | 318.0 |
| 2023-12-01 05:30:00 | SPY | ETF | 456.93 | 456.93 | 456.93 | 456.93 | 100.0 |
| 2023-12-01 05:35:00 | SPY | ETF | 456.88 | 456.88 | 456.87 | 456.87 | 211.0 |
| 2023-12-01 05:40:00 | SPY | ETF | 456.75 | 456.75 | 456.7 | 456.7 | 220.0 |
| 2023-12-01 05:45:00 | SPY | ETF | 456.7 | 456.8 | 456.7 | 456.8 | 253.0 |
| 2023-12-01 05:50:00 | SPY | ETF | 456.79 | 456.79 | 456.68 | 456.7 | 3200.0 |
| 2023-12-01 05:55:00 | SPY | ETF | 456.65 | 456.7 | 456.65 | 456.65 | 12700.0 |
| 2023-12-01 06:00:00 | SPY | ETF | 456.64 | 456.69 | 456.62 | 456.69 | 8600.0 |
| 2023-12-01 06:05:00 | SPY | ETF | 456.67 | 456.67 | 456.55 | 456.56 | 4850.0 |
| 2023-12-01 06:10:00 | SPY | ETF | 456.53 | 456.68 | 456.53 | 456.68 | 10614.0 |
| 2023-12-01 06:15:00 | SPY | ETF | 456.73 | 456.73 | 456.67 | 456.67 | 23940.0 |
| 2023-12-01 06:20:00 | SPY | ETF | 456.65 | 456.78 | 456.65 | 456.78 | 6541.0 |
| 2023-12-01 06:25:00 | SPY | ETF | 456.76 | 456.76 | 456.75 | 456.75 | 1200.0 |
| 2023-12-01 06:30:00 | SPY | ETF | 456.76 | 456.76 | 456.72 | 456.72 | 700.0 |
| 2023-12-01 06:35:00 | SPY | ETF | 456.73 | 456.73 | 456.59 | 456.59 | 222.0 |
| 2023-12-01 06:40:00 | SPY | ETF | 456.5 | 456.51 | 456.49 | 456.49 | 1191.0 |
| 2023-12-01 06:45:00 | SPY | ETF | 456.52 | 456.52 | 456.45 | 456.47 | 11480.0 |
| 2023-12-01 06:50:00 | SPY | ETF | 456.49 | 456.58 | 456.48 | 456.55 | 2227.0 |
| 2023-12-01 06:55:00 | SPY | ETF | 456.59 | 456.62 | 456.54 | 456.54 | 4088.0 |
| 2023-12-01 07:00:00 | SPY | ETF | 456.53 | 456.53 | 456.43 | 456.44 | 7319.0 |
| 2023-12-01 07:05:00 | SPY | ETF | 456.46 | 456.54 | 456.33 | 456.33 | 71090.0 |
| 2023-12-01 07:10:00 | SPY | ETF | 456.3 | 456.3 | 456.11 | 456.11 | 19156.0 |
| 2023-12-01 07:15:00 | SPY | ETF | 456.1 | 456.1 | 456.0 | 456.0 | 11500.0 |
| 2023-12-01 07:20:00 | SPY | ETF | 455.98 | 455.98 | 455.82 | 455.95 | 5711.0 |
| 2023-12-01 07:25:00 | SPY | ETF | 455.95 | 456.02 | 455.95 | 456.02 | 11491.0 |
| 2023-12-01 07:30:00 | SPY | ETF | 455.98 | 456.09 | 455.96 | 455.98 | 13133.0 |
| 2023-12-01 07:35:00 | SPY | ETF | 455.95 | 455.97 | 455.9 | 455.95 | 6150.0 |
| 2023-12-01 07:40:00 | SPY | ETF | 455.95 | 455.95 | 455.88 | 455.9 | 3800.0 |
| 2023-12-01 07:45:00 | SPY | ETF | 455.89 | 455.89 | 455.58 | 455.59 | 14041.0 |
| 2023-12-01 07:50:00 | SPY | ETF | 455.58 | 455.63 | 455.45 | 455.52 | 7774.0 |
| 2023-12-01 07:55:00 | SPY | ETF | 455.52 | 455.59 | 455.5 | 455.58 | 10304.0 |
| 2023-12-01 08:00:00 | SPY | ETF | 455.55 | 457.3104 | 455.45 | 455.72 | 47117.0 |
| 2023-12-01 08:05:00 | SPY | ETF | 455.7 | 455.76 | 455.6801 | 455.75 | 2340.0 |
| 2023-12-01 08:10:00 | SPY | ETF | 455.71 | 455.741 | 455.54 | 455.6 | 6434.0 |
| 2023-12-01 08:15:00 | SPY | ETF | 455.61 | 455.78 | 455.58 | 455.78 | 8322.0 |
| 2023-12-01 08:20:00 | SPY | ETF | 455.77 | 455.85 | 455.72 | 455.83 | 9034.0 |
| 2023-12-01 08:25:00 | SPY | ETF | 455.85 | 455.91 | 455.81 | 455.8101 | 7431.0 |
| 2023-12-01 08:30:00 | SPY | ETF | 455.94 | 455.94 | 455.75 | 455.78 | 12066.0 |
> showing 50 of 107,603 rows — these rows as CSV