PREVIEW / etf_5min / 2004-06-18
file: by_date/etf_5min/2004/2004-06-18.parquet size: 81 KB rows: 4,288
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-06-18 08:00:00 | SPY | ETF | 113.13 | 113.15 | 113.13 | 113.13 | 4000.0 |
| 2004-06-18 08:05:00 | SPY | ETF | 113.15 | 113.15 | 113.14 | 113.15 | 22700.0 |
| 2004-06-18 08:10:00 | SPY | ETF | 113.13 | 113.13 | 113.13 | 113.13 | 2500.0 |
| 2004-06-18 08:15:00 | SPY | ETF | 113.15 | 113.15 | 113.12 | 113.13 | 4100.0 |
| 2004-06-18 08:20:00 | SPY | ETF | 113.13 | 113.15 | 113.13 | 113.15 | 3500.0 |
| 2004-06-18 08:25:00 | SPY | ETF | 113.18 | 113.23 | 113.18 | 113.23 | 26000.0 |
| 2004-06-18 08:30:00 | SPY | ETF | 113.25 | 113.27 | 113.24 | 113.27 | 2200.0 |
| 2004-06-18 08:35:00 | SPY | ETF | 113.27 | 113.28 | 113.27 | 113.28 | 400.0 |
| 2004-06-18 08:40:00 | SPY | ETF | 113.26 | 113.26 | 113.26 | 113.26 | 1100.0 |
| 2004-06-18 08:45:00 | SPY | ETF | 113.26 | 113.33 | 113.26 | 113.33 | 4600.0 |
| 2004-06-18 08:50:00 | SPY | ETF | 113.27 | 113.33 | 113.27 | 113.32 | 28500.0 |
| 2004-06-18 08:55:00 | SPY | ETF | 113.33 | 113.33 | 113.33 | 113.33 | 3800.0 |
| 2004-06-18 09:00:00 | SPY | ETF | 113.32 | 113.32 | 113.3 | 113.3 | 2500.0 |
| 2004-06-18 09:05:00 | SPY | ETF | 113.28 | 113.28 | 113.27 | 113.27 | 3400.0 |
| 2004-06-18 09:10:00 | SPY | ETF | 113.28 | 113.29 | 113.27 | 113.27 | 300.0 |
| 2004-06-18 09:15:00 | SPY | ETF | 113.28 | 113.29 | 113.27 | 113.28 | 30400.0 |
| 2004-06-18 09:20:00 | SPY | ETF | 113.3 | 113.32 | 113.3 | 113.3 | 8500.0 |
| 2004-06-18 09:25:00 | SPY | ETF | 113.3 | 113.3 | 113.26 | 113.26 | 20600.0 |
| 2004-06-18 09:30:00 | SPY | ETF | 113.2 | 113.3 | 113.2 | 113.3 | 746100.0 |
| 2004-06-18 09:35:00 | SPY | ETF | 113.3 | 113.35 | 113.2215 | 113.29 | 1170500.0 |
| 2004-06-18 09:40:00 | SPY | ETF | 113.28 | 113.4 | 113.28 | 113.37 | 1078500.0 |
| 2004-06-18 09:45:00 | SPY | ETF | 113.39 | 113.54 | 113.32 | 113.52 | 772100.0 |
| 2004-06-18 09:50:00 | SPY | ETF | 113.53 | 113.65 | 113.53 | 113.59 | 767600.0 |
| 2004-06-18 09:55:00 | SPY | ETF | 113.59 | 113.6 | 113.52 | 113.55 | 681700.0 |
| 2004-06-18 10:00:00 | SPY | ETF | 113.56 | 113.8 | 113.54 | 113.77 | 1368400.0 |
| 2004-06-18 10:05:00 | SPY | ETF | 113.76 | 113.97 | 113.74 | 113.92 | 1423900.0 |
| 2004-06-18 10:10:00 | SPY | ETF | 113.92 | 113.94 | 113.85 | 113.91 | 978500.0 |
| 2004-06-18 10:15:00 | SPY | ETF | 113.91 | 114.03 | 113.88 | 114.01 | 507100.0 |
| 2004-06-18 10:20:00 | SPY | ETF | 114.03 | 114.05 | 113.92 | 113.95 | 486100.0 |
| 2004-06-18 10:25:00 | SPY | ETF | 113.95 | 114.06 | 113.94 | 114.06 | 292300.0 |
| 2004-06-18 10:30:00 | SPY | ETF | 114.06 | 114.22 | 113.98 | 114.14 | 1163800.0 |
| 2004-06-18 10:35:00 | SPY | ETF | 114.14 | 114.16 | 114.09 | 114.09 | 340600.0 |
| 2004-06-18 10:40:00 | SPY | ETF | 114.1 | 114.12 | 113.97 | 114.1 | 400500.0 |
| 2004-06-18 10:45:00 | SPY | ETF | 114.11 | 114.17 | 114.05 | 114.08 | 198700.0 |
| 2004-06-18 10:50:00 | SPY | ETF | 114.08 | 114.1 | 114.05 | 114.09 | 173500.0 |
| 2004-06-18 10:55:00 | SPY | ETF | 114.09 | 114.09 | 114.04 | 114.04 | 99500.0 |
| 2004-06-18 11:00:00 | SPY | ETF | 114.04 | 114.11 | 114.04 | 114.1 | 167200.0 |
| 2004-06-18 11:05:00 | SPY | ETF | 114.09 | 114.14 | 114.04 | 114.06 | 154800.0 |
| 2004-06-18 11:10:00 | SPY | ETF | 114.05 | 114.1 | 114.0 | 114.03 | 505900.0 |
| 2004-06-18 11:15:00 | SPY | ETF | 114.03 | 114.06 | 113.98 | 114.02 | 909500.0 |
| 2004-06-18 11:20:00 | SPY | ETF | 114.0 | 114.08 | 114.0 | 114.03 | 328500.0 |
| 2004-06-18 11:25:00 | SPY | ETF | 114.03 | 114.05 | 114.02 | 114.04 | 172200.0 |
| 2004-06-18 11:30:00 | SPY | ETF | 114.02 | 114.05 | 114.01 | 114.03 | 65200.0 |
| 2004-06-18 11:35:00 | SPY | ETF | 114.03 | 114.1 | 114.03 | 114.1 | 114000.0 |
| 2004-06-18 11:40:00 | SPY | ETF | 114.11 | 114.11 | 114.01 | 114.01 | 157900.0 |
| 2004-06-18 11:45:00 | SPY | ETF | 114.01 | 114.05 | 114.0 | 114.01 | 49900.0 |
| 2004-06-18 11:50:00 | SPY | ETF | 114.02 | 114.07 | 113.99 | 114.01 | 280200.0 |
| 2004-06-18 11:55:00 | SPY | ETF | 114.01 | 114.05 | 113.98 | 113.99 | 293900.0 |
| 2004-06-18 12:00:00 | SPY | ETF | 113.97 | 114.02 | 113.95 | 113.96 | 93500.0 |
| 2004-06-18 12:05:00 | SPY | ETF | 113.96 | 113.99 | 113.84 | 113.85 | 591100.0 |
> showing 50 of 4,288 rows — these rows as CSV