PREVIEW / etf_5min / 2005-11-14
file: by_date/etf_5min/2005/2005-11-14.parquet size: 133 KB rows: 7,245
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-14 07:05:00 | SPY | ETF | 123.74 | 123.74 | 123.74 | 123.74 | 500.0 |
| 2005-11-14 07:10:00 | SPY | ETF | 123.74 | 123.74 | 123.74 | 123.74 | 3000.0 |
| 2005-11-14 07:20:00 | SPY | ETF | 123.73 | 123.73 | 123.73 | 123.73 | 100.0 |
| 2005-11-14 07:25:00 | SPY | ETF | 123.72 | 123.72 | 123.72 | 123.72 | 100.0 |
| 2005-11-14 07:35:00 | SPY | ETF | 123.71 | 123.71 | 123.71 | 123.71 | 500.0 |
| 2005-11-14 07:40:00 | SPY | ETF | 123.7 | 123.7 | 123.7 | 123.7 | 33200.0 |
| 2005-11-14 07:50:00 | SPY | ETF | 123.69 | 123.7 | 123.69 | 123.69 | 70500.0 |
| 2005-11-14 08:00:00 | SPY | ETF | 123.69 | 123.73 | 123.65 | 123.69 | 150900.0 |
| 2005-11-14 08:05:00 | SPY | ETF | 123.7 | 123.7 | 123.66 | 123.69 | 8400.0 |
| 2005-11-14 08:10:00 | SPY | ETF | 123.68 | 123.69 | 123.68 | 123.69 | 2600.0 |
| 2005-11-14 08:15:00 | SPY | ETF | 123.7 | 123.7 | 123.67 | 123.69 | 219400.0 |
| 2005-11-14 08:20:00 | SPY | ETF | 123.73 | 123.75 | 123.7 | 123.73 | 25200.0 |
| 2005-11-14 08:25:00 | SPY | ETF | 123.73 | 123.73 | 123.7 | 123.7 | 14700.0 |
| 2005-11-14 08:30:00 | SPY | ETF | 123.68 | 123.7 | 123.68 | 123.7 | 21000.0 |
| 2005-11-14 08:35:00 | SPY | ETF | 123.67 | 123.67 | 123.67 | 123.67 | 26300.0 |
| 2005-11-14 08:40:00 | SPY | ETF | 123.7 | 123.73 | 123.7 | 123.73 | 12100.0 |
| 2005-11-14 08:45:00 | SPY | ETF | 123.73 | 123.75 | 123.73 | 123.75 | 10300.0 |
| 2005-11-14 08:50:00 | SPY | ETF | 123.75 | 123.75 | 123.74 | 123.74 | 900.0 |
| 2005-11-14 08:55:00 | SPY | ETF | 123.71 | 123.71 | 123.7 | 123.7 | 24900.0 |
| 2005-11-14 09:00:00 | SPY | ETF | 123.72 | 123.72 | 123.71 | 123.71 | 1400.0 |
| 2005-11-14 09:05:00 | SPY | ETF | 123.75 | 123.77 | 123.75 | 123.77 | 17400.0 |
| 2005-11-14 09:10:00 | SPY | ETF | 123.76 | 123.76 | 123.75 | 123.76 | 5700.0 |
| 2005-11-14 09:15:00 | SPY | ETF | 123.75 | 123.76 | 123.75 | 123.76 | 31000.0 |
| 2005-11-14 09:20:00 | SPY | ETF | 123.76 | 123.78 | 123.76 | 123.78 | 61900.0 |
| 2005-11-14 09:25:00 | SPY | ETF | 123.78 | 123.8 | 123.77 | 123.78 | 221600.0 |
| 2005-11-14 09:30:00 | SPY | ETF | 123.76 | 123.8 | 123.63 | 123.69 | 913100.0 |
| 2005-11-14 09:35:00 | SPY | ETF | 123.69 | 123.72 | 123.65 | 123.67 | 1072900.0 |
| 2005-11-14 09:40:00 | SPY | ETF | 123.67 | 123.78 | 123.67 | 123.69 | 550500.0 |
| 2005-11-14 09:45:00 | SPY | ETF | 123.7 | 123.9 | 123.7 | 123.86 | 1632300.0 |
| 2005-11-14 09:50:00 | SPY | ETF | 123.86 | 123.88 | 123.75 | 123.75 | 1346800.0 |
| 2005-11-14 09:55:00 | SPY | ETF | 123.77 | 123.82 | 123.69 | 123.78 | 1324500.0 |
| 2005-11-14 10:00:00 | SPY | ETF | 123.79 | 123.8 | 123.7 | 123.7 | 1047600.0 |
| 2005-11-14 10:05:00 | SPY | ETF | 123.71 | 123.79 | 123.7 | 123.78 | 344300.0 |
| 2005-11-14 10:10:00 | SPY | ETF | 123.77 | 123.94 | 123.73 | 123.92 | 836400.0 |
| 2005-11-14 10:15:00 | SPY | ETF | 123.92 | 124.02 | 123.89 | 123.9 | 2976600.0 |
| 2005-11-14 10:20:00 | SPY | ETF | 123.91 | 123.97 | 123.84 | 123.85 | 295100.0 |
| 2005-11-14 10:25:00 | SPY | ETF | 123.84 | 123.89 | 123.71 | 123.71 | 896500.0 |
| 2005-11-14 10:30:00 | SPY | ETF | 123.72 | 123.85 | 123.7 | 123.84 | 945400.0 |
| 2005-11-14 10:35:00 | SPY | ETF | 123.85 | 123.91 | 123.77 | 123.81 | 265900.0 |
| 2005-11-14 10:40:00 | SPY | ETF | 123.84 | 123.88 | 123.81 | 123.81 | 397300.0 |
| 2005-11-14 10:45:00 | SPY | ETF | 123.81 | 123.83 | 123.76 | 123.79 | 537800.0 |
| 2005-11-14 10:50:00 | SPY | ETF | 123.8 | 123.82 | 123.72 | 123.73 | 249000.0 |
| 2005-11-14 10:55:00 | SPY | ETF | 123.72 | 123.77 | 123.67 | 123.69 | 434700.0 |
| 2005-11-14 11:00:00 | SPY | ETF | 123.67 | 123.75 | 123.65 | 123.72 | 494500.0 |
| 2005-11-14 11:05:00 | SPY | ETF | 123.71 | 123.74 | 123.67 | 123.69 | 265400.0 |
| 2005-11-14 11:10:00 | SPY | ETF | 123.68 | 123.74 | 123.62 | 123.69 | 548300.0 |
| 2005-11-14 11:15:00 | SPY | ETF | 123.69 | 123.8 | 123.67 | 123.75 | 875000.0 |
| 2005-11-14 11:20:00 | SPY | ETF | 123.76 | 123.78 | 123.69 | 123.72 | 1208600.0 |
| 2005-11-14 11:25:00 | SPY | ETF | 123.71 | 123.78 | 123.68 | 123.72 | 176300.0 |
| 2005-11-14 11:30:00 | SPY | ETF | 123.73 | 123.74 | 123.67 | 123.69 | 156400.0 |
> showing 50 of 7,245 rows — these rows as CSV