PREVIEW / etf_5min / 2015-01-16
file: by_date/etf_5min/2015/2015-01-16.parquet size: 1.2 MB rows: 49,783
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-01-16 04:00:00 | SPY | ETF | 198.68 | 198.74 | 198.64 | 198.64 | 2310.0 |
| 2015-01-16 04:05:00 | SPY | ETF | 198.68 | 198.68 | 198.67 | 198.67 | 1400.0 |
| 2015-01-16 04:15:00 | SPY | ETF | 198.56 | 198.58 | 198.31 | 198.42 | 56900.0 |
| 2015-01-16 04:20:00 | SPY | ETF | 198.41 | 198.41 | 198.36 | 198.37 | 10420.0 |
| 2015-01-16 04:25:00 | SPY | ETF | 198.41 | 198.41 | 198.33 | 198.33 | 1580.0 |
| 2015-01-16 04:35:00 | SPY | ETF | 198.11 | 198.18 | 198.11 | 198.18 | 10200.0 |
| 2015-01-16 04:40:00 | SPY | ETF | 197.96 | 197.96 | 197.86 | 197.91 | 12285.0 |
| 2015-01-16 04:45:00 | SPY | ETF | 197.86 | 197.88 | 197.78 | 197.88 | 3500.0 |
| 2015-01-16 04:50:00 | SPY | ETF | 197.98 | 197.98 | 197.93 | 197.93 | 1010.0 |
| 2015-01-16 04:55:00 | SPY | ETF | 198.18 | 198.28 | 198.18 | 198.28 | 910.0 |
| 2015-01-16 05:30:00 | SPY | ETF | 198.26 | 198.56 | 198.26 | 198.48 | 8050.0 |
| 2015-01-16 05:35:00 | SPY | ETF | 198.52 | 198.63 | 198.51 | 198.61 | 9010.0 |
| 2015-01-16 05:40:00 | SPY | ETF | 198.63 | 198.63 | 198.5 | 198.58 | 27900.0 |
| 2015-01-16 05:45:00 | SPY | ETF | 198.5 | 198.53 | 198.3 | 198.53 | 13523.0 |
| 2015-01-16 05:50:00 | SPY | ETF | 198.46 | 198.46 | 198.23 | 198.25 | 82700.0 |
| 2015-01-16 05:55:00 | SPY | ETF | 198.23 | 198.45 | 198.23 | 198.43 | 41500.0 |
| 2015-01-16 06:00:00 | SPY | ETF | 198.35 | 198.52 | 198.35 | 198.48 | 8050.0 |
| 2015-01-16 06:05:00 | SPY | ETF | 198.42 | 198.42 | 198.39 | 198.39 | 4600.0 |
| 2015-01-16 06:10:00 | SPY | ETF | 198.41 | 198.52 | 198.41 | 198.51 | 10900.0 |
| 2015-01-16 06:15:00 | SPY | ETF | 198.49 | 198.62 | 198.49 | 198.61 | 46200.0 |
| 2015-01-16 06:20:00 | SPY | ETF | 198.6 | 198.97 | 198.6 | 198.87 | 60010.0 |
| 2015-01-16 06:25:00 | SPY | ETF | 198.87 | 198.99 | 198.83 | 198.95 | 84942.0 |
| 2015-01-16 06:30:00 | SPY | ETF | 198.89 | 199.18 | 198.89 | 199.17 | 84535.0 |
| 2015-01-16 06:35:00 | SPY | ETF | 199.13 | 199.13 | 198.89 | 198.97 | 4422.0 |
| 2015-01-16 06:40:00 | SPY | ETF | 198.99 | 198.99 | 198.82 | 198.86 | 1020.0 |
| 2015-01-16 06:45:00 | SPY | ETF | 198.85 | 198.93 | 198.85 | 198.93 | 4450.0 |
| 2015-01-16 06:50:00 | SPY | ETF | 198.92 | 199.0 | 198.89 | 198.95 | 6845.0 |
| 2015-01-16 06:55:00 | SPY | ETF | 198.88 | 198.98 | 198.88 | 198.98 | 2300.0 |
| 2015-01-16 07:00:00 | SPY | ETF | 198.94 | 198.98 | 198.63 | 198.67 | 26775.0 |
| 2015-01-16 07:05:00 | SPY | ETF | 198.69 | 198.72 | 198.58 | 198.58 | 20519.0 |
| 2015-01-16 07:10:00 | SPY | ETF | 198.58 | 198.67 | 198.55 | 198.67 | 8975.0 |
| 2015-01-16 07:15:00 | SPY | ETF | 198.64 | 198.65 | 198.44 | 198.5 | 45875.0 |
| 2015-01-16 07:20:00 | SPY | ETF | 198.5 | 198.56 | 198.31 | 198.33 | 33640.0 |
| 2015-01-16 07:25:00 | SPY | ETF | 198.35 | 198.4 | 198.24 | 198.26 | 134910.0 |
| 2015-01-16 07:30:00 | SPY | ETF | 198.25 | 198.31 | 198.18 | 198.31 | 67776.0 |
| 2015-01-16 07:35:00 | SPY | ETF | 198.32 | 198.37 | 198.12 | 198.12 | 223881.0 |
| 2015-01-16 07:40:00 | SPY | ETF | 198.12 | 198.34 | 198.12 | 198.29 | 76381.0 |
| 2015-01-16 07:45:00 | SPY | ETF | 198.31 | 198.31 | 198.18 | 198.23 | 55584.0 |
| 2015-01-16 07:50:00 | SPY | ETF | 198.2 | 198.31 | 198.16 | 198.23 | 50010.0 |
| 2015-01-16 07:55:00 | SPY | ETF | 198.21 | 198.21 | 198.06 | 198.17 | 103522.0 |
| 2015-01-16 08:00:00 | SPY | ETF | 198.22 | 198.64 | 197.15 | 198.25 | 2139381.0 |
| 2015-01-16 08:05:00 | SPY | ETF | 198.27 | 198.335 | 198.2 | 198.23 | 43727.0 |
| 2015-01-16 08:10:00 | SPY | ETF | 198.23 | 198.28 | 198.19 | 198.2 | 30622.0 |
| 2015-01-16 08:15:00 | SPY | ETF | 198.2 | 198.3 | 198.2 | 198.27 | 36002.0 |
| 2015-01-16 08:20:00 | SPY | ETF | 198.28 | 198.32 | 198.24 | 198.25 | 55190.0 |
| 2015-01-16 08:25:00 | SPY | ETF | 198.26 | 198.68 | 198.26 | 198.48 | 177595.0 |
| 2015-01-16 08:30:00 | SPY | ETF | 198.47 | 198.98 | 198.27 | 198.72 | 493497.0 |
| 2015-01-16 08:35:00 | SPY | ETF | 198.69 | 198.92 | 198.58 | 198.92 | 477217.0 |
| 2015-01-16 08:40:00 | SPY | ETF | 198.92 | 199.06 | 198.87 | 199.06 | 261499.0 |
| 2015-01-16 08:45:00 | SPY | ETF | 199.04 | 199.21 | 199.0 | 199.01 | 304765.0 |
> showing 50 of 49,783 rows — these rows as CSV