PREVIEW / etf_5min / 2009-09-23
file: by_date/etf_5min/2009/2009-09-23.parquet size: 741 KB rows: 30,761
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-09-23 04:15:00 | SPY | ETF | 107.45 | 107.45 | 107.45 | 107.45 | 300.0 |
| 2009-09-23 04:20:00 | SPY | ETF | 107.4 | 107.4 | 107.39 | 107.39 | 600.0 |
| 2009-09-23 04:25:00 | SPY | ETF | 107.33 | 107.33 | 107.33 | 107.33 | 400.0 |
| 2009-09-23 04:30:00 | SPY | ETF | 107.34 | 107.34 | 107.34 | 107.34 | 300.0 |
| 2009-09-23 04:55:00 | SPY | ETF | 107.44 | 107.45 | 107.44 | 107.45 | 200.0 |
| 2009-09-23 05:00:00 | SPY | ETF | 107.42 | 107.42 | 107.42 | 107.42 | 100.0 |
| 2009-09-23 05:20:00 | SPY | ETF | 107.48 | 107.48 | 107.44 | 107.44 | 400.0 |
| 2009-09-23 05:30:00 | SPY | ETF | 107.44 | 107.44 | 107.44 | 107.44 | 1700.0 |
| 2009-09-23 05:40:00 | SPY | ETF | 107.37 | 107.37 | 107.37 | 107.37 | 10000.0 |
| 2009-09-23 05:45:00 | SPY | ETF | 107.22 | 107.22 | 107.22 | 107.22 | 2000.0 |
| 2009-09-23 05:50:00 | SPY | ETF | 107.19 | 107.19 | 107.15 | 107.15 | 22000.0 |
| 2009-09-23 05:55:00 | SPY | ETF | 107.15 | 107.15 | 107.13 | 107.14 | 25000.0 |
| 2009-09-23 06:00:00 | SPY | ETF | 107.16 | 107.16 | 107.16 | 107.16 | 8300.0 |
| 2009-09-23 06:05:00 | SPY | ETF | 107.19 | 107.26 | 107.19 | 107.26 | 17100.0 |
| 2009-09-23 06:15:00 | SPY | ETF | 107.19 | 107.19 | 107.19 | 107.19 | 1000.0 |
| 2009-09-23 06:20:00 | SPY | ETF | 107.17 | 107.21 | 107.17 | 107.21 | 8000.0 |
| 2009-09-23 06:40:00 | SPY | ETF | 107.26 | 107.26 | 107.26 | 107.26 | 5000.0 |
| 2009-09-23 06:45:00 | SPY | ETF | 107.27 | 107.29 | 107.27 | 107.29 | 10000.0 |
| 2009-09-23 06:55:00 | SPY | ETF | 107.26 | 107.26 | 107.26 | 107.26 | 15000.0 |
| 2009-09-23 07:00:00 | SPY | ETF | 107.27 | 107.36 | 107.27 | 107.33 | 79296.0 |
| 2009-09-23 07:05:00 | SPY | ETF | 107.3 | 107.34 | 107.3 | 107.34 | 10500.0 |
| 2009-09-23 07:10:00 | SPY | ETF | 107.33 | 107.35 | 107.32 | 107.35 | 14200.0 |
| 2009-09-23 07:15:00 | SPY | ETF | 107.38 | 107.38 | 107.35 | 107.35 | 11800.0 |
| 2009-09-23 07:20:00 | SPY | ETF | 107.36 | 107.36 | 107.35 | 107.36 | 524.0 |
| 2009-09-23 07:25:00 | SPY | ETF | 107.35 | 107.4 | 107.35 | 107.4 | 15376.0 |
| 2009-09-23 07:30:00 | SPY | ETF | 107.42 | 107.42 | 107.37 | 107.39 | 46800.0 |
| 2009-09-23 07:35:00 | SPY | ETF | 107.39 | 107.5 | 107.39 | 107.44 | 94376.0 |
| 2009-09-23 07:40:00 | SPY | ETF | 107.46 | 107.47 | 107.42 | 107.42 | 33500.0 |
| 2009-09-23 07:45:00 | SPY | ETF | 107.46 | 107.46 | 107.42 | 107.44 | 74200.0 |
| 2009-09-23 07:50:00 | SPY | ETF | 107.44 | 107.46 | 107.44 | 107.44 | 55277.0 |
| 2009-09-23 07:55:00 | SPY | ETF | 107.42 | 107.42 | 107.41 | 107.41 | 7500.0 |
| 2009-09-23 08:00:00 | SPY | ETF | 107.39 | 107.42 | 107.25 | 107.39 | 148700.0 |
| 2009-09-23 08:05:00 | SPY | ETF | 107.39 | 107.43 | 107.39 | 107.43 | 35271.0 |
| 2009-09-23 08:10:00 | SPY | ETF | 107.42 | 107.43 | 107.41 | 107.42 | 39363.0 |
| 2009-09-23 08:15:00 | SPY | ETF | 107.42 | 107.43 | 107.4 | 107.42 | 72025.0 |
| 2009-09-23 08:20:00 | SPY | ETF | 107.05 | 107.42 | 107.05 | 107.41 | 218800.0 |
| 2009-09-23 08:25:00 | SPY | ETF | 107.41 | 107.41 | 107.37 | 107.37 | 33600.0 |
| 2009-09-23 08:30:00 | SPY | ETF | 107.37 | 107.41 | 107.37 | 107.37 | 40607.0 |
| 2009-09-23 08:35:00 | SPY | ETF | 107.37 | 107.38 | 107.33 | 107.35 | 45826.0 |
| 2009-09-23 08:40:00 | SPY | ETF | 107.35 | 107.38 | 107.34 | 107.38 | 38587.0 |
| 2009-09-23 08:45:00 | SPY | ETF | 107.39 | 107.43 | 107.38 | 107.38 | 67296.0 |
| 2009-09-23 08:50:00 | SPY | ETF | 107.4 | 107.41 | 107.39 | 107.41 | 16812.0 |
| 2009-09-23 08:55:00 | SPY | ETF | 107.41 | 107.44 | 107.39 | 107.39 | 49900.0 |
| 2009-09-23 09:00:00 | SPY | ETF | 107.38 | 107.39 | 107.35 | 107.38 | 27992.0 |
| 2009-09-23 09:05:00 | SPY | ETF | 107.36 | 107.39 | 107.36 | 107.37 | 64372.0 |
| 2009-09-23 09:10:00 | SPY | ETF | 107.37 | 107.4 | 107.35 | 107.4 | 154910.0 |
| 2009-09-23 09:15:00 | SPY | ETF | 107.39 | 107.39 | 107.37 | 107.38 | 17866.0 |
| 2009-09-23 09:20:00 | SPY | ETF | 107.37 | 107.43 | 107.35 | 107.43 | 220244.0 |
| 2009-09-23 09:25:00 | SPY | ETF | 107.42 | 107.42 | 107.32 | 107.33 | 178809.0 |
| 2009-09-23 09:30:00 | SPY | ETF | 107.32 | 107.33 | 107.2 | 107.23 | 3146000.0 |
> showing 50 of 30,761 rows — these rows as CSV