PREVIEW / etf_5min / 2007-02-27
file: by_date/etf_5min/2007/2007-02-27.parquet size: 386 KB rows: 16,344
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-02-27 04:05:00 | SPY | ETF | 144.52 | 144.52 | 144.52 | 144.52 | 2300.0 |
| 2007-02-27 04:50:00 | SPY | ETF | 144.47 | 144.47 | 144.47 | 144.47 | 1600.0 |
| 2007-02-27 06:00:00 | SPY | ETF | 144.6 | 144.6 | 144.6 | 144.6 | 50000.0 |
| 2007-02-27 06:10:00 | SPY | ETF | 144.49 | 144.5 | 144.49 | 144.5 | 35000.0 |
| 2007-02-27 06:15:00 | SPY | ETF | 144.5 | 144.5 | 144.49 | 144.49 | 15000.0 |
| 2007-02-27 06:25:00 | SPY | ETF | 144.52 | 144.52 | 144.5 | 144.5 | 25000.0 |
| 2007-02-27 06:30:00 | SPY | ETF | 144.51 | 144.51 | 144.51 | 144.51 | 10000.0 |
| 2007-02-27 06:35:00 | SPY | ETF | 144.57 | 144.57 | 144.54 | 144.54 | 1200.0 |
| 2007-02-27 06:45:00 | SPY | ETF | 144.48 | 144.48 | 144.48 | 144.48 | 5000.0 |
| 2007-02-27 06:50:00 | SPY | ETF | 144.44 | 144.46 | 144.44 | 144.46 | 157000.0 |
| 2007-02-27 06:55:00 | SPY | ETF | 144.47 | 144.48 | 144.47 | 144.48 | 5100.0 |
| 2007-02-27 07:00:00 | SPY | ETF | 144.5 | 144.5 | 144.42 | 144.45 | 80900.0 |
| 2007-02-27 07:05:00 | SPY | ETF | 144.44 | 144.45 | 144.29 | 144.31 | 40200.0 |
| 2007-02-27 07:10:00 | SPY | ETF | 144.31 | 144.38 | 144.3 | 144.33 | 35600.0 |
| 2007-02-27 07:15:00 | SPY | ETF | 144.33 | 144.39 | 144.3 | 144.31 | 121900.0 |
| 2007-02-27 07:20:00 | SPY | ETF | 144.35 | 144.35 | 144.29 | 144.3 | 124900.0 |
| 2007-02-27 07:25:00 | SPY | ETF | 144.29 | 144.29 | 144.2 | 144.23 | 115900.0 |
| 2007-02-27 07:30:00 | SPY | ETF | 144.23 | 144.23 | 144.15 | 144.2 | 359600.0 |
| 2007-02-27 07:35:00 | SPY | ETF | 144.29 | 144.32 | 144.27 | 144.3 | 37600.0 |
| 2007-02-27 07:40:00 | SPY | ETF | 144.32 | 144.34 | 144.3 | 144.32 | 77100.0 |
| 2007-02-27 07:45:00 | SPY | ETF | 144.32 | 144.32 | 144.26 | 144.29 | 171800.0 |
| 2007-02-27 07:50:00 | SPY | ETF | 144.29 | 144.32 | 144.24 | 144.26 | 115800.0 |
| 2007-02-27 07:55:00 | SPY | ETF | 144.26 | 144.32 | 144.24 | 144.32 | 26200.0 |
| 2007-02-27 08:00:00 | SPY | ETF | 144.29 | 144.58 | 144.26 | 144.4 | 360400.0 |
| 2007-02-27 08:05:00 | SPY | ETF | 144.38 | 144.41 | 144.27 | 144.35 | 302500.0 |
| 2007-02-27 08:10:00 | SPY | ETF | 144.35 | 144.36 | 144.25 | 144.36 | 218100.0 |
| 2007-02-27 08:15:00 | SPY | ETF | 144.33 | 144.35 | 144.27 | 144.28 | 116200.0 |
| 2007-02-27 08:20:00 | SPY | ETF | 144.27 | 144.32 | 144.27 | 144.3 | 65200.0 |
| 2007-02-27 08:25:00 | SPY | ETF | 144.28 | 144.32 | 144.26 | 144.27 | 147800.0 |
| 2007-02-27 08:30:00 | SPY | ETF | 144.26 | 144.28 | 144.01 | 144.11 | 1008500.0 |
| 2007-02-27 08:35:00 | SPY | ETF | 144.15 | 144.18 | 144.11 | 144.13 | 294300.0 |
| 2007-02-27 08:40:00 | SPY | ETF | 144.12 | 144.13 | 144.06 | 144.09 | 328000.0 |
| 2007-02-27 08:45:00 | SPY | ETF | 144.11 | 144.16 | 144.11 | 144.16 | 46800.0 |
| 2007-02-27 08:50:00 | SPY | ETF | 144.13 | 144.15 | 144.07 | 144.11 | 91100.0 |
| 2007-02-27 08:55:00 | SPY | ETF | 144.09 | 144.1 | 143.89 | 143.93 | 649400.0 |
| 2007-02-27 09:00:00 | SPY | ETF | 143.94 | 144.0 | 143.74 | 143.75 | 626800.0 |
| 2007-02-27 09:05:00 | SPY | ETF | 143.76 | 143.89 | 143.73 | 143.89 | 982300.0 |
| 2007-02-27 09:10:00 | SPY | ETF | 143.86 | 143.91 | 143.79 | 143.89 | 158800.0 |
| 2007-02-27 09:15:00 | SPY | ETF | 143.88 | 143.92 | 143.85 | 143.85 | 407400.0 |
| 2007-02-27 09:20:00 | SPY | ETF | 143.85 | 143.96 | 143.85 | 143.93 | 323300.0 |
| 2007-02-27 09:25:00 | SPY | ETF | 143.93 | 143.96 | 143.83 | 143.9 | 235500.0 |
| 2007-02-27 09:30:00 | SPY | ETF | 143.88 | 143.93 | 143.66 | 143.71 | 5114800.0 |
| 2007-02-27 09:35:00 | SPY | ETF | 143.71 | 143.79 | 143.31 | 143.42 | 4865700.0 |
| 2007-02-27 09:40:00 | SPY | ETF | 143.42 | 143.65 | 143.33 | 143.52 | 4570400.0 |
| 2007-02-27 09:45:00 | SPY | ETF | 143.52 | 143.64 | 143.45 | 143.51 | 3703800.0 |
| 2007-02-27 09:50:00 | SPY | ETF | 143.51 | 144.2 | 143.47 | 143.66 | 3156200.0 |
| 2007-02-27 09:55:00 | SPY | ETF | 143.68 | 143.69 | 143.46 | 143.58 | 2137900.0 |
| 2007-02-27 10:00:00 | SPY | ETF | 143.59 | 144.2 | 143.59 | 143.75 | 5851100.0 |
| 2007-02-27 10:05:00 | SPY | ETF | 143.76 | 143.86 | 143.5 | 143.7 | 3841800.0 |
| 2007-02-27 10:10:00 | SPY | ETF | 143.69 | 143.83 | 143.61 | 143.66 | 1403900.0 |
> showing 50 of 16,344 rows — these rows as CSV