PREVIEW / etf_5min / 2003-08-27
file: by_date/etf_5min/2003/2003-08-27.parquet size: 49 KB rows: 2,526
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-27 08:00:00 | SPY | ETF | 100.17 | 100.17 | 100.17 | 100.17 | 1500.0 |
| 2003-08-27 08:05:00 | SPY | ETF | 100.16 | 100.16 | 100.14 | 100.14 | 2000.0 |
| 2003-08-27 08:10:00 | SPY | ETF | 100.14 | 100.14 | 100.14 | 100.14 | 9700.0 |
| 2003-08-27 08:30:00 | SPY | ETF | 100.11 | 100.12 | 100.11 | 100.12 | 500.0 |
| 2003-08-27 08:35:00 | SPY | ETF | 100.1 | 100.1 | 100.09 | 100.09 | 4200.0 |
| 2003-08-27 08:45:00 | SPY | ETF | 100.11 | 100.13 | 100.1 | 100.13 | 800.0 |
| 2003-08-27 08:50:00 | SPY | ETF | 100.1 | 100.14 | 100.1 | 100.13 | 1500.0 |
| 2003-08-27 08:55:00 | SPY | ETF | 100.07 | 100.07 | 100.06 | 100.06 | 900.0 |
| 2003-08-27 09:00:00 | SPY | ETF | 100.04 | 100.04 | 100.01 | 100.01 | 3500.0 |
| 2003-08-27 09:05:00 | SPY | ETF | 100.01 | 100.01 | 100.0 | 100.0 | 1400.0 |
| 2003-08-27 09:10:00 | SPY | ETF | 99.99 | 100.0 | 99.98 | 99.98 | 6600.0 |
| 2003-08-27 09:15:00 | SPY | ETF | 100.0 | 100.0 | 100.0 | 100.0 | 500.0 |
| 2003-08-27 09:20:00 | SPY | ETF | 100.02 | 100.02 | 100.02 | 100.02 | 3500.0 |
| 2003-08-27 09:25:00 | SPY | ETF | 100.02 | 100.03 | 99.98 | 100.03 | 10600.0 |
| 2003-08-27 09:30:00 | SPY | ETF | 100.05 | 100.11 | 100.01 | 100.07 | 670200.0 |
| 2003-08-27 09:35:00 | SPY | ETF | 100.05 | 100.13 | 100.0 | 100.07 | 412600.0 |
| 2003-08-27 09:40:00 | SPY | ETF | 100.09 | 100.16 | 100.04 | 100.07 | 358800.0 |
| 2003-08-27 09:45:00 | SPY | ETF | 100.099 | 100.16 | 99.99 | 100.03 | 238000.0 |
| 2003-08-27 09:50:00 | SPY | ETF | 100.02 | 100.1 | 100.0 | 100.05 | 251100.0 |
| 2003-08-27 09:55:00 | SPY | ETF | 100.04 | 100.08 | 99.95 | 99.97 | 851100.0 |
| 2003-08-27 10:00:00 | SPY | ETF | 99.95 | 100.01 | 99.88 | 99.92 | 618000.0 |
| 2003-08-27 10:05:00 | SPY | ETF | 99.98 | 99.98 | 99.85 | 99.96 | 442800.0 |
| 2003-08-27 10:10:00 | SPY | ETF | 99.94 | 99.97 | 99.84 | 99.91 | 201400.0 |
| 2003-08-27 10:15:00 | SPY | ETF | 99.9 | 100.0 | 99.9 | 99.98 | 196000.0 |
| 2003-08-27 10:20:00 | SPY | ETF | 99.99 | 100.01 | 99.88 | 99.97 | 184400.0 |
| 2003-08-27 10:25:00 | SPY | ETF | 99.97 | 100.0 | 99.82 | 99.94 | 283200.0 |
| 2003-08-27 10:30:00 | SPY | ETF | 99.92 | 100.02 | 99.89 | 99.95 | 234700.0 |
| 2003-08-27 10:35:00 | SPY | ETF | 99.97 | 100.14 | 99.94 | 100.06 | 130600.0 |
| 2003-08-27 10:40:00 | SPY | ETF | 100.08 | 100.252 | 100.08 | 100.22 | 555600.0 |
| 2003-08-27 10:45:00 | SPY | ETF | 100.21 | 100.24 | 100.11 | 100.15 | 440000.0 |
| 2003-08-27 10:50:00 | SPY | ETF | 100.16 | 100.2 | 100.13 | 100.14 | 138400.0 |
| 2003-08-27 10:55:00 | SPY | ETF | 100.11 | 100.18 | 100.11 | 100.17 | 239500.0 |
| 2003-08-27 11:00:00 | SPY | ETF | 100.153 | 100.18 | 100.12 | 100.16 | 266800.0 |
| 2003-08-27 11:05:00 | SPY | ETF | 100.16 | 100.19 | 100.07 | 100.07 | 381100.0 |
| 2003-08-27 11:10:00 | SPY | ETF | 100.06 | 100.17 | 100.02 | 100.12 | 156700.0 |
| 2003-08-27 11:15:00 | SPY | ETF | 100.13 | 100.15 | 100.07 | 100.12 | 131300.0 |
| 2003-08-27 11:20:00 | SPY | ETF | 100.11 | 100.16 | 100.05 | 100.1 | 152100.0 |
| 2003-08-27 11:25:00 | SPY | ETF | 100.1 | 100.15 | 100.05 | 100.12 | 102500.0 |
| 2003-08-27 11:30:00 | SPY | ETF | 100.12 | 100.16 | 100.07 | 100.14 | 192500.0 |
| 2003-08-27 11:35:00 | SPY | ETF | 100.12 | 100.171 | 100.1 | 100.16 | 114700.0 |
| 2003-08-27 11:40:00 | SPY | ETF | 100.13 | 100.208 | 100.12 | 100.14 | 209900.0 |
| 2003-08-27 11:45:00 | SPY | ETF | 100.16 | 100.16 | 100.07 | 100.11 | 69500.0 |
| 2003-08-27 11:50:00 | SPY | ETF | 100.12 | 100.12 | 100.07 | 100.07 | 32000.0 |
| 2003-08-27 11:55:00 | SPY | ETF | 100.09 | 100.11 | 100.08 | 100.08 | 82900.0 |
| 2003-08-27 12:00:00 | SPY | ETF | 100.09 | 100.12 | 100.07 | 100.08 | 119200.0 |
| 2003-08-27 12:05:00 | SPY | ETF | 100.09 | 100.12 | 100.04 | 100.12 | 102700.0 |
| 2003-08-27 12:10:00 | SPY | ETF | 100.12 | 100.12 | 100.08 | 100.11 | 68900.0 |
| 2003-08-27 12:15:00 | SPY | ETF | 100.1 | 100.12 | 100.07 | 100.09 | 21800.0 |
| 2003-08-27 12:20:00 | SPY | ETF | 100.1 | 100.11 | 100.06 | 100.09 | 40400.0 |
| 2003-08-27 12:25:00 | SPY | ETF | 100.09 | 100.11 | 100.06 | 100.1 | 31800.0 |
> showing 50 of 2,526 rows — these rows as CSV