PREVIEW / etf_5min / 2013-12-17
file: by_date/etf_5min/2013/2013-12-17.parquet size: 960 KB rows: 41,044
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-12-17 04:05:00 | SPY | ETF | 179.11 | 179.11 | 179.02 | 179.02 | 4400.0 |
| 2013-12-17 04:10:00 | SPY | ETF | 179.0 | 179.0 | 179.0 | 179.0 | 2650.0 |
| 2013-12-17 04:15:00 | SPY | ETF | 179.0 | 179.0 | 179.0 | 179.0 | 2850.0 |
| 2013-12-17 04:20:00 | SPY | ETF | 178.97 | 178.98 | 178.97 | 178.97 | 600.0 |
| 2013-12-17 04:25:00 | SPY | ETF | 179.01 | 179.01 | 178.97 | 178.97 | 400.0 |
| 2013-12-17 04:30:00 | SPY | ETF | 178.98 | 178.98 | 178.98 | 178.98 | 129.0 |
| 2013-12-17 04:40:00 | SPY | ETF | 179.01 | 179.01 | 179.01 | 179.01 | 100.0 |
| 2013-12-17 04:45:00 | SPY | ETF | 179.05 | 179.1 | 179.05 | 179.1 | 1300.0 |
| 2013-12-17 04:55:00 | SPY | ETF | 179.1 | 179.1 | 179.1 | 179.1 | 600.0 |
| 2013-12-17 05:00:00 | SPY | ETF | 179.1 | 179.1 | 179.1 | 179.1 | 5000.0 |
| 2013-12-17 05:05:00 | SPY | ETF | 179.1 | 179.1 | 179.1 | 179.1 | 590.0 |
| 2013-12-17 05:10:00 | SPY | ETF | 179.07 | 179.07 | 179.02 | 179.02 | 5200.0 |
| 2013-12-17 05:15:00 | SPY | ETF | 179.07 | 179.1 | 179.05 | 179.07 | 1575.0 |
| 2013-12-17 05:20:00 | SPY | ETF | 179.04 | 179.04 | 179.04 | 179.04 | 169.0 |
| 2013-12-17 05:30:00 | SPY | ETF | 179.05 | 179.07 | 179.05 | 179.07 | 2633.0 |
| 2013-12-17 05:35:00 | SPY | ETF | 179.06 | 179.1 | 179.06 | 179.1 | 337.0 |
| 2013-12-17 05:40:00 | SPY | ETF | 179.09 | 179.16 | 179.09 | 179.16 | 289.0 |
| 2013-12-17 05:55:00 | SPY | ETF | 179.16 | 179.17 | 179.16 | 179.17 | 27500.0 |
| 2013-12-17 06:00:00 | SPY | ETF | 179.17 | 179.17 | 179.15 | 179.16 | 3000.0 |
| 2013-12-17 06:05:00 | SPY | ETF | 179.15 | 179.15 | 179.15 | 179.15 | 500.0 |
| 2013-12-17 06:10:00 | SPY | ETF | 179.13 | 179.13 | 179.13 | 179.13 | 100.0 |
| 2013-12-17 06:15:00 | SPY | ETF | 179.08 | 179.08 | 179.08 | 179.08 | 300.0 |
| 2013-12-17 06:20:00 | SPY | ETF | 179.11 | 179.11 | 179.11 | 179.11 | 200.0 |
| 2013-12-17 06:25:00 | SPY | ETF | 179.11 | 179.11 | 179.11 | 179.11 | 1500.0 |
| 2013-12-17 06:30:00 | SPY | ETF | 179.13 | 179.13 | 179.13 | 179.13 | 900.0 |
| 2013-12-17 06:40:00 | SPY | ETF | 179.14 | 179.14 | 179.12 | 179.13 | 628.0 |
| 2013-12-17 06:45:00 | SPY | ETF | 179.13 | 179.14 | 179.13 | 179.14 | 949.0 |
| 2013-12-17 06:55:00 | SPY | ETF | 179.15 | 179.15 | 179.15 | 179.15 | 700.0 |
| 2013-12-17 07:00:00 | SPY | ETF | 179.15 | 179.21 | 179.15 | 179.2 | 9228.0 |
| 2013-12-17 07:05:00 | SPY | ETF | 179.2 | 179.29 | 179.2 | 179.28 | 8600.0 |
| 2013-12-17 07:10:00 | SPY | ETF | 179.27 | 179.32 | 179.27 | 179.31 | 62420.0 |
| 2013-12-17 07:15:00 | SPY | ETF | 179.3 | 179.37 | 179.3 | 179.37 | 19450.0 |
| 2013-12-17 07:20:00 | SPY | ETF | 179.36 | 179.38 | 179.36 | 179.38 | 12680.0 |
| 2013-12-17 07:25:00 | SPY | ETF | 179.36 | 179.36 | 179.35 | 179.35 | 9300.0 |
| 2013-12-17 07:30:00 | SPY | ETF | 179.33 | 179.33 | 179.25 | 179.25 | 9580.0 |
| 2013-12-17 07:35:00 | SPY | ETF | 179.26 | 179.26 | 179.24 | 179.24 | 2250.0 |
| 2013-12-17 07:40:00 | SPY | ETF | 179.29 | 179.31 | 179.28 | 179.28 | 3400.0 |
| 2013-12-17 07:45:00 | SPY | ETF | 179.28 | 179.34 | 179.28 | 179.34 | 1000.0 |
| 2013-12-17 07:50:00 | SPY | ETF | 179.34 | 179.34 | 179.34 | 179.34 | 1900.0 |
| 2013-12-17 07:55:00 | SPY | ETF | 179.35 | 179.35 | 179.34 | 179.34 | 314.0 |
| 2013-12-17 08:00:00 | SPY | ETF | 179.32 | 179.32 | 179.27 | 179.27 | 1030825.0 |
| 2013-12-17 08:05:00 | SPY | ETF | 179.29 | 179.31 | 179.26 | 179.26 | 7700.0 |
| 2013-12-17 08:10:00 | SPY | ETF | 179.28 | 179.28 | 179.26 | 179.26 | 282.0 |
| 2013-12-17 08:15:00 | SPY | ETF | 179.25 | 179.26 | 179.25 | 179.25 | 2919.0 |
| 2013-12-17 08:20:00 | SPY | ETF | 179.25 | 179.25 | 179.22 | 179.25 | 13818.0 |
| 2013-12-17 08:25:00 | SPY | ETF | 179.27 | 179.33 | 179.25 | 179.28 | 15376.0 |
| 2013-12-17 08:30:00 | SPY | ETF | 179.29 | 179.41 | 179.29 | 179.38 | 341005.0 |
| 2013-12-17 08:35:00 | SPY | ETF | 179.38 | 179.46 | 179.38 | 179.45 | 585532.0 |
| 2013-12-17 08:40:00 | SPY | ETF | 179.43 | 179.44 | 179.43 | 179.44 | 109395.0 |
| 2013-12-17 08:45:00 | SPY | ETF | 179.44 | 179.46 | 179.43 | 179.45 | 154952.0 |
> showing 50 of 41,044 rows — these rows as CSV