PREVIEW / etf_1min / 2005-09-02
file: by_date/etf_1min/2005/2005-09-02.parquet size: 224 KB rows: 16,623
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-09-02 07:49:00 | SPY | ETF | 122.6 | 122.6 | 122.6 | 122.6 | 5000.0 |
| 2005-09-02 08:00:00 | SPY | ETF | 122.57 | 122.57 | 122.57 | 122.57 | 100000.0 |
| 2005-09-02 08:01:00 | SPY | ETF | 122.57 | 122.69 | 122.57 | 122.68 | 611000.0 |
| 2005-09-02 08:02:00 | SPY | ETF | 122.6 | 122.6 | 122.6 | 122.6 | 100.0 |
| 2005-09-02 08:03:00 | SPY | ETF | 122.58 | 122.58 | 122.58 | 122.58 | 5000.0 |
| 2005-09-02 08:04:00 | SPY | ETF | 122.54 | 122.54 | 122.54 | 122.54 | 1000.0 |
| 2005-09-02 08:06:00 | SPY | ETF | 122.55 | 122.58 | 122.54 | 122.58 | 10500.0 |
| 2005-09-02 08:09:00 | SPY | ETF | 122.54 | 122.54 | 122.53 | 122.53 | 10000.0 |
| 2005-09-02 08:13:00 | SPY | ETF | 122.52 | 122.52 | 122.52 | 122.52 | 5000.0 |
| 2005-09-02 08:18:00 | SPY | ETF | 122.55 | 122.55 | 122.55 | 122.55 | 100.0 |
| 2005-09-02 08:19:00 | SPY | ETF | 122.55 | 122.55 | 122.5 | 122.5 | 2700.0 |
| 2005-09-02 08:20:00 | SPY | ETF | 122.5 | 122.52 | 122.5 | 122.52 | 1100.0 |
| 2005-09-02 08:21:00 | SPY | ETF | 122.52 | 122.53 | 122.52 | 122.53 | 7800.0 |
| 2005-09-02 08:22:00 | SPY | ETF | 122.57 | 122.57 | 122.56 | 122.56 | 3200.0 |
| 2005-09-02 08:23:00 | SPY | ETF | 122.55 | 122.55 | 122.55 | 122.55 | 2100.0 |
| 2005-09-02 08:24:00 | SPY | ETF | 122.56 | 122.56 | 122.54 | 122.54 | 300.0 |
| 2005-09-02 08:25:00 | SPY | ETF | 122.53 | 122.55 | 122.53 | 122.55 | 16000.0 |
| 2005-09-02 08:26:00 | SPY | ETF | 122.53 | 122.53 | 122.52 | 122.52 | 4000.0 |
| 2005-09-02 08:27:00 | SPY | ETF | 122.51 | 122.52 | 122.5 | 122.5 | 213100.0 |
| 2005-09-02 08:28:00 | SPY | ETF | 122.69 | 122.69 | 122.69 | 122.69 | 300000.0 |
| 2005-09-02 08:29:00 | SPY | ETF | 122.51 | 122.55 | 122.5 | 122.55 | 304000.0 |
| 2005-09-02 08:30:00 | SPY | ETF | 122.48 | 122.6 | 122.41 | 122.52 | 374000.0 |
| 2005-09-02 08:31:00 | SPY | ETF | 122.47 | 122.5 | 122.39 | 122.39 | 25000.0 |
| 2005-09-02 08:32:00 | SPY | ETF | 122.43 | 122.5 | 122.43 | 122.48 | 1000.0 |
| 2005-09-02 08:33:00 | SPY | ETF | 122.46 | 122.55 | 122.46 | 122.51 | 116600.0 |
| 2005-09-02 08:34:00 | SPY | ETF | 122.53 | 122.54 | 122.52 | 122.52 | 6900.0 |
| 2005-09-02 08:35:00 | SPY | ETF | 122.55 | 122.58 | 122.55 | 122.58 | 12700.0 |
| 2005-09-02 08:36:00 | SPY | ETF | 122.61 | 122.62 | 122.6 | 122.61 | 46600.0 |
| 2005-09-02 08:37:00 | SPY | ETF | 122.64 | 122.77 | 122.64 | 122.76 | 27900.0 |
| 2005-09-02 08:38:00 | SPY | ETF | 122.78 | 122.78 | 122.66 | 122.66 | 109400.0 |
| 2005-09-02 08:39:00 | SPY | ETF | 122.67 | 122.73 | 122.67 | 122.67 | 8600.0 |
| 2005-09-02 08:40:00 | SPY | ETF | 122.66 | 122.67 | 122.63 | 122.65 | 376400.0 |
| 2005-09-02 08:41:00 | SPY | ETF | 122.66 | 122.7 | 122.66 | 122.7 | 12100.0 |
| 2005-09-02 08:42:00 | SPY | ETF | 122.68 | 122.68 | 122.68 | 122.68 | 1300.0 |
| 2005-09-02 08:43:00 | SPY | ETF | 122.69 | 122.74 | 122.65 | 122.72 | 159800.0 |
| 2005-09-02 08:44:00 | SPY | ETF | 122.73 | 122.73 | 122.71 | 122.71 | 3200.0 |
| 2005-09-02 08:45:00 | SPY | ETF | 122.75 | 122.84 | 122.75 | 122.79 | 21900.0 |
| 2005-09-02 08:46:00 | SPY | ETF | 122.81 | 122.83 | 122.73 | 122.73 | 153400.0 |
| 2005-09-02 08:47:00 | SPY | ETF | 122.74 | 122.77 | 122.73 | 122.77 | 15400.0 |
| 2005-09-02 08:48:00 | SPY | ETF | 122.75 | 122.77 | 122.75 | 122.77 | 205100.0 |
| 2005-09-02 08:49:00 | SPY | ETF | 122.75 | 122.75 | 122.72 | 122.72 | 2500.0 |
| 2005-09-02 08:50:00 | SPY | ETF | 122.72 | 122.82 | 122.71 | 122.82 | 13700.0 |
| 2005-09-02 08:51:00 | SPY | ETF | 122.79 | 122.79 | 122.79 | 122.79 | 9900.0 |
| 2005-09-02 08:52:00 | SPY | ETF | 122.77 | 122.8 | 122.77 | 122.79 | 11300.0 |
| 2005-09-02 08:53:00 | SPY | ETF | 122.81 | 122.81 | 122.8 | 122.8 | 14900.0 |
| 2005-09-02 08:54:00 | SPY | ETF | 122.81 | 122.81 | 122.81 | 122.81 | 1000.0 |
| 2005-09-02 08:55:00 | SPY | ETF | 122.81 | 122.81 | 122.81 | 122.81 | 400.0 |
| 2005-09-02 08:56:00 | SPY | ETF | 122.82 | 122.88 | 122.82 | 122.87 | 162000.0 |
| 2005-09-02 08:57:00 | SPY | ETF | 122.87 | 122.9 | 122.82 | 122.87 | 241500.0 |
| 2005-09-02 08:58:00 | SPY | ETF | 122.89 | 122.91 | 122.89 | 122.9 | 700.0 |
> showing 50 of 16,623 rows — these rows as CSV