PREVIEW / etf_5min / 2010-02-17
file: by_date/etf_5min/2010/2010-02-17.parquet size: 711 KB rows: 32,003
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-17 04:15:00 | SPY | ETF | 110.19 | 110.2 | 110.17 | 110.17 | 3400.0 |
| 2010-02-17 04:20:00 | SPY | ETF | 110.16 | 110.16 | 110.16 | 110.16 | 800.0 |
| 2010-02-17 04:30:00 | SPY | ETF | 110.15 | 110.15 | 110.15 | 110.15 | 237.0 |
| 2010-02-17 04:40:00 | SPY | ETF | 110.2 | 110.27 | 110.2 | 110.27 | 1400.0 |
| 2010-02-17 04:45:00 | SPY | ETF | 110.29 | 110.29 | 110.29 | 110.29 | 300.0 |
| 2010-02-17 04:55:00 | SPY | ETF | 110.24 | 110.24 | 110.23 | 110.23 | 524.0 |
| 2010-02-17 05:00:00 | SPY | ETF | 110.15 | 110.15 | 110.15 | 110.15 | 100.0 |
| 2010-02-17 05:05:00 | SPY | ETF | 110.2 | 110.2 | 110.18 | 110.18 | 3800.0 |
| 2010-02-17 05:10:00 | SPY | ETF | 110.17 | 110.17 | 110.17 | 110.17 | 100.0 |
| 2010-02-17 05:15:00 | SPY | ETF | 110.15 | 110.15 | 110.15 | 110.15 | 100.0 |
| 2010-02-17 05:25:00 | SPY | ETF | 110.1 | 110.1 | 110.1 | 110.1 | 5000.0 |
| 2010-02-17 05:50:00 | SPY | ETF | 110.14 | 110.14 | 110.12 | 110.12 | 20000.0 |
| 2010-02-17 06:00:00 | SPY | ETF | 110.11 | 110.11 | 110.09 | 110.09 | 2100.0 |
| 2010-02-17 06:05:00 | SPY | ETF | 110.03 | 110.03 | 110.01 | 110.01 | 5000.0 |
| 2010-02-17 06:25:00 | SPY | ETF | 110.0 | 110.0 | 110.0 | 110.0 | 500.0 |
| 2010-02-17 06:30:00 | SPY | ETF | 110.02 | 110.02 | 110.02 | 110.02 | 100.0 |
| 2010-02-17 06:40:00 | SPY | ETF | 110.12 | 110.15 | 110.12 | 110.15 | 2600.0 |
| 2010-02-17 06:45:00 | SPY | ETF | 110.12 | 110.19 | 110.12 | 110.19 | 200.0 |
| 2010-02-17 06:55:00 | SPY | ETF | 110.15 | 110.2 | 110.15 | 110.2 | 61700.0 |
| 2010-02-17 07:00:00 | SPY | ETF | 110.13 | 110.14 | 110.1 | 110.13 | 318029.0 |
| 2010-02-17 07:05:00 | SPY | ETF | 110.12 | 110.14 | 110.08 | 110.1 | 4180.0 |
| 2010-02-17 07:10:00 | SPY | ETF | 110.1 | 110.12 | 110.1 | 110.11 | 700.0 |
| 2010-02-17 07:15:00 | SPY | ETF | 110.12 | 110.15 | 110.12 | 110.13 | 10000.0 |
| 2010-02-17 07:20:00 | SPY | ETF | 110.15 | 110.21 | 110.15 | 110.2 | 50632.0 |
| 2010-02-17 07:25:00 | SPY | ETF | 110.18 | 110.23 | 110.18 | 110.23 | 21850.0 |
| 2010-02-17 07:30:00 | SPY | ETF | 110.2 | 110.26 | 110.2 | 110.25 | 65850.0 |
| 2010-02-17 07:35:00 | SPY | ETF | 110.25 | 110.34 | 110.25 | 110.31 | 99700.0 |
| 2010-02-17 07:40:00 | SPY | ETF | 110.28 | 110.32 | 110.27 | 110.32 | 116700.0 |
| 2010-02-17 07:45:00 | SPY | ETF | 110.32 | 110.44 | 110.32 | 110.4 | 139350.0 |
| 2010-02-17 07:50:00 | SPY | ETF | 110.4 | 110.42 | 110.35 | 110.35 | 58379.0 |
| 2010-02-17 07:55:00 | SPY | ETF | 110.35 | 110.38 | 110.35 | 110.38 | 40860.0 |
| 2010-02-17 08:00:00 | SPY | ETF | 110.38 | 110.41 | 110.11 | 110.35 | 729653.0 |
| 2010-02-17 08:05:00 | SPY | ETF | 110.37 | 110.4 | 110.34 | 110.36 | 358864.0 |
| 2010-02-17 08:10:00 | SPY | ETF | 110.35 | 110.39 | 110.35 | 110.37 | 96220.0 |
| 2010-02-17 08:15:00 | SPY | ETF | 110.37 | 110.38 | 110.31 | 110.32 | 205487.0 |
| 2010-02-17 08:20:00 | SPY | ETF | 110.32 | 110.32 | 110.27 | 110.3 | 174874.0 |
| 2010-02-17 08:25:00 | SPY | ETF | 110.31 | 110.35 | 110.3 | 110.32 | 87951.0 |
| 2010-02-17 08:30:00 | SPY | ETF | 110.33 | 110.38 | 110.26 | 110.37 | 258417.0 |
| 2010-02-17 08:35:00 | SPY | ETF | 110.36 | 110.42 | 110.3 | 110.39 | 372798.0 |
| 2010-02-17 08:40:00 | SPY | ETF | 110.38 | 110.45 | 110.37 | 110.38 | 98071.0 |
| 2010-02-17 08:45:00 | SPY | ETF | 110.39 | 110.43 | 110.3 | 110.32 | 473006.0 |
| 2010-02-17 08:50:00 | SPY | ETF | 110.32 | 110.37 | 110.3 | 110.35 | 243352.0 |
| 2010-02-17 08:55:00 | SPY | ETF | 110.35 | 110.38 | 110.32 | 110.36 | 70092.0 |
| 2010-02-17 09:00:00 | SPY | ETF | 110.37 | 110.37 | 110.29 | 110.32 | 235346.0 |
| 2010-02-17 09:05:00 | SPY | ETF | 110.32 | 110.38 | 110.3 | 110.3 | 237786.0 |
| 2010-02-17 09:10:00 | SPY | ETF | 110.32 | 110.33 | 110.29 | 110.32 | 140559.0 |
| 2010-02-17 09:15:00 | SPY | ETF | 110.33 | 110.36 | 110.26 | 110.3 | 299301.0 |
| 2010-02-17 09:20:00 | SPY | ETF | 110.3 | 110.3 | 110.22 | 110.23 | 649355.0 |
| 2010-02-17 09:25:00 | SPY | ETF | 110.23 | 110.27 | 110.21 | 110.27 | 272626.0 |
| 2010-02-17 09:30:00 | SPY | ETF | 110.27 | 110.28 | 110.09 | 110.22 | 5755348.0 |
> showing 50 of 32,003 rows — these rows as CSV