PREVIEW / etf_5min / 2007-07-09
file: by_date/etf_5min/2007/2007-07-09.parquet size: 296 KB rows: 16,958
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-07-09 06:05:00 | SPY | ETF | 153.18 | 153.18 | 153.18 | 153.18 | 15000.0 |
| 2007-07-09 06:45:00 | SPY | ETF | 153.19 | 153.23 | 153.19 | 153.23 | 13500.0 |
| 2007-07-09 07:00:00 | SPY | ETF | 153.18 | 153.18 | 153.14 | 153.14 | 10000.0 |
| 2007-07-09 07:05:00 | SPY | ETF | 153.2 | 153.21 | 153.2 | 153.21 | 14000.0 |
| 2007-07-09 07:10:00 | SPY | ETF | 153.16 | 153.25 | 153.16 | 153.25 | 7500.0 |
| 2007-07-09 07:15:00 | SPY | ETF | 153.21 | 153.26 | 153.21 | 153.26 | 2900.0 |
| 2007-07-09 07:20:00 | SPY | ETF | 153.25 | 153.26 | 153.23 | 153.26 | 4100.0 |
| 2007-07-09 07:25:00 | SPY | ETF | 153.32 | 153.32 | 153.31 | 153.31 | 2500.0 |
| 2007-07-09 07:30:00 | SPY | ETF | 153.3 | 153.33 | 153.3 | 153.33 | 4000.0 |
| 2007-07-09 07:40:00 | SPY | ETF | 153.25 | 153.25 | 153.25 | 153.25 | 2500.0 |
| 2007-07-09 07:45:00 | SPY | ETF | 153.23 | 153.23 | 153.23 | 153.23 | 100.0 |
| 2007-07-09 07:55:00 | SPY | ETF | 153.26 | 153.26 | 153.26 | 153.26 | 800.0 |
| 2007-07-09 08:00:00 | SPY | ETF | 153.19 | 153.32 | 153.19 | 153.32 | 23500.0 |
| 2007-07-09 08:05:00 | SPY | ETF | 153.32 | 153.33 | 153.24 | 153.24 | 2500.0 |
| 2007-07-09 08:10:00 | SPY | ETF | 153.25 | 153.28 | 153.25 | 153.26 | 11400.0 |
| 2007-07-09 08:15:00 | SPY | ETF | 153.28 | 153.29 | 153.19 | 153.19 | 25700.0 |
| 2007-07-09 08:20:00 | SPY | ETF | 153.19 | 153.2 | 152.95 | 153.18 | 83200.0 |
| 2007-07-09 08:25:00 | SPY | ETF | 153.18 | 153.21 | 153.17 | 153.21 | 25800.0 |
| 2007-07-09 08:30:00 | SPY | ETF | 153.21 | 153.22 | 153.2 | 153.21 | 7700.0 |
| 2007-07-09 08:35:00 | SPY | ETF | 153.23 | 153.23 | 153.22 | 153.23 | 21200.0 |
| 2007-07-09 08:40:00 | SPY | ETF | 153.23 | 153.23 | 153.2 | 153.2 | 12700.0 |
| 2007-07-09 08:45:00 | SPY | ETF | 153.2 | 153.22 | 153.18 | 153.18 | 22300.0 |
| 2007-07-09 08:50:00 | SPY | ETF | 153.17 | 153.17 | 153.09 | 153.12 | 119600.0 |
| 2007-07-09 08:55:00 | SPY | ETF | 153.09 | 153.12 | 153.07 | 153.12 | 31400.0 |
| 2007-07-09 09:00:00 | SPY | ETF | 153.1 | 153.13 | 153.08 | 153.11 | 49900.0 |
| 2007-07-09 09:05:00 | SPY | ETF | 153.11 | 153.15 | 153.11 | 153.12 | 62400.0 |
| 2007-07-09 09:10:00 | SPY | ETF | 153.12 | 153.14 | 153.09 | 153.09 | 35300.0 |
| 2007-07-09 09:15:00 | SPY | ETF | 153.11 | 153.15 | 153.1 | 153.14 | 58614.0 |
| 2007-07-09 09:20:00 | SPY | ETF | 153.15 | 153.15 | 153.11 | 153.14 | 70700.0 |
| 2007-07-09 09:25:00 | SPY | ETF | 153.15 | 153.21 | 153.13 | 153.13 | 109300.0 |
| 2007-07-09 09:30:00 | SPY | ETF | 153.16 | 153.24 | 153.075 | 153.22 | 2334068.0 |
| 2007-07-09 09:35:00 | SPY | ETF | 153.22 | 153.25 | 153.14 | 153.21 | 2174000.0 |
| 2007-07-09 09:40:00 | SPY | ETF | 153.21 | 153.33 | 153.21 | 153.25 | 1476200.0 |
| 2007-07-09 09:45:00 | SPY | ETF | 153.24 | 153.26 | 153.1 | 153.15 | 2678100.0 |
| 2007-07-09 09:50:00 | SPY | ETF | 153.15 | 153.18 | 153.12 | 153.12 | 1480400.0 |
| 2007-07-09 09:55:00 | SPY | ETF | 153.12 | 153.14 | 153.02 | 153.1 | 2031226.0 |
| 2007-07-09 10:00:00 | SPY | ETF | 153.11 | 153.17 | 153.075 | 153.16 | 672300.0 |
| 2007-07-09 10:05:00 | SPY | ETF | 153.15 | 153.24 | 153.09 | 153.23 | 969800.0 |
| 2007-07-09 10:10:00 | SPY | ETF | 153.24 | 153.28 | 153.2 | 153.26 | 880300.0 |
| 2007-07-09 10:15:00 | SPY | ETF | 153.26 | 153.28 | 153.13 | 153.22 | 1476200.0 |
| 2007-07-09 10:20:00 | SPY | ETF | 153.23 | 153.28 | 153.15 | 153.17 | 756100.0 |
| 2007-07-09 10:25:00 | SPY | ETF | 153.16 | 153.17 | 153.05 | 153.12 | 1287735.0 |
| 2007-07-09 10:30:00 | SPY | ETF | 153.11 | 153.14 | 153.06 | 153.07 | 649500.0 |
| 2007-07-09 10:35:00 | SPY | ETF | 153.08 | 153.09 | 152.81 | 152.89 | 2433299.0 |
| 2007-07-09 10:40:00 | SPY | ETF | 152.88 | 152.88 | 152.69 | 152.71 | 1807006.0 |
| 2007-07-09 10:45:00 | SPY | ETF | 152.71 | 152.77 | 152.68 | 152.72 | 1092128.0 |
| 2007-07-09 10:50:00 | SPY | ETF | 152.72 | 152.81 | 152.66 | 152.75 | 2051700.0 |
| 2007-07-09 10:55:00 | SPY | ETF | 152.76 | 152.79 | 152.62 | 152.64 | 1129000.0 |
| 2007-07-09 11:00:00 | SPY | ETF | 152.64 | 152.88 | 152.63 | 152.86 | 1039700.0 |
| 2007-07-09 11:05:00 | SPY | ETF | 152.86 | 152.92 | 152.85 | 152.86 | 544720.0 |
> showing 50 of 16,958 rows — these rows as CSV