PREVIEW / etf_5min / 2009-05-21
file: by_date/etf_5min/2009/2009-05-21.parquet size: 718 KB rows: 30,741
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-05-21 04:25:00 | SPY | ETF | 90.07 | 90.07 | 89.99 | 89.99 | 665.0 |
| 2009-05-21 04:30:00 | SPY | ETF | 89.98 | 89.98 | 89.98 | 89.98 | 300.0 |
| 2009-05-21 04:50:00 | SPY | ETF | 89.87 | 89.87 | 89.87 | 89.87 | 200.0 |
| 2009-05-21 05:10:00 | SPY | ETF | 89.94 | 89.94 | 89.94 | 89.94 | 141.0 |
| 2009-05-21 05:15:00 | SPY | ETF | 89.92 | 89.92 | 89.85 | 89.85 | 400.0 |
| 2009-05-21 05:20:00 | SPY | ETF | 89.89 | 89.95 | 89.89 | 89.95 | 900.0 |
| 2009-05-21 05:25:00 | SPY | ETF | 89.98 | 89.98 | 89.98 | 89.98 | 2000.0 |
| 2009-05-21 05:40:00 | SPY | ETF | 89.78 | 89.78 | 89.78 | 89.78 | 100.0 |
| 2009-05-21 05:50:00 | SPY | ETF | 89.96 | 90.02 | 89.96 | 90.0 | 5600.0 |
| 2009-05-21 06:05:00 | SPY | ETF | 90.02 | 90.02 | 89.98 | 90.0 | 22000.0 |
| 2009-05-21 06:10:00 | SPY | ETF | 90.08 | 90.11 | 90.08 | 90.11 | 3600.0 |
| 2009-05-21 06:25:00 | SPY | ETF | 89.97 | 90.01 | 89.97 | 89.97 | 14050.0 |
| 2009-05-21 06:30:00 | SPY | ETF | 89.98 | 89.98 | 89.98 | 89.98 | 500.0 |
| 2009-05-21 06:40:00 | SPY | ETF | 89.96 | 89.96 | 89.96 | 89.96 | 2500.0 |
| 2009-05-21 06:45:00 | SPY | ETF | 89.93 | 89.93 | 89.93 | 89.93 | 3000.0 |
| 2009-05-21 06:50:00 | SPY | ETF | 89.97 | 89.97 | 89.95 | 89.95 | 479.0 |
| 2009-05-21 06:55:00 | SPY | ETF | 89.92 | 89.98 | 89.92 | 89.98 | 600.0 |
| 2009-05-21 07:00:00 | SPY | ETF | 89.96 | 90.0 | 89.91 | 89.95 | 70610.0 |
| 2009-05-21 07:05:00 | SPY | ETF | 89.93 | 89.95 | 89.81 | 89.85 | 38315.0 |
| 2009-05-21 07:10:00 | SPY | ETF | 89.9 | 89.9 | 89.81 | 89.85 | 170800.0 |
| 2009-05-21 07:15:00 | SPY | ETF | 89.86 | 89.9 | 89.81 | 89.87 | 32250.0 |
| 2009-05-21 07:20:00 | SPY | ETF | 89.88 | 89.89 | 89.84 | 89.85 | 14000.0 |
| 2009-05-21 07:25:00 | SPY | ETF | 89.89 | 89.9 | 89.84 | 89.85 | 10428.0 |
| 2009-05-21 07:30:00 | SPY | ETF | 89.86 | 89.93 | 89.85 | 89.91 | 44712.0 |
| 2009-05-21 07:35:00 | SPY | ETF | 89.95 | 90.0 | 89.94 | 89.94 | 96356.0 |
| 2009-05-21 07:40:00 | SPY | ETF | 89.96 | 89.97 | 89.91 | 89.91 | 32711.0 |
| 2009-05-21 07:45:00 | SPY | ETF | 89.91 | 89.93 | 89.89 | 89.93 | 14550.0 |
| 2009-05-21 07:50:00 | SPY | ETF | 89.93 | 89.98 | 89.92 | 89.98 | 139950.0 |
| 2009-05-21 07:55:00 | SPY | ETF | 89.98 | 90.08 | 89.98 | 90.03 | 165675.0 |
| 2009-05-21 08:00:00 | SPY | ETF | 90.02 | 90.03 | 89.87 | 89.92 | 348165.0 |
| 2009-05-21 08:05:00 | SPY | ETF | 89.93 | 89.97 | 89.89 | 89.96 | 138208.0 |
| 2009-05-21 08:10:00 | SPY | ETF | 89.97 | 90.02 | 89.96 | 90.0 | 202905.0 |
| 2009-05-21 08:15:00 | SPY | ETF | 90.01 | 90.01 | 89.95 | 90.0 | 33892.0 |
| 2009-05-21 08:20:00 | SPY | ETF | 90.0 | 90.2 | 89.99 | 90.01 | 53157.0 |
| 2009-05-21 08:25:00 | SPY | ETF | 90.0 | 90.07 | 89.99 | 90.06 | 204521.0 |
| 2009-05-21 08:30:00 | SPY | ETF | 90.07 | 90.07 | 89.74 | 89.81 | 764843.0 |
| 2009-05-21 08:35:00 | SPY | ETF | 89.81 | 89.82 | 89.7 | 89.79 | 262325.0 |
| 2009-05-21 08:40:00 | SPY | ETF | 89.79 | 89.82 | 89.76 | 89.8 | 304351.0 |
| 2009-05-21 08:45:00 | SPY | ETF | 89.8 | 89.8 | 89.72 | 89.74 | 228850.0 |
| 2009-05-21 08:50:00 | SPY | ETF | 89.74 | 89.75 | 89.57 | 89.58 | 613995.0 |
| 2009-05-21 08:55:00 | SPY | ETF | 89.58 | 89.64 | 89.44 | 89.45 | 641767.0 |
| 2009-05-21 09:00:00 | SPY | ETF | 89.45 | 89.46 | 89.37 | 89.44 | 520586.0 |
| 2009-05-21 09:05:00 | SPY | ETF | 89.44 | 89.48 | 89.36 | 89.37 | 357083.0 |
| 2009-05-21 09:10:00 | SPY | ETF | 89.37 | 89.39 | 89.31 | 89.38 | 446739.0 |
| 2009-05-21 09:15:00 | SPY | ETF | 89.38 | 89.4 | 89.29 | 89.33 | 168936.0 |
| 2009-05-21 09:20:00 | SPY | ETF | 89.33 | 89.46 | 89.32 | 89.46 | 314639.0 |
| 2009-05-21 09:25:00 | SPY | ETF | 89.45 | 89.46 | 89.42 | 89.44 | 430313.0 |
| 2009-05-21 09:30:00 | SPY | ETF | 89.46 | 89.5 | 89.25 | 89.38 | 7652984.0 |
| 2009-05-21 09:35:00 | SPY | ETF | 89.39 | 89.48 | 89.27 | 89.41 | 5376343.0 |
| 2009-05-21 09:40:00 | SPY | ETF | 89.4 | 89.65 | 89.35 | 89.62 | 4423127.0 |
> showing 50 of 30,741 rows — these rows as CSV