PREVIEW / etf_5min / 2014-03-03
file: by_date/etf_5min/2014/2014-03-03.parquet size: 1.1 MB rows: 47,725
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-03 04:00:00 | SPY | ETF | 185.1 | 185.1 | 184.91 | 184.91 | 9141.0 |
| 2014-03-03 04:05:00 | SPY | ETF | 184.89 | 184.91 | 184.87 | 184.9 | 15253.0 |
| 2014-03-03 04:10:00 | SPY | ETF | 184.87 | 184.88 | 184.84 | 184.84 | 13448.0 |
| 2014-03-03 04:15:00 | SPY | ETF | 184.87 | 184.87 | 184.84 | 184.87 | 2790.0 |
| 2014-03-03 04:20:00 | SPY | ETF | 184.89 | 184.9 | 184.87 | 184.87 | 1833.0 |
| 2014-03-03 04:25:00 | SPY | ETF | 184.88 | 184.89 | 184.88 | 184.89 | 650.0 |
| 2014-03-03 04:30:00 | SPY | ETF | 184.91 | 184.91 | 184.87 | 184.87 | 582.0 |
| 2014-03-03 04:35:00 | SPY | ETF | 184.88 | 184.88 | 184.76 | 184.76 | 1176.0 |
| 2014-03-03 04:40:00 | SPY | ETF | 184.71 | 184.71 | 184.64 | 184.69 | 1400.0 |
| 2014-03-03 04:45:00 | SPY | ETF | 184.75 | 184.75 | 184.62 | 184.69 | 18150.0 |
| 2014-03-03 04:50:00 | SPY | ETF | 184.69 | 184.69 | 184.61 | 184.62 | 2100.0 |
| 2014-03-03 04:55:00 | SPY | ETF | 184.6 | 184.6 | 184.6 | 184.6 | 357.0 |
| 2014-03-03 05:00:00 | SPY | ETF | 184.74 | 184.74 | 184.73 | 184.73 | 225.0 |
| 2014-03-03 05:05:00 | SPY | ETF | 184.69 | 184.7 | 184.64 | 184.69 | 67533.0 |
| 2014-03-03 05:10:00 | SPY | ETF | 184.7 | 184.74 | 184.7 | 184.74 | 1650.0 |
| 2014-03-03 05:15:00 | SPY | ETF | 184.72 | 184.84 | 184.72 | 184.84 | 725.0 |
| 2014-03-03 05:20:00 | SPY | ETF | 184.84 | 184.87 | 184.82 | 184.84 | 4125.0 |
| 2014-03-03 05:25:00 | SPY | ETF | 184.84 | 184.84 | 184.8 | 184.8 | 2200.0 |
| 2014-03-03 05:30:00 | SPY | ETF | 184.76 | 184.76 | 184.66 | 184.67 | 13148.0 |
| 2014-03-03 05:35:00 | SPY | ETF | 184.67 | 184.67 | 184.55 | 184.57 | 21582.0 |
| 2014-03-03 05:40:00 | SPY | ETF | 184.59 | 184.59 | 184.46 | 184.49 | 18814.0 |
| 2014-03-03 05:45:00 | SPY | ETF | 184.5 | 184.55 | 184.5 | 184.53 | 15006.0 |
| 2014-03-03 05:50:00 | SPY | ETF | 184.55 | 184.59 | 184.54 | 184.59 | 1559.0 |
| 2014-03-03 05:55:00 | SPY | ETF | 184.59 | 184.59 | 184.52 | 184.52 | 2952.0 |
| 2014-03-03 06:00:00 | SPY | ETF | 184.5 | 184.5 | 184.4 | 184.4 | 10584.0 |
| 2014-03-03 06:05:00 | SPY | ETF | 184.4 | 184.4 | 184.26 | 184.26 | 26167.0 |
| 2014-03-03 06:10:00 | SPY | ETF | 184.26 | 184.35 | 184.25 | 184.35 | 9877.0 |
| 2014-03-03 06:15:00 | SPY | ETF | 184.34 | 184.44 | 184.34 | 184.44 | 8088.0 |
| 2014-03-03 06:20:00 | SPY | ETF | 184.4 | 184.4 | 184.35 | 184.35 | 5791.0 |
| 2014-03-03 06:25:00 | SPY | ETF | 184.39 | 184.4 | 184.31 | 184.31 | 53160.0 |
| 2014-03-03 06:30:00 | SPY | ETF | 184.32 | 184.32 | 184.24 | 184.27 | 18759.0 |
| 2014-03-03 06:35:00 | SPY | ETF | 184.26 | 184.27 | 184.15 | 184.17 | 19025.0 |
| 2014-03-03 06:40:00 | SPY | ETF | 184.18 | 184.32 | 184.1 | 184.32 | 48174.0 |
| 2014-03-03 06:45:00 | SPY | ETF | 184.3 | 184.37 | 184.28 | 184.33 | 45540.0 |
| 2014-03-03 06:50:00 | SPY | ETF | 184.3 | 184.34 | 184.23 | 184.23 | 7950.0 |
| 2014-03-03 06:55:00 | SPY | ETF | 184.24 | 184.24 | 184.17 | 184.19 | 74948.0 |
| 2014-03-03 07:00:00 | SPY | ETF | 184.17 | 184.3 | 184.13 | 184.3 | 80256.0 |
| 2014-03-03 07:05:00 | SPY | ETF | 184.3 | 184.35 | 184.21 | 184.35 | 175979.0 |
| 2014-03-03 07:10:00 | SPY | ETF | 184.35 | 184.35 | 184.2 | 184.2 | 113075.0 |
| 2014-03-03 07:15:00 | SPY | ETF | 184.22 | 184.23 | 184.09 | 184.14 | 130591.0 |
| 2014-03-03 07:20:00 | SPY | ETF | 184.13 | 184.33 | 184.11 | 184.27 | 60645.0 |
| 2014-03-03 07:25:00 | SPY | ETF | 184.24 | 184.26 | 184.19 | 184.24 | 29697.0 |
| 2014-03-03 07:30:00 | SPY | ETF | 184.21 | 184.27 | 184.21 | 184.25 | 20767.0 |
| 2014-03-03 07:35:00 | SPY | ETF | 184.27 | 184.34 | 184.22 | 184.34 | 107163.0 |
| 2014-03-03 07:40:00 | SPY | ETF | 184.31 | 184.53 | 184.29 | 184.44 | 191952.0 |
| 2014-03-03 07:45:00 | SPY | ETF | 184.47 | 184.65 | 184.47 | 184.59 | 113699.0 |
| 2014-03-03 07:50:00 | SPY | ETF | 184.6 | 184.76 | 184.5 | 184.75 | 108940.0 |
| 2014-03-03 07:55:00 | SPY | ETF | 184.76 | 184.8 | 184.7 | 184.77 | 140026.0 |
| 2014-03-03 08:00:00 | SPY | ETF | 184.76 | 184.95 | 184.21 | 184.84 | 333176.0 |
| 2014-03-03 08:05:00 | SPY | ETF | 184.76 | 184.91 | 184.18 | 184.73 | 419689.0 |
> showing 50 of 47,725 rows — these rows as CSV