PREVIEW / etf_5min / 2007-12-07
file: by_date/etf_5min/2007/2007-12-07.parquet size: 384 KB rows: 19,816
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-12-07 05:50:00 | SPY | ETF | 150.63 | 150.63 | 150.55 | 150.55 | 10500.0 |
| 2007-12-07 06:15:00 | SPY | ETF | 150.75 | 150.8 | 150.75 | 150.8 | 6000.0 |
| 2007-12-07 06:20:00 | SPY | ETF | 150.84 | 150.84 | 150.84 | 150.84 | 200.0 |
| 2007-12-07 06:25:00 | SPY | ETF | 150.91 | 150.94 | 150.82 | 150.94 | 5500.0 |
| 2007-12-07 06:40:00 | SPY | ETF | 150.94 | 150.94 | 150.94 | 150.94 | 10000.0 |
| 2007-12-07 06:50:00 | SPY | ETF | 150.8 | 150.8 | 150.8 | 150.8 | 1500.0 |
| 2007-12-07 07:00:00 | SPY | ETF | 150.91 | 150.94 | 150.91 | 150.94 | 7000.0 |
| 2007-12-07 07:05:00 | SPY | ETF | 150.91 | 150.91 | 150.85 | 150.88 | 32600.0 |
| 2007-12-07 07:10:00 | SPY | ETF | 150.93 | 150.93 | 150.88 | 150.91 | 17600.0 |
| 2007-12-07 07:15:00 | SPY | ETF | 150.98 | 151.03 | 150.95 | 150.95 | 81500.0 |
| 2007-12-07 07:20:00 | SPY | ETF | 150.96 | 150.96 | 150.88 | 150.88 | 5600.0 |
| 2007-12-07 07:25:00 | SPY | ETF | 150.84 | 150.84 | 150.69 | 150.73 | 72500.0 |
| 2007-12-07 07:30:00 | SPY | ETF | 150.71 | 150.83 | 150.71 | 150.73 | 1200.0 |
| 2007-12-07 07:35:00 | SPY | ETF | 150.75 | 150.83 | 150.75 | 150.83 | 52700.0 |
| 2007-12-07 07:40:00 | SPY | ETF | 150.83 | 150.85 | 150.8 | 150.83 | 17000.0 |
| 2007-12-07 07:45:00 | SPY | ETF | 150.8 | 150.8 | 150.77 | 150.77 | 5900.0 |
| 2007-12-07 07:50:00 | SPY | ETF | 150.79 | 150.83 | 150.77 | 150.8 | 22700.0 |
| 2007-12-07 07:55:00 | SPY | ETF | 150.83 | 150.91 | 150.83 | 150.88 | 13700.0 |
| 2007-12-07 08:00:00 | SPY | ETF | 150.88 | 150.92 | 150.85 | 150.86 | 4348400.0 |
| 2007-12-07 08:05:00 | SPY | ETF | 150.88 | 151.03 | 150.86 | 151.02 | 38500.0 |
| 2007-12-07 08:10:00 | SPY | ETF | 151.03 | 151.1 | 150.97 | 151.06 | 1280800.0 |
| 2007-12-07 08:15:00 | SPY | ETF | 151.06 | 151.2 | 151.05 | 151.14 | 150000.0 |
| 2007-12-07 08:20:00 | SPY | ETF | 151.14 | 151.3 | 151.1 | 151.17 | 546300.0 |
| 2007-12-07 08:25:00 | SPY | ETF | 151.16 | 151.26 | 151.13 | 151.19 | 862300.0 |
| 2007-12-07 08:30:00 | SPY | ETF | 151.21 | 151.68 | 150.92 | 151.6 | 9834000.0 |
| 2007-12-07 08:35:00 | SPY | ETF | 151.6 | 151.62 | 151.37 | 151.44 | 1775800.0 |
| 2007-12-07 08:40:00 | SPY | ETF | 151.44 | 151.45 | 150.6 | 151.38 | 1769600.0 |
| 2007-12-07 08:45:00 | SPY | ETF | 151.38 | 151.55 | 150.33 | 151.5 | 971400.0 |
| 2007-12-07 08:50:00 | SPY | ETF | 151.5 | 151.57 | 151.45 | 151.46 | 482800.0 |
| 2007-12-07 08:55:00 | SPY | ETF | 151.47 | 151.51 | 151.37 | 151.41 | 296300.0 |
| 2007-12-07 09:00:00 | SPY | ETF | 151.41 | 151.47 | 151.38 | 151.43 | 252300.0 |
| 2007-12-07 09:05:00 | SPY | ETF | 151.43 | 151.63 | 151.42 | 151.6 | 184000.0 |
| 2007-12-07 09:10:00 | SPY | ETF | 151.63 | 151.63 | 151.55 | 151.56 | 302700.0 |
| 2007-12-07 09:15:00 | SPY | ETF | 151.57 | 151.58 | 151.5 | 151.53 | 189900.0 |
| 2007-12-07 09:20:00 | SPY | ETF | 151.51 | 151.54 | 151.48 | 151.49 | 311500.0 |
| 2007-12-07 09:25:00 | SPY | ETF | 151.47 | 151.51 | 151.37 | 151.41 | 497700.0 |
| 2007-12-07 09:30:00 | SPY | ETF | 151.42 | 151.47 | 151.13 | 151.13 | 5071683.0 |
| 2007-12-07 09:35:00 | SPY | ETF | 151.13 | 151.3199 | 151.04 | 151.21 | 4742216.0 |
| 2007-12-07 09:40:00 | SPY | ETF | 151.21 | 151.4 | 151.2 | 151.39 | 3504395.0 |
| 2007-12-07 09:45:00 | SPY | ETF | 151.4 | 151.5 | 151.28 | 151.28 | 3734083.0 |
| 2007-12-07 09:50:00 | SPY | ETF | 151.27 | 151.313 | 151.0 | 151.16 | 2713357.0 |
| 2007-12-07 09:55:00 | SPY | ETF | 151.16 | 151.28 | 151.05 | 151.17 | 3639805.0 |
| 2007-12-07 10:00:00 | SPY | ETF | 151.17 | 151.36 | 151.09 | 151.27 | 2778033.0 |
| 2007-12-07 10:05:00 | SPY | ETF | 151.27 | 151.3 | 151.0 | 151.12 | 2597743.0 |
| 2007-12-07 10:10:00 | SPY | ETF | 151.12 | 151.27 | 151.04 | 151.22 | 1606581.0 |
| 2007-12-07 10:15:00 | SPY | ETF | 151.22 | 151.25 | 151.08 | 151.23 | 1004353.0 |
| 2007-12-07 10:20:00 | SPY | ETF | 151.23 | 151.24 | 151.06 | 151.1 | 1421840.0 |
| 2007-12-07 10:25:00 | SPY | ETF | 151.1 | 151.22 | 150.89 | 150.94 | 2563187.0 |
| 2007-12-07 10:30:00 | SPY | ETF | 150.93 | 150.98 | 150.81 | 150.89 | 3191461.0 |
| 2007-12-07 10:35:00 | SPY | ETF | 150.89 | 150.9799 | 150.86 | 150.93 | 2144777.0 |
> showing 50 of 19,816 rows — these rows as CSV