PREVIEW / etf_1min / 2009-02-25
file: by_date/etf_1min/2009/2009-02-25.parquet size: 1.7 MB rows: 93,081
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-02-25 04:08:00 | SPY | ETF | 77.05 | 77.05 | 77.05 | 77.05 | 500.0 |
| 2009-02-25 04:15:00 | SPY | ETF | 77.14 | 77.14 | 77.12 | 77.12 | 600.0 |
| 2009-02-25 04:16:00 | SPY | ETF | 77.07 | 77.07 | 77.04 | 77.04 | 300.0 |
| 2009-02-25 04:24:00 | SPY | ETF | 77.09 | 77.09 | 77.09 | 77.09 | 500.0 |
| 2009-02-25 04:26:00 | SPY | ETF | 77.09 | 77.09 | 77.09 | 77.09 | 1500.0 |
| 2009-02-25 04:27:00 | SPY | ETF | 77.03 | 77.03 | 77.03 | 77.03 | 500.0 |
| 2009-02-25 05:00:00 | SPY | ETF | 77.54 | 77.54 | 77.54 | 77.54 | 1000.0 |
| 2009-02-25 05:22:00 | SPY | ETF | 77.51 | 77.51 | 77.51 | 77.51 | 500.0 |
| 2009-02-25 06:01:00 | SPY | ETF | 77.4 | 77.4 | 77.4 | 77.4 | 100.0 |
| 2009-02-25 06:04:00 | SPY | ETF | 77.43 | 77.43 | 77.43 | 77.43 | 800.0 |
| 2009-02-25 06:15:00 | SPY | ETF | 77.61 | 77.61 | 77.61 | 77.61 | 3000.0 |
| 2009-02-25 06:21:00 | SPY | ETF | 77.56 | 77.56 | 77.56 | 77.56 | 200.0 |
| 2009-02-25 06:24:00 | SPY | ETF | 77.51 | 77.51 | 77.51 | 77.51 | 100.0 |
| 2009-02-25 06:29:00 | SPY | ETF | 77.38 | 77.38 | 77.38 | 77.38 | 3000.0 |
| 2009-02-25 06:30:00 | SPY | ETF | 77.35 | 77.35 | 77.35 | 77.35 | 1000.0 |
| 2009-02-25 06:35:00 | SPY | ETF | 77.26 | 77.31 | 77.26 | 77.31 | 2100.0 |
| 2009-02-25 06:36:00 | SPY | ETF | 77.32 | 77.32 | 77.32 | 77.32 | 300.0 |
| 2009-02-25 06:38:00 | SPY | ETF | 77.23 | 77.23 | 77.23 | 77.23 | 400.0 |
| 2009-02-25 06:45:00 | SPY | ETF | 77.03 | 77.03 | 76.95 | 76.95 | 600.0 |
| 2009-02-25 06:46:00 | SPY | ETF | 77.01 | 77.01 | 76.98 | 76.98 | 300.0 |
| 2009-02-25 06:47:00 | SPY | ETF | 76.82 | 76.82 | 76.81 | 76.81 | 10500.0 |
| 2009-02-25 06:48:00 | SPY | ETF | 76.83 | 76.83 | 76.83 | 76.83 | 5000.0 |
| 2009-02-25 06:54:00 | SPY | ETF | 76.85 | 76.85 | 76.85 | 76.85 | 2000.0 |
| 2009-02-25 06:55:00 | SPY | ETF | 76.92 | 76.92 | 76.91 | 76.91 | 700.0 |
| 2009-02-25 06:56:00 | SPY | ETF | 76.91 | 76.91 | 76.91 | 76.91 | 5500.0 |
| 2009-02-25 06:57:00 | SPY | ETF | 76.94 | 77.02 | 76.94 | 77.02 | 3200.0 |
| 2009-02-25 06:58:00 | SPY | ETF | 76.96 | 76.96 | 76.96 | 76.96 | 2000.0 |
| 2009-02-25 07:00:00 | SPY | ETF | 76.91 | 76.91 | 76.91 | 76.91 | 200.0 |
| 2009-02-25 07:01:00 | SPY | ETF | 76.88 | 76.92 | 76.88 | 76.92 | 1400.0 |
| 2009-02-25 07:02:00 | SPY | ETF | 76.93 | 76.93 | 76.93 | 76.93 | 100.0 |
| 2009-02-25 07:03:00 | SPY | ETF | 76.98 | 76.98 | 76.96 | 76.96 | 2300.0 |
| 2009-02-25 07:04:00 | SPY | ETF | 76.98 | 76.98 | 76.95 | 76.95 | 20200.0 |
| 2009-02-25 07:05:00 | SPY | ETF | 76.99 | 76.99 | 76.99 | 76.99 | 4750.0 |
| 2009-02-25 07:06:00 | SPY | ETF | 77.03 | 77.03 | 77.0 | 77.0 | 600.0 |
| 2009-02-25 07:07:00 | SPY | ETF | 77.0 | 77.0 | 76.93 | 76.96 | 18700.0 |
| 2009-02-25 07:08:00 | SPY | ETF | 76.94 | 76.94 | 76.88 | 76.88 | 23800.0 |
| 2009-02-25 07:09:00 | SPY | ETF | 76.86 | 76.87 | 76.86 | 76.87 | 300.0 |
| 2009-02-25 07:10:00 | SPY | ETF | 76.85 | 76.85 | 76.79 | 76.81 | 5800.0 |
| 2009-02-25 07:12:00 | SPY | ETF | 76.82 | 76.86 | 76.8 | 76.84 | 4100.0 |
| 2009-02-25 07:13:00 | SPY | ETF | 76.89 | 76.89 | 76.87 | 76.87 | 4300.0 |
| 2009-02-25 07:15:00 | SPY | ETF | 76.91 | 76.91 | 76.88 | 76.9 | 700.0 |
| 2009-02-25 07:16:00 | SPY | ETF | 76.9 | 76.96 | 76.9 | 76.96 | 5700.0 |
| 2009-02-25 07:17:00 | SPY | ETF | 76.94 | 76.94 | 76.88 | 76.89 | 4700.0 |
| 2009-02-25 07:18:00 | SPY | ETF | 77.01 | 77.01 | 77.01 | 77.01 | 300.0 |
| 2009-02-25 07:19:00 | SPY | ETF | 77.03 | 77.11 | 77.03 | 77.03 | 2500.0 |
| 2009-02-25 07:20:00 | SPY | ETF | 77.03 | 77.09 | 77.03 | 77.09 | 26300.0 |
| 2009-02-25 07:21:00 | SPY | ETF | 77.07 | 77.07 | 77.0 | 77.01 | 1500.0 |
| 2009-02-25 07:22:00 | SPY | ETF | 77.1 | 77.1 | 77.1 | 77.1 | 500.0 |
| 2009-02-25 07:23:00 | SPY | ETF | 77.05 | 77.05 | 77.03 | 77.03 | 10900.0 |
| 2009-02-25 07:24:00 | SPY | ETF | 77.05 | 77.05 | 77.03 | 77.03 | 1000.0 |
> showing 50 of 93,081 rows — these rows as CSV