PREVIEW / etf_5min / 2015-09-22
file: by_date/etf_5min/2015/2015-09-22.parquet size: 1.1 MB rows: 48,965
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-22 04:00:00 | SPY | ETF | 195.75 | 195.75 | 195.3 | 195.51 | 8440.0 |
| 2015-09-22 04:05:00 | SPY | ETF | 195.26 | 195.3 | 195.1 | 195.1 | 12507.0 |
| 2015-09-22 04:10:00 | SPY | ETF | 195.0 | 195.16 | 194.95 | 195.16 | 2107.0 |
| 2015-09-22 04:15:00 | SPY | ETF | 195.25 | 195.25 | 195.25 | 195.25 | 500.0 |
| 2015-09-22 04:20:00 | SPY | ETF | 195.24 | 195.24 | 194.78 | 194.78 | 5725.0 |
| 2015-09-22 04:25:00 | SPY | ETF | 194.75 | 194.75 | 194.35 | 194.47 | 4868.0 |
| 2015-09-22 04:30:00 | SPY | ETF | 194.5 | 194.54 | 194.35 | 194.43 | 9625.0 |
| 2015-09-22 04:35:00 | SPY | ETF | 194.44 | 194.56 | 194.44 | 194.49 | 3118.0 |
| 2015-09-22 04:40:00 | SPY | ETF | 194.43 | 194.46 | 194.3 | 194.46 | 32506.0 |
| 2015-09-22 04:45:00 | SPY | ETF | 194.44 | 194.55 | 194.44 | 194.45 | 14350.0 |
| 2015-09-22 04:50:00 | SPY | ETF | 194.51 | 194.51 | 194.18 | 194.24 | 6217.0 |
| 2015-09-22 04:55:00 | SPY | ETF | 194.27 | 194.75 | 194.25 | 194.75 | 14535.0 |
| 2015-09-22 05:00:00 | SPY | ETF | 194.47 | 194.55 | 194.42 | 194.55 | 14000.0 |
| 2015-09-22 05:05:00 | SPY | ETF | 194.6 | 194.6 | 194.39 | 194.39 | 6250.0 |
| 2015-09-22 05:10:00 | SPY | ETF | 194.44 | 194.44 | 194.07 | 194.14 | 19404.0 |
| 2015-09-22 05:15:00 | SPY | ETF | 194.13 | 194.2 | 194.08 | 194.08 | 18513.0 |
| 2015-09-22 05:20:00 | SPY | ETF | 194.14 | 194.22 | 194.03 | 194.22 | 87370.0 |
| 2015-09-22 05:25:00 | SPY | ETF | 194.19 | 194.19 | 193.98 | 194.13 | 6626.0 |
| 2015-09-22 05:30:00 | SPY | ETF | 194.2 | 194.39 | 194.2 | 194.39 | 7662.0 |
| 2015-09-22 05:35:00 | SPY | ETF | 194.33 | 194.48 | 194.3 | 194.42 | 5484.0 |
| 2015-09-22 05:40:00 | SPY | ETF | 194.44 | 194.44 | 194.33 | 194.33 | 13200.0 |
| 2015-09-22 05:45:00 | SPY | ETF | 194.25 | 194.39 | 194.22 | 194.27 | 7370.0 |
| 2015-09-22 05:50:00 | SPY | ETF | 194.25 | 194.3 | 194.1 | 194.1 | 12180.0 |
| 2015-09-22 05:55:00 | SPY | ETF | 194.05 | 194.08 | 193.91 | 194.05 | 12145.0 |
| 2015-09-22 06:00:00 | SPY | ETF | 194.05 | 194.06 | 193.97 | 193.97 | 1653.0 |
| 2015-09-22 06:05:00 | SPY | ETF | 193.96 | 193.99 | 193.85 | 193.95 | 24658.0 |
| 2015-09-22 06:10:00 | SPY | ETF | 193.9 | 194.06 | 193.9 | 193.93 | 6952.0 |
| 2015-09-22 06:15:00 | SPY | ETF | 193.78 | 193.8 | 193.6 | 193.7 | 33255.0 |
| 2015-09-22 06:20:00 | SPY | ETF | 193.73 | 194.1 | 193.73 | 193.95 | 44229.0 |
| 2015-09-22 06:25:00 | SPY | ETF | 193.87 | 193.9 | 193.74 | 193.84 | 11368.0 |
| 2015-09-22 06:30:00 | SPY | ETF | 193.92 | 194.0 | 193.91 | 193.91 | 3733.0 |
| 2015-09-22 06:35:00 | SPY | ETF | 193.92 | 193.98 | 193.85 | 193.85 | 17301.0 |
| 2015-09-22 06:40:00 | SPY | ETF | 193.93 | 194.17 | 193.93 | 194.12 | 6310.0 |
| 2015-09-22 06:45:00 | SPY | ETF | 194.12 | 194.27 | 194.1 | 194.23 | 28500.0 |
| 2015-09-22 06:50:00 | SPY | ETF | 194.23 | 194.32 | 194.17 | 194.17 | 26032.0 |
| 2015-09-22 06:55:00 | SPY | ETF | 194.25 | 194.35 | 194.17 | 194.29 | 8580.0 |
| 2015-09-22 07:00:00 | SPY | ETF | 194.35 | 194.36 | 194.11 | 194.2 | 62165.0 |
| 2015-09-22 07:05:00 | SPY | ETF | 194.2 | 194.3 | 194.06 | 194.1 | 107941.0 |
| 2015-09-22 07:10:00 | SPY | ETF | 194.1 | 194.17 | 194.01 | 194.16 | 33350.0 |
| 2015-09-22 07:15:00 | SPY | ETF | 194.18 | 194.32 | 194.14 | 194.28 | 32820.0 |
| 2015-09-22 07:20:00 | SPY | ETF | 194.25 | 194.26 | 194.16 | 194.2 | 77625.0 |
| 2015-09-22 07:25:00 | SPY | ETF | 194.18 | 194.32 | 194.15 | 194.28 | 57180.0 |
| 2015-09-22 07:30:00 | SPY | ETF | 194.3 | 194.34 | 194.21 | 194.26 | 88267.0 |
| 2015-09-22 07:35:00 | SPY | ETF | 194.18 | 194.19 | 194.05 | 194.08 | 112660.0 |
| 2015-09-22 07:40:00 | SPY | ETF | 194.1 | 194.27 | 194.1 | 194.23 | 198695.0 |
| 2015-09-22 07:45:00 | SPY | ETF | 194.24 | 194.34 | 194.21 | 194.29 | 56128.0 |
| 2015-09-22 07:50:00 | SPY | ETF | 194.3 | 194.4 | 194.28 | 194.37 | 94153.0 |
| 2015-09-22 07:55:00 | SPY | ETF | 194.37 | 194.52 | 194.31 | 194.38 | 144542.0 |
| 2015-09-22 08:00:00 | SPY | ETF | 194.4 | 194.43 | 194.04 | 194.24 | 1325279.0 |
| 2015-09-22 08:05:00 | SPY | ETF | 196.66 | 196.66 | 194.13 | 194.22 | 289697.0 |
> showing 50 of 48,965 rows — these rows as CSV