PREVIEW / etf_5min / 2007-10-16
file: by_date/etf_5min/2007/2007-10-16.parquet size: 348 KB rows: 18,158
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-10-16 04:20:00 | SPY | ETF | 154.11 | 154.11 | 154.11 | 154.11 | 100.0 |
| 2007-10-16 04:30:00 | SPY | ETF | 154.19 | 154.19 | 154.19 | 154.19 | 100.0 |
| 2007-10-16 05:05:00 | SPY | ETF | 154.26 | 154.26 | 154.24 | 154.25 | 5000.0 |
| 2007-10-16 05:40:00 | SPY | ETF | 154.24 | 154.24 | 154.24 | 154.24 | 3000.0 |
| 2007-10-16 05:55:00 | SPY | ETF | 154.26 | 154.31 | 154.26 | 154.31 | 12600.0 |
| 2007-10-16 06:10:00 | SPY | ETF | 154.29 | 154.29 | 154.29 | 154.29 | 100.0 |
| 2007-10-16 06:25:00 | SPY | ETF | 154.28 | 154.28 | 154.28 | 154.28 | 1000.0 |
| 2007-10-16 06:30:00 | SPY | ETF | 154.26 | 154.26 | 154.26 | 154.26 | 1000.0 |
| 2007-10-16 06:40:00 | SPY | ETF | 154.16 | 154.21 | 154.16 | 154.18 | 70700.0 |
| 2007-10-16 06:50:00 | SPY | ETF | 154.26 | 154.26 | 154.26 | 154.26 | 1000.0 |
| 2007-10-16 06:55:00 | SPY | ETF | 154.29 | 154.29 | 154.29 | 154.29 | 500.0 |
| 2007-10-16 07:00:00 | SPY | ETF | 154.34 | 154.36 | 154.29 | 154.29 | 3600.0 |
| 2007-10-16 07:05:00 | SPY | ETF | 154.34 | 154.34 | 154.33 | 154.33 | 10000.0 |
| 2007-10-16 07:10:00 | SPY | ETF | 154.3 | 154.32 | 154.3 | 154.31 | 88500.0 |
| 2007-10-16 07:15:00 | SPY | ETF | 154.31 | 154.35 | 154.29 | 154.31 | 12800.0 |
| 2007-10-16 07:20:00 | SPY | ETF | 154.29 | 154.3 | 154.23 | 154.23 | 77100.0 |
| 2007-10-16 07:25:00 | SPY | ETF | 154.23 | 154.28 | 154.23 | 154.28 | 25000.0 |
| 2007-10-16 07:30:00 | SPY | ETF | 154.28 | 154.3 | 154.2 | 154.2 | 18000.0 |
| 2007-10-16 07:35:00 | SPY | ETF | 154.26 | 154.26 | 154.2 | 154.2 | 11100.0 |
| 2007-10-16 07:40:00 | SPY | ETF | 154.2 | 154.23 | 154.16 | 154.18 | 94500.0 |
| 2007-10-16 07:45:00 | SPY | ETF | 154.19 | 154.2 | 154.13 | 154.2 | 530700.0 |
| 2007-10-16 07:50:00 | SPY | ETF | 154.2 | 154.29 | 154.17 | 154.29 | 62200.0 |
| 2007-10-16 07:55:00 | SPY | ETF | 154.29 | 154.3 | 154.25 | 154.25 | 71500.0 |
| 2007-10-16 08:00:00 | SPY | ETF | 154.24 | 154.29 | 154.18 | 154.28 | 598100.0 |
| 2007-10-16 08:05:00 | SPY | ETF | 154.24 | 154.25 | 154.21 | 154.22 | 19300.0 |
| 2007-10-16 08:10:00 | SPY | ETF | 154.24 | 154.25 | 154.19 | 154.22 | 108800.0 |
| 2007-10-16 08:15:00 | SPY | ETF | 154.23 | 154.25 | 154.2 | 154.25 | 137500.0 |
| 2007-10-16 08:20:00 | SPY | ETF | 154.25 | 154.29 | 154.23 | 154.28 | 84100.0 |
| 2007-10-16 08:25:00 | SPY | ETF | 154.28 | 154.29 | 154.24 | 154.24 | 31500.0 |
| 2007-10-16 08:30:00 | SPY | ETF | 154.25 | 154.25 | 154.22 | 154.24 | 59900.0 |
| 2007-10-16 08:35:00 | SPY | ETF | 154.24 | 154.24 | 154.2 | 154.24 | 71800.0 |
| 2007-10-16 08:40:00 | SPY | ETF | 154.24 | 154.29 | 154.24 | 154.29 | 230000.0 |
| 2007-10-16 08:45:00 | SPY | ETF | 154.29 | 154.41 | 154.29 | 154.4 | 97800.0 |
| 2007-10-16 08:50:00 | SPY | ETF | 154.4 | 154.48 | 154.35 | 154.48 | 330600.0 |
| 2007-10-16 08:55:00 | SPY | ETF | 154.48 | 154.56 | 154.47 | 154.49 | 110000.0 |
| 2007-10-16 09:00:00 | SPY | ETF | 154.51 | 154.51 | 154.34 | 154.36 | 294714.0 |
| 2007-10-16 09:05:00 | SPY | ETF | 154.36 | 154.36 | 154.27 | 154.28 | 517000.0 |
| 2007-10-16 09:10:00 | SPY | ETF | 154.28 | 154.36 | 154.28 | 154.34 | 147600.0 |
| 2007-10-16 09:15:00 | SPY | ETF | 154.31 | 154.38 | 154.3 | 154.38 | 244114.0 |
| 2007-10-16 09:20:00 | SPY | ETF | 154.39 | 154.41 | 154.38 | 154.41 | 14100.0 |
| 2007-10-16 09:25:00 | SPY | ETF | 154.41 | 154.43 | 154.4 | 154.42 | 34500.0 |
| 2007-10-16 09:30:00 | SPY | ETF | 154.41 | 154.49 | 154.28 | 154.33 | 2034379.0 |
| 2007-10-16 09:35:00 | SPY | ETF | 154.32 | 156.48 | 154.11 | 154.16 | 4012765.0 |
| 2007-10-16 09:40:00 | SPY | ETF | 154.16 | 154.2 | 154.0 | 154.13 | 4358900.0 |
| 2007-10-16 09:45:00 | SPY | ETF | 154.13 | 154.18 | 153.98 | 154.06 | 2728400.0 |
| 2007-10-16 09:50:00 | SPY | ETF | 154.06 | 154.14 | 153.97 | 154.05 | 4270500.0 |
| 2007-10-16 09:55:00 | SPY | ETF | 154.06 | 154.26 | 154.05 | 154.21 | 3586700.0 |
| 2007-10-16 10:00:00 | SPY | ETF | 154.21 | 154.2125 | 154.04 | 154.16 | 1630250.0 |
| 2007-10-16 10:05:00 | SPY | ETF | 154.16 | 154.39 | 154.12 | 154.32 | 2210400.0 |
| 2007-10-16 10:10:00 | SPY | ETF | 154.29 | 154.33 | 153.9 | 153.9 | 1959888.0 |
> showing 50 of 18,158 rows — these rows as CSV