PREVIEW / etf_5min / 2001-08-31
file: by_date/etf_5min/2001/2001-08-31.parquet size: 31 KB rows: 1,227
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-31 09:30:00 | SPY | ETF | 113.4 | 113.6 | 113.34 | 113.5 | 560700.0 |
| 2001-08-31 09:35:00 | SPY | ETF | 113.48 | 113.56 | 113.29 | 113.32 | 187300.0 |
| 2001-08-31 09:40:00 | SPY | ETF | 113.3 | 113.46 | 113.25 | 113.46 | 527400.0 |
| 2001-08-31 09:45:00 | SPY | ETF | 113.44 | 113.56 | 113.2 | 113.21 | 253300.0 |
| 2001-08-31 09:50:00 | SPY | ETF | 113.22 | 113.4 | 113.13 | 113.39 | 402000.0 |
| 2001-08-31 09:55:00 | SPY | ETF | 113.37 | 113.5 | 113.28 | 113.4 | 262400.0 |
| 2001-08-31 10:00:00 | SPY | ETF | 113.4 | 114.3 | 113.4 | 114.08 | 1237500.0 |
| 2001-08-31 10:05:00 | SPY | ETF | 114.08 | 114.28 | 114.0 | 114.18 | 519900.0 |
| 2001-08-31 10:10:00 | SPY | ETF | 114.2 | 114.22 | 114.06 | 114.1 | 364400.0 |
| 2001-08-31 10:15:00 | SPY | ETF | 114.18 | 114.77 | 114.18 | 114.77 | 491200.0 |
| 2001-08-31 10:20:00 | SPY | ETF | 114.77 | 114.77 | 114.53 | 114.6 | 607800.0 |
| 2001-08-31 10:25:00 | SPY | ETF | 114.59 | 114.6 | 114.4 | 114.4 | 202800.0 |
| 2001-08-31 10:30:00 | SPY | ETF | 114.4 | 114.43 | 114.32 | 114.42 | 125000.0 |
| 2001-08-31 10:35:00 | SPY | ETF | 114.44 | 114.45 | 114.2 | 114.25 | 169800.0 |
| 2001-08-31 10:40:00 | SPY | ETF | 114.26 | 114.28 | 114.1 | 114.19 | 130400.0 |
| 2001-08-31 10:45:00 | SPY | ETF | 114.2 | 114.2 | 113.98 | 114.13 | 90400.0 |
| 2001-08-31 10:50:00 | SPY | ETF | 114.15 | 114.25 | 114.1 | 114.17 | 121800.0 |
| 2001-08-31 10:55:00 | SPY | ETF | 114.16 | 114.16 | 113.87 | 113.89 | 126800.0 |
| 2001-08-31 11:00:00 | SPY | ETF | 113.86 | 113.9 | 113.75 | 113.84 | 203200.0 |
| 2001-08-31 11:05:00 | SPY | ETF | 113.81 | 113.92 | 113.68 | 113.7 | 159800.0 |
| 2001-08-31 11:10:00 | SPY | ETF | 113.68 | 113.82 | 113.65 | 113.65 | 80600.0 |
| 2001-08-31 11:15:00 | SPY | ETF | 113.67 | 113.75 | 113.63 | 113.7 | 136500.0 |
| 2001-08-31 11:20:00 | SPY | ETF | 113.73 | 113.83 | 113.7 | 113.83 | 75500.0 |
| 2001-08-31 11:25:00 | SPY | ETF | 113.86 | 113.92 | 113.83 | 113.9 | 134800.0 |
| 2001-08-31 11:30:00 | SPY | ETF | 113.91 | 113.91 | 113.71 | 113.74 | 272700.0 |
| 2001-08-31 11:35:00 | SPY | ETF | 113.8 | 113.89 | 113.79 | 113.87 | 190500.0 |
| 2001-08-31 11:40:00 | SPY | ETF | 113.89 | 113.92 | 113.79 | 113.89 | 49300.0 |
| 2001-08-31 11:45:00 | SPY | ETF | 113.84 | 113.84 | 113.74 | 113.74 | 204100.0 |
| 2001-08-31 11:50:00 | SPY | ETF | 113.74 | 113.79 | 113.67 | 113.7 | 135000.0 |
| 2001-08-31 11:55:00 | SPY | ETF | 113.68 | 113.69 | 113.35 | 113.37 | 112800.0 |
| 2001-08-31 12:00:00 | SPY | ETF | 113.41 | 113.42 | 113.2 | 113.3 | 310600.0 |
| 2001-08-31 12:05:00 | SPY | ETF | 113.29 | 113.44 | 113.29 | 113.44 | 232700.0 |
| 2001-08-31 12:10:00 | SPY | ETF | 113.42 | 113.42 | 113.29 | 113.38 | 129100.0 |
| 2001-08-31 12:15:00 | SPY | ETF | 113.41 | 113.65 | 113.37 | 113.61 | 91100.0 |
| 2001-08-31 12:20:00 | SPY | ETF | 113.59 | 113.78 | 113.59 | 113.64 | 97800.0 |
| 2001-08-31 12:25:00 | SPY | ETF | 113.63 | 113.73 | 113.6 | 113.73 | 45600.0 |
| 2001-08-31 12:30:00 | SPY | ETF | 113.74 | 113.74 | 113.63 | 113.72 | 78400.0 |
| 2001-08-31 12:35:00 | SPY | ETF | 113.71 | 113.76 | 113.64 | 113.64 | 64100.0 |
| 2001-08-31 12:40:00 | SPY | ETF | 113.68 | 113.89 | 113.64 | 113.89 | 118500.0 |
| 2001-08-31 12:45:00 | SPY | ETF | 113.88 | 114.04 | 113.87 | 113.99 | 175200.0 |
| 2001-08-31 12:50:00 | SPY | ETF | 114.02 | 114.11 | 113.96 | 114.01 | 146000.0 |
| 2001-08-31 12:55:00 | SPY | ETF | 114.01 | 114.05 | 113.91 | 113.91 | 100200.0 |
| 2001-08-31 13:00:00 | SPY | ETF | 113.95 | 114.06 | 113.93 | 113.97 | 104500.0 |
| 2001-08-31 13:05:00 | SPY | ETF | 113.97 | 114.01 | 113.85 | 113.89 | 373900.0 |
| 2001-08-31 13:10:00 | SPY | ETF | 113.85 | 113.98 | 113.84 | 113.98 | 38400.0 |
| 2001-08-31 13:15:00 | SPY | ETF | 114.02 | 114.21 | 113.97 | 114.21 | 20400.0 |
| 2001-08-31 13:20:00 | SPY | ETF | 114.22 | 114.24 | 114.14 | 114.24 | 128200.0 |
| 2001-08-31 13:25:00 | SPY | ETF | 114.24 | 114.29 | 114.16 | 114.17 | 134300.0 |
| 2001-08-31 13:30:00 | SPY | ETF | 114.15 | 114.2 | 114.08 | 114.08 | 26300.0 |
| 2001-08-31 13:35:00 | SPY | ETF | 114.05 | 114.11 | 114.02 | 114.11 | 31700.0 |
> showing 50 of 1,227 rows — these rows as CSV