PREVIEW / etf_5min / 2002-07-19
file: by_date/etf_5min/2002/2002-07-19.parquet size: 49 KB rows: 2,079
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-19 09:30:00 | SPY | ETF | 86.76 | 87.1 | 86.65 | 86.83 | 1157100.0 |
| 2002-07-19 09:35:00 | SPY | ETF | 86.83 | 86.95 | 86.35 | 86.5 | 996700.0 |
| 2002-07-19 09:40:00 | SPY | ETF | 86.46 | 87.1 | 86.4 | 87.01 | 1013800.0 |
| 2002-07-19 09:45:00 | SPY | ETF | 87.0 | 87.2 | 86.72 | 86.74 | 1736200.0 |
| 2002-07-19 09:50:00 | SPY | ETF | 86.75 | 86.98 | 86.5 | 86.57 | 905500.0 |
| 2002-07-19 09:55:00 | SPY | ETF | 86.55 | 87.03 | 86.5 | 86.83 | 610500.0 |
| 2002-07-19 10:00:00 | SPY | ETF | 86.85 | 86.97 | 86.65 | 86.97 | 896200.0 |
| 2002-07-19 10:05:00 | SPY | ETF | 86.96 | 87.08 | 86.75 | 87.07 | 510100.0 |
| 2002-07-19 10:10:00 | SPY | ETF | 87.0 | 87.4 | 86.9 | 87.36 | 1330900.0 |
| 2002-07-19 10:15:00 | SPY | ETF | 87.35 | 87.55 | 87.24 | 87.29 | 1536600.0 |
| 2002-07-19 10:20:00 | SPY | ETF | 87.29 | 87.3 | 87.05 | 87.24 | 399500.0 |
| 2002-07-19 10:25:00 | SPY | ETF | 87.26 | 87.27 | 86.9 | 86.95 | 725500.0 |
| 2002-07-19 10:30:00 | SPY | ETF | 86.95 | 87.23 | 86.92 | 87.04 | 407700.0 |
| 2002-07-19 10:35:00 | SPY | ETF | 87.08 | 87.09 | 86.65 | 86.76 | 856100.0 |
| 2002-07-19 10:40:00 | SPY | ETF | 86.78 | 87.06 | 86.7 | 87.0 | 454100.0 |
| 2002-07-19 10:45:00 | SPY | ETF | 87.05 | 87.12 | 86.8 | 86.85 | 387500.0 |
| 2002-07-19 10:50:00 | SPY | ETF | 86.86 | 87.04 | 86.73 | 87.0 | 181100.0 |
| 2002-07-19 10:55:00 | SPY | ETF | 86.97 | 87.2 | 86.85 | 86.85 | 798900.0 |
| 2002-07-19 11:00:00 | SPY | ETF | 86.85 | 86.88 | 86.6 | 86.77 | 944000.0 |
| 2002-07-19 11:05:00 | SPY | ETF | 86.7 | 86.9 | 86.62 | 86.89 | 553600.0 |
| 2002-07-19 11:10:00 | SPY | ETF | 86.9 | 87.03 | 86.8 | 86.84 | 306900.0 |
| 2002-07-19 11:15:00 | SPY | ETF | 86.82 | 86.86 | 86.57 | 86.62 | 433800.0 |
| 2002-07-19 11:20:00 | SPY | ETF | 86.67 | 86.76 | 86.3 | 86.4 | 1115200.0 |
| 2002-07-19 11:25:00 | SPY | ETF | 86.41 | 86.45 | 86.12 | 86.44 | 794700.0 |
| 2002-07-19 11:30:00 | SPY | ETF | 86.45 | 86.5 | 86.33 | 86.45 | 581500.0 |
| 2002-07-19 11:35:00 | SPY | ETF | 86.46 | 86.59 | 86.35 | 86.46 | 379900.0 |
| 2002-07-19 11:40:00 | SPY | ETF | 86.44 | 86.5 | 86.27 | 86.35 | 647500.0 |
| 2002-07-19 11:45:00 | SPY | ETF | 86.3 | 86.5 | 86.08 | 86.18 | 697200.0 |
| 2002-07-19 11:50:00 | SPY | ETF | 86.14 | 86.25 | 86.06 | 86.1 | 721300.0 |
| 2002-07-19 11:55:00 | SPY | ETF | 86.08 | 86.22 | 86.05 | 86.14 | 484600.0 |
| 2002-07-19 12:00:00 | SPY | ETF | 86.14 | 86.4 | 86.12 | 86.37 | 302400.0 |
| 2002-07-19 12:05:00 | SPY | ETF | 86.39 | 86.53 | 86.28 | 86.34 | 299700.0 |
| 2002-07-19 12:10:00 | SPY | ETF | 86.33 | 86.67 | 86.31 | 86.65 | 330600.0 |
| 2002-07-19 12:15:00 | SPY | ETF | 86.65 | 86.72 | 86.42 | 86.49 | 421000.0 |
| 2002-07-19 12:20:00 | SPY | ETF | 86.5 | 86.56 | 86.36 | 86.46 | 156900.0 |
| 2002-07-19 12:25:00 | SPY | ETF | 86.41 | 86.62 | 86.39 | 86.39 | 190700.0 |
| 2002-07-19 12:30:00 | SPY | ETF | 86.39 | 86.45 | 86.14 | 86.16 | 594400.0 |
| 2002-07-19 12:35:00 | SPY | ETF | 86.25 | 86.27 | 86.01 | 86.07 | 694100.0 |
| 2002-07-19 12:40:00 | SPY | ETF | 86.08 | 86.2 | 86.01 | 86.2 | 469500.0 |
| 2002-07-19 12:45:00 | SPY | ETF | 86.21 | 86.4 | 86.12 | 86.12 | 350000.0 |
| 2002-07-19 12:50:00 | SPY | ETF | 86.18 | 86.22 | 86.06 | 86.22 | 416500.0 |
| 2002-07-19 12:55:00 | SPY | ETF | 86.23 | 86.28 | 86.0 | 86.07 | 784000.0 |
| 2002-07-19 13:00:00 | SPY | ETF | 86.1 | 86.27 | 86.0 | 86.18 | 579600.0 |
| 2002-07-19 13:05:00 | SPY | ETF | 86.2 | 86.3 | 86.11 | 86.17 | 208000.0 |
| 2002-07-19 13:10:00 | SPY | ETF | 86.2 | 86.25 | 85.98 | 86.05 | 996600.0 |
| 2002-07-19 13:15:00 | SPY | ETF | 86.14 | 86.14 | 85.84 | 85.95 | 717400.0 |
| 2002-07-19 13:20:00 | SPY | ETF | 85.92 | 86.05 | 85.87 | 86.0 | 273000.0 |
| 2002-07-19 13:25:00 | SPY | ETF | 86.02 | 86.17 | 85.98 | 85.98 | 486500.0 |
| 2002-07-19 13:30:00 | SPY | ETF | 86.05 | 86.32 | 85.97 | 86.28 | 670500.0 |
| 2002-07-19 13:35:00 | SPY | ETF | 86.31 | 86.48 | 86.22 | 86.28 | 417700.0 |
> showing 50 of 2,079 rows — these rows as CSV