PREVIEW / etf_5min / 2013-11-07
file: by_date/etf_5min/2013/2013-11-07.parquet size: 1.0 MB rows: 42,760
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-07 04:00:00 | SPY | ETF | 176.93 | 176.93 | 176.93 | 176.93 | 30100.0 |
| 2013-11-07 04:05:00 | SPY | ETF | 176.93 | 176.93 | 176.86 | 176.93 | 8700.0 |
| 2013-11-07 04:15:00 | SPY | ETF | 176.9 | 176.9 | 176.8 | 176.83 | 1100.0 |
| 2013-11-07 04:20:00 | SPY | ETF | 176.8 | 176.83 | 176.8 | 176.8 | 900.0 |
| 2013-11-07 04:30:00 | SPY | ETF | 176.8 | 176.8 | 176.79 | 176.79 | 400.0 |
| 2013-11-07 04:35:00 | SPY | ETF | 176.78 | 176.78 | 176.77 | 176.77 | 607.0 |
| 2013-11-07 04:40:00 | SPY | ETF | 176.83 | 176.83 | 176.83 | 176.83 | 200.0 |
| 2013-11-07 04:50:00 | SPY | ETF | 176.88 | 176.88 | 176.88 | 176.88 | 300.0 |
| 2013-11-07 04:55:00 | SPY | ETF | 176.89 | 176.89 | 176.88 | 176.88 | 520.0 |
| 2013-11-07 05:00:00 | SPY | ETF | 176.85 | 176.85 | 176.85 | 176.85 | 300.0 |
| 2013-11-07 05:05:00 | SPY | ETF | 176.88 | 176.88 | 176.88 | 176.88 | 411.0 |
| 2013-11-07 05:10:00 | SPY | ETF | 176.85 | 176.85 | 176.85 | 176.85 | 600.0 |
| 2013-11-07 05:15:00 | SPY | ETF | 176.85 | 176.93 | 176.85 | 176.93 | 2800.0 |
| 2013-11-07 05:20:00 | SPY | ETF | 176.93 | 176.93 | 176.93 | 176.93 | 100.0 |
| 2013-11-07 05:25:00 | SPY | ETF | 176.9 | 176.93 | 176.9 | 176.9 | 5400.0 |
| 2013-11-07 05:30:00 | SPY | ETF | 176.9 | 176.9 | 176.83 | 176.83 | 561.0 |
| 2013-11-07 05:35:00 | SPY | ETF | 176.86 | 176.88 | 176.85 | 176.85 | 1100.0 |
| 2013-11-07 05:40:00 | SPY | ETF | 176.83 | 176.83 | 176.83 | 176.83 | 200.0 |
| 2013-11-07 05:45:00 | SPY | ETF | 176.83 | 176.83 | 176.8 | 176.8 | 1200.0 |
| 2013-11-07 05:50:00 | SPY | ETF | 176.79 | 176.79 | 176.79 | 176.79 | 400.0 |
| 2013-11-07 05:55:00 | SPY | ETF | 176.79 | 176.79 | 176.79 | 176.79 | 25000.0 |
| 2013-11-07 06:00:00 | SPY | ETF | 176.79 | 176.79 | 176.78 | 176.78 | 21200.0 |
| 2013-11-07 06:05:00 | SPY | ETF | 176.81 | 176.83 | 176.81 | 176.83 | 350.0 |
| 2013-11-07 06:20:00 | SPY | ETF | 176.83 | 176.83 | 176.83 | 176.83 | 158.0 |
| 2013-11-07 06:30:00 | SPY | ETF | 176.8 | 176.8 | 176.75 | 176.75 | 1300.0 |
| 2013-11-07 06:40:00 | SPY | ETF | 176.79 | 176.79 | 176.79 | 176.79 | 249.0 |
| 2013-11-07 06:45:00 | SPY | ETF | 176.78 | 176.78 | 176.78 | 176.78 | 100.0 |
| 2013-11-07 06:50:00 | SPY | ETF | 176.8 | 176.8 | 176.8 | 176.8 | 200.0 |
| 2013-11-07 06:55:00 | SPY | ETF | 176.83 | 176.83 | 176.83 | 176.83 | 200.0 |
| 2013-11-07 07:00:00 | SPY | ETF | 176.81 | 176.83 | 176.8 | 176.83 | 2500.0 |
| 2013-11-07 07:05:00 | SPY | ETF | 176.84 | 176.84 | 176.82 | 176.82 | 600.0 |
| 2013-11-07 07:10:00 | SPY | ETF | 176.84 | 176.9 | 176.82 | 176.9 | 1800.0 |
| 2013-11-07 07:15:00 | SPY | ETF | 176.93 | 176.98 | 176.93 | 176.93 | 35400.0 |
| 2013-11-07 07:20:00 | SPY | ETF | 176.96 | 177.03 | 176.96 | 177.02 | 20000.0 |
| 2013-11-07 07:25:00 | SPY | ETF | 177.01 | 177.02 | 176.98 | 176.98 | 15750.0 |
| 2013-11-07 07:30:00 | SPY | ETF | 176.99 | 177.04 | 176.99 | 177.04 | 18897.0 |
| 2013-11-07 07:35:00 | SPY | ETF | 177.04 | 177.12 | 177.04 | 177.11 | 7797.0 |
| 2013-11-07 07:40:00 | SPY | ETF | 177.12 | 177.12 | 177.0 | 177.0 | 28496.0 |
| 2013-11-07 07:45:00 | SPY | ETF | 176.97 | 177.9 | 176.95 | 177.63 | 648926.0 |
| 2013-11-07 07:50:00 | SPY | ETF | 177.62 | 177.93 | 177.6 | 177.72 | 370810.0 |
| 2013-11-07 07:55:00 | SPY | ETF | 177.71 | 177.73 | 177.61 | 177.72 | 100819.0 |
| 2013-11-07 08:00:00 | SPY | ETF | 177.7 | 177.95 | 176.98 | 177.83 | 267362.0 |
| 2013-11-07 08:05:00 | SPY | ETF | 177.82 | 177.87 | 177.74 | 177.8 | 94891.0 |
| 2013-11-07 08:10:00 | SPY | ETF | 177.82 | 177.82 | 177.73 | 177.78 | 107360.0 |
| 2013-11-07 08:15:00 | SPY | ETF | 177.78 | 177.83 | 177.78 | 177.8 | 35544.0 |
| 2013-11-07 08:20:00 | SPY | ETF | 177.79 | 177.8 | 177.74 | 177.75 | 82750.0 |
| 2013-11-07 08:25:00 | SPY | ETF | 177.75 | 177.79 | 177.7 | 177.72 | 59801.0 |
| 2013-11-07 08:30:00 | SPY | ETF | 177.72 | 177.83 | 177.48 | 177.83 | 733344.0 |
| 2013-11-07 08:35:00 | SPY | ETF | 177.83 | 177.87 | 177.76 | 177.76 | 182074.0 |
| 2013-11-07 08:40:00 | SPY | ETF | 177.76 | 177.79 | 177.56 | 177.62 | 289370.0 |
> showing 50 of 42,760 rows — these rows as CSV