PREVIEW / etf_5min / 2009-10-15
file: by_date/etf_5min/2009/2009-10-15.parquet size: 736 KB rows: 31,125
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-10-15 04:20:00 | SPY | ETF | 109.2 | 109.2 | 109.2 | 109.2 | 100.0 |
| 2009-10-15 05:20:00 | SPY | ETF | 109.28 | 109.28 | 109.28 | 109.28 | 2000.0 |
| 2009-10-15 06:00:00 | SPY | ETF | 109.3 | 109.3 | 109.3 | 109.3 | 800.0 |
| 2009-10-15 06:05:00 | SPY | ETF | 109.25 | 109.25 | 109.19 | 109.19 | 4500.0 |
| 2009-10-15 06:40:00 | SPY | ETF | 109.28 | 109.28 | 109.28 | 109.28 | 200.0 |
| 2009-10-15 06:55:00 | SPY | ETF | 109.22 | 109.22 | 109.22 | 109.22 | 7700.0 |
| 2009-10-15 07:00:00 | SPY | ETF | 109.3 | 109.31 | 109.27 | 109.31 | 11472.0 |
| 2009-10-15 07:05:00 | SPY | ETF | 109.33 | 109.42 | 109.33 | 109.42 | 26700.0 |
| 2009-10-15 07:10:00 | SPY | ETF | 109.45 | 109.45 | 109.33 | 109.33 | 87950.0 |
| 2009-10-15 07:15:00 | SPY | ETF | 109.34 | 109.34 | 109.07 | 109.14 | 709139.0 |
| 2009-10-15 07:20:00 | SPY | ETF | 109.12 | 109.12 | 108.94 | 108.96 | 155090.0 |
| 2009-10-15 07:25:00 | SPY | ETF | 108.98 | 109.0 | 108.87 | 108.91 | 147550.0 |
| 2009-10-15 07:30:00 | SPY | ETF | 108.91 | 108.97 | 108.86 | 108.89 | 71981.0 |
| 2009-10-15 07:35:00 | SPY | ETF | 108.89 | 108.89 | 108.8 | 108.87 | 51900.0 |
| 2009-10-15 07:40:00 | SPY | ETF | 108.87 | 108.93 | 108.87 | 108.92 | 81075.0 |
| 2009-10-15 07:45:00 | SPY | ETF | 108.92 | 108.93 | 108.78 | 108.81 | 75389.0 |
| 2009-10-15 07:50:00 | SPY | ETF | 108.81 | 108.89 | 108.8 | 108.85 | 105590.0 |
| 2009-10-15 07:55:00 | SPY | ETF | 108.86 | 108.87 | 108.69 | 108.72 | 248990.0 |
| 2009-10-15 08:00:00 | SPY | ETF | 108.8 | 108.92 | 108.56 | 108.64 | 744357.0 |
| 2009-10-15 08:05:00 | SPY | ETF | 108.63 | 108.63 | 108.49 | 108.55 | 411070.0 |
| 2009-10-15 08:10:00 | SPY | ETF | 108.55 | 108.71 | 108.55 | 108.68 | 149037.0 |
| 2009-10-15 08:15:00 | SPY | ETF | 108.68 | 108.69 | 108.6 | 108.62 | 157545.0 |
| 2009-10-15 08:20:00 | SPY | ETF | 108.61 | 108.61 | 108.56 | 108.58 | 194601.0 |
| 2009-10-15 08:25:00 | SPY | ETF | 108.59 | 108.68 | 108.52 | 108.62 | 531392.0 |
| 2009-10-15 08:30:00 | SPY | ETF | 108.62 | 108.83 | 108.53 | 108.69 | 1379265.0 |
| 2009-10-15 08:35:00 | SPY | ETF | 108.7 | 108.81 | 108.7 | 108.74 | 292359.0 |
| 2009-10-15 08:40:00 | SPY | ETF | 108.74 | 108.75 | 108.64 | 108.64 | 239300.0 |
| 2009-10-15 08:45:00 | SPY | ETF | 108.64 | 108.69 | 108.62 | 108.69 | 350090.0 |
| 2009-10-15 08:50:00 | SPY | ETF | 108.68 | 108.69 | 108.63 | 108.67 | 154202.0 |
| 2009-10-15 08:55:00 | SPY | ETF | 108.67 | 108.69 | 108.67 | 108.68 | 214965.0 |
| 2009-10-15 09:00:00 | SPY | ETF | 108.68 | 108.76 | 108.68 | 108.76 | 191340.0 |
| 2009-10-15 09:05:00 | SPY | ETF | 108.76 | 108.81 | 108.7 | 108.81 | 438293.0 |
| 2009-10-15 09:10:00 | SPY | ETF | 108.81 | 108.83 | 108.71 | 108.72 | 234222.0 |
| 2009-10-15 09:15:00 | SPY | ETF | 108.73 | 108.74 | 108.68 | 108.71 | 95779.0 |
| 2009-10-15 09:20:00 | SPY | ETF | 108.72 | 108.78 | 108.72 | 108.74 | 104683.0 |
| 2009-10-15 09:25:00 | SPY | ETF | 108.75 | 108.78 | 108.69 | 108.78 | 274658.0 |
| 2009-10-15 09:30:00 | SPY | ETF | 108.78 | 108.93 | 108.74 | 108.93 | 3672079.0 |
| 2009-10-15 09:35:00 | SPY | ETF | 108.93 | 109.09 | 108.88 | 109.07 | 4738081.0 |
| 2009-10-15 09:40:00 | SPY | ETF | 109.08 | 109.12 | 108.95 | 108.98 | 3360596.0 |
| 2009-10-15 09:45:00 | SPY | ETF | 108.988 | 109.11 | 108.98 | 109.02 | 2294179.0 |
| 2009-10-15 09:50:00 | SPY | ETF | 109.03 | 109.15 | 109.0125 | 109.07 | 2583807.0 |
| 2009-10-15 09:55:00 | SPY | ETF | 109.08 | 109.22 | 109.04 | 109.219 | 2343314.0 |
| 2009-10-15 10:00:00 | SPY | ETF | 109.21 | 109.22 | 108.95 | 109.05 | 4605986.0 |
| 2009-10-15 10:05:00 | SPY | ETF | 109.065 | 109.1225 | 109.02 | 109.061 | 2039510.0 |
| 2009-10-15 10:10:00 | SPY | ETF | 109.06 | 109.13 | 108.84 | 108.96 | 3427935.0 |
| 2009-10-15 10:15:00 | SPY | ETF | 108.97 | 109.02 | 108.935 | 108.99 | 2437373.0 |
| 2009-10-15 10:20:00 | SPY | ETF | 108.99 | 109.08 | 108.91 | 109.05 | 1782870.0 |
| 2009-10-15 10:25:00 | SPY | ETF | 109.05 | 109.1 | 108.93 | 108.9392 | 1708073.0 |
| 2009-10-15 10:30:00 | SPY | ETF | 108.94 | 109.02 | 108.87 | 108.97 | 1752109.0 |
| 2009-10-15 10:35:00 | SPY | ETF | 108.975 | 108.979 | 108.79 | 108.8 | 2950799.0 |
> showing 50 of 31,125 rows — these rows as CSV