PREVIEW / etf_5min / 2007-02-07
file: by_date/etf_5min/2007/2007-02-07.parquet size: 285 KB rows: 13,915
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-02-07 06:10:00 | SPY | ETF | 145.01 | 145.01 | 145.01 | 145.01 | 15000.0 |
| 2007-02-07 06:40:00 | SPY | ETF | 145.0 | 145.0 | 145.0 | 145.0 | 100.0 |
| 2007-02-07 07:00:00 | SPY | ETF | 144.93 | 144.99 | 144.93 | 144.99 | 1300.0 |
| 2007-02-07 07:15:00 | SPY | ETF | 144.98 | 144.98 | 144.98 | 144.98 | 3700.0 |
| 2007-02-07 07:20:00 | SPY | ETF | 145.0 | 145.01 | 145.0 | 145.01 | 90000.0 |
| 2007-02-07 07:30:00 | SPY | ETF | 145.0 | 145.0 | 145.0 | 145.0 | 10900.0 |
| 2007-02-07 07:35:00 | SPY | ETF | 145.03 | 145.03 | 145.03 | 145.03 | 300.0 |
| 2007-02-07 07:40:00 | SPY | ETF | 145.04 | 145.04 | 145.04 | 145.04 | 10000.0 |
| 2007-02-07 07:55:00 | SPY | ETF | 145.05 | 145.08 | 145.05 | 145.08 | 18500.0 |
| 2007-02-07 08:00:00 | SPY | ETF | 145.07 | 145.07 | 144.99 | 145.05 | 38600.0 |
| 2007-02-07 08:05:00 | SPY | ETF | 145.07 | 145.07 | 145.04 | 145.04 | 5200.0 |
| 2007-02-07 08:10:00 | SPY | ETF | 145.04 | 145.04 | 145.04 | 145.04 | 2100.0 |
| 2007-02-07 08:15:00 | SPY | ETF | 145.04 | 145.06 | 145.03 | 145.03 | 700.0 |
| 2007-02-07 08:20:00 | SPY | ETF | 145.03 | 145.05 | 145.02 | 145.05 | 14900.0 |
| 2007-02-07 08:25:00 | SPY | ETF | 145.03 | 145.05 | 145.03 | 145.05 | 500.0 |
| 2007-02-07 08:30:00 | SPY | ETF | 145.06 | 145.15 | 145.03 | 145.11 | 286900.0 |
| 2007-02-07 08:35:00 | SPY | ETF | 145.12 | 145.15 | 145.12 | 145.14 | 39800.0 |
| 2007-02-07 08:40:00 | SPY | ETF | 145.14 | 145.2 | 145.12 | 145.18 | 245900.0 |
| 2007-02-07 08:45:00 | SPY | ETF | 145.15 | 145.15 | 145.15 | 145.15 | 100.0 |
| 2007-02-07 08:50:00 | SPY | ETF | 145.15 | 145.15 | 145.15 | 145.15 | 100.0 |
| 2007-02-07 08:55:00 | SPY | ETF | 145.15 | 145.17 | 145.15 | 145.16 | 29000.0 |
| 2007-02-07 09:00:00 | SPY | ETF | 145.16 | 145.17 | 145.16 | 145.17 | 2300.0 |
| 2007-02-07 09:05:00 | SPY | ETF | 145.17 | 145.17 | 145.1 | 145.15 | 16700.0 |
| 2007-02-07 09:10:00 | SPY | ETF | 145.15 | 145.15 | 145.14 | 145.14 | 3000.0 |
| 2007-02-07 09:15:00 | SPY | ETF | 145.13 | 145.13 | 145.11 | 145.11 | 9100.0 |
| 2007-02-07 09:20:00 | SPY | ETF | 145.12 | 145.13 | 145.11 | 145.11 | 313500.0 |
| 2007-02-07 09:25:00 | SPY | ETF | 145.11 | 145.12 | 145.08 | 145.12 | 70900.0 |
| 2007-02-07 09:30:00 | SPY | ETF | 145.12 | 145.19 | 145.03 | 145.06 | 1082700.0 |
| 2007-02-07 09:35:00 | SPY | ETF | 145.07 | 145.08 | 144.97 | 144.97 | 1658200.0 |
| 2007-02-07 09:40:00 | SPY | ETF | 144.98 | 145.04 | 144.92 | 144.95 | 921700.0 |
| 2007-02-07 09:45:00 | SPY | ETF | 144.95 | 145.04 | 144.9 | 144.94 | 1167300.0 |
| 2007-02-07 09:50:00 | SPY | ETF | 144.94 | 145.02 | 144.93 | 145.0 | 1007700.0 |
| 2007-02-07 09:55:00 | SPY | ETF | 144.99 | 145.0 | 144.87 | 144.96 | 1332000.0 |
| 2007-02-07 10:00:00 | SPY | ETF | 144.96 | 144.98 | 144.88 | 144.94 | 559600.0 |
| 2007-02-07 10:05:00 | SPY | ETF | 144.94 | 144.98 | 144.88 | 144.92 | 579300.0 |
| 2007-02-07 10:10:00 | SPY | ETF | 144.92 | 145.05 | 144.87 | 145.04 | 1003200.0 |
| 2007-02-07 10:15:00 | SPY | ETF | 145.03 | 145.11 | 145.01 | 145.07 | 854900.0 |
| 2007-02-07 10:20:00 | SPY | ETF | 145.06 | 145.2 | 145.06 | 145.16 | 1168100.0 |
| 2007-02-07 10:25:00 | SPY | ETF | 145.16 | 145.22 | 145.1 | 145.1 | 1240000.0 |
| 2007-02-07 10:30:00 | SPY | ETF | 145.11 | 145.19 | 145.06 | 145.15 | 753200.0 |
| 2007-02-07 10:35:00 | SPY | ETF | 145.14 | 145.27 | 145.11 | 145.26 | 776700.0 |
| 2007-02-07 10:40:00 | SPY | ETF | 145.26 | 145.33 | 145.23 | 145.3199 | 1148200.0 |
| 2007-02-07 10:45:00 | SPY | ETF | 145.31 | 145.34 | 145.27 | 145.32 | 861400.0 |
| 2007-02-07 10:50:00 | SPY | ETF | 145.31 | 145.34 | 145.24 | 145.26 | 577000.0 |
| 2007-02-07 10:55:00 | SPY | ETF | 145.26 | 145.31 | 145.22 | 145.25 | 815100.0 |
| 2007-02-07 11:00:00 | SPY | ETF | 145.25 | 145.28 | 145.22 | 145.24 | 453600.0 |
| 2007-02-07 11:05:00 | SPY | ETF | 145.24 | 145.34 | 145.24 | 145.28 | 381400.0 |
| 2007-02-07 11:10:00 | SPY | ETF | 145.28 | 145.3 | 145.22 | 145.22 | 308600.0 |
| 2007-02-07 11:15:00 | SPY | ETF | 145.23 | 145.2799 | 145.22 | 145.23 | 141200.0 |
| 2007-02-07 11:20:00 | SPY | ETF | 145.23 | 145.25 | 145.19 | 145.23 | 205500.0 |
> showing 50 of 13,915 rows — these rows as CSV