PREVIEW / etf_5min / 2009-03-10
file: by_date/etf_5min/2009/2009-03-10.parquet size: 703 KB rows: 30,205
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-10 04:15:00 | SPY | ETF | 68.95 | 69.2 | 68.95 | 69.2 | 500.0 |
| 2009-03-10 04:25:00 | SPY | ETF | 69.24 | 69.24 | 69.24 | 69.24 | 200.0 |
| 2009-03-10 04:30:00 | SPY | ETF | 69.19 | 69.19 | 69.19 | 69.19 | 300.0 |
| 2009-03-10 04:35:00 | SPY | ETF | 69.33 | 69.33 | 69.33 | 69.33 | 200.0 |
| 2009-03-10 04:40:00 | SPY | ETF | 69.38 | 69.4 | 69.38 | 69.4 | 210.0 |
| 2009-03-10 04:50:00 | SPY | ETF | 69.4 | 69.5 | 69.4 | 69.5 | 1700.0 |
| 2009-03-10 04:55:00 | SPY | ETF | 69.42 | 69.42 | 69.42 | 69.42 | 3800.0 |
| 2009-03-10 05:15:00 | SPY | ETF | 69.22 | 69.22 | 69.21 | 69.21 | 6000.0 |
| 2009-03-10 05:45:00 | SPY | ETF | 69.32 | 69.32 | 69.32 | 69.32 | 500.0 |
| 2009-03-10 05:50:00 | SPY | ETF | 69.37 | 69.45 | 69.37 | 69.45 | 1500.0 |
| 2009-03-10 05:55:00 | SPY | ETF | 69.42 | 69.42 | 69.42 | 69.42 | 300.0 |
| 2009-03-10 06:00:00 | SPY | ETF | 69.24 | 69.38 | 69.24 | 69.38 | 12600.0 |
| 2009-03-10 06:05:00 | SPY | ETF | 69.33 | 69.33 | 69.33 | 69.33 | 100.0 |
| 2009-03-10 06:10:00 | SPY | ETF | 69.36 | 69.36 | 69.36 | 69.36 | 200.0 |
| 2009-03-10 06:15:00 | SPY | ETF | 69.49 | 69.59 | 69.49 | 69.55 | 6318.0 |
| 2009-03-10 06:20:00 | SPY | ETF | 69.62 | 69.64 | 69.62 | 69.64 | 431.0 |
| 2009-03-10 06:25:00 | SPY | ETF | 69.6 | 69.69 | 69.6 | 69.63 | 7200.0 |
| 2009-03-10 06:30:00 | SPY | ETF | 69.65 | 69.69 | 69.64 | 69.64 | 36800.0 |
| 2009-03-10 06:35:00 | SPY | ETF | 69.61 | 69.61 | 69.58 | 69.61 | 15200.0 |
| 2009-03-10 06:40:00 | SPY | ETF | 69.53 | 69.55 | 69.5 | 69.5 | 27731.0 |
| 2009-03-10 06:45:00 | SPY | ETF | 69.56 | 69.56 | 69.5 | 69.53 | 3800.0 |
| 2009-03-10 06:50:00 | SPY | ETF | 69.48 | 69.49 | 69.48 | 69.48 | 1750.0 |
| 2009-03-10 07:00:00 | SPY | ETF | 69.49 | 69.59 | 69.35 | 69.37 | 400300.0 |
| 2009-03-10 07:05:00 | SPY | ETF | 69.36 | 69.48 | 69.35 | 69.48 | 122870.0 |
| 2009-03-10 07:10:00 | SPY | ETF | 69.48 | 69.53 | 69.48 | 69.52 | 102950.0 |
| 2009-03-10 07:15:00 | SPY | ETF | 69.49 | 69.5 | 69.39 | 69.39 | 58021.0 |
| 2009-03-10 07:20:00 | SPY | ETF | 69.42 | 69.42 | 69.37 | 69.4 | 19600.0 |
| 2009-03-10 07:25:00 | SPY | ETF | 69.4 | 69.4 | 69.3 | 69.33 | 24134.0 |
| 2009-03-10 07:30:00 | SPY | ETF | 69.32 | 69.32 | 69.26 | 69.3 | 163490.0 |
| 2009-03-10 07:35:00 | SPY | ETF | 69.33 | 69.41 | 69.33 | 69.38 | 87856.0 |
| 2009-03-10 07:40:00 | SPY | ETF | 69.38 | 69.45 | 69.38 | 69.45 | 31691.0 |
| 2009-03-10 07:45:00 | SPY | ETF | 69.43 | 69.44 | 69.35 | 69.35 | 51481.0 |
| 2009-03-10 07:50:00 | SPY | ETF | 69.43 | 69.43 | 69.37 | 69.4 | 2200.0 |
| 2009-03-10 07:55:00 | SPY | ETF | 69.41 | 69.5 | 69.41 | 69.44 | 224960.0 |
| 2009-03-10 08:00:00 | SPY | ETF | 69.44 | 69.46 | 68.75 | 69.42 | 115354.0 |
| 2009-03-10 08:05:00 | SPY | ETF | 69.42 | 69.5 | 69.35 | 69.5 | 641610.0 |
| 2009-03-10 08:10:00 | SPY | ETF | 69.45 | 69.61 | 69.43 | 69.58 | 485768.0 |
| 2009-03-10 08:15:00 | SPY | ETF | 69.59 | 69.64 | 69.55 | 69.61 | 172759.0 |
| 2009-03-10 08:20:00 | SPY | ETF | 69.61 | 69.61 | 69.41 | 69.43 | 258885.0 |
| 2009-03-10 08:25:00 | SPY | ETF | 69.44 | 69.51 | 69.43 | 69.49 | 95918.0 |
| 2009-03-10 08:30:00 | SPY | ETF | 69.49 | 69.61 | 69.47 | 69.52 | 335689.0 |
| 2009-03-10 08:35:00 | SPY | ETF | 69.5 | 69.59 | 69.46 | 69.57 | 162656.0 |
| 2009-03-10 08:40:00 | SPY | ETF | 69.57 | 69.6 | 68.88 | 69.59 | 160577.0 |
| 2009-03-10 08:45:00 | SPY | ETF | 69.57 | 69.58 | 69.14 | 69.42 | 731628.0 |
| 2009-03-10 08:50:00 | SPY | ETF | 69.42 | 69.47 | 69.38 | 69.43 | 343970.0 |
| 2009-03-10 08:55:00 | SPY | ETF | 69.44 | 69.54 | 69.25 | 69.32 | 1095470.0 |
| 2009-03-10 09:00:00 | SPY | ETF | 69.31 | 69.34 | 69.2 | 69.21 | 1055854.0 |
| 2009-03-10 09:05:00 | SPY | ETF | 69.21 | 69.52 | 69.21 | 69.26 | 947938.0 |
| 2009-03-10 09:10:00 | SPY | ETF | 69.26 | 69.4 | 69.26 | 69.31 | 564999.0 |
| 2009-03-10 09:15:00 | SPY | ETF | 69.32 | 69.49 | 69.31 | 69.42 | 802225.0 |
> showing 50 of 30,205 rows — these rows as CSV