PREVIEW / etf_1min / 2009-09-21
file: by_date/etf_1min/2009/2009-09-21.parquet size: 1.6 MB rows: 86,898
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-21 04:15:00 | SPY | ETF | 105.92 | 105.94 | 105.89 | 105.89 | 7675.0 |
| 2009-09-21 04:16:00 | SPY | ETF | 105.89 | 105.89 | 105.89 | 105.89 | 495.0 |
| 2009-09-21 04:17:00 | SPY | ETF | 105.89 | 105.89 | 105.89 | 105.89 | 300.0 |
| 2009-09-21 04:18:00 | SPY | ETF | 105.94 | 105.94 | 105.94 | 105.94 | 1000.0 |
| 2009-09-21 04:30:00 | SPY | ETF | 106.07 | 106.09 | 106.07 | 106.09 | 300.0 |
| 2009-09-21 04:34:00 | SPY | ETF | 106.07 | 106.07 | 106.07 | 106.07 | 300.0 |
| 2009-09-21 04:38:00 | SPY | ETF | 106.12 | 106.12 | 106.1 | 106.1 | 600.0 |
| 2009-09-21 04:39:00 | SPY | ETF | 106.11 | 106.11 | 106.06 | 106.09 | 550.0 |
| 2009-09-21 04:49:00 | SPY | ETF | 105.98 | 105.98 | 105.98 | 105.98 | 200.0 |
| 2009-09-21 04:54:00 | SPY | ETF | 105.9 | 105.9 | 105.88 | 105.88 | 800.0 |
| 2009-09-21 04:55:00 | SPY | ETF | 105.85 | 105.85 | 105.85 | 105.85 | 200.0 |
| 2009-09-21 05:00:00 | SPY | ETF | 105.85 | 105.85 | 105.82 | 105.84 | 568.0 |
| 2009-09-21 05:01:00 | SPY | ETF | 105.82 | 105.82 | 105.82 | 105.82 | 200.0 |
| 2009-09-21 05:05:00 | SPY | ETF | 105.83 | 105.83 | 105.81 | 105.81 | 649.0 |
| 2009-09-21 05:18:00 | SPY | ETF | 105.87 | 105.87 | 105.87 | 105.87 | 500.0 |
| 2009-09-21 05:22:00 | SPY | ETF | 105.8 | 105.8 | 105.8 | 105.8 | 200.0 |
| 2009-09-21 05:23:00 | SPY | ETF | 105.8 | 105.8 | 105.8 | 105.8 | 525.0 |
| 2009-09-21 05:30:00 | SPY | ETF | 105.79 | 105.79 | 105.77 | 105.77 | 1700.0 |
| 2009-09-21 05:36:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 400.0 |
| 2009-09-21 05:37:00 | SPY | ETF | 105.73 | 105.73 | 105.73 | 105.73 | 200.0 |
| 2009-09-21 05:46:00 | SPY | ETF | 105.72 | 105.72 | 105.72 | 105.72 | 100.0 |
| 2009-09-21 05:50:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 1000.0 |
| 2009-09-21 05:52:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 2000.0 |
| 2009-09-21 05:53:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 1000.0 |
| 2009-09-21 05:54:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 200.0 |
| 2009-09-21 06:05:00 | SPY | ETF | 105.82 | 105.82 | 105.82 | 105.82 | 1000.0 |
| 2009-09-21 06:08:00 | SPY | ETF | 105.88 | 105.88 | 105.88 | 105.88 | 200.0 |
| 2009-09-21 06:10:00 | SPY | ETF | 105.8 | 105.81 | 105.8 | 105.81 | 600.0 |
| 2009-09-21 06:15:00 | SPY | ETF | 105.8 | 105.8 | 105.8 | 105.8 | 200.0 |
| 2009-09-21 06:16:00 | SPY | ETF | 105.79 | 105.79 | 105.79 | 105.79 | 2500.0 |
| 2009-09-21 06:20:00 | SPY | ETF | 105.74 | 105.74 | 105.74 | 105.74 | 10000.0 |
| 2009-09-21 06:35:00 | SPY | ETF | 105.78 | 105.78 | 105.78 | 105.78 | 2500.0 |
| 2009-09-21 06:41:00 | SPY | ETF | 105.84 | 105.84 | 105.84 | 105.84 | 100.0 |
| 2009-09-21 06:44:00 | SPY | ETF | 105.85 | 105.85 | 105.85 | 105.85 | 400.0 |
| 2009-09-21 06:45:00 | SPY | ETF | 105.94 | 105.94 | 105.94 | 105.94 | 2000.0 |
| 2009-09-21 06:51:00 | SPY | ETF | 105.95 | 105.95 | 105.94 | 105.94 | 5500.0 |
| 2009-09-21 06:52:00 | SPY | ETF | 105.93 | 105.93 | 105.91 | 105.91 | 3100.0 |
| 2009-09-21 06:57:00 | SPY | ETF | 105.91 | 105.91 | 105.91 | 105.91 | 1100.0 |
| 2009-09-21 06:58:00 | SPY | ETF | 105.93 | 105.93 | 105.93 | 105.93 | 100.0 |
| 2009-09-21 06:59:00 | SPY | ETF | 105.91 | 105.91 | 105.91 | 105.91 | 100.0 |
| 2009-09-21 07:00:00 | SPY | ETF | 105.9 | 105.9 | 105.9 | 105.9 | 700.0 |
| 2009-09-21 07:01:00 | SPY | ETF | 105.95 | 106.0 | 105.95 | 105.98 | 78760.0 |
| 2009-09-21 07:02:00 | SPY | ETF | 106.0 | 106.01 | 106.0 | 106.01 | 33500.0 |
| 2009-09-21 07:03:00 | SPY | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 40000.0 |
| 2009-09-21 07:04:00 | SPY | ETF | 105.98 | 105.98 | 105.98 | 105.98 | 250.0 |
| 2009-09-21 07:05:00 | SPY | ETF | 106.03 | 106.03 | 106.0 | 106.03 | 4267.0 |
| 2009-09-21 07:07:00 | SPY | ETF | 106.03 | 106.03 | 105.97 | 105.97 | 4400.0 |
| 2009-09-21 07:08:00 | SPY | ETF | 106.01 | 106.01 | 106.01 | 106.01 | 541.0 |
| 2009-09-21 07:09:00 | SPY | ETF | 105.99 | 105.99 | 105.99 | 105.99 | 1000.0 |
| 2009-09-21 07:10:00 | SPY | ETF | 105.99 | 105.99 | 105.99 | 105.99 | 130.0 |
> showing 50 of 86,898 rows — these rows as CSV