PREVIEW / etf_5min / 2013-11-06
file: by_date/etf_5min/2013/2013-11-06.parquet size: 928 KB rows: 40,940
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-11-06 04:00:00 | SPY | ETF | 176.75 | 176.95 | 176.75 | 176.95 | 45967.0 |
| 2013-11-06 04:05:00 | SPY | ETF | 176.88 | 176.92 | 176.88 | 176.91 | 1114.0 |
| 2013-11-06 04:10:00 | SPY | ETF | 176.9 | 176.9 | 176.83 | 176.83 | 11600.0 |
| 2013-11-06 04:15:00 | SPY | ETF | 176.81 | 176.87 | 176.81 | 176.85 | 3100.0 |
| 2013-11-06 04:20:00 | SPY | ETF | 176.85 | 176.89 | 176.85 | 176.89 | 300.0 |
| 2013-11-06 04:30:00 | SPY | ETF | 176.94 | 176.96 | 176.94 | 176.96 | 269.0 |
| 2013-11-06 04:35:00 | SPY | ETF | 176.93 | 177.0 | 176.93 | 177.0 | 64379.0 |
| 2013-11-06 04:40:00 | SPY | ETF | 177.0 | 177.01 | 176.98 | 177.01 | 61439.0 |
| 2013-11-06 04:45:00 | SPY | ETF | 176.98 | 176.98 | 176.98 | 176.98 | 40000.0 |
| 2013-11-06 04:55:00 | SPY | ETF | 176.95 | 176.98 | 176.95 | 176.98 | 35100.0 |
| 2013-11-06 05:00:00 | SPY | ETF | 176.98 | 176.98 | 176.93 | 176.93 | 425.0 |
| 2013-11-06 05:05:00 | SPY | ETF | 176.95 | 177.02 | 176.95 | 177.0 | 30271.0 |
| 2013-11-06 05:10:00 | SPY | ETF | 177.0 | 177.0 | 177.0 | 177.0 | 408.0 |
| 2013-11-06 05:15:00 | SPY | ETF | 177.0 | 177.01 | 177.0 | 177.0 | 24600.0 |
| 2013-11-06 05:20:00 | SPY | ETF | 176.98 | 177.02 | 176.98 | 177.02 | 5992.0 |
| 2013-11-06 05:25:00 | SPY | ETF | 177.02 | 177.06 | 177.02 | 177.06 | 169963.0 |
| 2013-11-06 05:30:00 | SPY | ETF | 177.05 | 177.05 | 177.05 | 177.05 | 200.0 |
| 2013-11-06 05:35:00 | SPY | ETF | 177.05 | 177.07 | 177.03 | 177.07 | 23800.0 |
| 2013-11-06 05:40:00 | SPY | ETF | 177.05 | 177.05 | 177.03 | 177.03 | 12111.0 |
| 2013-11-06 05:45:00 | SPY | ETF | 177.07 | 177.08 | 177.07 | 177.08 | 60000.0 |
| 2013-11-06 05:50:00 | SPY | ETF | 177.08 | 177.16 | 177.08 | 177.12 | 86121.0 |
| 2013-11-06 05:55:00 | SPY | ETF | 177.15 | 177.17 | 177.12 | 177.12 | 99600.0 |
| 2013-11-06 06:00:00 | SPY | ETF | 177.16 | 177.2 | 177.16 | 177.2 | 300.0 |
| 2013-11-06 06:10:00 | SPY | ETF | 177.16 | 177.16 | 177.12 | 177.14 | 13700.0 |
| 2013-11-06 06:15:00 | SPY | ETF | 177.1 | 177.12 | 177.1 | 177.11 | 6200.0 |
| 2013-11-06 06:20:00 | SPY | ETF | 177.1 | 177.11 | 177.09 | 177.1 | 21371.0 |
| 2013-11-06 06:25:00 | SPY | ETF | 177.14 | 177.16 | 177.14 | 177.16 | 700.0 |
| 2013-11-06 06:30:00 | SPY | ETF | 177.18 | 177.19 | 177.16 | 177.16 | 19925.0 |
| 2013-11-06 06:35:00 | SPY | ETF | 177.13 | 177.13 | 177.06 | 177.06 | 506.0 |
| 2013-11-06 06:40:00 | SPY | ETF | 177.1 | 177.1 | 177.07 | 177.07 | 5313.0 |
| 2013-11-06 06:45:00 | SPY | ETF | 177.06 | 177.06 | 177.02 | 177.05 | 900.0 |
| 2013-11-06 06:50:00 | SPY | ETF | 177.02 | 177.03 | 177.0 | 177.0 | 1058.0 |
| 2013-11-06 06:55:00 | SPY | ETF | 177.01 | 177.01 | 177.0 | 177.0 | 5000.0 |
| 2013-11-06 07:00:00 | SPY | ETF | 177.03 | 177.06 | 177.02 | 177.04 | 7500.0 |
| 2013-11-06 07:05:00 | SPY | ETF | 177.06 | 177.06 | 177.01 | 177.04 | 69700.0 |
| 2013-11-06 07:10:00 | SPY | ETF | 176.96 | 176.98 | 176.93 | 176.94 | 51418.0 |
| 2013-11-06 07:15:00 | SPY | ETF | 176.93 | 177.0 | 176.93 | 176.99 | 9880.0 |
| 2013-11-06 07:20:00 | SPY | ETF | 176.98 | 177.04 | 176.98 | 177.03 | 4500.0 |
| 2013-11-06 07:25:00 | SPY | ETF | 177.04 | 177.1 | 177.04 | 177.09 | 36300.0 |
| 2013-11-06 07:30:00 | SPY | ETF | 177.09 | 177.12 | 177.09 | 177.1 | 17385.0 |
| 2013-11-06 07:35:00 | SPY | ETF | 177.08 | 177.09 | 177.06 | 177.08 | 3500.0 |
| 2013-11-06 07:40:00 | SPY | ETF | 177.07 | 177.09 | 177.04 | 177.06 | 5210.0 |
| 2013-11-06 07:45:00 | SPY | ETF | 177.06 | 177.06 | 177.06 | 177.06 | 6700.0 |
| 2013-11-06 07:50:00 | SPY | ETF | 177.03 | 177.03 | 177.01 | 177.03 | 6000.0 |
| 2013-11-06 07:55:00 | SPY | ETF | 177.02 | 177.04 | 177.01 | 177.01 | 7500.0 |
| 2013-11-06 08:00:00 | SPY | ETF | 177.0 | 177.07 | 176.95 | 177.0 | 32405.0 |
| 2013-11-06 08:05:00 | SPY | ETF | 177.05 | 177.05 | 176.96 | 177.0 | 27500.0 |
| 2013-11-06 08:10:00 | SPY | ETF | 177.0 | 177.0 | 176.96 | 176.98 | 19030.0 |
| 2013-11-06 08:15:00 | SPY | ETF | 176.96 | 176.98 | 176.91 | 176.93 | 45825.0 |
| 2013-11-06 08:20:00 | SPY | ETF | 176.95 | 176.97 | 176.95 | 176.97 | 70099.0 |
> showing 50 of 40,940 rows — these rows as CSV