PREVIEW / etf_5min / 2014-10-23
file: by_date/etf_5min/2014/2014-10-23.parquet size: 1.1 MB rows: 47,129
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-10-23 04:00:00 | SPY | ETF | 193.71 | 194.19 | 193.71 | 194.19 | 16922.0 |
| 2014-10-23 04:05:00 | SPY | ETF | 194.29 | 194.39 | 194.25 | 194.3 | 5125.0 |
| 2014-10-23 04:10:00 | SPY | ETF | 194.32 | 194.32 | 194.21 | 194.28 | 6303.0 |
| 2014-10-23 04:15:00 | SPY | ETF | 194.29 | 194.3 | 194.26 | 194.26 | 12330.0 |
| 2014-10-23 04:20:00 | SPY | ETF | 194.14 | 194.14 | 194.12 | 194.12 | 200.0 |
| 2014-10-23 04:25:00 | SPY | ETF | 194.19 | 194.28 | 194.19 | 194.28 | 3603.0 |
| 2014-10-23 04:30:00 | SPY | ETF | 194.24 | 194.24 | 194.18 | 194.18 | 7000.0 |
| 2014-10-23 04:35:00 | SPY | ETF | 194.12 | 194.19 | 194.1 | 194.19 | 1253.0 |
| 2014-10-23 04:40:00 | SPY | ETF | 194.24 | 194.24 | 194.24 | 194.24 | 6200.0 |
| 2014-10-23 04:50:00 | SPY | ETF | 194.07 | 194.08 | 194.04 | 194.06 | 6400.0 |
| 2014-10-23 05:00:00 | SPY | ETF | 194.02 | 194.02 | 194.0 | 194.02 | 700.0 |
| 2014-10-23 05:05:00 | SPY | ETF | 194.11 | 194.19 | 194.11 | 194.19 | 519.0 |
| 2014-10-23 05:10:00 | SPY | ETF | 194.2 | 194.2 | 194.14 | 194.16 | 3300.0 |
| 2014-10-23 05:15:00 | SPY | ETF | 194.04 | 194.04 | 194.04 | 194.04 | 10300.0 |
| 2014-10-23 05:20:00 | SPY | ETF | 194.06 | 194.11 | 194.01 | 194.11 | 2500.0 |
| 2014-10-23 05:25:00 | SPY | ETF | 194.11 | 194.11 | 194.02 | 194.02 | 4000.0 |
| 2014-10-23 05:30:00 | SPY | ETF | 194.05 | 194.2 | 194.05 | 194.2 | 7774.0 |
| 2014-10-23 05:35:00 | SPY | ETF | 194.18 | 194.19 | 194.18 | 194.19 | 3222.0 |
| 2014-10-23 05:40:00 | SPY | ETF | 194.15 | 194.15 | 194.12 | 194.14 | 4156.0 |
| 2014-10-23 05:45:00 | SPY | ETF | 194.19 | 194.21 | 194.19 | 194.21 | 1035.0 |
| 2014-10-23 05:50:00 | SPY | ETF | 194.09 | 194.1 | 194.09 | 194.1 | 6640.0 |
| 2014-10-23 05:55:00 | SPY | ETF | 194.11 | 194.11 | 194.05 | 194.05 | 1200.0 |
| 2014-10-23 06:00:00 | SPY | ETF | 194.04 | 194.07 | 194.04 | 194.07 | 4000.0 |
| 2014-10-23 06:05:00 | SPY | ETF | 194.07 | 194.09 | 194.07 | 194.07 | 15688.0 |
| 2014-10-23 06:10:00 | SPY | ETF | 194.04 | 194.04 | 194.02 | 194.02 | 6650.0 |
| 2014-10-23 06:15:00 | SPY | ETF | 194.04 | 194.07 | 193.99 | 193.99 | 15551.0 |
| 2014-10-23 06:20:00 | SPY | ETF | 193.97 | 193.98 | 193.92 | 193.95 | 12025.0 |
| 2014-10-23 06:25:00 | SPY | ETF | 193.92 | 193.92 | 193.8 | 193.8 | 6420.0 |
| 2014-10-23 06:30:00 | SPY | ETF | 193.81 | 193.81 | 193.74 | 193.74 | 20660.0 |
| 2014-10-23 06:35:00 | SPY | ETF | 193.76 | 193.76 | 193.59 | 193.59 | 25625.0 |
| 2014-10-23 06:40:00 | SPY | ETF | 193.57 | 193.57 | 193.49 | 193.5 | 59463.0 |
| 2014-10-23 06:45:00 | SPY | ETF | 193.55 | 193.69 | 193.55 | 193.69 | 4000.0 |
| 2014-10-23 06:50:00 | SPY | ETF | 193.69 | 193.69 | 193.56 | 193.56 | 50733.0 |
| 2014-10-23 06:55:00 | SPY | ETF | 193.56 | 193.56 | 193.5 | 193.56 | 27586.0 |
| 2014-10-23 07:00:00 | SPY | ETF | 193.54 | 193.76 | 193.54 | 193.76 | 46722.0 |
| 2014-10-23 07:05:00 | SPY | ETF | 193.76 | 193.9 | 193.73 | 193.84 | 119808.0 |
| 2014-10-23 07:10:00 | SPY | ETF | 193.88 | 193.88 | 193.76 | 193.83 | 13951.0 |
| 2014-10-23 07:15:00 | SPY | ETF | 193.75 | 193.96 | 193.75 | 193.96 | 63140.0 |
| 2014-10-23 07:20:00 | SPY | ETF | 193.97 | 194.01 | 193.96 | 193.98 | 36073.0 |
| 2014-10-23 07:25:00 | SPY | ETF | 193.98 | 194.01 | 193.88 | 193.9 | 13266.0 |
| 2014-10-23 07:30:00 | SPY | ETF | 193.9 | 194.17 | 193.89 | 194.11 | 146218.0 |
| 2014-10-23 07:35:00 | SPY | ETF | 194.13 | 194.13 | 194.05 | 194.07 | 54230.0 |
| 2014-10-23 07:40:00 | SPY | ETF | 194.07 | 194.16 | 194.05 | 194.16 | 45789.0 |
| 2014-10-23 07:45:00 | SPY | ETF | 194.11 | 194.16 | 194.04 | 194.07 | 71120.0 |
| 2014-10-23 07:50:00 | SPY | ETF | 194.05 | 194.25 | 194.05 | 194.18 | 175384.0 |
| 2014-10-23 07:55:00 | SPY | ETF | 194.18 | 194.44 | 194.18 | 194.42 | 131308.0 |
| 2014-10-23 08:00:00 | SPY | ETF | 194.13 | 194.55 | 193.85 | 194.47 | 161117.0 |
| 2014-10-23 08:05:00 | SPY | ETF | 194.46 | 194.7 | 194.46 | 194.6 | 197001.0 |
| 2014-10-23 08:10:00 | SPY | ETF | 194.6 | 194.6 | 193.09 | 194.57 | 238106.0 |
| 2014-10-23 08:15:00 | SPY | ETF | 194.57 | 194.6 | 194.4 | 194.5 | 210862.0 |
> showing 50 of 47,129 rows — these rows as CSV