PREVIEW / etf_5min / 2002-01-07
file: by_date/etf_5min/2002/2002-01-07.parquet size: 42 KB rows: 1,746
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-01-07 09:30:00 | SPY | ETF | 117.7 | 117.85 | 117.63 | 117.85 | 829000.0 |
| 2002-01-07 09:35:00 | SPY | ETF | 117.83 | 117.99 | 117.78 | 117.81 | 255400.0 |
| 2002-01-07 09:40:00 | SPY | ETF | 117.83 | 117.88 | 117.7 | 117.78 | 274900.0 |
| 2002-01-07 09:45:00 | SPY | ETF | 117.78 | 117.89 | 117.72 | 117.85 | 165400.0 |
| 2002-01-07 09:50:00 | SPY | ETF | 117.86 | 117.88 | 117.64 | 117.71 | 306600.0 |
| 2002-01-07 09:55:00 | SPY | ETF | 117.75 | 117.78 | 117.47 | 117.51 | 308500.0 |
| 2002-01-07 10:00:00 | SPY | ETF | 117.5 | 117.58 | 117.32 | 117.37 | 383200.0 |
| 2002-01-07 10:05:00 | SPY | ETF | 117.4 | 117.55 | 117.38 | 117.55 | 179100.0 |
| 2002-01-07 10:10:00 | SPY | ETF | 117.55 | 117.59 | 117.45 | 117.54 | 113900.0 |
| 2002-01-07 10:15:00 | SPY | ETF | 117.55 | 117.68 | 117.54 | 117.6 | 101000.0 |
| 2002-01-07 10:20:00 | SPY | ETF | 117.58 | 117.7 | 117.47 | 117.66 | 182200.0 |
| 2002-01-07 10:25:00 | SPY | ETF | 117.69 | 117.9 | 117.64 | 117.74 | 124100.0 |
| 2002-01-07 10:30:00 | SPY | ETF | 117.74 | 117.83 | 117.67 | 117.83 | 86900.0 |
| 2002-01-07 10:35:00 | SPY | ETF | 117.8 | 117.81 | 117.59 | 117.61 | 66400.0 |
| 2002-01-07 10:40:00 | SPY | ETF | 117.59 | 117.72 | 117.55 | 117.7 | 134700.0 |
| 2002-01-07 10:45:00 | SPY | ETF | 117.66 | 117.81 | 117.64 | 117.68 | 48700.0 |
| 2002-01-07 10:50:00 | SPY | ETF | 117.72 | 117.75 | 117.48 | 117.55 | 57200.0 |
| 2002-01-07 10:55:00 | SPY | ETF | 117.54 | 117.59 | 117.4 | 117.51 | 275000.0 |
| 2002-01-07 11:00:00 | SPY | ETF | 117.45 | 117.48 | 117.3 | 117.46 | 86300.0 |
| 2002-01-07 11:05:00 | SPY | ETF | 117.46 | 117.53 | 117.35 | 117.49 | 77900.0 |
| 2002-01-07 11:10:00 | SPY | ETF | 117.47 | 117.53 | 117.36 | 117.4 | 166900.0 |
| 2002-01-07 11:15:00 | SPY | ETF | 117.39 | 117.39 | 117.15 | 117.18 | 168400.0 |
| 2002-01-07 11:20:00 | SPY | ETF | 117.17 | 117.23 | 117.12 | 117.2 | 262700.0 |
| 2002-01-07 11:25:00 | SPY | ETF | 117.22 | 117.24 | 117.06 | 117.23 | 101100.0 |
| 2002-01-07 11:30:00 | SPY | ETF | 117.24 | 117.28 | 117.16 | 117.17 | 252400.0 |
| 2002-01-07 11:35:00 | SPY | ETF | 117.22 | 117.29 | 117.15 | 117.19 | 110400.0 |
| 2002-01-07 11:40:00 | SPY | ETF | 117.17 | 117.19 | 117.08 | 117.1 | 82700.0 |
| 2002-01-07 11:45:00 | SPY | ETF | 117.13 | 117.14 | 116.98 | 117.0 | 199200.0 |
| 2002-01-07 11:50:00 | SPY | ETF | 117.03 | 117.06 | 116.85 | 116.9 | 95100.0 |
| 2002-01-07 11:55:00 | SPY | ETF | 116.95 | 116.99 | 116.87 | 116.94 | 337500.0 |
| 2002-01-07 12:00:00 | SPY | ETF | 116.93 | 117.03 | 116.92 | 116.98 | 144300.0 |
| 2002-01-07 12:05:00 | SPY | ETF | 117.0 | 117.06 | 116.95 | 116.97 | 102200.0 |
| 2002-01-07 12:10:00 | SPY | ETF | 117.0 | 117.04 | 116.92 | 117.04 | 50000.0 |
| 2002-01-07 12:15:00 | SPY | ETF | 117.04 | 117.05 | 116.9 | 116.91 | 74800.0 |
| 2002-01-07 12:20:00 | SPY | ETF | 116.91 | 116.99 | 116.91 | 116.93 | 61900.0 |
| 2002-01-07 12:25:00 | SPY | ETF | 116.93 | 117.02 | 116.85 | 117.0 | 89100.0 |
| 2002-01-07 12:30:00 | SPY | ETF | 117.04 | 117.16 | 116.99 | 117.13 | 130300.0 |
| 2002-01-07 12:35:00 | SPY | ETF | 117.15 | 117.22 | 117.12 | 117.18 | 122800.0 |
| 2002-01-07 12:40:00 | SPY | ETF | 117.18 | 117.21 | 117.14 | 117.15 | 87300.0 |
| 2002-01-07 12:45:00 | SPY | ETF | 117.16 | 117.16 | 117.09 | 117.13 | 43900.0 |
| 2002-01-07 12:50:00 | SPY | ETF | 117.13 | 117.13 | 117.01 | 117.06 | 50000.0 |
| 2002-01-07 12:55:00 | SPY | ETF | 117.06 | 117.13 | 117.02 | 117.11 | 36300.0 |
| 2002-01-07 13:00:00 | SPY | ETF | 117.12 | 117.12 | 116.88 | 117.01 | 40500.0 |
| 2002-01-07 13:05:00 | SPY | ETF | 117.04 | 117.05 | 116.97 | 117.0 | 12300.0 |
| 2002-01-07 13:10:00 | SPY | ETF | 117.0 | 117.03 | 116.93 | 117.02 | 28800.0 |
| 2002-01-07 13:15:00 | SPY | ETF | 117.04 | 117.13 | 117.0 | 117.13 | 44100.0 |
| 2002-01-07 13:20:00 | SPY | ETF | 117.08 | 117.21 | 117.08 | 117.17 | 88800.0 |
| 2002-01-07 13:25:00 | SPY | ETF | 117.18 | 117.28 | 117.14 | 117.15 | 91800.0 |
| 2002-01-07 13:30:00 | SPY | ETF | 117.14 | 117.27 | 117.12 | 117.25 | 54500.0 |
| 2002-01-07 13:35:00 | SPY | ETF | 117.22 | 117.24 | 117.1 | 117.11 | 43800.0 |
> showing 50 of 1,746 rows — these rows as CSV