PREVIEW / etf_5min / 2001-08-20
file: by_date/etf_5min/2001/2001-08-20.parquet size: 29 KB rows: 1,170
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-20 09:30:00 | SPY | ETF | 116.8 | 116.9 | 116.71 | 116.85 | 275600.0 |
| 2001-08-20 09:35:00 | SPY | ETF | 116.9 | 116.92 | 116.76 | 116.82 | 341100.0 |
| 2001-08-20 09:40:00 | SPY | ETF | 116.83 | 116.95 | 116.66 | 116.7 | 178100.0 |
| 2001-08-20 09:45:00 | SPY | ETF | 116.67 | 116.94 | 116.67 | 116.92 | 452500.0 |
| 2001-08-20 09:50:00 | SPY | ETF | 116.9 | 117.0 | 116.83 | 116.87 | 127100.0 |
| 2001-08-20 09:55:00 | SPY | ETF | 116.88 | 116.88 | 116.65 | 116.68 | 106800.0 |
| 2001-08-20 10:00:00 | SPY | ETF | 116.7 | 116.73 | 116.55 | 116.66 | 133000.0 |
| 2001-08-20 10:05:00 | SPY | ETF | 116.62 | 116.75 | 116.61 | 116.64 | 105900.0 |
| 2001-08-20 10:10:00 | SPY | ETF | 116.67 | 116.86 | 116.58 | 116.81 | 125900.0 |
| 2001-08-20 10:15:00 | SPY | ETF | 116.78 | 116.95 | 116.78 | 116.84 | 164800.0 |
| 2001-08-20 10:20:00 | SPY | ETF | 116.82 | 117.05 | 116.82 | 116.95 | 129000.0 |
| 2001-08-20 10:25:00 | SPY | ETF | 116.96 | 117.14 | 116.9 | 117.04 | 72700.0 |
| 2001-08-20 10:30:00 | SPY | ETF | 117.04 | 117.04 | 116.85 | 116.87 | 67100.0 |
| 2001-08-20 10:35:00 | SPY | ETF | 116.87 | 117.1 | 116.86 | 117.09 | 210800.0 |
| 2001-08-20 10:40:00 | SPY | ETF | 117.09 | 117.37 | 117.07 | 117.33 | 202200.0 |
| 2001-08-20 10:45:00 | SPY | ETF | 117.32 | 117.42 | 117.3 | 117.39 | 189500.0 |
| 2001-08-20 10:50:00 | SPY | ETF | 117.38 | 117.52 | 117.35 | 117.35 | 321400.0 |
| 2001-08-20 10:55:00 | SPY | ETF | 117.35 | 117.38 | 117.28 | 117.32 | 92000.0 |
| 2001-08-20 11:00:00 | SPY | ETF | 117.28 | 117.42 | 117.28 | 117.3 | 101000.0 |
| 2001-08-20 11:05:00 | SPY | ETF | 117.32 | 117.36 | 117.22 | 117.31 | 58000.0 |
| 2001-08-20 11:10:00 | SPY | ETF | 117.31 | 117.33 | 117.2 | 117.24 | 28700.0 |
| 2001-08-20 11:15:00 | SPY | ETF | 117.22 | 117.25 | 117.12 | 117.18 | 90600.0 |
| 2001-08-20 11:20:00 | SPY | ETF | 117.15 | 117.27 | 117.15 | 117.27 | 48900.0 |
| 2001-08-20 11:25:00 | SPY | ETF | 117.23 | 117.23 | 117.1 | 117.11 | 27000.0 |
| 2001-08-20 11:30:00 | SPY | ETF | 117.15 | 117.21 | 117.13 | 117.18 | 50600.0 |
| 2001-08-20 11:35:00 | SPY | ETF | 117.17 | 117.28 | 117.14 | 117.24 | 61800.0 |
| 2001-08-20 11:40:00 | SPY | ETF | 117.25 | 117.31 | 117.23 | 117.26 | 47300.0 |
| 2001-08-20 11:45:00 | SPY | ETF | 117.29 | 117.33 | 117.24 | 117.24 | 20900.0 |
| 2001-08-20 11:50:00 | SPY | ETF | 117.23 | 117.24 | 117.17 | 117.18 | 59900.0 |
| 2001-08-20 11:55:00 | SPY | ETF | 117.15 | 117.25 | 117.15 | 117.24 | 10200.0 |
| 2001-08-20 12:00:00 | SPY | ETF | 117.24 | 117.38 | 117.21 | 117.37 | 103600.0 |
| 2001-08-20 12:05:00 | SPY | ETF | 117.36 | 117.37 | 117.32 | 117.34 | 30900.0 |
| 2001-08-20 12:10:00 | SPY | ETF | 117.34 | 117.4 | 117.32 | 117.4 | 84900.0 |
| 2001-08-20 12:15:00 | SPY | ETF | 117.4 | 117.4 | 117.25 | 117.29 | 40000.0 |
| 2001-08-20 12:20:00 | SPY | ETF | 117.29 | 117.3 | 117.17 | 117.18 | 15900.0 |
| 2001-08-20 12:25:00 | SPY | ETF | 117.19 | 117.19 | 117.14 | 117.16 | 48400.0 |
| 2001-08-20 12:30:00 | SPY | ETF | 117.12 | 117.13 | 117.02 | 117.08 | 49500.0 |
| 2001-08-20 12:35:00 | SPY | ETF | 117.09 | 117.1 | 117.06 | 117.06 | 9500.0 |
| 2001-08-20 12:40:00 | SPY | ETF | 117.09 | 117.12 | 117.07 | 117.09 | 24700.0 |
| 2001-08-20 12:45:00 | SPY | ETF | 117.12 | 117.17 | 117.11 | 117.13 | 40800.0 |
| 2001-08-20 12:50:00 | SPY | ETF | 117.13 | 117.18 | 117.06 | 117.06 | 35100.0 |
| 2001-08-20 12:55:00 | SPY | ETF | 117.06 | 117.06 | 116.94 | 116.94 | 57700.0 |
| 2001-08-20 13:00:00 | SPY | ETF | 116.98 | 116.98 | 116.92 | 116.96 | 134500.0 |
| 2001-08-20 13:05:00 | SPY | ETF | 116.95 | 117.04 | 116.95 | 116.98 | 25600.0 |
| 2001-08-20 13:10:00 | SPY | ETF | 116.98 | 117.1 | 116.98 | 117.08 | 86300.0 |
| 2001-08-20 13:15:00 | SPY | ETF | 117.1 | 117.1 | 117.09 | 117.1 | 76600.0 |
| 2001-08-20 13:20:00 | SPY | ETF | 117.09 | 117.2 | 117.05 | 117.2 | 50800.0 |
| 2001-08-20 13:25:00 | SPY | ETF | 117.19 | 117.21 | 117.09 | 117.11 | 1306300.0 |
| 2001-08-20 13:30:00 | SPY | ETF | 117.11 | 117.11 | 116.85 | 116.96 | 221300.0 |
| 2001-08-20 13:35:00 | SPY | ETF | 116.99 | 117.03 | 116.93 | 117.03 | 17300.0 |
> showing 50 of 1,170 rows — these rows as CSV