PREVIEW / etf_5min / 2007-03-02
file: by_date/etf_5min/2007/2007-03-02.parquet size: 333 KB rows: 14,339
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-02 04:55:00 | SPY | ETF | 140.67 | 140.67 | 140.55 | 140.55 | 29600.0 |
| 2007-03-02 05:05:00 | SPY | ETF | 140.79 | 140.79 | 140.79 | 140.79 | 15000.0 |
| 2007-03-02 05:10:00 | SPY | ETF | 140.74 | 140.74 | 140.74 | 140.74 | 3700.0 |
| 2007-03-02 05:15:00 | SPY | ETF | 140.74 | 140.83 | 140.74 | 140.83 | 11200.0 |
| 2007-03-02 05:55:00 | SPY | ETF | 140.68 | 140.68 | 140.65 | 140.65 | 14900.0 |
| 2007-03-02 06:00:00 | SPY | ETF | 140.63 | 140.63 | 140.63 | 140.63 | 2900.0 |
| 2007-03-02 06:05:00 | SPY | ETF | 140.53 | 140.54 | 140.53 | 140.54 | 15900.0 |
| 2007-03-02 06:15:00 | SPY | ETF | 140.58 | 140.58 | 140.58 | 140.58 | 8000.0 |
| 2007-03-02 06:30:00 | SPY | ETF | 140.65 | 140.65 | 140.65 | 140.65 | 1000.0 |
| 2007-03-02 06:40:00 | SPY | ETF | 140.51 | 140.51 | 140.5 | 140.5 | 6000.0 |
| 2007-03-02 06:50:00 | SPY | ETF | 140.54 | 140.54 | 140.51 | 140.51 | 5900.0 |
| 2007-03-02 06:55:00 | SPY | ETF | 140.09 | 140.23 | 140.09 | 140.16 | 23400.0 |
| 2007-03-02 07:00:00 | SPY | ETF | 140.16 | 140.16 | 140.0 | 140.0 | 59200.0 |
| 2007-03-02 07:05:00 | SPY | ETF | 140.02 | 140.17 | 139.97 | 140.13 | 32400.0 |
| 2007-03-02 07:10:00 | SPY | ETF | 140.08 | 140.08 | 139.8 | 139.83 | 121900.0 |
| 2007-03-02 07:15:00 | SPY | ETF | 139.89 | 140.01 | 139.89 | 139.95 | 12600.0 |
| 2007-03-02 07:20:00 | SPY | ETF | 140.0 | 140.13 | 140.0 | 140.02 | 87600.0 |
| 2007-03-02 07:25:00 | SPY | ETF | 140.01 | 140.06 | 139.97 | 140.02 | 369800.0 |
| 2007-03-02 07:30:00 | SPY | ETF | 140.09 | 140.17 | 140.07 | 140.17 | 137000.0 |
| 2007-03-02 07:35:00 | SPY | ETF | 140.2 | 140.41 | 140.16 | 140.31 | 343700.0 |
| 2007-03-02 07:40:00 | SPY | ETF | 140.33 | 140.34 | 140.16 | 140.17 | 89500.0 |
| 2007-03-02 07:45:00 | SPY | ETF | 140.22 | 140.23 | 140.14 | 140.14 | 182400.0 |
| 2007-03-02 07:50:00 | SPY | ETF | 140.15 | 140.25 | 140.14 | 140.25 | 26600.0 |
| 2007-03-02 07:55:00 | SPY | ETF | 140.22 | 140.25 | 140.15 | 140.17 | 52400.0 |
| 2007-03-02 08:00:00 | SPY | ETF | 140.16 | 140.4 | 139.98 | 140.19 | 1443800.0 |
| 2007-03-02 08:05:00 | SPY | ETF | 140.15 | 140.18 | 139.93 | 139.93 | 658800.0 |
| 2007-03-02 08:10:00 | SPY | ETF | 139.93 | 140.04 | 139.72 | 140.0 | 673500.0 |
| 2007-03-02 08:15:00 | SPY | ETF | 139.97 | 140.06 | 139.66 | 139.68 | 964300.0 |
| 2007-03-02 08:20:00 | SPY | ETF | 139.94 | 139.94 | 139.48 | 139.59 | 1869900.0 |
| 2007-03-02 08:25:00 | SPY | ETF | 139.63 | 139.99 | 139.52 | 139.67 | 1527900.0 |
| 2007-03-02 08:30:00 | SPY | ETF | 139.7 | 139.86 | 139.55 | 139.8 | 601400.0 |
| 2007-03-02 08:35:00 | SPY | ETF | 139.81 | 140.6 | 139.8 | 139.86 | 223200.0 |
| 2007-03-02 08:40:00 | SPY | ETF | 139.85 | 139.92 | 139.72 | 139.72 | 586700.0 |
| 2007-03-02 08:45:00 | SPY | ETF | 139.71 | 139.82 | 139.69 | 139.78 | 374800.0 |
| 2007-03-02 08:50:00 | SPY | ETF | 139.78 | 139.88 | 139.76 | 139.84 | 145800.0 |
| 2007-03-02 08:55:00 | SPY | ETF | 139.85 | 139.9 | 139.81 | 139.9 | 107800.0 |
| 2007-03-02 09:00:00 | SPY | ETF | 139.87 | 139.98 | 139.87 | 139.95 | 339500.0 |
| 2007-03-02 09:05:00 | SPY | ETF | 139.95 | 140.0 | 139.95 | 139.95 | 53400.0 |
| 2007-03-02 09:10:00 | SPY | ETF | 139.95 | 140.07 | 139.92 | 140.06 | 270600.0 |
| 2007-03-02 09:15:00 | SPY | ETF | 140.06 | 140.08 | 139.95 | 140.0 | 442400.0 |
| 2007-03-02 09:20:00 | SPY | ETF | 140.04 | 140.13 | 140.02 | 140.13 | 68100.0 |
| 2007-03-02 09:25:00 | SPY | ETF | 140.11 | 140.15 | 139.98 | 140.04 | 307600.0 |
| 2007-03-02 09:30:00 | SPY | ETF | 140.05 | 140.26 | 139.92 | 139.97 | 2278500.0 |
| 2007-03-02 09:35:00 | SPY | ETF | 139.97 | 140.24 | 139.84 | 140.03 | 2726100.0 |
| 2007-03-02 09:40:00 | SPY | ETF | 140.05 | 140.45 | 139.97 | 140.23 | 2214900.0 |
| 2007-03-02 09:45:00 | SPY | ETF | 140.23 | 140.31 | 140.06 | 140.14 | 2795900.0 |
| 2007-03-02 09:50:00 | SPY | ETF | 140.16 | 140.34 | 139.99 | 140.09 | 1759700.0 |
| 2007-03-02 09:55:00 | SPY | ETF | 140.09 | 140.11 | 139.94 | 140.08 | 1899000.0 |
| 2007-03-02 10:00:00 | SPY | ETF | 140.07 | 140.48 | 139.84 | 140.24 | 2788900.0 |
| 2007-03-02 10:05:00 | SPY | ETF | 140.24 | 140.3 | 140.08 | 140.14 | 1171700.0 |
> showing 50 of 14,339 rows — these rows as CSV