PREVIEW / etf_5min / 2015-08-27
file: by_date/etf_5min/2015/2015-08-27.parquet size: 1.3 MB rows: 56,875
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-08-27 04:00:00 | SPY | ETF | 196.32 | 196.38 | 196.07 | 196.1 | 31526.0 |
| 2015-08-27 04:05:00 | SPY | ETF | 196.21 | 196.36 | 196.17 | 196.22 | 12250.0 |
| 2015-08-27 04:10:00 | SPY | ETF | 196.18 | 196.21 | 196.08 | 196.21 | 1405.0 |
| 2015-08-27 04:15:00 | SPY | ETF | 196.33 | 196.43 | 196.26 | 196.43 | 5410.0 |
| 2015-08-27 04:20:00 | SPY | ETF | 196.48 | 196.5 | 196.43 | 196.44 | 10360.0 |
| 2015-08-27 04:25:00 | SPY | ETF | 196.47 | 196.58 | 196.41 | 196.58 | 6423.0 |
| 2015-08-27 04:30:00 | SPY | ETF | 196.6 | 196.65 | 196.42 | 196.49 | 1200.0 |
| 2015-08-27 04:35:00 | SPY | ETF | 196.42 | 196.44 | 196.36 | 196.44 | 22690.0 |
| 2015-08-27 04:40:00 | SPY | ETF | 196.44 | 196.52 | 196.42 | 196.48 | 42305.0 |
| 2015-08-27 04:45:00 | SPY | ETF | 196.49 | 196.52 | 196.34 | 196.44 | 69261.0 |
| 2015-08-27 04:50:00 | SPY | ETF | 196.42 | 197.07 | 196.42 | 196.98 | 56598.0 |
| 2015-08-27 04:55:00 | SPY | ETF | 196.95 | 197.11 | 196.94 | 197.11 | 6017.0 |
| 2015-08-27 05:00:00 | SPY | ETF | 197.18 | 197.18 | 196.72 | 196.87 | 36924.0 |
| 2015-08-27 05:05:00 | SPY | ETF | 196.78 | 197.06 | 196.78 | 197.06 | 25906.0 |
| 2015-08-27 05:10:00 | SPY | ETF | 196.94 | 197.05 | 196.77 | 196.82 | 38284.0 |
| 2015-08-27 05:15:00 | SPY | ETF | 196.85 | 197.07 | 196.83 | 196.93 | 20710.0 |
| 2015-08-27 05:20:00 | SPY | ETF | 197.0 | 197.0 | 196.89 | 196.93 | 2452.0 |
| 2015-08-27 05:25:00 | SPY | ETF | 196.97 | 197.0 | 196.72 | 196.86 | 21720.0 |
| 2015-08-27 05:30:00 | SPY | ETF | 196.83 | 196.87 | 196.58 | 196.58 | 5813.0 |
| 2015-08-27 05:35:00 | SPY | ETF | 196.61 | 196.7 | 196.52 | 196.52 | 13227.0 |
| 2015-08-27 05:40:00 | SPY | ETF | 196.46 | 196.66 | 196.46 | 196.66 | 3228.0 |
| 2015-08-27 05:45:00 | SPY | ETF | 196.65 | 196.67 | 196.62 | 196.67 | 4200.0 |
| 2015-08-27 05:50:00 | SPY | ETF | 196.63 | 196.67 | 196.55 | 196.56 | 8173.0 |
| 2015-08-27 05:55:00 | SPY | ETF | 196.56 | 196.7 | 196.53 | 196.63 | 27700.0 |
| 2015-08-27 06:00:00 | SPY | ETF | 196.79 | 196.91 | 196.76 | 196.82 | 12100.0 |
| 2015-08-27 06:05:00 | SPY | ETF | 196.85 | 196.99 | 196.83 | 196.93 | 14000.0 |
| 2015-08-27 06:10:00 | SPY | ETF | 196.97 | 197.07 | 196.88 | 197.0 | 9376.0 |
| 2015-08-27 06:15:00 | SPY | ETF | 196.98 | 196.98 | 196.88 | 196.9 | 9102.0 |
| 2015-08-27 06:20:00 | SPY | ETF | 196.86 | 196.9 | 196.68 | 196.75 | 5025.0 |
| 2015-08-27 06:25:00 | SPY | ETF | 196.72 | 196.73 | 196.68 | 196.7 | 2503.0 |
| 2015-08-27 06:30:00 | SPY | ETF | 196.67 | 196.74 | 196.6 | 196.74 | 13324.0 |
| 2015-08-27 06:35:00 | SPY | ETF | 196.65 | 196.72 | 196.62 | 196.68 | 48555.0 |
| 2015-08-27 06:40:00 | SPY | ETF | 196.84 | 196.84 | 196.7 | 196.75 | 75214.0 |
| 2015-08-27 06:45:00 | SPY | ETF | 196.74 | 196.8 | 196.73 | 196.77 | 32600.0 |
| 2015-08-27 06:50:00 | SPY | ETF | 196.72 | 196.8 | 196.67 | 196.67 | 24210.0 |
| 2015-08-27 06:55:00 | SPY | ETF | 196.61 | 196.68 | 196.42 | 196.42 | 29103.0 |
| 2015-08-27 07:00:00 | SPY | ETF | 196.45 | 196.52 | 196.33 | 196.33 | 115255.0 |
| 2015-08-27 07:05:00 | SPY | ETF | 196.33 | 196.56 | 196.26 | 196.45 | 100520.0 |
| 2015-08-27 07:10:00 | SPY | ETF | 196.5 | 196.53 | 196.4 | 196.41 | 32370.0 |
| 2015-08-27 07:15:00 | SPY | ETF | 196.44 | 196.45 | 196.1 | 196.26 | 78350.0 |
| 2015-08-27 07:20:00 | SPY | ETF | 196.18 | 196.18 | 196.09 | 196.13 | 110017.0 |
| 2015-08-27 07:25:00 | SPY | ETF | 196.12 | 196.38 | 196.0 | 196.32 | 97875.0 |
| 2015-08-27 07:30:00 | SPY | ETF | 196.28 | 196.5 | 196.21 | 196.45 | 156037.0 |
| 2015-08-27 07:35:00 | SPY | ETF | 196.46 | 196.56 | 196.39 | 196.5 | 228810.0 |
| 2015-08-27 07:40:00 | SPY | ETF | 196.43 | 196.47 | 196.33 | 196.39 | 79854.0 |
| 2015-08-27 07:45:00 | SPY | ETF | 196.39 | 196.43 | 196.26 | 196.34 | 29796.0 |
| 2015-08-27 07:50:00 | SPY | ETF | 196.35 | 196.36 | 196.11 | 196.11 | 83011.0 |
| 2015-08-27 07:55:00 | SPY | ETF | 196.13 | 196.14 | 196.04 | 196.04 | 89448.0 |
| 2015-08-27 08:00:00 | SPY | ETF | 196.04 | 196.54 | 195.84 | 195.95 | 367220.0 |
| 2015-08-27 08:05:00 | SPY | ETF | 195.95 | 196.1 | 195.79 | 196.06 | 118515.0 |
> showing 50 of 56,875 rows — these rows as CSV