PREVIEW / etf_5min / 2005-05-25
file: by_date/etf_5min/2005/2005-05-25.parquet size: 110 KB rows: 5,808
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-25 07:25:00 | SPY | ETF | 119.33 | 119.33 | 119.3 | 119.3 | 71900.0 |
| 2005-05-25 07:35:00 | SPY | ETF | 119.32 | 119.32 | 119.32 | 119.32 | 2500.0 |
| 2005-05-25 07:40:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 900.0 |
| 2005-05-25 07:45:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 500.0 |
| 2005-05-25 07:50:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 25000.0 |
| 2005-05-25 07:55:00 | SPY | ETF | 119.3 | 119.3 | 119.29 | 119.29 | 25100.0 |
| 2005-05-25 08:00:00 | SPY | ETF | 119.3 | 119.3 | 119.28 | 119.28 | 4900.0 |
| 2005-05-25 08:05:00 | SPY | ETF | 119.27 | 119.33 | 119.27 | 119.33 | 40900.0 |
| 2005-05-25 08:10:00 | SPY | ETF | 119.33 | 119.35 | 119.33 | 119.35 | 8700.0 |
| 2005-05-25 08:15:00 | SPY | ETF | 119.33 | 119.33 | 119.29 | 119.31 | 31200.0 |
| 2005-05-25 08:20:00 | SPY | ETF | 119.31 | 119.31 | 119.3 | 119.3 | 31800.0 |
| 2005-05-25 08:25:00 | SPY | ETF | 119.31 | 119.35 | 119.31 | 119.35 | 59300.0 |
| 2005-05-25 08:30:00 | SPY | ETF | 119.26 | 119.35 | 119.24 | 119.34 | 37400.0 |
| 2005-05-25 08:35:00 | SPY | ETF | 119.35 | 119.46 | 119.35 | 119.46 | 36300.0 |
| 2005-05-25 08:40:00 | SPY | ETF | 119.45 | 119.46 | 119.38 | 119.38 | 4700.0 |
| 2005-05-25 08:50:00 | SPY | ETF | 119.37 | 119.37 | 119.33 | 119.35 | 3500.0 |
| 2005-05-25 08:55:00 | SPY | ETF | 119.35 | 119.35 | 119.33 | 119.33 | 8100.0 |
| 2005-05-25 09:00:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 1100.0 |
| 2005-05-25 09:05:00 | SPY | ETF | 119.38 | 119.4 | 119.38 | 119.38 | 900.0 |
| 2005-05-25 09:10:00 | SPY | ETF | 119.4 | 119.41 | 119.38 | 119.41 | 9300.0 |
| 2005-05-25 09:15:00 | SPY | ETF | 119.41 | 119.43 | 119.4 | 119.4 | 15000.0 |
| 2005-05-25 09:20:00 | SPY | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 1100.0 |
| 2005-05-25 09:25:00 | SPY | ETF | 119.41 | 119.41 | 119.38 | 119.38 | 3800.0 |
| 2005-05-25 09:30:00 | SPY | ETF | 119.35 | 119.39 | 119.3 | 119.35 | 734600.0 |
| 2005-05-25 09:35:00 | SPY | ETF | 119.35 | 119.38 | 119.26 | 119.28 | 687800.0 |
| 2005-05-25 09:40:00 | SPY | ETF | 119.28 | 119.37 | 119.25 | 119.31 | 901500.0 |
| 2005-05-25 09:45:00 | SPY | ETF | 119.31 | 119.33 | 119.23 | 119.31 | 890500.0 |
| 2005-05-25 09:50:00 | SPY | ETF | 119.31 | 119.33 | 119.25 | 119.27 | 479300.0 |
| 2005-05-25 09:55:00 | SPY | ETF | 119.25 | 119.36 | 119.25 | 119.29 | 241700.0 |
| 2005-05-25 10:00:00 | SPY | ETF | 119.29 | 119.32 | 119.18 | 119.29 | 1619400.0 |
| 2005-05-25 10:05:00 | SPY | ETF | 119.29 | 119.33 | 119.19 | 119.23 | 613300.0 |
| 2005-05-25 10:10:00 | SPY | ETF | 119.23 | 119.34 | 119.1 | 119.13 | 1434100.0 |
| 2005-05-25 10:15:00 | SPY | ETF | 119.13 | 119.14 | 118.98 | 119.08 | 1239500.0 |
| 2005-05-25 10:20:00 | SPY | ETF | 119.07 | 119.07 | 119.01 | 119.03 | 764200.0 |
| 2005-05-25 10:25:00 | SPY | ETF | 119.04 | 119.14 | 119.04 | 119.12 | 990400.0 |
| 2005-05-25 10:30:00 | SPY | ETF | 119.12 | 119.13 | 118.97 | 119.0 | 2061000.0 |
| 2005-05-25 10:35:00 | SPY | ETF | 119.0 | 119.09 | 118.95 | 119.01 | 637600.0 |
| 2005-05-25 10:40:00 | SPY | ETF | 119.01 | 119.05 | 118.96 | 118.98 | 717000.0 |
| 2005-05-25 10:45:00 | SPY | ETF | 118.99 | 119.04 | 118.95 | 119.0 | 426000.0 |
| 2005-05-25 10:50:00 | SPY | ETF | 118.99 | 119.08 | 118.95 | 119.07 | 851300.0 |
| 2005-05-25 10:55:00 | SPY | ETF | 119.07 | 119.08 | 118.99 | 119.05 | 900400.0 |
| 2005-05-25 11:00:00 | SPY | ETF | 119.06 | 119.09 | 119.0 | 119.01 | 867600.0 |
| 2005-05-25 11:05:00 | SPY | ETF | 119.02 | 119.08 | 119.01 | 119.06 | 234100.0 |
| 2005-05-25 11:10:00 | SPY | ETF | 119.05 | 119.09 | 118.96 | 118.98 | 536800.0 |
| 2005-05-25 11:15:00 | SPY | ETF | 118.98 | 119.3 | 118.91 | 119.02 | 369700.0 |
| 2005-05-25 11:20:00 | SPY | ETF | 119.02 | 119.05 | 119.01 | 119.03 | 846900.0 |
| 2005-05-25 11:25:00 | SPY | ETF | 119.02 | 119.08 | 119.02 | 119.05 | 203800.0 |
| 2005-05-25 11:30:00 | SPY | ETF | 119.04 | 119.16 | 119.04 | 119.11 | 861500.0 |
| 2005-05-25 11:35:00 | SPY | ETF | 119.12 | 119.13 | 119.03 | 119.11 | 590500.0 |
| 2005-05-25 11:40:00 | SPY | ETF | 119.1 | 119.12 | 119.07 | 119.08 | 101400.0 |
> showing 50 of 5,808 rows — these rows as CSV