PREVIEW / etf_1min / 2009-12-31
file: by_date/etf_1min/2009/2009-12-31.parquet size: 1.5 MB rows: 79,773
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-12-31 04:16:00 | SPY | ETF | 112.6 | 112.6 | 112.6 | 112.6 | 100.0 |
| 2009-12-31 05:11:00 | SPY | ETF | 112.74 | 112.74 | 112.74 | 112.74 | 100.0 |
| 2009-12-31 06:39:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 200.0 |
| 2009-12-31 07:05:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 400.0 |
| 2009-12-31 07:11:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 300.0 |
| 2009-12-31 07:15:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 200.0 |
| 2009-12-31 07:16:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 300.0 |
| 2009-12-31 07:22:00 | SPY | ETF | 112.9 | 112.9 | 112.89 | 112.89 | 1960.0 |
| 2009-12-31 07:25:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 300.0 |
| 2009-12-31 07:27:00 | SPY | ETF | 112.84 | 112.87 | 112.84 | 112.87 | 1300.0 |
| 2009-12-31 07:35:00 | SPY | ETF | 112.82 | 112.82 | 112.82 | 112.82 | 300.0 |
| 2009-12-31 07:38:00 | SPY | ETF | 112.86 | 112.87 | 112.86 | 112.87 | 2100.0 |
| 2009-12-31 07:42:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 5000.0 |
| 2009-12-31 07:43:00 | SPY | ETF | 112.85 | 112.87 | 112.85 | 112.87 | 30810.0 |
| 2009-12-31 07:46:00 | SPY | ETF | 112.82 | 112.82 | 112.81 | 112.81 | 700.0 |
| 2009-12-31 07:47:00 | SPY | ETF | 112.81 | 112.81 | 112.8 | 112.81 | 9100.0 |
| 2009-12-31 07:48:00 | SPY | ETF | 112.82 | 112.82 | 112.81 | 112.81 | 500.0 |
| 2009-12-31 07:49:00 | SPY | ETF | 112.82 | 112.85 | 112.82 | 112.85 | 6013.0 |
| 2009-12-31 07:51:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 1501.0 |
| 2009-12-31 07:53:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 4000.0 |
| 2009-12-31 07:54:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 3004.0 |
| 2009-12-31 07:57:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 600.0 |
| 2009-12-31 08:00:00 | SPY | ETF | 112.84 | 112.84 | 112.81 | 112.81 | 27080.0 |
| 2009-12-31 08:01:00 | SPY | ETF | 112.82 | 112.82 | 112.8 | 112.8 | 6700.0 |
| 2009-12-31 08:02:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 3000.0 |
| 2009-12-31 08:03:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 200.0 |
| 2009-12-31 08:04:00 | SPY | ETF | 112.82 | 112.83 | 112.81 | 112.81 | 21801.0 |
| 2009-12-31 08:05:00 | SPY | ETF | 112.82 | 112.86 | 112.81 | 112.86 | 13978.0 |
| 2009-12-31 08:06:00 | SPY | ETF | 112.86 | 112.86 | 112.86 | 112.86 | 300.0 |
| 2009-12-31 08:07:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 2400.0 |
| 2009-12-31 08:08:00 | SPY | ETF | 112.83 | 112.83 | 112.83 | 112.83 | 352.0 |
| 2009-12-31 08:09:00 | SPY | ETF | 112.83 | 112.83 | 112.82 | 112.82 | 4760.0 |
| 2009-12-31 08:10:00 | SPY | ETF | 112.82 | 112.83 | 112.82 | 112.83 | 9488.0 |
| 2009-12-31 08:11:00 | SPY | ETF | 112.82 | 112.82 | 112.82 | 112.82 | 1400.0 |
| 2009-12-31 08:12:00 | SPY | ETF | 112.82 | 112.84 | 112.82 | 112.84 | 5400.0 |
| 2009-12-31 08:13:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 100.0 |
| 2009-12-31 08:15:00 | SPY | ETF | 112.82 | 112.82 | 112.82 | 112.82 | 800.0 |
| 2009-12-31 08:16:00 | SPY | ETF | 112.82 | 112.83 | 112.82 | 112.82 | 8300.0 |
| 2009-12-31 08:17:00 | SPY | ETF | 112.83 | 112.83 | 112.82 | 112.82 | 23300.0 |
| 2009-12-31 08:18:00 | SPY | ETF | 112.83 | 112.86 | 112.83 | 112.85 | 20001.0 |
| 2009-12-31 08:21:00 | SPY | ETF | 112.84 | 112.84 | 112.82 | 112.82 | 11200.0 |
| 2009-12-31 08:22:00 | SPY | ETF | 112.82 | 112.83 | 112.82 | 112.82 | 7300.0 |
| 2009-12-31 08:23:00 | SPY | ETF | 112.82 | 112.82 | 112.82 | 112.82 | 400.0 |
| 2009-12-31 08:25:00 | SPY | ETF | 112.82 | 112.82 | 112.81 | 112.81 | 1440.0 |
| 2009-12-31 08:26:00 | SPY | ETF | 112.81 | 112.81 | 112.71 | 112.72 | 240515.0 |
| 2009-12-31 08:27:00 | SPY | ETF | 112.72 | 112.79 | 112.72 | 112.79 | 352058.0 |
| 2009-12-31 08:28:00 | SPY | ETF | 112.78 | 112.78 | 112.75 | 112.76 | 15206.0 |
| 2009-12-31 08:29:00 | SPY | ETF | 112.77 | 112.78 | 112.76 | 112.76 | 10362.0 |
| 2009-12-31 08:30:00 | SPY | ETF | 112.77 | 112.89 | 112.77 | 112.8 | 245522.0 |
| 2009-12-31 08:31:00 | SPY | ETF | 112.79 | 112.81 | 112.79 | 112.81 | 53300.0 |
> showing 50 of 79,773 rows — these rows as CSV