PREVIEW / etf_5min / 2007-01-11
file: by_date/etf_5min/2007/2007-01-11.parquet size: 288 KB rows: 13,965
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-01-11 06:35:00 | SPY | ETF | 141.53 | 141.53 | 141.53 | 141.53 | 17500.0 |
| 2007-01-11 07:00:00 | SPY | ETF | 141.53 | 141.53 | 141.4 | 141.4 | 2700.0 |
| 2007-01-11 07:10:00 | SPY | ETF | 141.35 | 141.37 | 141.35 | 141.37 | 8900.0 |
| 2007-01-11 07:20:00 | SPY | ETF | 141.37 | 141.37 | 141.37 | 141.37 | 10000.0 |
| 2007-01-11 07:25:00 | SPY | ETF | 141.4 | 141.4 | 141.4 | 141.4 | 1000.0 |
| 2007-01-11 07:30:00 | SPY | ETF | 141.39 | 141.39 | 141.3 | 141.3 | 12600.0 |
| 2007-01-11 07:40:00 | SPY | ETF | 141.34 | 141.38 | 141.34 | 141.38 | 30000.0 |
| 2007-01-11 07:45:00 | SPY | ETF | 141.4 | 141.51 | 141.4 | 141.49 | 165700.0 |
| 2007-01-11 07:50:00 | SPY | ETF | 141.5 | 141.54 | 141.5 | 141.54 | 71300.0 |
| 2007-01-11 07:55:00 | SPY | ETF | 141.5 | 141.5 | 141.46 | 141.46 | 15200.0 |
| 2007-01-11 08:00:00 | SPY | ETF | 141.41 | 141.54 | 141.25 | 141.4 | 600300.0 |
| 2007-01-11 08:05:00 | SPY | ETF | 141.38 | 141.42 | 141.31 | 141.31 | 5400.0 |
| 2007-01-11 08:10:00 | SPY | ETF | 141.31 | 141.33 | 141.3 | 141.31 | 4800.0 |
| 2007-01-11 08:15:00 | SPY | ETF | 141.29 | 141.29 | 141.26 | 141.28 | 4000.0 |
| 2007-01-11 08:20:00 | SPY | ETF | 141.27 | 141.29 | 141.25 | 141.25 | 8400.0 |
| 2007-01-11 08:25:00 | SPY | ETF | 141.25 | 141.25 | 141.17 | 141.22 | 629300.0 |
| 2007-01-11 08:30:00 | SPY | ETF | 141.21 | 141.26 | 141.21 | 141.25 | 222000.0 |
| 2007-01-11 08:35:00 | SPY | ETF | 141.27 | 141.27 | 141.2 | 141.27 | 59200.0 |
| 2007-01-11 08:40:00 | SPY | ETF | 141.25 | 141.39 | 141.24 | 141.39 | 90300.0 |
| 2007-01-11 08:45:00 | SPY | ETF | 141.38 | 141.38 | 141.35 | 141.35 | 24700.0 |
| 2007-01-11 08:50:00 | SPY | ETF | 141.35 | 141.42 | 141.35 | 141.41 | 222800.0 |
| 2007-01-11 08:55:00 | SPY | ETF | 141.41 | 141.41 | 141.37 | 141.37 | 19900.0 |
| 2007-01-11 09:00:00 | SPY | ETF | 141.38 | 141.43 | 141.38 | 141.42 | 21200.0 |
| 2007-01-11 09:05:00 | SPY | ETF | 141.42 | 141.46 | 141.42 | 141.46 | 33300.0 |
| 2007-01-11 09:10:00 | SPY | ETF | 141.47 | 141.56 | 141.46 | 141.55 | 480500.0 |
| 2007-01-11 09:15:00 | SPY | ETF | 141.54 | 141.54 | 141.5 | 141.53 | 14700.0 |
| 2007-01-11 09:20:00 | SPY | ETF | 141.51 | 141.52 | 141.49 | 141.52 | 6400.0 |
| 2007-01-11 09:25:00 | SPY | ETF | 141.52 | 141.57 | 141.52 | 141.56 | 37700.0 |
| 2007-01-11 09:30:00 | SPY | ETF | 141.56 | 141.64 | 141.5 | 141.58 | 1200800.0 |
| 2007-01-11 09:35:00 | SPY | ETF | 141.58 | 141.74 | 141.58 | 141.68 | 884500.0 |
| 2007-01-11 09:40:00 | SPY | ETF | 141.69 | 141.84 | 141.68 | 141.82 | 1486100.0 |
| 2007-01-11 09:45:00 | SPY | ETF | 141.81 | 142.04 | 141.81 | 141.91 | 1712000.0 |
| 2007-01-11 09:50:00 | SPY | ETF | 141.9 | 142.0 | 141.89 | 141.93 | 861800.0 |
| 2007-01-11 09:55:00 | SPY | ETF | 141.95 | 142.11 | 141.9401 | 142.02 | 1073400.0 |
| 2007-01-11 10:00:00 | SPY | ETF | 142.02 | 142.04 | 141.94 | 141.95 | 643900.0 |
| 2007-01-11 10:05:00 | SPY | ETF | 141.95 | 142.09 | 141.95 | 142.07 | 765000.0 |
| 2007-01-11 10:10:00 | SPY | ETF | 142.07 | 142.28 | 142.01 | 142.14 | 1056500.0 |
| 2007-01-11 10:15:00 | SPY | ETF | 142.15 | 142.19 | 142.11 | 142.16 | 587700.0 |
| 2007-01-11 10:20:00 | SPY | ETF | 142.14 | 142.16 | 142.05 | 142.12 | 1402100.0 |
| 2007-01-11 10:25:00 | SPY | ETF | 142.13 | 142.15 | 142.05 | 142.06 | 470200.0 |
| 2007-01-11 10:30:00 | SPY | ETF | 142.05 | 142.14 | 142.03 | 142.11 | 870200.0 |
| 2007-01-11 10:35:00 | SPY | ETF | 142.1 | 142.18 | 142.05 | 142.16 | 741800.0 |
| 2007-01-11 10:40:00 | SPY | ETF | 142.16 | 142.23 | 142.12 | 142.21 | 367200.0 |
| 2007-01-11 10:45:00 | SPY | ETF | 142.21 | 142.33 | 142.2 | 142.3 | 766400.0 |
| 2007-01-11 10:50:00 | SPY | ETF | 142.3 | 142.33 | 142.24 | 142.27 | 1175500.0 |
| 2007-01-11 10:55:00 | SPY | ETF | 142.26 | 142.35 | 142.21 | 142.34 | 670800.0 |
| 2007-01-11 11:00:00 | SPY | ETF | 142.33 | 142.47 | 142.33 | 142.44 | 786800.0 |
| 2007-01-11 11:05:00 | SPY | ETF | 142.43 | 142.54 | 142.43 | 142.47 | 815000.0 |
| 2007-01-11 11:10:00 | SPY | ETF | 142.46 | 142.56 | 142.43 | 142.55 | 810200.0 |
| 2007-01-11 11:15:00 | SPY | ETF | 142.54 | 142.61 | 142.51 | 142.57 | 878700.0 |
> showing 50 of 13,965 rows — these rows as CSV