PREVIEW / etf_5min / 2009-11-24
file: by_date/etf_5min/2009/2009-11-24.parquet size: 705 KB rows: 30,694
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-11-24 04:30:00 | SPY | ETF | 110.78 | 110.78 | 110.74 | 110.74 | 235.0 |
| 2009-11-24 04:40:00 | SPY | ETF | 110.75 | 110.75 | 110.75 | 110.75 | 100.0 |
| 2009-11-24 04:45:00 | SPY | ETF | 110.73 | 110.73 | 110.73 | 110.73 | 300.0 |
| 2009-11-24 04:55:00 | SPY | ETF | 110.73 | 110.73 | 110.73 | 110.73 | 1000.0 |
| 2009-11-24 05:05:00 | SPY | ETF | 110.76 | 110.76 | 110.76 | 110.76 | 100.0 |
| 2009-11-24 05:10:00 | SPY | ETF | 110.76 | 110.76 | 110.76 | 110.76 | 650.0 |
| 2009-11-24 05:15:00 | SPY | ETF | 110.88 | 110.94 | 110.88 | 110.94 | 4000.0 |
| 2009-11-24 05:30:00 | SPY | ETF | 110.98 | 110.98 | 110.98 | 110.98 | 100.0 |
| 2009-11-24 05:40:00 | SPY | ETF | 111.03 | 111.03 | 111.03 | 111.03 | 100.0 |
| 2009-11-24 05:45:00 | SPY | ETF | 111.07 | 111.11 | 111.07 | 111.11 | 650.0 |
| 2009-11-24 05:55:00 | SPY | ETF | 111.11 | 111.11 | 111.09 | 111.1 | 3100.0 |
| 2009-11-24 06:00:00 | SPY | ETF | 111.1 | 111.1 | 111.08 | 111.08 | 2600.0 |
| 2009-11-24 06:05:00 | SPY | ETF | 111.1 | 111.1 | 111.1 | 111.1 | 100.0 |
| 2009-11-24 06:15:00 | SPY | ETF | 111.1 | 111.1 | 111.06 | 111.06 | 1200.0 |
| 2009-11-24 06:25:00 | SPY | ETF | 111.02 | 111.02 | 111.02 | 111.02 | 3000.0 |
| 2009-11-24 06:30:00 | SPY | ETF | 111.02 | 111.02 | 111.02 | 111.02 | 400.0 |
| 2009-11-24 06:40:00 | SPY | ETF | 110.95 | 110.95 | 110.95 | 110.95 | 2500.0 |
| 2009-11-24 06:45:00 | SPY | ETF | 110.97 | 111.0 | 110.97 | 111.0 | 300.0 |
| 2009-11-24 06:50:00 | SPY | ETF | 111.03 | 111.03 | 111.03 | 111.03 | 100.0 |
| 2009-11-24 06:55:00 | SPY | ETF | 110.93 | 110.95 | 110.93 | 110.95 | 2250.0 |
| 2009-11-24 07:00:00 | SPY | ETF | 110.94 | 110.94 | 110.92 | 110.93 | 75400.0 |
| 2009-11-24 07:05:00 | SPY | ETF | 110.93 | 111.0 | 110.93 | 111.0 | 2565.0 |
| 2009-11-24 07:10:00 | SPY | ETF | 111.02 | 111.07 | 110.99 | 111.05 | 14600.0 |
| 2009-11-24 07:15:00 | SPY | ETF | 111.05 | 111.06 | 111.05 | 111.06 | 5617.0 |
| 2009-11-24 07:20:00 | SPY | ETF | 111.04 | 111.13 | 111.04 | 111.13 | 13303.0 |
| 2009-11-24 07:25:00 | SPY | ETF | 111.12 | 111.14 | 111.12 | 111.14 | 21400.0 |
| 2009-11-24 07:30:00 | SPY | ETF | 111.13 | 111.14 | 111.09 | 111.11 | 60700.0 |
| 2009-11-24 07:35:00 | SPY | ETF | 111.1 | 111.12 | 111.09 | 111.09 | 10100.0 |
| 2009-11-24 07:40:00 | SPY | ETF | 111.06 | 111.09 | 111.02 | 111.09 | 41700.0 |
| 2009-11-24 07:45:00 | SPY | ETF | 111.08 | 111.11 | 111.05 | 111.06 | 42303.0 |
| 2009-11-24 07:50:00 | SPY | ETF | 111.09 | 111.13 | 111.09 | 111.09 | 16000.0 |
| 2009-11-24 07:55:00 | SPY | ETF | 111.09 | 111.14 | 111.09 | 111.13 | 15800.0 |
| 2009-11-24 08:00:00 | SPY | ETF | 111.09 | 111.12 | 110.52 | 111.08 | 105180.0 |
| 2009-11-24 08:05:00 | SPY | ETF | 111.09 | 111.15 | 111.08 | 111.12 | 110214.0 |
| 2009-11-24 08:10:00 | SPY | ETF | 111.09 | 111.1 | 111.06 | 111.07 | 43750.0 |
| 2009-11-24 08:15:00 | SPY | ETF | 111.05 | 111.08 | 111.01 | 111.02 | 171059.0 |
| 2009-11-24 08:20:00 | SPY | ETF | 111.02 | 111.09 | 111.01 | 111.06 | 255949.0 |
| 2009-11-24 08:25:00 | SPY | ETF | 111.06 | 111.15 | 111.01 | 111.15 | 184696.0 |
| 2009-11-24 08:30:00 | SPY | ETF | 111.15 | 111.15 | 110.86 | 110.93 | 918873.0 |
| 2009-11-24 08:35:00 | SPY | ETF | 110.93 | 111.02 | 110.86 | 110.86 | 237018.0 |
| 2009-11-24 08:40:00 | SPY | ETF | 110.87 | 111.06 | 110.83 | 111.02 | 157125.0 |
| 2009-11-24 08:45:00 | SPY | ETF | 111.02 | 111.06 | 110.98 | 111.05 | 85151.0 |
| 2009-11-24 08:50:00 | SPY | ETF | 111.05 | 111.05 | 110.99 | 111.01 | 87757.0 |
| 2009-11-24 08:55:00 | SPY | ETF | 111.02 | 111.02 | 110.97 | 110.99 | 95753.0 |
| 2009-11-24 09:00:00 | SPY | ETF | 110.98 | 111.12 | 110.95 | 111.1 | 286734.0 |
| 2009-11-24 09:05:00 | SPY | ETF | 111.1 | 111.17 | 111.1 | 111.11 | 358550.0 |
| 2009-11-24 09:10:00 | SPY | ETF | 111.1 | 111.13 | 111.07 | 111.08 | 119470.0 |
| 2009-11-24 09:15:00 | SPY | ETF | 111.07 | 111.07 | 111.02 | 111.05 | 40976.0 |
| 2009-11-24 09:20:00 | SPY | ETF | 111.04 | 111.05 | 111.01 | 111.02 | 92394.0 |
| 2009-11-24 09:25:00 | SPY | ETF | 111.03 | 111.05 | 111.0 | 111.0 | 209182.0 |
> showing 50 of 30,694 rows — these rows as CSV