PREVIEW / etf_5min / 2005-01-24
file: by_date/etf_5min/2005/2005-01-24.parquet size: 117 KB rows: 6,216
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-01-24 08:00:00 | SPY | ETF | 116.91 | 116.91 | 116.91 | 116.91 | 100.0 |
| 2005-01-24 08:05:00 | SPY | ETF | 116.94 | 117.02 | 116.94 | 117.02 | 4100.0 |
| 2005-01-24 08:10:00 | SPY | ETF | 117.0 | 117.0 | 116.93 | 116.93 | 190600.0 |
| 2005-01-24 08:15:00 | SPY | ETF | 116.91 | 116.91 | 116.91 | 116.91 | 100.0 |
| 2005-01-24 08:20:00 | SPY | ETF | 116.91 | 116.94 | 116.91 | 116.94 | 1500.0 |
| 2005-01-24 08:30:00 | SPY | ETF | 116.96 | 117.0 | 116.96 | 116.98 | 28200.0 |
| 2005-01-24 08:35:00 | SPY | ETF | 116.98 | 117.0 | 116.97 | 117.0 | 7700.0 |
| 2005-01-24 08:40:00 | SPY | ETF | 116.98 | 117.02 | 116.96 | 117.02 | 10900.0 |
| 2005-01-24 08:45:00 | SPY | ETF | 117.01 | 117.05 | 117.0 | 117.0 | 81600.0 |
| 2005-01-24 08:50:00 | SPY | ETF | 117.0 | 117.06 | 117.0 | 117.04 | 55300.0 |
| 2005-01-24 08:55:00 | SPY | ETF | 117.04 | 117.05 | 117.03 | 117.04 | 8000.0 |
| 2005-01-24 09:00:00 | SPY | ETF | 117.04 | 117.11 | 117.04 | 117.11 | 114000.0 |
| 2005-01-24 09:05:00 | SPY | ETF | 117.1 | 117.14 | 117.09 | 117.14 | 153400.0 |
| 2005-01-24 09:10:00 | SPY | ETF | 117.14 | 117.14 | 117.13 | 117.14 | 33600.0 |
| 2005-01-24 09:15:00 | SPY | ETF | 117.13 | 117.13 | 117.1 | 117.1 | 26600.0 |
| 2005-01-24 09:20:00 | SPY | ETF | 117.1 | 117.1 | 117.07 | 117.07 | 7700.0 |
| 2005-01-24 09:25:00 | SPY | ETF | 117.07 | 117.11 | 117.06 | 117.08 | 10000.0 |
| 2005-01-24 09:30:00 | SPY | ETF | 117.09 | 117.16 | 117.01 | 117.16 | 1080300.0 |
| 2005-01-24 09:35:00 | SPY | ETF | 117.15 | 117.28 | 117.12 | 117.21 | 2003100.0 |
| 2005-01-24 09:40:00 | SPY | ETF | 117.22 | 117.25 | 117.12 | 117.12 | 1199800.0 |
| 2005-01-24 09:45:00 | SPY | ETF | 117.13 | 117.21 | 117.08 | 117.09 | 1083900.0 |
| 2005-01-24 09:50:00 | SPY | ETF | 117.08 | 117.11 | 116.86 | 116.86 | 1387200.0 |
| 2005-01-24 09:55:00 | SPY | ETF | 116.86 | 117.0 | 116.8 | 116.84 | 1456300.0 |
| 2005-01-24 10:00:00 | SPY | ETF | 116.84 | 116.92 | 116.77 | 116.9 | 1590300.0 |
| 2005-01-24 10:05:00 | SPY | ETF | 116.78 | 116.99 | 116.78 | 116.81 | 1266200.0 |
| 2005-01-24 10:10:00 | SPY | ETF | 116.82 | 116.98 | 116.75 | 116.93 | 1718100.0 |
| 2005-01-24 10:15:00 | SPY | ETF | 116.93 | 117.15 | 116.88 | 117.1 | 1873100.0 |
| 2005-01-24 10:20:00 | SPY | ETF | 117.1 | 117.13 | 116.92 | 116.95 | 756200.0 |
| 2005-01-24 10:25:00 | SPY | ETF | 116.96 | 117.02 | 116.83 | 116.86 | 750600.0 |
| 2005-01-24 10:30:00 | SPY | ETF | 116.87 | 117.19 | 116.84 | 117.13 | 1973300.0 |
| 2005-01-24 10:35:00 | SPY | ETF | 117.12 | 117.23 | 117.03 | 117.06 | 1117400.0 |
| 2005-01-24 10:40:00 | SPY | ETF | 117.05 | 117.1 | 116.99 | 117.05 | 675100.0 |
| 2005-01-24 10:45:00 | SPY | ETF | 117.06 | 117.09 | 116.92 | 117.03 | 439800.0 |
| 2005-01-24 10:50:00 | SPY | ETF | 117.03 | 117.07 | 116.84 | 116.84 | 971400.0 |
| 2005-01-24 10:55:00 | SPY | ETF | 116.84 | 116.9 | 116.74 | 116.87 | 1798100.0 |
| 2005-01-24 11:00:00 | SPY | ETF | 116.87 | 116.97 | 116.84 | 116.88 | 572100.0 |
| 2005-01-24 11:05:00 | SPY | ETF | 116.89 | 116.92 | 116.71 | 116.74 | 693400.0 |
| 2005-01-24 11:10:00 | SPY | ETF | 116.85 | 116.91 | 116.74 | 116.8 | 584700.0 |
| 2005-01-24 11:15:00 | SPY | ETF | 116.79 | 117.08 | 116.76 | 117.06 | 491300.0 |
| 2005-01-24 11:20:00 | SPY | ETF | 117.05 | 117.2 | 117.01 | 117.16 | 1550300.0 |
| 2005-01-24 11:25:00 | SPY | ETF | 117.15 | 117.19 | 117.06 | 117.06 | 968400.0 |
| 2005-01-24 11:30:00 | SPY | ETF | 117.09 | 117.2 | 117.07 | 117.16 | 467900.0 |
| 2005-01-24 11:35:00 | SPY | ETF | 117.16 | 117.25 | 117.06 | 117.1 | 689300.0 |
| 2005-01-24 11:40:00 | SPY | ETF | 117.1 | 117.1 | 116.95 | 116.97 | 538600.0 |
| 2005-01-24 11:45:00 | SPY | ETF | 116.96 | 117.06 | 116.95 | 117.04 | 747200.0 |
| 2005-01-24 11:50:00 | SPY | ETF | 117.03 | 117.1 | 117.0 | 117.02 | 262600.0 |
| 2005-01-24 11:55:00 | SPY | ETF | 117.0 | 117.06 | 116.97 | 117.03 | 308300.0 |
| 2005-01-24 12:00:00 | SPY | ETF | 117.03 | 117.23 | 117.03 | 117.17 | 630800.0 |
| 2005-01-24 12:05:00 | SPY | ETF | 117.18 | 117.18 | 117.0 | 117.04 | 286900.0 |
| 2005-01-24 12:10:00 | SPY | ETF | 117.03 | 117.09 | 116.95 | 117.01 | 307500.0 |
> showing 50 of 6,216 rows — these rows as CSV