PREVIEW / etf_5min / 2009-03-26
file: by_date/etf_5min/2009/2009-03-26.parquet size: 685 KB rows: 30,124
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-03-26 04:10:00 | SPY | ETF | 82.15 | 82.15 | 82.15 | 82.15 | 100.0 |
| 2009-03-26 04:15:00 | SPY | ETF | 82.18 | 82.18 | 82.18 | 82.18 | 900.0 |
| 2009-03-26 04:40:00 | SPY | ETF | 81.9 | 81.9 | 81.9 | 81.9 | 100.0 |
| 2009-03-26 04:45:00 | SPY | ETF | 81.9 | 81.9 | 81.9 | 81.9 | 200.0 |
| 2009-03-26 04:50:00 | SPY | ETF | 81.76 | 81.76 | 81.76 | 81.76 | 510.0 |
| 2009-03-26 05:00:00 | SPY | ETF | 81.82 | 81.82 | 81.82 | 81.82 | 200.0 |
| 2009-03-26 05:10:00 | SPY | ETF | 82.01 | 82.05 | 82.01 | 82.05 | 1700.0 |
| 2009-03-26 05:15:00 | SPY | ETF | 81.99 | 81.99 | 81.98 | 81.98 | 600.0 |
| 2009-03-26 05:20:00 | SPY | ETF | 81.91 | 81.91 | 81.86 | 81.86 | 600.0 |
| 2009-03-26 05:25:00 | SPY | ETF | 81.93 | 81.93 | 81.93 | 81.93 | 100.0 |
| 2009-03-26 05:30:00 | SPY | ETF | 81.82 | 81.82 | 81.8 | 81.8 | 400.0 |
| 2009-03-26 05:35:00 | SPY | ETF | 81.77 | 81.77 | 81.77 | 81.77 | 100.0 |
| 2009-03-26 05:40:00 | SPY | ETF | 81.85 | 81.89 | 81.79 | 81.79 | 1200.0 |
| 2009-03-26 05:45:00 | SPY | ETF | 81.77 | 81.8 | 81.74 | 81.8 | 1000.0 |
| 2009-03-26 05:50:00 | SPY | ETF | 81.81 | 81.83 | 81.81 | 81.83 | 24500.0 |
| 2009-03-26 05:55:00 | SPY | ETF | 81.87 | 81.87 | 81.81 | 81.81 | 25100.0 |
| 2009-03-26 06:00:00 | SPY | ETF | 81.8 | 81.92 | 81.8 | 81.87 | 19800.0 |
| 2009-03-26 06:05:00 | SPY | ETF | 81.82 | 81.82 | 81.82 | 81.82 | 100.0 |
| 2009-03-26 06:10:00 | SPY | ETF | 81.92 | 81.92 | 81.92 | 81.92 | 300.0 |
| 2009-03-26 06:15:00 | SPY | ETF | 81.96 | 82.03 | 81.96 | 82.03 | 600.0 |
| 2009-03-26 06:20:00 | SPY | ETF | 82.08 | 82.08 | 82.07 | 82.07 | 3200.0 |
| 2009-03-26 06:25:00 | SPY | ETF | 82.08 | 82.12 | 82.05 | 82.1 | 21800.0 |
| 2009-03-26 06:30:00 | SPY | ETF | 82.12 | 82.13 | 82.1 | 82.1 | 600.0 |
| 2009-03-26 06:35:00 | SPY | ETF | 82.14 | 82.18 | 82.14 | 82.18 | 10900.0 |
| 2009-03-26 06:40:00 | SPY | ETF | 82.12 | 82.12 | 82.1 | 82.1 | 450.0 |
| 2009-03-26 06:45:00 | SPY | ETF | 81.97 | 81.97 | 81.97 | 81.97 | 100.0 |
| 2009-03-26 06:55:00 | SPY | ETF | 82.11 | 82.11 | 82.04 | 82.04 | 493.0 |
| 2009-03-26 07:00:00 | SPY | ETF | 82.01 | 82.01 | 81.94 | 81.95 | 5850.0 |
| 2009-03-26 07:05:00 | SPY | ETF | 81.99 | 82.15 | 81.96 | 82.09 | 487994.0 |
| 2009-03-26 07:10:00 | SPY | ETF | 82.09 | 82.14 | 82.06 | 82.14 | 137655.0 |
| 2009-03-26 07:15:00 | SPY | ETF | 82.14 | 82.18 | 82.11 | 82.12 | 164540.0 |
| 2009-03-26 07:20:00 | SPY | ETF | 82.1 | 82.1 | 81.9 | 81.95 | 173396.0 |
| 2009-03-26 07:25:00 | SPY | ETF | 81.92 | 81.98 | 81.88 | 81.88 | 21569.0 |
| 2009-03-26 07:30:00 | SPY | ETF | 81.89 | 81.94 | 81.85 | 81.9 | 131600.0 |
| 2009-03-26 07:35:00 | SPY | ETF | 81.95 | 82.01 | 81.95 | 81.97 | 30300.0 |
| 2009-03-26 07:40:00 | SPY | ETF | 81.97 | 82.05 | 81.94 | 81.99 | 134350.0 |
| 2009-03-26 07:45:00 | SPY | ETF | 81.98 | 82.15 | 81.96 | 82.14 | 74421.0 |
| 2009-03-26 07:50:00 | SPY | ETF | 82.15 | 82.28 | 82.15 | 82.22 | 109285.0 |
| 2009-03-26 07:55:00 | SPY | ETF | 82.22 | 82.23 | 82.16 | 82.22 | 72665.0 |
| 2009-03-26 08:00:00 | SPY | ETF | 82.23 | 82.39 | 82.04 | 82.37 | 2590756.0 |
| 2009-03-26 08:05:00 | SPY | ETF | 82.36 | 82.46 | 82.35 | 82.37 | 535019.0 |
| 2009-03-26 08:10:00 | SPY | ETF | 82.37 | 82.39 | 82.26 | 82.3 | 292898.0 |
| 2009-03-26 08:15:00 | SPY | ETF | 82.3 | 82.37 | 82.27 | 82.34 | 138595.0 |
| 2009-03-26 08:20:00 | SPY | ETF | 82.33 | 82.36 | 82.23 | 82.25 | 186885.0 |
| 2009-03-26 08:25:00 | SPY | ETF | 82.25 | 82.35 | 82.23 | 82.35 | 292759.0 |
| 2009-03-26 08:30:00 | SPY | ETF | 82.34 | 82.54 | 81.94 | 81.94 | 1755293.0 |
| 2009-03-26 08:35:00 | SPY | ETF | 81.94 | 82.04 | 81.87 | 81.96 | 413976.0 |
| 2009-03-26 08:40:00 | SPY | ETF | 81.95 | 82.14 | 81.94 | 82.08 | 185854.0 |
| 2009-03-26 08:45:00 | SPY | ETF | 82.09 | 82.14 | 82.04 | 82.07 | 281374.0 |
| 2009-03-26 08:50:00 | SPY | ETF | 82.07 | 82.24 | 82.02 | 82.17 | 307663.0 |
> showing 50 of 30,124 rows — these rows as CSV