PREVIEW / etf_5min / 2015-06-03
file: by_date/etf_5min/2015/2015-06-03.parquet size: 1.1 MB rows: 47,182
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-06-03 04:00:00 | SPY | ETF | 211.64 | 211.8 | 211.64 | 211.79 | 1285.0 |
| 2015-06-03 04:10:00 | SPY | ETF | 211.65 | 211.65 | 211.64 | 211.64 | 1500.0 |
| 2015-06-03 04:15:00 | SPY | ETF | 211.6 | 211.6 | 211.6 | 211.6 | 100.0 |
| 2015-06-03 04:20:00 | SPY | ETF | 211.57 | 211.57 | 211.57 | 211.57 | 500.0 |
| 2015-06-03 04:25:00 | SPY | ETF | 211.66 | 211.66 | 211.66 | 211.66 | 301.0 |
| 2015-06-03 04:30:00 | SPY | ETF | 211.57 | 211.61 | 211.57 | 211.59 | 4700.0 |
| 2015-06-03 04:35:00 | SPY | ETF | 211.56 | 211.56 | 211.46 | 211.46 | 300.0 |
| 2015-06-03 04:45:00 | SPY | ETF | 211.4 | 211.4 | 211.39 | 211.39 | 500.0 |
| 2015-06-03 04:50:00 | SPY | ETF | 211.5 | 211.5 | 211.5 | 211.5 | 1000.0 |
| 2015-06-03 05:00:00 | SPY | ETF | 211.58 | 211.58 | 211.58 | 211.58 | 300.0 |
| 2015-06-03 05:05:00 | SPY | ETF | 211.52 | 211.52 | 211.52 | 211.52 | 100.0 |
| 2015-06-03 05:20:00 | SPY | ETF | 211.57 | 211.57 | 211.57 | 211.57 | 500.0 |
| 2015-06-03 05:25:00 | SPY | ETF | 211.56 | 211.61 | 211.56 | 211.61 | 680.0 |
| 2015-06-03 05:30:00 | SPY | ETF | 211.6 | 211.6 | 211.55 | 211.55 | 1100.0 |
| 2015-06-03 05:35:00 | SPY | ETF | 211.56 | 211.61 | 211.47 | 211.5 | 16620.0 |
| 2015-06-03 05:40:00 | SPY | ETF | 211.53 | 211.53 | 211.53 | 211.53 | 300.0 |
| 2015-06-03 05:45:00 | SPY | ETF | 211.5 | 211.6 | 211.5 | 211.51 | 3780.0 |
| 2015-06-03 05:50:00 | SPY | ETF | 211.58 | 211.58 | 211.58 | 211.58 | 360.0 |
| 2015-06-03 05:55:00 | SPY | ETF | 211.61 | 211.61 | 211.59 | 211.61 | 4080.0 |
| 2015-06-03 06:10:00 | SPY | ETF | 211.66 | 211.66 | 211.63 | 211.63 | 340.0 |
| 2015-06-03 06:15:00 | SPY | ETF | 211.65 | 211.65 | 211.65 | 211.65 | 300.0 |
| 2015-06-03 06:20:00 | SPY | ETF | 211.62 | 211.68 | 211.62 | 211.68 | 3340.0 |
| 2015-06-03 06:25:00 | SPY | ETF | 211.69 | 211.7 | 211.69 | 211.69 | 1080.0 |
| 2015-06-03 06:30:00 | SPY | ETF | 211.7 | 211.73 | 211.69 | 211.73 | 6355.0 |
| 2015-06-03 06:35:00 | SPY | ETF | 211.74 | 211.86 | 211.74 | 211.77 | 3905.0 |
| 2015-06-03 06:40:00 | SPY | ETF | 211.77 | 211.81 | 211.76 | 211.81 | 8700.0 |
| 2015-06-03 06:45:00 | SPY | ETF | 211.83 | 211.88 | 211.83 | 211.85 | 25000.0 |
| 2015-06-03 06:50:00 | SPY | ETF | 211.85 | 211.95 | 211.85 | 211.86 | 12910.0 |
| 2015-06-03 07:00:00 | SPY | ETF | 211.74 | 211.8 | 211.74 | 211.8 | 1600.0 |
| 2015-06-03 07:05:00 | SPY | ETF | 211.88 | 211.9 | 211.84 | 211.84 | 4553.0 |
| 2015-06-03 07:10:00 | SPY | ETF | 211.86 | 211.91 | 211.79 | 211.79 | 52407.0 |
| 2015-06-03 07:15:00 | SPY | ETF | 211.81 | 212.06 | 211.81 | 212.06 | 27413.0 |
| 2015-06-03 07:20:00 | SPY | ETF | 212.04 | 212.18 | 212.03 | 212.12 | 201725.0 |
| 2015-06-03 07:25:00 | SPY | ETF | 212.1 | 212.38 | 212.1 | 212.27 | 103741.0 |
| 2015-06-03 07:30:00 | SPY | ETF | 212.27 | 212.29 | 212.22 | 212.25 | 35408.0 |
| 2015-06-03 07:35:00 | SPY | ETF | 212.24 | 212.24 | 212.17 | 212.23 | 74291.0 |
| 2015-06-03 07:40:00 | SPY | ETF | 212.21 | 212.22 | 212.17 | 212.2 | 41551.0 |
| 2015-06-03 07:45:00 | SPY | ETF | 212.22 | 212.32 | 212.17 | 212.32 | 61301.0 |
| 2015-06-03 07:50:00 | SPY | ETF | 212.32 | 212.56 | 212.32 | 212.46 | 151046.0 |
| 2015-06-03 07:55:00 | SPY | ETF | 212.45 | 212.45 | 212.36 | 212.43 | 56071.0 |
| 2015-06-03 08:00:00 | SPY | ETF | 211.67 | 212.5 | 211.67 | 212.31 | 129319.0 |
| 2015-06-03 08:05:00 | SPY | ETF | 212.31 | 212.34 | 212.24 | 212.25 | 151453.0 |
| 2015-06-03 08:10:00 | SPY | ETF | 212.25 | 212.29 | 212.18 | 212.229 | 39229.0 |
| 2015-06-03 08:15:00 | SPY | ETF | 212.21 | 212.27 | 212.18 | 212.19 | 99366.0 |
| 2015-06-03 08:20:00 | SPY | ETF | 212.19 | 212.24 | 212.13 | 212.22 | 114477.0 |
| 2015-06-03 08:25:00 | SPY | ETF | 212.22 | 212.25 | 212.21 | 212.21 | 30503.0 |
| 2015-06-03 08:30:00 | SPY | ETF | 212.25 | 212.32 | 212.22 | 212.22 | 54175.0 |
| 2015-06-03 08:35:00 | SPY | ETF | 212.23 | 212.25 | 212.18 | 212.22 | 108835.0 |
| 2015-06-03 08:40:00 | SPY | ETF | 212.22 | 212.24 | 212.2 | 212.24 | 21700.0 |
| 2015-06-03 08:45:00 | SPY | ETF | 212.25 | 212.3 | 212.14 | 212.159 | 82773.0 |
> showing 50 of 47,182 rows — these rows as CSV