PREVIEW / etf_5min / 2009-10-06
file: by_date/etf_5min/2009/2009-10-06.parquet size: 764 KB rows: 31,630
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-06 04:15:00 | SPY | ETF | 104.3 | 104.43 | 104.3 | 104.43 | 500.0 |
| 2009-10-06 04:20:00 | SPY | ETF | 104.47 | 104.47 | 104.47 | 104.47 | 100.0 |
| 2009-10-06 04:40:00 | SPY | ETF | 104.49 | 104.52 | 104.49 | 104.52 | 600.0 |
| 2009-10-06 04:45:00 | SPY | ETF | 104.53 | 104.53 | 104.53 | 104.53 | 100.0 |
| 2009-10-06 05:00:00 | SPY | ETF | 104.53 | 104.7 | 104.53 | 104.7 | 1200.0 |
| 2009-10-06 05:05:00 | SPY | ETF | 104.73 | 104.77 | 104.72 | 104.75 | 6400.0 |
| 2009-10-06 05:10:00 | SPY | ETF | 104.74 | 104.89 | 104.74 | 104.89 | 1659.0 |
| 2009-10-06 05:15:00 | SPY | ETF | 104.79 | 104.95 | 104.79 | 104.95 | 2400.0 |
| 2009-10-06 05:20:00 | SPY | ETF | 104.97 | 105.13 | 104.97 | 105.02 | 5090.0 |
| 2009-10-06 05:25:00 | SPY | ETF | 105.07 | 105.1 | 105.04 | 105.07 | 6600.0 |
| 2009-10-06 05:30:00 | SPY | ETF | 105.03 | 105.03 | 105.03 | 105.03 | 100.0 |
| 2009-10-06 05:35:00 | SPY | ETF | 104.95 | 104.95 | 104.95 | 104.95 | 100.0 |
| 2009-10-06 05:45:00 | SPY | ETF | 105.0 | 105.0 | 105.0 | 105.0 | 100.0 |
| 2009-10-06 05:50:00 | SPY | ETF | 104.92 | 104.92 | 104.92 | 104.92 | 100.0 |
| 2009-10-06 05:55:00 | SPY | ETF | 104.95 | 104.97 | 104.95 | 104.97 | 300.0 |
| 2009-10-06 06:00:00 | SPY | ETF | 104.86 | 104.88 | 104.86 | 104.87 | 17200.0 |
| 2009-10-06 06:05:00 | SPY | ETF | 104.9 | 104.9 | 104.9 | 104.9 | 1000.0 |
| 2009-10-06 06:10:00 | SPY | ETF | 104.9 | 104.9 | 104.9 | 104.9 | 500.0 |
| 2009-10-06 06:20:00 | SPY | ETF | 104.95 | 104.95 | 104.93 | 104.93 | 500.0 |
| 2009-10-06 06:25:00 | SPY | ETF | 105.0 | 105.04 | 104.98 | 104.99 | 4200.0 |
| 2009-10-06 06:30:00 | SPY | ETF | 105.0 | 105.05 | 105.0 | 105.05 | 400.0 |
| 2009-10-06 06:35:00 | SPY | ETF | 105.12 | 105.15 | 105.1 | 105.15 | 5060.0 |
| 2009-10-06 06:50:00 | SPY | ETF | 105.1 | 105.1 | 105.05 | 105.05 | 8500.0 |
| 2009-10-06 06:55:00 | SPY | ETF | 105.09 | 105.1 | 105.09 | 105.1 | 350.0 |
| 2009-10-06 07:00:00 | SPY | ETF | 105.08 | 105.1 | 105.05 | 105.08 | 77900.0 |
| 2009-10-06 07:05:00 | SPY | ETF | 105.1 | 105.1 | 105.07 | 105.08 | 63525.0 |
| 2009-10-06 07:10:00 | SPY | ETF | 105.08 | 105.08 | 105.0 | 105.0 | 120295.0 |
| 2009-10-06 07:15:00 | SPY | ETF | 105.0 | 105.09 | 105.0 | 105.09 | 349752.0 |
| 2009-10-06 07:20:00 | SPY | ETF | 105.05 | 105.06 | 105.0 | 105.03 | 102060.0 |
| 2009-10-06 07:25:00 | SPY | ETF | 105.03 | 105.08 | 105.02 | 105.08 | 29770.0 |
| 2009-10-06 07:30:00 | SPY | ETF | 105.08 | 105.13 | 105.07 | 105.09 | 116420.0 |
| 2009-10-06 07:35:00 | SPY | ETF | 105.1 | 105.1 | 105.07 | 105.07 | 9800.0 |
| 2009-10-06 07:40:00 | SPY | ETF | 105.06 | 105.1 | 105.06 | 105.1 | 16415.0 |
| 2009-10-06 07:45:00 | SPY | ETF | 105.08 | 105.16 | 105.08 | 105.1 | 184760.0 |
| 2009-10-06 07:50:00 | SPY | ETF | 105.11 | 105.23 | 105.1 | 105.19 | 50885.0 |
| 2009-10-06 07:55:00 | SPY | ETF | 105.15 | 105.15 | 105.12 | 105.12 | 31609.0 |
| 2009-10-06 08:00:00 | SPY | ETF | 105.1 | 105.13 | 105.01 | 105.02 | 611629.0 |
| 2009-10-06 08:05:00 | SPY | ETF | 105.01 | 105.02 | 104.95 | 105.0 | 197340.0 |
| 2009-10-06 08:10:00 | SPY | ETF | 105.0 | 105.03 | 104.89 | 104.92 | 168446.0 |
| 2009-10-06 08:15:00 | SPY | ETF | 104.94 | 104.96 | 104.92 | 104.95 | 119411.0 |
| 2009-10-06 08:20:00 | SPY | ETF | 104.94 | 105.0 | 104.91 | 104.96 | 203984.0 |
| 2009-10-06 08:25:00 | SPY | ETF | 104.97 | 105.01 | 104.92 | 104.97 | 243422.0 |
| 2009-10-06 08:30:00 | SPY | ETF | 104.98 | 104.99 | 104.91 | 104.99 | 131699.0 |
| 2009-10-06 08:35:00 | SPY | ETF | 105.0 | 105.02 | 104.91 | 104.92 | 160931.0 |
| 2009-10-06 08:40:00 | SPY | ETF | 104.92 | 104.94 | 104.02 | 104.89 | 130020.0 |
| 2009-10-06 08:45:00 | SPY | ETF | 104.89 | 104.91 | 104.86 | 104.87 | 59795.0 |
| 2009-10-06 08:50:00 | SPY | ETF | 104.86 | 104.93 | 104.85 | 104.91 | 165676.0 |
| 2009-10-06 08:55:00 | SPY | ETF | 104.9 | 105.04 | 104.51 | 104.91 | 285011.0 |
| 2009-10-06 09:00:00 | SPY | ETF | 104.91 | 104.99 | 104.9 | 104.98 | 260326.0 |
| 2009-10-06 09:05:00 | SPY | ETF | 104.96 | 104.97 | 104.93 | 104.96 | 385858.0 |
> showing 50 of 31,630 rows — these rows as CSV