PREVIEW / etf_5min / 2001-08-10
file: by_date/etf_5min/2001/2001-08-10.parquet size: 31 KB rows: 1,171
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-10 09:30:00 | SPY | ETF | 118.8 | 118.82 | 118.6 | 118.8 | 262500.0 |
| 2001-08-10 09:35:00 | SPY | ETF | 118.83 | 118.87 | 118.72 | 118.82 | 176600.0 |
| 2001-08-10 09:40:00 | SPY | ETF | 118.82 | 118.84 | 118.57 | 118.7 | 133300.0 |
| 2001-08-10 09:45:00 | SPY | ETF | 118.71 | 118.71 | 118.56 | 118.67 | 182800.0 |
| 2001-08-10 09:50:00 | SPY | ETF | 118.67 | 118.69 | 118.49 | 118.6 | 214100.0 |
| 2001-08-10 09:55:00 | SPY | ETF | 118.55 | 118.6 | 118.43 | 118.58 | 198900.0 |
| 2001-08-10 10:00:00 | SPY | ETF | 118.55 | 118.63 | 118.39 | 118.45 | 64500.0 |
| 2001-08-10 10:05:00 | SPY | ETF | 118.43 | 118.44 | 118.24 | 118.32 | 251700.0 |
| 2001-08-10 10:10:00 | SPY | ETF | 118.29 | 118.34 | 118.08 | 118.1 | 137100.0 |
| 2001-08-10 10:15:00 | SPY | ETF | 118.1 | 118.1 | 117.41 | 117.42 | 309500.0 |
| 2001-08-10 10:20:00 | SPY | ETF | 117.4 | 117.59 | 117.34 | 117.55 | 239400.0 |
| 2001-08-10 10:25:00 | SPY | ETF | 117.55 | 117.74 | 117.55 | 117.68 | 217800.0 |
| 2001-08-10 10:30:00 | SPY | ETF | 117.7 | 117.78 | 117.62 | 117.75 | 196500.0 |
| 2001-08-10 10:35:00 | SPY | ETF | 117.79 | 117.85 | 117.67 | 117.68 | 139500.0 |
| 2001-08-10 10:40:00 | SPY | ETF | 117.68 | 117.79 | 117.65 | 117.72 | 116000.0 |
| 2001-08-10 10:45:00 | SPY | ETF | 117.68 | 117.8 | 117.68 | 117.79 | 60600.0 |
| 2001-08-10 10:50:00 | SPY | ETF | 117.74 | 117.78 | 117.65 | 117.75 | 62100.0 |
| 2001-08-10 10:55:00 | SPY | ETF | 117.76 | 117.78 | 117.67 | 117.73 | 257500.0 |
| 2001-08-10 11:00:00 | SPY | ETF | 117.76 | 117.76 | 117.55 | 117.58 | 511200.0 |
| 2001-08-10 11:05:00 | SPY | ETF | 117.6 | 117.64 | 117.49 | 117.49 | 273300.0 |
| 2001-08-10 11:10:00 | SPY | ETF | 117.5 | 117.62 | 117.45 | 117.62 | 123400.0 |
| 2001-08-10 11:15:00 | SPY | ETF | 117.6 | 117.78 | 117.6 | 117.75 | 135400.0 |
| 2001-08-10 11:20:00 | SPY | ETF | 117.76 | 117.87 | 117.76 | 117.8 | 98400.0 |
| 2001-08-10 11:25:00 | SPY | ETF | 117.77 | 117.99 | 117.77 | 117.93 | 102000.0 |
| 2001-08-10 11:30:00 | SPY | ETF | 117.95 | 118.16 | 117.9 | 118.16 | 118900.0 |
| 2001-08-10 11:35:00 | SPY | ETF | 118.15 | 118.18 | 118.04 | 118.05 | 62200.0 |
| 2001-08-10 11:40:00 | SPY | ETF | 118.08 | 118.16 | 118.04 | 118.13 | 96600.0 |
| 2001-08-10 11:45:00 | SPY | ETF | 118.16 | 118.26 | 118.16 | 118.19 | 92400.0 |
| 2001-08-10 11:50:00 | SPY | ETF | 118.18 | 118.25 | 118.08 | 118.08 | 51700.0 |
| 2001-08-10 11:55:00 | SPY | ETF | 118.07 | 118.15 | 118.03 | 118.06 | 74300.0 |
| 2001-08-10 12:00:00 | SPY | ETF | 118.06 | 118.06 | 117.96 | 117.97 | 41900.0 |
| 2001-08-10 12:05:00 | SPY | ETF | 117.95 | 117.99 | 117.91 | 117.99 | 16100.0 |
| 2001-08-10 12:10:00 | SPY | ETF | 118.0 | 118.06 | 117.96 | 117.96 | 29900.0 |
| 2001-08-10 12:15:00 | SPY | ETF | 117.99 | 118.13 | 117.99 | 118.05 | 12700.0 |
| 2001-08-10 12:20:00 | SPY | ETF | 117.98 | 118.1 | 117.91 | 117.93 | 276300.0 |
| 2001-08-10 12:25:00 | SPY | ETF | 117.95 | 118.01 | 117.95 | 117.99 | 23000.0 |
| 2001-08-10 12:30:00 | SPY | ETF | 118.0 | 118.17 | 117.98 | 118.17 | 57200.0 |
| 2001-08-10 12:35:00 | SPY | ETF | 118.17 | 118.21 | 118.08 | 118.16 | 162200.0 |
| 2001-08-10 12:40:00 | SPY | ETF | 118.16 | 118.36 | 118.16 | 118.32 | 56600.0 |
| 2001-08-10 12:45:00 | SPY | ETF | 118.34 | 118.58 | 118.24 | 118.53 | 207000.0 |
| 2001-08-10 12:50:00 | SPY | ETF | 118.55 | 118.73 | 118.52 | 118.65 | 134200.0 |
| 2001-08-10 12:55:00 | SPY | ETF | 118.68 | 119.32 | 118.59 | 119.0 | 230500.0 |
| 2001-08-10 13:00:00 | SPY | ETF | 119.05 | 119.22 | 119.0 | 119.05 | 302500.0 |
| 2001-08-10 13:05:00 | SPY | ETF | 119.02 | 119.07 | 119.0 | 119.04 | 140100.0 |
| 2001-08-10 13:10:00 | SPY | ETF | 119.08 | 119.3 | 119.03 | 119.28 | 182400.0 |
| 2001-08-10 13:15:00 | SPY | ETF | 119.32 | 119.37 | 119.03 | 119.03 | 151900.0 |
| 2001-08-10 13:20:00 | SPY | ETF | 119.08 | 119.21 | 119.0 | 119.15 | 144900.0 |
| 2001-08-10 13:25:00 | SPY | ETF | 119.11 | 119.28 | 119.11 | 119.26 | 38200.0 |
| 2001-08-10 13:30:00 | SPY | ETF | 119.25 | 119.68 | 119.25 | 119.57 | 469200.0 |
| 2001-08-10 13:35:00 | SPY | ETF | 119.65 | 119.65 | 119.4 | 119.4 | 210400.0 |
> showing 50 of 1,171 rows — these rows as CSV