PREVIEW / etf_5min / 2005-06-22
file: by_date/etf_5min/2005/2005-06-22.parquet size: 113 KB rows: 6,269
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-06-22 07:15:00 | SPY | ETF | 121.76 | 121.77 | 121.76 | 121.77 | 1000.0 |
| 2005-06-22 07:20:00 | SPY | ETF | 121.77 | 121.78 | 121.77 | 121.78 | 1600.0 |
| 2005-06-22 07:25:00 | SPY | ETF | 121.79 | 121.79 | 121.79 | 121.79 | 500.0 |
| 2005-06-22 07:40:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 100.0 |
| 2005-06-22 07:45:00 | SPY | ETF | 121.82 | 121.82 | 121.81 | 121.82 | 17400.0 |
| 2005-06-22 07:50:00 | SPY | ETF | 121.82 | 121.83 | 121.82 | 121.83 | 9500.0 |
| 2005-06-22 07:55:00 | SPY | ETF | 121.79 | 121.79 | 121.79 | 121.79 | 1000.0 |
| 2005-06-22 08:00:00 | SPY | ETF | 121.79 | 121.8 | 121.78 | 121.78 | 5300.0 |
| 2005-06-22 08:05:00 | SPY | ETF | 121.78 | 121.79 | 121.77 | 121.77 | 1300.0 |
| 2005-06-22 08:10:00 | SPY | ETF | 121.75 | 121.76 | 121.75 | 121.76 | 27200.0 |
| 2005-06-22 08:20:00 | SPY | ETF | 121.74 | 121.74 | 121.74 | 121.74 | 3200.0 |
| 2005-06-22 08:25:00 | SPY | ETF | 121.75 | 121.76 | 121.75 | 121.76 | 800.0 |
| 2005-06-22 08:30:00 | SPY | ETF | 121.78 | 121.78 | 121.78 | 121.78 | 500.0 |
| 2005-06-22 08:35:00 | SPY | ETF | 121.78 | 121.78 | 121.77 | 121.77 | 500.0 |
| 2005-06-22 08:40:00 | SPY | ETF | 121.77 | 121.78 | 121.77 | 121.77 | 12600.0 |
| 2005-06-22 08:45:00 | SPY | ETF | 121.78 | 121.78 | 121.78 | 121.78 | 800.0 |
| 2005-06-22 08:55:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 2700.0 |
| 2005-06-22 09:00:00 | SPY | ETF | 121.79 | 121.8 | 121.79 | 121.79 | 13300.0 |
| 2005-06-22 09:05:00 | SPY | ETF | 121.78 | 121.78 | 121.76 | 121.76 | 1900.0 |
| 2005-06-22 09:10:00 | SPY | ETF | 121.77 | 121.77 | 121.75 | 121.75 | 36200.0 |
| 2005-06-22 09:15:00 | SPY | ETF | 121.75 | 121.76 | 121.75 | 121.76 | 2600.0 |
| 2005-06-22 09:20:00 | SPY | ETF | 121.76 | 121.78 | 121.75 | 121.76 | 23300.0 |
| 2005-06-22 09:25:00 | SPY | ETF | 121.75 | 121.76 | 121.69 | 121.69 | 28600.0 |
| 2005-06-22 09:30:00 | SPY | ETF | 121.68 | 121.9 | 121.65 | 121.86 | 1535000.0 |
| 2005-06-22 09:35:00 | SPY | ETF | 121.86 | 121.94 | 121.8 | 121.8 | 1112600.0 |
| 2005-06-22 09:40:00 | SPY | ETF | 121.81 | 121.88 | 121.72 | 121.75 | 1311300.0 |
| 2005-06-22 09:45:00 | SPY | ETF | 121.75 | 121.8 | 121.62 | 121.63 | 735700.0 |
| 2005-06-22 09:50:00 | SPY | ETF | 121.64 | 121.71 | 121.59 | 121.67 | 597900.0 |
| 2005-06-22 09:55:00 | SPY | ETF | 121.67 | 121.75 | 121.61 | 121.62 | 474500.0 |
| 2005-06-22 10:00:00 | SPY | ETF | 121.63 | 121.64 | 121.46 | 121.55 | 659200.0 |
| 2005-06-22 10:05:00 | SPY | ETF | 121.54 | 121.59 | 121.52 | 121.59 | 517000.0 |
| 2005-06-22 10:10:00 | SPY | ETF | 121.59 | 121.62 | 121.53 | 121.57 | 213200.0 |
| 2005-06-22 10:15:00 | SPY | ETF | 121.56 | 121.59 | 121.48 | 121.59 | 297600.0 |
| 2005-06-22 10:20:00 | SPY | ETF | 121.57 | 121.85 | 121.55 | 121.6494 | 518000.0 |
| 2005-06-22 10:25:00 | SPY | ETF | 121.65 | 121.65 | 121.53 | 121.56 | 222200.0 |
| 2005-06-22 10:30:00 | SPY | ETF | 121.54 | 121.73 | 121.52 | 121.71 | 955500.0 |
| 2005-06-22 10:35:00 | SPY | ETF | 121.72 | 121.76 | 121.62 | 121.67 | 600000.0 |
| 2005-06-22 10:40:00 | SPY | ETF | 121.67 | 121.7 | 121.52 | 121.52 | 611400.0 |
| 2005-06-22 10:45:00 | SPY | ETF | 121.51 | 121.61 | 121.38 | 121.38 | 897200.0 |
| 2005-06-22 10:50:00 | SPY | ETF | 121.38 | 121.42 | 121.26 | 121.28 | 977000.0 |
| 2005-06-22 10:55:00 | SPY | ETF | 121.28 | 121.31 | 121.16 | 121.23 | 1010100.0 |
| 2005-06-22 11:00:00 | SPY | ETF | 121.25 | 121.3 | 121.18 | 121.2193 | 392400.0 |
| 2005-06-22 11:05:00 | SPY | ETF | 121.22 | 121.23 | 121.1 | 121.18 | 920000.0 |
| 2005-06-22 11:10:00 | SPY | ETF | 121.18 | 121.27 | 121.18 | 121.22 | 363700.0 |
| 2005-06-22 11:15:00 | SPY | ETF | 121.22 | 121.27 | 121.19 | 121.23 | 233600.0 |
| 2005-06-22 11:20:00 | SPY | ETF | 121.23 | 121.3 | 121.2 | 121.27 | 284200.0 |
| 2005-06-22 11:25:00 | SPY | ETF | 121.27 | 121.36 | 121.22 | 121.3 | 643400.0 |
| 2005-06-22 11:30:00 | SPY | ETF | 121.31 | 121.31 | 121.22 | 121.28 | 242200.0 |
| 2005-06-22 11:35:00 | SPY | ETF | 121.28 | 121.35 | 121.25 | 121.29 | 393600.0 |
| 2005-06-22 11:40:00 | SPY | ETF | 121.29 | 121.33 | 121.23 | 121.29 | 274000.0 |
> showing 50 of 6,269 rows — these rows as CSV