PREVIEW / etf_5min / 2013-05-07
file: by_date/etf_5min/2013/2013-05-07.parquet size: 975 KB rows: 41,684
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-07 04:15:00 | SPY | ETF | 161.78 | 161.78 | 161.78 | 161.78 | 200.0 |
| 2013-05-07 05:00:00 | SPY | ETF | 161.79 | 161.79 | 161.79 | 161.79 | 500.0 |
| 2013-05-07 05:05:00 | SPY | ETF | 161.84 | 161.84 | 161.84 | 161.84 | 300.0 |
| 2013-05-07 05:15:00 | SPY | ETF | 161.86 | 161.86 | 161.86 | 161.86 | 3300.0 |
| 2013-05-07 05:20:00 | SPY | ETF | 161.86 | 161.91 | 161.86 | 161.91 | 400.0 |
| 2013-05-07 05:25:00 | SPY | ETF | 161.91 | 161.91 | 161.91 | 161.91 | 700.0 |
| 2013-05-07 05:40:00 | SPY | ETF | 161.88 | 161.91 | 161.88 | 161.91 | 400.0 |
| 2013-05-07 05:45:00 | SPY | ETF | 161.91 | 161.91 | 161.91 | 161.91 | 5000.0 |
| 2013-05-07 05:55:00 | SPY | ETF | 161.93 | 161.96 | 161.93 | 161.96 | 7700.0 |
| 2013-05-07 06:00:00 | SPY | ETF | 161.91 | 161.91 | 161.91 | 161.91 | 100.0 |
| 2013-05-07 06:05:00 | SPY | ETF | 161.96 | 161.96 | 161.96 | 161.96 | 700.0 |
| 2013-05-07 06:10:00 | SPY | ETF | 161.96 | 161.98 | 161.96 | 161.98 | 25900.0 |
| 2013-05-07 06:25:00 | SPY | ETF | 161.99 | 161.99 | 161.99 | 161.99 | 200.0 |
| 2013-05-07 06:30:00 | SPY | ETF | 162.0 | 162.02 | 162.0 | 162.02 | 844.0 |
| 2013-05-07 06:35:00 | SPY | ETF | 162.06 | 162.06 | 162.05 | 162.05 | 4000.0 |
| 2013-05-07 06:40:00 | SPY | ETF | 162.06 | 162.06 | 162.05 | 162.06 | 7300.0 |
| 2013-05-07 06:45:00 | SPY | ETF | 162.03 | 162.03 | 162.02 | 162.03 | 600.0 |
| 2013-05-07 06:50:00 | SPY | ETF | 162.03 | 162.03 | 162.03 | 162.03 | 100.0 |
| 2013-05-07 06:55:00 | SPY | ETF | 162.03 | 162.03 | 162.03 | 162.03 | 100.0 |
| 2013-05-07 07:00:00 | SPY | ETF | 162.03 | 162.06 | 162.03 | 162.05 | 6122.0 |
| 2013-05-07 07:05:00 | SPY | ETF | 162.05 | 162.07 | 162.05 | 162.05 | 3317.0 |
| 2013-05-07 07:10:00 | SPY | ETF | 162.04 | 162.05 | 162.02 | 162.02 | 6500.0 |
| 2013-05-07 07:15:00 | SPY | ETF | 162.03 | 162.03 | 162.01 | 162.03 | 5000.0 |
| 2013-05-07 07:20:00 | SPY | ETF | 162.01 | 162.02 | 162.0 | 162.0 | 9251.0 |
| 2013-05-07 07:25:00 | SPY | ETF | 162.02 | 162.03 | 162.0 | 162.02 | 32996.0 |
| 2013-05-07 07:30:00 | SPY | ETF | 162.03 | 162.05 | 162.0 | 162.03 | 12767.0 |
| 2013-05-07 07:35:00 | SPY | ETF | 162.03 | 162.06 | 162.0 | 162.03 | 5612.0 |
| 2013-05-07 07:40:00 | SPY | ETF | 162.03 | 162.07 | 162.03 | 162.07 | 4088.0 |
| 2013-05-07 07:45:00 | SPY | ETF | 162.07 | 162.11 | 162.07 | 162.09 | 39000.0 |
| 2013-05-07 07:50:00 | SPY | ETF | 162.09 | 162.12 | 162.08 | 162.11 | 23925.0 |
| 2013-05-07 07:55:00 | SPY | ETF | 162.11 | 162.11 | 162.08 | 162.1 | 36275.0 |
| 2013-05-07 08:00:00 | SPY | ETF | 162.0 | 162.13 | 161.343 | 162.13 | 361593.0 |
| 2013-05-07 08:05:00 | SPY | ETF | 162.13 | 162.13 | 162.06 | 162.07 | 14099.0 |
| 2013-05-07 08:10:00 | SPY | ETF | 162.08 | 162.08 | 162.04 | 162.07 | 10100.0 |
| 2013-05-07 08:15:00 | SPY | ETF | 162.08 | 162.08 | 162.06 | 162.08 | 24928.0 |
| 2013-05-07 08:20:00 | SPY | ETF | 162.08 | 162.16 | 162.08 | 162.14 | 74961.0 |
| 2013-05-07 08:25:00 | SPY | ETF | 162.12 | 162.16 | 162.12 | 162.13 | 62652.0 |
| 2013-05-07 08:30:00 | SPY | ETF | 162.13 | 162.14 | 162.09 | 162.11 | 48175.0 |
| 2013-05-07 08:35:00 | SPY | ETF | 162.1 | 162.13 | 162.09 | 162.1 | 119700.0 |
| 2013-05-07 08:40:00 | SPY | ETF | 162.1 | 162.14 | 162.09 | 162.1 | 36791.0 |
| 2013-05-07 08:45:00 | SPY | ETF | 162.09 | 162.09 | 162.03 | 162.03 | 61102.0 |
| 2013-05-07 08:50:00 | SPY | ETF | 162.04 | 162.07 | 162.02 | 162.02 | 47458.0 |
| 2013-05-07 08:55:00 | SPY | ETF | 162.02 | 162.05 | 161.99 | 162.01 | 40588.0 |
| 2013-05-07 09:00:00 | SPY | ETF | 162.01 | 162.1 | 161.99 | 162.1 | 75612.0 |
| 2013-05-07 09:05:00 | SPY | ETF | 162.1 | 162.12 | 162.08 | 162.1 | 62596.0 |
| 2013-05-07 09:10:00 | SPY | ETF | 162.11 | 162.13 | 162.11 | 162.12 | 43350.0 |
| 2013-05-07 09:15:00 | SPY | ETF | 162.13 | 162.14 | 162.11 | 162.12 | 57340.0 |
| 2013-05-07 09:20:00 | SPY | ETF | 162.12 | 162.15 | 162.11 | 162.13 | 95151.0 |
| 2013-05-07 09:25:00 | SPY | ETF | 162.13 | 162.16 | 162.08 | 162.11 | 241278.0 |
| 2013-05-07 09:30:00 | SPY | ETF | 162.13 | 162.17 | 162.0 | 162.15 | 3098864.0 |
> showing 50 of 41,684 rows — these rows as CSV