PREVIEW / etf_5min / 2009-03-31
file: by_date/etf_5min/2009/2009-03-31.parquet size: 662 KB rows: 28,096
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-31 04:15:00 | SPY | ETF | 79.61 | 79.61 | 79.5 | 79.5 | 2700.0 |
| 2009-03-31 04:20:00 | SPY | ETF | 79.54 | 79.54 | 79.54 | 79.54 | 200.0 |
| 2009-03-31 04:25:00 | SPY | ETF | 79.57 | 79.6 | 79.57 | 79.6 | 7834.0 |
| 2009-03-31 04:30:00 | SPY | ETF | 79.59 | 79.59 | 79.59 | 79.59 | 300.0 |
| 2009-03-31 04:40:00 | SPY | ETF | 79.51 | 79.58 | 79.51 | 79.58 | 2800.0 |
| 2009-03-31 05:00:00 | SPY | ETF | 79.52 | 79.52 | 79.52 | 79.52 | 100.0 |
| 2009-03-31 05:10:00 | SPY | ETF | 79.46 | 79.46 | 79.46 | 79.46 | 201.0 |
| 2009-03-31 05:30:00 | SPY | ETF | 79.56 | 79.56 | 79.56 | 79.56 | 200.0 |
| 2009-03-31 05:35:00 | SPY | ETF | 79.6 | 79.6 | 79.6 | 79.6 | 100.0 |
| 2009-03-31 05:40:00 | SPY | ETF | 79.64 | 79.64 | 79.64 | 79.64 | 100.0 |
| 2009-03-31 05:50:00 | SPY | ETF | 79.56 | 79.56 | 79.56 | 79.56 | 4000.0 |
| 2009-03-31 06:05:00 | SPY | ETF | 79.28 | 79.28 | 79.28 | 79.28 | 2500.0 |
| 2009-03-31 06:10:00 | SPY | ETF | 79.22 | 79.22 | 79.22 | 79.22 | 600.0 |
| 2009-03-31 06:15:00 | SPY | ETF | 79.3 | 79.3 | 79.3 | 79.3 | 20000.0 |
| 2009-03-31 06:20:00 | SPY | ETF | 79.35 | 79.43 | 79.35 | 79.43 | 7500.0 |
| 2009-03-31 06:25:00 | SPY | ETF | 79.62 | 79.64 | 79.62 | 79.64 | 2600.0 |
| 2009-03-31 06:30:00 | SPY | ETF | 79.65 | 79.65 | 79.65 | 79.65 | 15000.0 |
| 2009-03-31 06:35:00 | SPY | ETF | 79.58 | 79.58 | 79.53 | 79.53 | 25350.0 |
| 2009-03-31 06:40:00 | SPY | ETF | 79.66 | 79.66 | 79.66 | 79.66 | 2700.0 |
| 2009-03-31 06:45:00 | SPY | ETF | 79.66 | 79.7 | 79.65 | 79.7 | 51000.0 |
| 2009-03-31 06:50:00 | SPY | ETF | 79.65 | 79.65 | 79.65 | 79.65 | 1000.0 |
| 2009-03-31 06:55:00 | SPY | ETF | 79.7 | 79.73 | 79.7 | 79.72 | 10025.0 |
| 2009-03-31 07:00:00 | SPY | ETF | 79.65 | 79.65 | 79.59 | 79.6 | 49700.0 |
| 2009-03-31 07:05:00 | SPY | ETF | 79.6 | 79.69 | 79.59 | 79.69 | 74400.0 |
| 2009-03-31 07:10:00 | SPY | ETF | 79.63 | 79.66 | 79.58 | 79.6 | 72200.0 |
| 2009-03-31 07:15:00 | SPY | ETF | 79.59 | 79.59 | 79.57 | 79.58 | 70100.0 |
| 2009-03-31 07:20:00 | SPY | ETF | 79.58 | 79.6 | 79.54 | 79.58 | 37700.0 |
| 2009-03-31 07:25:00 | SPY | ETF | 79.6 | 79.6 | 79.45 | 79.45 | 252800.0 |
| 2009-03-31 07:30:00 | SPY | ETF | 79.46 | 79.5 | 79.46 | 79.5 | 93447.0 |
| 2009-03-31 07:35:00 | SPY | ETF | 79.5 | 79.51 | 79.47 | 79.47 | 66775.0 |
| 2009-03-31 07:40:00 | SPY | ETF | 79.47 | 79.54 | 79.45 | 79.54 | 47500.0 |
| 2009-03-31 07:45:00 | SPY | ETF | 79.54 | 79.55 | 79.46 | 79.5 | 70280.0 |
| 2009-03-31 07:50:00 | SPY | ETF | 79.51 | 79.57 | 79.51 | 79.52 | 41400.0 |
| 2009-03-31 07:55:00 | SPY | ETF | 79.53 | 79.56 | 79.53 | 79.54 | 14100.0 |
| 2009-03-31 08:00:00 | SPY | ETF | 79.53 | 79.71 | 79.1468 | 79.69 | 878421.0 |
| 2009-03-31 08:05:00 | SPY | ETF | 79.71 | 79.74 | 79.63 | 79.7 | 329521.0 |
| 2009-03-31 08:10:00 | SPY | ETF | 79.7 | 79.74 | 79.68 | 79.68 | 148680.0 |
| 2009-03-31 08:15:00 | SPY | ETF | 79.68 | 79.74 | 79.67 | 79.68 | 118481.0 |
| 2009-03-31 08:20:00 | SPY | ETF | 79.68 | 79.7 | 79.62 | 79.66 | 238374.0 |
| 2009-03-31 08:25:00 | SPY | ETF | 79.66 | 79.7 | 79.62 | 79.63 | 155497.0 |
| 2009-03-31 08:30:00 | SPY | ETF | 79.62 | 79.66 | 79.58 | 79.66 | 174380.0 |
| 2009-03-31 08:35:00 | SPY | ETF | 79.67 | 79.68 | 79.62 | 79.68 | 139713.0 |
| 2009-03-31 08:40:00 | SPY | ETF | 79.67 | 79.76 | 79.62 | 79.74 | 212758.0 |
| 2009-03-31 08:45:00 | SPY | ETF | 79.73 | 79.76 | 79.66 | 79.69 | 47045.0 |
| 2009-03-31 08:50:00 | SPY | ETF | 79.7 | 79.7 | 79.58 | 79.62 | 92408.0 |
| 2009-03-31 08:55:00 | SPY | ETF | 79.63 | 79.66 | 79.6 | 79.65 | 100070.0 |
| 2009-03-31 09:00:00 | SPY | ETF | 79.65 | 79.65 | 79.54 | 79.64 | 198827.0 |
| 2009-03-31 09:05:00 | SPY | ETF | 79.63 | 79.64 | 79.59 | 79.61 | 68897.0 |
| 2009-03-31 09:10:00 | SPY | ETF | 79.6 | 79.61 | 79.53 | 79.61 | 173251.0 |
| 2009-03-31 09:15:00 | SPY | ETF | 79.61 | 79.71 | 79.53 | 79.53 | 281846.0 |
> showing 50 of 28,096 rows — these rows as CSV