PREVIEW / etf_5min / 2007-07-25
file: by_date/etf_5min/2007/2007-07-25.parquet size: 381 KB rows: 18,317
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-07-25 04:05:00 | SPY | ETF | 151.52 | 151.52 | 151.52 | 151.52 | 1000.0 |
| 2007-07-25 04:10:00 | SPY | ETF | 151.58 | 151.62 | 151.58 | 151.62 | 5600.0 |
| 2007-07-25 04:20:00 | SPY | ETF | 151.43 | 151.43 | 151.41 | 151.41 | 6000.0 |
| 2007-07-25 04:25:00 | SPY | ETF | 151.37 | 151.37 | 151.37 | 151.37 | 2000.0 |
| 2007-07-25 04:35:00 | SPY | ETF | 151.45 | 151.45 | 151.45 | 151.45 | 1100.0 |
| 2007-07-25 04:50:00 | SPY | ETF | 151.58 | 151.61 | 151.58 | 151.61 | 2000.0 |
| 2007-07-25 05:25:00 | SPY | ETF | 151.52 | 151.52 | 151.52 | 151.52 | 2000.0 |
| 2007-07-25 05:35:00 | SPY | ETF | 151.66 | 151.66 | 151.66 | 151.66 | 2000.0 |
| 2007-07-25 05:40:00 | SPY | ETF | 151.66 | 151.68 | 151.66 | 151.68 | 2000.0 |
| 2007-07-25 06:10:00 | SPY | ETF | 151.68 | 151.68 | 151.68 | 151.68 | 1900.0 |
| 2007-07-25 06:40:00 | SPY | ETF | 151.86 | 151.86 | 151.86 | 151.86 | 400.0 |
| 2007-07-25 06:50:00 | SPY | ETF | 151.8 | 151.8 | 151.79 | 151.79 | 5000.0 |
| 2007-07-25 06:55:00 | SPY | ETF | 151.78 | 151.78 | 151.77 | 151.77 | 20000.0 |
| 2007-07-25 07:00:00 | SPY | ETF | 151.76 | 151.76 | 151.74 | 151.74 | 10000.0 |
| 2007-07-25 07:05:00 | SPY | ETF | 151.78 | 151.82 | 151.73 | 151.74 | 33500.0 |
| 2007-07-25 07:10:00 | SPY | ETF | 151.75 | 151.83 | 151.75 | 151.82 | 47600.0 |
| 2007-07-25 07:15:00 | SPY | ETF | 151.82 | 151.86 | 151.82 | 151.86 | 11100.0 |
| 2007-07-25 07:20:00 | SPY | ETF | 151.83 | 152.01 | 151.83 | 152.01 | 181400.0 |
| 2007-07-25 07:25:00 | SPY | ETF | 152.01 | 152.01 | 151.94 | 151.98 | 201000.0 |
| 2007-07-25 07:30:00 | SPY | ETF | 151.99 | 152.18 | 151.99 | 152.15 | 364700.0 |
| 2007-07-25 07:35:00 | SPY | ETF | 152.15 | 152.16 | 152.03 | 152.03 | 144000.0 |
| 2007-07-25 07:40:00 | SPY | ETF | 152.05 | 152.08 | 152.03 | 152.07 | 126500.0 |
| 2007-07-25 07:45:00 | SPY | ETF | 152.08 | 152.12 | 152.08 | 152.12 | 35800.0 |
| 2007-07-25 07:50:00 | SPY | ETF | 152.11 | 152.12 | 152.08 | 152.1 | 67100.0 |
| 2007-07-25 07:55:00 | SPY | ETF | 152.08 | 152.1 | 152.06 | 152.07 | 71900.0 |
| 2007-07-25 08:00:00 | SPY | ETF | 152.08 | 152.15 | 151.63 | 152.13 | 1106100.0 |
| 2007-07-25 08:05:00 | SPY | ETF | 152.15 | 152.17 | 151.7 | 152.15 | 1678500.0 |
| 2007-07-25 08:10:00 | SPY | ETF | 152.12 | 152.12 | 151.7 | 152.06 | 666600.0 |
| 2007-07-25 08:15:00 | SPY | ETF | 152.06 | 152.1 | 152.04 | 152.05 | 161600.0 |
| 2007-07-25 08:20:00 | SPY | ETF | 152.08 | 152.12 | 152.03 | 152.1 | 59800.0 |
| 2007-07-25 08:25:00 | SPY | ETF | 152.1 | 152.12 | 152.08 | 152.11 | 22800.0 |
| 2007-07-25 08:30:00 | SPY | ETF | 152.1 | 152.22 | 152.1 | 152.18 | 601100.0 |
| 2007-07-25 08:35:00 | SPY | ETF | 152.14 | 152.16 | 152.05 | 152.08 | 689100.0 |
| 2007-07-25 08:40:00 | SPY | ETF | 152.06 | 152.11 | 152.04 | 152.09 | 165600.0 |
| 2007-07-25 08:45:00 | SPY | ETF | 152.09 | 152.12 | 152.06 | 152.07 | 279400.0 |
| 2007-07-25 08:50:00 | SPY | ETF | 152.06 | 152.13 | 152.06 | 152.13 | 521100.0 |
| 2007-07-25 08:55:00 | SPY | ETF | 152.14 | 152.14 | 152.12 | 152.12 | 29300.0 |
| 2007-07-25 09:00:00 | SPY | ETF | 152.12 | 152.13 | 152.09 | 152.11 | 379900.0 |
| 2007-07-25 09:05:00 | SPY | ETF | 152.11 | 152.15 | 152.09 | 152.12 | 288700.0 |
| 2007-07-25 09:10:00 | SPY | ETF | 152.1 | 152.12 | 152.04 | 152.05 | 449343.0 |
| 2007-07-25 09:15:00 | SPY | ETF | 152.05 | 152.08 | 152.04 | 152.07 | 142600.0 |
| 2007-07-25 09:20:00 | SPY | ETF | 152.07 | 152.12 | 151.85 | 151.85 | 144300.0 |
| 2007-07-25 09:25:00 | SPY | ETF | 152.04 | 152.07 | 151.53 | 152.03 | 893700.0 |
| 2007-07-25 09:30:00 | SPY | ETF | 152.02 | 152.21 | 152.02 | 152.07 | 3138911.0 |
| 2007-07-25 09:35:00 | SPY | ETF | 152.07 | 152.15 | 151.99 | 152.13 | 4736746.0 |
| 2007-07-25 09:40:00 | SPY | ETF | 152.12 | 152.27 | 152.05 | 152.2 | 3084350.0 |
| 2007-07-25 09:45:00 | SPY | ETF | 152.21 | 152.27 | 152.08 | 152.2 | 2221869.0 |
| 2007-07-25 09:50:00 | SPY | ETF | 152.2 | 152.39 | 152.18 | 152.29 | 3847472.0 |
| 2007-07-25 09:55:00 | SPY | ETF | 152.3 | 152.33 | 152.16 | 152.16 | 2067580.0 |
| 2007-07-25 10:00:00 | SPY | ETF | 152.16 | 152.25 | 152.0 | 152.03 | 4844660.0 |
> showing 50 of 18,317 rows — these rows as CSV