PREVIEW / etf_5min / 2012-02-15
file: by_date/etf_5min/2012/2012-02-15.parquet size: 933 KB rows: 38,591
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-15 04:00:00 | SPY | ETF | 135.7 | 135.95 | 135.7 | 135.95 | 16183.0 |
| 2012-02-15 04:05:00 | SPY | ETF | 135.94 | 135.94 | 135.94 | 135.94 | 5000.0 |
| 2012-02-15 04:10:00 | SPY | ETF | 136.0 | 136.0 | 136.0 | 136.0 | 200.0 |
| 2012-02-15 04:30:00 | SPY | ETF | 136.0 | 136.02 | 135.97 | 136.02 | 62166.0 |
| 2012-02-15 04:35:00 | SPY | ETF | 136.01 | 136.01 | 136.01 | 136.01 | 850.0 |
| 2012-02-15 04:45:00 | SPY | ETF | 136.01 | 136.01 | 136.0 | 136.0 | 1222.0 |
| 2012-02-15 04:50:00 | SPY | ETF | 135.99 | 136.05 | 135.96 | 136.01 | 53278.0 |
| 2012-02-15 05:00:00 | SPY | ETF | 136.03 | 136.06 | 136.03 | 136.06 | 1370.0 |
| 2012-02-15 05:05:00 | SPY | ETF | 136.04 | 136.09 | 136.04 | 136.09 | 5200.0 |
| 2012-02-15 05:15:00 | SPY | ETF | 136.12 | 136.14 | 136.12 | 136.14 | 250.0 |
| 2012-02-15 05:25:00 | SPY | ETF | 136.12 | 136.12 | 136.12 | 136.12 | 200.0 |
| 2012-02-15 05:30:00 | SPY | ETF | 136.1 | 136.1 | 136.08 | 136.08 | 500.0 |
| 2012-02-15 05:35:00 | SPY | ETF | 136.05 | 136.05 | 136.05 | 136.05 | 1000.0 |
| 2012-02-15 05:40:00 | SPY | ETF | 136.08 | 136.08 | 135.93 | 135.93 | 5300.0 |
| 2012-02-15 05:45:00 | SPY | ETF | 135.99 | 135.99 | 135.91 | 135.91 | 300.0 |
| 2012-02-15 05:50:00 | SPY | ETF | 135.91 | 136.0 | 135.91 | 135.93 | 3050.0 |
| 2012-02-15 06:00:00 | SPY | ETF | 135.96 | 135.96 | 135.96 | 135.96 | 500.0 |
| 2012-02-15 06:05:00 | SPY | ETF | 135.98 | 135.98 | 135.98 | 135.98 | 200.0 |
| 2012-02-15 06:10:00 | SPY | ETF | 136.0 | 136.0 | 135.98 | 135.98 | 500.0 |
| 2012-02-15 06:15:00 | SPY | ETF | 135.97 | 135.98 | 135.97 | 135.98 | 1200.0 |
| 2012-02-15 06:25:00 | SPY | ETF | 136.0 | 136.02 | 136.0 | 136.02 | 300.0 |
| 2012-02-15 06:30:00 | SPY | ETF | 136.02 | 136.02 | 135.98 | 135.98 | 25200.0 |
| 2012-02-15 06:35:00 | SPY | ETF | 136.04 | 136.07 | 136.02 | 136.04 | 27500.0 |
| 2012-02-15 06:40:00 | SPY | ETF | 136.07 | 136.13 | 136.07 | 136.07 | 68980.0 |
| 2012-02-15 06:45:00 | SPY | ETF | 136.07 | 136.07 | 136.05 | 136.05 | 5300.0 |
| 2012-02-15 06:50:00 | SPY | ETF | 136.05 | 136.07 | 136.02 | 136.06 | 7550.0 |
| 2012-02-15 06:55:00 | SPY | ETF | 135.99 | 136.05 | 135.99 | 136.05 | 57500.0 |
| 2012-02-15 07:00:00 | SPY | ETF | 135.99 | 136.04 | 135.95 | 136.04 | 27382.0 |
| 2012-02-15 07:05:00 | SPY | ETF | 136.04 | 136.09 | 136.04 | 136.05 | 30882.0 |
| 2012-02-15 07:10:00 | SPY | ETF | 136.01 | 136.08 | 135.99 | 136.08 | 10240.0 |
| 2012-02-15 07:15:00 | SPY | ETF | 136.07 | 136.16 | 136.04 | 136.04 | 113116.0 |
| 2012-02-15 07:20:00 | SPY | ETF | 136.04 | 136.11 | 136.04 | 136.09 | 56450.0 |
| 2012-02-15 07:25:00 | SPY | ETF | 136.12 | 136.19 | 136.1 | 136.19 | 152867.0 |
| 2012-02-15 07:30:00 | SPY | ETF | 136.18 | 136.23 | 136.17 | 136.19 | 81980.0 |
| 2012-02-15 07:35:00 | SPY | ETF | 136.19 | 136.23 | 136.15 | 136.2 | 62097.0 |
| 2012-02-15 07:40:00 | SPY | ETF | 136.2 | 136.2 | 136.12 | 136.16 | 41028.0 |
| 2012-02-15 07:45:00 | SPY | ETF | 136.15 | 136.19 | 136.14 | 136.17 | 94000.0 |
| 2012-02-15 07:50:00 | SPY | ETF | 136.19 | 136.19 | 136.02 | 136.05 | 174348.0 |
| 2012-02-15 07:55:00 | SPY | ETF | 136.06 | 136.07 | 136.0 | 136.0 | 98347.0 |
| 2012-02-15 08:00:00 | SPY | ETF | 136.0 | 136.06 | 135.53 | 136.02 | 114026.0 |
| 2012-02-15 08:05:00 | SPY | ETF | 136.17 | 136.17 | 135.9 | 135.93 | 203063.0 |
| 2012-02-15 08:10:00 | SPY | ETF | 135.93 | 136.0 | 135.68 | 135.7 | 942281.0 |
| 2012-02-15 08:15:00 | SPY | ETF | 135.68 | 135.76 | 135.52 | 135.76 | 749342.0 |
| 2012-02-15 08:20:00 | SPY | ETF | 135.72 | 135.78 | 135.66 | 135.78 | 139750.0 |
| 2012-02-15 08:25:00 | SPY | ETF | 135.79 | 135.85 | 135.76 | 135.85 | 206353.0 |
| 2012-02-15 08:30:00 | SPY | ETF | 135.85 | 135.92 | 135.77 | 135.81 | 233790.0 |
| 2012-02-15 08:35:00 | SPY | ETF | 135.83 | 135.87 | 135.78 | 135.78 | 64083.0 |
| 2012-02-15 08:40:00 | SPY | ETF | 135.78 | 135.84 | 135.7 | 135.8 | 194728.0 |
| 2012-02-15 08:45:00 | SPY | ETF | 135.8 | 135.83 | 135.63 | 135.64 | 186894.0 |
| 2012-02-15 08:50:00 | SPY | ETF | 135.64 | 135.73 | 135.62 | 135.71 | 483014.0 |
> showing 50 of 38,591 rows — these rows as CSV