PREVIEW / etf_5min / 2013-12-18
file: by_date/etf_5min/2013/2013-12-18.parquet size: 1.0 MB rows: 43,025
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-12-18 04:00:00 | SPY | ETF | 178.71 | 179.17 | 178.71 | 179.17 | 62195.0 |
| 2013-12-18 04:05:00 | SPY | ETF | 179.11 | 179.11 | 179.11 | 179.11 | 2201.0 |
| 2013-12-18 04:10:00 | SPY | ETF | 178.94 | 178.94 | 178.94 | 178.94 | 2506.0 |
| 2013-12-18 04:15:00 | SPY | ETF | 178.87 | 178.96 | 178.86 | 178.96 | 1317.0 |
| 2013-12-18 04:20:00 | SPY | ETF | 178.99 | 178.99 | 178.99 | 178.99 | 100.0 |
| 2013-12-18 04:25:00 | SPY | ETF | 179.02 | 179.05 | 179.02 | 179.03 | 825.0 |
| 2013-12-18 04:30:00 | SPY | ETF | 178.96 | 178.96 | 178.96 | 178.96 | 100.0 |
| 2013-12-18 04:40:00 | SPY | ETF | 178.97 | 178.97 | 178.96 | 178.96 | 945.0 |
| 2013-12-18 04:45:00 | SPY | ETF | 178.94 | 178.94 | 178.94 | 178.94 | 176.0 |
| 2013-12-18 04:50:00 | SPY | ETF | 178.99 | 178.99 | 178.99 | 178.99 | 100.0 |
| 2013-12-18 04:55:00 | SPY | ETF | 179.0 | 179.04 | 179.0 | 179.04 | 2799.0 |
| 2013-12-18 05:00:00 | SPY | ETF | 179.05 | 179.05 | 179.02 | 179.02 | 200.0 |
| 2013-12-18 05:10:00 | SPY | ETF | 178.98 | 179.11 | 178.98 | 179.11 | 1076.0 |
| 2013-12-18 05:15:00 | SPY | ETF | 179.11 | 179.19 | 179.11 | 179.13 | 25853.0 |
| 2013-12-18 05:20:00 | SPY | ETF | 179.15 | 179.16 | 179.12 | 179.12 | 615.0 |
| 2013-12-18 05:25:00 | SPY | ETF | 179.14 | 179.14 | 179.14 | 179.14 | 103.0 |
| 2013-12-18 05:30:00 | SPY | ETF | 179.14 | 179.17 | 179.14 | 179.17 | 7972.0 |
| 2013-12-18 05:35:00 | SPY | ETF | 179.14 | 179.14 | 179.14 | 179.14 | 100.0 |
| 2013-12-18 05:40:00 | SPY | ETF | 179.17 | 179.17 | 179.17 | 179.17 | 100.0 |
| 2013-12-18 05:45:00 | SPY | ETF | 179.18 | 179.2 | 179.17 | 179.17 | 1164.0 |
| 2013-12-18 05:50:00 | SPY | ETF | 179.17 | 179.17 | 179.17 | 179.17 | 10000.0 |
| 2013-12-18 06:00:00 | SPY | ETF | 179.15 | 179.15 | 179.12 | 179.12 | 1881.0 |
| 2013-12-18 06:05:00 | SPY | ETF | 179.14 | 179.15 | 179.14 | 179.15 | 2000.0 |
| 2013-12-18 06:15:00 | SPY | ETF | 179.08 | 179.08 | 179.04 | 179.04 | 2948.0 |
| 2013-12-18 06:20:00 | SPY | ETF | 179.04 | 179.04 | 178.98 | 178.98 | 2306.0 |
| 2013-12-18 06:25:00 | SPY | ETF | 179.05 | 179.05 | 179.02 | 179.02 | 200.0 |
| 2013-12-18 06:30:00 | SPY | ETF | 178.98 | 179.0 | 178.97 | 178.99 | 3823.0 |
| 2013-12-18 06:35:00 | SPY | ETF | 179.02 | 179.05 | 178.88 | 178.88 | 3685.0 |
| 2013-12-18 06:40:00 | SPY | ETF | 178.9 | 178.92 | 178.87 | 178.92 | 1203.0 |
| 2013-12-18 06:45:00 | SPY | ETF | 178.89 | 178.96 | 178.86 | 178.96 | 2419.0 |
| 2013-12-18 06:50:00 | SPY | ETF | 178.93 | 178.93 | 178.89 | 178.89 | 3315.0 |
| 2013-12-18 06:55:00 | SPY | ETF | 178.91 | 178.97 | 178.91 | 178.96 | 1917.0 |
| 2013-12-18 07:00:00 | SPY | ETF | 178.93 | 178.93 | 178.87 | 178.87 | 5336.0 |
| 2013-12-18 07:05:00 | SPY | ETF | 178.87 | 178.91 | 178.84 | 178.84 | 2673.0 |
| 2013-12-18 07:10:00 | SPY | ETF | 178.87 | 178.93 | 178.87 | 178.9 | 3237.0 |
| 2013-12-18 07:15:00 | SPY | ETF | 178.91 | 178.92 | 178.84 | 178.87 | 3270.0 |
| 2013-12-18 07:20:00 | SPY | ETF | 178.86 | 178.86 | 178.78 | 178.78 | 13032.0 |
| 2013-12-18 07:25:00 | SPY | ETF | 178.75 | 178.81 | 178.75 | 178.81 | 33800.0 |
| 2013-12-18 07:30:00 | SPY | ETF | 178.81 | 178.85 | 178.81 | 178.83 | 7193.0 |
| 2013-12-18 07:35:00 | SPY | ETF | 178.84 | 178.85 | 178.84 | 178.85 | 2740.0 |
| 2013-12-18 07:40:00 | SPY | ETF | 178.84 | 178.85 | 178.82 | 178.82 | 3350.0 |
| 2013-12-18 07:45:00 | SPY | ETF | 178.85 | 178.86 | 178.83 | 178.83 | 22800.0 |
| 2013-12-18 07:50:00 | SPY | ETF | 178.83 | 178.84 | 178.82 | 178.83 | 3000.0 |
| 2013-12-18 07:55:00 | SPY | ETF | 178.83 | 178.83 | 178.82 | 178.82 | 19553.0 |
| 2013-12-18 08:00:00 | SPY | ETF | 178.83 | 178.91 | 178.8 | 178.83 | 13678.0 |
| 2013-12-18 08:05:00 | SPY | ETF | 178.81 | 178.81 | 178.74 | 178.76 | 38038.0 |
| 2013-12-18 08:10:00 | SPY | ETF | 178.75 | 178.76 | 178.72 | 178.75 | 32782.0 |
| 2013-12-18 08:15:00 | SPY | ETF | 178.75 | 178.79 | 178.74 | 178.79 | 39173.0 |
| 2013-12-18 08:20:00 | SPY | ETF | 178.77 | 178.83 | 178.77 | 178.78 | 14633.0 |
| 2013-12-18 08:25:00 | SPY | ETF | 178.77 | 178.81 | 178.76 | 178.81 | 24353.0 |
> showing 50 of 43,025 rows — these rows as CSV