PREVIEW / etf_5min / 2001-03-02
file: by_date/etf_5min/2001/2001-03-02.parquet size: 29 KB rows: 1,069
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-03-02 09:30:00 | SPY | ETF | 122.5 | 123.0 | 122.5 | 122.71 | 412000.0 |
| 2001-03-02 09:35:00 | SPY | ETF | 122.85 | 122.97 | 122.66 | 122.9 | 337100.0 |
| 2001-03-02 09:40:00 | SPY | ETF | 122.89 | 123.25 | 122.8 | 122.9 | 277200.0 |
| 2001-03-02 09:45:00 | SPY | ETF | 122.99 | 123.25 | 122.9 | 123.24 | 56500.0 |
| 2001-03-02 09:50:00 | SPY | ETF | 123.25 | 123.4 | 122.88 | 123.02 | 129200.0 |
| 2001-03-02 09:55:00 | SPY | ETF | 123.05 | 123.05 | 122.65 | 122.8 | 105500.0 |
| 2001-03-02 10:00:00 | SPY | ETF | 122.77 | 122.85 | 122.3 | 122.44 | 220200.0 |
| 2001-03-02 10:05:00 | SPY | ETF | 122.5 | 122.95 | 122.46 | 122.95 | 211000.0 |
| 2001-03-02 10:10:00 | SPY | ETF | 122.77 | 123.06 | 122.75 | 123.06 | 87100.0 |
| 2001-03-02 10:15:00 | SPY | ETF | 123.13 | 123.43 | 123.0 | 123.12 | 285700.0 |
| 2001-03-02 10:20:00 | SPY | ETF | 123.13 | 123.35 | 123.12 | 123.25 | 318700.0 |
| 2001-03-02 10:25:00 | SPY | ETF | 123.3 | 123.6 | 123.28 | 123.4 | 122800.0 |
| 2001-03-02 10:30:00 | SPY | ETF | 123.5 | 123.93 | 123.45 | 123.8 | 134000.0 |
| 2001-03-02 10:35:00 | SPY | ETF | 123.7 | 123.81 | 123.5 | 123.57 | 213700.0 |
| 2001-03-02 10:40:00 | SPY | ETF | 123.57 | 123.7 | 123.31 | 123.66 | 196500.0 |
| 2001-03-02 10:45:00 | SPY | ETF | 123.56 | 123.98 | 123.56 | 123.74 | 193400.0 |
| 2001-03-02 10:50:00 | SPY | ETF | 123.7 | 124.19 | 123.65 | 124.06 | 144100.0 |
| 2001-03-02 10:55:00 | SPY | ETF | 123.99 | 124.0 | 123.76 | 123.85 | 79900.0 |
| 2001-03-02 11:00:00 | SPY | ETF | 123.76 | 123.85 | 123.61 | 123.67 | 108300.0 |
| 2001-03-02 11:05:00 | SPY | ETF | 123.74 | 123.74 | 123.5 | 123.5 | 84800.0 |
| 2001-03-02 11:10:00 | SPY | ETF | 123.45 | 123.5 | 123.2 | 123.41 | 51700.0 |
| 2001-03-02 11:15:00 | SPY | ETF | 123.41 | 123.64 | 123.35 | 123.35 | 52100.0 |
| 2001-03-02 11:20:00 | SPY | ETF | 123.3 | 123.3 | 122.98 | 123.15 | 64600.0 |
| 2001-03-02 11:25:00 | SPY | ETF | 123.07 | 123.34 | 123.07 | 123.3 | 78800.0 |
| 2001-03-02 11:30:00 | SPY | ETF | 123.3 | 123.55 | 123.27 | 123.5 | 39000.0 |
| 2001-03-02 11:35:00 | SPY | ETF | 123.49 | 123.85 | 123.4 | 123.64 | 40400.0 |
| 2001-03-02 11:40:00 | SPY | ETF | 123.6 | 123.7 | 123.38 | 123.38 | 25200.0 |
| 2001-03-02 11:45:00 | SPY | ETF | 123.48 | 123.72 | 123.41 | 123.72 | 7500.0 |
| 2001-03-02 11:50:00 | SPY | ETF | 123.72 | 123.92 | 123.61 | 123.81 | 102800.0 |
| 2001-03-02 11:55:00 | SPY | ETF | 123.83 | 123.83 | 123.65 | 123.75 | 30000.0 |
| 2001-03-02 12:00:00 | SPY | ETF | 123.75 | 124.0 | 123.7 | 123.98 | 121600.0 |
| 2001-03-02 12:05:00 | SPY | ETF | 124.0 | 124.38 | 124.0 | 124.2 | 94000.0 |
| 2001-03-02 12:10:00 | SPY | ETF | 124.21 | 124.44 | 124.2 | 124.25 | 357200.0 |
| 2001-03-02 12:15:00 | SPY | ETF | 124.1 | 124.67 | 124.1 | 124.61 | 110600.0 |
| 2001-03-02 12:20:00 | SPY | ETF | 124.66 | 125.05 | 124.64 | 125.0 | 476400.0 |
| 2001-03-02 12:25:00 | SPY | ETF | 124.93 | 125.0 | 124.66 | 124.72 | 75500.0 |
| 2001-03-02 12:30:00 | SPY | ETF | 124.66 | 124.73 | 124.53 | 124.65 | 402400.0 |
| 2001-03-02 12:35:00 | SPY | ETF | 124.59 | 124.78 | 124.46 | 124.62 | 324400.0 |
| 2001-03-02 12:40:00 | SPY | ETF | 124.7 | 124.77 | 124.4 | 124.48 | 66500.0 |
| 2001-03-02 12:45:00 | SPY | ETF | 124.55 | 124.7 | 124.4 | 124.7 | 72900.0 |
| 2001-03-02 12:50:00 | SPY | ETF | 124.69 | 124.81 | 124.48 | 124.48 | 46400.0 |
| 2001-03-02 12:55:00 | SPY | ETF | 124.49 | 124.68 | 124.46 | 124.65 | 24300.0 |
| 2001-03-02 13:00:00 | SPY | ETF | 124.65 | 124.9 | 124.58 | 124.9 | 400800.0 |
| 2001-03-02 13:05:00 | SPY | ETF | 124.9 | 125.25 | 124.86 | 125.25 | 321000.0 |
| 2001-03-02 13:10:00 | SPY | ETF | 125.24 | 125.25 | 125.06 | 125.16 | 198800.0 |
| 2001-03-02 13:15:00 | SPY | ETF | 125.16 | 125.2 | 125.0 | 125.0 | 29800.0 |
| 2001-03-02 13:20:00 | SPY | ETF | 125.01 | 125.14 | 124.91 | 124.91 | 15800.0 |
| 2001-03-02 13:25:00 | SPY | ETF | 125.0 | 125.15 | 124.9 | 125.07 | 24600.0 |
| 2001-03-02 13:30:00 | SPY | ETF | 125.16 | 125.65 | 125.16 | 125.65 | 293900.0 |
| 2001-03-02 13:35:00 | SPY | ETF | 125.64 | 125.65 | 125.45 | 125.45 | 395400.0 |
> showing 50 of 1,069 rows — these rows as CSV