PREVIEW / etf_5min / 2009-06-22
file: by_date/etf_5min/2009/2009-06-22.parquet size: 703 KB rows: 30,131
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-06-22 04:15:00 | SPY | ETF | 91.65 | 91.65 | 91.55 | 91.55 | 750.0 |
| 2009-06-22 04:20:00 | SPY | ETF | 91.55 | 91.55 | 91.47 | 91.47 | 300.0 |
| 2009-06-22 04:25:00 | SPY | ETF | 91.45 | 91.45 | 91.44 | 91.44 | 300.0 |
| 2009-06-22 04:30:00 | SPY | ETF | 91.41 | 91.41 | 91.24 | 91.24 | 2900.0 |
| 2009-06-22 04:35:00 | SPY | ETF | 91.27 | 91.27 | 91.27 | 91.27 | 2500.0 |
| 2009-06-22 05:05:00 | SPY | ETF | 91.2 | 91.2 | 91.2 | 91.2 | 2500.0 |
| 2009-06-22 05:10:00 | SPY | ETF | 91.24 | 91.25 | 91.24 | 91.25 | 15000.0 |
| 2009-06-22 05:15:00 | SPY | ETF | 91.3 | 91.3 | 91.3 | 91.3 | 200.0 |
| 2009-06-22 05:40:00 | SPY | ETF | 91.29 | 91.29 | 91.29 | 91.29 | 338.0 |
| 2009-06-22 06:00:00 | SPY | ETF | 91.42 | 91.42 | 91.42 | 91.42 | 600.0 |
| 2009-06-22 06:15:00 | SPY | ETF | 91.22 | 91.22 | 91.22 | 91.22 | 2500.0 |
| 2009-06-22 06:25:00 | SPY | ETF | 91.36 | 91.37 | 91.27 | 91.27 | 11600.0 |
| 2009-06-22 06:30:00 | SPY | ETF | 91.35 | 91.35 | 91.35 | 91.35 | 4800.0 |
| 2009-06-22 06:35:00 | SPY | ETF | 91.44 | 91.44 | 91.37 | 91.42 | 3738.0 |
| 2009-06-22 06:40:00 | SPY | ETF | 91.37 | 91.37 | 91.32 | 91.32 | 800.0 |
| 2009-06-22 06:45:00 | SPY | ETF | 91.33 | 91.33 | 91.24 | 91.26 | 12180.0 |
| 2009-06-22 06:50:00 | SPY | ETF | 91.35 | 91.35 | 91.19 | 91.22 | 7500.0 |
| 2009-06-22 06:55:00 | SPY | ETF | 91.28 | 91.29 | 91.28 | 91.29 | 2300.0 |
| 2009-06-22 07:00:00 | SPY | ETF | 91.28 | 91.31 | 91.24 | 91.31 | 12072.0 |
| 2009-06-22 07:05:00 | SPY | ETF | 91.37 | 91.39 | 91.33 | 91.39 | 8418.0 |
| 2009-06-22 07:10:00 | SPY | ETF | 91.39 | 91.39 | 91.26 | 91.28 | 13240.0 |
| 2009-06-22 07:15:00 | SPY | ETF | 91.26 | 91.27 | 91.21 | 91.26 | 20288.0 |
| 2009-06-22 07:20:00 | SPY | ETF | 91.29 | 91.29 | 91.19 | 91.2 | 207200.0 |
| 2009-06-22 07:25:00 | SPY | ETF | 91.2 | 91.2 | 91.15 | 91.15 | 85122.0 |
| 2009-06-22 07:30:00 | SPY | ETF | 91.14 | 91.35 | 91.13 | 91.35 | 69210.0 |
| 2009-06-22 07:35:00 | SPY | ETF | 91.27 | 91.28 | 91.2 | 91.2 | 59499.0 |
| 2009-06-22 07:40:00 | SPY | ETF | 91.2 | 91.29 | 91.2 | 91.26 | 22207.0 |
| 2009-06-22 07:45:00 | SPY | ETF | 91.28 | 91.33 | 91.28 | 91.33 | 28153.0 |
| 2009-06-22 07:50:00 | SPY | ETF | 91.31 | 91.33 | 91.26 | 91.28 | 29433.0 |
| 2009-06-22 07:55:00 | SPY | ETF | 91.26 | 91.26 | 91.19 | 91.23 | 94340.0 |
| 2009-06-22 08:00:00 | SPY | ETF | 91.23 | 91.31 | 91.2 | 91.28 | 481065.0 |
| 2009-06-22 08:05:00 | SPY | ETF | 91.29 | 91.32 | 91.25 | 91.25 | 109364.0 |
| 2009-06-22 08:10:00 | SPY | ETF | 91.24 | 91.25 | 91.15 | 91.22 | 137858.0 |
| 2009-06-22 08:15:00 | SPY | ETF | 91.22 | 91.24 | 91.19 | 91.19 | 305392.0 |
| 2009-06-22 08:20:00 | SPY | ETF | 91.18 | 91.2 | 91.11 | 91.13 | 183456.0 |
| 2009-06-22 08:25:00 | SPY | ETF | 91.12 | 91.15 | 91.11 | 91.15 | 123031.0 |
| 2009-06-22 08:30:00 | SPY | ETF | 91.15 | 91.16 | 91.0 | 91.04 | 408188.0 |
| 2009-06-22 08:35:00 | SPY | ETF | 91.05 | 91.05 | 90.98 | 91.03 | 263520.0 |
| 2009-06-22 08:40:00 | SPY | ETF | 91.03 | 91.04 | 90.96 | 91.0 | 217671.0 |
| 2009-06-22 08:45:00 | SPY | ETF | 91.01 | 91.08 | 91.01 | 91.04 | 98339.0 |
| 2009-06-22 08:50:00 | SPY | ETF | 91.04 | 91.12 | 91.03 | 91.07 | 344350.0 |
| 2009-06-22 08:55:00 | SPY | ETF | 91.08 | 91.09 | 91.05 | 91.06 | 176422.0 |
| 2009-06-22 09:00:00 | SPY | ETF | 91.06 | 91.08 | 91.03 | 91.05 | 97347.0 |
| 2009-06-22 09:05:00 | SPY | ETF | 91.04 | 91.07 | 91.0 | 91.04 | 117211.0 |
| 2009-06-22 09:10:00 | SPY | ETF | 91.03 | 91.12 | 90.99 | 91.1 | 274185.0 |
| 2009-06-22 09:15:00 | SPY | ETF | 91.1 | 91.18 | 91.07 | 91.17 | 232681.0 |
| 2009-06-22 09:20:00 | SPY | ETF | 91.15 | 91.17 | 91.06 | 91.07 | 200179.0 |
| 2009-06-22 09:25:00 | SPY | ETF | 91.07 | 91.13 | 91.06 | 91.12 | 285742.0 |
| 2009-06-22 09:30:00 | SPY | ETF | 91.14 | 91.19 | 90.95 | 91.0 | 4150280.0 |
| 2009-06-22 09:35:00 | SPY | ETF | 90.99 | 91.02 | 90.84 | 90.93 | 6305002.0 |
> showing 50 of 30,131 rows — these rows as CSV