PREVIEW / etf_5min / 2007-08-30
file: by_date/etf_5min/2007/2007-08-30.parquet size: 348 KB rows: 16,482
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-08-30 04:40:00 | SPY | ETF | 146.34 | 146.34 | 146.34 | 146.34 | 1000.0 |
| 2007-08-30 04:45:00 | SPY | ETF | 146.36 | 146.36 | 146.36 | 146.36 | 1000.0 |
| 2007-08-30 04:55:00 | SPY | ETF | 146.44 | 146.44 | 146.44 | 146.44 | 500.0 |
| 2007-08-30 05:50:00 | SPY | ETF | 146.12 | 146.12 | 146.12 | 146.12 | 500.0 |
| 2007-08-30 05:55:00 | SPY | ETF | 145.87 | 145.87 | 145.87 | 145.87 | 1000.0 |
| 2007-08-30 06:00:00 | SPY | ETF | 145.86 | 145.88 | 145.86 | 145.88 | 3500.0 |
| 2007-08-30 06:05:00 | SPY | ETF | 145.82 | 145.82 | 145.82 | 145.82 | 1000.0 |
| 2007-08-30 06:10:00 | SPY | ETF | 145.8 | 145.8 | 145.8 | 145.8 | 1000.0 |
| 2007-08-30 06:45:00 | SPY | ETF | 145.81 | 145.87 | 145.81 | 145.86 | 11700.0 |
| 2007-08-30 06:50:00 | SPY | ETF | 145.84 | 145.88 | 145.77 | 145.8 | 31500.0 |
| 2007-08-30 06:55:00 | SPY | ETF | 145.76 | 145.77 | 145.6 | 145.61 | 265000.0 |
| 2007-08-30 07:00:00 | SPY | ETF | 145.66 | 145.8 | 145.6 | 145.79 | 277900.0 |
| 2007-08-30 07:05:00 | SPY | ETF | 145.79 | 145.87 | 145.79 | 145.8 | 42200.0 |
| 2007-08-30 07:10:00 | SPY | ETF | 145.87 | 145.87 | 145.87 | 145.87 | 50000.0 |
| 2007-08-30 07:15:00 | SPY | ETF | 145.92 | 145.95 | 145.88 | 145.95 | 80300.0 |
| 2007-08-30 07:20:00 | SPY | ETF | 145.93 | 145.93 | 145.8 | 145.87 | 162300.0 |
| 2007-08-30 07:25:00 | SPY | ETF | 145.8 | 145.82 | 145.77 | 145.77 | 91500.0 |
| 2007-08-30 07:30:00 | SPY | ETF | 145.76 | 145.82 | 145.72 | 145.8 | 65700.0 |
| 2007-08-30 07:35:00 | SPY | ETF | 145.8 | 145.8 | 145.7 | 145.79 | 74700.0 |
| 2007-08-30 07:40:00 | SPY | ETF | 145.8 | 145.8 | 145.74 | 145.8 | 47600.0 |
| 2007-08-30 07:45:00 | SPY | ETF | 145.87 | 145.89 | 145.74 | 145.79 | 76200.0 |
| 2007-08-30 07:50:00 | SPY | ETF | 145.8 | 145.9 | 145.8 | 145.9 | 19600.0 |
| 2007-08-30 07:55:00 | SPY | ETF | 145.92 | 145.98 | 145.92 | 145.95 | 53200.0 |
| 2007-08-30 08:00:00 | SPY | ETF | 146.0 | 146.06 | 145.85 | 145.89 | 896900.0 |
| 2007-08-30 08:05:00 | SPY | ETF | 145.88 | 146.01 | 145.86 | 145.95 | 115100.0 |
| 2007-08-30 08:10:00 | SPY | ETF | 145.95 | 145.97 | 145.9 | 145.92 | 58700.0 |
| 2007-08-30 08:15:00 | SPY | ETF | 145.91 | 145.92 | 145.74 | 145.76 | 437900.0 |
| 2007-08-30 08:20:00 | SPY | ETF | 145.74 | 145.82 | 145.73 | 145.77 | 483100.0 |
| 2007-08-30 08:25:00 | SPY | ETF | 145.79 | 145.86 | 145.75 | 145.75 | 174800.0 |
| 2007-08-30 08:30:00 | SPY | ETF | 145.77 | 146.05 | 145.7 | 146.0 | 1071300.0 |
| 2007-08-30 08:35:00 | SPY | ETF | 146.0 | 146.12 | 145.77 | 145.77 | 898300.0 |
| 2007-08-30 08:40:00 | SPY | ETF | 145.78 | 145.89 | 145.78 | 145.87 | 82600.0 |
| 2007-08-30 08:45:00 | SPY | ETF | 145.85 | 145.94 | 145.8 | 145.93 | 351600.0 |
| 2007-08-30 08:50:00 | SPY | ETF | 145.92 | 145.97 | 145.87 | 145.87 | 76800.0 |
| 2007-08-30 08:55:00 | SPY | ETF | 145.87 | 145.92 | 145.79 | 145.84 | 105500.0 |
| 2007-08-30 09:00:00 | SPY | ETF | 145.84 | 145.84 | 145.71 | 145.75 | 147600.0 |
| 2007-08-30 09:05:00 | SPY | ETF | 145.74 | 145.74 | 145.63 | 145.69 | 339700.0 |
| 2007-08-30 09:10:00 | SPY | ETF | 145.69 | 145.69 | 145.42 | 145.44 | 2044500.0 |
| 2007-08-30 09:15:00 | SPY | ETF | 145.46 | 146.3 | 145.41 | 145.43 | 365900.0 |
| 2007-08-30 09:20:00 | SPY | ETF | 145.43 | 145.52 | 145.43 | 145.5 | 111100.0 |
| 2007-08-30 09:25:00 | SPY | ETF | 145.49 | 145.5 | 145.41 | 145.45 | 383700.0 |
| 2007-08-30 09:30:00 | SPY | ETF | 145.45 | 145.58 | 145.31 | 145.58 | 4723106.0 |
| 2007-08-30 09:35:00 | SPY | ETF | 145.58 | 145.82 | 145.47 | 145.79 | 3609300.0 |
| 2007-08-30 09:40:00 | SPY | ETF | 145.78 | 145.88 | 145.67 | 145.76 | 6872400.0 |
| 2007-08-30 09:45:00 | SPY | ETF | 145.76 | 146.01 | 145.71 | 145.91 | 5001800.0 |
| 2007-08-30 09:50:00 | SPY | ETF | 145.92 | 146.34 | 145.87 | 146.17 | 4670800.0 |
| 2007-08-30 09:55:00 | SPY | ETF | 146.16 | 146.3 | 146.02 | 146.05 | 4355600.0 |
| 2007-08-30 10:00:00 | SPY | ETF | 146.051 | 146.18 | 145.87 | 146.03 | 3770500.0 |
| 2007-08-30 10:05:00 | SPY | ETF | 146.02 | 146.47 | 146.02 | 146.34 | 3956600.0 |
| 2007-08-30 10:10:00 | SPY | ETF | 146.34 | 146.42 | 146.07 | 146.13 | 2118100.0 |
> showing 50 of 16,482 rows — these rows as CSV