PREVIEW / etf_5min / 2013-05-31
file: by_date/etf_5min/2013/2013-05-31.parquet size: 1.0 MB rows: 43,099
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-31 04:00:00 | SPY | ETF | 165.18 | 165.18 | 165.0 | 165.0 | 4188.0 |
| 2013-05-31 04:05:00 | SPY | ETF | 165.07 | 165.12 | 165.03 | 165.12 | 12228.0 |
| 2013-05-31 04:15:00 | SPY | ETF | 165.0 | 165.0 | 165.0 | 165.0 | 1000.0 |
| 2013-05-31 04:20:00 | SPY | ETF | 164.99 | 164.99 | 164.91 | 164.91 | 3550.0 |
| 2013-05-31 04:25:00 | SPY | ETF | 164.91 | 164.91 | 164.86 | 164.86 | 2750.0 |
| 2013-05-31 04:30:00 | SPY | ETF | 164.93 | 164.93 | 164.91 | 164.91 | 1200.0 |
| 2013-05-31 04:35:00 | SPY | ETF | 164.9 | 164.9 | 164.9 | 164.9 | 15000.0 |
| 2013-05-31 04:40:00 | SPY | ETF | 164.94 | 164.94 | 164.94 | 164.94 | 300.0 |
| 2013-05-31 04:45:00 | SPY | ETF | 164.97 | 164.97 | 164.97 | 164.97 | 100.0 |
| 2013-05-31 04:50:00 | SPY | ETF | 164.86 | 164.86 | 164.85 | 164.85 | 3700.0 |
| 2013-05-31 04:55:00 | SPY | ETF | 164.85 | 164.85 | 164.85 | 164.85 | 8100.0 |
| 2013-05-31 05:00:00 | SPY | ETF | 164.81 | 164.81 | 164.72 | 164.74 | 51340.0 |
| 2013-05-31 05:05:00 | SPY | ETF | 164.77 | 164.77 | 164.77 | 164.77 | 500.0 |
| 2013-05-31 05:10:00 | SPY | ETF | 164.72 | 164.72 | 164.71 | 164.71 | 300.0 |
| 2013-05-31 05:15:00 | SPY | ETF | 164.74 | 164.79 | 164.74 | 164.77 | 1215.0 |
| 2013-05-31 05:20:00 | SPY | ETF | 164.76 | 164.84 | 164.76 | 164.82 | 11700.0 |
| 2013-05-31 05:25:00 | SPY | ETF | 164.82 | 164.82 | 164.77 | 164.77 | 13200.0 |
| 2013-05-31 05:30:00 | SPY | ETF | 164.77 | 164.77 | 164.7 | 164.7 | 56500.0 |
| 2013-05-31 05:35:00 | SPY | ETF | 164.7 | 164.7 | 164.61 | 164.63 | 4100.0 |
| 2013-05-31 05:40:00 | SPY | ETF | 164.69 | 164.69 | 164.61 | 164.61 | 500.0 |
| 2013-05-31 05:45:00 | SPY | ETF | 164.62 | 164.69 | 164.57 | 164.64 | 5750.0 |
| 2013-05-31 05:50:00 | SPY | ETF | 164.62 | 164.62 | 164.57 | 164.62 | 3600.0 |
| 2013-05-31 05:55:00 | SPY | ETF | 164.64 | 164.77 | 164.64 | 164.77 | 4100.0 |
| 2013-05-31 06:00:00 | SPY | ETF | 164.72 | 164.74 | 164.67 | 164.67 | 12134.0 |
| 2013-05-31 06:05:00 | SPY | ETF | 164.66 | 164.74 | 164.66 | 164.74 | 12400.0 |
| 2013-05-31 06:10:00 | SPY | ETF | 164.74 | 164.85 | 164.74 | 164.85 | 2035.0 |
| 2013-05-31 06:15:00 | SPY | ETF | 164.78 | 164.88 | 164.74 | 164.84 | 54100.0 |
| 2013-05-31 06:20:00 | SPY | ETF | 164.78 | 164.82 | 164.76 | 164.76 | 14090.0 |
| 2013-05-31 06:25:00 | SPY | ETF | 164.81 | 164.96 | 164.81 | 164.94 | 18600.0 |
| 2013-05-31 06:30:00 | SPY | ETF | 164.93 | 165.04 | 164.93 | 164.96 | 39615.0 |
| 2013-05-31 06:35:00 | SPY | ETF | 164.96 | 164.99 | 164.93 | 164.97 | 34900.0 |
| 2013-05-31 06:40:00 | SPY | ETF | 164.97 | 165.08 | 164.91 | 165.05 | 81200.0 |
| 2013-05-31 06:45:00 | SPY | ETF | 165.06 | 165.08 | 165.01 | 165.05 | 10300.0 |
| 2013-05-31 06:50:00 | SPY | ETF | 165.05 | 165.12 | 165.05 | 165.12 | 24800.0 |
| 2013-05-31 06:55:00 | SPY | ETF | 165.09 | 165.09 | 165.01 | 165.01 | 10600.0 |
| 2013-05-31 07:00:00 | SPY | ETF | 165.02 | 165.14 | 164.98 | 165.04 | 18000.0 |
| 2013-05-31 07:05:00 | SPY | ETF | 165.09 | 165.09 | 165.0 | 165.0 | 24664.0 |
| 2013-05-31 07:10:00 | SPY | ETF | 165.04 | 165.04 | 164.98 | 165.02 | 33000.0 |
| 2013-05-31 07:15:00 | SPY | ETF | 165.02 | 165.06 | 164.98 | 165.02 | 11490.0 |
| 2013-05-31 07:20:00 | SPY | ETF | 165.06 | 165.12 | 165.06 | 165.08 | 56420.0 |
| 2013-05-31 07:25:00 | SPY | ETF | 165.08 | 165.12 | 165.06 | 165.06 | 21800.0 |
| 2013-05-31 07:30:00 | SPY | ETF | 165.09 | 165.1 | 165.08 | 165.1 | 5300.0 |
| 2013-05-31 07:35:00 | SPY | ETF | 165.1 | 165.13 | 164.97 | 165.0 | 37100.0 |
| 2013-05-31 07:40:00 | SPY | ETF | 164.99 | 165.12 | 164.99 | 165.08 | 13900.0 |
| 2013-05-31 07:45:00 | SPY | ETF | 165.11 | 165.27 | 165.11 | 165.25 | 75200.0 |
| 2013-05-31 07:50:00 | SPY | ETF | 165.23 | 165.24 | 165.16 | 165.16 | 12600.0 |
| 2013-05-31 07:55:00 | SPY | ETF | 165.16 | 165.16 | 165.04 | 165.12 | 74330.0 |
| 2013-05-31 08:00:00 | SPY | ETF | 165.12 | 165.25 | 164.99 | 165.14 | 134609.0 |
| 2013-05-31 08:05:00 | SPY | ETF | 165.12 | 165.17 | 165.09 | 165.14 | 121143.0 |
| 2013-05-31 08:10:00 | SPY | ETF | 165.14 | 165.17 | 165.09 | 165.13 | 50840.0 |
> showing 50 of 43,099 rows — these rows as CSV