PREVIEW / etf_5min / 2004-01-21
file: by_date/etf_5min/2004/2004-01-21.parquet size: 99 KB rows: 4,986
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-21 08:05:00 | SPY | ETF | 114.21 | 114.21 | 114.21 | 114.21 | 2600.0 |
| 2004-01-21 08:15:00 | SPY | ETF | 114.27 | 114.27 | 114.27 | 114.27 | 1600.0 |
| 2004-01-21 08:25:00 | SPY | ETF | 114.26 | 114.26 | 114.22 | 114.22 | 3600.0 |
| 2004-01-21 08:30:00 | SPY | ETF | 114.25 | 114.27 | 114.25 | 114.27 | 200.0 |
| 2004-01-21 08:35:00 | SPY | ETF | 114.16 | 114.16 | 114.16 | 114.16 | 2900.0 |
| 2004-01-21 08:40:00 | SPY | ETF | 114.11 | 114.11 | 114.09 | 114.09 | 1400.0 |
| 2004-01-21 08:55:00 | SPY | ETF | 114.16 | 114.16 | 114.16 | 114.16 | 2500.0 |
| 2004-01-21 09:00:00 | SPY | ETF | 114.17 | 114.2 | 114.17 | 114.18 | 5400.0 |
| 2004-01-21 09:05:00 | SPY | ETF | 114.18 | 114.18 | 114.13 | 114.13 | 7600.0 |
| 2004-01-21 09:10:00 | SPY | ETF | 114.13 | 114.14 | 114.12 | 114.12 | 1200.0 |
| 2004-01-21 09:25:00 | SPY | ETF | 114.1 | 114.13 | 114.1 | 114.13 | 900.0 |
| 2004-01-21 09:30:00 | SPY | ETF | 114.13 | 114.16 | 113.95 | 113.95 | 554100.0 |
| 2004-01-21 09:35:00 | SPY | ETF | 113.96 | 114.01 | 113.87 | 113.9 | 509500.0 |
| 2004-01-21 09:40:00 | SPY | ETF | 113.88 | 113.98 | 113.84 | 113.92 | 252700.0 |
| 2004-01-21 09:45:00 | SPY | ETF | 113.92 | 113.97 | 113.83 | 113.95 | 267700.0 |
| 2004-01-21 09:50:00 | SPY | ETF | 113.951 | 114.03 | 113.92 | 113.97 | 373000.0 |
| 2004-01-21 09:55:00 | SPY | ETF | 113.94 | 114.02 | 113.9 | 114.02 | 273100.0 |
| 2004-01-21 10:00:00 | SPY | ETF | 114.02 | 114.03 | 113.75 | 113.79 | 408400.0 |
| 2004-01-21 10:05:00 | SPY | ETF | 113.8 | 113.87 | 113.72 | 113.85 | 626700.0 |
| 2004-01-21 10:10:00 | SPY | ETF | 113.85 | 113.92 | 113.83 | 113.87 | 190800.0 |
| 2004-01-21 10:15:00 | SPY | ETF | 113.86 | 114.03 | 113.86 | 113.98 | 242900.0 |
| 2004-01-21 10:20:00 | SPY | ETF | 114.0 | 114.1 | 113.94 | 113.95 | 439600.0 |
| 2004-01-21 10:25:00 | SPY | ETF | 113.94 | 113.96 | 113.76 | 113.76 | 340300.0 |
| 2004-01-21 10:30:00 | SPY | ETF | 113.75 | 113.89 | 113.75 | 113.77 | 380000.0 |
| 2004-01-21 10:35:00 | SPY | ETF | 113.78 | 113.85 | 113.72 | 113.84 | 604300.0 |
| 2004-01-21 10:40:00 | SPY | ETF | 113.84 | 113.9 | 113.8 | 113.88 | 672500.0 |
| 2004-01-21 10:45:00 | SPY | ETF | 113.86 | 113.88 | 113.74 | 113.82 | 337900.0 |
| 2004-01-21 10:50:00 | SPY | ETF | 113.81 | 113.94 | 113.8 | 113.92 | 294100.0 |
| 2004-01-21 10:55:00 | SPY | ETF | 113.94 | 113.99 | 113.87 | 113.93 | 230100.0 |
| 2004-01-21 11:00:00 | SPY | ETF | 113.92 | 113.94 | 113.87 | 113.93 | 99200.0 |
| 2004-01-21 11:05:00 | SPY | ETF | 113.93 | 114.0 | 113.85 | 113.85 | 166700.0 |
| 2004-01-21 11:10:00 | SPY | ETF | 113.85 | 114.01 | 113.85 | 113.99 | 142100.0 |
| 2004-01-21 11:15:00 | SPY | ETF | 113.99 | 114.05 | 113.95 | 113.97 | 298400.0 |
| 2004-01-21 11:20:00 | SPY | ETF | 113.98 | 113.99 | 113.92 | 113.98 | 266200.0 |
| 2004-01-21 11:25:00 | SPY | ETF | 113.99 | 114.03 | 113.96 | 114.02 | 88500.0 |
| 2004-01-21 11:30:00 | SPY | ETF | 114.02 | 114.2 | 113.98 | 114.19 | 351600.0 |
| 2004-01-21 11:35:00 | SPY | ETF | 114.19 | 114.19 | 114.12 | 114.13 | 340200.0 |
| 2004-01-21 11:40:00 | SPY | ETF | 114.14 | 114.2 | 114.07 | 114.15 | 337000.0 |
| 2004-01-21 11:45:00 | SPY | ETF | 114.12 | 114.25 | 114.12 | 114.24 | 296800.0 |
| 2004-01-21 11:50:00 | SPY | ETF | 114.25 | 114.28 | 114.17 | 114.19 | 197400.0 |
| 2004-01-21 11:55:00 | SPY | ETF | 114.17 | 114.23 | 114.12 | 114.16 | 81500.0 |
| 2004-01-21 12:00:00 | SPY | ETF | 114.14 | 114.2 | 114.1 | 114.12 | 390200.0 |
| 2004-01-21 12:05:00 | SPY | ETF | 114.13 | 114.2 | 114.12 | 114.18 | 119000.0 |
| 2004-01-21 12:10:00 | SPY | ETF | 114.18 | 114.22 | 114.12 | 114.17 | 369600.0 |
| 2004-01-21 12:15:00 | SPY | ETF | 114.17 | 114.21 | 114.1 | 114.12 | 119600.0 |
| 2004-01-21 12:20:00 | SPY | ETF | 114.13 | 114.51 | 114.12 | 114.51 | 533700.0 |
| 2004-01-21 12:25:00 | SPY | ETF | 114.5 | 114.56 | 114.42 | 114.42 | 767600.0 |
| 2004-01-21 12:30:00 | SPY | ETF | 114.43 | 114.56 | 114.4 | 114.48 | 213000.0 |
| 2004-01-21 12:35:00 | SPY | ETF | 114.48 | 114.54 | 114.42 | 114.49 | 67500.0 |
| 2004-01-21 12:40:00 | SPY | ETF | 114.48 | 114.55 | 114.47 | 114.52 | 240400.0 |
> showing 50 of 4,986 rows — these rows as CSV