PREVIEW / etf_1min / 2009-10-20
file: by_date/etf_1min/2009/2009-10-20.parquet size: 1.7 MB rows: 92,582
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-10-20 04:15:00 | SPY | ETF | 109.54 | 109.54 | 109.54 | 109.54 | 900.0 |
| 2009-10-20 04:17:00 | SPY | ETF | 109.44 | 109.44 | 109.44 | 109.44 | 5000.0 |
| 2009-10-20 04:20:00 | SPY | ETF | 109.52 | 109.52 | 109.52 | 109.52 | 100.0 |
| 2009-10-20 04:21:00 | SPY | ETF | 109.54 | 109.54 | 109.54 | 109.54 | 1000.0 |
| 2009-10-20 04:25:00 | SPY | ETF | 109.59 | 109.59 | 109.59 | 109.59 | 100.0 |
| 2009-10-20 04:32:00 | SPY | ETF | 109.61 | 109.61 | 109.61 | 109.61 | 300.0 |
| 2009-10-20 04:47:00 | SPY | ETF | 109.61 | 109.61 | 109.61 | 109.61 | 200.0 |
| 2009-10-20 05:10:00 | SPY | ETF | 109.79 | 109.79 | 109.79 | 109.79 | 100.0 |
| 2009-10-20 05:15:00 | SPY | ETF | 109.75 | 109.75 | 109.75 | 109.75 | 100.0 |
| 2009-10-20 05:36:00 | SPY | ETF | 109.71 | 109.71 | 109.71 | 109.71 | 500.0 |
| 2009-10-20 05:37:00 | SPY | ETF | 109.73 | 109.73 | 109.73 | 109.73 | 100.0 |
| 2009-10-20 05:47:00 | SPY | ETF | 109.81 | 109.81 | 109.81 | 109.81 | 100.0 |
| 2009-10-20 06:04:00 | SPY | ETF | 109.86 | 109.86 | 109.86 | 109.86 | 500.0 |
| 2009-10-20 06:05:00 | SPY | ETF | 109.86 | 109.86 | 109.86 | 109.86 | 2500.0 |
| 2009-10-20 06:08:00 | SPY | ETF | 109.83 | 109.83 | 109.83 | 109.83 | 100.0 |
| 2009-10-20 06:13:00 | SPY | ETF | 109.81 | 109.81 | 109.81 | 109.81 | 300.0 |
| 2009-10-20 06:15:00 | SPY | ETF | 109.8 | 109.8 | 109.8 | 109.8 | 500.0 |
| 2009-10-20 06:21:00 | SPY | ETF | 109.81 | 109.81 | 109.81 | 109.81 | 200.0 |
| 2009-10-20 06:25:00 | SPY | ETF | 109.82 | 109.82 | 109.82 | 109.82 | 200.0 |
| 2009-10-20 06:27:00 | SPY | ETF | 109.79 | 109.79 | 109.79 | 109.79 | 100.0 |
| 2009-10-20 06:28:00 | SPY | ETF | 109.78 | 109.78 | 109.72 | 109.72 | 500.0 |
| 2009-10-20 06:30:00 | SPY | ETF | 109.74 | 109.74 | 109.74 | 109.74 | 200.0 |
| 2009-10-20 06:31:00 | SPY | ETF | 109.7 | 109.7 | 109.7 | 109.7 | 1000.0 |
| 2009-10-20 06:38:00 | SPY | ETF | 109.77 | 109.77 | 109.77 | 109.77 | 200.0 |
| 2009-10-20 06:52:00 | SPY | ETF | 109.72 | 109.72 | 109.72 | 109.72 | 2500.0 |
| 2009-10-20 06:55:00 | SPY | ETF | 109.72 | 109.72 | 109.72 | 109.72 | 100.0 |
| 2009-10-20 06:57:00 | SPY | ETF | 109.68 | 109.68 | 109.68 | 109.68 | 5200.0 |
| 2009-10-20 07:00:00 | SPY | ETF | 109.71 | 109.71 | 109.71 | 109.71 | 3209.0 |
| 2009-10-20 07:01:00 | SPY | ETF | 109.72 | 109.73 | 109.72 | 109.73 | 1000.0 |
| 2009-10-20 07:02:00 | SPY | ETF | 109.75 | 109.75 | 109.75 | 109.75 | 300.0 |
| 2009-10-20 07:05:00 | SPY | ETF | 109.73 | 109.8 | 109.73 | 109.8 | 13896.0 |
| 2009-10-20 07:06:00 | SPY | ETF | 109.83 | 109.84 | 109.83 | 109.84 | 24296.0 |
| 2009-10-20 07:07:00 | SPY | ETF | 109.85 | 109.88 | 109.85 | 109.88 | 1200.0 |
| 2009-10-20 07:08:00 | SPY | ETF | 109.85 | 109.88 | 109.85 | 109.88 | 3750.0 |
| 2009-10-20 07:09:00 | SPY | ETF | 109.88 | 109.88 | 109.87 | 109.87 | 500.0 |
| 2009-10-20 07:10:00 | SPY | ETF | 109.88 | 109.89 | 109.88 | 109.89 | 800.0 |
| 2009-10-20 07:11:00 | SPY | ETF | 109.89 | 109.9 | 109.89 | 109.9 | 2550.0 |
| 2009-10-20 07:12:00 | SPY | ETF | 109.87 | 109.91 | 109.87 | 109.91 | 6000.0 |
| 2009-10-20 07:13:00 | SPY | ETF | 109.87 | 109.95 | 109.87 | 109.93 | 1800.0 |
| 2009-10-20 07:14:00 | SPY | ETF | 109.93 | 109.99 | 109.93 | 109.99 | 3500.0 |
| 2009-10-20 07:15:00 | SPY | ETF | 109.95 | 109.95 | 109.93 | 109.93 | 5000.0 |
| 2009-10-20 07:16:00 | SPY | ETF | 109.93 | 109.93 | 109.93 | 109.93 | 1000.0 |
| 2009-10-20 07:17:00 | SPY | ETF | 109.96 | 109.96 | 109.96 | 109.96 | 200.0 |
| 2009-10-20 07:18:00 | SPY | ETF | 109.99 | 109.99 | 109.95 | 109.95 | 3250.0 |
| 2009-10-20 07:19:00 | SPY | ETF | 109.9 | 109.9 | 109.89 | 109.89 | 10000.0 |
| 2009-10-20 07:20:00 | SPY | ETF | 109.9 | 109.9 | 109.9 | 109.9 | 500.0 |
| 2009-10-20 07:21:00 | SPY | ETF | 109.91 | 109.91 | 109.91 | 109.91 | 12800.0 |
| 2009-10-20 07:22:00 | SPY | ETF | 109.93 | 109.93 | 109.93 | 109.93 | 5000.0 |
| 2009-10-20 07:23:00 | SPY | ETF | 109.95 | 109.97 | 109.95 | 109.97 | 600.0 |
| 2009-10-20 07:24:00 | SPY | ETF | 109.97 | 109.99 | 109.97 | 109.99 | 1456.0 |
> showing 50 of 92,582 rows — these rows as CSV