PREVIEW / etf_5min / 2001-07-02
file: by_date/etf_5min/2001/2001-07-02.parquet size: 30 KB rows: 1,183
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-07-02 09:30:00 | SPY | ETF | 122.8 | 122.99 | 122.66 | 122.76 | 392200.0 |
| 2001-07-02 09:35:00 | SPY | ETF | 122.72 | 122.87 | 122.62 | 122.75 | 290600.0 |
| 2001-07-02 09:40:00 | SPY | ETF | 122.72 | 122.87 | 122.66 | 122.83 | 289400.0 |
| 2001-07-02 09:45:00 | SPY | ETF | 122.83 | 122.99 | 122.8 | 122.97 | 55100.0 |
| 2001-07-02 09:50:00 | SPY | ETF | 122.94 | 123.04 | 122.73 | 122.73 | 256500.0 |
| 2001-07-02 09:55:00 | SPY | ETF | 122.73 | 122.86 | 122.66 | 122.8 | 57200.0 |
| 2001-07-02 10:00:00 | SPY | ETF | 122.86 | 123.19 | 122.78 | 123.1 | 152200.0 |
| 2001-07-02 10:05:00 | SPY | ETF | 123.1 | 123.2 | 122.93 | 123.08 | 103700.0 |
| 2001-07-02 10:10:00 | SPY | ETF | 123.19 | 123.38 | 123.09 | 123.35 | 200500.0 |
| 2001-07-02 10:15:00 | SPY | ETF | 123.28 | 123.59 | 123.28 | 123.42 | 414500.0 |
| 2001-07-02 10:20:00 | SPY | ETF | 123.4 | 123.53 | 123.35 | 123.43 | 41100.0 |
| 2001-07-02 10:25:00 | SPY | ETF | 123.39 | 123.39 | 123.27 | 123.3 | 61000.0 |
| 2001-07-02 10:30:00 | SPY | ETF | 123.38 | 123.54 | 123.32 | 123.46 | 57200.0 |
| 2001-07-02 10:35:00 | SPY | ETF | 123.47 | 123.5 | 123.28 | 123.36 | 30500.0 |
| 2001-07-02 10:40:00 | SPY | ETF | 123.4 | 123.44 | 123.22 | 123.28 | 67500.0 |
| 2001-07-02 10:45:00 | SPY | ETF | 123.23 | 123.42 | 123.18 | 123.42 | 35300.0 |
| 2001-07-02 10:50:00 | SPY | ETF | 123.4 | 123.42 | 123.28 | 123.31 | 25800.0 |
| 2001-07-02 10:55:00 | SPY | ETF | 123.35 | 123.57 | 123.35 | 123.47 | 62100.0 |
| 2001-07-02 11:00:00 | SPY | ETF | 123.46 | 123.74 | 123.4 | 123.6 | 314800.0 |
| 2001-07-02 11:05:00 | SPY | ETF | 123.75 | 123.78 | 123.62 | 123.78 | 71100.0 |
| 2001-07-02 11:10:00 | SPY | ETF | 123.72 | 123.95 | 123.72 | 123.9 | 66800.0 |
| 2001-07-02 11:15:00 | SPY | ETF | 123.93 | 124.09 | 123.78 | 124.08 | 60200.0 |
| 2001-07-02 11:20:00 | SPY | ETF | 123.98 | 124.04 | 123.83 | 123.83 | 83500.0 |
| 2001-07-02 11:25:00 | SPY | ETF | 123.9 | 124.13 | 123.9 | 123.96 | 101100.0 |
| 2001-07-02 11:30:00 | SPY | ETF | 124.03 | 124.08 | 123.96 | 124.04 | 77800.0 |
| 2001-07-02 11:35:00 | SPY | ETF | 124.05 | 124.09 | 123.94 | 124.0 | 22300.0 |
| 2001-07-02 11:40:00 | SPY | ETF | 124.0 | 124.14 | 123.98 | 124.09 | 42900.0 |
| 2001-07-02 11:45:00 | SPY | ETF | 124.1 | 124.1 | 123.91 | 124.04 | 178500.0 |
| 2001-07-02 11:50:00 | SPY | ETF | 124.05 | 124.29 | 124.04 | 124.24 | 247200.0 |
| 2001-07-02 11:55:00 | SPY | ETF | 124.2 | 124.32 | 124.16 | 124.26 | 296900.0 |
| 2001-07-02 12:00:00 | SPY | ETF | 124.23 | 124.25 | 124.06 | 124.15 | 87400.0 |
| 2001-07-02 12:05:00 | SPY | ETF | 124.19 | 124.21 | 124.06 | 124.12 | 53000.0 |
| 2001-07-02 12:10:00 | SPY | ETF | 124.14 | 124.18 | 124.0 | 124.0 | 23900.0 |
| 2001-07-02 12:15:00 | SPY | ETF | 124.07 | 124.16 | 124.0 | 124.12 | 71600.0 |
| 2001-07-02 12:20:00 | SPY | ETF | 124.07 | 124.1 | 123.96 | 123.96 | 103600.0 |
| 2001-07-02 12:25:00 | SPY | ETF | 124.0 | 124.02 | 123.91 | 123.96 | 56700.0 |
| 2001-07-02 12:30:00 | SPY | ETF | 123.98 | 124.01 | 123.93 | 123.98 | 12500.0 |
| 2001-07-02 12:35:00 | SPY | ETF | 124.01 | 124.11 | 124.01 | 124.04 | 15600.0 |
| 2001-07-02 12:40:00 | SPY | ETF | 123.97 | 123.98 | 123.83 | 123.83 | 74600.0 |
| 2001-07-02 12:45:00 | SPY | ETF | 123.9 | 123.98 | 123.84 | 123.84 | 45400.0 |
| 2001-07-02 12:50:00 | SPY | ETF | 123.86 | 123.96 | 123.83 | 123.89 | 78300.0 |
| 2001-07-02 12:55:00 | SPY | ETF | 123.85 | 123.88 | 123.75 | 123.8 | 51800.0 |
| 2001-07-02 13:00:00 | SPY | ETF | 123.88 | 123.98 | 123.84 | 123.95 | 17600.0 |
| 2001-07-02 13:05:00 | SPY | ETF | 123.98 | 124.05 | 123.95 | 124.03 | 10800.0 |
| 2001-07-02 13:10:00 | SPY | ETF | 124.04 | 124.11 | 124.0 | 124.11 | 10400.0 |
| 2001-07-02 13:15:00 | SPY | ETF | 124.11 | 124.18 | 123.96 | 123.98 | 17700.0 |
| 2001-07-02 13:20:00 | SPY | ETF | 123.98 | 124.13 | 123.95 | 124.13 | 22500.0 |
| 2001-07-02 13:25:00 | SPY | ETF | 124.13 | 124.13 | 123.98 | 124.1 | 11900.0 |
| 2001-07-02 13:30:00 | SPY | ETF | 124.14 | 124.2 | 124.11 | 124.15 | 37200.0 |
| 2001-07-02 13:35:00 | SPY | ETF | 124.19 | 124.25 | 124.11 | 124.11 | 49200.0 |
> showing 50 of 1,183 rows — these rows as CSV