PREVIEW / etf_5min / 2004-07-01
file: by_date/etf_5min/2004/2004-07-01.parquet size: 97 KB rows: 4,774
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-07-01 08:00:00 | SPY | ETF | 114.51 | 114.51 | 114.4 | 114.4 | 1900.0 |
| 2004-07-01 08:05:00 | SPY | ETF | 114.41 | 114.41 | 114.41 | 114.41 | 200.0 |
| 2004-07-01 08:15:00 | SPY | ETF | 114.41 | 114.42 | 114.36 | 114.37 | 9600.0 |
| 2004-07-01 08:20:00 | SPY | ETF | 114.37 | 114.37 | 114.34 | 114.36 | 2100.0 |
| 2004-07-01 08:25:00 | SPY | ETF | 114.38 | 114.38 | 114.36 | 114.36 | 7500.0 |
| 2004-07-01 08:30:00 | SPY | ETF | 114.37 | 114.37 | 114.3 | 114.3 | 25400.0 |
| 2004-07-01 08:35:00 | SPY | ETF | 114.4 | 114.4 | 114.4 | 114.4 | 2000.0 |
| 2004-07-01 08:40:00 | SPY | ETF | 114.4 | 114.4 | 114.37 | 114.37 | 4500.0 |
| 2004-07-01 08:55:00 | SPY | ETF | 114.39 | 114.39 | 114.39 | 114.39 | 300.0 |
| 2004-07-01 09:00:00 | SPY | ETF | 114.39 | 114.47 | 114.39 | 114.47 | 11900.0 |
| 2004-07-01 09:05:00 | SPY | ETF | 114.45 | 114.45 | 114.4 | 114.42 | 13000.0 |
| 2004-07-01 09:10:00 | SPY | ETF | 114.42 | 114.42 | 114.4 | 114.41 | 19900.0 |
| 2004-07-01 09:15:00 | SPY | ETF | 114.4 | 114.4 | 114.38 | 114.38 | 400.0 |
| 2004-07-01 09:20:00 | SPY | ETF | 114.4 | 114.4 | 114.38 | 114.38 | 600.0 |
| 2004-07-01 09:25:00 | SPY | ETF | 114.36 | 114.36 | 114.3 | 114.3 | 16500.0 |
| 2004-07-01 09:30:00 | SPY | ETF | 114.25 | 114.34 | 114.24 | 114.3 | 822400.0 |
| 2004-07-01 09:35:00 | SPY | ETF | 114.31 | 114.36 | 114.24 | 114.36 | 537900.0 |
| 2004-07-01 09:40:00 | SPY | ETF | 114.35 | 114.4 | 114.25 | 114.32 | 854000.0 |
| 2004-07-01 09:45:00 | SPY | ETF | 114.31 | 114.38 | 114.24 | 114.3 | 414400.0 |
| 2004-07-01 09:50:00 | SPY | ETF | 114.31 | 114.34 | 114.1 | 114.15 | 722200.0 |
| 2004-07-01 09:55:00 | SPY | ETF | 114.11 | 114.13 | 114.04 | 114.09 | 779300.0 |
| 2004-07-01 10:00:00 | SPY | ETF | 114.09 | 114.28 | 114.08 | 114.23 | 1365800.0 |
| 2004-07-01 10:05:00 | SPY | ETF | 114.23 | 114.26 | 114.13 | 114.14 | 439700.0 |
| 2004-07-01 10:10:00 | SPY | ETF | 114.14 | 114.18 | 113.95 | 114.01 | 368800.0 |
| 2004-07-01 10:15:00 | SPY | ETF | 114.0 | 114.02 | 113.92 | 113.98 | 849900.0 |
| 2004-07-01 10:20:00 | SPY | ETF | 113.98 | 114.0 | 113.82 | 113.82 | 484600.0 |
| 2004-07-01 10:25:00 | SPY | ETF | 113.86 | 113.94 | 113.82 | 113.92 | 310500.0 |
| 2004-07-01 10:30:00 | SPY | ETF | 113.92 | 113.97 | 113.9 | 113.97 | 263900.0 |
| 2004-07-01 10:35:00 | SPY | ETF | 113.97 | 113.97 | 113.87 | 113.87 | 223400.0 |
| 2004-07-01 10:40:00 | SPY | ETF | 113.88 | 113.96 | 113.85 | 113.89 | 187300.0 |
| 2004-07-01 10:45:00 | SPY | ETF | 113.9 | 113.93 | 113.76 | 113.82 | 355700.0 |
| 2004-07-01 10:50:00 | SPY | ETF | 113.8 | 113.83 | 113.7 | 113.71 | 546000.0 |
| 2004-07-01 10:55:00 | SPY | ETF | 113.71 | 113.77 | 113.53 | 113.55 | 1180700.0 |
| 2004-07-01 11:00:00 | SPY | ETF | 113.53 | 113.57 | 113.18 | 113.38 | 1445100.0 |
| 2004-07-01 11:05:00 | SPY | ETF | 113.38 | 113.42 | 113.22 | 113.22 | 1372100.0 |
| 2004-07-01 11:10:00 | SPY | ETF | 113.22 | 113.24 | 112.85 | 113.0 | 2735700.0 |
| 2004-07-01 11:15:00 | SPY | ETF | 113.01 | 113.13 | 112.93 | 113.11 | 1924300.0 |
| 2004-07-01 11:20:00 | SPY | ETF | 113.12 | 113.12 | 112.98 | 113.05 | 1543700.0 |
| 2004-07-01 11:25:00 | SPY | ETF | 113.05 | 113.19 | 113.02 | 113.18 | 503800.0 |
| 2004-07-01 11:30:00 | SPY | ETF | 113.18 | 113.19 | 113.09 | 113.17 | 392000.0 |
| 2004-07-01 11:35:00 | SPY | ETF | 113.16 | 113.18 | 113.11 | 113.18 | 245500.0 |
| 2004-07-01 11:40:00 | SPY | ETF | 113.19 | 113.19 | 113.0 | 113.04 | 408400.0 |
| 2004-07-01 11:45:00 | SPY | ETF | 113.07 | 113.08 | 112.98 | 113.03 | 353400.0 |
| 2004-07-01 11:50:00 | SPY | ETF | 113.03 | 113.12 | 113.0 | 113.06 | 713900.0 |
| 2004-07-01 11:55:00 | SPY | ETF | 113.06 | 113.15 | 113.03 | 113.09 | 722500.0 |
| 2004-07-01 12:00:00 | SPY | ETF | 113.08 | 113.11 | 113.0 | 113.04 | 641500.0 |
| 2004-07-01 12:05:00 | SPY | ETF | 113.06 | 113.06 | 112.91 | 112.96 | 387400.0 |
| 2004-07-01 12:10:00 | SPY | ETF | 112.94 | 112.99 | 112.91 | 112.96 | 329600.0 |
| 2004-07-01 12:15:00 | SPY | ETF | 112.99 | 113.01 | 112.92 | 112.98 | 217400.0 |
| 2004-07-01 12:20:00 | SPY | ETF | 112.99 | 113.01 | 112.95 | 113.0 | 278900.0 |
> showing 50 of 4,774 rows — these rows as CSV